We cannot pass a table variable to a stored procedure. The alternate way I used is to create a temp table and delete the data at the end of the...

Actually we did that, and the vendor came back and said "Ignore it". I dont know how I can ignore it when the Backup jobs are failing because of this...

Thanks a lot for your help. That solution did work for me.

I still get the following error :

Server: Msg 7313, Level 16, State 1, Line 1

Invalid schema or catalog specified for provider 'MSDASQL'.

OLE DB error trace [Non-interface error: Invalid schema...

Actually one of my co-workers just admited that he messed with the log_shipping_monitor table in msdb database and he made it to point it to wrong server, thats the reason...

Even I thought so, and backuped but the databases and restored it on destination server with norecovery. Then I backed up the transaction log, ran the copy and restore jobs....

Great!! That worked.

Any idea what was the confusion over here ?

why in EM I was seeing a different ID as a DBO while 'sa' was the actuall DBO ?

'SA' is mapped to 'DBO' ( as I can see in the user list ).

But when I right click on that database -> properties -> it shows the database owner...

I actually meant :

sp_dropuser 'sa'

Server: Msg 15008, Level 16, State 1, Procedure sp_dropuser, Line 12

User 'sa' does not exist in the current database.

Thanks.

I was using :

xp_sendmail ....,@attachment='t:\..'

and I was getting this error :

Server: Msg 18025, Level 16, State 1, Line 0

xp_sendmail: failed with mail error 0x80004005

Instead of that I tried to use...

Thanks a lot to all you guys for your inputs.

I am running a optmization job every night.

Could that be causing my differential backup to be as large as database backup ?

Thanks.

I am doing a INIT, so it should not append. Also I am doing it on every night.

And also I am not using a device, I use a file name...

This is a Development Server and users do need/have DBO privileges. Even if I am able to restrict it to certain amount it would be great.

Thanks for your responses though.

...

Even I had a similiar kind of problem. Granting the proxy account, read/write permissions on temp directory did help. As mentioned my

Steven, it was a bug in SP1 that...