Viewing 15 posts - 47,371 through 47,385 (of 49,571 total)
Try print for debug then. Assign a local var in the trigger and print that. If the print prints nothing, then there's something else wrong.
February 14, 2008 at 11:05 am
I don't know exactly what the notifications are for. It's for a trading system, so I will guess that its to tell the front end that a price/rate has changed.
Not...
February 14, 2008 at 11:01 am
Steve Jones - Editor (2/14/2008)
Lock Pages in Memory not assigned?
Standard Edition. IIRC, Lock pages is only honoured on Enterprise.
I'd still call PSS. I don't know anyone who can read stackdumps...
February 14, 2008 at 10:57 am
Run a profiler trace against the server. Someone or something is changing the recovery mode. It doesn't change on its own.
Trace to disk and load the trace into SQL once...
February 14, 2008 at 10:54 am
We're not that strict here. The same post in 2 different places means that people will waste time answering something that has been answered already.
If you realise the post is...
February 14, 2008 at 9:02 am
Not at all. SQL's quite capable of handling index creation while the DB's in use.
Since you're on SQL 2005, you can create the index either online or offline. Offline is...
February 14, 2008 at 8:52 am
Please don't cross post. It just wastes people's time.
Answered on the following thread - http://www.sqlservercentral.com/Forums/Topic455740-169-1.aspx
February 14, 2008 at 8:50 am
Triggers returning rowsets is frowned upon. There's a server setting that prohibits triggers from retruning result sets at all.
I would suggest you stick to print.
February 14, 2008 at 8:46 am
It's a x64 server, so no PAE memory, but 14GB is still a little too high. I prefer my available memory to be at least 1.5-2GB on servers with 16GB...
February 14, 2008 at 8:43 am
Why do you want to lock the tables?
iirc, in SQL 2000, creating a nonclustered index makes the table readonly for the duration of the index creation
February 14, 2008 at 8:39 am
Frank Woodard (2/14/2008)
select * from table where [datetime] between '2007/02/14' and '2007/02/15' this will give you 2007/02/14 from 00:00:00.0 through 23:59:59.9
That will return 2007/02/14 from 00:00:00.000 through 23:59:59.997 and...
February 14, 2008 at 8:35 am
Probably both have select locks on a page and both want to escalate to exclusive. Instant deadlock.
Could you post the code for both the proc and the trigger, as well...
February 14, 2008 at 8:13 am
Steve Jones - Editor (2/14/2008)
February 14, 2008 at 8:08 am
Stu (2/14/2008)
February 14, 2008 at 3:51 am
No idea, sorry.
If you just do a straight Select 1 FROM a, do you get the same error?
February 14, 2008 at 1:18 am
Viewing 15 posts - 47,371 through 47,385 (of 49,571 total)