Here's a quick little script I use.  I was trying to emulate the Oracle DESC <table> command.

SELECT case ORDINAL_POSITION

           when 1 then  left(TABLE_NAME, 25)

           else ' '

       end                               'Table Name',...

Thanks..that is probably the best explanation I could get.  Or could hoep for.   I am seeing some odd results myself and have been hoping to figure it out.

Thanks..............

All of mine do not show up either.  This is because of different domains, a DMZ, and a firewall (see DMZ).

Your first post said "leaving 100% % free."   Is that accurate? 

Steve..

I can do this in Oracle and have yet to find a way in SQL Server.  Is there a way to activate a trigger on login, or create an alert...

Through osal try changing the sa password..you don't need to have thew old password to change it.

The selectivity on the Item+Store+Salesweek index appears to be much better than the Salesweek+Store+Item index.  

A non-clustered index creates more i/o and lookups when accessing the datapage and looking for...

Bill...not sure if I am going to offer what you are looking for.   This is a thread I will probably follow too.   Here are a couple of ideas that come...

Do you have indexes on the Item and Store tables?  How about using an index hint? 

What index did you change to a clustered index when the new table was...

I have a lot of databases out in the field that come in corrupted and have more than once had a 'suspect' database.   I don't have a solution for you. ...

This was a great question!!  Good useful stuff!!!

I have had the pleasure to work extensively on Oracle and SQL Server and thought this thread was great!! Yes, Oracle DBA's are more protective and I think the...

jcool has a good point regarding referential integrity, constraints, and such. This could be an issue, but not impossible. As long as Primary keys stay unique and can...

Another option...

Look at isql and osql.

I hope Yukon overcomes some of the weaknesses of SQL Server. Since I work on both Oracle and SQL Server, my initial response before reading the questions was an...