I think this is useful when you need to nest transactions. For example if you had three sections and you wanted to commit 1 and 3 together and rollback the...

From BOL

";number

Is an optional integer used to group procedures of the same name so they can be dropped together with a single DROP PROCEDURE statement. For example, the procedures used...

Ok so now I know the difference and also that a synchronous script component is faster. When would it be useful to use an asynchronous script component instead of...

While I agree that quite a few QOD questions are poorly worded, I found this question very educational. I was unaware of this change and I maintain code that may have to...

Did anyone notice the space between the path and the file name in the first staement?

BACKUP\ myBackup_FULL.bak'

           ^

-Kevin Williams

Remi,

No. I think that you were right/wrong in the end.

-Kevin Williams

The BOL states that "SQL Server automatically creates a UNIQUE index to enforce the uniqueness requirement of the UNIQUE constraint."

So if a clustered unique index is implicitly created along...

I'm unfamiliar with transactional publication. What insert stored procedure is being referred to in answer D? Is this something automatically generated by SQL?

-Kevin

Wow!!! I sure am glad I found that out. I can't tell you all the coutless hours I spent toiling over this issue. I'm sure glad you cleared that up.

How about this?

select a.idno + 1

from tablename a

left outer join tablename b on (b.idno = a.idno + 1)

where b.idno is null

Kevin Williams

DTS Packages are stored in the sysdts tables in the msdb database. You can backup that database or you can save each DTS package as a Structured Storage File.

-Kevin Williams

You mean CHECK (minit like '[ A-Z]' and minit is not null) ?

Also, when I test this in query analyzer i am allowed to insert an empty string ''. Am...

I don't think there is any way to do this in a single query. I would select into a temporary table grouping on CASE_NUMBER and getting the min CLAIMANT_NAME, summing the CLAIM_AMOUNT and...

In development it is a physical file. When you release it to Reporting Services it is stored in the database.

-Kevin Williams

Reporting services does have a directory structure so that you can organize all of your reports as desired. You can publish the report to any folder you like when you build...