If not search for "forcibly shrink" here for a script that can help.

you should rarely shrink anything. Usually this is because something hasn't been done correctly in the past or...

Whoops and thanks for the link, William.

I think that this can be a good solution for smaller companies. If you can't afford high bandwidth or distributed servers, this is one...

never heard of that. For whatever reason my wife has the tubes, but I'll mention the powder. That sounds more fun than putting on a halter and sticking my fingers...

Check and be sure the XP firewall isn't preventing connections.

Please don't cross post. This is answer here: http://www.sqlservercentral.com/Forums/Topic469971-146-1.aspx

There's no way to go back and get this. A log reader might help if you really need one. Check out ApexSQL for a tool to help if you need...

You probably need to change all Windows logins in the server. If the name of the Windows host did not change, then SQL itself should be ok.

I would always run this regularly. If you can run it before every backup, do that and page out errors. As mentioned, if there are problems, then your backup might...

We are working with Instant Forums to incorporate some of these ideas into their next version.

I had a rough job with a new manager at one point. He was a "failed projects" guy brought in to try and get us to finish a large project...

I'd also look at why it's suspect. check the error log for clues. Often this is something simple, like a moved LDF file or permissions.

Wow, I drop off for a couple days and the thread goes crazy!

I'll add in a few more job stories here, though don't be surprised if any make them into...

I believe for SAs it runs as the SQL Server Agent account.

There is no best book. Most of them have almost all the same information. I'll recommend Brian Knight's SSIS books because he's a friend and they're well written.

Hillary Cotter has...

I'd typically add a column to the source that loads with a "loaded" value. That way you know what's been sent in. Then you could update xx records with a...