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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- Pebkac
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Setup and Administration
-
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...- Pebkac
- Thread
- Replies: 16
- Forum: Microsoft: Windows
-
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...- Pebkac
- Thread
- Replies: 13
- Forum: Microsoft SQL Server: Programming
