Viewing 15 posts - 9,451 through 9,465 (of 9,720 total)
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...
September 7, 2007 at 5:44 am
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...
September 7, 2007 at 4:52 am
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...
September 7, 2007 at 4:43 am
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.
September 6, 2007 at 10:51 am
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....
September 6, 2007 at 9:25 am
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
Viewing 15 posts - 9,451 through 9,465 (of 9,720 total)