I use table aliases in my queries all the time.  All of us at my office do.  I don't recall that we had that warning in the UA when we...

It might if you're being inconsistant.  Such as prefixing with the table name in the WHERE clause if you're using table aliases in the SELECT statement.

And it's only made worse for those who are trustworthy when the few "rotten apples" get their escapades published nationwide.  I've read at least 5 stories in the past 3 months...

Here's a thought.

Orders table contains the summary version of the order.

OrderLines table contains the individual detail lines of the order including an FK to OrderID.  That way you can have...

We use method two.  Since it is possible for one tables ID field to be used in more than one other table, method two makes it easier for us to...

Sorry, I should have mentioned that my last comment was for Steve.  It seems odd to me that the Upgrade Advisor wouldn't work if you didn't have Windows Admin permissions.

Has...

Did you really mean to say SysAdmin? 

I ask because the original post was about Local Admin Permissions on the Windows OS (Administrator rights) which isn't exactly the same thing...

The backup for the Master Key requires a CONTROL permission on the database.  That tells me the person has to be a SysAdmin, DBOwner or a DBBackupOperator.  I don't know...

That's just it.  Qwest would "get your permission" when you cashed the little checks they sent out.  Or if you competed in a contest they were sponsering or even if...

I definitely have to agree with your second comment there, but you forgot to mention the free swag.  @=)

Okay, I found the word.  I had the # of syllables wrong, though.

What Qwest was doing was called "slamming".  You can find a detailed entry for it at Wikipedia.

No.  There was actually a term for it that was uniquely different from fraud and scam.  It was like 4 syllables long and it had never been applied to anyone...

When we installed SQL 2005, we were unable to split the .mdf and .ldf files.  We could change the base location of the DBs, but couldn't split up the files. ...

Okay, now that's just weird.  I had never noticed this behavior from SQL Server 2005, but you are absolutely correct.  When I only specific one column in the SELECT (out of...

I haven't tried this, but you might investigate setting up a DDL trigger on the certification events.  Or check the other DDL Events and Event Groups to see if something...