Mel and his team have been busy on a couple things and we made some changes to other areas this week. I'll ask him to have another look at this...

Please start a new thread if you have a question. You might try running update statistics manually first to be sure it will run.

Matt Whitfield (9/15/2009)

---

I would put money on the fact that when you used SET ROWCOUNT one of the two following possibilities was true:

1) There was no where clause on the...

George, no problem and thanks for the clarification. They renamed the modes once, so you'll find some white papers and documentation referring to things differently.

You want synchronous mode, to be...

Don't stick multiple users in the same column. You're slowing down access.

Instead you'd typically have another table that links the user with the notification. As in

create table notification( noteID int...

Any more details? error? What is the alias? Where is it set?

The answer is yes, you can. Add a step to do this with a T-SQL command.

Note that if you find an answer, it's good etiquette to post it.

The linked server should determine how the connection is made, or possibly defaults in the control panel for that account. If you hadn't changed anything, however, I'd expect they would...

A log backup does a truncate in that all records that were backed up are marked as free, and that space can be re-used. Your log is a bucket that...

You are missing some information here.

When do you execute the application role? You need to run a stored proc to invoke this. I believe that the temp table will not...

Also note that if you have clients using the SNAC client or a recent ADO.NET driver, you can add both servers in the connection string. Then when you stop...

I've only seen this with corruption. However in DR situations you have to restore master, which can be a nice challenge if you're not used to it.

Some of the third party backup tools (litespeed from Quest, SQL Backup from Red Gate) will restore an object from a backup.

If you want to do it yourself, let me...

What are you trying to accomplish? When you shell out, you aren't using your login, you're using a service account (or proxy) login. running explorer.exe won't get you anything.

Microsoft included tablediff in the product, however this isn't necessarily a trivial task. It takes some time and effort to get it working right.

I work for Red Gate, but I'd...