Are you executing the query from Query Analyzer from say a client machine?

There are trade-offs with both types of schema. Here is some more info from Microsoft:

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part5/c1761.asp

There's also a reach article about why snowflake makes a good data warehouse design. Haven't...

Try here:

http://www.microsoft.com/sql/reporting/howtobuy/retailfulfillment.asp

I don't see the argument here and I'll explain why. Before the release of reporting services, you got a full-blown license of SQL Server and SQL Server Analysis Services. That's...

Chris is right in that those looking for a quick "hit" will scan only well-known ports, but the serious person will scan 'em all. We do. Also, just because SQL...

I stopped by Void's cube. This one can be solved by converging Field3 in a derived table and then performing a rollup from that derived table.

As they say, respect the rank, not the person. The rank and command structure is in place to make dissemination of orders and reacting to loss of commanders as much...

Hap Arnold is considered one of the founders of the modern US Air Force and his buttons are authorized for what we call our mess dress (looks like a tuxedo...

Mine is a dragonfly on top of a daisy. Something I photoshopped together a while ago. When the avatar came up on this site, I chose it over the Hap...

But the avatars are nice. Love the Charlie Brown.

Check the account first, failing that, what events are recorded in the event logs? Look for Service Control Manager events.

They still make those things? And I thought my ever increasing collection was going to be priceless one day.

Do you have the other two registered in EM or as an alias?

Hey Gary,

Generally most users hit Active Topics and see the list of all new topics. Therefore in the future you only need to post once. Someone will get to it!...

1) Yes, multiple people can map into dbo. Also, there is a fixed database role called db_owner. Multiple users can be a member of that role.

When creating objects, those mapped...