In my experience - just using the word "join" usually tells SQL server "inner join", whereas "left join" = LEFT OUTER JOIN.

And while the results might look a little strange...

It's those little things you don't notice until you want to use them... You're absolutely right.

Learned yet another tidbit.

Thanks!

I'm not sure I understand why you say lookup wouldn't work with a text source (or a text reference). Albeit slower thanks to the lack of indexing, I don't...

There are special procedures to follow if you need to restore system databases.

You will want to read up on there from Books Online. Link is

http://msdn2.microsoft.com/en-us/library/ms190190.aspx

hehe....I hear you Vika - I'm both as well.

On Grant's scale of tolerability, I'm currently falling somewhere between staphilococcus and streptococcus....:)

Well - you can have both if you pay for both, yes. But this is one of those you can't have your cake and eat it too things. ...

Also- if you're not averse to extended stored procedures - you can download the regular expressions support for SQL Server 2000 from the scripts area.

Would make this fairly easy....

Secondary comment - which gets kind of interesting as to the scoping issue.

If the procedure in MASTER is marked as a system stored proc, then it overrides the user DB's...

goran -

That really wasn't called for. Considering we're discussing "best practices" and a rule of thumb that's been bandied about a LOT, talking about what if's is in...

Got it. Kind of what I expected to hear, but the BEWARE in your warning made me doubt myself...:)

Thanks!

There's actually nothing preventing you from attaching the older copy of MSDB as a user database and getting the info out of the table that stores the DTS packages. ...

Holly -

Maybe there's something strange going on, but this is what I get when I go to the link you mentioned:

Products Released General Availability Date Mainstream Support Retired Extended...

I'd second D smith's concern as the the HIPAA violation you have going on. I'd yank that image off of there before you get yourself into trouble.

This might be...

Well - you could either "long-hand" the formula, or - you might consider using the UNPIVOT clause to normalize you data, and then use something like SUM(case answer when 1...

You could try something like this:

Select tables.TABLE_NAME, cols.column_name from information_schema.tables tables

inner join information_schema.columns cols on tables.table_name=cols.table_name

...