If it won't stop from services, reboot. You might set it not to auto start first, and then start it in minimal configuration from the command line.

It does, Bob, it does

Lynn,

You can head to Boulder for the weekend. That's a far off (out), exotic (strange) locale. Stop by Celestial Seasonings! :w00t:

Tom,

I haven't been lucky enough to commiserate with you, but you have my sympathies here. Please feel free to vent!

I think part of the issue for XEvents and waitstats is that there isn't much documentation out there on them. MS came up with these features, didn't support them well,...

Not my burgers!

To me the risk is instability in the OLE item, or perhaps a misundertanding of how it can be used by the admin. What if that component is attacked (low...

The same thing applies, in Enterprise Manager, when you create a login, you can create and map it to a user.

Nice link! I learned a few things.

When you create a login in SSMS, you have the chance to create and map a user at the same time.

If the login exists, CREATE USER will help you.

If...

First I'd run a backup ASAP.

Then if you can't lose data,

1) make sure you have full backups scheduled, copy these to a remote machine.

2) schedule log backups every 5-15...

If you install this on your servers, exclude your SQL Server data files, log files, error logs, and backup file folders.

http://www.sqlservercentral.com/articles/sqlserversecuritydealingwithantivirusprograms/1351/

Disconnections that appear random often have to do with drivers. I'd be sure that your drivers and firmware for the cards are up to date.

Permissions are what I would check next, as Roy mentioned. The xp_cmdshell can operate with a proxy account, and be sure it has permissions. AFAIK, there is no timeout for...

Write a SELECT to get the row you want, changing the values if you need to.

For example, to change the date forward for a date in an order table

select dateadd(...