I'm not familiar with that script but you can just use this select to find what you want:

select name, text

from syscomments A

JOIN sysobjects B on A.id = B.id and...

You mean if there are gaps in the IDs (they are not sequential) ? Your sample code indicated that they would be. However, that situation could be handled by using...

I'm beginning to find the new "intelli[non]sense" to be aggravating at times.

Hopefully this isn't a homework assignment... but what you want to do is usually done in two updates as follows:

update A set A.outputdataversionid = B.outputdataversionid

from outputdatavesrion A

JOIN outputdatavesrion B...

GilaMonster (6/13/2011)

---

A single bit column takes one byte, same as a char(1). Up to 8 bit columns takes the same amount of space (up to 8 bit columns can be...

HaHa ... one of the nice things about...

you can put an index on a bit column but think about, its not very selective for large tables so probably wouldn't be used, but then neither would a char()...

Reloading ammo is always relaxing.

please post the connections string you are using. If using a DSN make sure you have not specified a protocol other than TCP/IP (if that's what you want).

You should be...

Gsquared you are right on. Depending upon a lot of factors the deletes could have gotten significantly behind the inserts. All inserts always go at the end of heap...

I have mixed emotions about all of the letters I sometimes see after some peoples names (I realize G-Squared does it in jest).

When I first became a licensed pilot...

pixelwizzard (6/7/2011)

---

Hi, we need to hire a true SQL Server expert for a day or two of consulting in optimizing a new golf scoring system under heavy load. We've ran...

PhilDaniels (5/23/2011)

---

My reasoning is perfectly sound...Core inflation is over 3% and excludes gasoline and food prices. Add those in, and inflation goes to about 7%. So, it is a perfectly...

Wait till it finishes. Depending upon what it was doing (did) it could take a while for the rollback to complete.

opc.three (5/12/2011)

---

sturner (5/12/2011)

---

opc.three (5/12/2011)

---

sturner (5/12/2011)

---

Yes, that is a hack way of masking the underlying...