Hi,

Thank you...its working fine..

Regards,

Ezhilan

Thank you...Gail Shaw. Its working now.

Regards,

Ezhilan

I am just copying the procedure. Not the the database.

Regards,

Ezhilan

Yes..you are correct. In one server it is Case sensitive and in other it is not. It is deliberate. How can we resolve this issue?

Regards,

Ezhilan

Hi,

This is where view comes from...

CREATE VIEW dbo.VW_ATSR_OETC_AUD_HIPO_SIDE_ONLY

AS

SELECT *

FROM OPENQUERY(AM_ATSR_NV, 'SELECT * FROM openmsg.OETC_AUD where INST_BROK = ''I''')...

Hi Sugesh,

I am also facing the same kind of errors,

How to enable xp_cmdshell?

Please suggest

Regards

USE [master]

GO

/****** Object: StoredProcedure [dbo].[RL_ERC_DBA_Grant_DB_INTACT] Script Date: 11/13/2007 01:48:57 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER Procedure [dbo].[RL_ERC_DBA_Grant_DB_INTACT] as

set nocount on

Declare @cmd1 varchar(250),@cmd2 varchar(250)

set @cmd1='osql -SUSXS4001 -E...

Thanks Maverick. Its working fine

Hi Karthik,

I would suggest you to read SQL SErver 2000 for Expereinced Users by Rober Vierra.

This is very Good Book.

Regards,

Ezhilan Ekambaram

Thanks David...

Thanks it is working fine..

I have used..this..

select convert(datetime,convert(char,getdate()-datepart(dd,getdate()),103),104)

Is it OK.

Regards,

Ezhilan

Thanks...

Its working fine..

Hi..

I have one more query...

How about using this Dynamic Query extensively in the procedure..(In almost all the Updates and Inserts)

Will performace gets affected because of this?

Regards,

Ezhilan

Thanks a Lot prasad...

It is working fine..

Warm Regards,

Ezhilan

Hi,

I have modified it...

Still I am getting that error in the line...

/********/

EXEC('Insert into temptable1'+ @sp_id + 'values (10,''XXXXX'')')

/**********/

I think problem should be somewhere here - 'values (10,''XXXXX'')')

Could you please check...