Server and PC have no meaning. They're both computers. The install differentiates between which version of the operating system you have. Some SQL Server versions will only install on a...

You can't do this directly. The FROM clause requires resolution at compile time, so it can't take a variable.

You can run something like this:

declare @cmd varchar(200)

,...

I think you're confused, or at least one of us is. Your code only contains a single value, but you're muddying the issues here.

You have 3 columns, a month, and...

I think Grant has given a good explanation of why #2 works. It's easier for the next person (developer or user) to understand as well. It makes client development slightly...

Interesting idea, Bryant, of a shifting or sliding warehouse.

From what I understand, which might be little, is that the warehouse should be the central source where you've consolidated the...

Typically you run defragment on only certain databases, like user databases, so you'd want to run a loop or use a list. That way you aren't messing with system databases.

I'd...

The PIX won't pass 1433 by default.

You'll usually find people split on this issue. I tend to agree with Jeff, but lots of people like having the images/BLOBs in SQL Server. Everything is then in once...

Ah, that stinks. Perhaps you can uninstall the SQL Native Client only? Not sure if that's separate with Express.

Which article?

I see at least one that's broken and I'll have someone look at it tomorrow.

Steve

I agree with Lowell. Don't update the system tables. Especially in this case. These are two simple procs to run to fix this.

I have almost always used R5 for servers, however I've usually been on a budget. Many smaller companies, gov't, etc. struggled with the cost of disk. Usually when we get...

An Event Notification should fire when a role is modified, either sp_addrole or ALTER ROLE.

I'll try to test this tomorrow, but that might help you to trap who it is.

I thought the Profiler bugs were fixed in 2005 regarding objects.

A trigger, however, is a good way to try and capture what's going on. At least audit who/when this happens.

Be sure that you consider your application. Automatic failover with mirroring requires you to use the new SQL Native Client, not older OLEDB/ADO technologies. This can be an issue.

If you...