It won't in the case of numeric fields. One thing that can be done is to specify a DEFAULT constraint for the given column. For instance:

CREATE...

You're welcome. Information Schema views can come in handy because we can avoid the system tables with them.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

If you want to use Information Schema Views:

CREATE PROC usp_GetPrimaryKeyCols

@Table sysname

AS

SELECT C.COLUMN_NAME, C.DATA_TYPE

FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU

JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC

ON KCU.CONSTRAINT_NAME = TC.CONSTRAINT_NAME

AND KCU.CONSTRAINT_SCHEMA = TC.CONSTRAINT_SCHEMA

AND KCU.CONSTRAINT_CATALOG = TC.CONSTRAINT_CATALOG

JOIN INFORMATION_SCHEMA.COLUMNS C

ON...

Correct. Row locator is a generic term given that a non-clustered index could be build upon a heap or upon a clustered index. Row locator with regard to...

If they expanded T-SQL so we could code front-ends... nah, too many structures would have to be added. But seriously, by opening up to .NET, what it does mean...

You might give a look at Compaq's Active Answers site at:

http://activeanswers.compaq.com

They have sizers on the site for the Proliant systems, both for SQL Server 7 and 2000, and for OLTP...

Chris, one thing you can do is check syscacheobjects between the first and second times you run the query to see if an entry got added that is applicable. ...

Nonclustered indexes contain the value (for the nonclustered index) and a row locator to the data row having the data value (or rows if the data value is not unique)....

As Steve has indicated, the decryption routines do exist, people have figured 'em out. But through Microsoft's provided tools there is no way. For instance, going through EM...

BTW, I should mention that isql works, too.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

One thing you could use (though you'll have to do a little cleanup) is use osql and the sp_helptext system stored procedure. For instance

osql -E -S MyServer...

While it is true that the multiple instances won't talk to each other directly and yield directly to each other, the way SQL Server dynamically handles memory with regards to...

Out of curiousity, how is performance accessing via Query Analyzer?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Not yet. But remember, Yukon will support .NET for stored procedures. As a result, it has the potential to significantly impact a DBA's job. We're already talking...

The triggers/constraints issue in SQL Server 7 meant that I had to manually delete from the bottom up with respect to a SQL 7 database I designed. It wasn't...