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...

I should have mentioned. The Win32_scheduledJob object will only work with AT scheduled jobs. 

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...

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...

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...

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...

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. ...

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...

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.

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...

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.

...

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,...

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...

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...

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...