Shwetha -

Unless you've set up columns in or triggers on your tables to accept this type of information or are runnning a "log explorer" type tool there is no way...

select * will mess you up everytime - by selecting * you're forcing SQL to go back to the base row in the table regardles of indexes including including covering...

You could try adding a local user account with the exact same user name as the users corresponding user name in your domain (e.g. domain user namt is domain\cliffordj, create...

Talk to your firewall folks about setting up an IPSec connection between your offices and the remote users.  Depending on the settings of the IPSec connection a changing IP may...

Probably the first thing I would look at is whether or not SQL Server can determine the primary key of the remote table; does the remote table have constraints, etc? ...

I tend to keep the nicer shirts (e.g polo's with collars) the rest, especially X-large t-shirts (I'm a medium all the way regardless of brand) end up being sleepwear for the...

Jim -

I've got to side with Jeff on this one - been there done that, even against 300-400 million row/200GB+ databases, it's possible to write distance calculations that return subsecond...

Deltatuk -

I just have to ask, why can't you use linked servers or replication?  Sounds to me like somebody has made a decision without all of the facts.

Joe

Ahhh, the joys of our electronic world, short of emoticons (:sick and <grins>, it is often difficult to judge the intent of the message...

Joe

Hmm... how did you take your snapshots?  Is the production database set to auto update statistics or is there a sheduled reorg/reindex that might not have taken place on the development...

Art -

You'll want to get the servers to be as nearly identical to each other as possible.  If I interpreted your post correctly you've got difference O/S's at different service...

Have you tried logging in using the same account that the agent is running under?  I know you said you tried while logged in as a domain admin, but was...

All -

Select <> Insert.  You're comparing apples to oranges in that a select is a simple data retrieval operation limited only by the time for your source database server to...

Identical hardware?  You've got a couple of variables there so solving for one is going to be difficult.

Assuming that your first environment is a development environment you're going to want...