Viewing 3 posts - 1 through 3 (of 3 total)
I think this will work.
DECLARE @MaxRows NVARCHAR(300)
DECLARE @sql NVARCHAR(300)
SET @MaxRows = 20
set @sql = 'select top ' + @MaxRows + '* from SomeTable'
EXEC sp_executesql @sql
February 20, 2007 at 1:58 am
#690590
may be i am not sure but are u removing the replication before the attach
November 7, 2006 at 9:39 pm
#670460
Export it as csv, will be more readable and ur manager will see it like a txt file
October 17, 2006 at 11:43 pm
#666400