Congratulations Steve!!!

First of all, I have mentioned that it can be done in a single script file, but can't be. Sorry for that. You will need 2 script files.

Now coming to...

If it is pretty small then you can follow this:

1. Take backup on server.

2. Copy backup file on remote machine (laptop).

3. Drop the existing DB on the remote machine.

4. Restore...

I think the following sequence should help you:

1. Execute sp_adddistributor on master db of distributor.

2. Execute sp_adddistributor on on master db of all publishers.

3. Execute sp_adddistributiondb on the distributor.

For parameters...

What is the size of the database?

How many users wants to access this database from their laptops?

Let us know the answers of these question so that we can provide a...

I had faced the same issue twice or thrice on my test server. That time I just restarted the SQL server service 🙂 (as it was a test server).

Did you try googling?

- Check whether mixed authentication is enabled on your remote server.

- Check whether the windows user has rights to connect to that server.

and do google it..

I am also interested in knowing the alternate solution.

Anyone?

You can try the following approach:

- drop the subscription only for the article that refers to your table. (sp_dropsubscription )

- drop the article. (sp_droparticle)

- drop the table.

Let us know if...

same way..

sp_helptext 'UDFName'

Should have mentioned in the first post...

If there is no data in the table you can use ALTER TABLE...

Also, you don't need the outer cusor:

DECLARE

@liDepLinksID ...

Which transaction you want to rollback?

The earlier UPDATES that you made on UDMLastTransaction when the condition was true in the loop...?

OR/AND

the processing done by the pr_UDMAssetValuesReport SP when the condition...

use CONVERT or CAST function

CHECK (LEN(RTRIM(LTRIM(columnName))) >= 32)

I would also suggest you to please go through the CREATE TABLE syntax in BOL.