This is a good solution. Thanks but when I tried it in SQL 2014,

I did not see error message that we have supplied in trigger, instead I m getting this,

"Logon...

Thanks but we can not declare a variable inside view so have to use ## only. Thanks.

Thanks a lot.

Thanks but we can not add diff backup in our environment. thats how this environment is since sql 2005, 2008 and now 2014 is the only one that started giving...

Hi... How do I attach a screenshot in my question? When I clicked on image---> but how do I insert there? I dont want to make attachment.

Ohh thats a great idea. However I tried something like this and it worked as well but i like ur solution much better. Thanks again.

SELECT @ScriptPer...

Thanks a lot for the quick reply but I think i did not explain very well or I did not get what I wanted.

Here is what I want to see...

Thanks for the explanation guys.

Okay Thanks a lot Steve, IF you know any link that demonstrate the same using some example or if u can show me some example then I really appreciate it....

Okay So that works in config file.

Does this same format also works inside ur codes that u write using VB,C#,ADO.NET etc ??

Are each IP on a different NIC? --->I am not very sure as not much knowledge but what I know is we will have 3 different IP addresses for the...

Thanks alot Steve.

We requested our Network team to create one more DNS entry and hence we have total 2 I\P for that box.

In future we will have 3 instances...

Okay It worked when I used -n switch.

And I wrote a cursor so it works.

But I have all different extensions like jpg,doc,zip etc.

It only works for PDF files...

Okay Thanks a lot For your help.

Here is the working solution I created

DECLARE @FileName varchar(50),

@bcpCommand varchar(2000)

SET @FileName = 'c:\dod\authors_06-04-14.doc' --REPLACE('c:\dod\authors_'+CONVERT(char(8),GETDATE(),1)+'.doc','/','-')...

Okay Thanks a lot. I will try that soon and let u know.