So the script was something along the lines of this :

SELECT 'DROP TABLE [' + USER_NAME(uid) + '].[' + Name + ']' AS DropCMD FROM dbo.SysObjects WHERE XType =...

HTH.

Good night.

Nah, I'm more of a Bon Jovi fan .

Yup, even with the June 2007 version :

http://msdn2.microsoft.com/en-us/library/aa258253(SQL.80).aspx

Books online / Create view / E

I'll try to find it on msdn...

Why not SELECT TOP 1 * FROM Table1 ORDER BY Duration [ASC|DESC]

??

LabID between 1 and 35 or LabID is null

Don't use the default and you'll be fine.

As for precedence I never really thaught about this one.  I think I would code it...

Happy to help .

We'd need the table DDL, sample data and required output from that data to help you here.

IF EXSITS (SELECT * FROM Whatever)

BEGIN

--at least one row

END

ELSE

BEGIN

--no rows

END

I'm glad we could help... after all .

I think this is only fitting, for anyone here, to close this thread

This is a hierarchy problem.  This is pretty simple to solve with loops.

However one other solution I like is to have another design :

BatchID --ids the group of jobs...

I said that because the file will grow back to whatever size it needs to be at for the DB to work properly.  Once that's done I like to exten the...

That's why I was using the SysColumns approach, that way you can find potential problem tables.  Once you have that list, you can start looking for rows that are close...

Ya that's a big one.  You must set a connection for the command object and that connection must be opened when executing the code.

Also I think that the parameters size...