Viewing 9 posts - 1 through 9 (of 9 total)
You could check in Select * from msdb.dbo.sysjobschedules
Pay attention to freq_type... 64 = When SQL Server Agent Starts.
OR if you are looking for a specific Procedure...
Select all procedures in a cursor...
November 4, 2005 at 4:55 am
Goto Start ->Run, Then type
MSACCESS.EXE /DECOMPILE YourAccessDatabaseHere... and enter(OK)
This should decompile it. You now have the cnahce to correct whatever is the problem.
Good Luck
October 11, 2005 at 4:10 am
Where is "Begin Tran T1"..
It appears you are going from Tran ADC to Saving Tran T1
May 20, 2004 at 2:41 am
What is wrong with this!!
Alter Procedure spCodesOffenseListActive
(
@Find
as varchar(20)=NULL
)
April 15, 2004 at 2:12 am
Have you been able to determine what the users are doing when this timeout starts occurring??
April 13, 2004 at 2:47 am
What is this RowID..
I would think you would only need to create Stored procedure, supply it with data in the form of a command object and execute it with your...
April 2, 2004 at 8:03 am
When you create a link to Access, make sure you identify a PrimaryKey (unique identifier) for the SQL Server Table.
If you do not identify what will uniquely identify your records,...
April 2, 2004 at 1:55 am
SELECT account_id, bill_contact, bill_address,bill_method = Case
When 'CC' Then (SELECT CC_Number, CC_TYPE, CC_Exp FROM credit_card)
FROM account
WHen 'ZZ' Then Do something else
End as 'The Value'
From account
June 19, 2003 at 2:48 am
SELECT account_id, bill_contact, bill_address,
(IF bill_method = 'CC' THEN (SELECT CC_Number, CC_TYPE, CC_Exp FROM credit_card)
FROM account
June 19, 2003 at 2:46 am
Viewing 9 posts - 1 through 9 (of 9 total)