Are you looking to do windows integrated or just pass a domian username/PW combo?

You could consider using an ODBC datasource as well...

Instead of using a Global Variable, you can change it at run time via an activeX script. 

Have a look at this and see if it helps any.

http://www.sqldts.com/default.aspx?200

-Luke.

Most likely what is happening is that you installed your program files, not just your databases to d:\.  When the citrix install came through it installed many of the same...

What tools are you speaking of, EM, Query Analyzer etc?

check and make sure your shortcuts are pointing to the correct locations.

My CFo or CIO's safe has always worked for me...

I'd say it definately depends on what the developer is trying to do.  If I have 2 databases, instances whatever and I have 2 tables with a bunch of records...

how are you executing the BCP command?  Is it via a SQL Agent job, via xp_cmdshell or whatnot?  Try adding the SQL Agent account to the share permissions.  Also have...

As I read this I can't help but think... Was the SQL Service set to run as an account on the Old Domain?  Is the sQL server service even started...

From Book online...

"When xp_cmdshell is invoked by a user who is a member of the sysadmin fixed server role, xp_cmdshell will be executed under the security context in which the...

Just what everyone else said.  I don't trust data I get from the web unless it's been verified by numerous other sources and I've test it myself.  Like everyone else...

When you said "and have them be synchronized", were you talking about moving the data once, or were you talking about having both db's synchronized for reporting or high availability...

I think it's taking issue with the /b following the EXIT command, although I can't swear to it as I'm not terribly familiar with scripting osql commands.  It may also...

yeah I'd seen the save change script and noticed what it was doing.  those procedures should help a bit.  I appreciate the info.

Thanks again.

-Luke.

it's not terribly important and from a design standpoint it makes no difference, as in the application it can be displayed whereever I want to.  It's more of a "for the...

I'd imagine you could do this all from one SP without the need to xp_cmdShell et al.  Have you tried setting them up as linked servers and then using the...