Agree with you on most points.

I like the Inner Join syntax. Makes it easier for me to read (not for you, but it does for me). Otherwise, yeah...

GSquared (1/9/2009)

---

You can't restore SQL 2000 system databases onto SQL 2005. Won't work. You'll need to migrate your logins, etc., but there are processes for doing all of...

If I understand you correctly, SQL was installed as part of an application. Your best bet, in that case, is to contact the vendor of the application and ask...

RyanRandall (1/9/2009)

---

I guess you could create a view which is the union of all your tables, and then update the view.

Having many similarly named tables is usually an indication that...

Jeff Moden (1/9/2009)

---

GSquared (1/9/2009)

---

I've seen requests to Microsoft to make having a Where clause on every query be required, with the solution to unrestricted queries that they could have something...

Matt Miller (1/9/2009)

---

GSquared (1/9/2009)

---

I've seen requests to Microsoft to make having a Where clause on every query be required, with the solution to unrestricted queries that they could have something...

gcopeland (1/9/2009)

---

As the resident HR guy, I note a few pretty vicious posts. That is ok, I have been dispensing unsolicited advice to my fellow techies for decades, and...

http://support.microsoft.com/default.aspx/kb/321185

Has data on version numbers.

http://support.microsoft.com/kb/937137/

Has data on cumulative update version data.

I've seen requests to Microsoft to make having a Where clause on every query be required, with the solution to unrestricted queries that they could have something like "Where 1...

I'm not clear on what's being requested. What does a report have to do with how many someone can order of something?

You should also correct the syntax of you create scripts. It's "create table ", not the other way around.

On the normalization, you will need the join tables already...

You can't restore SQL 2000 system databases onto SQL 2005. Won't work. You'll need to migrate your logins, etc., but there are processes for doing all of that....

You mentioned that the server was an instance, but it looks like you aren't using an instance-style server name. Try selecting "browse for more" in the server-name drop-down when...

I'd say check what the monitoring tool means by that. And why is it saying that drive Z has a C-drive filepath on it?

Of course, the other thing this part of this thread reminds me of, is a joke about a newly married couple.

The man tells his wife, "put on my pants". ...