and the resulting costs mean that keeping our DR in house is the cheapest option. We operate out of two data centers in the UK, one in London the other...

I need some links if you can share. Please don't mind. I want to learn.

I can provide you some details as required, if you take personal interest? Please share your...

Hello Gail, based on your answer, Could you please let me where to go for consultation? If you don't mind, can you guide me some material for research myself. The...

Thanks for reply. We have a different (new) product for which we are looking MIS tool only for BI management reporting purpose. They use Cognos for their existing live...

I tested this with the following query:

Begin tran A

update TL_CST_Account set AccountTitle = 'Shamshad-windows' where AccountId = 10001000010021

The idea is, if we are running an update on a table...

A peer of mine is saying when we use updLock, it uses Primary key and so the practice of using PK should be forcefully used in all update statements with...

OK, will study AlwaysOn feature. but what about those who are on 2008? How are they handling this situation? Do you think high availability will provide high performance on a...

Thanks, can you please explain a little more? with a diagram of infrastructure. We are on 2012 and can move on 2014 if beneficial?

Shamshad

Agreed, I have decided to use Crystal Report and its service to automatically send my reports in any output format that i give using command line with given parameters and...

I saw the video and I know this. Thanks. My question is how do i automate subscription here? Is Reporting service subscription API or any TSQL available? it ask for...

Yeah, I fixed it myself like following, Just wanted to share it so that others can get some help from code below:

Alter Proc CustomerMonthlyActivityComparison @Year int, @Location varchar(50), @CustomerId int...

did not get reply since a week now... please see my last questions in continuation with my original question...

i am using VS 2012 for desktop application, My question is how can i use report viewer in my desktop application to generate reports. Is MS giving any reporting tool...

Hi all,

Thanks for help. I got success to download file locally using script task, but when I try to import this text file data through BULK insert script or through...

I do not understand this, How this will help me in SSIS, if some one has a complete solution, please share, if there is any better suggestion available, please share...