On second thought, maybe you should just brung Brian along. 😉

Marios Philippopoulos (3/24/2008)

---

Good luck. Make sure that you've got some...

Does anyone run with RECURSIVE_TRIGGERS on? It just seems like an insane setting?

Actually, I find that including CreateDate, CreatedBy, UpdateDate and UpdateBy columns on the table give me the most bang for the buck by far. More than enough information to...

Can't you change your port number?

This works also and has the advantage of being portable to many of database environments:

[font="Courier New"]Select Table_Schema, Table_Name , Column_Name, DATA_TYPE

, Coalesce(Character_Maximum_Length, Numeric_Precision) as [Size]

From INFORMATION_SCHEMA.COLUMNS C

Where...

sunshine (3/25/2008)

---

It works for sa users, not for Windows Authenticated users. 🙁 They get this error.

OLE DB provider "SQLNCLI" for linked server "ServerName" returned message "Communication link failure".

Msg 10054, Level...

It can facilitate the ETL process.

Chirag (3/25/2008)

---

RbarryYoung - RTM version does not have a option where we can generate alter script for all the procs that have been modified. Rightclick on the database\Tasks\ Generatescripts has...

MobashA, you're welcome.

To start, what are you trying to do?

Here is a description of how to get better responses to your questions: http://www.sqlservercentral.com/articles/Best+Practices/61537/

With an after update trigger on the table, something like this:

create trigger trgFubar_UPD on Fubar AFTER Update

AS

Update Fubar

Set UPD_DATE = Getdate()

Where Fubar.PK = inserted.PK

Two things that are likely to work:

1) put a clustered index on SendOrder

2) Put a covering index on the table to cover (col0, col1, col2, col3, col4, SendOrder, col10)

I don't know any tricks to get periodic query refreshing inside SSMS, I always write a VB.net client to do this kind of stuff.

Well, this does what...