Could you point me toward a good resource for examples of code without using cursors, I have some examples where you load a select statement into a temp table and...

Would any of you use the undocumented SPs sp_MSforeachdb or sp_MSforeachtable to do the iteration for them if the situation suited using these? Anyone know how these work, if...

Poor wording made it into a trick question when it was so simple, I got it wrong by the way in the same way as the above comment.

This was news to me as well but there is a default trace running in SQL 2005, something I knew nothing about, it looks to be invaluable, I wish I...

It won't mention delete in the security log, only users that accessed the server, depending on the set up it might give you a host name or it might just...

Do the users have to go onto a server (RDC etc) to access the databases or do they do it through a client?

Look at the security log in event viewer...

I've found out what causes this error, it's reindexing on a primary XML index.

I ran repair_allow_data_loss on a backup copy of the database and it fixes the consistency error but...

Kerberos aside, what...

Is this for DTS packages that you have put on a SQL 2005 server or SSIS packages?

I'm still having this problem, has anyone got any suggestions?

Thanks

But none relating to the proportional-fill process.

I was more worried that I couldn't find where I had read it but I can't find it on any microsoft KBs so I assume that where ever I read...

I'm sure it was something I read somewhere that you had to do this as well, maybe on this forum, but can't find an article specifically saying that you need...

If you are doing this in SQL 2000 you need to set the trace flag 1118 so the different tempdb files are used evenly but in SQL 2005 you don't...

Jinx 😀