Ohio.

Or maybe West Virginia. Plenty of graduates from Marshall and UK in western West Virginia and eastern Kentucky who would be willing to do quality tech stuff for a...

I've never used filegroup backups, so I have a question. If I understand the concepts correctly, even if you back up all the filegroups individually, you couldn't be guaranteed...

Sorry, I miss read the SELECT.

Can you run a profiler trace to make sure you're sending the proc what you think you're sending?

I don't think this is going to do what you are expecting it to do. If you pass in '1111111111' as the phone number, but the name on the...

Won't this always fall through to the error handling routine, where you will always return a non-zero value.

You probably need an 'ELSE' to go with your IF that says RETURN...

The potato goes with the pork chop. Next will come the salad shooters, and finally the dessert derringers.

Are the master databases for both instances stored on the same drive? When did this problem start? Were any changes made to the accounts under which the server...

Guys,

He may be a vegitarian, Rotarian, NRA member too, but I wouldn't necessarily jump to the conclusion that any of those had an influence on his MVP status. It...

So in this case MVP may equal Most Verbiage Plagiarized?

I'm guessing that #1 has to do with how you would handle unpredictable combinations of search criteria being entered by the user. The answer to this could be successive...

Since, I'm guessing, this is homework, why don't you tell us your ideas about how to accomplish these things and we'll provide guidance as needed. Most people are happy...

OK, here's a hint for 15.

The employees table has a city column which can be used to find specific cities.

Give the SQL a try and we'll go from there.

Since I don't have that database installed on any of the servers I'm working with, without the table definitions, I'm not going to be much help. There may be...

Incoming!!!

http://www.sqlservercentral.com/Forums/Topic665389-5-1.aspx?Update=1

Are you wanting to run these queries in Access, or do you want to run them inside SQL Server and get the data from the Access database?

Could you please post...