Hi Robert,

Thanks for quick reply

Can u give information on, when we execute a query in SSMS, will it be maintained a record in system tables of master data.

if object_id('') is not null

drop procedure dbo.Usp_AddPhoto

go

create procedure dbo.Usp_AddPhoto

(

@p_StdID int,

@p_Photo image,

@p_output int output

)

as

begin

Declare @err int

begin tran

if exists(select 1 from tbl_Registration_Master where datalength(photo) =

datalength(@p_photo) or substring(photo, 1, 8000) = substring(@p_photo,...

Hi,

I stopped the user who is accessing the database and now i am getting the following message

Server: Msg 3201, Level 16, State 2, Line 1

Cannot open backup device '\\xyz\Databackups\ddd.BAK'. Device...

Thanks man

I have created a maintainence plan.

I have one more question. Do you any idea about reading xml file in sql server 2000. I have worked on reading xml data...

Hi pradeep,

Could u brief me about maintainence plan, bcoz i am new to database administration

Regards

Durgesh

hi,

As my requirement is to update other column when status is changed to 1. So, how can I achieve this

Looking Forward

Regards

Durgesh

hi,

when status is set to 1 will the update trigger will fire

Regards

Durgesh

hi

if my table is as follows

col1 col2 col3

aa ram b

bb ram a

cc ravi ...

hi

if my table is as follows

col1 col2

aa ram

bb ram

cc ravi

dd rahi

and i need the output as

col1 col2

bb ...

hi ss

It works fine if col1 is integer, but if col1 is varchar then it is not working

hi ros,

i have a transaction table

col1 col2 col3

a 1 a1

b 2 ...