Viewing 15 posts - 361 through 375 (of 1,186 total)
Alan,
I don't think that IF BOL states the "Amount of time incurred in the previous execution of the job." (Don't know which version of BOL you are using) How...
May 17, 2005 at 4:13 pm
1. With the introduction of SQL 2K the checkbox that says "save in sent".. no longer works. A change was made to the dll's.... (frustrating trust me I know)
2. With...
May 17, 2005 at 2:57 pm
Bill,
Unfortunately, unless you have written an audit trail to capture this the answer is no.. Sorry
May 17, 2005 at 2:53 pm
In addition to Remi, IF you know that your field will always be 4 I would change the CONVERT(VARCHAR, to be CONVERT(VARCHAR(4), or CONVERT(CHAR(4),
I have had instances in the...
May 17, 2005 at 2:45 pm
Do you ALWAYS have to perform this on the entire table? IF not you could shorten the amount of employees by using:
UPDATE E1 SET CongDist = R1.CongDist
FROM dbo.Ranged...
May 17, 2005 at 11:39 am
I think you are going to have to re-install the procedures. I would change one of the procedures that is currently failing to have ANSI_NULL ON or OFF (Depending on...
May 17, 2005 at 11:32 am
I dont think you are interpreting BOL correctly. The exact phrase is:
| last_run_duration | int | Amount of time incurred in the previous execution of the job. |
This...
May 17, 2005 at 11:28 am
Porcrim,
There are plenty of articles/discussions here about this. The problem is that WHEN you pass a variable in to act as the dynamic IN... SQL treats it as a...
May 17, 2005 at 9:06 am
Have you tried using SET DATEFORMAT DMY ?? Put this at the beginning of your statement and see if this works...
May 16, 2005 at 5:26 am
If you want ACTUAL counts than the answer is no. IF you want estimated counts you can pull that from Sysindexes BUT this can be VERY incorrect....
May 13, 2005 at 5:32 am
Gibbers,
You can do the 2nd statement (the OR) and EACH DEFAULT must have a unique name unfortunately.
May 10, 2005 at 4:12 pm
Try [SFISQL02\doci]. and see if that works.
May 9, 2005 at 2:44 pm
It sounds like when you proted the Acess tables to SQL the DEFAULT setting did not make it.
Your Access calculations will need to be modified to be something like .........
May 9, 2005 at 5:46 am
Are you getting an error? I know you say that you are trying to add records through the web.. How? Is it via stored-procedure call?? Do you have rights to...
May 6, 2005 at 3:49 pm
Does the table that you are attempting to enter data into have a Primary|Unique key? I know Access has a similar problem and so does EM when the table doesn't...
May 6, 2005 at 11:31 am
Viewing 15 posts - 361 through 375 (of 1,186 total)