Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Pebkac

    Removing Desktop Shortcuts Using Wise Install Builder

    Did you want the typo of Ink Or Lnk?
  2. Pebkac

    Get Registry Key returns Nil

    Are you typing in the HKey_Local_machine in the Registry Key field? If not, please show what you are putting into the fields.
  3. Pebkac

    Trigger using sp_who ? Is it possible?

    OK. I just dont know where the info is coming from via the SP. Is there a base table I can use conditions on? The app only has a table with the user name. Is there a view or table I can create that will show me the Host and username from SP_who2 that I can then put conditions on to watch?
  4. Pebkac

    Trigger using sp_who ? Is it possible?

    Is there a way to set up a trigger or message when a user logs in under a different ID name? I am specifically looking for when the Host name is not in the loginname Example: Loginname =Domain1/User1 Host =User1 is OK but I want to know if this occurs Loginname =Domain1/User2 Host...
  5. Pebkac

    DB Will Not Grow

    I have seen a simmilar issue in SQL 7. The fix for me was I needed to make the SQLCMDexec user an admin on the local machine. Check to see that the SQLCMDexec user has the permissions on the local machine to the HD. IF not then you will get a similar issue (or passwords expired).
  6. Pebkac

    Mapped Drives

    Who are eagles1 and netwalker? I need a laugh, where can I read about them?
  7. Pebkac

    Mapped Drives

    Oops Let me rephrase that. I am not sure who stu@tcm (Visitor) is but I am Pebkac and the originator of this, and I am all set.
  8. Pebkac

    Mapped Drives

    i am not sure who put in that it disconnects same as the user. But I am the one who stu@tcm (Visitor) is. wrote the original problem. I have created the bat file and then just put it in the startup folder and it run auto for me after the login bat runs. The original issue was to find a...
  9. Pebkac

    Differential Backups

    Sorry here is the DIFF Statement: DECLARE @dt char(12), @sql varchar(4000) -- Get date and time for backup file name SELECT @dt=convert(char(6), getdate(), 12) + replace(convert(char(8),getdate(),8),':','') SELECT @sql='' SELECT @sql=@sql+ 'PRINT ''' + name + '''' + char(10) + 'PRINT '''''...
  10. Pebkac

    Differential Backups

    tlbroadbent I am looking for some help. Can you tell me how to get Retaindays to work in the statement? I tried it but the files never get deleted this is on both the Full and Dif Backups.
  11. Pebkac

    Differential Backups

    OK here is my problem. Maybe I am misunderstanding the purpose of the Diff Backup. If you looked at the size of the Diff backups and compared diff before and after Backup you would find its 24 MB and 24.8 MB respectivly in size. The one just before the backup is only 800 KB larger. Now that is...
  12. Pebkac

    Differential Backups

    I thought that the Diff backups were basicly the Transaction logs combined. The largest log I have is 190 KB, the average is 100 KB. The Diff bkup that is run 30 min after the Backup is only 800KB smaller than the one 20 min before the Next nights backup. It just seems that if there is only...
  13. Pebkac

    Mapped Drives

    Does anyone know how to force a mapped drive from a cmd? There is a logon script that is run to redirect a drive letter for the Anti Virus software update. But we have hardcoded paths that use the same letter (to a different location) Is there a way to make a bat file that will correct this...
  14. Pebkac

    Differential Backups

    Thank you very much. Works like a charm I have one more question that maybe you can answer. Why would each Diff backup be 90+% of the complete database file size, yet the total size of the logs for the same time period is 3 %. I used your Diff backup statement. The DB is pretty small <50 Mg...
  15. Pebkac

    Differential Backups

    How can I to this dynamically? I want this to be done with the schedule of every 2 hrs, not that I would have to hand append the time stamp at the end. I know I can create a job for the SQLAgent and put in the step, but how can I get the dynamic timestamp?
  16. Pebkac

    Differential Backups

    does anyone know how to get a diffential backup to stay as an archive? I am looking to get a diffential backup on my DB every 2 hrs. I have Logs every 20 min. The full backup is once a night. I can see the time stamps on the logs and full DB files. When I run the Diff backup I get either...

Part and Inventory Search

Back
Top