MSSQLTips

I am very very new to databases and how they are created. I have been tasked with taking an already created SQL and adding it to a server via Remote Desktop Connection. The server is currently running other databases and I don't want to screw anything up. I have downloaded the new SQL database to...

We need to create three user with different rights, 1).User A want full right like read .write and modify ...If user A edit some files ,,no others can't edit or make any changes in that files. 2)User A can read ,write and edit all file except user A's edited file 3) User C can only read permission...

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...

I have a table wherein there are two columns the first column is amount and the second column is percentage. The amount columns has values mentioned in To Column of the following table: From To Percentage 1 50000 1% 50001 100000 2% 100001 150000 3% 150001 200000 4% 200001...

We are facing problem while inserting the new record in MS SQL Server Compact 3.5. The record is not getting inserted. My setup is: (a) Visual Studio 2008. (b) SP1 (c) SQL Server Compact 3.5 (d) Windows Mobile 6 SDK Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable...

Yes.but My Question is - "is there anyway to avoid Rollbacking of inner transactions alone??"

Hi, Do anyone can confirm me, i am little bit confused whether using alias name will improve the performances Or not? In my point of view, it won't do. Because i observed one thing by the CPU time & elapsed time is less, when i did not use alias name in my query. If it's not Helping to improve...

Under MSSQL 2000 I get a deadlock on a transaction. This victim transaction contains one single SELECT statement joining 2 tables using the READPAST hint. I thought this hint will cause the transaction not be blocked on locks. How can it happen that the transaction is part of a deadlock? The query looks...

Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

Hi, MSSQL2000 has such a feature that it detects deadlocks and kills one of the transactions which take part in the deadlock. I would like to turn off this feature (for debugging purposes), i.e. make the server not to terminate these transactions (i.e. block forever). Is there a flag/setting in the DB...