I've always felt that the only way to truly assure security is to have the network cable unplugged and the computer in a lockable room.

The trade-off, however, is no good.  The...

When I need proactive information (info I want before I need it), there's always the daily SQL Server Central e-mail.

When I need reactive information (got a problem, need a fix...

The securist computer is one not connected to a network and behind a locked door.

A friend just bought a PowerPC based dual-proc Mac and got me to thinking...

An article on how Apple's the only computer maker to care about the end user, Windows is...

I'm not going to talk about the kid's grades other than to say I agree with Mark Yelton about the pay period notion.

I'm more interested in the next to last...

I've had some difficulty with this myself, but it's not too hard to accomplish.  My situation involves something similar - I have one stored proc which returns different shaped record...

Number of records is not the most significant measure of index performance - it is selectivity of data.  If your attribute table contains only a few different attribute types, while...

10 More Influential (but not always in a positive way!)

Martin Luther King

Franklin D. Roosevelt

Albert Einstein

Adolf Hitler

Winston Churchill

Ronald Reagan

Mikhail Gorbachev

Robert Oppenheimer

Orville & Wilbur Wright (I know, technically two in one slot...)

Henry...

Thanks for the help - that's exactly what I needed!

Have a great weekend.

Carter

Ditto - when I tried with table aliases, I get

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near 'middle'.

as I'm sure all the rest did as...

1 - They're fun;

2 - They'll look great on a resume!

Hope this helps!

I ran into a similar problem when porting sprocs and udfs.  I was using the Copy SQL Server Objects Task in DTS to send tables, views, sprocs, etc...