Viewing 15 posts - 5,071 through 5,085 (of 5,102 total)
Here is a thought
Once the Alert is Setup You have the Option to Include the ALERT ERROR TEXT in Email to the specified Operator and if you create an Operator...
November 5, 2003 at 8:21 am
When you get timeout errors specially after moving from one domain to another the usual problem is CONECTIVITY.
Check that the Account running the package can connect to the previous...
November 5, 2003 at 8:08 am
quote:
Somehow I remembered you need linked tables to run PassThrough queries.
No You DON'T. You Just...
November 5, 2003 at 7:38 am
what do you need the user info for? You can always use suser_sname() to get the name.
October 28, 2003 at 5:51 am
that problem usually happens when the MAPI Session was lost in the email server. e.g. In case the email server is rebooted.
October 28, 2003 at 5:42 am
can you use ACCESS ADP? I supports sp on the Report record source field Natively
October 24, 2003 at 12:41 pm
Am I missing something ...
Why not:
UPDATE tblStudent SET fldLastName = @LASTNAME, fldFirstName = @FIRSTNAME, fldDepartmentCode = @DEPT,
fldBalance = @Balance, fldAddress = @ADDRESS
Where
fldStudentID = @ID
Do you really...
October 24, 2003 at 12:33 pm
Have you check the total size ( per row ) of your table?
6000 is pretty big. Considering a maximum of 8060 per row you have theoretically 2060 left and I...
October 24, 2003 at 12:18 pm
quote:
how about this :select e.deptno, e.ename, e.job, M.MaxSal
from emp e
inner join
(select deptno, max(sal) as MaxSal from emp group by deptno) M
on...
October 24, 2003 at 11:29 am
I would also redesig the process to run both steps in only one procedure (if it is feasible) it will cut down the number of round trips to the server
...
October 24, 2003 at 10:44 am
be aware that those procedures (
sp_adduser or sp_addlogin) require high PRIVILEGE accounts.
October 24, 2003 at 10:22 am
in the README file of SP3a this function IS DOCUMENTED (Item - 5.1.10).
🙂 You did read it, right?
October 24, 2003 at 10:12 am
quote:
... However, eliminating TCP/IP is not the best solution if it screws up your apps that rely on it. SQL...
October 24, 2003 at 10:09 am
The best way I have found is to use RAISERROR
HTH
October 24, 2003 at 9:16 am
quote:
Here's the question from today:What is the best way to prevent hackers from exploiting the SQL Server 2000 UDP port running...
October 24, 2003 at 8:53 am
Viewing 15 posts - 5,071 through 5,085 (of 5,102 total)