I found this article a while back when I thought of logging deadlocks. I did not go with it as I found the reason for locks was the application.

Hope it...

I tried it and it worked fine.

Have you recently applied a service pack to the server?

Alternatively, the dts package may be corrupt.

Have you tried the same task in...

Glad to have helped in some way.

You need to create a cursor (@curTableName) and bring in each tablename into it using:

SELECT TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

Then inside the cursor:

Select Top 10 * from ''' + @curTableName '''

Run this printing...

If the coulmn is not an identity column, you can write a cursor to populate a new colum incrementing each row by 1. You can then drop the original column...

I am afraid there is not. If you want to keep a history you will need to buy a package that takes care of change control in sql. e.g embarcadero,...

Sorry to butt in, David.

Remember to bind the rule to the column that you want the rule on as well using 'sp_bindrule'. The rule does not apply to all date...

Here's my two penneth.

Make sure that you are getting back the correct amount of records by bringing back a record count.

If it looks OK, it's worth having a look at...

better off doing it through the front end. I.e. the web pages itself.

Private Sub Form_KeyPress(KeyAscii As Integer)

If KeyAscii = vbKeyReturn Then

KeyAscii =...

Thanks again, Nicholas. I completely missed that one. I was looking for something more complicated rather than the obvious.

Thank you to everyone. I now have the job running. It appears that the following must be done to make it work.

1. A drive must be mapped to the file...

I know I am asking for the world, but one other thing.

The code brings back a separate window for each query in QA. I was hoping to bring back the...

Darrell. Did you run the sql server agent against a windows authenticated user or sql server sa. I ran mine under sa and I think that is where the problem...

Thanks Nicholas. You are a star.

I can get rid of my 500 line query now and replace it with 1 line.

I could not find anything on BOL.

I did try to write to the c drive and that failed as well. Maybe the account did not have permissions to write to the c drive on the server....