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...
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...
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...
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...
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
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...
February 22, 2005 at 11:30 pm
sorry my fault ... i removed a table from the select list for easy understanding ... consider A=B .
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...
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...
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...
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...
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 - ...
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
😉
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...
November 25, 2003 at 4:47 am
Viewing 15 posts - 1 through 15 (of 19 total)