Yep... I agree with Trigger... don't ever use @@IDENTITY because if a trigger fires and that trigger inserts into another table, @@IDENTITY will not contain the value you think it...

Ummmm.... you could us sp_lock to see if the table is being worked on by the type of lock it has.  You would, of course, need to know the ID...

You bet, Charles.  Thank you for the feedback.

Great idea... a word of caution, though.  I've found that sp_Depends will sometimes miss things... I believe that problem is also documented (somewhere) on this forum.  Not sure if they...

What was the solution you came up with?  Thanks.

You could convert this to a sproc or use it as is...

DECLARE @ObjectToFind VARCHAR(200)

SET @ObjectToFind = 'PutNameOfObjectToFindHere'

 

 SELECT DISTINCT

        so.Name,so.XType

   FROM dbo.SysObjects so,

        dbo.SysComments sc

 ...

Ok, thanks... always a pleasure Sergiy.

I agree with PW... store the date as a DateTime field or you'll kick yourself in the near future.

One method to display the date from a DateTime column using the...

Serqiy, As you are aware, in MS-SQL Server 2000, you can't create a variable with the TEXT datatype.  Where did you store the 20k XML before you used it as...

Roger that!  Confirmation in both directions is always a wonderful thing...

It doesn't work quite like you'd expect... although the VALUE of the seed works as posted above and in Books-Online, it doesn't work WHEN you'd like it to if you...

It could also be a 2 digit year Julian date format in the form of DDDYY where "DDD" is the day of the year.  But, as many have already said,...

Hmmmm... Ken, I can't say I agree... here's some test code to demonstrate why...

The first part of the code makes a test table of a million rows.  After all, if...

Yakov,

As many have said, this is (or should be) common knowledge.  But, I for one, appreciate your boldness for publishing what you did.  You found a nifty tool in Query...

Uh huh... The only difference between what you and the author did is you didn't list all the steps.