Yeah, you have to restore logs onto a DB in either norecovery mode or in standby mode, and the only way you get that condition is to restore at minimum...

Check database properties to see if autoshrink is enabled.

Not to mention that even if you index a very large table with a nonclustered index, if you omit a clustered index from that table, the nonclustered index may not...

Ah, but the original question as phrased seemed to ask "Would changing a password change the service startup from automatic to manual?" The answer to that is "No, it...

May be a silly question, but did you update the password on the service account when you changed it in Windows? Check the event log to see if the...

If the backup file is in a location on the network available to both servers, you could do what we do for month end jobs -- add a step to...

The problem you are having is that the start job feature is asynchronous, in other words, all it does is start the job. It doesn't wait for it to...

Have you verified connectivity on the network, and that the name you are using is the actual machine by IP you want? You should do some PINGing I think...

Johnny -- does that XP support getting event logs from live servers? That's what he probably is doing. Log Parser lets you run a query against, say, an...

He's trying to scrape logs from other servers most likely. I did that with this app using my SA privs at my last job to make a lightweight error...

Do a books online search for BULK INSERT or BCP. They are exactly what you are looking for. You'll need a formatfile to describe the structure of the...

A little late to suggest this now, since the damage is done, but your company should work to make the development environment mirror the production environment, and require developers to...

No company I have ever worked with would support a non-DBA group getting permanent DBO access to a production database. Changes should be tested and approved and then migrated...

Backups always work if they complete successfully and have a valid header. Once upon a job the other DBA deleted 50,000 records by mistake. Many of them were...

The optimizer won't grab a field if it doesn't have to. If you use, for instance, a covering index, it won't even hit the main table at all but...