Its ok, I learned that SEQUENCE has many more possibilities then IDENTITY but in my case provided link from stackoverflow is best solution there is.

thank you both for your...

RonKyle (6/22/2015)

---

The sequence by its nature would not need to be part of a composite key. It will be...

For surrogate key I was aware it's more point of view to use it or not. Your answer is very good.

I didn't see anywhere example of sequence object in composite...

cppwiz (6/18/2015)

---

First, let me state that my comments are only my opinion and I have no inside knowledge or contact with the Microsoft certification team regarding their plans for SQL...

cppwiz (5/11/2015)

---

You have years to pass all three exams (461, 462, 463) to earn the MCSA. The only time limit will be when Microsoft stops offering the exam. ...

Jacob Wilkins (5/25/2015)

---

Ah, I understand your thought now.

Attaching the database files does not move them to the default data directory. They will remain in the location from which they...

Jacob Wilkins (5/25/2015)

---

Ah, I understand your thought now.

Attaching the database files does not move them to the default data directory. They will remain in the location from which they...

Thank you for very useful post.

Of course I don't want to have database in my Download folder. I understood databases will be in default SQL Server folder because I...

If you give the SQL Server service account permissions on that D drive folder and make sure you set it to replace permissions on the child objects so that the...

Jacob Wilkins (5/24/2015)

---

When you say you couldn't attach it, what was the exact error you were getting?

Also, just so I'm clear, when connected via Windows Authentication, you could attach...

That isn't precise answer. If anyone knows, how to grant access to attach files for 'sa' user.

I cant use this kind of security on work. If I disable Windows authentication...

So, for MCSA candidates will be tested on SQL Server 2012 (doesnt exist for 2014), but for MCSE it will be SQL Server 2014 because that is current version.

Thank you...