Thanks for the tip.

sp_change_user_login does the trick. 

Thanks WZ700, so you can REPLACE with nothing

johnathna, jxflagg

Thanks for the tips

What's the differece between openrowset and using linked servers?

Thanks

Sure the message I'm getting, 3624, is below, it happens sporadically when doing log dump.

Thanks

____________________________________________

2003-09-11 00:27:10.45 spid54 Stack Signature for the dump is 0x21F5A243

2003-09-11 00:27:10.49 spid54 ...

Hi we're running sql 2000 sp3.

Shas3, much thaks for all your help, have a great weekend.

Richard

Shas thnaks, do I need to just start and stop sql or reboot the server for this to take effect.

Appreciate all you advice.

Richard

Shaa,

the "executive" is the mssqlserver service?

and the sqlservseragent as well?

and do I need to change the logon for the MDTC server?

do I need to restart sql for this to take...

Thanks Marcus,

Can I change from local account to domain wihtout reinstalling SQL?

Thanks

Thanks all for you great advice, makes sense now. btw maremont why use char(13)?.

Richard

Terry,

I'm not sure if I'm a 'heavy hitter' but I am in Chicago and do contract work.

Richard Buchner

I'll plan to give you a call Monday.

Hi,

One way to get started is to use the Stored Procedure Wizard.

Go into Enterprise Manager, Tool, Wizards, Storped Procedure. it will guide you thruhg some simple stored procs.

Then go to...

Thanks for the tip, it worked fine.

One other question, then. How and why do you use SYSNAME in sprocs?

Thanks

Thanks for the tip, it worked fine.

One other question, then. How and why do you use SYSNAME in sprocs?

Thanks