• SQL Server login problems

    I am using Access as a front end to SQL Server 2014 backend database using DSN-less connections to tables and for pass-thru queries. All works fine. I have recently created a second database within the same instance of SQL Server, and believe I have set log in credentials the same for both, but am...

    DataSense45 pointsBadges:
  • Best 3rd party monitoring software for SQL?

    What's the best 3rd party monitoring software for SQL?

    Fran5 pointsBadges:
  • SQL Server: Update a table using SELECT

    I understand that in SQL Server, it's actually possible to insert into a table using the SELECT statement. But would it be possible to actually update via SELECT? We have a table that contains values and we need to update another table with those exact same values. Thanks.

    ITKE434,705 pointsBadges:
  • joining what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    Muktioracle50 pointsBadges:
  • Select 1 + 1 from tablename in SQL Server

    What will the above query return?

    shainan15 pointsBadges:
  • Connect database from Oracle to VB 6.0 in SQL Server

    I'm a BCA student. I'm doing my project on college management system with VB 6.0. I want to know how to connect a database from Oracle to VB 6.0 in a SQL Server. Thanks!

    eliza72472fathima5 pointsBadges:
  • How to get local time of a SQL server?

    Hwo to get local time of a SQL server and store it in a variable of a client program written in C#?

    Edchu5 pointsBadges:
  • SQL Server password issues

    How can I access a SQL Server without a password, how can I change a SQL Server password, and what is an SA on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Select columns with columnized ntext data

    I have a table with 20 columns, where column 2 is an ntext, and it contains 133 comma separated 'fields'. How do I read the 19 columns and include in the output, the 133 columns from the ntext column.

    PeterGrierson45 pointsBadges:
  • Schedule backups on regular intervals in Azure Backup

    I have SQL Server on premises, data is about 20GB. I want to scheduled backups on regular intervals in Azure Backup. Would like to how it works?

    mmreddykiran5 pointsBadges:
  • INSERT or CREATE record in SQL Server database

    I have this SQL Server table structure: MyTable(KEY, datafield1, datafield2...) And now I have to update an existing record / create a new one if it doesn't appear. What's the best way to do that?

    ITKE434,705 pointsBadges:
  • Ignores my new column-store index in SQL Server 2014

    I am using SQL Server 2014. I had an existing table with lots of indexes. I added a non clustered column-store index as a test. When I run test queries it ignores my new column-store index. I don’t know Why? Should I remove the old indexes, leaving just the column store?

    danieljones2,800 pointsBadges:
  • SQL Server – SSIS

    what is SSIs in Sql Server?

    90497265505 pointsBadges:
  • Difference between nvarchar(max) and NText

    Now, I'm a beginner using SQL Server and I'm looking to learn more about the advantages / disadvantages between "nvarchar(max)" and "NText" data types. Now, I don't need to know backward compatibility so I already know that "nvarchar(max)" isn't supported by previous SQL Server releases.

    ITKE434,705 pointsBadges:
  • How am I blocking connections to SQL Server 2008?

    This is a fairly specific issue, but I'm at a loss for reasons to what might be happening. We have SQL Server 2008 running on what we'll call ServerA. We can RDP in ServerA, we can ping ServerA. If we RDP into ServerA, we can open up SQL Server Management Studio and connect to all of the database...

    edwinjhoffer3,355 pointsBadges:
  • Recovering a truncated table on a SQL Server

    How can I recover a truncated table on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Grant permissions to user for backup/restore in SQL Server

    Can anyone tell me what permissions must I give to a user inside SQL Server 2005 so that this user can backup and restore a database without given him sysadmin server role?

    edwinjhoffer3,355 pointsBadges:
  • Problem with SQL Server Database File(.mdf)

    I am using SQL Server 2008 R2 and I want to check my master database file (.mdf) but failed to open it.

    edwinjhoffer3,355 pointsBadges:
  • How to disable SQL Server Management Studio for a user

    Is there a way to prevent users from getting into SQL Server Management Studio so that they can't just edit table rows manually? They still need to access the tables by running my application.

    edwinjhoffer3,355 pointsBadges:
  • Report having more than 240 columns in SSRS 2005

    Hi folks, I am using SSRS 2005 BI. As per MSDN standards SSRS 2005 will not support more than 240 columns in excel (while exporting, will get error). Now I am having more than 240 columns though I am using SSRS 2005, I am not getting any errors. However there is an error here: Reporting Services...

    BhakthaprahladaReddy2,030 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following