View Complete Post
SQL Server 2005 SP2. Push Replication. One publication. One subscription. Distribution on publisher.
The Replication Monitor shows 800k commands waiting to be delivered in the distribution database. The subscriber database is up to date. This has been ticking up since I reinitialized the subscription two days ago.
The following query:
undelivered = sum(UndelivCmdsInDistDB)
MSDistribution_status s with (nolock)
join [db].dbo.sysarticles a
on s.article_id = a.artid
group by s.agent_id
Agent_id 1 and 2 are virtual.
Are these two pieces of info related? I am concerned that the distribution database will grow. I am trying to figure out replication, but it has been tough. Any help is appreciated.
When we remotely manage a SQL 2008 instance the Database column in Activity Monitor is Blank, but when connected directly it shows up. We do have one user where the database column dose populate but he cannot remember if he did something to fix/enable it
or not. These users are logging into this SQL server to get this info instead of managing remotely which I would like them to stop doing but I need to resolve this before they can since this info is critical.
I cannot imagine it is permission related since the column is blank for me as well and I have sysadmin rights over the instance.
Hello all, I'm new to asp.net and I'm currently practising some few stuffs. I'm creating a hotel reservation system using ASP.net Web site in visual studio 2008 and I currently don't have an App_Data in my solution explorer unlike visual web developer.
1. I have planned to make users of the website login before making their reservations.
2. I have also planned to develop the website such that I will be able to know all reservations made by each user.
First and formost, I will like to know how I can access/View the security database?
Secondly, how do I link my custom made reservation database and the security database in order to achieve my second plan above.?
Someone help me.