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.

Not everyone has been using SQL Server for more than one...

Never read that one, only his Sci-Fi.

A backup of the database does not affect the log file. You need to schedule a log backup separately.

You need to know what files are "changing" size, not which is...

Write the query as you would if they were two tables in the same database and fully qualify both tables.

So include the database name and owner with the table. As...

You need to better explain what happened and what you are doing.

What do you mean by user data in master? What did you do to put it there? And in...