GOT IT. I ran

sp_dropsubscriber 'servername', @Ignore_distributor =1

then

sp_dropdistpublisher 'servername', @Ignore_distributor =1

then

use [master]

exec sp_dropdistributor @no_checks = 1

GO

Then I was able to recreate the distributor DB

thanks! 😀

GOT IT.

SOLUTION:

In my service Broker there where emails with Q's on them, after deleteing them I was able to drop the user. :-D:-D:-D:-D:-D

Nothing shows up. There has to be a way for force a drop user.

thanks gor you help.....

Leisha

I can't use the version because I am already on .net 3.5.

any other suggestions, please I really need help on deleting the user!:crying:

I know but how do i find out which ones? 😀

No errors in the Replication Monitor? Checkk the event veiwer to see if yopu have log in failures. Also make sure the user you have put in the pub and...

Okay no takers! I see. Well it all came together, I let it run over the weekend came in and it created my publication. Now I assume that the one...

1. F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ImportRepository\wicgcdemo".

this path is on your local machine not your test servers.

2.1 copy the flat files to a drive on the test server and reconfigure your ssis...

So you have you columns in the excel sheet? 🙂

It would write you a script and delete out what you do not need so yes it would be the quicker way. Just look over the script before excuting it....

I would export them out to flat files and use ultredit or wincompare (ithink that's was it is called) find out what you don't need and delete them out. easy...

have you renamed you mdf and ldf files from the database you are trying to restore? Are you using sql backup restore or redgate?

leisha

Terry,

Not going to happen in a format fashion in the message sending out. Why would want to put errors in the message of an email anyway? I would put...

Create an excel spreadsheet that matches the colums you are try to pull. This should make the message go away and you can map your columns. Be sure when you...