SQLServerCentral / Administration / SQL Server 7,2000

Installation Issue

gksharmaajmer — Wed, 18 Apr 2012 06:52:12 GMT

Windows XP SP 3 32 bit P4 2GB RAMInstallation completed of SQL Server 2000, but not able to login, no service found in services.msc nor when I check :C:\Program Files\Microsoft SQL Server\80\Tools\Binn there is no sqlserver.exe. When at command prompt i searched I found it in :C:\sql2ksp3\x86\binnAfter re-installation of 2-3 times, I think its time to write here. Basically, I am oracle DBA, but on my this home PC, I want to install sql server 2000 for my friend's query (performance related one sql want to check here).Kindly tell me what to do ?RegardsGirish Sharma

sp_getapplock useful?

FreeHansje — Wed, 10 Aug 2005 01:58:00 GMT

Hi there,

I'm managing a database where I noticed lock type APP. Never heard of it, could not find anything in BOL, googled the internet and found something about sp_getapplock and sp_releaseapplock. Looked up where these procedures are used in the database, and they are used a lot.

Question: is there any reason why one would use this locktype over the standard locks in SQL Sever? I understand you can lock a specific resource this way. As far as I ca tell no database resources are locked in my situation, but I wonder what would happen if something went amiss and the locked resource is not released.

The database(s) where this situation occurs are BizTalk databases, it is very likely that these locks are part of the BizTalk apl. OS is W2000 + latest sp, DBMS is SQL Server SE + sp3a.

Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install

chulheekim — Wed, 04 May 2011 16:22:33 GMT

I see the message below everywhere in the sql error log file. They appeared only on last Monday. What is this about?Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.or Configuration option 'allow updates' changed from 0 to 0. Run the RECONFIGURE statement to install.

Will SQL7 install and work on Windows 2008 Server?

neil.harding — Fri, 18 May 2012 04:26:59 GMT

Hi All,I currently have an old server running rinning SBS4.5 and SQL7 and need to move it to a VMware server. This is causing potential problems with a backup solution which is not able to backup SBS so we're looking at the possibilty of vreating a Windwos2008 server on the VMware platform and then re-install SQL7 and the apps. Does anyone have any experience on this, will it work??Huge thanks if you canhelp.Neil

Deadlock sarted after upgrade the OS and SQL from 32 bit to 64 bit

prodyut.dasgupta — Wed, 09 May 2012 02:20:55 GMT

Recently i have upgrade my SQL server from 32bit to 64 bit(OS Win 2003 64bit/SQL 2005 64 bit) . After upgradation i noticed continous deadlock on one table. Can any one help to resolve this issue

Log Shipping Backup Failure..

jblovesthegym — Tue, 15 May 2012 04:51:49 GMT

I should really say "Restore failure", but anyway...Here's the Event Log chain...The backup data in '\\OurServerName\T$\LOG_RESTORE\XXXXXXXXXX_tlog_201205141815.TRN' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable.Error: 644, Severity: 21, State: 5Could not find the index entry for RID '362d2b9b000200000100100002000000' in index page (1:5496937), index ID 12, database 'XXXXXXXXXXXXXXXX'..Error: 3314, Severity: 21, State: 3Error while undoing logged operation in database 'XXXXXXXXXXXXXXXX'. Error at log record ID (294398:764:9)..

Can't Get DTS To Import Properly

sdownen05 — Mon, 14 May 2012 13:18:57 GMT

I have a spreadsheet that contains a dozen items. I want to create a DTS package that will import the items into a table. Using this code, it shows what I would like it to look like:[code="sql"]--===== If the test table already exists, drop it IF OBJECT_ID('TempDB..#ItemSim','U') IS NOT NULL DROP TABLE #ItemSimGO--===== Create the test tables and insert test dataCREATE TABLE #ItemSim (Item NVARCHAR(30), ItemDesc NVARCHAR(40)) INSERT INTO #ItemSim (Item, ItemDesc)SELECT '8.33963', 'Widget1' UNION ALLSELECT '8.33985', 'Widget2' UNION ALLSELECT '101934', 'Widget3' UNION ALLSELECT '102437', 'Widget10' UNION ALLSELECT '102807', 'Widget11' UNION ALLSELECT '002-119752', 'Widget12' UNION ALLSELECT '06-217-8', 'Widget13' UNION ALLSELECT '06-255-3', 'Widget14' UNION ALLSELECT '1P102158', 'Widget19' UNION ALLSELECT '1P102164', 'Widget20' UNION ALLSELECT '1P102167', 'Widget21'--==== SELECT the records SELECT * FROM #ItemSim--==== Actual ResultItem ItemDesc--------- --------8.33963 Widget18.33985 Widget2NULL Widget3NULL Widget10NULL Widget11002-119752 Widget1206-217-8 Widget1306-255-3 Widget141P102158 Widget191P102164 Widget201P102167 Widget21[/code]Using DTS, the actual result returns NULLS for all items that have ONLY numbers in them. Even if there is a period or a dash it will import, but not a numbers-only record. I have formatted and reformatted the Excel spreadsheet, (Saved as Excel 97-2003), but I can not get it to work.Is there a parameter I am missing, or a trick I don't know about? I am completely stuck, and need this for production. BTW, the real life spreadsheet contains almost 30,000 items, so I can't use Excel 5.0-95. It is also 60 columns wide.I will gladly give you any more information you may need to help me solve this problem. I am open to any solution, whether or not it is DTS.Thank you.Steve

SQLSERVERAGENT

Sponge-592981 — Mon, 03 Mar 2008 13:18:33 GMT

Fellow collegues,I can not restart my sql server agent. I check the sql logs and nothing, however there are a series of application logs that suggest regesitry and .dll files are not there or can not be read. I will include all of the errors and informational messages I think is pertinent. I have checked online and checked and checked and can not find anything concrete. Please Please Please if you have seen this error provide as much as detalied information to resolve it.FYI: I am starting this service with the same start up account id as for SQL Server Services. I tested the login and it logins in successfully through terminal services and is included ofcourse in the local administrator group.Application logs indicate the following error:Event Type: InformationEvent Source: SQLSERVERAGENTEvent Category: Disk Event ID: 102Date: 3/3/2008Time: 11:32:21 AMUser: N/AComputer: LBMKT1QASUNWHDescription:The description for Event ID ( 102 ) in Source ( SQLSERVERAGENT ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: The event log file is corrupt..Event Type: ErrorEvent Source: SQLSERVERAGENTEvent Category: Disk Event ID: 103Date: 3/3/2008Time: 11:32:21 AMUser: N/AComputer: LBMKT1QASUNWHDescription:The description for Event ID ( 103 ) in Source ( SQLSERVERAGENT ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: Unable to connect to server '(local)'; SQLServerAgent cannot start.Event Type: ErrorEvent Source: UserenvEvent Category: NoneEvent ID: 1000Date: 3/3/2008Time: 10:49:51 AMUser: NT AUTHORITY\SYSTEMComputer: LBMKT1QASUNWHDescription:Windows cannot unload your registry file. If you have a roaming profile, your settings are not replicated. Contact your administrator. DETAIL - Access is denied. , Build number ((2195)). Event Type: InformationEvent Source: MSSQLSERVEREvent Category: Disk Event ID: 17055Date: 3/3/2008Time: 10:22:26 AMUser: SUNAMERICA-LA\rrahyabComputer: LBMKT1QASUNWHDescription:The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 8128, Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_msver'..Data:0000: c0 1f 00 00 0a 00 00 00 À.......0008: 0e 00 00 00 4c 00 42 00 ....L.B.0010: 4d 00 4b 00 54 00 31 00 M.K.T.1.0018: 51 00 41 00 53 00 55 00 Q.A.S.U.0020: 4e 00 57 00 48 00 00 00 N.W.H...0028: 07 00 00 00 6d 00 61 00 ....m.a.0030: 73 00 74 00 65 00 72 00 s.t.e.r.0038: 00 00 .. Event Type: InformationEvent Source: MSSQLSERVEREvent Category: Disk Event ID: 17055Date: 3/3/2008Time: 10:17:00 AMUser: SUNAMERICA-LA\rrahyabComputer: LBMKT1QASUNWHDescription:The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 8128, Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'..Data:0000: c0 1f 00 00 0a 00 00 00 À.......0008: 0e 00 00 00 4c 00 42 00 ....L.B.0010: 4d 00 4b 00 54 00 31 00 M.K.T.1.0018: 51 00 41 00 53 00 55 00 Q.A.S.U.0020: 4e 00 57 00 48 00 00 00 N.W.H...0028: 07 00 00 00 6d 00 61 00 ....m.a.0030: 73 00 74 00 65 00 72 00 s.t.e.r.0038: 00 00 .. Event Type: InformationEvent Source: Horizon RCCEvent Category: NoneEvent ID: 1Date: 3/3/2008Time: 7:53:59 AMUser: N/AComputer: LBMKT1QASUNWHDescription:The description for Event ID ( 1 ) in Source ( Horizon RCC ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: MonoSphere Storage Horizon collection being performed from host WHPWMSPHERE1.Event Type: InformationEvent Source: MSSQLSERVEREvent Category: Disk Event ID: 17177Date: 3/3/2008Time: 12:00:57 AMUser: N/AComputer: LBMKT1QASUNWHDescription:The description for Event ID ( 17177 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 1928, 2/29/2008 11:54:44 PM, 3/1/2008 7:54:44 AM.Data:0000: 19 43 00 00 0a 00 00 00 .C......0008: 0e 00 00 00 4c 00 42 00 ....L.B.0010: 4d 00 4b 00 54 00 31 00 M.K.T.1.0018: 51 00 41 00 53 00 55 00 Q.A.S.U.0020: 4e 00 57 00 48 00 00 00 N.W.H...0028: 00 00 00 00 .... :w00t:

Can't get into Local..

Jake Shelton — Sat, 12 May 2012 04:37:03 GMT

Hi all,I've got a questionable installation of 2K at home, obviously I've got full admin rights on it, but the local server continues to come up with "Specified SQL Server not found".Before I do the sanity check of seeing whether 'Master.mdf" actually exists in the 80/90 folder, are there any other steps I will need to take?Thanks, Jake

sys.sysservers table

control — Tue, 10 Mar 2009 07:23:01 GMT

When I query the system table sys.sysservers, two result is displayed in srvstatuscolumn for 2 different servers. One is 1217 and 1089.Can somebody tell me different between srvstatus 1217 and 1089?

Resolving Users/Logins in Log Shipping

jblovesthegym — Thu, 10 May 2012 03:11:37 GMT

Hi all,I've been analysing our in-house Log Shipping documentation, which describes the failover/failback process (from Primary to Secondary and back again), but a comparison of the Technet document...http://technet.microsoft.com/en-us/library/cc966382.aspx ...highlights that ours makes no mention of login resolution. We have two logins ('Archive' + 'Portal' that are common to both the primary and secondary servers, as well as two similarly named users, of which 'Archive' is the main app user.But...when I check the 'Users' folder of any of the user db's, I noticed that only the 'Portal' user seems associated with the 'Portal' loginname - the corresponding value for the 'Archive' user is null.Does any of this mean that, if we need to failover, the app won't be able to login to the Secondary server, even after being repointed by the applications team? Thanks,JB

Maintenance Backup & Restricted User Mode

kd11 — Thu, 10 May 2012 08:26:05 GMT

By having a database in Restricted User Mode, will that prevent the backup job in the maintenance plan from running. I'm trying to figure out why the backup(maintenance plan) didn't run.

Looking for the inverse of xp_fixeddrives

Jeff W — Tue, 27 Apr 2004 09:04:00 GMT

master..xp_fixeddrives returns the amount of free space on the fixed drives. I am looking for a command that may return the amount of total space on the fixed drives. Or maybe even a command that will return the total amount of space if the specific drive is specified...

Any ideas?

Jeff

unable to configure SSRS in 2005..WMI error

SQL_kode_kracker — Tue, 08 May 2012 00:06:35 GMT

Hi I am unable to use Report server or report manager in SQl 2005. I am gettin a WMI Error can any one help with this...

Difference between Process and thread

Ponguru.SreenivasaRao — Mon, 10 Jan 2005 06:55:00 GMT

some body help me,i have Q and need A

what is Difference between Process and thread

can a threed kill the process that it belongs to

Can thread kill its sibling thread initated by some process

How do I get fragmentation levels for indexes...

jblovesthegym — Tue, 01 May 2012 05:46:02 GMT

...WITHOUT creating a sproc? Is there a Select I can run to get fragmentation levels for all indexes on a particular table/db/server?

BCP

river1 — Tue, 11 Aug 2009 08:40:01 GMT

Hi, i need to export data from a view to a PSV file.I'm traing to do this t-sql:exec master..xp_cmdshell 'bcp "select * from [database]..test1" queryout "c:\Import.psv" -T -S "server\instancename"'I receive an error:Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve collation conflict for replace operation.I want to export this data to a unicode PSV so that people from Oracle can import it.Can someone help please? thank you

How can we add a new priovider in linked servers

krishnaprasad14 — Wed, 02 May 2012 09:06:49 GMT

Hi,one quick question please ...How can we add a new provider in linked servers .....SQL server all versions...Thank you in Advance...

Delete Tempdb Files which are in use

Lian — Wed, 02 May 2012 05:59:36 GMT

Good Day,I did an investigation on one of my SQL Server 2000 Systems and found that there are two data files for Tempdb on the same disk . I wan to delete one of them . I could not find any posts on the web how to do it . Can it be done or should it be rather left as t is ?

silent uninstall

waeva — Mon, 30 Apr 2012 21:55:38 GMT

how to uninstall sql 2000 from command line, unattended ?are the SQL 2000 setup files required?tried "wmic product get name", but 'Microsoft SQL Server 2000' does not even show up in the list.but it is there in Add/Remove Programs.relevant thread : http://www.sqlservercentral.com/Forums/Topic665317-5-1.aspx

steps after data purge

stephenhai — Mon, 30 Apr 2012 12:37:32 GMT

I am going to do data purging in my databases.I guess it will have around 20% of data will be removed.After that, what thing I need to do?1. re-indexing2. update statistics3. shrink the data files.Please advice what are the best practices after data purge

Cannot Kill Process stays in KILLED/ROLLBACK status

krishnaprasad14 — Thu, 26 Apr 2012 05:16:38 GMT

Hi I have killed one spid bu its still showing this KILLED/ROLLBACK statusSugest me to resolve this with out restating the server please.....[Foun a link here but it's not resolved my issue http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/71d3cd0b-ce4d-4202-8e3b-38b38da90a5b]Thank you in Advance .

Using SSMS to "Edit top 200 rows" on a 2000 server and getting a weird error.

Kenneth.Fisher — Fri, 20 Apr 2012 15:25:35 GMT

I would supply sample tables and data but to be honest I can't replicate the problem. When I right click on the table and say "Edit top 200 rows" then try to edit one of the rows I get the following error:No row was updated.The data in row 1 was not committed.Error Source: Microsoft.SqlServer.Management.DataTools.Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(2 rows).Now I have created a duplicate table, same structure, same indexes, same data and everything works correctly. I've dropped and recreated the indexes with no luck. I've checked for duplicate entries and run a CHECKDB.Anyone have any suggestions?

Bcp in problem

er.rajesh89 — Fri, 27 Apr 2012 08:25:14 GMT

hii want insert some data from a bcp file so i execute a cmd:bcp [Meritus].[dbo].[Chennai1] in "d:\test.csv'" -N -S @@servername -Tbut it show some error:Msg 102, Level 15, State 1, Line 1Incorrect syntax near '.'.how to solve

Patch for MS12-027

jblovesthegym — Thu, 26 Apr 2012 03:55:52 GMT

Hi all,The above patch is in response to the April 10th Security Update at http://support.microsoft.com/kb/2664258, describing a vulnerability "in MSCOMCTL.OCX could allow Remote Code Execution". This leads to another link for the patch at http://support.microsoft.com/kb/983808.However, THIS states that "computer must be restarted"... !!!!Has anyone done this recently, and were there any issues? Also, how do you tell whether to use the GDR or QFE?Cheers,JB

Perfmon output: Converting from binary to CSV file

bj007 — Mon, 17 May 2004 14:57:00 GMT

Hi All,

While collecting perfmon statistics, I saved the file as a binary file my mistake. How do I read the data now from it ?

Is there a way, to convert this file to a CSV format ? Any help grealy appreciated.

bill

Ideas to create notification based on event

Peter D-251663 — Tue, 24 Apr 2012 18:19:50 GMT

We have a system that writes scheduled jobs to a table. This table (PRCS) gets updated based on the jobs status.Some of the columns that track job statuses include begintime, endtime, and job_name.I'm trying to get some ideas to create a sql job to poll the PRCS table every 30mins for a specific job_name that runs for over 6 hours and then fire of a cdosys email if condition is met.Something including SELECT begintime, endtime, job_name from PRCS WHERE jobname = 'nVision' and ......Appreciate insight

user access rights disabled to prticulare database?

ananda.murugesan — Tue, 24 Apr 2012 01:14:56 GMT

Hi,User name -TEST1. Database A2. Database BTest user have rights to access both A&B database. I want disable to access & connect Database A.use Database AgoREVOKE CONNECT FROM TESTplease confirm, does this script valid or invalid? after execute this script TEST user can able to connect Database B.Thanks

please help me

selvakumar.sms — Mon, 23 Apr 2012 04:30:48 GMT

hi all my database is crashed suddenly , now i want to add my mdf and ldf in database using power shellthanks

SQL SERVER 2000 Licensing

bsantosh6 — Fri, 20 Apr 2012 12:50:25 GMT

Hello,We planning migration of 2 SQL 2000 Instances (clustered) to run as standalones on a single server(multiple instance )In the current production setup the licensing Modes are as follows:Server 1 : Per seat for 5 devicesServer 2 : Per seat for 8 devicesI am just beginning the SQL Installs for the Destination Server that will house the 2 instances in the future.Any idea what option I should pick for my licensing?FYI...The server we re migrating to (which will hold 2 instances) will be used as production once we shutdown server1,2.Thanks in AdvanceSantosh

sql server admin books

selvakumar.sms — Tue, 17 Apr 2012 00:52:07 GMT

hi all i am very new to sql server admin. so please suggest some very good books and sites to learn basic and advance of sql server administration.thanks in advace:-P:-P:-P:-PRegardsSelvakumar

Data is only saving in temp db not in .mdf files -- sql server 2000

msmartsairam — Mon, 16 Apr 2012 00:28:02 GMT

Hi,I had situation where one of my windows 2003 server is crashed, after few days we re-installed windows 2003 and then after i installed sql server 2000.Then i attached the .mdf & .ndf files to database.Then i came across some errors like[b]1[/b].Invalid Protocol specified for a ?????t?c?????t?????? instance: ???y?????t?c?????t??????.[b]2[/b].SuperSocket Info: Bind failed on TCP port 1433.[b]3[/b].LogEvent: Failed to report the current event. Operating system error = 31(A device attached to the system is not functioning.).Then on-wards data is not storing in .mdf files (On drive it is showing last files attached date - its not showing recent data when last data is modified) But daily i am taking the backups - backups only is happening.I don't know where does data is saving or storing, every 10 days we restart the server.So please provide any solution for this situation

Importing excel to sql

gharat.mayur14 — Wed, 18 Apr 2012 09:35:30 GMT

.........i m trying this..............EXEC sp_addlinkedserver txtsrv, N'Jet 4.0', N'Microsoft.Jet.OLEDB.4.0', N'D:\DotNet\Book1.xls', NULL, N'Text';GOExec sp_addlinkedsrvlogin 'txtsrv','false',null,'admin',null;select * into map1 from opendatasource('Microsoft.Jet.OLEDB.4.0','Data Source=D:\DotNet\Book1.xls;User ID=Admin;Password=;Extended Properties=Excel 8.0')...[map1$]& i m getting this error..........Msg 7399, Level 16, State 1, Line 1The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)"..........plz help me..............

Log shipping backups running for excessive lengths

jblovesthegym — Wed, 18 Apr 2012 08:41:52 GMT

Hi all,We run log shipping every 15 minutes, and I've noticed (via Idera DM) that some backup jobs run for long periods (several thousand % longer than average, and possibly longer than 15 mins). It is my understanding that log shipping is largely self-healing, however we have had a problem with some databases going 'Suspect', and I'd like to address the issue if only to eliminate it from our troubleshooting.QUESTION:Is there a script that reveals run-times for log backups?

Reindexing Tables used in Log Shipping

homebrew01 — Sun, 18 Nov 2007 11:45:51 GMT

I have several databases just set up for log shipping to another server. Previously, I would set the DB to SIMPLE recovery, run DBCC DBREINDEX, then set it back to FULL recovery.But now that they're used for Log Shipping, I imagine that my previous strategy would break the transaction log chain. If I run DBCC DBREINDEX in FULL mode, then I'll generate big transaction logs, and those T-Logs will get pushed to the secondary server.What's the best practice for doing DB maintenance for databases used in Log Shipping ?? Thanks in advance.

Alerting

jblovesthegym — Tue, 17 Apr 2012 04:57:35 GMT

Hi all,We have an ongoing situation where our DBA team is being overalerted, with even trivial issues (like a backup succeeding) being flagged as 'Critical', and as such they are being overwhelmed with alerts, in addition to existing workload.Over the next week or two I want to investigate what software is generating these alerts, who gets them etc, and if anyone has a list of best practices, I'd like to have it.We have Idera DM in operation on one of our clusters, but at the moment I'm only using its dashboard, which I refer to as part of my morning checks, and then several times a day - not the ideal method of keeping on top of things.What I envisage for alerting categories would be the following:Critical - issue that merit an immediate response, ie a backup job failing, service stopped etc;Moderate - An issue that should be looked at immediately and a response scheduled when convenient to the business, ie backup jobs running over x seconds, indexes fragmented over x% etcInformational - Trivial issues, ie a known user filling a disk to just over 80% for a few seconds during staging ops.I would like some input on what kind of alerting you good people do, best practices, even if it's for versions other than 2K.Cheers,JB

SQLServer 2000 Using Ram

zsafakhah — Mon, 16 Apr 2012 04:55:26 GMT

Dear Friends,My Company had a server with 4G ram and Available Ram equal 323,232K. when i stop MSSQLServer Service available Ram equal 3,323,232K. why this happend?i want increase Available Ram when MSSQLServer Service is run?what i should do? Best Regards,Zohreh:cool:

Performance issue

Ratheesh.K.Nair — Tue, 17 Apr 2012 04:13:12 GMT

Hi Experts,Application team got error from their end that system database is overloaded.We have run some initial set of counters under the assumption that its memory bottleneck. Please find the counter values belowUser connections are below 100,CPU utilisation is below 30% most of the timesPage lookups : High Free Pages: Low Page Life expectancy: Low value most of the timesDatabase page: HighBuffer cache hit ratio: High Pages\sec(Server):LowBut we are not able to come to a conslusion.Please help

SQL_Latin1_General_CP1_CI_AS on sqlserver 2000 install

Adonia Delavigne-521648 — Sun, 15 Apr 2012 23:28:37 GMT

Hi I have to create an as close to exact copy of a prod sql2000 as possible as part of our move to sql2008. The details are as follows:current prod config - sqlserver 2000 sp4 (8.00.2055) with SQL_Latin1_General_CP1_CI_AS on WindowsServer2003 ver5.2(build 3790.srv03_sp2_gdr.111025-0634: service pack 2)on WindowsServer2003 ver5.2(build 3790.srv03_sp2_gdr.111025-0634: service pack 2) US Englishnew test config - sqlserver 2000 __soon_to_be_the_same_ on WindowsServer2003 ver5.2(build 3790.srv03_sp2_gdr.101019-0340: service pack 2) US EnglishMy problem is I cannot select collation SQL_Latin1_General_CP1_CI_AS either with the collation designator section, or sql collations section of the collation settings install menubox and I have used two different ISO images. After an install I get SQL_Latin1_General_CI_AS.Any suggestsions would be welcome as I cannot see an obivous reason for this bottleneck.Regards Adonia

SQL Server OR Postgresql

mjschwenger — Wed, 17 Mar 2004 09:14:00 GMT

Hi,

here is my problem or, may be, it sounds more like a joke...

We are running SQL Server 2000 (Enterprise and Standard) on Win 2000 & 2003. Bought licensing and everything.

Although as DBA I do not have any serious issues (my major problems are when SQL backup doesn’t find the network path – bad switch, or domain problems – PDC down), my boss thinks “SQL is unstable” and proposed to switch to Postgresql and eliminate SQL Server. The reason – “it’s for free” and it’ll be “more stable”…

I did look at the FAQ and Manuals on the postgresql website and it did not look any better to me. The worst is that there’s not a way to compare – no concrete data…

For example: It says: ”can use concurrent connections”, but how many, on what hardware, etc. – it does not say…

Anybody using postgresql? Somebody knows some articles for comparison?

Any thoughts are greatly appreciated.

Thanks,