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

I'd use something like Lowell has to generate a script. Be sure it's hitting the tables that you really need. Last thing you want to do is update something you...

You should be able to install components with Express there. Are you getting an error?

Nice one, Peter.

The extension doesn't matter to SQL Server. Usually .bak is used for organizational purposes, but it can be anything.

It's probably faster. Haven't done enough testing to know, but they usually tweak the process with each version to run a bit smoother.

Some better options with filegroup backup / restore,...

Sorry, being an ID-10-T here today. Or for sure today, possibly other days as well 🙂

Save as a VB file (.bas). You should be able to open in notepad and...

You'd have to include a SET for every column

update xx

set colA = null

where colA = ''

update xx

set colB = null

where colB = ''

etc.

You could...

Dan,

If you can get the funds, I'd call PSS. Sounds like something is very strange on your system.

No idea, but I had issues on my workstation as well.

I removed the directories, the SQL reg keys, and deleted the SQLSTP.log (?) in the Windows folder. Then I re-downloaded...

You have until Jan 30, so go quickly!