Viewing 15 posts - 27,886 through 27,900 (of 39,769 total)
You might have a hardware problem somewhere. I've seen this error with those. I'd contact the vendor for the storage system and let them know you're getting this error.
July 9, 2008 at 9:12 am
database role, backupadmin.
How is a DBA not allowed access to the rest of the server?
July 9, 2008 at 9:10 am
Thanks for the update.
July 9, 2008 at 9:06 am
I don't see an attempt at a CTE here. please show some work.
July 9, 2008 at 9:01 am
Speaking of high security. I worked in a nuclear plant like that. I was friends with the head of security and since I was often going in and out of...
July 9, 2008 at 8:50 am
OK, points awarded back.
The question has also been changed to specify the cursor fitting in memory. Apologies for the delay. We had hay delivered yesterday (160 bales) and it started...
July 9, 2008 at 8:45 am
I think it's a tendency that Brad is mentioning. There are plenty of people that start to get arrogant at a point when they have a lot of knowledge.
July 8, 2008 at 9:12 pm
You can do this with DDL triggers on 2005. Not sure you can do this in 2000 without running a trace continuously.
July 8, 2008 at 12:21 pm
You can't do this, because the drivers for OLEDB/ODBC will use the logged on credentials.
Most OS's now allow a "switch user", which logs in a 2nd person.
July 8, 2008 at 12:20 pm
I'd rebuild all indexes, which will update statistics and ensure things are OK, including removing fragmentation. I might double check the fill factors, checking if I need less or more...
July 8, 2008 at 11:51 am
The plans are stored in msdb. If you back that up, you're OK. I think sysmaintplans has the binary if you need to grab that.
July 8, 2008 at 11:48 am
Do not run this as a single delete. If you do, it's one commit, and it's one transaction, and it's still logged in the transaction log. You want to delete...
July 8, 2008 at 11:46 am
RAID is redundant array of independent disks. If you don't understand RAID, I'm not sure you're the person to provide hardware requirements. You might want to let them know that...
July 8, 2008 at 11:41 am
Viewing 15 posts - 27,886 through 27,900 (of 39,769 total)