RE: Killing users before restore
Put a sp_renamedb statement in your kill script to prevent app or user log right back in when you perform the kill action in master db.
2003-07-01
1 reads
cloud computing
RE: Group Policy for MMC
Try having someone edit the group policy from a system where the Snap-In (the SQL Client Tools) have been installed. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-06-30
1 reads
RE: filegroups and performance
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/sqlops6.asp
2003-06-27
RE: eliminating duplicates from stored procedure joins
Thats it guys, Is there no way out that i can get unique values through query.Is there any way if i can get rid of that duplicates through ASP where I am calling this procedure?
2003-06-24
2003-06-24
RE: eliminating duplicates from stored procedure joins
You may be pleased (kind of!) to know that the reason you have had so much trouble is that what you are trying to do is logically impossible. You don't have a fan trap - but you do have a standard chain of three tables. You need to be aware of which table is at […]
2003-06-24
RE: eliminating duplicates from stored procedure joins
Data is duplicated in tblFileNames (Case_no#,reportid,type) Data is duplicated in userviewed (viewid,reportid) Data is not duplicated in Case30 and caseold
2003-06-23
RE: How to upload database to sql server
One way is to script out all the objects using DMO. Another would be to just sto the service, FTP the files directly. Might also look at freeware tools. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-19
RE: How much do you earn?
Droppinbg back a bit, my tax rate is US 35% (my wife works), not sure about the state rate in CO. Hell, I'm not against taxes, they allow me to live in this great coutry. Wouldn't want them above 50%, but can't complain too much about where they are. More and more I think companies […]
2003-06-19
Blogs
DBAs, Organizing Your SQL Scripts in Git
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
Only Capture Extended Events For a Given Time
It’s a great question. Let’s say you want to capture stored procedure completions. But,...
Not Selected for the PASS Data Community Summit 2024
By Steve Jones
I got this in an email about a week ago from the PASS Data...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers