Thanks,

I was just wondering whether there was something else I could do which wouldn't give permissions for all DDL, just the SET IDENTITY_INSERT

DOH,

I meant that to be SET IDENTITY_INSERT

Sorry

Thank you for taking the trouble to reply.

I remebered something else. I registered a server, and it didn't appear in EM. I tried again, but it gave me the message that it was already registered....

Hi Greg,

Thanks for your reply.

Your code works perfectly in 7, however, the same code in 6.5 produces this error:

Line 1: Incorrect syntax near 'master'.

I get this for each db...

Sorry I overtyped and split the code - here it is as it should read:

Hi,

I am trying to create a job which will run nightly to show database info for...

Oops

That should read 32 1/2 million rows

jon,

Creepy!! I am looking atround th office right now to see if you are here & writing in cognito!!

I've always thought that certain people ge t promoted out of the...

Ooops - sorry!!

Anyway, the hour has passed, and everthing went OK, so you are still cool!! I have recently moved from DEV to DBA, and I still panic...

Thanks Brian,

I have to do this in 10 minutes - so here goes. Funny, I put your book on the lobby table to bring to work today (SQLAdmin 911),...

So, are you saying that I should be able to ser tempdb to single user mode?

I have looked at sp_who2, and there are no users connected.

If I run the...

Thanks for the replies , and aplogies for doubble post.

It is from this article I am working and

quote:

---

You should have...

Hi,

Thanks for you replies. Would locking hints help to prevent blocking?

Thanks, I managed to connect at last. I agree about connecting via SQL, but I don't have an option, company policy etc.

I am getting really twisted up with global...

I got round this by creating the relationships, and then looping round them altering them to NO CHECK. It only seems to work if you create them and then...