Viewing 6 posts - 1 through 6 (of 6 total)
try a trigger on inserts of sysservers table in the master db.
August 30, 2005 at 2:47 pm
What account are the SQL and SQL Agent services running under? If not a domain user, then you will need to execute the xp_startmail stored procedure to start the mail...
August 30, 2005 at 2:41 pm
Just curious why you would need to do this? You create the temp table through code, so you should know what the columns in it are.
August 18, 2005 at 8:31 am
Sounds like you need a cursor where your SQL statement would be:
Select n.something, count(*) as Number
from...
group by n.something
This will get you all groups that have records you are tyring to...
August 18, 2005 at 8:27 am
A Cursor and fetch relative command may work best, especially if you may be sorting the records by different fields.
For example:
create spRecordNo @rcdno int
declare @CustId varchar(20)
Declare tmpCursor Dynamic for (Select...
August 15, 2005 at 8:38 am
Where convert(varchar(50),ContractDate,101) = convert(varchar(50),getdate(),101)
June 16, 2005 at 9:20 am
Viewing 6 posts - 1 through 6 (of 6 total)