Assuming we're talking SQL Server 2012, you don't have to set the traceflag any more. The system_health extended event session captures deadlock information automatically.

Deadlocks are fundamentally a performance problem. So,...

SMALLDATETIME only runs January 1, 1900, through June 6, 2079. It sounds like the value you're trying to convert falls outside that range. Or, as Koen already said, it's not...

Just a suggestion, instead of granting permissions to a user, create a role, assign that role permissions, add the user to the role. That way, you can give multiple users...

John Mitchell-245523 (6/10/2014)

---

vijay.singh 14112 (6/10/2014)

---

Hi John,

Please find the error message below.

Msg 3169, Level 16, State 1, Line 1

The database was backed up on a server running version 8.00.0760. That version...

But it's like Karen already said. You can create a table in Azure without a clustered index, but you can't put data into it, so what's the point? If anything,...

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....