Forum Replies Created

Viewing 15 posts - 1 through 15 (of 19 total)

  • RE: Job Step Proxy Account not available

    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...

  • RE: Materialized View

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

  • RE: Restore backup file from sql server 2005 to 2000

    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...

  • RE: Debugger not working at client

    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...

  • RE: Debugger not working at client

    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...

  • RE: SP4 & Enterprise Manager problems

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

    Regards,

    Rehan

  • RE: Trigger not firing for all records in a cursor

    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...

  • RE: Problems with Trigger

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

  • RE: Backup Transaction Logs

    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...

  • RE: Transactional Backups for archived data

    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...

  • RE: Restoring Old backup over current data?

    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...

  • RE: Restoring Old backup over current data?

    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...

  • RE: Restoring Old backup over current data?

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

    initially table(s) data

    RowId - RowData

    1 - ...

  • RE: Restoring Old backup over current data?

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

    reply quick

    😉

  • RE: Restoring Old backup over current data?

    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...

Viewing 15 posts - 1 through 15 (of 19 total)