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(...

What's the question?

Chris,

My condolences and our thoughts and prayers are with you and your family.

I don't buy maintenance for lots of software. I don't have it for Word, for Snagit or Camtasia. I didn't get it for my video software.

When we purchased Goldmine...

I think doing your best includes not overdoing it. Know your limitations.