InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 10:39:19 GMT20http://www.sqlservercentral.com/Forums/Topic1452409-1437-1.aspxI have created Linked server through Oracle. Linked server created successfully but data showing only one row.Please do the needful...ASAP...Tue, 14 May 2013 01:10:46 GMTrajeshsdbahttp://www.sqlservercentral.com/Forums/Topic1432919-1437-1.aspxI have a really old 6.5 setup. It has an app that hits the db but it was all based on the domain. Nothing in the app controls this the sql service used to run as a domain service account but the server is NT4 and no longer communicates to the domain. We set the service to load as the service account and are trying to load the app as the local admin of the administrator remotely but without luck.Does anyone know of a company that has support resources for 6.5 or anyone have time to work with me to get an answer to help me in figure this out?Oh yeah to add more to the deal the system is on the final hard drive and I'm afraid to reboot it because of that. We are just trying to get it communicating one last time to print off data quickly before the 14 year old compaq dies for good.Tue, 19 Mar 2013 15:44:06 GMTlawson2305http://www.sqlservercentral.com/Forums/Topic1430172-1437-1.aspxHi all, I'm being told I have to scrub invalid data in an input file. I have a 30 character description field with extended Ascii poop causing a failure in my SSIS package, trying to store this in a char column.Is there a simple way using sql to replace ascii values < 32 and > 127 with a space ' '?thanks in advanceTue, 12 Mar 2013 18:50:15 GMTj.bluesteinhttp://www.sqlservercentral.com/Forums/Topic1384553-1437-1.aspxHi All,I have been tasked with testing an OS upgrade.We have a legacy application that runs on XP Pro which uses the SQL 16Bit Client. We are considering deploying the application via Terminal Services hosted on Windows Server 2008 (32bit).When I attempt to install the SQL 16Bit Client in the Windows Server 2008 (32bit) OS I receive the following error:DSHELL caused General Protection Fault in module MSCUISTF.DLL at 0003:1FA2I am not an SQL expert hemce asking here, is there any way to install the SQL 16Bit Client on a Windows Server 2008(32bit)?TIADanielWed, 14 Nov 2012 05:18:10 GMTd_agrichardshttp://www.sqlservercentral.com/Forums/Topic1375881-1437-1.aspxI have the data.Dat and log.dat files, but i find it hard to actually attach it or restore it into sql 6.5. Tried with Stored procedure 'sp_attach_db', but that is not found on the server. Can anyone help me with the sql query to attach DB to this server version. Tue, 23 Oct 2012 01:44:32 GMTpelsebubbhttp://www.sqlservercentral.com/Forums/Topic1309867-1437-1.aspxHi - I had a database in SQL 2000 and want to move it to SQL 2005. I made a backup copy in SQL 2000. When restoring it the SQL 2005, I receive message stating that it does not recognize the format. Any tips on this? Thanks.Fri, 01 Jun 2012 10:53:08 GMTjudyhouhttp://www.sqlservercentral.com/Forums/Topic1309798-1437-1.aspxHi - I need to repair index in 6.5 versionplease provide me DBCC commandThanksFri, 01 Jun 2012 08:56:58 GMTnihal9200_kwadahttp://www.sqlservercentral.com/Forums/Topic1265084-1437-1.aspxDoes anyone know where I can find the documentation(online) for v6.5? Specifically I'd cherish a list of valid system views in 6.5, i.e. which ones are today's equivalent of sys.dm_exec_connections, sys.databases, etc. etc. I know 6.5 allowed access to the syslogs view (to see inside the t/logs - hurrah) but aside from this nugget, I'm not sure what views were available in this product.Reason being I have to troubleshoot a 6.5 box later today, considering this was released when I was 12 years old I am anticipating some trouble.Wish me luck / send me links! Thank you.Mon, 12 Mar 2012 05:39:43 GMTderek.colleyhttp://www.sqlservercentral.com/Forums/Topic1267141-1437-1.aspxHi, I've eventually managed to get a copy of SQL Server 6.5 and I've made it available for download for SSC users.You will need an FTP client (or command line!) Use 8-bit binary type (TYPE BINARY at cmd line) and a RAR extractor.Server: ftp.derekcolley.co.ukUsername: sqlservercentral AT derekcolley.co.ukPassword: sscFilename: SQL65.RARI'll leave it online for the foreseeable future. There is a manual included in the download.Install by using setup.exe in the I386 folder,documentation is in SQLBKS65. Extras scattered throughout inc. ISQL, DTS client and more.Enjoy!Wed, 14 Mar 2012 16:18:36 GMTderek.colleyhttp://www.sqlservercentral.com/Forums/Topic1261238-1437-1.aspxI am facing a problem, I am installing SQL Server 2000 on Windows 2003,I have changed many systems, changed the name of PCs in Capital and all other recomendations i read from diffirent forms but still not solution.here is some error in sqlstp.log file contents11:06:51 Path successfully updated.11:06:51 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN11:06:51 End Action: UpdateSystemPath11:06:52 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 917792 -U sa -P 11:06:53 Process Exit Code: (-1073741819) 11:07:03 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.11:07:03 Action CleanUpInstall:11:07:03 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT11:07:03 Process Exit Code: (1060) The specified service does not exist as an installed service.very anxiously waitining for this solutions. Iam very very upset and working on this from many many days but same issueSun, 04 Mar 2012 00:00:34 GMTfsdnicehttp://www.sqlservercentral.com/Forums/Topic1235981-1437-1.aspxI have to add a couple new parameters to a stored proc. running on an old sql 2000 server. Obviously I don't want to break existing code so I want to use default values. Does sql 2000 support default values for stored procedure parameters? It seems like defaults came along after sql 2000.Thanks!Fri, 13 Jan 2012 14:46:54 GMTBSavoiehttp://www.sqlservercentral.com/Forums/Topic1154711-1437-1.aspxHi Guys,The backup file is in *.dat.gz which is a Gun Zip File.Please help me in Unzipping the file and then restoring it in Server.Source and destination are of Same versions.Thu, 04 Aug 2011 19:11:29 GMTseven.srikanthhttp://www.sqlservercentral.com/Forums/Topic1142150-1437-1.aspxDear All,I am doing a repointing of the target table in SQL server to another ODBC destination. The problem is, if i were to specify a new target ODBC destination, i have to do the repointing of each column(in the transformation job) to the new target column. There are about 200 jobs and each tables has many columns.Besides this manual and tedious process, would like to seek your expertise or by experience, is there any other simpler yet automated way to perform this task?Thu, 14 Jul 2011 19:57:50 GMTsomeone83http://www.sqlservercentral.com/Forums/Topic1109996-1437-1.aspxIf any one was wondering about the SQL version and their code names, then here it is:SQL Server 6.0 - SQL95SQL Server 6.5 - HydraSQL Server 7.0 - SphinxSQL Server 2000 32-bit - Shiloh SQL Server 2000 64-bit - LibertySQL Server 2005 - Yukon SQL Server 2008 - Katmai SQL Server 2008 R2 - Kilimanjaro SQL Server 2011 -DenaliJust a little bit of light reading before I begin my escapades in the SQL Server Central's forums. :-)Tue, 17 May 2011 00:34:26 GMTMehernoshhttp://www.sqlservercentral.com/Forums/Topic1057520-1437-1.aspxHi , I´d like to know the right procedure to migrate an old version sql 6.5 to Sql 2000 and the right Sql 2000 Collation or equivalent that I need to install in the new Sql 2000 before migrate.This is the 6.5 collation .Sort Order Description ------------------------------------------------------------------ Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set. Sort Order = 52, nocase Case-insensitive dictionary sort order for use with several We stern-European languages including English, French, and German . Uses the ISO 8859-1 character set. Characters, in Order ------------------------------------------------------------------ ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ ¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯ ° ± ² ³ ´ µ ¶ · I was wondering if I could use the DTS to transfer data when the sql2000 is already on.I think that I need to migrate to 2000 before migrate to 2005 or higher , I'm right ??Thks a lot.Alex.Wed, 02 Feb 2011 08:39:13 GMTalex_briseno22http://www.sqlservercentral.com/Forums/Topic705393-1437-1.aspxI have a filed of varchar the holds names of companies. Like 'A & B Cleaners'. What I what to do is to select this.. 'ABClea'. How can I get this done?ThanksJimMon, 27 Apr 2009 15:45:15 GMTjim.rasmussenhttp://www.sqlservercentral.com/Forums/Topic960803-1437-1.aspxHi All,I know this seems a bit like a dated question but I have a server with a few databases and the main process is taking all of the cpu, ( the sqlservr.exe and thread msvcrt40.dll ) . Is this a known bug or issue with these versions ?We have a Win2000 box with 2gb of ramThank youThu, 29 Jul 2010 09:20:28 GMTjrmtlhttp://www.sqlservercentral.com/Forums/Topic945357-1437-1.aspxHi,when i am finding server health i can't able to understand how we check thathow can we monitor the general health of the server?Wed, 30 Jun 2010 04:54:58 GMTvenkatb.dbahttp://www.sqlservercentral.com/Forums/Topic947293-1437-1.aspxhi,can any one tell me,what is the use of tempdb in sql server 2005?Sun, 04 Jul 2010 00:02:38 GMTvenkatb.dbahttp://www.sqlservercentral.com/Forums/Topic945353-1437-1.aspxHi,Please help me ?upgradation from sql server 2000 to sql server 2005, what steps we follow to do this one.migration from one server to another server, what steps we follow.tempdb is full what we have to do?waiting for answersregardsvenkat...Wed, 30 Jun 2010 04:48:41 GMTvenkatb.dbahttp://www.sqlservercentral.com/Forums/Topic809230-1437-1.aspxI have worked with a few old boxes running SQL 6.5, but has never seen SQL 6.0 installed anywhere and stil extant.heard 6.0 was the first version developed by Microsoft (after parting with Sybase) for Windows NT. anyone has worked on it before?Tue, 27 Oct 2009 06:03:10 GMTArun Jebakumarhttp://www.sqlservercentral.com/Forums/Topic852127-1437-1.aspxGood Morning,I am very new to SQL. I am trying to run a SQL on a table to see what changes were made to the system.Can I use one that's on my system in a folder entitled SQL Scripts? or do I need to create one.I am using MSSQL Server 2000 and I Query Analyzer and received error message, table already created.I am trying to find if any changes were made to the table. In this instance a Table was deleted and need to know who deleted it.There is an SQL Files in a Scripts Folder where looks like a query is written that asks it to create a table, but what I am wanting to do is create a log of any changes on that particular table.Hope this makes sense.Again, thank you for your help and patience with helping me to understandHow do I get results of the query?Thank you for your help.Fri, 22 Jan 2010 09:14:52 GMTglee777http://www.sqlservercentral.com/Forums/Topic862178-1437-1.aspx-Mon, 08 Feb 2010 20:36:04 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic758356-1437-1.aspxHello,I am part of a dev group that works with ASP.Net/C#, and we are having a problem. We create lots of stored procedures in the datacenter (they run SQL 2000, in 6.5 compatibility mode), and they work as they should.But sometimes we need to alter these procedures (successfully), including the number of parameters that they receive. If the procedure was executed several times, and the number of parameters that it receive was changed the application returns an error:[URL=http://img32.imageshack.us/i/mysticalerror.png/][IMG]http://img32.imageshack.us/img32/4315/mysticalerror.th.png[/IMG][/URL]We have a workaround to it, drop the old procedure and recreate it, with a new name. It works, but it's not practical and the client don't like to wait.The developer of the "Connection" class says that it's a problem with the database (some kind of strange unknown cache).Somebody have a clue to what is the problem and how to solve it? It's definitelly a problem with the database or the application is the one to blame?Thanks.Thu, 23 Jul 2009 09:34:08 GMTdaniel.aydar.aranteshttp://www.sqlservercentral.com/Forums/Topic767074-1437-1.aspxHi,Firstly I need to point out that I am a complete non user of SQL and know nothing about it. I run a small wholesale company and have a MS SB Server 2003 which runs as a file server and also hosts accounting software, etc that utelises SQL (I guess). It also has pervasive v8 installed.My problem is that I am trying to put on the software from our courier company (TNT) which stores all of the delivery addresses, postcodes, routing information etc and prints the barcode routing lables. Half way through the install it asks for a user name and password to log into the SQL server and install the TNT databases.Trouble is that I dont know them and the company that we brought the server from doesnt know them. I have tried the server administrator log in details, which doesnt work and just about anything else it might be but to no avail.My question is: Is there any way of getting the password or of creating a new user that could allow the installation to continue?Thanks in advance for your help.DaveFri, 07 Aug 2009 09:59:41 GMTdperry-1139696http://www.sqlservercentral.com/Forums/Topic763350-1437-1.aspxHere is my first try at a loop, it is not working and would appreciate any assistance. I want to make sure every userid is unique and if not add a digit to it.DECLARE @i INTDECLARE @id VARCHAR(64)DECLARE @newid VARCHAR(64)DECLARE @count INTSET @id = 'this is the user id'SET @newid = @idSET @i = 0SELECT @count = 0 WHILE 1 = 1BEGINSELECT @count = (SELECT COUNT(*) FROM usertest WHERE userid = @newid)IF @count = 0EXEC('INSERT INTO usertest (userid) VALUES (' + @newid +')')BREAKELSESET @i = @i + 1;SET @newid = @id+@i;CONTINUEEND I am receiving a Syntax error near ELSEPosted this in 2008 forum at first and then realized I was on the 2000 server instead of my 2008 serverAny help would be appreciated,Thank youPHKFri, 31 Jul 2009 13:24:49 GMTpkinnamanhttp://www.sqlservercentral.com/Forums/Topic751468-1437-1.aspxI need to get 6.5 server properties programmatically, but 'serverproperty' is not recognized and @@version is not what I am looking for. Ideas? Thanks!Fri, 10 Jul 2009 15:41:49 GMTstamichttp://www.sqlservercentral.com/Forums/Topic747032-1437-1.aspxwe are running sql 2000 sp3 under a win2000 Sp2 OS. we recently upgraded the server ram from 4 gb to 8gb. afterwards, we started to get the error 'not enough contiguous memory'. we did not have this issue when we were just using 4gb but after the upgrade to a bigger memory we started to get one. before rolling back the upgrade as a last resort, we would like to know if there are settings that we could change/modified to get around this problem. we are constraint by the application we are running to stay in current version of the OS as well as the SQL. Fri, 03 Jul 2009 09:24:18 GMTron.casaulhttp://www.sqlservercentral.com/Forums/Topic735398-1437-1.aspxOn the ms sql 6.5 sp5a, the backup/restore page,when i check on the info button of the backup/restore device (such as tape0) after backup,the size is 0kb,but if restore & check the database,it is ok.Why the info for size of backup database to tape/dump is 0kb????Mon, 15 Jun 2009 19:28:46 GMTliuschttp://www.sqlservercentral.com/Forums/Topic716711-1437-1.aspxHi In SQLSERVER 6.5 how can we check the replication?I need to check the las replicated time of the database.Thu, 14 May 2009 02:20:41 GMTsudarramhttp://www.sqlservercentral.com/Forums/Topic711239-1437-1.aspxHiWe have a lagecy system where long back some one migrated from sql server 65 to sql server 2000(80) but they kept comptatibility level to 65. I could see their are several tables with ansi null off. so I cannot create index on view.and old dba told me not to change this... can anybody tell me what would be the impact on application if we change it to 80 ie. what precousions I should take todo so.Appriciate any help.ThanxVinayWed, 06 May 2009 09:47:57 GMTVinay Thakur-585143http://www.sqlservercentral.com/Forums/Topic639516-1437-1.aspxWe have 5 databses (master and 4 user DB's) that need to be Upgraded from SQL Server 6.5 to 2005.Is there a Standard procedure one can prescribe for the Process.Mon, 19 Jan 2009 14:13:05 GMTsqldba.pareehttp://www.sqlservercentral.com/Forums/Topic691834-1437-1.aspxI'm creating a query with a lot of AND's after the WHERE, but i've noticed that they are not all working. I dont get an error though, i'm just not getting the result that i need.Tue, 07 Apr 2009 04:43:41 GMTpansyleahttp://www.sqlservercentral.com/Forums/Topic681343-1437-1.aspxHi guys, I'm trying to shrink log files in SQL Server 7.0. where I couldn't find an option similar to 2000 or 2005! Please tell me how do I go ahead in Enterprise Manager. Also, tried my hand with DBCC ShrinkFile, but nothing seems to be happening when I run the SQL statement, it just returns the following values:columns "'DbId,FileId,CurrentSize,MinimumSize,UsedPages,EstimatedPages"Help me guys!!Thanks in advance!Mon, 23 Mar 2009 06:03:23 GMTCobra-1032610http://www.sqlservercentral.com/Forums/Topic659571-1437-1.aspxHiI have tried and failed many times now to try and get my head round this problem but its cropped up again and I could really do with some help.:blink:I have a registration (2 in the example) and they each have a number of conferences against them.The example data is as follows/****** Object: Table [dbo].[ECAFALL] Script Date: 18/02/2009 11:10:05 ******/CREATE TABLE [dbo].[Registration_Conference_Dates]( [Registration_ID] [int] NULL, [Conference_Actual_Date] [datetime] NULL, [Number of Conferences on date] [Int]) ON [PRIMARY]INSERT INTO [dbo].[ECAFALL](Person, Type, [ID], START_DATE, END_DATE)SELECT 12054, 'ECAFSTD', 496815, '2007-08-29 13:37:35.923', '2007-08-29 13:38:15.357' UNIONSELECT 17039,'2008-07-15 00:00:00.000',3UNIONSELECT 17039,'2008-12-04 00:00:00.000',2UNIONSELECT 17039,'2009-02-13 00:00:00.000',3UNIONSELECT 18867,'2005-12-21 00:00:00.000',2UNIONSELECT 18867,'2006-03-07 00:00:00.000',2UNIONSELECT 18867,'2006-07-11 00:00:00.000',7UNIONSELECT 18867,'2006-12-13 00:00:00.000',5How do I get the above into this format.......Registration_ID Date1 Date2 Date3 Date4 17039 '2008-07-15 00:00:00.000' '2008-12-04 00:00:00.000' '2009-02-13 00:00:00.000'18867 '2005-12-21 00:00:00.000' '2006-03-07 00:00:00.000' '2006-07-11 00:00:00.000' '2006-12-13 00:00:00.000'The Registrations can have up to 30 dates attatched. This is intended to create just one row of data for each registration showing the entire life of the processWed, 18 Feb 2009 09:46:52 GMTDebbie Edwardshttp://www.sqlservercentral.com/Forums/Topic671253-1437-1.aspxHi,Please help me in bcp in the below data structure to the data base ...feb2009 SMART/SMART SMART/SMART 89810000005 USD 13224.18 feb 2009 GCN & Telex MIS ChargeOut OUCGB2833 OUCZ14040 feb2009 SMART/SMART SMART/SMART 89810000003 USD 18.75 feb 2009 GCN & Telex MIS ChargeOut OUCGB2833 OUCZ14040 feb2009 SMART/SMART SMART/SMART 89810000004 USD 71.51 feb 2009 GCN & Telex MIS ChargeOut OUCGB2833 OUCZP1073 feb2009 SMART/SMART SMART/SMART 89810000005 USD 1358.61 feb 2009 GCN & Telex MIS ChargeOut OUCGB2833 OUCZP1073 feb2009 USDDAUSD/0010990765 US00001/0000000007 89810000001 USD 1.80 feb 2009 GCN & Telex Cash ChargeOut GB00002/0000GB2833 feb2009 USDDAUSD/0010990765 US00001/0000000364 89810000001 USD 25.67 feb 2009 GCN & Telex Cash ChargeOut GB00002/0000GB2833 feb2009 USDDAUSD/0010990765 US00001/0000000507 89810000001 USD 10.00 feb 2009 GCN & Telex Cash ChargeOut GB00002/0000GB2833 feb2009 USDDAUSD/0010990765 US00001/0000000676 89810000001 USD 0.57 feb 2009 GCN & Telex Cash ChargeOut GB00002/0000GB2833 feb2009 USDDAUSD/0010990765 US00001/0000000679 89810000001 USD 13782.07 feb 2009 GCN & Telex Cash ChargeOut GB00002/0000GB2833 feb2009 USDDAUSD/0010990765 US00001/0000000679 89810000002 USD 51.38 feb 2009 GCN & Telex Cash ChargeOut GB00002/0000GB2833 The column names of the table should be ..1) Billing Cycle 2) SVC Provider Org Code3) Customer Org Code4) Sub Product5) Transaction Currency Code6) Actual Cost7) Volume8) Invoice Description9) Other SVC Provider Org Code10) Other Cust Org Code11) Additional Info Thanks in advance,Faizal Ahmed.HSun, 08 Mar 2009 23:25:23 GMTfaizal.hhttp://www.sqlservercentral.com/Forums/Topic675403-1437-1.aspxHi there.. I have a project in my school, and i'm gonna create a database driven website. I will use[b] PHP 5.2[/b] and [b]MS SQL SERVER 2000[/b]. Can someone help me for a step by step tutorial for connecting php to MS SQL SERVER? and for example, my server is on a different computer, how can i link my page to connect to the MS SQL SERVER? Your reply is highly appreciated.. Thanks..Fri, 13 Mar 2009 10:41:32 GMTzairgotschihttp://www.sqlservercentral.com/Forums/Topic667155-1437-1.aspxWhile bulk copying datas from the notepad file to the database using "bcp in", i want to remove the first row (i.e, header part of the data file ). Please provide suggestions to write the format file such that header should not copied to the database.Thanks in Advance,Faizal AhmedTue, 03 Mar 2009 04:05:06 GMTfaizal.hhttp://www.sqlservercentral.com/Forums/Topic620308-1437-1.aspxHi,Can we give a different database name while restoring a backup file in SQL 6.0.can somebody tell me the procedure for restoring a database in SQL 6.0?Tue, 16 Dec 2008 04:58:57 GMTsunandas