Some new additions:

Msg 15137, Level 16, State 1, Procedure sp_xp_cmdshell_proxy_account, Line 1

An error occurred during the execution of sp_xp_cmdshell_proxy_account. Possible reasons: the provided account was invalid or the '##xp_cmdshell_proxy_account##' credential...

Problem solved ... thanks to myself ..!!

I would say, we cannot restore backup of 2005 onto 2000. NO BACKWARD COMPATIBILITY. Altough look for yourself if there is any option available when backing up the database, to...

Thanks

When i executed this on the desired database and reattempted the debug, it gave the folllowing error message:

Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1

[Microsoft][ODBC SQL Server...

Thanks SQLBill,

But this means that nobody can debug a SP at client end, it is only possible at Server machine. What I think about this is a little upsetting thought, as...

Thankyou all, specially Lakhani. The problem is solved! I guess it was due to some corruption in the MSC file. Thankyou all.

Regards,

Rehan

Hey guys thanks for your help... the problem is identified and solved ... it was an exception in the code of the trigger that occurs only for the last row...

sorry my fault ... i removed a table from the select list for easy understanding ... consider A=B .

HI,

Well I had this problem ... SQL Server provides two DBCC commands 1. DBCC Shrinkfile 2. DBCC ShrinkDatabase ...

for your full recovery ... take backup of transaction log .. and...

I am archiving the data manually, using some stored procedures. What kind of backups/restoration techniques are required in order to archive date and restore it later on, without effecting existing...

Hi Frank,

I am not into taking transactional backups yet. Can you please teach me how to accomplish this kind of backups and restoration ... i will be thankful to you...

i think that transaction log is not required ... but i want to restore data from backup without over-writing existing data in the database ... without overwriting the current data...

Frank...

hey here is the situation ... please advise how to do this kind of backups...

initially table(s) data

RowId - RowData

1 - ...

Hi there. Kalis please tell me full procedure for making a backup and restoring it over current database without lossing current data.

reply quick

😉

Thanks Frank... you proved to be a Guru for me ... solved the problem at once. (k)ool ...

but tell me what is the reason for a single User Connected to...