The main reason for removing it is that anyone with domain admin permission (hackers) has automatic sysadmin access to you SQL server installation. I know that it's an academic...

The main reason for removing it is that anyone with domain admin permission (hackers) has automatic sysadmin access to you SQL server installation. I know that it's an academic...

Dragging this thread back up. Just thought I'd let you know, I haven't applied SP2 (business reasons and fear of Clustering...ooooooooh!) but I did some more research and...

Hidee Ho

I'm in the same boat a tinawx (sorta). Our develepers want to be able to run a DTS package from a client machine but I'm not keen to...

Thanks Andy

ckempste, I tried that already but how can include all the objects without having to manually remove them from the script. For example the grant statements on sprocs...

Hi Andy, I think I see what needs to be copied; the entry in sysusers relating to the role and the entries in the sysprotects table based on the uid...

Thanks Andy.

DeltaKilo

Gifted ! This has been a long day and it was immensely stupid to fix. SET ANSI_WARNINGS is a database option... not something to set in a stored procedure...

Nope, that's not it. But thanks.

DeltaKilo

Wilco

Sorry, I should have specified, I've no intention of using a third party SQL backup engine. I was strictly talking about the tape backup of the disk-based files. Sorry...

AAAAAAAAAAAAAH

Ooooo. That's handy. Do you know what the actual bug that SP2 fixed for you was? Q265379? It would be nice to be able to go to the devs...

That's a good plan ....but...

As it is I have an acceptable workaround of logging off and logging back in in the mornings and I amn't confident enough with SQL server...

Thanks Andy,

I was a bit scardy of going to a VB site first.... that's still very much alchemy to me(or Quackery, the jury's out). I'll take a snoop around...