Viewing 15 posts - 31,021 through 31,035 (of 39,754 total)
I agree with Lowell. Don't update the system tables. Especially in this case. These are two simple procs to run to fix this.
October 8, 2007 at 10:07 pm
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...
October 8, 2007 at 10:04 pm
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.
October 8, 2007 at 10:00 pm
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.
October 8, 2007 at 9:53 pm
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...
October 8, 2007 at 5:24 pm
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...
October 8, 2007 at 5:22 pm
You should be able to install components with Express there. Are you getting an error?
October 8, 2007 at 5:21 pm
The extension doesn't matter to SQL Server. Usually .bak is used for organizational purposes, but it can be anything.
October 8, 2007 at 3:47 pm
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,...
October 8, 2007 at 3:34 pm
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...
October 8, 2007 at 3:02 pm
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...
October 8, 2007 at 2:59 pm
Dan,
If you can get the funds, I'd call PSS. Sounds like something is very strange on your system.
October 8, 2007 at 2:47 pm
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...
October 8, 2007 at 10:30 am
Viewing 15 posts - 31,021 through 31,035 (of 39,754 total)