You should also use an SSIS package for things like this. Especially when accessing another box. You can easily include some things in the package to check if this particular...

Forget about the INSERT statement until you get the SELECT working correctly. You really should place this code into a stored procedure. That way most anything can call the sproc...

Yes, SSIS is the best way for this. You can schedule the package to fire off when needed, or fire it off manually at anytime.

You can perform every step needed....

This can easily be accomplished using a SSIS package. It will take many small steps. You can always drop the foreign key constraints, pump the data in, and add the...

To keep things really simple, I would create a simple SSIS package. That way I could schedule it to fire when needed, or even have it fire manually from within...

I found an "ODBC Connector for Windows". I have used that to pump data out of, and in to MySQL. If you want to pump data into SQL Server, I...

I think it would be so very much easier to create a DTS / SSIS Package. There is so very much more that you can do with the Comma delimited...

Thanks

I thought about the replace function right after I posted. It has been a long week.

Thanks

Andrew

What is odd, I also have SQL 2005 running on both boxes as well as SQL 2000, and I can connect to any of the SQL 2005 database just as...

It is set to allow remote connections from other servers.

But it will not accept any.

Thanks

Andrew

Handle what?

That is not that odd. Sometime you have to have connection string accounts like that.

It is much better to use Active Directory account, but I like using SQL accounts...

Well, here is the problem, there is not a SQL Command in the Create Login, only on the Drop Login

Create Login

...

Good Idea

I will try that, at least I may be able to see what is in the XML string

Thanks

Andrew SQLDBA

Thanks

I have been looking thru the BOL under Notifications. Still reading

I will look at what you suggested.

Thanks

Andrew SQLDBA

I know there should be something, but what? Do you happen to know of the Number?

Thanks

Andrew SQLDBA