What do you mean "I removed it from the publication" ?

Did you delete the publication ?

If the database is truly not used in Replication, or you need to temporarily mark...

It's no problem with Snapshot & transactional replication ..... Don't know about Merge, but I don't see why not.   In my case, DatabaseA is a publisher of tableA and a...

I've had the same issue once in a while, with no clue as to why. A job can run for weeks with the same owner, then just fail out of...

Hi Sushila !  Long time no see .....

Are you suggesting I read the post properly before giving a response ??   Hmmm  I'll think about it.

You want an actual "Linked Server" ?  Or just trying to send data between the AS/400 and SQL Server ?  We used regular DSNs without much trouble a while ago,...

All our pivot tables execute SQL Stored Procs. That way you don't have to do any code maint in the Pivot table, and if users want to 'Save As" their pivot tables...

I share your thoughts on replication's "strangeness" at times, although I think adding keys should be safe. I would set up a little test scenario that mimics your Prod environment...

Here's what I think

1. Are you referring to J Woo here ?  If so, I think it's true ...  IF you're publishing from just 1 server to multiple subscribers....

You have to restrict growth on the first file (mdf). When it fills up to the size you set, sql will start using your ndf.

If you can't figure out the script, then you can use this little trick I've been doing sometimes. I recently started using SQL 2005 on my desktop to manage my...

However, you can get it back if you have a backup of your database that contains it.

Restore your database ("PROD_DB") as "PROD_DB_GetTheSP_I_Mistakenly_Deleted" ....  ok .... maybe a shorter name ......... ...

This question seems to come up every week or so ...... did you search the existing posts ? Look for "huge log" etc ...

Is your db in FULL or SIMPLE...

I found reference to the command "sp_replrestart" that seems to have helped get my log reader job going again (I had saved a script of the job so I could...

Thanks ... I guess I'd prefer the default to be "never expire". 

It looks as though I have to drop what remains of the subscription & recreate it using the...

Nevermind....... A developer had put triggers on the subscription tables, but there are errors in the triggers that reference field names multiple times .