So sorry Gail. I forgot to thank you for your answer. I have already created a program that calls SQLCMD to do what I need to do. You have been...

I'm trying to automate a process. That wouldn't work.

It is definitely Monday morning.

Thanks for the correction. You are right. What I want to do is change to a different instance. Does this make sense?

Rob,

Thanks for the code. That will work in this case.

Gianluca,

Thank you for the article. I have it bookmarked to read and reference. I will be needing this in about 3...

Unfortunately, the data is contained in a table tat is part of a proprietary ERP system, and thus can not be modified.

Boy, do I feel stupid. I figured it out. I changed my network password the other day but failed to change it on the services. Everything works now. Thank you...

The SQL Server (MSSQLSERVER) service failed to start due to the following error:

The service did not start due to a logon failure.

For more information, see Help and Support...

Yes, I am trying to connect to my own machine. None of the services are running. When I try to start any of them they error out.

Todd,

I inherited this code, so I am not quite sure what they were trying to do. I have made these variables = NULL and that part works fine.

Dan,

Sorry I forgot...

Sorry it took me so long to get back to you. Thank you very much, Jack. It works perfectly.

I am pulling from the same database. Basically what I am doing is creating a temp table in a sproc. Before I do I want to make sure the old...

Pam, thank you again. I will see if I can incorporate this into my code.

Drew, you have given me a very good idea. I am indeed trying to incorporate this...

Thanks again, Pam! You are a great help!

Thank you, Pam! The last one works perfectly!

Steve

Sorry, I should have done this first. Here is the code to create the data:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#jobtran','U') IS...