Search results for query: *

Windows 2000 Advanced Server (latest service pack) SQL Server 2000 Enterprise Edition (8.00.2187) 1. Server can see other machines in network through Windows Explorer 2. Server can connect to other machines in network through ODBC 3. Other machine can't connect to my server through ODBC 4...

Before I start poking around in the system tables, I figured that I would ask around on some forums first. What I want to do it two things: 1. Show on a graph how long each one of my nightly jobs runs, scheduled through SQL Agent. Also I want to show on this graph where my jobs overlap and...

Ok, I am frustrated. I specify my active X object to use VB Script as the language for my code. Half of the VB code that I write won't work in the object. I mean SIMPLE things like the Now() and Date() functions aren't supported. I have done searches on VB script and these functions are...

I have done ActiveX in other client/server visual languages before, but not as an ActiveX object in DTS. My DTS job runs a query and then outputs the file to an excel file. That part works fine. I am trying to open the file and bold the cell A1. What am I doing wrong in this script. I have...

I have stored procedure that I don't want 2 copies of it running at the same time. How do I check if the stored procedure is already running in another instance? I know that I could setup a table and just put a row in the table when it starts and empty it when I leave. I want to know if...

Here is my query: SELECT LTRIM(RTRIM('')) If I run this in one of my databases it returns NULL, in another one it returns a blank line. What setting determines this handling? I am running Windows 2000 Server with Sql Server 2000

ERR is a column of char(255) How can I speed up this reference? LEN(RTRIM(LTRIM(ERR))) > 0 I need to find out if there is anything in ERR that is not blanks. This query is going to be ran thousands of times a day on nonstatic data, so precalculating to another table is not a valid option. I...

I have 2040 installed on all my servers and I have been having some memory problems on the main production server during high utilization. What is the latest hotfix? I found 2162, but the download isn't available because of found bugs. What is the latest stable version?

This past weekend we added 2gb of memory to our server, bring it to 8gb. We are running Win2000 Advanced Server with SQL Server 2000 Enterprise Edition. Before the memory upgrade I had the SQL Server manually set to allocate 4gb out of the 6gb to SQL Server. After the upgrade I manually set...

(SQL Server 2000 Client tools on a XP Pro Workstation accessing a SQL Server 2000 Enterprise with Windows 200 Advanced Server.) I try to go in and generate a script of the indexes of a table using Enterprise Manager and I get the following error: [SQL-DMO]Create File error on...

I know that this issue has came up on this forum a couple of times, but here's the error that I get when I schedule the DTS task: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)...

Well we had the C drive of our main server become corrupt over the weekend. Nothing like a disaster to bring to lite the inadequcies of the backup plans. I figure that I would start a topic of what else do I need to be safe from data loss. Here's my current list of activities that we are/will...

Win 2000 Advanced Server SQL 2000 Enterprise My above server is running Named Pipes and TCPIP. Some machines connect with Named Pipes and some connect as TCPIP. The Named Pipes run much slower than TCPIP. Here's my question. If I remove the Named Pipes protocol from the list, will all...

Server 1(bought new in 1999) Quad 750mhz Pentium Xeon 512mb Level 2 cache 4 gig memory Win NT 4.0 SQL Server 7.0 10k rpm drives Tempdb size - about 2gb Wide table with 10,000,000 Table size - about 19gb query ran for 1 minute, pulled down 180,000 rows Server 2(bought new in 2003) Quad...

I have a client/server reporting application that let's the user create and run adhoc queries on my database. I have a view that summarizes rows and does other calculations by office. I want to be able to combine offices and have the calucations come out correct. If I modify the source of...

I am running Win2000 with SQL2000. My backup has been working fine for a couple of days, until this morning. Here's the error message I got from my nightly backup job: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 945: [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'IEX39' cannot...

Ok, I have not changed anything. I can run the DTS package manually by right clicking on the package in the Local Packages list. When the package is scheduled to run, it fails. It worked fine yesterday and for about a month before that on a daily basis. The table that it's trying to load is...

I have downloaded the file SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE from microsofts website. The page said that it would update the Desktop Engine. I ran the file and then ran the setup.exe that the file creates. I get the following error : The instance name specified is invalid. I have searched...

I have a DTS job setup that runs fine when you right click on it and the click Execute, but when I schedule the job, it fails with the following output: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1...

What I need to do is setup a DTS pull from another system. The problem is that the machine that I am pulling from is VERY VERY slow. The only query that I can run without timing out the ODBC connection is : SELECT * FROM SCHEDULE WHERE DATE='2005-04-25' What I need to do is setup a DTS...