CREATE UNIQUE CLUSTERED INDEX CI_TableC_Col1_Col2

ON dbo.TableC (Col1 ASC, Col2 ASC) ...

Look at books online - search for CREATE INDEX.

Some groups (like our group in Wash DC / Northern VA) belong to other organizations as well.

There's a list of groups on our site (it's probably not a complete list)

Steve,

Thank you for the input. You bring up interesting points. In our local users group (novasql.com), you will find people that LOVE to participate and on the other hand, some...

Just wanted to plug in the following:

You can also use the SELECT INTO clause in order to create an exact copy of a source table to a target table. This...

What size should the restriction be? Keep in mind that Image is simply a binary data type, so if the size you wish to use is not very large (i.e.,...

Is this for transactional replication? If so, did you try to use sp_repladdcolumn with @force_reinit_subscription = 0. Books online (BOL) describe this as the way to disable the reinitialization (but...

Just wanted to plug a comment relating to: "The data stored in the identity columns will be replicated to the target tables, but the identity property itself will not be....

In order to determine whether SQL is listening on the correct ports using the TCP protocol, you can simply run the statement below from the command line.

telnet

For example:

telnet...