Sounds good to me but unless I am not responding with an answer to the original thread I wasn't sure if it would be appropriate to get into someone's thread...

Thanks @Johan.

I settled with this...

CREATE TABLE #Results (
     abc VARCHAR(MAX)
 )
INSERT INTO #Results
exec sp_msforeachdb '
Select ''
USE [?]
GO
CREATE DATABASE AUDIT SPECIFICATION [DatabaseAuditSpecification ?]
FOR SERVER...

Thank you

No infact it has more memory allocated

@Grant and all

Thank you

@Grant/All,absolutely, the advise I have received from this community has been unparalleled.Learnt a lot from here and I rely more here than the web.

Initially the DB was not a true...

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

My bad ,I understand. Thanks again @Grant.

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

@scott,@Grant,@Steve, All

We have again done a straight back and restore across enterprise to standard.Under what circumstances can the execution plans be different.Both instances run on same windows and do not...

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

Stats were never updated on both the versions (standard and enterprise).Both stand 2 years old.Checked some tables which are referred in the stored proc.They stats are the same.

Looks like statistics...

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

@steve-2 Jones, @Grant and all,

Thank you.

I have saved the execution plans from enterprise and standard edition. How can I force the stored procedure to use the enterprise plan when I...

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

I did nothing.They just became readable.

Thanks

@steve-2. Thanks

What settings/config values should be checking in Standard and enterprise (fyi:both on same machine)to troubleshoot this.A back and restore has been done from enterprise to standard, so data stays...

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

Thank you @Grant and everybody else.

Can a Stored Procedure(has several parameters as input) run differently in standard or enterprise version when executed from SSMS when compared getting triggered from the...

No more an issue

Thank you everybody.

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