Matt,

Did you ever resolve this issue? I am having the same problem.

Dan

mromm,

Does this look correct I have one of those system generated server names!?

Select * Into G-6F85G465CSGUJ\Archive.PSPArchive.dbo.Secure From Secure_1

It does not like the dash "-" though...

Dan

Hello,

We are having a similar problem with the Log file, where we have run the SHRINKDATABASE and SHRINKFILE. After running both of these our MDF is down to 600Mb, but...

I was able to change the physical file name by using the "Copy Database Wizard". In there they allow you to set the destination file name.

I think I am all...

Now that I have the database renamed, is there an easy way to rename the physical .MDF?

Dan

Thanks for all of the options!

I used the sp_renamedb, and it looks as though it worked great.

Thanks again,

Dan

Got it to work last night. Silly problem... In networking - Client networking, I never went into properties to set NT login etc... I didn't even realize that info was...

Attached is a downsized version of the code... I also tried moving the commit's in different places with no difference as well as without Commit's. Sorry about the naming, but...

Yes... that's what I am doing now is going to a regular table. Much faster.

I was just curious of what was going on with the delay to the ## table...

The plan did not show me anything out of the norm... So what I did was Create a table named Adjust and took the ## off of the 1st insert...

Antares, looks like you hit it!

The path only had the windows directory.

When I added the path to my command line it worked as usual.

You folks have been very helpful and...

OK, you are probably right.

Well at least I am able to create a couple of new DSN's to get me going.

If you find anything further, please post.

Thanks again,

Dan

Ok, here is something strange...

I decided to enable MultiProtocol on the server. Once I did that, I came back to the Client and set the DSN to MultiProtocol. Click Next...

Hello guys,

Yes I can ping the SQL machine from the clients and the response is good. When I tried using QA from the client, I got the following:

Unable to connect...

Hello again,

I even went so far as to reinstall SQL this morning, and still have the same issue.

Dan