Oh,

I'm sorry Parthy, I missed the IDENTITY_INSERT ON/OFF statements.

your query works for me. thanks

Best Regards,

Ami

Hi Grant Fritchey,

I didn't mean it. I need a starting point(that why i mention ignition). I take your suggestion. Let me go through Kalen's book.

Thanks a lot,

Regards,

Ami

Before going for a live data base what are the things we need to consider and steps should be taken as a vibrant intuitive DBA?

On memory utilization, space, Performance tuning,...

Wow Craig,

Thanks,

Just now I found out the mistake and thought of posting the answer.

You are so quick and posted before me.

Thanks a lot,

Ami

Hi All,

Thanks for everyone's input.

What ever you use sys.objects or information schemas the sp_OAMethod gives the script with the old SP name only.

When you right on...

Hi,

DECLARE @SPName VARCHAR(150)

DECLARE CURSCRIPT CURSOR FOR

SELECT name FROM SYSOBJECTS WHERE XTYPE = 'P'

DECLARE @oServerint

DECLARE @methodvarchar(300)

DECLARE @TSQLvarchar(4000)

DECLARE @ScriptType int

EXEC sp_OACreate 'SQLDMO.SQLServer', @oServer OUT

EXEC sp_OASetProperty @oServer, 'loginsecure', 'true'

EXEC sp_OAMethod...

Hi,

SELECT * FROM SYSOBJECTS WHERE XTYPE = 'P'

output of this query gives the new SP name.

My problem is while getting the create script for the same gets created in old...

Hi all,

Thanks for the inputs.

I've checked in 2005. the Script Procedure --> Create gives the correct modified SP name. But while creating from the mentioned script it is...

Hi Sachin,

thanks for responding. as i mentioned.

My objective is to update a set of tables across the network on a timely basis.

it is for updating price details of certain...

Sorry,

I think I have not explained you clearly.

I have the same username in the Servername-->Security.

I'm able to map to other Dbs in the same server. but not to a...

yes it exists.

and I'm able to give permissions for other DBs. But not to a particular Database

-ami

i'm trying to get what Paul is saying. but in first case and else part it is giving 1.

where 1 =1 satisfies i get all the rows.

by the way

for...

Thanks to Eugene and mthurber nice and easy way of achieving it.

by the way, Mr. Paul, i still don't understand the logic behind it.

SELECT * FROM Tbl1

WHERE 1 = 1

If...

Hi Paul,

It's working. Actually I found a round about way & accomplished.

declare @t1 table(type int)

if @type =0

begin

insert into @t1 values (1)

insert into @t1 values (2)

end

else

insert into @t1 select @type

select...

Hi,

I would like to get result like

1abcdef

2defdef

3ghidef

4klmdef

5klmklm

where the relevant names for the orderedby and receivedby staffids.

thanks,

ami