Topics
Started by
Posts
Last post
I have multiple SQL Server 2005 Instances where i run the following SQL every week or so to capture…
2 replies
Below is my query , SELECT ROW_NUMBER() OVER(ORDER BY a.CollegeName) + 1 as SrNo, a.[CollegeId],[Co…
9 replies
Hi, I have a SQLServer 2005 on a client server and it seems that the server has some viruses. I hav…
5 replies
I want to keep a track on database user activity in MSSQL 2005. the script should return the userna…
8 replies
I have gone through a few resources including http://technet.microsoft.com/en-us/library/ms187540.a…
3 replies
!= is it the same is <> what is better to use? Thank you
11 replies
Hello all, I would like to disable log shipping on one of our server temporarily when the Dr server…
15 replies
Hi, How to find root cause of blocking. If SPID 1 is blocking SPID 2,3,4,5,6 then how can I find th…
3 replies
I have a maintenance plan created with the wizard that includes Check Database Integrity as one of …
5 replies
Good morning Everybody. I know that it might be Not a best solution to use cursor....however here i…
10 replies
Hello, I need to instal sql server 2008 on my future production server. Can someone provide me a li…
12 replies
I have SQL 2008 Sp1. There s a table in a database that I cannot drop. There is a schema corruption…
17 replies
What is the best encryption type for backup/Restore? How will you generate the encryption key? Than…
6 replies
Below is the query in my store procedure.. SELECT distinct a.[CollegeId],a.[CollegeName], a.PaidCli…
10 replies
Hi to all. I am moving our SQL instance from physical to virtual (clean install). We will remain at…
2 replies
Viewing 15 topics - 2,836 through 2,850 (of 22,780 total)
You must be logged in to create new topics.