Can you post BCP format file?

When you drop the database sql will also drop the associated file in most of the time...

You can make use xp_fileexist procedure to check file existence...

I believe you are using sp_delete_job job in step to delete "report queue" job in step2.

Does user who is executing the another procedure to run report queue job has the...

I never did like this...

But you can use FOR XML cluase to save the data in xml format...

I am purging the data from highly OLTP tables... some of my tables are accessed and inserted and updated by users all the time...

I use the following method...

1. Created the...

Main issue with your maintenance plan is Reorganize pages will Cause the indexes on the tables in the database to be dropped and re-created with the original FILLFACTOR that was...

Your script should work without any problem but....

You are trying to rename .ldf file which is data base log file... if I am not mistaken...

You can rename the file while...

There is no option to hide few dts packages from one user and the few from other...

You can hide everything or not...

Execute permissions can be granted in a different way...

Open the transformation task (the black arrow) properties. 

On the last tab (Options) ...

Check the "use fast load" checkbox. 

UnCheck the "Check Constrainst" checkbox.

Check the "Enable Identity Insert" check box...

I believe you should use "ORDER BY NEWID() " in inner query to get the unique rows ...not the outer query to get the unique rows...

I don't think there any solution to resolve torn page error other than restoring the db from previous good backup.

OR

Put the db in engency mode and take the data out...

I don't think it is possible.

Does Login used in VB to execute the procedure has the procedure execute permissions?

1. While executing the procedure through VB, run sql trace to with ERRORS and BATCH STARTING and BATCH COMPLETED...

Try this..

SELECT  JokeID,

JokeCatID,

JokeTitle,

JokeDesc,

UserID

from (

SELECT DISTINCT top 5 JokeID,

JokeCatID,

JokeTitle,

JokeDesc,

UserID,

newid()

FROM jokes

WHERE JokeCatID = SomeNumber

ORDER BY NEWID()

) a

order by JokeID

For high OLTP server profiler may cause performance issues when you are auding all calls, So As Steve advised use SQL trace using the procedures... and save the trace data...