RE: Stored procedures for multiserver jobs
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-24
Software Development
RE: Problem with arithabort
I had this problem before and I believe I found out that the ODBC SQL Server driver always sets ARITHABORT OFF. You may have to set it ON with each user connection. Another option may be to index specific columns from your base tables instead of indexing the view. That's what we did to get […]
2003-06-23
RE: Merge Replication Connect Failure
Sorted Teach me for trying to do enterprise level operations on a desktop level dbms 🙁
2003-06-23
1 reads
RE: VBScript command-line performance question
As long as you are committing in small batches - as Steve suggests - there may be some benefit to setting a recovery mode of "Simple" on your target database (Database -> Properties -> Options). Remember to set it back when you are finished. This means that the logfile will only retain information for incomplete […]
2003-06-23
1 reads
RE: VBScript command-line performance question
Unless your data is sorted in clustered index order, remove your index before you load and then rebuild it. Also, I doubt that VBScript is the quickest language to do any conversion. We found the fastest method was to convert the data using C and bulkload using the BCP API, running 7 loads in parallel […]
2003-06-23
RE: VBScript command-line performance question
quote: It seemed to slow down as it went along. Could it be an issue with your clustered index? As more records are beeing added the clustered index grows and if you have a wide and/or unique index maybe you are starting to experience huge amounts of page splits and your I/O might not cope? […]
2003-06-23
1 reads
RE: SQL Server Agent fails to start - no error msg
Has 'BUILTIN\Administrators' login been removed/denied from SQL Server Logins? If it is, To start SQL Server Agent from local system account, You have to grant 'NT Authority\System' account to access SQL Server with 'sa' privilege. If you want to use local admin account to start SQL Server Agent, grant this local admin account to access […]
2003-06-20
1 reads
RE: SQL Server Agent fails to start - no error msg
Dear All, I also found a very interesting problem on the server. If I go to the server (pcAnywhere), open the LOCAL Enterprise Manager and try to register the LOCAL SQL Server instance then I get an error message: [SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION If I open the Enterprise Manager on my PC and register the […]
2003-06-20
2 reads
RE: SQL Server Agent fails to start - no error msg
Dear Allen, Sorry, my statement was misunderstandable. I meant that I wanted to start the Agent under local system account as well as under local admin user. Both solution failed so until now I haven't found any way how I can start the Agent. The SQL Server itself runs without any problem. Thanks! Csaba Mezo
2003-06-20
1 reads
RE: SQL Server Agent fails to start - no error msg
Hi Frank, In the event log I only find the error message that I wrote in my first posting. Nothing more. No, there was no change in the config. However currently I started to reinstall the SQL Server then I will see if it solves the problem or not. Thanks, Csaba Csaba Mezo (mezo@inform.hu)
2003-06-20
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers