Recent content by BradF

I know very little about C++ but I'm trying to tackle something for work and need some help... I'm using this C++ ISAPI filter code to add a message to the top of a page on a IIS web server running ASP and CFML. This is a web server that will be going away and need a way to notify the users...

I'm looking at creating a site that allows you to drag/drop pictures, text-boxes, and certain stylized elements onto a template. It should contain the ability to edit the text in the boxes, as well as re-size the elements. There is a site that does basically the same thing using flash, but I'd...

Here's what my data looks like: "12312331 ","DOE, JOHN","3423423",0,1900-01-01 00:00:00,"","@@ ","","JOHN DOE PROCESSING PLANT" Here's my format file: 7.0 10 1 SQLCHAR 0 0 "\"" 0 "" 2 SQLCHAR 0 250 "\",\"" 1...

I'm needing help writing a query that will convert a DATETIME value into a SMALLDATETIME value and drop any DATETIME values that would cause a SMALLDATETIME overflow error (use NULL instead). Something like this maybe? UPDATE TABLE SET THISDATE = CASE WHEN THISDATE) >= 1/1/1900 OR...

Nothing has helped so far. Everything seems to be okay with the defragmentation and statistics. This proc is very simple. It simply truncates two tables and reloads summary data into them. As I said, everything works fine and fast except when I surround the query inside the SPROC with a...

Could it be related to the LOG files?

Crowley, thanks for the helpful response. The SPROC had been running fine for the past year and just recently started having problems. I've looked over the indexes and they seem to be okay. It does appear to be a deadlock as you said. I had noticed some of the indexes on one of the tables...

If I do the following, the SPROC runs fine: --BEGIN TRAN --commented out blah blah blah IF @@ERROR <> 0 BEGIN --ROLLBACK TRAIN --commented out RETURN 1 END --COMMIT TRAN --commented out

Dennis -- I did not put in the full code because I assumed those responding would assume I knew what I was doing... IF @@error <> 0 BEGIN ROLLBACK TRAN RETURN 1 END Is the exact block of code for that section. Thanks for your concern over my methods however that's not my...

I have a SP that will not work when I have the queries in it surrounded by... BEGIN TRAN blah - blah - blah IF @ERROR ROLLBACK TRAN COMMIT TRAN The proc seems to run indefinitely and there are tons of locks on the database it's using. If I remove all the TRAN lines (comment them out) the...

George: Unfortunately, I'm unable to setup a true linked server and the databases aren't on the same server. I knew this was going to be a fiasco!

I still can't get this to work. Is there another way to do it that may be easier?

George, that gave me: Invalid object name 'b'. I don't think updating via aliases works on SQL Server 2000.

Here's an example dataset returned from the select portion of the query after a run: 39 39 0 0 0 1 2007-12-12 14:40:17.910 2007-12-12 14:40:18.393 40 40 0 0 0 0 2007-12-12 14:40:17.910 2007-12-12 14:40:18.393 41 41 0 0 0 0 2007-12-12 14:40:17.910 2007-12-12 14:40:18.393 42 42 0 0 0 0 2007-12-12...

Can someone please tell me why this doesn't work? *'s replace actual secured values. UPDATE OPENDATASOURCE('SQLOLEDB','Data Source=*.*.*.*;User ID=*;Password=*').*.dbo.* SET ExceptionRanked = a.XCP_RNK_IR, SelectionFlg = a.SLE_IR, EUDLoadDt = GETDATE() FROM TADMSMT a INNER JOIN...