Recent content by MarkButler

Worked like a champ, thanx

I wish to create a log when scheduled procedures are run to capture some counts and totals. I want to insert a record into a log file each time the procedure is run. I wish to store the name of the stored procedure to this log file. What I am looking for is a way to determine from within the...

I can get to the batch script which is on a local drive without a problem. I create a log within the batch script used for debugging. The log is being created and states that the file on the other server is not found. I have tried doing it both ways, using the xp_cmdshell and the job...

I have a SQL job which the first step executes a 'extract.bat' script. Within this script is a copy from another physical server as follows: copy \\serverb\temp\xxx.txt e:\xxx.txt It seems that it never finds the file to copy. I placed an "if exist echo nofile" in front of the copy and it...

Thanx nigelrivett that worked. Why the original method did not work is still a mystery. If it works just move on!! Thanx again.

Actually that is how I got the generated statement for this post. I have placed the statement into QA and have been playing with it and still no luck. It all revolves around the input database/table name. In the following I picked a system table in the "pubs" database and the one I am having...

I forgot the error message. SQLState = 37000, NativeError = 170 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '10245.'.

I have a database with a table within it that I want to extract into a text file. On my laptop I have the database defined and have no problem with the following command. The difference is that on my laptop the database name is test and on the actual server it is a numeric name. I beleive...

With that said is there any penalty for using VARCHAR (8000) on all my memo fields? Or should I go through each one and find a maximum used and set it to a more reasonable number?

Is there a performance or other advantage to using VARCHAR over the TEXT field definition? I am converting from a FoxPro database which has a MEMO type field. It would be easy to say for any MEMO field in FoxPro to just define it as TEXT to SQL. In most cases the maximum characters used in...

Thanx for the reply Jay. I had already tried MDAC 2.8 which did not work. I then reinstalled Crystal Reports and all is now well. Although I do not use it at least SQL works. Sometimes you just have to drag an anchor just to troll slow enough.

I have a laptop which has Windows XP pro installed. I had SQL 2000 personal and Crystal Reports 7 applications installed. I was no longer using Crystal on the laptop and wanted to remove it. I did an uninstall and the uninstall had some problems but I did respond to leave the shared files...

What is interesting is if I change the line: 'Claim: '+froi.fr_claimno, to '' or 'Claim: ' the query runs.

Thanx for the response. The fr_claimno is defined as follows: fr_claimno [char] 10 NOT NULL The field being updated with that information is defined as: [DI_NOTES] [text] Am I breaking a rule by inserting data into a field defined as [text]?

How about something like the following: WHERE CONVERT(DATETIME, CAST(table.monthportion AS CHAR(2)) + '/' + CAST(table.dayportion AS CHAR(2)) + '/' + CAST(table.yearportion AS CHAR(4))) > GETDATE()