Viewing 15 posts - 35,056 through 35,070 (of 39,793 total)
While there may not be a "query" per se, the idea you have of reading the sysjobschedules in real time is probably what happens. Perhaps there is some "backdoor" approach...
April 15, 2004 at 8:52 am
Rollback means it's rolling back. Likely something is stuck. Did you check for blocks?
If KILL doesn't do it, you'd have to do a restart to end the process.
April 15, 2004 at 8:41 am
You really need an external process that can accept the files and move them into SQL Server. It could run a DTS package, bulk import, simple insert, whatever.
As far as...
April 13, 2004 at 11:06 pm
Profiler is the best way. Cumbersome and only for point use.
April 13, 2004 at 2:25 pm
, you need to send in the output parameter for it to be output. Otherwise where does the output parameter go? It's not a...
April 13, 2004 at 10:33 am
You guys are thinking too hard. It IS possible to attach back the mdf and get it working. It's certainly possible that this will not work, and there may be...
April 13, 2004 at 10:13 am
Haven't done much with it. Called in as a consultant to some companies that have used it but cannot restore. Worked with Veritas and sometimes successful.
My 2 cents: Not worth...
April 12, 2004 at 5:35 pm
I'm searching back for the Q reference, but I actually ran into this one. I couldn't create a database and the reason linked back from PSS as Autoclose set on...
April 12, 2004 at 5:29 pm
Like I said, it depends. They don't need any of those roles necessarily. If I want someone to run imports via DTS from Excel, I can add him as a...
April 9, 2004 at 4:45 pm
depends on how they do it. Could get by with insert and select (maybe update). Sys admin isn't something I'd give out.
April 9, 2004 at 3:51 pm
It can take awhile if it's lots of GB of space. Glad it's fixed for you.
April 9, 2004 at 3:43 pm
I don't think so, but you may email or check Ken Henderson's book.
April 9, 2004 at 10:29 am
Viewing 15 posts - 35,056 through 35,070 (of 39,793 total)