Groups | Blog | Home
all groups > sql server replication > july 2003 >

sql server replication : Will anyone know this?


Ben Taylor
7/18/2003 12:28:45 AM
Hi,
Does anybody know how to get enterprise manager to stop
putting lines like setuser('taylorb') in the output .sql
file when you ask it to script a whole load of stored
procedures?
I had even created a VB program to remove these lines but
it isn't working properly now, and I thought it would be
the sort of thing you could turn off but not in an obvious
way. It doesn't work when I'm trying to set the database
up on another server for example because there's some
security issue with setuser (I'm not an administrator but
am the database owner) - I just want to remove setuser
calls.
Hilary Cotter
7/18/2003 4:54:40 AM
I have complained about this. You might want to to:

sqlwish@microsoft.com

What I do is do a global search and replace for these
guys, ie

setuser

is replaced by

--setuser

The replaces not only the setuser statements, but also the
setuser N'username' statements,and has SQL ignore them

then at the top of the sql script I type

setuser N'MyOwnerName'

This works when I have a single namespace.
[quoted text, click to view]
AddThis Social Bookmark Button