Viewing 3 posts - 1 through 3 (of 3 total)
a possible scenario:
for db tables, dump all tables from "updated" db:
SELECT o.name Table_Name, c.name Column_Name, t.name DataType, c.Length, CASE WHEN c.isnullable=1 THEN 'Yes' ELSE ...
June 27, 2008 at 7:40 am
#835343
DBCC SHRINKFILE('yourdb_Log',EMPTYFILE)
April 26, 2006 at 9:49 am
#634360
What about
SELECT RAND( (DATEPART(mm, GETDATE()) * 100000 )
+ (DATEPART(ss, GETDATE()) * 1000 )
+ DATEPART(ms, GETDATE()) )
generate a random number, then use to retrieve data .... ?
September 23, 2004 at 11:59 pm
#524285