The problem you have here is that the inner query is not linked back to the outer query.

When you are saying "WHERE NOT EXISTS (...)" all that matters is that...

Also for performance reasons I suggest only storing the documents in a table (and only document data) and its related information in a separate table as a One-To-One relationship. Maybe...

I remember the first SQL training I did (outside of Uni) when I started work - the trainer said one thing that I rememebered - "If you're going to get...

Hungarian Notition is great for apps but not databases. You change one field and then you have to change 15 stored procedures, 13 views, 3 triggers, etc all because...

Luigi said you the first query was missing a FROM clause.

Also  I don't believe you can use aliases in the initial UPDATE clause and you don't need it in the SET clause...

If your using SQL Server 2000 you could try using Declared tables instead of temp tables to improve performance - note that I dont think you can pass these between...

I thought the syntax was not:

SELECT a.*

FROM OPENROWSET('IBMDADB2','xxx.xxx.xxx.xx,50000';'myuserid';'mypassword',

'SELECT * FROM mycatalog.mySchema.T_LastNames') AS a

but more along the lines of:

SELECT a.*

FROM OPENROWSET(

                'IBMDADB2',

                'address=xxx.xxx.xxx.xx,50000;uid=myuserid;pwd=mypassword',

                'SELECT * FROM mycatalog.mySchema.T_LastNames'

               ) AS...

Thanks,

I'll have a look at DBCC as well. Some of the sites are pretty big and do require optimizations. Note that these will only be run once a week.

As for...

Thanks for that information.

I don't think I made clear that when the Transaction Log was huge it was after not only the optimizations, integrity checks but also a full complete...

Thanks for that. I tried running the script but the log did not grow and no data was dumped. When I removed the lines

BACKUP LOG  northwinds  WITH  TRUNCATE_ONLY

DBCC SHRINKFILE (northwinds_Log,truncateonly)

it...

I'm an idiot - as a first timer I didn't release this was administration for Notification services.

I'll be moving my question to Backup -> Admin