Viewing 15 posts - 47,986 through 48,000 (of 49,571 total)
What was the problem?
December 21, 2007 at 6:00 am
colin Leversuch-Roberts (12/21/2007)
December 21, 2007 at 5:14 am
Ok.
As I said, I know very little about notification services. Is there any way to check which query notifications are active in the DB?
December 21, 2007 at 4:51 am
Adam Haines (12/20/2007)
You are absolutely correct. I forgot to mention that "column2" has to be an actual column in the table for this work. You cannot do this...
December 21, 2007 at 12:17 am
Can you double check that the notification services in the two DBs are set up the same? Same events, same schedules, same subscribers, etc.
I'm not that familiar with notification sevices,...
December 20, 2007 at 11:42 pm
I have a feeling that the error's coming from the sub query. Try changing to the following and see if your problem goes away.
SELECT
L.LOC_ID,
L.Location,
L.Phone,
L.DealerCode,
(FirstName +...
December 20, 2007 at 11:33 pm
Enable traceflag 1204. That will write the deadlock graphs into the SQL error log. With the info in the graph, you should be able to locate the cause of the...
December 20, 2007 at 11:28 pm
Run sp_updateusage
Edit: Correction, that should be DBCC UPDATEUSAGE. Sorry
DBCC UPDATEUSAGE ('DB name','Table name');
December 20, 2007 at 12:57 pm
Adam Haines (12/20/2007)
example:
SELECT mer_from_dttm fd,
column2 = DBO.FreqFortnightlyFunction('24-MAY-2006 2:40:00',...
December 20, 2007 at 11:16 am
I'll try it out in 2005, see if the results are different.
December 20, 2007 at 10:56 am
Lowry Kozlowski (12/20/2007)
December 20, 2007 at 10:20 am
The script as written will find you the longest column name per table. Somehow, I don't think that's what you wanted.
If you want to find the length of the data...
December 20, 2007 at 9:53 am
Viewing 15 posts - 47,986 through 48,000 (of 49,571 total)