What do you mean by different DB Engines? Do you mean a different SQL Server or do you mean Oracle, Sybase, etc...?

Withing SQL Server you would use Linked...

I don't know of anyway to do this with a desktop application. I think you could with a web application using IIS as you could set that to have...

You might be better off writing separate SP's for each set of conditions and making this a master procedure.

It is WAY too long to try to understand what is happening....

Simple answer, Yes. I'd talk to the Day Care administration about this.

Can you provide the error message?

In order to tell you what is happening, you'd have to include some sample data and results to demonstrate what you mean by wrong. To be honest I doubt...

I'm going to second John's suggestion. Figure out how the procedure is being executed and disable it while loading the data.

If you can't disable the procedure call, could you...

Did you read the articles suggested earlier in the thread?

Grant Fritchey (10/27/2009)

---

Well now that I can do, but...

Bob Hovious 24601 (10/27/2009)

---

Hey y'all. I think I finally have something that would make a good short article. Have any of you ever seen something...

I'll third the value of at least occasionally attending a user group. It wasn't feasible for me to do it travel wise until 2007, now I find it invaluable...

Thanks Jon. I think I've seen it before, but couldn't remember. Just feels weird typing jcrawf02 when replying or referring to you especially in The Thread.

Great! Count me for a soda or coffee.

I'm planning a blog a post this week, pre-Summit on my suggestions for PASS. I'll be honest, most center around resources for user groups as that is where I...

Do you mean you gave the ASP.NET account full permissions on the folder?