Dan,

I'm not necessarily saying that hybrids need to be in IT, but rather that we need these hybrids, and the IT guys could fill some of these roles, if they...

If you upgrade to SQL 7, you can move to 2005.

http://msdn.microsoft.com/en-US/library/ms143393%28v=SQL.90%29.aspx

However, DTS was better in SQL 2000. You ought to be able to restore the database from v6.5 backup to...

I Tend to agree with Craig, and I'd like to see more information about what the entities are, what you are tracking, and what it means in relation to other...

Here's some licensing information from Robert Pearl, who researched a bit of what is out there for 2008

http://www.sqlservercentral.com/blogs/pearlknows/archive/2011/01/24/microsoft-sql-server-licensing-for-dummies.aspx

I did it a few times.

I was the basic DBA, got offered the IT manager position at a small company. That meant I managed the network guy/programmer/contractor, and myself. Not...

Well, had a nice adventure today. Water cut off mid-morning, took my daughter to the doctor so they could diagnose flu, and while thawing a pipe this afternoon with a...

You have distinct, but that applies to the entire row, not just the display name. The account differences are resulting in the extra rows. If you removed a row, how...

I can snapshot the mirror and run dbcc. Is that passive?

I talked with MS licensing and they considered...

Thanks, we've suspended development here while working on a few other things, but we'll be looking to add more info to this app, or another one, in the future.

I don't know quite how a passive server is defined, but all the MS documents seem to say that you get at least one passive server for your HA options....

GSquared is correct. The order of operations has the insert tested and you have a type conversion, without data being moved.

I think it's...

My feeling is that government ought to develop a framework for both more efficient energy generation, and energy efficiency in our use. It only makes sense that we try to...

You can have SSMS create a database diagram, but it's not really a full ERD, and depending on how you have setup RI, it might not be completely correct.

The main...

Ron Porter (2/1/2011)

---

... Finally, since these servers are going to be put into full service only when something else is down, planned or otherwise, I would like to see the...