Why not create one set of stored procedures that are then duplicated in every database?

If you don't want to use dynamic SQL, then this is probably your best choice.

What error are you getting?

Also, I don't think that "9.500.12.02" is a valid IP address, each segment should be in the range 0-255. "500" is a little bit over...

Can you un-declare and re-declare...

umanpowered (12/3/2008)

---

Because the changes I make are miniscule, I was seeking to avoid the trigger or UPDATE solutions by merely exposing changed "date" data in one of the columns in...

"dbo" applies on SQL 2000. On 2005, most system objects are now "sys".

Glad...

Just add the server name, DB and owner name:

Select * from RemoteSrv.RemoteDB.dbo.SYSCOLUMNS

Use the Google Maps API and see if they return the same location?

IIRC INFORMATION_SCHEMA worked differently on SQL Server 2000, I do not believe that they worked cross-database, whic would certianly make it unlikely that they would work cross-server.

I would recommend using...

Huh? Don't you watch the Science Channel? Air Cannons are where its at, more than twice...

What kind of wait states is the SQL process getting?

In fact the whole WHERE clause of the first function seems to be very confused. The is definitely something wrong with it because it won't compile, even if I...

Whetever you were putting in front of your 6's in the first function is lost. Could you please fix it? thnx

mlandry (12/3/2008)

---

Whoa, using SQL to do cross-tabs really is "old school" (circa mid-90's or before.) It just wasn't designed for this.

Do yourself a BIG favor and try Analysis Services. The...

Great article, Jeff. Like The Return of the King, it was well worth the wait!

🙂

Originally, the SCHEMA were intended as an organizational concept in SQL that could have security attached to it. Microsoft's implementation of them before SQL Server 2005 were so bound...