Sometimes restarting the SQL Services will not clear the killed rollback state. Please restart the server. It will get cleared.

Regards

S.R.Kundur

I think it is not possible, you can also have at the below link.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/4daae3e5-15ab-4929-a122-e1bab420310e/

Regards

S.R.Kundur

There are many ways to trnasfer the data,

1. Use insert into Server2.dbname.schemaname.member

select * from Server1.dbname.schemaname.member

2 use SSIS import data import

3 use the merge statement to update the data.

Regards

S.R.Kundur

For checking the blocking you can also use when you get this timeout issue.

Select * from Sysprocess where Blocked >0

Thanks

S.R.Kundur

Thanks Perry I have completed the setup

Sorry emadleiman47,

Its My bad I think I misunderstood your question.

It appears that the Advance Express Edition of 2012 also does not include SSAS components. Please check the below link and...

Always ON

Regards

S.R.Kundur

Which edition of SQL Server 2012 are you installing and on which version of OS?

Regards

S.R.Kundur

I mean to say Click on Start Menu--> All Programs --> Microsoft SQL Server 2012 --> Open SQL Server Data tools, Once it is open you can see the...

Are you able to see SQL Server Data Tools in the SQL Server 2012 installed folder?

S.R.Kundur

Could you please check the Data type and Length of the datatype used are same on Source and destination?

S.R.Kundur

Please check whether there is a network breakage or packet loss to the Server machine where SQL is installed.

Regards

S.R.Kundur

If you are using SQL Server 2008 and above, You can use the Inbuild reports which gives you the long running queries for all the Databases.

Regards

Srikanth Reddy Kundur

Can you please provide us a step by step notes to perform this. I am not able to configure them.

Let me explain me the scenario

I have created SQL Server 2012...

Hi

The link which was sent to you in the first thread was correct for creating a SQL Server Instance alias. After creating the alias, reference it by using the...