DBCC CHECKIDENT (<tablename&gt --Resets the ident

Max limit on the number is the max value of the column, in this case int so 2,147,483,647....you could...

I'm not aware of any way to reassigning that port, however you could limit the traffic allowed access through that port to certain IP addresses or subnets.

You could try using @@identity, scope_identity is new to SQL2k

http://www.developerfusion.com/show/3704/2/

Unless you have a site license or select licensing agreement or you will be using large amounts of memory I would not go with Ent Ed on the standby due...

If you subscriber to SQL Server Magazine they have an article with a UDF that will actually just go and remove either the numeric or non-numeric characters from a string...

There is a log shipping monitor, which is a nice little graphical display that tells you whether or not your logshipping is outside your specified deltas, however there are better...

In the trace properties you could remove everything from the events to trace other than Lockseadlock and Locks

Have you thought about running a trace against the server to capture the textdata information so that you can go back and see what that spid was attempting to execute...

Populating the table just adds rows, this is best used as an identity when doing an insert. If you wanted to insert against more than one table for example and...

Whenever you insert a record. You create a proc to just return an incremental value by using a procedure and scope_identity(), which you could then use to populate another table

create...

Did you check the string the is executing the job step? You could be using the /U switch with the SA user and pwd.

Within the DTS I would also check...

Here's what I did....

Make sure that the account you are logging into the machines as is an Admin on both boxes and the cluster so that it can access all resources.

Fail...

When you create the table use the identity for the column definition

CREATE TABLE testuser (THE_ID_COL INT IDENTITY(1,1))

You can change the 1,1 to reflect changes in either the starting number, or...

From the command line

OSQL -L

You can only run the Maintenance plan logshipping from Enterprise to Enterprise, that does not however stop you from running a manual logshipping deal. If you do a search on...