I would check the code that calls the stored-procedure that INSERTs the data and validate that the mod_user parameter is being populated.

Try running Profiler to catch the parameters and that...

Quite honestly never have used it yet

Have you tried to send the columnist a private message or e-mail?

hmm.

Research DTSRunUI and copy paste that string into a SQL job using Command as the language...

Perplexing

When you refer to scheduling the DTS package a 2nd time are you going to the DTS package itself or going to the Management > SQL Server Agent > Jobs? ...

1 of 3 options presents itself

1.  Wait and the process will eventually go away

2.  Stop/Restart SQL service and hope that it goes away

3.  Reboot SQL server and hope the killed\rollback doesn't...

Try something like this

DECLARE @var VARCHAR(15)

SET     @var = 1

SELECT CAST(REPLACE(STR(RTRIM(LTRIM(@var)), 15, 0), ' ', 0) AS VARCHAR(15))

Just ran the code from above and never received the *****ISNULL****

I would however change the code to be IF ISNULL(@sort, 0) = 0 and instead of SELECT @sort = MAX(ID)...

Please see the below link:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=139298

Just did this via QA

ALTER DATABASE testtheory

MODIFY FILE(NAME='testtheory_Log', NEWNAME='testtheory2k_Log')

I would try and re-install the application and then uninstall.  Looks like somehow the file required to uninstall was deleted

research articles here for sql2pdf:

http://www.sqlservercentral.com/columnists/mivica/creatingapdffromastoredprocedure.asp

It is possible but, what is the purpose of the table variable or #table once you are done with it?  How many rows are going to be placed into it?

If...

 please see the below link for response:

http://www.sqlservercentral.com/forums/post.aspx?forumid=54&messageid=139052

please see the below link for response:

http://www.sqlservercentral.com/forums/post.aspx?forumid=54&messageid=139052

 please see the below link for response:

http://www.sqlservercentral.com/forums/post.aspx?forumid=54&messageid=139052