shobha.aradhya (12/24/2012)

I have the below code

declare @ret int

DECLARE @XMLFile varchar(255)

SET @XMLFile = 'C:\myfile.xml'

exec @ret = master..xp_FileExists @XMLFile

When I execute this its throwing error

Could not find stored procedure 'master..xp_FileExists'.

When...

Then, may be problem with data

have u updated with my procedure.....(missing columns included in insert for trans table)

do one thing....

post rate value which u get from another table in...

Dats good point Eugene Elutin..

check is there any update/insert triggers on trans table are created or not

alter PROCEDURE usp_update

@pcid int

,@ppid int

,@ptid int

,@pqty int

AS

BEGIN

SET NOCOUNT ON;

DECLARE @Rate int

SET @Rate = (select prate from M_PRDT where PID=@ppid)

IF EXISTS (SELECT cid FROM trans WHERE cid =@pcid and pid=@ppid)

BEGIN

UPDATE trans

set...

Please post the table structures which are participated in the procedure

Thanks for ur replies..

Can plz suggest... which is better from SQL Server or From Front End (.Net)????

Hi,

you can set at the services level. Go to SQL Server Service Properties..

On failure ,you can run a program that should send an email. ( batch script or...

Hi,

When you go to job history, you can find the 3 steps under the job....

i think u have seen top step in those 3 steps...

if you click on...

I have identified the problem on next day of this post 🙂

Thank You 🙂

Hi ,

I have configured the Maintenance Plan for T-Log Backup for every 2 minutes for a specific database( We can set multiple databases ).All T-logs are saved as...

Hi,

You can give permissions to another logins(Not admins) to trace through SQL Profiler.

Go To that login, select properties. and then go to securables

there you can...

Thanks for all for ur replies.

Dear Elliott W.

I want make data saving in encrypted format. then even though backup also having encrypted data. So...

BACKUP LOG DBNAME TO DISK = FILEPATH

oh..sorry....the above link was for to upgrade to 2008..

Find the link below..

http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en

Hope u can get it.

all d best

Ganesh