Script Table Data to Insert Statements - Handles Unicode datatypes (nchar, nvarchar, ntext). This script works with SQL 2000 and has been improved to handle properly the nchar, nvarchar, and ntext data types for Unicode, as well as handle apostrophes in data correctly. Usage is to run the script to create the stored proc in […]
2006-01-24 (first published: 2006-01-11)
571 reads
This is a script you can run on a per-server basis, from any database in Query Analyzer or incorporate into a stored procedure, that will examine all databases on that instance of SQL and show what Maintenance Plan(s) they are part of, if any. Shows clearly any databases that are not currently part of a […]
2004-10-01
484 reads
By Steve Jones
It’s just a couple weeks until the SQL in the City Summit comes back...
By Gethyn Ellis
Certified Microsoft Azure Fundamentals - AZ-900 1 day Web based Course - 12th December 2019 Its...
By Will Assaf
Thanks to the 56 of you who joined and actively answered my nerdy sample...
Hi all, I'm just doing some work on my own bank statements imported from...
Hi, As part of development task I have to write a SQL logic for...
Hi, I have a T4 script which reads extended properties. The value of...
Ask SSC