Viewing 15 posts - 9,451 through 9,465 (of 9,715 total)
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...
September 6, 2007 at 8:57 am
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...
September 6, 2007 at 5:42 am
Maybe that's what I saw. Information on the numeral version being depreciated... Ninja, do you have a source for that?
Thanks,
September 5, 2007 at 11:46 am
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...
September 5, 2007 at 10:40 am
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...
September 5, 2007 at 10:35 am
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...
September 5, 2007 at 8:44 am
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,...
September 5, 2007 at 8:34 am
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...
September 5, 2007 at 7:11 am
As much as I hate to suggested it, the only way you can do what you want is through the use of dynamic SQL. Stored procedures and Cursors don't like...
September 5, 2007 at 6:01 am
Well, the agent does support that sort of thing much in the same manner as John mentioned the disabling of steps. What you do is use the sp_start_job proc to...
September 5, 2007 at 5:35 am
Okay, now I feel just plain silly. @=)
I completely forgot about that functionality... Thanks for reminding me, John.
September 4, 2007 at 11:34 am
Half the stuff posted on Monster anymore seems to be trying to get people into Sales jobs or get them into training classes. It's sad.
Worse when they stick ads for...
August 29, 2007 at 10:22 am
Good point on the definition, Matt.
I actually meant outsourced in the sense that the DBA A) a contractor (not employed directly by the company and B) doesn't come into the...
August 28, 2007 at 8:36 am
I'm glad my forgetfulness could help someone out. @=)
August 28, 2007 at 7:49 am
If the practice tests are any example, I'm thinking you have 145 minutes total for the exam. The other stuff may be covered by NDAs (I haven't taken the test...
August 28, 2007 at 3:58 am
Viewing 15 posts - 9,451 through 9,465 (of 9,715 total)