Part of the credit to Jeff and Tom 🙂

I think that objective is met, at least in my case 🙂

especially when you are looking at them in early morning :hehe:

Questions on new features !! Thanks..

By default as well as ALWAYS primary key is not null and unique, some other constraints (like a check constraint)on a primary key column may be reasonable.

What is the additional...

@Andy - Waiting for your next question. This question was useful, I have gone through almost all the options given in the answer before clicking on 'None of...

@auke - And together we learn by sharing our mistakes. Thank you for sharing the question.

Even though -m is the direct answer, -f too places SQL instance in single user mode. BOL states this as " Starting SQL Server in minimal configuration mode places SQL...

Even though this is a simple one to remember, when strings are taken from a table ample are the chances that this behavior would be forgotten.

Lowell (3/7/2014)

---

i chose None of the above, because the AD group does not have the domain in the command, making it invalid.

--no such user or role

/*

Msg 15151, Level 16, State...

Still remember the pale face of a report developer who wants his data sorder in descending date order, but it was showing...

My mistake, shame on me for the silly mistake of the additional keyword 'End' at the end in the question ( as pointed out by some of the members) ...

From the information that is given , I believe you are trying COUNT the assets based on the YEAR groups in which it is.

The general solution for this problem...

Please refer the link on CREATE TABLE :- http://msdn.microsoft.com/en-us/library/ms174979.aspx

--------------------------------------------------------------------

Copying the permissions section from the link for easy reference

Permissions:-

Requires CREATE TABLE permission in the database and ALTER...