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

Nice joke.

Hopefully any of you that feel like that might get kick started to go do something more interesting with your life.

SQL Server isn't necessarily better at licensing on VMs, though I think you don't have to license more CPUs than you actually have.

You don't move an 8 proc box to...

you handle this in two ways.

1. You add the fix to v2 and either accelerate testing, or they wait for it to finish.

2. You make a change to v1, test...

I've never had good luck doing this. The script might work, but honestly, recreating them isn't that bad, even on dozens of instances and it's a one time task.

You should be using ALTER DATABASE to change the size and then restart SQL Server.

The older DBLib stuff might work (based on named pipes).

However you need some way to connect from Windows to Sybase, and once you have that, it's possible that you can...