My last post just gave me an idea!

It looks like you can set

/p:ExcludeObjectTypes=ColumnEncryptionKeys;ColumnMasterKeys

when calling sqlpackage.exe.   I'll try that!

Hi,

Thank you for the reply.  I'm happy doing the initial encryption manually,  it's more the on going maintenance of the database that's my issue.

From my tests so far,   the...

Update statistics?

Done some more testing and it appears that yes..

* If a select statement deadlocks whilst in a transaction then the tran count is 1

* If an update deadlocks whilst in...

I personally think it's a bit misleading, as couldn't it be argued that in the first case that the trancount is actually 1?

The main thing is however that we don't...

Me too :unsure:

Have a look at the dense_rank() function.

by the way, depending on what you are trying to do there are other ways of passing lists of parameters into a stored procedure. for example xml or...

You need to surround the fruits with '

i.e. '''Orange'',''Guava'''

DECLARE @SQL AS VARCHAR(MAX)

DECLARE @OrderList AS VARCHAR(MAX) = '''Orange'',''Guava'''

SET @SQL =

'SELECT Fruit,Price

FROM dbo.TESCOS

WHERE Fruit IN (' +...

SELECT Col2,

MAX(CASE Col1 WHEN 'A' THEN Col3 ELSE '' END ) AS A,

MAX(CASE Col1 WHEN 'B' THEN Col3 ELSE '' END ) AS B,

...

two things wrong with the sql. You need to add + ' WITH ' + to the second line. And the exec command needs brackets.

Declare @StrSql varchar(1000)

Set...

As it's currently written your sql will only work if you have a single database listed in your backups table.

I think I would use a cursor to loop down your...

yes forget the trigger idea that was daft. I think the check constraint meets the requirement however.

Rows with an ID < 200 can have a null created date

Rows with...

or better still

create table test

(

idint,

create_dtdatetime null default getdate(),

constraint ch check (id < 200 or create_dt is not null)

)

go

thought you might say that!

you could have a default constraint to cover your existing stored procedures which don't supply the column.

and then a trigger to prevent someone doing either insert...