Nope, no answewr on that yet.

Arrgghh!

Initial size is that big, I never looked for it!! Somebody kick me!

Tnx.

This should not be a problem: detach your database, move it to the new location and attach it again.

EDIT: As an afterthought: you can and probably should chage the default...

Tnx for answering all, I'll keep the warning in mind.

Another question, I'm stupified by the following:

I wish to allow non-sa users to run a bcp string with xp_cmdshell. The option to use this XP is by default turned off....

Tnx for answering all.

Tnx for the script, Alz. I'll try it and probly use it. Any idea how to go about this in a Clustered environment? I'm simple, so I'd...

Of course, this response doesn't address the issue of "why use BCP in this day & age..."

You are right. But don't ask, I have stopped asking...

Then again, if you need...

Um..No it does not. I wish to find out about the inner workings of these reports, where their sources are, how to use them on remote servers in an automated...

Time does not matter. I for 1 am glad to have found this, it solved a similar issue I experienced the last few weeks...

EXEC sp_executesql did it...

(burries his head in both hands and starts to cry)

Tnx for answering both.

Tnx for answering all.

I am uncertain on what the value of run_status tells me. If status is 4(Idle), does this mean that the job is active, but currently there is...

Problem solved, thank you all.

Jonathan,

I wish to say thanks again. I must have done something wrong, different then you describe in your solution. I could have sworn I used the same construction to test...

Tnx Jonathan, this is really hel;pful, in several ways.

I thought I had found the solution for my problem, but alas...

I need to call master.sys.dm_exec_sql_text(to find the last used sql-statement) from a trigger, or sp, in another database, by...