What was the problem?

colin Leversuch-Roberts (12/21/2007)

---

I have never ever improved or changed the performance of a database query by updating stats, issuing a full stat scan or rebuilding indexes in a database where...

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?

Adam Haines (12/20/2007)

---

GilaMonster,

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...

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,...

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 +...

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...

Run sp_updateusage

Edit: Correction, that should be DBCC UPDATEUSAGE. Sorry

DBCC UPDATEUSAGE ('DB name','Table name');

Is the DB set to autoclose?

Adam Haines (12/20/2007)

---

You cant put a function in a group by unless you set a column value = to it.

example:

SELECT mer_from_dttm fd,

column2 = DBO.FreqFortnightlyFunction('24-MAY-2006 2:40:00',...

I'll try it out in 2005, see if the results are different.

Lowry Kozlowski (12/20/2007)

---

With our databases, I have 30+ to check with many tables each with sometimes 100+ columns in the table. The script I wrote shows the column length, and...

Is the DB set to autoclose? Is it offline?

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...

Please don't multi-post.

Continue thread here