What a contribution. What a link! What's next?

https://msdn.microsoft.com/en-us/library/ms130214.aspx

Everyone else looks at stats table I knew there was a datetime in the indexes system table... Why do I even go out on google anymore. Thanks SSC 😀

My thoughts exactly.

SET ROWCOUNT

This sets your article back to active. :w00t:

I hope you don't mind but I posted this about you on facebook 🙂

"I like this guys code very robust and feature complete....."

Lost and have been chasing this CPU query down for several days THANKS!!!:w00t:

Gila the patient monster

Oh and I would also add that the real reason you make a second log file yes is for space emergencies. But I'm not talking after the fact I'm...

I believe EMPTYFILE is the better idea then truncate in your script .

BOL says the following.

EMPTYFILE

Migrates all data from the specified file to other files in the same filegroup....

I have also read the article and it makes since that at the OS level only one thread can look a file at a time.

There for if you...

Oxygen thank you for the post your code got me 80 % of the way there. I modified your cursor to look for PK in the db that are...

Ali,

I am using SSMS. the query window.

Have a good weekend and a beer on me.

MudLuck out

Blade you the man. Tried to do an ad hoc update which is not allowed without a single mode Séance which can't be done.

I had to change...

The issue wasn't the scripits they work te problem was the authentifiation mode it was set to NT only...

Dumb dumb dumb

Found out what the true problem was I didn't have the authentification mode set to windows auth only.

After that was able to get the passwords to work correctly..

Doh I hate...