A thought.  I like the concept of 'MCDBA-Enterprise' or 'MCDBA-Replication'.  And please excuse the shoddy verbiage/logic, I was woken up by a neighbor's drunken screaming match with her BF and...

Wow.  That is amazingly spiffy!  Thanks very much for posting that, Noel, I'll be sure to spread it around our department!

Just take all of the joy out of my life!

And here I've been developing this query

CREATE view dbo.vzTableColumnNames as

select o.name as TableName, c.name as ColumnName, c.ColID,

 t.name + '(' + rtrim(cast(c.Length as...

Good article reference, Frank (and congrats again on the MVP!)  I did not know about precedence of when the WHERE clause gets evaluated between the two forms.

This begs a question...

I was hoping someone might have replied to you, it sounds interesting.  What exactly are you trying to accomplish?  Are you talking about compressing images or large text files for...

Try using a field of shortdatetime or datetime data type with a default of now() (or is it getdate()?).  That'll give you an insert time stamp, you can use an...

Very cool, except I don't have sufficient permissions to run it as a developer.  I'll have to try it on my laptop some time.  Definitely a useful implementation for doing...

This is where naming conventions and prefixes come in handy, I can instantly differentiate between tables and views when I'm managing connections.

It's also advantageous to have your objects owned by...

This is why I'm not a fan of using Maintenance Plans.  I much prefer to code all the jobs myself so I get detailed output.  When I'm in DBA mode...

Unfortunately, Sebastiano, your code doesn't work, and I'm not certain why.  It double-counts the NOs and produces incorrect results.

The results of your query produces this:

ownerid  nocnt      

-------- -----------

1           4

2           0

3          ...

Thanks, Cliu.  I knew there was a more elegant solution out there.  I seem to have a mental block against using expressions in FROM clauses, I need to do some...

Well, I have a solution but I’m not sure how much I like it.

/*

create view vParentStatus as

select OwnerID,...

What OS are you running?  You should have no problems on XP Pro or Win2K Pro, I wouldn't bet on (or try!) WinXP Home as it's largely an extension of...

I just noticed that it looks like you can use the shortcut to insert date or time, but not both.  It seems that it clears the field contents before inserting...

Interesting.  So they partially implemented something that they've been doing in Access for years.  You can also use Ctrl-Quote (single or double) to copy the same field value of the...