What's the URL you're linking to internally? Or is this external?

If it reports a FK violation, that's what you have. It's not Java, SPs, or anything else. You must be missing something in what you're checking. If it fails, what...

SQL Server = Oracle = DB2

Maybe not ==, but each has things the other doesn't and for 99% of us out there, any of them will do. It's a little...

I've almost always used domain accounts. Set one up, no rights outside Everyone, which has no rights, and then let SQL Setup (or Config manager) assign rights.

Easier to do that...

MySpace has been a great SQL Server story, but more importantly, they show where SQL Server has been weak and how they've had to re-architect things a few times to...

Lowell, great tip on the calculated columns and I would expect these to perform much better than triggers.

David, let us know if you find something. Or write an article...

It's definitely a trivia question and I wouldn't recommend coding like this as all, unless you're in some type of contest for obfuscating code.

I also wouldn't let someone use this...

There are quite a few entries in the Control Panel as well, so you want to be sure you remove them all if SETUP doesn't work.

As David mentioned, SQL Server gets its time from the system. If you don't have your systems syncing time with some source, it is easy for this to happen. Also,...

It seems that everyone is talking about a similar thing here. Let's try to remain professional and respectful as we debate things. I had a few complaints that this was...

Wow, quiet a debate going on!

Brad, thanks for the break and a nice job on the editorial.

We all need to get "reset" at times, to have ourselves grounded back in...

Whenever you have a sourcing contract, you need to be sure you have this spelled out with the provider. If it's a small provider, you should also think about escrowing...

Just for this reason you never want to assign rights to public. Create new roles for every group of users.

As Brian suggested, check and be sure that this group doesn't...

The only issues I've heard of are people overloading the physical machine with VMs and then having IO or CPU issues. You can run 2000 in a virtual environment, just...

The limits change at times in versions, but to date I haven't heard anyone talking about reaching the limits.