Viewing 15 posts - 181 through 195 (of 252 total)
If the insert is large, perhaps it can be broken up into several inserts to keep the transaction size reasonable.
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 26, 2003 at 9:02 am
Because it works in QA, it must be DTS related. Is the package scheduled to run as a job? Did you check the process? Any blocking? ...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 25, 2003 at 8:53 am
You could use an EXECUTE to drop and create the table via another connection to simulate the GO.
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 20, 2003 at 7:03 pm
Do you really need to drop the table? Perhaps you can truncate it if you are using the simple recovery model. Is the blpu_rcords table changing structure between...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 20, 2003 at 6:25 pm
This refers to v7 but should work,
"To mark a provider as in-process, use one of the following two processes:
Create a linked server in SQL Server 7.0 which specifies...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 17, 2003 at 5:42 pm
I don't know what account it would use. Perhaps the security event log will have entries that will indicate what account is having access problems. It might...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 17, 2003 at 11:17 am
I just found a QOD that relates.
http://www.sqlservercentral.com/testcenter/QOD.asp
The date for the question is 9/24/3003.
The answer links to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/aghtconfig_15bm.asp which indicates that Allow InProcess should be checked. ...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 17, 2003 at 9:46 am
Maybe the "Allow InProcess" needs enabled. See "Configuring OLE DB Providers for Distributed Queries" in BOL.
From Q280106 - "You can set the Allow InProcess option directly through...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 17, 2003 at 9:34 am
You could try running MSDE using the domain admin account (or your account since it worked when you ran it logged in) just to see if it would work. ...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 14, 2003 at 11:34 am
My shot in the dark.... Perhaps MSDE is unable to access a required file. Can it access both the local Jet dlls (not part of MDAC 2.8) and...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 14, 2003 at 10:35 am
If case sensitivity is required and the collation of the db or column is not case sensitive, a cast can be used to change it without db redesign. Changing...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 14, 2003 at 9:16 am
quote:
If you use certain types of software, like Great Plains for example, you must use the sa password to set it up,...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 13, 2003 at 11:44 am
The default BUILTIN\Administrators works fine most of the time. However, you might have a policy change (error) or other failure that would prevent authentication (been there). The sa...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 13, 2003 at 8:57 am
Just a note of caution: Using the ON clause to reduce the records while using an outer join does not always produce obvious results. If the record is...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 13, 2003 at 8:36 am
Also, if there is any chance of a trigger being required on a table, I want an identity column. I do not know of any better way to match...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 10, 2003 at 8:52 am
Viewing 15 posts - 181 through 195 (of 252 total)