thanks for the reply.

yeah refreshing the view will solve the issue but when i query the view after adding a column to table, i get the following result.

c1c2total

533RobinNULL

655SteveNULL

Column Total values...

Thanks a lot Perry...

Do you have any microsoft document or link , i need to provide it to my manager ?

Thanks for the quick response.

Thanks again...

i understand and i'm aware if i change the threshold we can get rid of this alert. But we have't seen this alert previously what concerns me more is...

Also, do you know is this an issue with replication latency or kind of idera SQLdm bug ?

Thank you very much...

I'm 100% sure i ran it on the correct server...btw i ran your queries on distribution database....is that correct ? I dont have access to subscriber, its...

Also when i run sp_replcounters

Fyi, we have 2 publishers in our instance

i get the output as

replicated transaction = 0 (for both db's)

replication rate trans/sec = 66.66 ( for one...

Thanks again...

in Idera SQL Dm...we are frequently seeing the following alert and its been active...

2298 unsubscribed replication transactions received by the Distributor and not received by a Subscriber.

and i just...

Also, Can anyone provide me the script to find out list of commands in distribution that were not replicated to subscriber..

fyi, i do not have subscriber information.....we only need to...

MyDoggieJessie (6/8/2014)

---

You need to determine possible causes of the high count... It could be you've got to much going on on the publisher/distributor (you infer that these are on the...

durai nagarajan (5/12/2014)

---

is this ''domain\xxxxx'' is your service account?

if it is are your sure it is Sysadmin in that server, looks like it doesn't have access to the DB as...

Thanks for the response...

The database xxxx doesnt exist....i'm not sure where this connection is coming from....

Thanks for the explanation Wagner...

With the following query..i found the database size as 292 GB...

Restore filelistonly from disk = 'X:\xxxx.bak'

george sibbald (4/11/2014)

---

there are two ways around this I can see - a simple workaround would be run the query so the output is in text mode, does that suit??...

Ok thanks guys i got the following script which serves my need....

-- List out all users and user roles of all databases in a SQL Server instance

Declare @name varchar(100)

Declare @sqlstatement...

Thanks George....

I need the users in...