Difference between the parser reading an inner join like table1, table2 where OR table1 INNER JOIN table2....

and yes, there are many variables, but I'm just simply speaking of the...

THanks for your reply! So, basically no performance difference - just different syntax?

Don't forget your security and performance requirements/considerations 🙂

Thanks to you both. I will check the filemon tool. I changed the service account when I re-started the server the other day and then changed it back, unfortunately no-go....

Any ideas out there? I also have the same issue on another server that was not upgraded to Windows OS Enterprise.

Great post!

Here's the article from Microsoft:

http://support.microsoft.com/kb/914171

Hi, thanks for the idea, unfortunately Auto close is off on this database.

The problem appears to be related to named pipe connections vs tcp/ip. I will post the results...

Hi Ron,

Thanks for the reply!

I looked at this setting, however I have user instances turned Off so it is disregarded 🙁

I thought it may have to do with the tcp/ip...

They are connecting with an application installed on their desktop client, which uses and ODBC connection.

Since I'm not the system analyst I do not know much about the program except...

Whew!! I guess I missed that in the 2008 changes document!

Thank you SOOO much for the information.

Hawkeye DBA

Did you enable named pipes?

I noticed that if you use the Browser it connects with Named Pipes, even if you have an alias.

ROFL - That's the SAME question I have! Basically, the work is getting done on the production server... definately not ideal. So... that team is finishing up a big project...

I'm sorry, I guess I don't understand? Are you trying to script a CREATE DATABASE procedure? BOL has the definition of how to do this, however I'll post that here...

Glad to hear you got it working!

This is telling you that the account running SQL Server does not have access to the drive and/or folder. It is a permissions issue and once you correct the permissions...