DROP all stored procedures
This code will drop all stored procedures made with splog. With minor modification it will also drop all functions and sp not made with splog.
2009-03-13 (first published: 2009-02-12)
1,007 reads
AutoGenerate
AUTOGENERATE Stored procedures example
This is related to my other autogenerate code. this is just an example of how to use it.
2008-11-21
719 reads
AUTOGENERATE INSERT UPDATE SELECT STATEMENTS
use metadata to generate basic create procedure statements for insert update and select
2008-11-22 (first published: 2008-10-10)
3,808 reads
RE: What makes a good developer?
Hello Tomi, quote: Do you actually say "häh" in Germany? That's cool, we have exactly the same word here in Finland. yes we do, although it is considered rather slang. Cheers, Frank
2003-06-11
RE: Using variables within IN
Hello demos, quote: SELECT * FROM TableA WHERE ColumnB IN (@SomeVariable) and the variable can be = 1 or = 1,2,3 etc SELECT * FROM tablea WHERE ColumnB BETWEEN lower_bound and upper_bound Cheers, Frank
2003-06-11
1 reads
RE: Server slow down after stopping replication
One thing we found was that the disk that the data files are on is extremely fragmented (data area - > 90%, free space - 5%) Can this cause the problems with accessing the #tables? We didnt' notice any slow down accessing regular table, only #tables.
2003-06-06
RE: DELETE DUPLICATE ROWS
Thanks Jay it worked with the double FROM WTRDET statement. Its strange though while i was testing SQL with the same SELECT * query it gave me an error. But worked fine with the DELETE STATEMENT. Thanks once again for your time and help.
2003-06-05
RE: SQL Server Mag User Study
Hi Crispin, quote: Just completed it. Not sure what I got myself into. Maybe now I will be getting emails asking if I am lonely... Short survery and useless if you ask me. I already receive those mails asking if I wanna be friend to ???. Short surveys I like best. I only did this […]
2003-06-04
1 reads
RE: copy DTS jobs between servers
Here is an easier procedure I found in technet: Step 5: How to Move DTS Packages Step 5 is optional. If DTS packages are stored on the source server in the SQL Server or the repository, you can move them if you want. To move DTS packages between servers: Save the DTS package on the […]
2003-06-03
1 reads
Blogs
Undercover Catalogue 0.4.5 Released – Database Module Bug Fix
Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in...
Saving Emergency Space on my Laptop
By Steve Jones
With my new laptop, one of the things I realized I’d forgotten to do...
T-SQL Tuesday #178–A Recent Technical Problem
By Steve Jones
This month we have a good invitation from Deepthi Goguri, where she asks us...
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