Hi Shawn

Thanks for the info, but it is not what I am looking for.

What I am looking for is the script from the role to be able to...

What "GUI" are you talking about?

I am using SQL server Management Studio. There is the menu (clicking on the right button of the mouse) with "Script data...

I was so sure I knew the right answers that I would have bet on it! Good thing I did not as I got it wrong :blush:

I have the...

+1

More please, I...

Wow! SuperDuper! It does exactly what I needed

Thanks a lot 🙂

yes, but which one depends on how you fill and how he fills in a specific moment :blink:

It is always easy when you know. I did not even knew the command DBCC CHECKDB ! I had to search... but yes, it was easy to understand...

I agree on categorizing people. It is a surviving thing inside each of us from being eaten by some animal or being beaten by... well, some animal too.

I agree...

Hugo Kornelis (11/10/2011)

---

Because the bug is not introduced by conversion only, but by...

Why the quey works fine if I remove the "order by 2" if its a conversion bug?

select fileid, name from sysfiles intersect

select file_id, name from sys.master_files

where file_id in('1')

Hugo Kornelis (11/9/2011)

---

But the reason of the bug is because the query is done on the master or because there is "a non-explicit type conversion on the right hand...

I got it right because the only thing that looked wrong for me in the query was the "2" in the "ORDER BY": there were no column names "2" :-)...

bitbucket-25253 (11/4/2011)

---

A good question,... So congratulations to the author as the QOD not only tests ones knowledge, but teaches those who do not know the subject and this question will...

DugyC (10/28/2011)

---

Although, like 71% (at this time) of the others, I got this wrong because I was thinking Full-text indexing on a table can be disable/re-enabled. The question, on re-reading,...

L' Eomot Inversé (10/27/2011)

---

... So maybe the case for most...