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)
576 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
491 reads
By Steve Jones
Today’s coping tip is to notice what you are feeling without any judgment. Today...
By Arun Sirpal
Whatever your database background is you will have heard of an execution / explain...
By Steve Jones
Today’s coping tip is to ask a trusted friend to tell you what strengths...
Hi, We have a database. We received the alert Could not allocate new page...
Hi, We have Always on Server with one primary & 1 secondary ( Not...
Ask SSC