2012-03-30
480 reads
2012-03-30
480 reads
2009-07-20
2,708 reads
a stored procedure returning a single varchar(8000) of the CREATE TABLE script for any table.It does everything calculated columns, rules,indexes,defaults,triggers,constraints...everything.
2009-07-28 (first published: 2009-07-11)
795 reads
2009-04-10
3,963 reads
SQL 2000 SP4 failure on Cluster with error:Setup failed to perform required operations on the cluster nodes
2009-03-04
3,317 reads
This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.
2008-12-30 (first published: 2008-12-05)
1,020 reads
This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL
2008-08-09
977 reads
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
2008-07-18
8,145 reads
Continuing with his series on Alias Data Types in SQL Server 2000, Yakov Shmalfman brings us part 5, looking at indexes.
2008-04-17
1,164 reads
Script one or all roles in a database. Includes users, obect permissions and column permissions.
2011-09-08 (first published: 2008-01-08)
5,250 reads
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Comments posted to this topic are about the item Running a Service
Comments posted to this topic are about the item Creating Two Keys
Comments posted to this topic are about the item Stairway to DAX and Power...