Freaking beautiful! You made my day!.

Have a good one.

Thanks Erland.

Personally I prefer to have the results show up in the same pane as execution - one less step/keystroke to get my answer. Starting with the SSMS/VS integration...

Thanks for the ideas, GSquared.

In this case it is more a curiosity than an issue.

A coworker copied a table [foo].[bar] from database A to database B. I knew the...

Guilty as charged. I fell for this in a production environment. It was a particularly difficult bug to find. I Did not recognize it was doing the implicit conversion as...

Thanks Jim!

That led to

"GRANT Database Permissions (Transact-SQL)" http://msdn.microsoft.com/en-us/library/ms178569.aspx

which by far was the simplest answer.

Was not familiar with the granularity available (and it helps to know...

Thank you, Jim, & you're correct it is seemingly a simple issue. I'll check it out in the A.M.

Thanks again,

Joe

Thanks Eric, I kept @ it.

@ GSquared: agree but something about management decisions ...

Solution: (my own ignorance ... )

When setting permissions on, say a role or a...

Follow-up: per articles such as this ("SQL Server Best Practices – Implementation of Database Object Schemas" http://msdn.microsoft.com/en-us/library/dd283095%28v=sql.100%29.aspx ) it does indeed seem possible, per the documentation and example,...

@Adiga - I agree, at times I miss the old 2K QA IDE; what a great, simple tool w/ the option to use EM, just a stripped-down power...

Huh, your example is even a bit more curious. I figured that the 2K5 engine does not like the "SELECT a, * " (original post)...

Hey Lee, Sorry for the delay.

Here is my solution. It may not be the best but it works well without creating any other objects (i.e. temp...

Hello Lee,

Can you provide a data sample? It kinda sounds like

ID      Desc      Qty     Dt

533     someone   100     05/01/2006 12:15:13.000

534     notone    (15)   ...