In this Ourid is having int values and Faclity having char values

I want output where faclity is a and b having same our id column value

eg: a=2

...

Thanks For you information...

Can you please help on this too..

----------------------------------------------------------

I was skip a transaction in Transactional Replication. I followed these to skip a transactions which is mentioned in the msdn...

Because i want to report to monitor my server health.

so did one ssrs file run on different servers and generate pdf files/???

Thanks a very much dude...

In the caseid i have duplicated values.

Hi this is table values

Investigation_IdCase_IdInvestigation_NoteDateTimeTeam_IdStatus_Id

31101050282Testing Testing Testing 2011-01-26 11:45:00.000 2 1

51101050282sample 2011-01-26 00:00:00.000 ...

Thanks alot for your suggestions.!

Is there any way to find out using scripts, how many transactions are delivered from Publisher to Distributor and Distributor to Subscriber.

Can You suggest a book...

Hey

I have also same problem. Did u get any response, if u know any thing to do, please let me know..

DO i need to create any job for this query to run continuously..?

If Yes, This will effect any performance issues to my server.??

thank for your help.:)

Once we execute a query, in which location it is stored, and how many days it will be in there.

Can we set an option to stay a long or any...

Thank You ,, 🙂

There is any way or query to find the execution of queries,

I need a last 10 days queries which run on my sql server..