it's permissions still.

this is a common security misconception/"gotcha". The problem is that when you access any resource OUTSIDE of SQL server, like network shares, local hard drives and folders,xp_cmdshell,bcp with...

gary.p.heath (3/20/2012)

---

Lowell, you have made more sense and taught me more in the past hour than I have been able to learn in the past week over at CodeProject.com !!!...

I think you'll be fine if you just add a little flexibility into your application for handling the building of the connection string.

for example, what should happen if i wanted...

gary.p.heath (3/20/2012)

---

OK, thank you, that makes sense.

No, my program is a Windows Form with multiple Tabs that allows the user to update the database (yearly maintenance) and then process the...

nope. a database connection would be part of the project, not the database or the database service....the application "assumes" it's there.

you would typically parameterize the elements required for the connection...

without seeing the procedure itself, all i can offer is basic suggestions.

you might be suffering from parameter sniffing.

you might want to update your statistics.

the SET options (ansi_nulls, etc) between SSMS...

tI'd check for three things:

1. Make sure the SQL Broswer service is running. That is the Service that handles the part of the connection when you request machinename\Instance1 ,...

For those of you who followed this thread, did anyone use this method to handle foreign keys with circular references?

I adapted a couple of the posted examples, and against one...

in the past, because the foreign key table is used for a drop down list, I've seen key-value pairs like 0 'Select...', and the default of zero in...

My questions still apply;without details on what you have,what technology and what you've tried, i cannot give you any more advice than "the next button needs to retrieve the next...

Not enough information, my friend. Remember we can only see what you post.

Are you writing an application? If true,which language?

Or maybe reporting services?

Do you have any code you tried so...

First check the windows firewall. Disable it on the server, and then try to connect via SSMS from a remote machine. If it connect, you know you have to...

The default value would need to be a real value in the foreign key table.

An example might be a.n address record has a default value of the key to tbsrate...

ALL junk characters or SOME junk characters? was it human readable when you opened it?

if all...

because there is no default order. SQL built the...