Thank you all for the responses.

And how do we draw a parallel between indexes and statistics(updated/not updated).

Ex: Something like a query which gives me an index and its statistics and...

• This reply was modified 4 years, 4 months ago by mtz676.

Hello @Brian,

Method1 :This works:
Data is encrypted upon insert.
USE MyDB;
GO
OPEN SYMMETRIC KEY SK1
DECRYPTION BY CERTIFICATE C1;
GO

INSERT into 
[dbo].[SQLCredentials] 
([Server],
[Password], 
[Password_Encrypted]) 
VALUES 
(N'ABCXYZ ',N'sdf^jh&k*',ENCRYPTBYKEY(key_guid('SK1'),'sdf^jh&k*'))
GO
CLOSE SYMMETRIC KEY SK1;
GO

USE MyDB;
GO
OPEN SYMMETRIC...

• This reply was modified 4 years, 6 months ago by mtz676.

Thanks @Brian for the detailed explanation and your time.

Hello @jeff,

We use MAPS to collect SQL inventory from all servers, but MAPS cannot be automated.Are there any other free tools which can scan our network periodicaly and identify for...

• This reply was modified 4 years, 6 months ago by mtz676.

Thanks @jeff for your time and the elaborate answer.

• This reply was modified 4 years, 6 months ago by mtz676.

@jeff,

Thanks for the feedback but my question was how do I autoupdate the decommisioned column using a query or some script that says the server is decommisioned ? My actual...

Additional column would suffice.

Thanks, I will start with what you suggested.

FYI..All I trying to get was something quick and dirty...then build onto something more correct and in line with DB designs. I do...

All I meant was you picked up what exactly I wanted to get done....eventually..Thanks

• This reply was modified 4 years, 7 months ago by mtz676.

Exactly , thats what you are looking at.

Thank you

@Brian,

.

Are CTE's reallt the way to go for this . Every time I execute the stored procedure they are probably going to generate min(2 rows) or max...

• This reply was modified 4 years, 8 months ago by mtz676.
• This reply was modified 4 years, 8 months ago by mtz676.
• This reply was modified 4 years, 8 months ago by mtz676.

@Brian Gale.

That would update all rows where Q=1 in the table which is not what is needed.Every time the stored procedure executes it will populate the same table with as...

I am not fixated on a while loop.Anything more efficient will work just fine.

CREATE PROCEDURE [dbo].[ABCD]
(
@M int=0,@D int=0,
@F int=0,@Q int=0,@T datetime,@R int=0,
@RR datetime = NULL,@IO int=0
)
AS
BEGIN
DECLARE @I int = 1
DECLARE @QC int
SET @QC = @Q
DECLARE @Tm DATETIME
   BEGIN
...

• This reply was modified 4 years, 8 months ago by mtz676.