You can try to kill the process that is running, but, if it's part of a transaction, then you'll still have to wait for the transaction to complete it's rollback...

Well, I have used Visual Studio 2013 to create a MASD database before, so I'd be inclined to think it might be something to do with your configuration possibly. Maybe...

mikeg317X (6/9/2014)

---

Grant Fritchey (6/9/2014)

---

You are posting in a SQL Server 2008 forum. Since you're using Sybase, you're more likely to get specific assistance by posting the question in a forum...

A full backup records everything going on in the system, all the transactions that are running during the backup process, those that finish, those that don't. It all gets written...

And you see that where, in the properties? No, I can't say that's one I've run into. It sounds like something might be broken. Can you save the execution plan...

I have only seen this error when I run a table creation script that doesn't have a primary key definition. You can't have a CREATE TABLE definition and an ALTER...

You are posting in a SQL Server 2008 forum. Since you're using Sybase, you're more likely to get specific assistance by posting the question in a forum dedicated to that...

What kind of execution plan are you seeing that in? A graphical plan, a text plan or something else?

Basically you can put IF logic within an in-line function to determine which table to query. That way the code refers to one thing, but the function breaks the output...

It could be you don't have the right service packs in place on the 2000 version to upgrade to 2008R2. Do a quick search for the Upgrade Advisor from Microsoft....

There's no easy way to do this, like Kevin says. One thing you can try is to use either views or in-line functions to expose a common object name to...

Red Gate SQL Compare works quite well with Windows Azure SQL Database.

Disclosure, I work for Red Gate.

SQL Server prevents changes from occurring at the same time. It's part of the Atomicity, Consistency, Isolation, and Durabality (ACID) properties of the database. You can't both SELECT a row...

Yeah, of course. Both processes are going to use CPU and memory and I/O. Therefore there's a very distinct possibility that the two processes may be in contention on those...

Extended events is not easier than trace, but it's pretty easy and certainly has less impact on the server. Books Online will get you going.