Just keep in mind there is a difference between being the dbo and being in the db_owner role.

Andy

http://www.sqlservercentral.com/columnists/awarren/

My guess would be yes, but only a guess. I use transactional, rare need for merge. Having a backup seems wise! In general considering you're setting it up all over...

Try this one:

http://www.microsoftgear.com/Default.htm

You going to use both keychains at once? Take a big man to put Larry & Bill in their pocket at the same time!

Andy

I dont see anything obviously wrong, according to the sample in BOL it would seem to be valid syntax:

DECLARE @SearchWord varchar(30)

SET @SearchWord ='Moon'

SELECT pr_info FROM pub_info WHERE CONTAINS(pr_info, @SearchWord)

I just...

If inheritance and sub classing are must haves, any .Net language is worth considering too. Seems like the learning curve would be higher for VB.Net over VB6, but if you're...

Jon usually handles our full text search stuff, I sent him a note. If he's busy one of us will dig into it in a day or so!

Andy

Something close to this:

update B set A.ProdName=B.Prodname from TableWithName A inner join TableWithoutName B on A.sku=b.sku where b.prodname is null

Andy

Sp_replicationdboption supports @ignore_distributor as a param, I'd give that a try. Sp_dropdistributor has a similar switch. See if either of those help, let us know what happens.

Andy

What error did it report? Look at the maint plan history, not the job history.

Andy

Best practice is to have all objects owned by dbo. You can either create them and later change the owner, or you have to be the dbo (db owner) of...

Both strike me as strange situations to happen. Whats the chance another app on the same server would try to open 1433? I've seen this happen on my 8 proc,...

Yes. Instead of triggers are slightly different than after triggers in how they handle text.

Andy

The easiest way to do so is to set it up via the wizards/Enterprise Manager the first time, it has an option to let you script out the entire replication...

I've never had it happen so far. Then again, I dont have many server crashes. Even when I have had bad shutdowns I've never had an error. Perhaps lucky so...

You can configure the number of error logs. It keeps growing until you restart the service or use sp_cycle_errorlog. I set a job to cycle it daily at midnight, keeps...