What do you mean without going through the console? Do you mean not logging on to the actual server? Or without using SSMS?

You can't run a command without a connection...

That's strange. If DBCC checks out, does the fourth file appear in sys.master_files?

I might call CSS as well.

I would only use this mode if I needed to ensure the database functioned under SQL 2000 rules. No other reason to use this.

Note that I would also test it...

Few choices.

1. Can you rename the table? You could leave it in the db and ignore it. NOTE: I would not recommend this.

2. Call MS CSS, spend the $500 or...

The note from Dev should be correct. However if you are worried, run another full now. If that full backup from 11/26 has issues, you might be stuck.

Extra full backups...

give up.

Prolonging or repeating yourself...

You were, and I've chimed in with Gail.

A second vote for Gail's post. You need to determine the reason the log is growing. If it's replication, then you need to clear that or solve the issues before...

You check the maximum memory that the OS can see. If you don't know how to do that, search for it. It's a basic item to check, and if you...

Good catch, Carla. It was on the main page, but not in the article. I've added it, and I'll miss it as well :(, already have vacation scheduled that weekend...

djackson 22568 (12/6/2011)

---

Vendors still push for "sa" accounts for access and there is little I can do when I am told to implement a system with that poor of a...

sqlnyc (12/6/2011)

---

Steve - I'm not sure where you're located, but here in NYC, some financial institutions implement what is known as a "professional day". In case this is foreign to...

There is a lot more to encryption than creating a Database Master Key and a certificate. You, in general, don't want to encrypt data with a certificate or asymmetrical key...

I agree with Grant. Leave 2GB for the OS, then set the rest for SQL Server. You can also look at what SQL Server lists for the Target SQL Server...

A couple of things. The month of payment, is that a date?

Also, where does the beginning wage come from? Is that supplied by you?

You don't have a SELECT that retrieves...