Viewing 15 posts - 41,011 through 41,025 (of 49,571 total)
Print the sql string before you execute it and check it for any errors.
February 18, 2009 at 5:19 am
Run profiler (or preferably a server-side trace) for an hour or so during the server's busy time. Find the 3 or so queries that are running the longest or using...
February 18, 2009 at 5:08 am
As the error says, the view or function is not updatable because the update command you've issued affects more than one table. An update can only affect a single table.
February 18, 2009 at 5:02 am
nicholas.catley (2/18/2009)
I'm afraid that it wasn't!
It's usually a good idea when criticising someone else's spelling or grammar to ensure that you make no such mistakes in your criticism. 😉
February 18, 2009 at 5:01 am
Can you run a checkDB on model?
Does a restart of SQL fix the problem?
February 18, 2009 at 4:55 am
free_mascot (2/18/2009)
???If database is corrept and we are taking backup.... does backup too have corruption?
Yes. This is why it's so important to find corruption early so that there are clean...
February 18, 2009 at 4:53 am
Leo Leong (2/18/2009)
i don't think this is what i want.
I don't think so either. Why are you disabling lock escalation?
February 18, 2009 at 4:48 am
lior (2/18/2009)
HiThanks for the reply
I ran the command in Management Studio and the output I got was just "Command(s) completed successfully."
Is that what you asked me to do ?
Yup. That's...
February 18, 2009 at 4:47 am
ALZDBA (2/18/2009)
I know (and have activate on all our db) PAGE_VERIFY at db level.Is my perception correct that this would detect any issue as soon as it occurs ?
Which...
February 18, 2009 at 4:47 am
Check the lock types taken for both. You'll probably find that the delete has taken a lower granularity lock than the update
sys.dm_os_tran_locks
February 17, 2009 at 11:35 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic659079-357-1.aspx
February 17, 2009 at 11:32 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic659079-357-1.aspx
February 17, 2009 at 11:31 pm
What's your disk layout? (No of drives, raid level, DB-related content)?
SAN or local storage?
What do the following two perfmon counters look like (broken down by drive)
Physical disk\ avg sec/read
Physical disk\...
February 17, 2009 at 11:29 pm
Aaron Gonzalez (2/17/2009)
The funny thing here is that the database is configured for snapshot replication, not for transactional replication.
Then there's some left-over, misconfigured transactional replication somewhere. Snapshot doesn't use the...
February 17, 2009 at 11:28 pm
Then set the server's max memory. You should do that anyway on a 64-bit server because of SQL's tendency to eat memory.
How much memory on the server?
February 17, 2009 at 11:19 pm
Viewing 15 posts - 41,011 through 41,025 (of 49,571 total)