In the code that I had posted above, the quotes were two single quotes rather than the double quote :

declare @db_name nvarchar(30), @cmd nvarchar(200)

set @db_name = N'pubs'

set @cmd = N'SELECT...

Sorry - instead of "-n", use "-c"...

drop table emp

create table emp (eno int identity(1,1), ename varchar(10))

insert into emp (ename) values ('X')

insert into emp (ename) values ('Y')

insert into emp (ename) values...

It will insert all the records that you get for a given query.

SELECT  (CASE WHEN OBJECTPROPERTY(CONSTID, 'CNSTISDISABLED') = 0 THEN 'ENABLED' ELSE 'DISABLED' END) AS STATUS,        

OBJECT_NAME(CONSTID) AS CONSTRAINT_NAME,       

OBJECT_NAME(FKEYID) AS TABLE_NAME,        

COL_NAME(FKEYID, FKEY) AS COLUMN_NAME,       

OBJECT_NAME(RKEYID) AS REFERENCED_TABLE_NAME,       

COL_NAME(RKEYID, RKEY) AS...

1) Using DTS, you will modify the value of the global variable per execution.

So the pseudo logic would look like this:

a) Get the total count for the number of iterations...

Don't know why you would want to do that but Yes, it is possible. 

Couple of ways:

1) Use DTS and make use of global variables and come up with a...

declare @db_name nvarchar(30), @cmd nvarchar(200)

set @db_name = N'MY_DB'

set @cmd = N'SELECT TABLE_NAME, COLUMN_NAME FROM '+@DB_NAME+'.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME <> ''dtproperties'' order by table_name, column_name'

exec sp_executesql @cmd

Which trace flags did you enable ?  Did you enable, 1204, 1205 and 3605 ?  If so, it would write the deadlock trace information to the error log for that...

Please do not cross-post...see the solution on:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=233769#bm233777

You can use a temp table or a table variable to get the running number.  The default value of L can be obtained by just having a static string.  Then,...

Well, that depends...using an INT is the right thing but besides that -

There are two things to consider in this respect:

1) NUMERIC(9,0) will take up 5 bytes and INT...

That is just a display issue from the GUI part of the profiler or seeing it via Query Analyzer which imposes the restriction of 8192. 

The TextData column in Profiler...

Yes, you can. Look into global variable usage in DTS packages. You can pass in the user-name and then create file based on username and timestamp.

And you cannot have any other filter criteria in this query besides the url filter criteria ?  Can't you restrict based on another filter criteria that is on an indexed...

That depends upon what the DTS package does - if it is say copying over data from one database table to another and two users execute it, you can run...