Hi Florian,

It worked . Thank you for your help. Much appreciated.

Hey Flo . Thank you for the response. I am working on it with the idea of yours. I will let you know when done..

Hi Matt,

I had figured my problem last week. What I did was executed one of the server option for this server to be the distributor..

The linked server was configured to...

Any Ideas Guys??

Not a problem Colin.. I do the same. I actually did it and it was very simple. Just used cursor to loop through a table where the filepath is...

I can ping to this server and I do not think the network is the problem..There are other server as publisher they working fine.. What else can I try?

Hi Colin,

Can you please tell me what this " ServerLocal.dbo.ServerParameters WHERE ParmName='BackupPath' " is basically is ? I simply executed the procedure and function and try to run the proc...

Colin when I executed the proc it did not understood Serverlocal.dbo.serverparameters

IF @GroomPath is null

SELECT

...

Thanks Colin for the reply to this thread. I was looking at the code and try to execute the proc but did not work. I am only concerned with the...

Gail will If I turn on that flag will it show me the graph of the past like it was occurred yesterday... I have not worked on trace flagss so...

Hey Atul,

If I need to investigate why it was choosen as the deadlock victim where do I start? This is the second time I had this error. Last time it...

Don't worry guys it was the setting in the agent properties.. Max rows allowed was 50,000 and when I query msdb.dbo.sysjobhistory then the rows reflected was the same.. I have...

Hey Perry,

How will you query the system view to find out which foreign key is effected? What I did was dropped the foreign key that was available with the select...

Hey Gail,

I have a same database in one of my pre-prod server which is currently dead. I can work on this server to fix the database. So, can you tell...

It is around 20 G