Viewing 15 posts - 1 through 15 (of 16 total)
I have seen replies posted here which gave the solution of creating an alert which would start the job. In your SQL code, you would have a RAISEERROR which would trigger...
October 28, 2004 at 10:31 am
I should have mentioned. The Win32_scheduledJob object will only work with AT scheduled jobs.
October 22, 2004 at 10:23 am
The file is visible through the command prompt (ie. > dir c:\windows\tasks). Not sure how to make it visible through windows explorer but it probably has to do with the...
October 22, 2004 at 10:09 am
I believe the way to do it is create an operator which points to the distribution lists on the Exchange server. You would then use the name of the operator...
September 3, 2004 at 12:52 pm
In CASE you want another way.
CREATE FUNCTION dbo.sfFindUserRoles ()
RETURNS int AS
BEGIN
set nocount on
DECLARE @intRetval int
SET @intRetVal = CASE WHEN IS_MEMBER ('ARMS_Analysts') = 1 THEN 1
WHEN IS_MEMBER...
June 29, 2004 at 7:23 am
A variation of AM's solution
DECLARE @I INT
SET @I = 1 (OR SET @I = 2 )
SELECT *
FROM TABLE_A A,
(select * from TABLE_B WHERE 1=@I
union
select * from...
March 26, 2004 at 11:08 am
You didn't state which version of Outlook you were using. There are problems with some versions of Outlook (2000+) and the security patches installed when using with SQL Server 7.0. ...
March 3, 2004 at 8:21 am
Try starting up the application using the RUNAS command.
One thing you may need to do is an actual domain log on through dial-up first using the check...
December 24, 2003 at 7:28 am
Is it possible that another row with middlename equal to 'B' is allowing the check option to be met.
One suggestion would be to try EXIST rather than IN.
December 2, 2003 at 9:10 am
CREATE TRIGGER [TR_Testing_I] ON dbo.VIEWTesting_META
INSTEAD OF INSERT
AS
--Perform the insert in code explicitly
INSERT INTO TBL_Testing
(testdesc) --- shouldn't this be specified?
SELECT testdesc
FROM inserted
Not sure whether the above fixes the...
August 29, 2003 at 8:52 am
Try moving the variables/parameters to the WHERE clause. Having them as part of the join condition may be causing the stored procedure to recompile each time it is called.
...
June 17, 2003 at 9:19 am
joshcsmith13, "could have two records where A=A, B=B, & C<>C, but I don't ever want A and B to be equal."
An update/insert trigger could reject these.
lambje :
"col1c AS REPLACE(IsNull(col1,...
March 10, 2003 at 12:00 pm
Just to clarify.
You state that Access is set to medium date but you give a medium time as an example.
"Medium Date as the Data (e.g. 9:00 AM). "
You...
March 7, 2003 at 8:00 am
I think the statistics are still there but not being used. I experienced what you are seeing and this is my explanation.
If you are creating the result...
March 6, 2003 at 2:46 pm
We had a problem where imports would hang when importing from Access MDB's on a nightly basis. I ended up looking at some system stored procedures and based upon...
March 6, 2003 at 12:17 pm
Viewing 15 posts - 1 through 15 (of 16 total)