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)
822 reads
Problem: We are replaceing our exchange server with a new one all DBMAILs on all server use the old one
2009-07-27 (first published: 2009-07-08)
509 reads
2009-07-23 (first published: 2009-07-13)
1,406 reads
How to create and configure Sybase linked server in SQL Server 2005
2009-07-21 (first published: 2009-07-09)
672 reads
Quick Method to find Configured???????????????????????? Authentication Mode
2009-07-20 (first published: 2009-07-07)
901 reads
Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.
2009-07-20 (first published: 2009-07-03)
1,321 reads
2009-07-17 (first published: 2009-07-08)
919 reads
1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot
2009-07-13 (first published: 2009-07-03)
2,473 reads
returns CREATE TABLE script for any table. including schema name,calculated columns,
indexes with INCLUDE,rules,defaults,triggers,constraints,extended properties...everything.
2009-07-11
1,794 reads
The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL Server keeping the relational integrity intact, even when new primary keys are generated.
2009-07-08 (first published: 2009-06-22)
1,565 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
I have a couple of SQL Agent job steps which run PowerShell commands of...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers