PRAMANA.DBA (9/10/2014)

---

Sean Pearce (9/10/2014)

---

PRAMANA.DBA (9/9/2014)

---

I did below steps,

dbcc traceon(1204)

DBCC TRACEstatus (1204)

TraceFlagStatusGlobalSession

1204101

restarted SQL then i replicated deadlock , in log not showing any thing about deadlock , after that i have...

Makes a huge difference in terms...

PRAMANA.DBA (9/9/2014)

---

I did below steps,

dbcc traceon(1204)

DBCC TRACEstatus (1204)

TraceFlagStatusGlobalSession

1204101

restarted SQL then i replicated deadlock , in log not showing any thing about deadlock , after that i have verified status...

Without trying to sound anal, it is a Where Clause and not a Sentence.

No, query_hash and query_plan_hash are not the same thing.

MSDN - sys.dm_exec_query_stats

query_hash

Binary(8)

Binary hash value calculated on the query and used to identify queries with similar logic. You can use the query...

I see 4 correct answers.

ashish.george (8/18/2014)

---

the only problem is that what all changes made to 2008 is reflected on the 2012 DB,

u try creating a new Test Db on 2008 and u open 2012...

Using RAISERROR with a severity level of 20 will disconnect the session immediately.

IF (@@SERVERNAME='Prod')

BEGIN

RAISERROR('Incorrect Server', 20, -1) WITH LOG;

END;

GO

That article says:

For more information and examples of INSTEAD OF triggers, see the documentation for your database server. If you are using Microsoft SQL Server, see "INSTEAD OF" in SQL...

So your abstract definition is correct then?

mayankminawat (8/13/2014)

---

This is printing everything in one line:

SET @BODYTEXT = ' Dear ' + @fname +',We realize you may have taken ' + @course_due + ' in '+ @month_last_taken +'.'

...

That's the outer feed for a nested loop so estimated number...

This will fix your error message

create procedure a as print 'It Works'

go

declare @a nvarchar

declare @b-2 nvarchar

set @a = (select 'a')

set @b-2 =...

There is a free tool called database browser which exports to Excel the way you want. It's available from ETL-Tools.com.