You can revoke the delete permissions from the required tables. Just grant them insert and update, this will solve your purpose. If they will use any other tool also there...

At a command prompt, run the following command:

"%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /Remove"

Uninstall the SQL Server components one at a time until all the SQL Server components are uninstalled.

Note Add or...

Also please check if you have distributor_admin user created on all servers (publisher, subscriber and remote distributor (if any)). If this is not the case even after running sp_link_publication, then...

Also you may have to use the below:

sp_serveroption 'ServerName', 'rpc',1

Hope this helps.

error message 'Not configured for data access' can be fixed by running

sp_serveroption 'ServerName', 'data access', 1

change ServerName with the name you have created linkedserver.

Please let me know the exact...

SQL Server 2005 Books Online (September 2007)

sp_repltrans (Transact-SQL)

Returns a result set of all the transactions in the publication database transaction log that are marked for replication but have not been...

First move log files back to the E drive and remove the look up parameter T3608. Please let us know if your database is restored to previous state

There can be multiple reasons around this:

1. Is there any replication set up on the server, if yes, is it running fine?

2. Do we have any job or stored proceudre...

When a SQL Server user executes a command prompt command using xp_cmdshell, the command must execute in the security context of a Windows account. If the SQL Server user is...

There are changes in DBEngine features from SQL2K to SQL2K5. You can try to change the cusrsor type as per the table given in below link.

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

Using a correct...

Make sure MSDTC running on both machines, the error shows there is problem in linked server and communication between the servers is not getting established. You can check this by...

It has to be related to the shadow copy. It may not the exact problem that you are experiencing but similar.  The KBB article is 828481. shadow copy trying to access the database...

But still if you want to migrate the DTS packages, you have to install a option during installatio of yukon. If already installed you can just upgrade it also. Then...

How to: Work Around COM+ System Configuration Check Failure in SQL Server Setup

If SQL Server Setup fails, Setup will roll back the installation but may not remove...