Actually, the reason I tested TableSample without the Percent was to see if it did rows and it definitely does not.  I don't even think it converts to a percentage...

But that doesn't put the quote into the little Quote window, does it?

At least, I haven't been able to make it work. 

Here's what I'm doing.  I go to someone's post,...

mforbes, I know that.  That was my second comment.  My first comment or question is this:

Veritas can backup everything on the Server.  So, it backs up the OS, the folder structure...

Or, horror of horrors, the team is re-imaging the entire server which would "convienently restore" SQL Server to the state everything was in at the time Veritas took its snapshot...

AHA!  Now that's an argument I can use. 

Thanks, Steve. @=)

Darnit... Can't get the quote thing to quote the line I wanted to quote...  Meant to quote "Also, what about...

Ahhh.  Good one, Rudy.

Forget dynamic SQL.  Use Rudy's suggestion.  It'll save you having to change even the linked server connection / alias if the hardware changes.

Andras,

I just noticed that myself... GAH!  I'm working on so many bug fixes today that I feel like I left my brain at home.  I am such a Ditz sometimes....

I still don't understand why ObjectID() would make a difference with non-temporary tables.  It just happened to me again....Sortof.  Now in the opposite way...

If exists (Select name from MyUserDB.sys.objects where...

Unfortunately, the Upgrade Advisor article in BOL doesn't actually say what might be depreciated in future versions of SQL Server.  And I actually need quotable text to give to the...

Maybe that's what I saw.  Information on the numeral version being depreciated... Ninja, do you have a source for that?

Thanks,

If you're aliasing a Delete table for a join, the same principal works.  Example:

Delete from MyTable

from MyTable t1

join OtherTable t2

on t1.A = t2.A  ...

Basically, you have to list the FROM...

Are you talking about in the text of the proc or in the actual proc name?

You can write a T-SQL statement that pulls the name & Text of the Procs affected...

Except for the problem that the job is what actually schedules the SSIS package, so using SSIS to schedule the job wouldn't work except in a very recursive, clumsy way.

A...

The more I think about your idea, Ed, the more I like it.  I'm not sure how easy or hard it really would be for MS to code it up,...

I definitely would like to just go in and click a little check box next to each job step to say "Disabled".  It would make my life much easier.  And...