Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790:...

Gila,

Version and compatilbity levels are same?any other thing to check.

one more question if the data file is growing rapidly wat the solution its taking more space.

alteast log files we can...

I am shrinking database once in a week.

The job is scheduled to run once in a week.

pls tell me how to fix this error wat i have mentioned previously.

Main issue is here the path problem change the path like D:\backup\ give the file name and try it will run and remove the old path if u r using...

yes u can take backup to remote machine by sharing the path in network through TSQL we can take backup.Try it i am doing that only.

you can specify path...

I created for remote machine through remote login access

its working for other sql instances also,but only for one instance its not working.

Hi,

1)If u want to know whether log backup is failed check sql server event error log.

2)Then if job is scheduled check job history same as if maintainance plan is scheduled...

CREATE PROCEDURE sp_replace_value (

@strcvalue varchar(100),

@strdesc nvarchar(100)

)

as

update testtbl set value=@strcvalue(anj@test.com),desc=@strdesc where value=@strcvalue('test@test.com')

here i am not getting any error its showing zero rows effected.

in where...

hi grant see my sp pls and help me

CREATE PROCEDURE sp_replace_value (

@strcvalue varchar(100),

@strdesc nvarchar(100)

)

as

update testtbl set value=@strconfigvalue,desc=@strconfigdesc where value=@strconfigvalue

here assume we have value...

yes grant thanks for the help

but i need one more help pls

like this procedure only ,can we pass oldmail and new mail as parameter

exec updateemail @oldmail='anj@test.com',@newemail='grant@test.com'

here we have...

Hi steve,

Actually i am a dba,i have adminstration,but i dont know development so only i am asking u.Pls help

steve,

good examples and i have read in Bol also.

While saving the SSIs packages ,in the last combo box select the option rely on sql server storage and save it.

and then schedule the job it will run fine.

Actually we did the query tunning but still that query performance is not gud still getting timeout error.

I actually wanted to know in which or situation we are using full...

Regarding database u need to monitor database growth by checking data and the log files how much its growth,especially log files increases as it logs all the operations.Monitor that for...