Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-09 : 08:02:29
|
| Jeff writes "Hi - I was wondering if it's possible to determine if replication is currently in progress from a stored procedure." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-09 : 09:03:37
|
| What do you mean 'in progress'?That it is set up and there is an active publication? or records are being copied at this moment?Jay White{0} |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-09 : 09:05:49
|
That's rather vague  There are a lot of system stored procedures that can tell you just about anything you want to know about repliaction. Look in BOL index for system stored procedures, listed, scroll down the page to the replication procedures section . Also you can check the status of the various jobs set up by replication using sp_help_jobHTHJasper Smith |
|
|
|
|
|
|
How to determine replication from stored procedure