What does

DBCC CHECKIDENT (<tablename>, NORESEED)

return?

Here you go:

The fix:

1. Drop the SUBSCRIBER (if exists on new publication server)
2. On the SUBSCRIBER run (see BOL)

a.      sp_removedbreplication [ @dbname =...

image

For the email:

You will want to send the email through your application using SMTP.  I would probably go this route.

or

If you can configure email on the sql server then:

Lookup "xp_sendmail"...

You will need to register the sql server using IP address, not DNS name.  Verify the port in which sql server is running.  This port will be needed (if it's...

Yes, -1 can be placed in a char field.

nice, your welcome.

You can remove the Instance of SQL Server by going through "ADD/REMOVE PROGRAMS".  Select the instance you want to delete.

I've never tried using replication when the publisher and subscriber had different table schemas.  However, you may be able to do it this way.

You may want to try creating the...

Check the sql server service and see what account it is running as.  You may need to change the user/pw of this account, if it's not Local Sytem account.

How are...

A secure method would be to have a VPN key to connect to your network from home.  Then your pc would be connected directly to the network.  The other methods offer...

So now you have 2 backup jobs?  If so, then just delete the first or second job.  Right-click the job and delete it.  If the problem is with the schedule. ...

Yes, you can also generate the script in query analyzer.  Right-click the sproc and select "script to new window as create", or to file if you want.  In query analzyer...

thanks, i removed the dups

Output parameters are also input parameters.  If you do not want to supply a value simply define the output parameters as such.

Your old code:

-- declare the output parameters

@final_peak decimal(19,4) OUTPUT,

@final_date datetime OUTPUT

New (add...