Have you ever wanted to run a query across every database on a server with the convenience of a stored procedure? If so, Microsoft provided a stored procedure to do so. It’s unreliable, outdated, and somewhat obfuscated, though. Let’s improve on it!
2016-04-15 (first published: 2014-12-01)
15,443 reads
You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.
2008-08-11
966 reads
2004-05-25
Detaching just cleans up sysdatabases and sysfiles. Nothing at all wrong with stopping the server, copying the files to a different server and attaching. Doesn't affect anything. You'd use detach to avoid stopping the service on the original server. If you need a copy without stopping the server OR losing access, then you have to […]
2003-05-29
1 reads
I am doing it in EM and this is the only log backup and I have SP3 for mai SQL2000. So should I do this in query analyzer?
2003-05-28
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers