2012-03-30
495 reads
2012-03-30
495 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)
806 reads
2009-04-10
3,964 reads
SQL 2000 SP4 failure on Cluster with error:Setup failed to perform required operations on the cluster nodes
2009-03-04
3,363 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
1,013 reads
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
2008-07-18
8,194 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,165 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,251 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers