Or, instead of running in SSMS in sqlcmd mode (great idea, btw), just go and run the scripts in sqlcmd directly.

Definately not. The key is the key is the key. Whatever you have as the primary key in the parent table, that should be the foreign key in the related...

They almost describe themselves. A SQL Login is a login defined within the SQL Server system itself. It doesn't have existence outside of the SQL Server instance on which it...

GSquared (10/6/2009)

---

You can gain a lot of potential table names if you use Latin names (genus species style) as well as the vernacular. Extinct animals are a great source...

Lynn Pettis (10/6/2009)

---

Grant Fritchey (10/6/2009)

---

RBarryYoung (10/5/2009)

---

Woo-hoo! Back in 6th place. 🙂

Now all I need to do is to keep this up for three years... And for at...

Bob Hovious 24601 (10/6/2009)

---

Thank you for clarifying that, Grant. I was up to 'Zebra' in my table names.

But I haven't started using dinosaur names...

RBarryYoung (10/5/2009)

---

Woo-hoo! Back in 6th place. 🙂

Now all I need to do is to keep this up for three years... And for at least four people to...

What everyone is trying to say, just not in so many words, is, you need to look this stuff up for yourself. SQL Server comes with documentation. It will supply...

You've got two choices. First, and probably best, you need to leave all your databases in 8.0 compatibility mode until the production upgrade is completed. That way, none of your...

Ha!

Good...

rhunt (10/5/2009)

---

Yes, I've considered that...let me bounce this off you. This server is Win2003 R2 32 bit Enterprise with 3GB switch and AWE enabled with 10GB RAM.

Two things I've...

CPU usage within Profiler would not be a good measure for overall CPU use within the system. It's only going to give you information about the execution of the procedures...

It's also a lot faster to learn the TSQL. Once you know how to type out the RESTORE statement, you'll find that it's quicker than trying to click your way...

The management pack is an XML definition. You can read through the XML directly to see the list of rules & monitors. I meant you could go there.

I tried searching....

Performance Monitor (perfmon) and dynamic management viewws (DMV's) are best. You can also browse the trace events from a server side trace on the client machine using Profiler. I would...