SQL Server 2000 SP4 Slows Down Dts Job
Hi peeps,
We have just upgraded to Service Pack 4 on our SQL Server 2000.
We have had a DTS job that normally takes about four hours to complete(this dts job has been ok for the last three years).
However, after applying SP4, this DTS job now takes over 8 hours to complete.
There are no other processes running on the box and the box is a high end Dell machine with 8 Gig of RAM.
Any advice on this would be greatly appreciated.
Bal
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
SQL Server 2005 Slows Down
Hi MSDN PPL! I have an SQL Server 2005 instance that slows down over time, she almost grinds to a halt. The data is being exposed via an ASP.Net 2.0 web interface. The web application gets slower and slower over a matter of days. If I restart the SQL Server process she comes back to life and starts serving as it should - nice and snappy. The web application does not perform much writing to the DB, 90% of the time its just reading. The DB server is worked hard by a console application that produces data each day. This console app runs for about 30 minutes during which there is a lot of reading, processing and writing back to the DB as fast as the hardware will allow. Its this massive workload that is slowing the DB server. This seems to be related to the amount of memory that SQL Server is using. When looking at Task Manager I can see that sqlservr.exe is using 1,878,904K, this figure continues to rise while the console app runs. I have seen it over 2 GB. When the console app finishes the memory is still allocated and performance is slow. This continues to get worse after a few days of processing. The machine's specs are: * Windows Server 2003 R2 Standard * SQL Server 2005 Standard 9.00.3054.00 * Twin 3.2Ghz Xeons * 3.5 Gb RAM I plan to apply "Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2" in a blind hope to solve the problem. Any suggestions? Sorry if this is in the wrong place guys, couldn't find a general performance topic. Please move accordingly. Thanks, Matt.
View Replies !
View Related
SQL Server 2005 Slows Down After A Large Number Of Queries
Hi, We are running SQL Server 2005 Ent Edition with SP2 on a Windows 2003 Ent. Server SP2 with Intel E6600 Dual core CPU and 4GB of RAM. We have an C# application which perform a large number of calculation that run in a loop. The application first load transactions that needs to be updated and then goes to each one of the rows, query another table get some values and update the transaction. I have set a limit of 2GB of RAM for SQL server and when I run the application, it performs 5 records update (the process described above) per second. After roughly 10,000 records, the application slows down to about 1 record per second. I have tried to examine the activity monitor however I can't find anything that might indicate what's causing this. I have read that there are some known issues with Hyper-Threaded CPUs however since my CPU is Dual-core, I do not know if the issue applies to those CPUs too and I have no one to disable one core in the bios. The only thing that I have noticed is that if I change the Max Degree of Parallelism when the server slows down (I.e. From 0 to 1 and then back to 0), the server speeds up for another 10,000 records update and then slows down. Does anyone has an idea of what's causing it? What does the property change do that make the server speed up again? If there is no solution for this problem, does anyone know if there is a stored procedure or anything else than can be used programmatically to speed up the server when it slows down? (This is not the optimal solution however I will use it as a workaround) Any advice will be greatly appreciated. Thanks, Joe
View Replies !
View Related
Local Variable Slows Down SP (?)
Hi guys I am sitting and testing som variants of this simple SP, and I have an question that I couldent answer with google or any thread in this forum. Perhaps I am doing something really easy completly wrong here. Why does the local variables in the first code segment slow down the overall execution of the procedure? Dont mind the logic why I have them there are only testing som things out. If i declare two variables the same way: DECLARE @v INT SET @v = 100 When I use it in a WHERE CLAUSE: ...WHERE [V] BETWEEN @v AND @x) Is there any different then ...WHERE [V] BETWEEN 100 AND 200) Cant figure this out, why does it hurt the performance so bad? As a C# guy its the same thing ? Thanks in advance /Johan Slow ALTER PROCEDURE [dbo].[spStudio_Get_Cdr] @beginDate DATETIME = null, @endDate DATETIME = null, @beginTime INT, @endTime INT, @subscribers VARCHAR(MAX), @exchanges VARCHAR(MAX) = '1:', @beginDateValue int, @endDateValue int AS BEGIN SET NOCOUNT ON; DECLARE @s INT SET @s = @beginDateValue DECLARE @e INT SET @e = @endDateValue print @s print @e DECLARE @exch TABLE(Item Varchar(50)) INSERT INTO @exch SELECT Item FROM [SplitDelimitedVarChar] (@exchanges, '|') ORDER BY Item DECLARE @subs TABLE(Item Varchar(19)) INSERT INTO @subs SELECT Item FROM [SplitDelimitedVarChar] (@subscribers, '|') ORDER BY Item SELECT [id] ,[Abandon] ,[Bcap] ,[BlId] ,[CallChg] ,[CallIdentifier] ,[ChgInfo] ,[ClId] ,[CustNo] ,[Digits] ,[DigitType] ,[Dnis1] ,[Dnis2] ,[Duration] ,[FgDani] ,[HoundredHourDuration] ,[Name] ,[NameId] ,[Npi] ,[OrigAuxId] ,[OrigId] ,[OrigMin] ,[Origten0] ,[RecNo] ,[RecType] ,[Redir] ,[TerId] ,[TermAuxId] ,[TermMin] ,[Termten0] ,[Timestamp] ,[Ton] ,[Tta] ,[Twt] ,[Level] FROM [dbo].[Cdr] AS C WHERE (C.[DateValue] BETWEEN @s AND @e) AND (C.[TimeValue] BETWEEN @beginTime AND @endTime) AND EXISTS(SELECT [Item] FROM @exch WHERE [Item] = C.[Level]) AND (EXISTS(SELECT [Item] FROM @subs WHERE [Item] = C.[OrigId] OR [Item] = C.[TerId])) END Fast ALTER PROCEDURE [dbo].[spStudio_Get_Cdr] @beginDate DATETIME = null, @endDate DATETIME = null, @beginTime INT, @endTime INT, @subscribers VARCHAR(MAX), @exchanges VARCHAR(MAX) = '1:', @beginDateValue int, @endDateValue int AS BEGIN SET NOCOUNT ON; DECLARE @exch TABLE(Item Varchar(50)) INSERT INTO @exch SELECT Item FROM [SplitDelimitedVarChar] (@exchanges, '|') ORDER BY Item DECLARE @subs TABLE(Item Varchar(19)) INSERT INTO @subs SELECT Item FROM [SplitDelimitedVarChar] (@subscribers, '|') ORDER BY Item SELECT [id] ,[Abandon] ,[Bcap] ,[BlId] ,[CallChg] ,[CallIdentifier] ,[ChgInfo] ,[ClId] ,[CustNo] ,[Digits] ,[DigitType] ,[Dnis1] ,[Dnis2] ,[Duration] ,[FgDani] ,[HoundredHourDuration] ,[Name] ,[NameId] ,[Npi] ,[OrigAuxId] ,[OrigId] ,[OrigMin] ,[Origten0] ,[RecNo] ,[RecType] ,[Redir] ,[TerId] ,[TermAuxId] ,[TermMin] ,[Termten0] ,[Timestamp] ,[Ton] ,[Tta] ,[Twt] ,[Level] FROM [dbo].[Cdr] AS C WHERE (C.[DateValue] BETWEEN @beginDateValue AND @endDateValue) AND (C.[TimeValue] BETWEEN @beginTime AND @endTime) AND EXISTS(SELECT [Item] FROM @exch WHERE [Item] = C.[Level]) AND (EXISTS(SELECT [Item] FROM @subs WHERE [Item] = C.[OrigId] OR [Item] = C.[TerId])) END
View Replies !
View Related
ADO.NET 2.0 Slows SP Execution By Large Factor
I'm hoping someone will be able to point me in the right direction for solving this problem as i've come a bit stuck. The Sql Server 2005 Stored Procedure runs in about 3 secs for a small table when run from SQL Management Studio (starting with dbcc freeproccache before execution) but times out when run through ADO.NET on .NET (45 sec timeout). I've made sure the connection was closed prior to opening and executing the adapter. I'm a bit stuck as where to check next though. Any ideas greatfully received, Thanks
View Replies !
View Related
Help! Cygwin X Slows Down Query Analyzer
Hi,I use Xorg's XWin in rootless mode on cygwin on XP Pro for quite a bitof my work. Unfortunately it seems to slow down SQL Query Analyzer's UIterribly. If I exit out of X and/or kill it, the UI reverts back tonormal ie responds as it normally would. The slowdown usually happensif I stop using Query ANalyzer for sometime and then try to get back toit by clicking on the window.Has anybody else seen this problem?Is there a way around it?AM
View Replies !
View Related
Text Column Slows Down Select
Hi All,We're running SQL Server 2000, SP3.I have a stored procedure that consists of a single Select statement.It selects a bunch of columns one of which is a column of data typeTEXT.SP takes 30 sec to run which causes timeouts on the Front End.When I comment out the Text column from the select it only takes 1Sec.Is there anything I can do about it? I know I can't index a Textcolumn. It's also not used in the where clause, so no need forFull-Text Search.But we absolutely have to have it in the Select clause.Thanks for the help in advance.~Narine
View Replies !
View Related
T-SQL Select Statement Slows Down When Insert Into Is Put In Front
Hi We have a t-sql statement in a SP that generates on average between 50 €“ 60 rows of data, pretty small! The statement references a View, some tables and temporary # table which has been created in the SP. Everything works a treat and runs sub second until you put a Insert Into in front of the above statement scenario. The SP then takes a about a minute to run which happens to be about the same amount of time to generate all the data in the View. I have not attached T-Sql statement at this stage as it runs ok without the Insert Into but would be happy to post it if need be. Anybody else ever had this problem? We are using SQL Server 2005 SP2 64 bit. Art99
View Replies !
View Related
Report Performance Slows Down As SP Is Run Multiple Times.
Hi all, In my project, I have a website and through that, I run my reports. But the reports take a lot of time to render. When I checked the profiler, it showed that the SP for the report is run around 4-5 times. Due to this, the report rendering takes a lot of time. When, I ran the SP with the same set of Parameters in Query Analyser, it ran in around 18 seconds. But when I ran the report from web interface, it took around 3 minutes to completely show the data. And the SP has been run 5 times. I am having serious problems with Report's performance because of this. Many a times, report just times out. I have set the timeout as 10 minutes. And because the Sp is run 5 times, the report times out, if there is huge amount of data. Any help would be appreciated. Thanks in advance. Swati
View Replies !
View Related
Using Declared Variable As Passphrase Slows Query
I have two tables - gift_cards and history - each related by a field called "card_number". This field is encrypted in the history table but not in the gift_cards table. Let's say the passphrase is 'mypassphrase'. The following query takes about 1 second to execute with a fairly large amount of data in both tables: SELECT max([history].[date_of_wash]) AS LastUse FROM gift_cards AS gc LEFT JOIN history ON gc.card_number=CAST(DecryptByPassPhrase('mypassphrase', HISTORY.CARD_NUMBER) AS VARCHAR(50)) GROUP BY gc.card_number When I use a declared variable to contain the passphrase, the same query takes over 40 seconds. For example, declare @vchPassphrase as nvarchar(20) select @vchPassphrase = 'mypassphrase' SELECT max([history].[date_of_wash]) AS LastUse FROM gift_cards AS gc LEFT JOIN history ON gc.card_number=CAST(DecryptByPassPhrase(@vchPassphrase, HISTORY.CARD_NUMBER) AS VARCHAR(50)) GROUP BY gc.card_number This query is part of a stored procedure and, for security reasons, I can't embed the passphrase in it. Can anyone explain the discrepancy between execution times and suggest a way to make the second query execute faster? Thanks, SJonesy
View Replies !
View Related
Large Transaction Log Dramatically Slows Down Processing Any Idea Why?
While working on the data migration in the last 6 weeks or so, I've gotten some amazing results in performance differences due to the size of the transaction log file. Initially, the database was created (accidentally by typo) with a transaction log file size of 3 Gig. It should have been 300 Meg. We had been running migration with this database for about two months. In particular, there was a SQL->SQL migration of the shopping carts that consistently took 5 hours. This was consistent across 3 different machines, with the more powerful machine being about 20% faster. On the last round of migration testing, we rebuilt the database with the corrected 300 Meg transaction log file size. When I ran the shopping cart migration, it took 17 minutes. I couldn't believe the difference, so I tested a variety of things to confirm, and sure enough: When the only difference is the size of the transaction log file, a 5 hour process was reduced to 17 minutes! (the data was validated as well). All else was held equal - the tables, indexes, stored procedures, hard drive space (with the exception of the log file size difference, but there was ample room on the hard drive in either case). I even took the 17 minute version and grew the transaction log to 3gig, after which it degraged to 5 hours. We've discussed this here, and we can't explain it. If anyone has any insight, please share it with us. Many thanks in advance, Tom
View Replies !
View Related
SQL Integration Services Data Flow Task Slows Down
We are using an OLE DB Source for the Data Flow Source and OLE DB Destination for the Data Flow Destination. The amount of data being moved is about 30 million rows, and it is gather using a sql command. There is not other transformations in between straight from one to another. The flow starts amazingly fast but after 5 million rows it slows considerably. Wondered if anyone has experienced anything similar with large loads.
View Replies !
View Related
SSIS Data Flow Task Slows During Bulk Insert
I have an SSIS Package which is designed to import log files. Basically, it loops through a directory, parses text from the log files, and dumps it to the database. The issue I'm having is not with the package reading the files, but when it attempts to write the information to the db. What I'm seeing is that it will hit a file, read 3000 some lines, convert them (using the Data Conversion component), and then "hang" when it tries to write it to the db. I've run the SQL Server Profiler, and had originally thought that the issue had to do with the collation. I was seeing every char column with the word "collate" next to it. On the other hand, while looking at the Windows performance monitor, I see that the disk queue is maxed at 100% for about a minute after importing just one log file. I'm not sure if this is due to the size of the db, and having to update a clustered index, or not. The machine where this is all taking place has 2 arrays- both RAID 10. Each array is 600 GB, and consists of 8 disks. The SSIS package is being executed locally using BIDS. Your help is appreciated!
View Replies !
View Related
Not Able To Install SSRS For SQL Server 2000 On Production Machine (Windows 2000 Advanced Server)
Hi, I am not able to install SSRS for SQL Server 2000 on our production server, which is Windows 2000 advanced server and it is giving error messages in the last minute and before completing the set up and the message is displayed in meesage box as "SQL Setup failed to execute a command for Server configuration. The error was: Line 1: Incorrect Syntax error near '[]'. Refer to Server logs and set up logs for detailed error information " Please help on this at the earliest. Appreciate your help in advance.
View Replies !
View Related
Upgrade - Server 2000/sql Server 2000 To Server 2003/ Sql Server 2005
I am converting about 50 databases from Windows 2000 and from SQL Server 2000 to a totally new 4 processor Server 2003 with SQL SErver 2005. I used the Database Copy Wizard in SS2005 to do the transfer and I used the object method. After making sure the databases were big enough to hold the new Masterdatabase everything went well... except none of the stored procedures from any of the 50 databases copied from SQL Server 2000 to SQL Server 2005. What did I do wrong? And how do i fix it. Also, even though I changed the default database, the wizard did not reflect the new SAN location for the Data and Log files. I had to do each one manually.
View Replies !
View Related
Transition From Sql Server 2000 Developer To Sql Server 2000 Standard Edition
I have installed MS sql server developer edition on a server, created database and tested it and it all work fine. I have thousands of records and lots of store procedures to apply business rules. Since the developer edition has limitation in deployment into the production environment. I have obtained a new MS sql server Standard Edition so I can deploy my database in a production server (which is the same server I installed the developer edition)...... What are the best way to install the standard edition. options: 1- Back up the database , uninstall developer edition from server, then install the standard edition, then restore the database into the standard edition 2- install the standard edition as a second instance in the same server where the developer edition is installed, then move the complete database. 3- have a complete script copy of the database structure, store procedure, views,etc.. then bcp out all current data, then uninstall developer edition, then install standard edition, then run the scripts to build the data base, then bcp in the data. You can tell that I really do not know what is the best safe way to accomplish this task, appreciate your input in this one. Thanks Ali
View Replies !
View Related
SQL SERVER 2000: In Which Format The Datetime Will Be Stored In Sql Server 2000?
Hi All, I would like to know, how the datetime will be stored in the sqlserver datetime column. Because some time i am giving the date in dd/mm/yyyy and sometime mm/dd/yyyy. while give the date in mm/dd/yyyy works fine but not in the another case. and also while i execute a query on query analyser it shows the datetime in yyyy/mm/dd format. So anyone can please tell me how the dates will be stored in the datetime column of sqlserver database? Thanks in Advance. Regards, Dhanasekaran. G
View Replies !
View Related
Sql Server 2000 Linked Server To Access 97/2000 Incompatability
We are experiencing a problem with Sql Server 2000 linking to anAccess 97 file. We have two machines that link to this .mdb file, andwe recently upgraded one to newer hardware, SP3a, MDAC 2.8, etc. Thelink on this upgraded machine no longer works, giving this message:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.[OLE/DB provider returned message: Cannot open a database created witha previous version of your application.]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'IDBInitialize::Initialize returned 0x80004005: ].The link on the older machine still works. We decided to tryconverting a copy of the file to Access 2000 to see if the newerpatches/drivers/whatever no longer supported 97. We set up a link onboth machines to this file, and they both work. However, on theupgraded machine, the following error is receievedServer: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.[OLE/DB provider returned message: System resource exceeded.]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'ICommandText::Execute returned 0x80004005: ].when making 1-3 connections to the the linked server, while the oldermachine supports at least 7 simultaneous queries connecting to thelinked server and still hasn't produced that error.Does anyone have any idea if there is a known issue with linking toAccess 97/2000 files under MDAC 2.8, Jet 4.0, etc? Any light anyonecan shine on this subject would be greatly appreciated.
View Replies !
View Related
Upgrading SQL Server 2000 Standard To SQL Server 2000 Enterprise
I am currently running SQL Server 2000 Standard on my production system, and I am looking to upgrade the system to Windows 2000 Adv. Server. I would also like to upgrade SQL Server 2000 Standard to SQL Server 2000 Enterprise to utilize more than 2GB of memory. Can anyone tell me what is the best way to upgrade the system, and please provide some feedback on your experiences with the upgrade. Thanks in advance.
View Replies !
View Related
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A
HI, I installed Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A in my computer, but I can't see MSDE on my Start menu. I am really new to this and don't know how to open MSDE, so I could work with it. Sorry for such a silly question, but please help me. How can I open MSDE from the Start menu. I have windows XP professional. Thanks for the help. Munny
View Replies !
View Related
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A
My objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer. I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm). When I try to run setup, I get that message that says: "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same." Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up? I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks! Ron
View Replies !
View Related
Vista Business ODBC/DSN To Remote Windows 2000 Server / SQL 2000
Hi, Just upgraded some development desktops to Vista Business. However we need to still connect to some older remote windows 2000/SQL 2000 servers. Trying to setup an ODBC system DSN on our Vista Business local desktop we get the following errors - -START ERROR WINDOW- Connection Failed: SQLState: '01000' SQL Server Error: 772 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (SECDoClientHandshake()0. Connection failed: SQLState: '08001' SQL Server Error: 18 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SSL Security Error -END ERROR WINDOW- Any help greatly appreciated as this is stopping us from making database/table connections etc. We've checked the firewall setup and all is well there. PS - we can still connect fine using XP or windows 2000 desktops and their local DSNs.
View Replies !
View Related
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release
venu writes "Hi, Am very new to MS SQL adminstration Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice. The activity which am going to workout on MSDE is below. How to install SQL(on XP) How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other) How to create/delete tables if so, how can we do it either by GUI or CUI just i need a clarifications reg same Thank you, venu"
View Replies !
View Related
Maximum Capacity Specifications Comparison Table For Access, SQL Server 7, 2000 And MSDE 2000
Parameter Access 2000/XP SQL Server 7.0 SQL Server 2000 MSDE 2000 Number of instances per server n/a n/a 16 16 Number of databases per instance / server n/a 32,767 32,767 32,767 Number of objects per database 32,768 2,147,483,647 2,147,483,647 2,147,483,647 Number of users per database n/a 16,379 16,379 16,379 Number of roles per database n/a 16,367 16,367 16,367 Overall size of database (excluding logs) 2 GB 1,048,516 TB 1,048,516 TB 2 GB Number of columns per table 255 1024 1024 1024 Number of rows per table limited by storage limited by storage limited by storage limited by storage Number of bytes per row (Excluding TEXT/MEMO/IMAGE/OLE) 2 KB 8 KB 8 KB 8 KB Number of columns per query 255 4,096 4,096 4,096 Number of tables per query 32 256 256 256 Size of procedure / query 64 KB 250 MB 250 MB 250 MB Number of input params per procedure / query 199 1,024 2,100 2,100 Size of SQL statement / batch 64 KB 64 KB 64 KB 64 KB Depth of subquery nesting 50 32 32 32 Number of indexes per table 32 250 (1 clustered) 250 (1 clustered) 250 (1 clustered) Number of columns per index 10 16 16 16 Number of characters per object name 64 128 128 128 Number of concurrent user connections 255 32,767 32,767 5
View Replies !
View Related
Bit-data From SQL Server 2000 (2005 Working, 2000 Doesn't)
Hi, I am trying to edit some data from a SQL2000-datasource in ASP.NET 2.0 and have a problem with a column that has bit-data and is used for selection. SQL2005 works fine when declaring <SelectParameters> <asp:Parameter DefaultValue="TRUE" Name="APL" Type="boolean" /> </SelectParameters>When running this code with SQL2000, there are no error-msgs, but after editing a record the "APL"-column looses its value of 1 and is set to 0. Looks like an issue with type-conversion, we've hit incompatibilities between SQL200 and 2005 with bit/boolean several times before. So, how is this done correctly with SQL2000? (I've tried setting the Type to "int16" -> err. Also setting Defval="1" gave an err) ThanksMichael
View Replies !
View Related
Problem Using Access 2000 As A Front-end To SQL Server 2000 Tables
I've created a small company database where the tables reside in a SQLServer database. I'm using Access 2000 forms for a front end.I've got a System DSN set-up to SQL Server and am using links withinAccess 2000 to get to the SQL Server tables.My forms worked fine until I made a few minor changes to the databaseschema on SQL Server (e.g. added a foreign key, or added a column).After that, all the links break - I click on a table link and get anerror msg like "invalid object name."Deleting the links after a schema change and re-adding the links seemedto fix the problem. The forms I'd already created seemed to work fineafter re-creating the links.But then I got more advanced with my forms. I have it set up so thatfor certain entry fields, the combobox gets populated with values froma table (the description appears in the drop-down and the correspondingprimary key value gets populated in the table). I created a number offorms using this technique, entered data, and everything worked fine.Made a small schema change and it broke everything -- not the actualtable links, but the functionality for the drop-downs. My values nolonger appeared, and this was true for forms that accessed tables whoseschemas did not change.This is driving me nuts. Is there any way to keep my forms frombreaking each time I make a small schema change?Thanks.- Dana
View Replies !
View Related
Problem By Design - MS-SQL Server 2000 And MS-Access 2000 Project.
Hi.Sorry for cross posting!After I've installed MS-SQL Server 2000, I've got a problem each time I opena table, view or diagram in design, in a MS-Access project.Something like a table is popping up, but only the headline of the table,there is no name in the headline. The (ghost) table is automatic gettingfocus, (like a dialog box), and I can't do anything.I can close the (ghost) table using ALT-F4 combination, but it is veryannoying me.I've tried to uninstall both the MS-SQL Server 2000 and MS-Access 2000, I'vealso tried to compact and repair the database without luck.If I connect to MS-SQL Server 7 on another computer, (same database),everything is fine.My OS is Windows XP Home edition; the MS-SQL Server 7 is running on Windows98.Does anyone here have had the same experiences?TIAJørn
View Replies !
View Related
Windows 2000 Sp4 && SQL Server 2000 Causes Java Core Dump
I've just started getting this EXCEPTION_ACCESS_VIOLATION (0xc0000005) on machines using Windows 2000 sp4 connecting to SQLServer. This is crashing JVMs (multiple Sun versions and BEA also) in the Java VM frame (outside our code). This has just started recently - perhaps with the last set of patches? Has anyone else seen this or know what I could do to get more information? Could this be related to updates to named pipes? Thanks! -Brian Temple
View Replies !
View Related
Converting Data From Access 2000 To SQL Server 2000
Hi, I worked on a project in ASP.NET using SQL server 2000 as the back end. Its a conversion application that I rewrote in ASP.NET using C#. I need to import the old data in Access db into SQL server 2000 and I have very little knowledge about doing it. The data in not a direct one -one transformation. There are considerable changes to the Database design and data types. Any help and suggestions wud be really helpful. Also, any article links wud be great. Thanks
View Replies !
View Related
Importing Data From Pervasive 2000 To SQL Server 2000
I am working on bringing data into our SQL Server from a btreivedatabase through Pervasive.It seems to work, mostly, but I am having problems with dates.At first, all date conversions from btreive field type Date to SQLServer SmallDateTime would produce nothing but errors of this sort:ActiveX Scripting Transform 'DTSTransformation_1' encountered andinvalid data value for 'HomesteadDate' source column.Looking into the data on the pervasive side, many of the the datefields had no data in them.I tried to get around this by changing all lines that brought overdates from this:DTSDestination("HomesteadDate") = DTSSource("HomesteadDate")to this:IF ISDATE(DTSSource("HomesteadDate")) = 1 THENDTSDestination("HomesteadDate") = DTSSource("HomesteadDate") ELSEDTSDestination("HomesteadDate") = NULLWhat I have discovered since then, is that all my dates are simplyfailing the ISDATE check and returning null to the SQL Server, evenwhen it is a valid date.Any suggestions would be greatly appreciated.Steve HoyerGPW, MI
View Replies !
View Related
SQL Server 2000 - Problems When Installing Windows 2000 SP4?
I installed Windows 2000 SP4 on my server this evening. We ran intoan odd error, and (1) wanted to share, and (2) wanted to see if therewere any other things I should be on the lookout for.The problem we ran into this evening was "no storage was available".Email wouldn't work, Openqueries to other systems didn't work, and Icouldn't log in except as SA. Solution: upgrade IE to 128bitencryption. Since it's a server, I've never bothered upgrading theWeb browser on the system, but apparently SP4 does do something withthe encryption that breaks things. CryptoApi errors.We upgraded IE and it seems fine now, but I wanted to see if there wasanything else like this I should be on the lookout for. Thanks.
View Replies !
View Related
Access 2000 On Windows 2000 Can't Interact With SQL Server 7.0
We have a SQL Server 7.0 system in NT 4.0 environment. We upgraded our users to Access 2000 and started to work with this. Now we installed a new server which is Windows 2000 based and the domain is different from the SQL servers domain. We then installed Access 2000 on Windows 2000 to use with terminal server. But I noticed that there was a problem with the program. I then looked at the program which was written on Access 2000 and saw that the tables and views can't be seen. The program runs but I can't see the views and tables. Another thing is access disconects from SQL Server when I want to see the tables. So what can be the problem. In one part there is an Access 2000 on Windows 2000 server. On the other part SQL Server 7.0 on Windows NT 4.0. And Access can't see the tables in SQL server.
View Replies !
View Related
Sql 2000 Installation On Windows 2000 Advance Server
I am trying to install microsoft sql server 2000 enterprise edition on a windows 2000 advance server. I keep getting error message A previous program installation created pending file operations on the installation machine. You must restart the computer before running . I have restarted machine and no change. What does error message mean and what is solution?
View Replies !
View Related
|
TRACKER
