Questions tagged by "sql-server"


0
 bounty
1
answers
MsSQL Server: How can I drop DB using T-SQL?
6 years ago • lampego1@qrid
I want to drop my DB and close all connections before it When I try to do it I receive this message: Cannot drop database "DBName" because it is currently in use. Thanks..
0
 bounty
1
answers
MsSQL Server: How can I restore DB using T-SQL
6 years ago • lampego1@qrid
How can I restore DB using T-SQL? I'm working on linux(ubuntu)
0
 bounty
1
answers
MS SQL Server: How can I add new login and grand permissions for DB using T-SQL
6 years ago • lampego1@qrid
I need to be able to establish an ODBC connection through SQL Server authentication. How can I grant permissions for an user with ALL rights on DB? Please help :)
Tags: ,
0
 bounty
1
answers
.Net - Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM
10 years ago • lampego1@qrid
I am creating an object in C#, populating it with some data and then trying to save it into SQL Server table: User someUser = new User() { UserName = "TestUser", CreateDate = DateTime.MinValue }; I am getting the following error from MS SQL Server: > Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM Please help! Thanks!
0
 bounty
1
answers
Cannot drop an index that is being used for PK constraint enforcement (MS SQL Server 2008)
10 years ago • lampego1@qrid
I am trying to execute the following SQL command: DROP INDEX pk_name_PK ON [dbo].[TableName]; I am getting the following error: It is being used for PRIMARY KEY constraint enforcement. Please help! Thanks!
1 from 5