Hi David, quote: set conn = CreateObject("ADODB.Connection") set Com = CreateObject("ADODB.command") set Rs = CreateObject("ADODB.recordset") I always thought one must use something like Set conn = Server.CreateObject("ADODB.Connection") ... Is this the same? Cheers, Frank
2003-07-07
2003-07-03
quote: In the case of my client they have chosen Barclays bank so this means that all credit card details are handled by the bank systems and not mine. I looked at the Barclay's offering -- the main motivation being to try and put some distance between myself and CNP credit card fraud. It looked […]
2003-07-03
1 reads
2003-07-03
To test this out, I create a job 'AddUser' which just contained the code sp_addlogin 'test'. Not sure whether it is possible to use SQL-DMO in Access 97 so I tried using Transact SQL in Query Analyzer: Use msdb EXEC sp_start_job @job_name = 'AddUser' Still a SYSADMIN problem which I overcame by using xp_sqlagent_proxy_account. Managed […]
2003-07-02
Below is a portion of sp. @COLLECTOR_ID is the culprit. If I replace the variable with a hard coded value it runs quickly. CREATE PROCEDURE dbo.ABT_Select_Collector_LastWorkDate_NotReviewed --Add Parameters Here @COLLECTOR_ID INT, @LAST_WORK_DATE VARCHAR(50), @PROCESS_GROUP_ROLE_ID INT, @NT_USER_NAME VARCHAR(50) <snip> WHERE SGP.PROCESS_GROUP_ROLE_ID = @PROCESS_GROUP_ROLE_ID AND LWD.LAST_WORKDATE <= @LAST_WORK_DATE AND CU.CORE_USER_ID = @COLLECTOR_ID AND LOAN.PrincipalBal >1 Thanks in […]
2003-07-01
1 reads
Can you post the code or something similar to it that does the same?
2003-07-01
Thanks for your reply, Darren. Before you replied, i opted for decimal. Is there much (if at all any) difference between numeric and decimal that you know of? I have tried to read BOL, but can't seem to see a major difference between them.
2003-07-01
Scheduled stuff is usually done by setting up a job in SQL agent. You could set to run at a certain time when you know the step before would be done, or you could run more frequently to check to see if the step before was complete. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-07-01
2003-06-27
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers