What versions of SQL Server are out local and remote machines?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

What is the actual error are you getting?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Did you set the Server Options to allow "RPC Out" on the new linked server definition?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

I'm doing just what you are and here is what I have done.

On the box that runs the SQL Server Agent job, modify your linked server properties to include a...

Sorry for the blank reply.

Have you set up the SQL Server Agent account to logon to the remote server? This is the account that will be considered...

quote:

---

Here is my scenario:

I have 2 servers. One local server called SOCMON, the othe called GREP05 (which is in a DMZ)....

By packed decimal I'm guessing you mean an eight character date like '20020102' would look like this in a SQL Server binary field 0x20020102

If this is true then you might...

Yes, backups can be created on a mapped/network drive. To do this you need to first create a database backup device that points to the network device. I...

You will need to consider how many inserts and updates you will perform, and whether the performance issues out ways to data integrity issues, that might occur without FKs.

Gregory Larsen,...

I have some SQL Agent jobs that use CDONTS. Although this works because CDONTS is installed on our SQL box, because this particular box has both IIS, and SQL....

I have some SQL Agent jobs that use CDONTS. Although this works because CDONTS is installed on our SQL box, because this particular box has both IIS, and SQL....

A "Sleeping" process is a process waiting for a lock or user input. Know I suppose if a process started a transaction, did some stuff, then did some more...

If you restore a database it will overlay everything in an existing database. In your example table A will be gone.

If all you really want to do is migrate tables,...

Might try looking at the "Managing Long Data Types" section of BOL for some ideas.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

When you backup a database it backs up everything (Tables (schema and data), views, stored procedures, users, etc).

If you restore a backup onto another database it will restore everything (tables,...