This script returns a complete set of replication information.

SELECT DISTINCT

srv.srvname publication_server

, a.publisher_db

, p.publication publication_name

, a.article

, a.destination_object

, ss.srvname subscription_server

, s.subscriber_db

,...

Put the results in Temp Table from the Source and Fire In query as SQLSACT suggested.

Sql Server Agent also must be running with user credentials, check whether that credentials are right !!

Try starting SQL Server Agent with administrator priviliage and password, I guess your Sql Server Agent is running on Local System Account.

Googled it.. and found the solution

Check this out....

http://support.microsoft.com/kb/320499">

http://support.microsoft.com/kb/320499

Thanks

Instead of passing the output back to OLDB Source (i.e. I am assuming you are taking about Front end code's here like .net C# or vb.net etc...) you should process...

Try this...

SELECT CASE WHEN StartDate IS NULL THEN 'N/A' ELSE CAST(DATEDIFF(dd,StartDate,EndDate) AS varchar) END Days

50 Instance for Stanard and Enterprise, Only workgroup edition allows 16 instances.

Check the Data, whether you have a data for said months, if there is a data it should reflect in graph too..

Connect the SQL Server instance in Single User Mode and try restoring it.

How to Start Instance in Single User Mode.

Open Sql Server configuration Manager -> Sql Server Services -> Sql...

This is because your connection pools are overfilled or some of the connection not closed properly which is not in use, try killing the unwanted connection using SSMS.

duplicate post, already explained to your previous post.

manoj.ramaiah (5/27/2013)

---

Can you please give me the query based on the columns IntermediaryPK and ParentIntermediaryPK ? So it should return the output, If any invalid parent is there...

Create a SQL in a Variable and execute using sp_executesql procedure.

You can apply a Check Constraint on ParentColumn where ParentColumnId <> MainId.