How to make a column clustered

Here is my create table command

CREATE TABLE EXCLUSIVEITEM(VIEW_ID INTEGER NONCLUSTERED IDENTITY(1,1)PRIMARY KEY,
VIEW_LATEST_REPLY_DATE CLUSTERED INDEX DATETIME)

Is this the way to create one of my columns clustered. The books that I have all use stored procedure I only want to use regular sql commands. Is this possible?Indexes are clustered, columns aren't.

Can you post the assignment as you received it, or give us a URL to it? I'm still not clear on what you're trying to do, so I'm not much help in doing it!

-PatP

how to know if sqlserver is clustered

hi,

can u tell me how to find out sql server is clustered or not using sql dmo (c++)

Is there any method or property that i can use to find out if sql server is failover cluster

Use the Cluster Server APIs for this:

http://msdn2.microsoft.com/en-us/library/aa373104.aspx

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Check out the IsClustered property under Server.Information - here's a code sample:

Dim srvMgmtServer As Server
srvMgmtServer = New Server("MyServer")
Dim srvConn As ServerConnection
srvConn = srvMgmtServer.ConnectionContext
srvConn.LoginSecure = True

If srvMgmtServer.Information.IsClustered = True Then
' Do something here
End If

Hope that helps.

|||yes we have it in server properties i got the required information..

how to know if sqlserver is clustered

hi,

can u tell me how to find out sql server is clustered or not using sql dmo (c++)

Is there any method or property that i can use to find out if sql server is failover cluster

Use the Cluster Server APIs for this:

http://msdn2.microsoft.com/en-us/library/aa373104.aspx

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Check out the IsClustered property under Server.Information - here's a code sample:

Dim srvMgmtServer As Server
srvMgmtServer = New Server("MyServer")
Dim srvConn As ServerConnection
srvConn = srvMgmtServer.ConnectionContext
srvConn.LoginSecure = True

If srvMgmtServer.Information.IsClustered = True Then
' Do something here
End If

Hope that helps.

|||yes we have it in server properties i got the required information..