Have you checked the default_database settings for this...

You can also use SEQUENCE feature of SQL Server to get this functionality. However SEQUENCE are only available from SQL Server 2012 onwards.

Nice question. Thanks.

Traditional Model:

tEmployees (EmployeeID int,StatusID int)

tEmployeesStatus (StatusID int,StatusDescription (varchar(20))

Proposed Model:

tEmployees (EmployeeID int,StatusDescription varchar(20))

tEmployeesStatus (StatusDescription varchar(20))

Create a UDF that validates the data being entered into the StatusDescription field:

Create FUNCTION [dbo].[fnEmployeeStatusList](@EmployeeStatus varchar(20))

RETURNS...

Beatrix Kiddo (1/9/2014)

---

Right, I realised it should be

which worked.

However, it now won't let me restore the backup because it was taken on the version of...

There is no diference between NOLOCK & WITH (NOLOCK). They both execute the query...

If you only write the backup file name & DO NOT provide the backup directory path, then SQL Server automatically takes the backup in default backup location.

BACKUP DATABASE AdventureWorks TO...

I don't understand the significance of this thread:cool:

Nice article Brian. Thanks for sharing.

plamber (9/19/2013)

---

In my experience using the DMV's allows a DBA to better customize their administration experience as well as develops a better understanding of what is happening rather than using...

Nice article Paul.

Built-in activity monitor too can be used to check the "Head Blocker".

There is a column "Head Blocker" under the Processes tab which returns 0 or 1...

Thanks for the question & for pointing us towards the great explanation available on the SE (by Martin Smith).

You must be overlooking something over there.

I think you should recheck the access rights of the user. May be it is added in some application role that either gives...

Thanks for the article.

PHYData DBA (8/8/2013)

---

Nice article but while reading it I could only thing about one thing.

Why do you call these Myth's?

A Myth is something that people believe is true that is...