Recent content by lewatkin

George, Thank you for that clarifying that for me. It makes perfect sense now. I can work with the second suggestion you made. Thanks again, Lee

I have an insert trigger that is working fine. I have a need to export the primary key value that was inserted into the table to a text file. My attempts thus far have resulted in an error. Here is the code: BEGIN DECLARE @MySql varchar(1000) SELECT @MySql = 'osql -Q "SELECT...

Sorry for the delayed response. I just wanted to say thanks for pointing me in a direction to get me started. The code I used is posted below. ALTER TRIGGER [dbo].[Date_Update] ON [dbo].[staff_certs] AFTER UPDATE AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from --...

I'm sure this will be easy for some of you, but I am pretty new to the trigger/stored procedure world. I have a date field in two tables, and an employee id field in two tables. The dates are associated with a primary key of employee id. I would like to create a trigger (or stored procedure)...

PH, That is what I ended up doing. I saw the same thing you referenced and moved the Do loop below the connection string. Thanks for the reply! Lee

Thanks for your help! That's exactly what I did. have a star!!

I fixed it. Just added a boolean in a loop that was false until the Cancel button was clicked on the Msgbox form. Maybe not the most efficient, but it works.

Ok vbscript gurus, this is probably a simple question. This is my first attempt at vbscript. I am querying a database with input from the user, and when the records are returned to the message box, I have a retry button there. If the information that is returned is not what the user is...

Thank you for the reply and it is further than I was for sure. But its not quite what I was looking for. First, this only exports the information from the last server in the C:\AllServers.txt file. Additionally, the information is double quoted and pipe delimited (ex...

The following powershell script works fine.... foreach ($svr in get-content "C:\AllServers.txt") { [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null $serverinstance = new-object ('Microsoft.SqlServer.Management.Smo.Server') $svr foreach ($db in...

Gerry, Thanks so much for the code. It worked fine on the first document in the folder, but when it went to the second document, it failed on Set r = ActiveDocument.Range. Not sure why. Nonetheless, I am using Selection and it is working fine. The code is not pretty at all, but it works...

Hey gang! I know there is someone here that can help me. I have 10,000+ MS Word Docs. They are all formatted the same - another program creates them. See below: "Commencing at NGS monument "Any High 2" having XXXX Grid Coordinates (NAD 83-2001) X=XXX.XX and X=XXXX; thence from said point...

Hey gang! I know there is someone here that can help me. I have 10,000+ MS Word Docs. They are all formatted the same - another program creates them. See below: "Commencing at NGS monument "Any High 2" having XXXX Grid Coordinates (NAD 83-2001) X=XXX.XX and X=XXXX; thence from said point...

Gentlemen, THANK YOU BOTH. I am happy to report that I am posting this through aforementioned Gateway that would not previously get on the internet wirelessly. While neither of your posts was exactly what the problem was, they both lead me to what the problem was. I ran the /flushdns as...

Hey Jim, Thanks for the response. Here is what I did... On router: IP = 192.168.1.1 Subnet: 255.255.255.0 Gateway: 192.168.1.1 DHCP enabled Wireless Router: IP = 192.168.1.2 Subnet: 255.255.255.0 Gateway: 192.168.1.1 DHCP disabled No security enabled (will enable after it works) Connected...