I'd check on what Grant suggested.

Also, is this a data problem in any way or just differences in the way that the code is being interpreted?

SQL Server connections are through a port/IP combination, essentially a socket. If you have 3 servers all on default settings, and 1 public IP, you cannot connect through 1433 to...

Dashes throw things off, only slamming everything together requires everyone to assume the same thing. I know, I know, it's annoying, but the rest of the world is different from...

There's no reason this won't work on a cluster, put everything on both sides and it should be fine.

Unless someone is nervous about it, and I understand that. If you...

Either an output parameter, or a return value, or you could return a one row, one column result.

In any case, I'd recommend OUTPUT parameters as well.

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

I tend to agree with Colin here. You are asking for a tremendous amount of information, not some detailed issues. These are general questions and you end up not really...

The above solution will work. SQL Server doesn't care what the date data is. It stores it. The applications need to ensure they are both inserting properly and they are...

Henrik, thanks for the story and solution. Good job!

Yep, lack of replies was my fault. No newsletter. 🙁

More and more I think that you need a break. I probably work too much, and I'm trying to figure out how to be better there. Really more efficient in...

Are you using @test1 somewhere in your code? I think it's the return value as well, but some code is missing.

You need to post in the Access forum. I've moved it.

Second you need to give more information. What doesn't work, what error occurs, etc.

What do you mean recreated? Are they dropped and recreated? How do you know? Are permissions lost?

If this happens consistently and you know roughly when, I'd set up a trace...

http://www.37signals.com/svn/posts/1006-sleep-deprivation-is-not-a-badge-of-honor