That's not a problem.

When you create the table, or add a column, you can specify the start value and increment of the identity column

CREATE TABLE TestTable

   (Col1  int  IDENTITY(100, 2)

  ...

As far as I know, a database can not be easily moved without removing replication.  Neither detaching the database nor backing up, dropping, and restoring with move will work.

Perhaps you...

It seems like you want to execute this query aginast several databases.  Is this the case?

Assuming so, you have a few options:

1.  Use a WHILE loop or a cursor to...

Your database design has a foreign key between the table voucher_header and another table, likely named customers.  Voucher_header a child table and has a cust_no that references the Customer table.

The...

To get output information from dynamic SQL queries, use sp_executesql instead of EXEC to actually execute your queries.  The technique is to write your output to a variable which is...

If you truly need to pass in the db name as a parameter, the only way I know how is to use dynamic sql, either with EXEC or sp_executesql.

Can you tell...

Chuck,

Check out Microsoft's white paper entitled:  "Transactional Replication Performance Tuning and Optimization" .  It's got best practices for replication performance and some case studies (being published in 2001,  it's a bit...

Are there foreign keys that reference this table?  Deletes have to check each child table to ensure that foreign key relationships are maintained (by restricting or cascading the delete).   I...

No, unless you've got a backup with the version you want to recover.

Scott Thornburg

Volt Information Sciences

Yes, it is possible. I have such a partitioned view with a text field in production with no problems.

Assuming that you did not explictly indicate DISTINCT in the sql defining the view,...

SQL 2000 does not allow the syntax:

select  A.columns, B.columns

from    TableA as A

  join  dbo.MyFunction(TableA.ID) as Bon ...

However, you will be able to get this in SQL 2005...

David,

Any ad hoc query that is cached will give a Cache Insert and Cache Hit events, and apparently assigns an object id in doing so.  For example, set up a session...

I'm not fully sure what you are intending with the FLD = '0' piece.  Do you only want to update those rows if there is a row in TableB that...

Paul,

As your subject heading suggested, the problem is with nulls and equality.  With standard defaults for SQL SERVER (ANSI_NULLS on) it is neither true that null = null or that...

The standard answer to this type of question is that this is something best done in the client, not at the SQL Server level.  

But in cases where you can't...