i check in that table, that table is basically contains records for all log entries for the database, right now it contains 25 million records. so i need to talk...

How often are your Transaction Log backups running?

LOL, true...been a very busy day here at the office 🙁

It doesn't. But...

Okay, so your larger index is about 45GB (math could be wrong on that but I think that's right)

Is the DB in simple or full mode?

Recommended changes: Remove the restricted...

Something like this (you need to run per DB)

SELECT

i.name ...

What options are you using in your INDEX scripts?

If your initial file size is 94.6GB and you have the autogrowth increments set to 500MB...and you have the file size capped...

It's an integration services control "- Slowly Changing Dimension"

SSIS - SQL Server Integration Services (similar to DTS in SQL versions prior to 2005)

BCP - Bulk Copy Program (http://msdn.microsoft.com/en-us/library/ms162802.aspx)

@suresh - fixing the row at the subscriber would be your easiest method

If you find you must take a new snapshot of the article, make certain you disable the immediate...

Are you wanting to see only SQL Agent Jobs or as damodharan has already provided,...

What have you tried so far? Please post your code...

(1)-add code to save current data to a set tables (archive) before importing, if user decides to roll back, this set of archive tables set can be used for rollback...

Wow, I really thought this post would have generated dozens of replies by now! Must be Friday 🙂

The OP says Windows Authentication is OK, it's when they log in with a SQL Server account that they get the error...this has no bearing on AD