Viewing 15 posts - 35,476 through 35,490 (of 39,803 total)
The only real way to automate this is with a trigger. But the trigger can be really simple and update the same table as mentioned above, then load your "backup"...
January 12, 2004 at 10:07 am
You also need to be sure that you know why the database went suspect. Check the error log for a reason.
You can clear the suspect flag as well with
sp_resetstatus <db...
January 12, 2004 at 10:02 am
While we're not really looking at doing that for a number of reasons, can you list the issues with the new forums? It's a big change for me as well,...
January 12, 2004 at 9:47 am
I use a batch file (*.cmd) that calls
isql -S ServerA -E -Q"sp_password null, new, sa" >> change.txt
with a line for each server, add a server add a line, change the...
January 9, 2004 at 2:58 pm
and for the select, if the owner is "dbo" then the parser automatically resolves this. If any other user owns the object, you must query as owner.object.
January 9, 2004 at 2:54 pm
Might be hidden. Is this regarding an authors area?
Try the "Jump" box at the bottom.
January 9, 2004 at 2:51 pm
Sorry
, never tried this. I tend to work the things separately. I know in VS.NET it is completely integrated and the debugging crosses...
January 9, 2004 at 2:46 pm
What if you split this into
select @newvar = "@intDataChangeMode=" + cast(@intDataChangeMode as char)
print @newvar
Does it still fail? I'm curious to see if you can trace one execution under MTS with...
January 9, 2004 at 2:44 pm
Definitely a loophole. Here we remove public and create a group in msdb that allows package creation/editing. A separate group is used for job executions on the very rare chance...
January 9, 2004 at 2:41 pm
The big thing with notification from a business point of view is that we want you to come back, so not having the text (Which is the new design) works...
January 9, 2004 at 12:02 pm
January 9, 2004 at 11:57 am
http://www.sysinternals.com has some good utilities to see which process holds which file open.
January 9, 2004 at 11:56 am
I agree. I might drop the transform and rebuild it. Quick and easy and usually fixes issues. Print Area can be a big one as can blank lines.
January 9, 2004 at 11:55 am
I guess you could update the table manually, but I hate to do that. I'd add the new group and drop the old one.
January 9, 2004 at 11:54 am
Not sure how you do this from VB6. You can run Profiler and see all the calls made to the SQL Server. You can also load the SP in Query...
January 9, 2004 at 11:53 am
Viewing 15 posts - 35,476 through 35,490 (of 39,803 total)