Very strange. I'll try to test this a little later if I have time, but I wonder what happened. All I can think is that the package got resolved to...

That's a good question. Did you check and see if SQL Server moved anything itself on startup? If it's working, I'd note it for yourself and the rest of the...

I've been to Vancouver twice. It's a big city, spanning across the water, and I really liked it. It's expensive, but people were nice, lots of public transport, beautiful, clean,...

Seems like lots more uses for the spatial stuff than I imagined.

I thought of another last night.

What about some type of lottery/contest application that allows people to register/enter/purchase...

I'll admit that I hadn't thought about retention when read this article, so very good points about how long to keep things.

I've used optical jukeboxes, but they were problematic from...

The maintenance plans in 2005 are stored as SSIS packages, and I think the connections are buried in there. They should be in msdb, so you can get them there.

I'd...

OK, I accidentally marked this as published instead of pending. I'll remove all answers, and you can re-do this one on the 15th.

I guess it made sense to me. I...

I approached one employer about this when I found that they didn't really need a 40hour a week DBA. They did need some on-call, after hours support, and I said...

The compatibility mode changes the way keywords are handled in SQL Server. There were lots of words that were valid in v6.5 that became reserved in v70 and above (ie...

Interesting numbers.

So are costs higher in physical businesses or are software companies taking advantage of their lower costs and charging more? Is there value in what they're providing?

If you have the 2005 client, the SQL Native Client, then you put two entries in there for the mirrored servers and they automatically reconnect if the primary has failed.

http://msdn.microsoft.com/en-us/library/ms366348.aspx

It's...

The newsletter is new each day. We don't have things go from day to day, except perhaps the forum threads, and those reappear if they've had a new post in...

Block the users from the database with the firewall. More rules, not so elegant, but it solve the issue.

Right now, there's no way to change this. There have been suggestions...

Perhaps put them in a separate filegroup? Maybe then work with that separately?

Or add an "image" filegorup, put the data in, then add another one at some point, delete the...

There was a way in SQL 2000 to perform an MD5, one way encryption of data, and ENCRYPT() works on my SS2K instance.

However this cannot be decrypted. You can "compare"...