Find all Procedures, Views, Functions that have been renamed
Find all Procedures, Views, Functions that have been renamed with sp_rename where syscomments does not match.
2009-08-17 (first published: 2009-08-06)
817 reads
Find all Procedures, Views, Functions that have been renamed with sp_rename where syscomments does not match.
2009-08-17 (first published: 2009-08-06)
817 reads
Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.
2009-08-14 (first published: 2009-08-04)
2,373 reads
If you would like to send email from SQL Server, use this CDO method and store proceudre.
2009-08-13 (first published: 2009-07-29)
3,456 reads
This script automatically generates stored procedures for insert, update and delete operations on the given table
2009-08-12 (first published: 2009-07-23)
2,097 reads
This script is basically used in SQL Server 2005/2008 as that version not having the option to perform the same activity in the single window.
2009-08-11 (first published: 2009-07-23)
1,609 reads
In a scenario where we need to find out all the objects of a LINKED Server and check which object is accessible to us,
we need to write following query:
2009-08-07 (first published: 2009-07-20)
669 reads
Quick way to get all users on all Databases
2009-08-05 (first published: 2008-06-06)
1,658 reads
Generates a dataset for determining when subscriptions fail to send e-mail or post reports to file shares.
2009-08-05 (first published: 2008-11-19)
1,202 reads
This Script can be used for searching a column in SQL server 2005
2009-08-05 (first published: 2009-07-18)
985 reads
This Script can be used for searching a Table in SQL server 2005
2009-08-04 (first published: 2009-07-18)
1,068 reads
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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