I use a batch file that has the necessary steps for the backup process and then schedule the same with the Windows scheduler

One of the assembly was created with Permission_Set = Safe and the other one with Permission_set = UNSAFE. I did try changing both to Remote_Access but it didnt help

Thanks for the input. I managed to get it done. created 2 jobs, the first one to back up and the second one to restore. Each runs on seperate servers....

I came up with an idea of creating a CTE and then doing a final select from the CTE based on the Input parameter. My Select query too is not...

What is the DDL for #tempRespPriceSummary table

Vinoj

Not sure what you are trying to achieve. In my db i have Audit columns on all tables to determine who created the data and who modified it along with...

Thanks for the reply. What if I was using SET XACT_ABORT ON, Do I still need to use the Begin TRAN and COMMIT

CREATE PROCEDURE ...

AS

SET NOCOUNT ON

SET XACT_ABORT...

Could you copy the cursor code here.. It will be helpful

Vinoj

So if i understand correct the best option is to have it in the FROM clause itself, got confused with the replies.

I am also facing the similar kind of issue. I have a database which has 2 schemas. There are 2 development teams and each team reads the data from the...

They are SQL logins. I have already added them to a new role

Once you have identified the slow running query, you could also utilize the Include Client Statistics button located next to the Include Actual Query Plan in the SSMS(SQL Server Management...

Thanks. For some reason when i added the ProductID as the first column of the index and it gave an Index Scan. But when i added it as the last...

Thanks for the help. I managed to figure it out. The datasources are built when the setup.sql is run present in the C:\Program Files\Microsoft SQL Server\90\Tools\PerformanceDashboard folder. This creates a...

Well thats exactly what I tried but, when i take the data tab, it gives an error. DataSource1 not found... Any idea where this is located