Viewing 15 posts - 1 through 15 (of 19 total)
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...
- Rattu
March 22, 2007 at 7:03 am
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...
- Rattu
February 8, 2007 at 12:45 am
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...
- Rattu
March 28, 2006 at 5:48 am
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...
- Rattu
March 28, 2006 at 1:41 am
Thankyou all, specially Lakhani. The problem is solved! I guess it was due to some corruption in the MSC file. Thankyou all.
Regards,
Rehan
- Rattu
March 27, 2006 at 7:55 am
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...
- Rattu
February 22, 2005 at 11:30 pm
sorry my fault ... i removed a table from the select list for easy understanding ... consider A=B .
- Rattu
February 21, 2005 at 4:01 am
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...
- Rattu
March 30, 2004 at 7:10 am
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...
- Rattu
December 8, 2003 at 10:59 pm
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...
- Rattu
December 5, 2003 at 9:33 pm
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...
- Rattu
December 1, 2003 at 4:13 am
hey here is the situation ... please advise how to do this kind of backups...
initially table(s) data
RowId - RowData
1 - ...
- Rattu
November 30, 2003 at 10:37 pm
Hi there. Kalis please tell me full procedure for making a backup and restoring it over current database without lossing current data.
reply quick
😉
- Rattu
November 30, 2003 at 9:53 pm
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...
- Rattu
November 25, 2003 at 4:47 am
Viewing 15 posts - 1 through 15 (of 19 total)