Recent content by Pebkac

Did you want the typo of Ink Or Lnk?

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

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?

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

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

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

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.

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

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

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.

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

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

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

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

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?