Running Both 2000 & 7

May 2, 2002

Is it posssible to have a machine with both SQL 2000 Server and SQL 7 Server running on it? OS is NT4 with the latest SP.

View 2 Replies


ADVERTISEMENT

Running SQL 6.5 And SQL 2000 As 2 Instances

Feb 9, 2001

Hi all

We are planning to upgrade vom SQL 6.5 to SQL 2000 and SMS 1.2 to SMS 2.0. We want to first migrate SMS 1.2 to 2.0 with the SQL 6.5 database. Afterwards we want to install SQL 2000 as a second instance on the sql 6.5 server and migrate from there our databases. Is this the best way to do this? Does anybody have experience with running two instances of different SQL-Versions on one server? and what kind of trouble can I expect to run into?

Any tips & tricks are welcome

Thanx
Aragorn

View 1 Replies View Related

SQL Server 2000 Running DTS Package From Dos

Aug 29, 2001

Has anyone been able to run a DTS package from DOS. When I execute the dtsrun command it fires the process off in another Dos session and quickly closes. I know that SQL 7.0 worked ok. When it runs from dos it tell you when each step runs successfully or fails. I am Running Windows 2000 Server SP2 and SQL 2000 SP1. So the question is, is there any way to run the dtsrun utility from dos so you can see what is going on?

Any help would be appreicated!

Cory

View 1 Replies View Related

Running Two Servers W/SQL 2000 - Ideas? Help?`

Feb 22, 2005

I had a website that ran with one server that had SQL 2000 as the DB. I have upgraded to two webservers with MS SQL 2000 on both machines and a load balancer in front of the two servers to handle sending requests to the server with the least load.

My problem is, I am not sure how to start to work my second server with the MS SQL. I need to make sure both DB's are exact duplicates of each other so if a user hits one server they are pulling up the same info as another user hits the other server.

I have a lot of queries running on the ASP pages I use, several pages use search forms for many various processes, and I have several pages that are for users to input information that is to be stored and sent out via email to all the other members.

Not by any means am I a SQL guru of any kind, I am lucky I know what it is

So, can anyone point me in the right direction as to what I should look for or into to work the best possible process to keep these DB's mirrored?

Now these servers are on their own private network using a second NIC card, I did this so the SQL can talk between the servers without using the public network bandwidth.

How do I keep these SQL DB's duplicated?
What are some great suggestions?
Have you done this before? if so, what has worked best for you? Is it hard to do for someone with limited DB experience? (I learn really quick if I know what I need to learn)

At this point I am confused as to what the best practice would be. Help?

View 2 Replies View Related

SQl 2000 && 2005 Running On Same Server

Jul 30, 2007

Hi,


I've installed sql2005 on a windows 200 server. now the requirement is to install sql2000 also on the same server.

Would like to know if any have experienced and type of problem on having both sql on same server. and if there is any impact on installing sql2000 after sql2005.

thanks in advanced

View 5 Replies View Related

SQL Server 2000 Running Out Of Space.

May 18, 2006

Hi, we have a SqlServer instance in production containing around 10databases.It has just been realised that all the db's are held on the small c:partition with only a gig or so of space left.On the server there is another partition and another hard disk bothwill ample space (few hundred gigs).What would be the best way of getting the data onto the otherpartitions with minimal impact on the applications. Can we move theprimary data files for each db? Should we just create secondary datafiles on the big partitions for all the db's? Is there a method ofmoving all the data at once?Any ideas on how we should approach this?(ps we dont have control of the sqlserver its outsourced, so simplerthe better).Thanks,Jim

View 2 Replies View Related

Running SQL 2000 And SQL 2005 Simultaneously

Sep 6, 2007

I have seen information on the web about running two versions of SQL at the same time on the same server but was wondering any tricks of the trade regarding it. The main recommendation that I have seen is to have SQL 2000 SP4 running first as the default instance (which is my current situation on a development server) and then install SQL 2005 as a named instance on it. Should the SQL 2005 installation place its files in a dedicated directory (ie, C:SQL2005) as opposed to the default directory that the installation would normally write to, thus not overwriting any SQL 2000 system files? Any other recommendations?

View 1 Replies View Related

Query Running In SQL Server 2000

Sep 12, 2006

When you are inserting/altering a table and you expect values to be added, should you see the number of rows affected at the bottom of the query screen as the time goes by or not?

thx,

Kat

View 1 Replies View Related

Sql 2000 32 Bit Running On 64 Bit 2003 Server With AWE Set!!!

May 23, 2008


I€™m having a few issues with a server that keeps grinding to a halt and having frequent system issues requiring a reboor. It is Sql 2000 32 bit enterprise edition running 64 bit 2003 server. Im not sure of the impact of having the AWE switch set for this server because even though it has 8Gb of RAM it is only using 262Mb and is used extensively. It is set to dynamically configure sql server memory with a minuimum memory of 3075 and maximum of 6144

Is it worth me removing the AWE option or are there any more tweaks I can make to make this system run more effectively?

View 18 Replies View Related

Running SQL Query From Batch File- MS SQl 2000

Mar 25, 2008

Hello,
I am looking for some way to run a sql query from a batch file on the SQL server. The query needs a user entered parameter, if that can be accomodated it would be great.
I read about some osql command & tried to run it but it kept saying "Server does not exist or access denied."
Please give me the steps to go about this.
Thanks,
-R

View 4 Replies View Related

Application Slow - Running Double Take 4.4 On SQL 2000

Jun 6, 2005

Hi,

We are having SQL2000 Advance Server.
4 processor with hypherthreading, Memory 4 GB and it is a high transactional OLTP server. We are also running Transaction Replication on that server.

We recently bought Double Take and implemented on the server with File Difference with block check sum option for Disaster Recovery Purpose.
The Queue and the Log file folder is on local drive where the system doesn't use that folder except double take.

We are replicating from Source to Taget thru the WAN (DS3).We are replicating approx. 200 Gig of Data but just the difference.
Now the CPU usage is normal,Memory utilization is normal, but the network is a major problem as the Applications connecting to the Server timesout and the applications running very slow.

We have set just like the Tech support recommended.

I would appreciate, if someone give us some recommendations to run the double take without any problem.

Thanks in advance.
Anu

View 3 Replies View Related

List Of SQL Server 7.0/2000 Instances Running

Jun 28, 2004

How to get the list of instance of SQL Server 7.0/2000 running on the local machine inside my domain...
I need to prepare the list of all sql instances.. pls help if possible to find details using sql query.

View 1 Replies View Related

Running SQL Server 2000 And 2005 On The Same Computer

Nov 4, 2005

Does anyone know whether or not both versions can be installed on the same machine?

View 1 Replies View Related

SQL 2000 Running Scripts In Query Analyzer

Mar 25, 2008

Does anyone know how to run a script to get the log size and log space?

When I run the following command it does not work and I don't know why.

DBCC SQLPERF (logspace)

USE [master]
GO
SELECT *
FROM sysfiles
WHERE name LIKE '%LOG%'
GO

EXEC sp_spaceused

If I run this command on a different server I get the ouput that I need. Any help would be greatly appreciated.

msr976

View 4 Replies View Related

Running SSIS Package On SQL Server 2000 ?

Oct 19, 2007

Hello!

I´m currently developing an import/export package in SSIS. I recently realized that this package is supposed to be run on a SQL Server 2000 instance, and I have no clue if this will work...
I´m pretty new to SQL Server, but I now that DTS from 2000 ws replaced by SSIS in 2005,
and the command-line dtsrun replaced by dtexec.

So my question: Will I be able to run a SSIS package on SQL Server 2000, and how would I do that?



Regards,

Daniel

View 3 Replies View Related

Running SQL 2000 On Windows 2003 64-bit Intel

Jan 23, 2008

Can SQL 2000 32 bit run on a Windows 2003 64-bit Intel OS installation? What about the SQL 2000 64 bit version? Is the Enterprise Edition required for this?

View 1 Replies View Related

Running SSEUtil On SQL Server 2000/2005

May 23, 2008

Hi,

I have three systems that running different version of SQL sever..
1. my notebook - SQL Server Express 2005
2. my WS - SQL Server 2005 Standard
3. my server - SQL Server 2000

I installed SSEUtil to all of them and only the notebook works..
I read the Read me but it doesn't help me resolve my problem so I hope someone from this forum can help me out..

The problem:
Running sseutil on system 2. and 3. get this error, but not on 1.
SSEUtil
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Additional information:
The service 'MSSQL$SQLEXPRESS' is not installed.


I tried -m but it doesn't help..

Any idea how to fix it?

Thanks,

T.

View 8 Replies View Related

Running SSIS Package On SQL Server 2000

Apr 29, 2008

Hi,

I've an SSIS package that needs to run on our legacy database which is SQL server 2000. Is it possible?

View 1 Replies View Related

Running 2005 SSIS Jobs On 2000

Sep 10, 2007

I would like to create an SSIS package in 2005 and run it in 2000. Is there anyway to do this? Or does SQL Server 2000 have a precursor to SSIS? I am trying to create a job to automatically catch and kill orphaned processes.
-Kyle

View 1 Replies View Related

Change Version Of SQL 2000 On Running System

Nov 24, 2006

Hi,

is it possible to change the installed version on a server from SQL 2000 Standard Edition to SQL 2000 Developer Edition?

The server has been a production server and is now only used for testing by development, not from end users.

Best regards, Stefoon

View 4 Replies View Related

Windows 2003 64bit Running SQL 2000 SP4

Sep 28, 2006

I have been running Windows 2003 64bit and SQL2000 SP4 for over 2 months with out any issues.

Sadly we had a server crash "NTldr missing or corrupted"

now when the one engineer looked at it he suggested to reload the server with Windows 2003 32 bit version as there were known compatibility problems between 2003 64bit and SQL 2000 32bit but that you can install SQL 2000 32bit onto a Windows 2003 64 bit server.

Now i dont really believe this statement nor can i find any documentation supporting this. I believe this server might have crashed due to a new patch that was released the last 2 or 3 week either on Windows or SQL. Does anyone know where i can verify what patches was released?

Maybe someone else can share their thoughts with me.



View 3 Replies View Related

SQL Server 2000 Service Not Running In Local Machine

Jul 23, 2005

Hi all,After merged two partitions into one (C: and D: into one C:) byusing Partition Magic, I can't start SQL Server 2000 which waspreviously installed in both C:Program FilesMicrosoft SQL Server80and D:Program FilesMicrosoft SQL ServerMSSQLThe original files in D: (every thing in D: actually) are now copyedin C:Data folder.Other than re-install SQL Server in C:, is it possible to restoredata(files) from D:Data ?Mank thanks to any suggestions/hints.Kind Regards,Bob

View 3 Replies View Related

Installing And Running SQL Server 2000 On Windows Vista

Jan 17, 2008



Hey

Ive read on some pages that it is in fact possible to install and run SQL Server 2000 on Vista. In my university, SQL Server 2000 is still used to teach us about databases and how to administrate them. The computers run Windows 2000 Professional. I need to be able to use 2000 so I can not only have compatibility but also know the steps and all possible conditions and solutions to problems.
Would installing and running SQL Server 2000 on Vista be possible or am I better off using 2005? Is there much difference between these 2 versions?

View 11 Replies View Related

Running MSSQL 2000 Database In A 2005 Server

Jun 26, 2006

I'm running 2000 databases in a 2005 server. Can anyone tell me if there are adverse effects in doing this?
As I understand it, the 2005 performance benefits are available to databases running as 2000(Ver80) But some of the new futures may not be available..
And any documentation from Microsoft/white papapers regarding this subjects are appreciated..

View 8 Replies View Related

Access 2003 Need MSDE 2000 But Running Vista

Jan 30, 2008

I want to view the sample databases within Access 2003. When I try to view them an error message appears saying I need MSDE 2000 but this will not run on Windows Vista which is my operating system. What do I need to view the sample database as well as develop applications within Access using SQL server?

View 1 Replies View Related

Running Scheduled Stored Procedures MSSQL 2000/2005

Jul 15, 2007

 Hi allI am looking for the best method to automate a website's database management. Lets say I have a user registration database and the users register. This sends an automated email to the user with a link to activate the users registration. If the user does not register within 24 hours, his registration must be automatically deleted from the database using a stored procedure.I know how to do this using the global.aspx file, however there must be an alternative way of doing this, especially if the database is an SQL database. I do not know how much MSSQL server access is given to a developer by an as ISP who hosts the website.Can anyone tell me what would be the best method to use.ThxWarren 

View 1 Replies View Related

File Copy To Windows 2000 From NT Server Running Sql7

Jul 20, 2005

We are running SQL 7 on a Windows NT Server. If you copy a 25Mb filefrom this machine to a W2K server, the file copy takes over 5 minuteson a 100Mpbs switched network.Copying the same file to another NT server takes only seconds, andcopying the same file to the W2K server from the 2nd NT server, (whichis not running SQL) takes only seconds also.Has anyone any ideas as to why file copying between this machine and aW2K one will take so long. It is repliacted on 5 further w2K machines.

View 1 Replies View Related

Error Running Script: 80sp4-tools.sql Installing Sql 2000 SP4

Apr 13, 2007

Hello there,



I hope someone can help me with an annoying failure.



While installing sp4, the last running script is going very wrong.



"Error running script: 80sp4-tools.sql"



in the sqlsp.log, there is only an item with Process Exit Code: (1) after 80sp4-tools.sql



this is the log file.



14:15:05 Begin Setup
14:15:05 Version on Media: 8.00.2039
14:15:05 Mode = Normal
14:15:05 ModeType = NORMAL
14:15:06 Loading library - sqlsut.dll (#L1)
14:15:06 Begin: SetupInitialize()
14:15:06 End: SetupInitialize()
14:15:06 Begin: CheckFixedRequirements()
14:15:06 Platform ID: 0xf000
14:15:06 Version: 5.2.3790
14:15:06 File Version - C:WINDOWSsystem32shdocvw.dll: 6.0.3790.2858
14:15:06 End: CheckFixedRequirements()
14:15:06 Begin Action: CheckRequirements
14:15:06 Processor Architecture: x86 (Pentium)
14:15:06 Service Pack: 256
14:15:06 ComputerName: SERVER01
14:15:06 User Name: administrator
14:15:06 IsAllAccessAllowed returned: 1
14:15:06 OS Language: 0x409
14:15:06 End Action CheckRequirements
14:15:06 CreateSetupTopology(SERVER01), Handle : 0x14d46c8, returned : 0
14:15:06 CreateSetupTopology returned : 0, Handle : 0x14d46c8
14:15:06 Topology Type : 1, Return Value : 0
14:15:06 ST_GetPhysicalNode returned : 0, PNHandle : 0x14d4708
14:15:06 PN_EnumerateEx returned : 0
14:15:06 PN_GetSQLStates returned : 0, SqlStates : 0x88020024
14:15:06 PN_StartScan [0x14d4708] returned : 0
14:15:06 PN_GetNext [0x14d4708] returned : 0, Handle: [0x14d55c0]
14:15:06 SQLI_GetPackageId [0x14d55c0] returned : 0, PackageId = 0x2
14:15:06 SQLI_GetVersion [0x14d55c0] returned : 0, Version = 8.00.194
14:15:06 PN_GetNext [0x14d4708] returned : 0, Handle: [0x14d5f48]
14:15:06 PN_GetNext [0x14d4708] returned : 0, Handle: [0x14d6878]
14:15:06 PN_GetNext [0x14d4708] returned : 0, Handle: [0x14d7180]
14:15:06 PN_GetNext [0x14d4708] returned : 18, Handle: [0x0]
14:15:06 ReleaseSetupTopology
14:15:06 This combination of Package and Operating System allows a full product install.
14:15:06 Begin: SetupInstall()
14:15:06 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFilesDir ...
14:15:06 CommonFilesDir=C:Program FilesCommon Files
14:15:06 Windows Directory=C:WINDOWS
14:15:06 Program Files=C:Program Files
14:15:06 TEMPDIR=C:DOCUME~1ADMINI~1LOCALS~1Temp
14:15:06 End: SetupInstall()
14:15:06 Begin: ShowDialogs()
14:15:06 Initial Dialog Mask: 0x8300037, Disable Back=0x1
14:15:06 Begin Action ShowDialogsHlpr: 0x1
14:15:06 Begin Action: DialogShowSdWelcome
14:15:07 End Action DialogShowSdWelcome
14:15:07 Dialog 0x1 returned: 1
14:15:07 End Action ShowDialogsHlpr
14:15:07 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
14:15:07 Begin Action ShowDialogsHlpr: 0x2
14:15:07 Begin Action: DialogShowSdMachineName
14:15:07 ShowDlgMachine returned: 1
14:15:07 Name = SERVER01, Type = 0x1
14:15:07 End Action DialogShowSdMachineName
14:15:07 begin ShowDialogsUpdateMask
14:15:07 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 0
14:15:07 Updated Dialog Mask: 0xbf00035, Disable Back = 0x1
14:15:07 Dialog 0x2 returned: 0
14:15:07 End Action ShowDialogsHlpr
14:15:07 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
14:15:07 Begin Action ShowDialogsHlpr: 0x4
14:15:07 Begin Action: DialogShowSdInstallMode
14:15:07 ShowDlgInstallMode returned: 1
14:15:07 InstallMode : 0x2
14:15:07 End Action DialogShowSdInstallMode
14:15:07 begin ShowDialogsUpdateMask
14:15:07 nFullMask = 0xbf00035, nCurrent = 0x4, nDirection = 1
14:15:07 Updated Dialog Mask: 0xb000627, Disable Back = 0x1
14:15:07 Dialog 0x4 returned: 1
14:15:07 End Action ShowDialogsHlpr
14:15:07 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
14:15:07 Begin Action ShowDialogsHlpr: 0x20
14:15:07 Begin Action: DialogShowSdLicense
14:15:08 End Action DialogShowSdLicense
14:15:08 Dialog 0x20 returned: 1
14:15:08 End Action ShowDialogsHlpr
14:15:08 ShowDialogsGetDialog returned: nCurrent=0x200,index=9
14:15:08 Begin Action ShowDialogsHlpr: 0x200
14:15:08 Begin Action: DialogShowSdInstanceName
14:15:08 Begin Action: ShowDlgInstanceName
14:15:09 This machine has SQL Server 2000 SP3 already installed
14:15:09 Version of installed Service Pack: 8.00.761
14:15:09 The language on the CD is 1033 and installed is 1033
14:15:09 End Action : Verify Language
14:15:09 SKU is : Standard Edition
14:15:09 End Action: ShowDlgInstanceName
14:15:09 ShowDlgInstanceName returned : 0
14:15:09 InstanceName : INSTNAME
14:15:09 End Action DialogShowSdInstanceName
14:15:09 begin ShowDialogsUpdateMask
14:15:09 nFullMask = 0xb000627, nCurrent = 0x200, nDirection = 0
14:15:09 Updated Dialog Mask: 0xbc00627, Disable Back = 0x1
14:15:09 Dialog 0x200 returned: 0
14:15:09 End Action ShowDialogsHlpr
14:15:09 ShowDialogsGetDialog returned: nCurrent=0x400,index=10
14:15:09 Begin Action ShowDialogsHlpr: 0x400
14:15:09 Begin Action: DialogShowSdMaintain
14:15:09 ShowDlgMaintainInstall returned : 1
14:15:09 Type : 0xc
14:15:09 CreateSetupTopology(SERVER01), Handle : 0x14d5f08, returned : 0
14:15:09 CreateSetupTopology returned : 0, Handle : 0x14d5f08
14:15:09 Topology Type : 1, Return Value : 0
14:15:09 ST_GetPhysicalNode returned : 0, PNHandle : 0x14d46c8
14:15:09 PN_EnumerateEx returned : 0
14:15:09 PN_GetSQLStates returned : 0, SqlStates : 0x88020024
14:15:09 PN_GetInstance for INSTNAME [0x14d46c8] returned : 0
14:15:09 SQLI_GetPackageId [0x14d55c0] returned : 0, PackageId = 0x2
14:15:09 SQLI_GetVersion [0x14d55c0] returned : 0, Version = 8.00.194
14:15:09 SQLI_GetSQLStates for INSTNAME [0x14d55c0] returned : 0, SQLStates: 0xc20804
14:15:09 SQLI_GetInstallPath [0x14d55c0] returned : 0, Path = C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME
14:15:09 SQLI_GetDataPath [0x14d55c0] returned : 0, DataPath = C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME
14:15:09 SQLI_GetVersion [0x14d55c0] returned : 0, Version = 8.00.194
14:15:09 SQLI_GetRegKeyRoot [0x14d55c0] returned : 0, RegKeyRoot = SoftwareMicrosoftMicrosoft SQL ServerINSTNAME
14:15:09 SQLI_GetPackageName [0x14d55c0] returned : 0, szPackage = Standard Edition
14:15:09 SQLI_GetPackageId [0x14d55c0] returned : 0, PackageId = 0x2
14:15:09 Previous Install Path: C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME
14:15:09 Previous Install Data: C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME
14:15:09 Previous Install Version: 8.00.194
14:15:09 ReleaseSetupTopology
14:15:09 End Action DialogShowSdMaintain
14:15:09 begin ShowDialogsUpdateMask
14:15:09 nFullMask = 0xbc00627, nCurrent = 0x400, nDirection = 1
14:15:09 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
14:15:09 Dialog 0x400 returned: 1
14:15:10 End Action ShowDialogsHlpr
14:15:10 ShowDialogsGetDialog returned: nCurrent=0x2000,index=13
14:15:10 Begin Action ShowDialogsHlpr: 0x2000
14:15:10 Begin Action: DialogShowSdUpgrade
14:15:10 ShowDlgUpgrade returned : 1
14:15:10 Checking databases on instance 'INSTNAME'
14:15:10 Authenticate access
14:15:10 Begin SDPassword Dialog
14:15:13 End SDPassword Dialog
14:15:13 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe -Silent 1 -Action 6 -Service MSSQL$INSTNAME
14:15:13 Process Exit Code: (0)
14:15:13 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe -Silent 1 -Action 1 -Service MSSQL$INSTNAME -StartupOptions -T4022
14:16:03 Process Exit Code: (0)
14:16:03 D:SQL2KS~1x86BINNosql.exe -SlpcERVER01INSTNAME -n -d master -Q "exit" -o "C:DOCUME~1ADMINI~1LOCALS~1Tempsqlsp.out" -Usa -P"
14:16:04 Process Exit Code: (0)
14:16:04 Begin: CheckSAPassword
14:16:04 Begin: LogOnUsingBlankSA
14:16:04 D:SQL2KS~1x86BINNosql.exe -SlpcERVER01INSTNAME -n -d master -o "C:DOCUME~1ADMINI~1LOCALS~1Tempsqlsp.out" -Q"Exit(declare @ret int if (select count(*) from master..syslogins where name='sa' AND ( (1 = pwdcompare(N'', password)) OR password IS NULL )) = 0 Set @ret=0 else Set @ret=9000 Select @ret)" -Usa -P"
14:16:04 Process Exit Code: (0)
14:16:04 End: LogOnUsingBlankSA
14:16:04 Begin: SdBlankPwd
14:16:04 End: SdBlankPwd
14:16:04 End: CheckSAPassword
14:16:04 Begin : SdErrorReportingDlg
14:16:14 End: SdErrorReportingDlg
14:16:14 Access authenticated
14:16:14 D:SQL2KS~1x86BINNosql.exe -SlpcERVER01INSTNAME -n -b -d master -o "C:DOCUME~1ADMINI~1LOCALS~1Temp~sqldb0.txt" -i "C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBindbverify.sql" -Usa -P"
14:16:37 Process Exit Code: (0)
14:16:37 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe -Silent 1 -Action 6 -Service MSSQL$INSTNAME
14:17:17 Process Exit Code: (0)
14:17:17 Setup Type: Custom (303)
14:17:18 Processing: SQLProg
14:17:18 Processing: SQLProgSQLServr
14:17:18 Processing: SQLProgUpgTools
14:17:18 Processing: SQLProgReplSupp
14:17:18 Processing: SQLProgInstall
14:17:18 Processing: SQLProgSystem
14:17:18 Processing: SQLProgSvrExt
14:17:18 Processing: SQLProgDat
14:17:18 Processing: SQLProgDatSmpl
14:17:18 Processing: SQLProgBaseSys
14:17:18 Processing: SQLProgBaseBinn
14:17:18 Processing: SQLProgMSSearch
14:17:18 Processing: SQLProgBaseInst
14:17:18 Processing: SQLProgUI
14:17:18 Processing: SQLProgSymbols
14:17:18 Processing: SQLProgPerfmon
14:17:18 Processing: SQLProgRoot
14:17:18 Processing: SQLProgEXE
14:17:18 Processing: SQLProgDLL
14:17:18 Processing: MgtTool
14:17:18 Processing: MgtToolSEM
14:17:18 Processing: MgtToolProfiler
14:17:18 Processing: MgtToolQryanlz
14:17:18 Processing: MgtToolDTCCLi
14:17:18 Processing: MgtToolWzcnflct
14:17:18 Processing: MgtToolUtilSys
14:17:18 Processing: MgtToolUtilBinn
14:17:18 Processing: Connect
14:17:18 Processing: ConnectConnSys
14:17:18 Processing: Books
14:17:18 Processing: BooksBookso
14:17:18 Processing: DevTools
14:17:18 Processing: DevToolsHeaders and Libraries
14:17:18 Processing: DevToolsMDAC SDKs
14:17:18 Processing: DevToolsVDI
14:17:18 Processing: DevToolsDbg Int
14:17:18 Processing: Samples
14:17:18 Processing: SamplesADO
14:17:18 Processing: SamplesDBLIB
14:17:18 Processing: SamplesDesktop
14:17:18 Processing: SamplesDTS
14:17:18 Processing: SamplesESQLC
14:17:18 Processing: SamplesMisc
14:17:18 Processing: SamplesMSDTC
14:17:18 Processing: SamplesODBC
14:17:18 Processing: SamplesODS
14:17:18 Processing: SamplesOLEAut
14:17:18 Processing: SamplesRepl
14:17:18 Processing: SamplesSilverstoneDB
14:17:18 Processing: SamplesSQLDMO
14:17:18 Processing: SamplesSQLNS
14:17:18 Processing: SamplesUtils
14:17:18 Processing: SamplesXML
14:17:18 Processing: CoreRepl
14:17:18 Processing: CoreReplRes1033
14:17:18 Processing: CoreReplResIntl
14:17:18 Processing: Core
14:17:18 Processing: CoreRes1033
14:17:18 Processing: CoreResOther
14:17:18 Processing: Repostry
14:17:18 Processing: RepostryRepstSys
14:17:18 Processing: RepostryRes1033
14:17:18 Processing: RepostryResIntl
14:17:18 Processing: CoreMisc
14:17:18 Processing: CoreMiscActiveX
14:17:18 Processing: CoreMiscRes1033
14:17:18 Processing: Monarch
14:17:18 Processing: MonarchMonr1033
14:17:18 Processing: MonarchMonrIntl
14:17:18 Processing: Jet
14:17:18 Processing: CoreInst
14:17:18 Processing: CoreCOM
14:17:18 Processing: CoreCOMRes1033
14:17:18 Processing: CoreCOMResIntl
14:17:18 Processing: CoreTool
14:17:18 Processing: CoreToolRes1033
14:17:18 Processing: CoreToolResOther
14:17:18 Processing: DBLibCli
14:17:18 Processing: SFExt
14:17:18 Processing: SFExtActiveX
14:17:18 Processing: SFExtRes1033
14:17:18 Processing: SFExtResIntl
14:17:18 Processing: Trace
14:17:18 Processing: TraceRes1033
14:17:18 Processing: TraceResOther
14:17:18 Processing: CnctBinn
14:17:18 Processing: MiscCore
14:17:18 Processing: MC
14:17:18 Processing: MCMC1033
14:17:18 Processing: MCMCIntl
14:17:18 Processing: MCHelp
14:17:18 Processing: UI
14:17:18 Processing: UIUIHlp
14:17:18 Processing: UIUI1033
14:17:18 Processing: UIUIIntl
14:17:18 Processing: ClstSys
14:17:18 Processing: SQLMgr
14:17:18 Processing: SQLMgrRes1033
14:17:18 Processing: SQLMgrResIntl
14:17:18 Processing: SvrTool
14:17:18 Processing: SvrToolRes1033
14:17:18 Processing: SvrToolResIntl
14:17:18 Processing: DTSUI
14:17:18 Processing: DTSUIRes1033
14:17:18 Processing: DTSUIResIntl
14:17:18 Processing: ClFTSys
14:17:18 Processing: ClFtdata
14:17:18 Processing: MSOlap
14:17:18 Processing: MSOlapRes1033
14:17:18 Processing: MSOlapResIntl
14:17:18 Processing: ATL
14:17:18 Processing: ATLwinnt
14:17:18 Processing: ATLwin9x
14:17:18 Processing: MFC42U
14:17:18 Processing: VC
14:17:18 Processing: VB
14:17:18 Processing: OCX1
14:17:18 Processing: SQLAdHlp
14:17:18 Processing: SQLAdHlpRes1033
14:17:18 Processing: SQLAdHlpResOther
14:17:18 Setup type: Custom
14:17:18 End Action DialogShowSdUpgrade
14:17:18 begin ShowDialogsUpdateMask
14:17:18 nFullMask = 0xb002627, nCurrent = 0x2000, nDirection = 1
14:17:18 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
14:17:18 Dialog 0x2000 returned: 1
14:17:18 End Action ShowDialogsHlpr
14:17:18 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
14:17:18 Begin Action ShowDialogsHlpr: 0x1000000
14:17:18 Begin Action: DlgCollation
14:17:18 ShowDlgCollation returned: 1
14:17:18 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name = Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
14:17:18 End Action DlgCollation
14:17:18 begin ShowDialogsUpdateMask
14:17:18 nFullMask = 0xb002627, nCurrent = 0x1000000, nDirection = 1
14:17:18 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
14:17:18 Dialog 0x1000000 returned: 1
14:17:18 End Action ShowDialogsHlpr
14:17:18 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
14:17:18 Begin Action ShowDialogsHlpr: 0x2000000
14:17:18 Begin Action: DlgNetwork
14:17:18 ShowDlgNetwork returned: 1
14:17:18 [DlgServerNetwork]
14:17:18 NetworkLibs = 255
14:17:18 TCPPort = 0
14:17:18 TCPPrxy = Default
14:17:18 NMPPipeName = \.pipeMSSQL$INSTNAMEsqlquery
14:17:18 Result = 1
14:17:18 End Action DlgNetwork
14:17:18 begin ShowDialogsUpdateMask
14:17:18 nFullMask = 0xb002627, nCurrent = 0x2000000, nDirection = 1
14:17:18 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
14:17:18 Dialog 0x2000000 returned: 1
14:17:18 End Action ShowDialogsHlpr
14:17:18 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
14:17:18 Begin Action ShowDialogsHlpr: 0x8000000
14:17:18 Begin Action: DialogShowSdStartCopy
14:17:34 End Action DialogShowSdStartCopy
14:17:34 begin ShowDialogsUpdateMask
14:17:34 nFullMask = 0xb002627, nCurrent = 0x8000000, nDirection = 1
14:17:34 Updated Dialog Mask: 0xb002627, Disable Back = 0x1
14:17:34 Dialog 0x8000000 returned: 1
14:17:34 End Action ShowDialogsHlpr
14:17:34 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
14:17:34 End: ShowDialogs()
14:17:34 Initializing Event Log
14:17:34 Begin Action : LogEvent
14:17:34 End Action : LogEvent
14:17:34 Begin: ProcessBeforeDataMove()
14:17:35 DeinstallStart returned (C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME): 0
14:17:35 End: ProcessBeforeDataMove()
14:17:35 Begin: SetToolsComponentSelection()
14:17:35 CreateSetupTopology(SERVER01), Handle : 0x14d5ee8, returned : 0
14:17:35 CreateSetupTopology returned : 0, Handle : 0x14d5ee8
14:17:35 Topology Type : 1, Return Value : 0
14:17:35 ST_GetPhysicalNode returned : 0, PNHandle : 0x14d46c8
14:17:35 PN_EnumerateEx returned : 0
14:17:35 PN_GetSQLStates returned : 0, SqlStates : 0x88020024
14:17:35 PN_StartScan [0x14d46c8] returned : 0
14:17:35 PN_GetNext [0x14d46c8] returned : 18, Handle: [0x0]
14:17:35 No more items in enumeration.
14:17:35 ReleaseSetupTopology
14:17:35 End: SetToolsComponentSelection()
14:17:35 Begin: ProcessComponentSelection()
14:17:35 End: ProcessComponentSelection()
14:17:35 Begin: LogSelectedComponents()
14:17:35 Processing: SQLProg
14:17:35 Selected: SQLProg
14:17:35 Processing: SQLProgSQLServr
14:17:35 Selected: SQLProgSQLServr
14:17:35 Processing: SQLProgSQLServrHelp
14:17:35 Selected: SQLProgSQLServrHelp
14:17:35 Processing: SQLProgSQLServrSCMDev
14:17:35 Selected: SQLProgSQLServrSCMDev
14:17:35 Processing: SQLProgSQLServrSCMDevSCMh
14:17:35 Selected: SQLProgSQLServrSCMDevSCMh
14:17:35 Processing: SQLProgSQLServrSCMDevSCMX86Lb
14:17:35 Selected: SQLProgSQLServrSCMDevSCMX86Lb
14:17:35 Processing: SQLProgSQLServrSCMDevSCMALb
14:17:35 Selected: SQLProgSQLServrSCMDevSCMALb
14:17:35 Processing: SQLProgSQLServrRs1033
14:17:35 Selected: SQLProgSQLServrRs1033
14:17:35 Processing: SQLProgSQLServrRsIntl
14:17:35 Selected: SQLProgSQLServrRsIntl
14:17:35 Processing: SQLProgSQLServrActiveX
14:17:35 Selected: SQLProgSQLServrActiveX
14:17:35 Processing: SQLProgSQLServrSystem
14:17:35 Selected: SQLProgSQLServrSystem
14:17:35 Processing: SQLProgSQLServrWatson
14:17:35 Selected: SQLProgSQLServrWatson
14:17:35 Processing: SQLProgSQLServrWatsonWatson1033
14:17:35 Selected: SQLProgSQLServrWatsonWatson1033
14:17:35 Processing: SQLProgSQLServrWatsonWatsonOther
14:17:35 Selected: SQLProgSQLServrWatsonWatsonOther
14:17:35 Processing: SQLProgSQLServrMSXMLSQL
14:17:35 Selected: SQLProgSQLServrMSXMLSQL
14:17:35 Processing: SQLProgSQLServrMSXMLSQLRes1033
14:17:35 Selected: SQLProgSQLServrMSXMLSQLRes1033
14:17:35 Processing: SQLProgSQLServrMSXMLSQLResIntl
14:17:35 Selected: SQLProgSQLServrMSXMLSQLResIntl
14:17:35 Processing: SQLProgUpgTools
14:17:35 Processing: SQLProgUpgToolsUpgSys
14:17:35 Processing: SQLProgUpgToolsActiveX
14:17:35 Processing: SQLProgUpgToolsRes1033
14:17:35 Processing: SQLProgUpgToolsResOther
14:17:35 Processing: SQLProgUpgToolsResld
14:17:35 Processing: SQLProgReplSupp
14:17:35 Selected: SQLProgReplSupp
14:17:35 Processing: SQLProgReplSuppReplDat
14:17:35 Selected: SQLProgReplSuppReplDat
14:17:35 Processing: SQLProgReplSuppRepComm
14:17:35 Selected: SQLProgReplSuppRepComm
14:17:35 Processing: SQLProgReplSuppRepNoDk
14:17:35 Selected: SQLProgReplSuppRepNoDk
14:17:35 Processing: SQLProgReplSuppActiveX
14:17:35 Selected: SQLProgReplSuppActiveX
14:17:35 Processing: SQLProgInstall
14:17:35 Selected: SQLProgInstall
14:17:35 Processing: SQLProgSystem
14:17:35 Selected: SQLProgSystem
14:17:35 Processing: SQLProgSvrExt
14:17:35 Selected: SQLProgSvrExt
14:17:35 Processing: SQLProgSvrExtHelp
14:17:35 Selected: SQLProgSvrExtHelp
14:17:35 Processing: SQLProgSvrExtSvrExtRs
14:17:35 Selected: SQLProgSvrExtSvrExtRs
14:17:35 Processing: SQLProgSvrExtResIntl
14:17:35 Selected: SQLProgSvrExtResIntl
14:17:35 Processing: SQLProgDat
14:17:35 Processing: SQLProgDatSmpl
14:17:35 Processing: SQLProgBaseSys
14:17:35 Selected: SQLProgBaseSys
14:17:35 Processing: SQLProgBaseBinn
14:17:35 Selected: SQLProgBaseBinn
14:17:35 Processing: SQLProgMSSearch
14:17:35 Selected: SQLProgMSSearch
14:17:35 Processing: SQLProgMSSearchHelp
14:17:35 Selected: SQLProgMSSearchHelp
14:17:35 Processing: SQLProgMSSearchActiveX
14:17:35 Selected: SQLProgMSSearchActiveX
14:17:35 Processing: SQLProgBaseInst
14:17:35 Selected: SQLProgBaseInst
14:17:35 Processing: SQLProgUI
14:17:35 Processing: SQLProgSymbols
14:17:35 Selected: SQLProgSymbols
14:17:35 Processing: SQLProgSymbolsEXE
14:17:35 Selected: SQLProgSymbolsEXE
14:17:35 Processing: SQLProgSymbolsDLL
14:17:35 Selected: SQLProgSymbolsDLL
14:17:35 Processing: SQLProgPerfmon
14:17:35 Selected: SQLProgPerfmon
14:17:35 Processing: SQLProgPerfmonSystem
14:17:35 Selected: SQLProgPerfmonSystem
14:17:35 Processing: SQLProgRoot
14:17:35 Processing: SQLProgEXE
14:17:35 Processing: SQLProgDLL
14:17:35 Processing: MgtTool
14:17:35 Selected: MgtTool
14:17:35 Processing: MgtToolSEM
14:17:35 Selected: MgtToolSEM
14:17:35 Processing: MgtToolSEMHTML
14:17:35 Selected: MgtToolSEMHTML
14:17:35 Processing: MgtToolSEMMSD98
14:17:35 Selected: MgtToolSEMMSD98
14:17:35 Processing: MgtToolSEMMSD98SYS
14:17:35 Selected: MgtToolSEMMSD98SYS
14:17:35 Processing: MgtToolSEMMSD98Res
14:17:35 Selected: MgtToolSEMMSD98Res
14:17:35 Processing: MgtToolSEMMSD98Hlp
14:17:35 Selected: MgtToolSEMMSD98Hlp
14:17:35 Processing: MgtToolSEMHelp
14:17:35 Selected: MgtToolSEMHelp
14:17:35 Processing: MgtToolSEMRes1033
14:17:35 Selected: MgtToolSEMRes1033
14:17:35 Processing: MgtToolSEMResIntl
14:17:35 Selected: MgtToolSEMResIntl
14:17:35 Processing: MgtToolSEMMSD98RsI
14:17:35 Selected: MgtToolSEMMSD98RsI
14:17:35 Processing: MgtToolSEMActiveX
14:17:35 Selected: MgtToolSEMActiveX
14:17:35 Processing: MgtToolSEMActiveXRes1033
14:17:35 Selected: MgtToolSEMActiveXRes1033
14:17:35 Processing: MgtToolSEMActiveXResIntl
14:17:35 Selected: MgtToolSEMActiveXResIntl
14:17:35 Processing: MgtToolSEMScripts
14:17:35 Selected: MgtToolSEMScripts
14:17:35 Processing: MgtToolSEMOLEDB
14:17:35 Selected: MgtToolSEMOLEDB
14:17:35 Processing: MgtToolSEMOLEDBRes1033
14:17:35 Selected: MgtToolSEMOLEDBRes1033
14:17:35 Processing: MgtToolSEMOLEDBResIntl
14:17:35 Selected: MgtToolSEMOLEDBResIntl
14:17:35 Processing: MgtToolSEMMSD7
14:17:35 Selected: MgtToolSEMMSD7
14:17:35 Processing: MgtToolSEMMSD7Res
14:17:35 Selected: MgtToolSEMMSD7Res
14:17:35 Processing: MgtToolSEMMSD7RsI
14:17:35 Selected: MgtToolSEMMSD7RsI
14:17:35 Processing: MgtToolProfiler
14:17:35 Selected: MgtToolProfiler
14:17:35 Processing: MgtToolProfilerHelp
14:17:35 Selected: MgtToolProfilerHelp
14:17:35 Processing: MgtToolProfilerRes1033
14:17:35 Selected: MgtToolProfilerRes1033
14:17:35 Processing: MgtToolProfilerResIntl
14:17:35 Selected: MgtToolProfilerResIntl
14:17:35 Processing: MgtToolQryanlz
14:17:35 Selected: MgtToolQryanlz
14:17:35 Processing: MgtToolQryanlzHelp
14:17:35 Selected: MgtToolQryanlzHelp
14:17:35 Processing: MgtToolQryanlzRes1033
14:17:35 Selected: MgtToolQryanlzRes1033
14:17:35 Processing: MgtToolQryanlzResIntl
14:17:35 Selected: MgtToolQryanlzResIntl
14:17:35 Processing: MgtToolDTCCLi
14:17:35 Selected: MgtToolDTCCLi
14:17:35 Processing: MgtToolWzcnflct
14:17:35 Selected: MgtToolWzcnflct
14:17:35 Processing: MgtToolWzcnflctWzcnHlp
14:17:35 Selected: MgtToolWzcnflctWzcnHlp
14:17:35 Processing: MgtToolWzcnflctWzcn1033
14:17:35 Selected: MgtToolWzcnflctWzcn1033
14:17:35 Processing: MgtToolWzcnflctWzcnOthr
14:17:35 Selected: MgtToolWzcnflctWzcnOthr
14:17:35 Processing: MgtToolWzcnflctWzcnCmn
14:17:35 Selected: MgtToolWzcnflctWzcnCmn
14:17:35 Processing: MgtToolUtilSys
14:17:35 Selected: MgtToolUtilSys
14:17:35 Processing: MgtToolUtilBinn
14:17:35 Selected: MgtToolUtilBinn
14:17:35 Processing: Connect
14:17:35 Selected: Connect
14:17:35 Processing: ConnectConnSys
14:17:35 Selected: ConnectConnSys
14:17:35 Processing: Books
14:17:35 Selected: Books
14:17:35 Processing: BooksBookso
14:17:35 Selected: BooksBookso
14:17:35 Processing: BooksBooksoUtils
14:17:35 Selected: BooksBooksoUtils
14:17:35 Processing: DevTools
14:17:35 Selected: DevTools
14:17:35 Processing: DevToolsHeaders and Libraries
14:17:35 Processing: DevToolsHeaders and LibrariesInclude
14:17:35 Processing: DevToolsHeaders and LibrariesLibx86
14:17:35 Processing: DevToolsHeaders and LibrariesLibAlpha
14:17:35 Processing: DevToolsHeaders and LibrariesESQLC
14:17:35 Processing: DevToolsMDAC SDKs
14:17:35 Processing: DevToolsVDI
14:17:35 Processing: DevToolsVDIInc
14:17:35 Processing: DevToolsVDISamples
14:17:35 Processing: DevToolsDbg Int
14:17:35 Selected: DevToolsDbg Int
14:17:35 Processing: DevToolsDbg IntDbg Int Common
14:17:35 Selected: DevToolsDbg IntDbg Int Common
14:17:35 Processing: DevToolsDbg IntEXE
14:17:35 Selected: DevToolsDbg IntEXE
14:17:35 Processing: Samples
14:17:35 Processing: SamplesADO
14:17:35 Processing: SamplesDBLIB
14:17:35 Processing: SamplesDesktop
14:17:35 Processing: SamplesDTS
14:17:35 Processing: SamplesESQLC
14:17:35 Processing: SamplesMisc
14:17:35 Processing: SamplesMSDTC
14:17:35 Processing: SamplesODBC
14:17:35 Processing: SamplesODS
14:17:35 Processing: SamplesOLEAut
14:17:35 Processing: SamplesRepl
14:17:35 Processing: SamplesSilverstoneDB
14:17:35 Processing: SamplesSQLDMO
14:17:35 Processing: SamplesSQLNS
14:17:35 Processing: SamplesUtils
14:17:35 Processing: SamplesXML
14:17:35 Processing: CoreRepl
14:17:35 Selected: CoreRepl
14:17:35 Processing: CoreReplRes1033
14:17:35 Selected: CoreReplRes1033
14:17:35 Processing: CoreReplResIntl
14:17:35 Selected: CoreReplResIntl
14:17:35 Processing: Core
14:17:35 Selected: Core
14:17:35 Processing: CoreRes1033
14:17:35 Selected: CoreRes1033
14:17:35 Processing: CoreResOther
14:17:35 Selected: CoreResOther
14:17:35 Processing: Repostry
14:17:35 Selected: Repostry
14:17:35 Processing: RepostryRepstSys
14:17:35 Selected: RepostryRepstSys
14:17:35 Processing: RepostryRes1033
14:17:35 Selected: RepostryRes1033
14:17:35 Processing: RepostryResIntl
14:17:35 Selected: RepostryResIntl
14:17:35 Processing: CoreMisc
14:17:35 Selected: CoreMisc
14:17:35 Processing: CoreMiscActiveX
14:17:35 Selected: CoreMiscActiveX
14:17:35 Processing: CoreMiscActiveXRes1033
14:17:35 Selected: CoreMiscActiveXRes1033
14:17:35 Processing: CoreMiscActiveXResIntl
14:17:35 Selected: CoreMiscActiveXResIntl
14:17:35 Processing: CoreMiscRes1033
14:17:35 Selected: CoreMiscRes1033
14:17:35 Processing: Monarch
14:17:35 Selected: Monarch
14:17:35 Processing: MonarchMonr1033
14:17:35 Selected: MonarchMonr1033
14:17:35 Processing: MonarchMonrIntl
14:17:35 Selected: MonarchMonrIntl
14:17:35 Processing: Jet
14:17:35 Selected: Jet
14:17:35 Processing: CoreInst
14:17:35 Selected: CoreInst
14:17:35 Processing: CoreCOM
14:17:35 Selected: CoreCOM
14:17:35 Processing: CoreCOMRes1033
14:17:35 Selected: CoreCOMRes1033
14:17:35 Processing: CoreCOMResIntl
14:17:35 Selected: CoreCOMResIntl
14:17:35 Processing: CoreTool
14:17:35 Selected: CoreTool
14:17:35 Processing: CoreToolRes1033
14:17:35 Selected: CoreToolRes1033
14:17:35 Processing: CoreToolResOther
14:17:35 Selected: CoreToolResOther
14:17:35 Processing: DBLibCli
14:17:35 Selected: DBLibCli
14:17:35 Processing: SFExt
14:17:35 Selected: SFExt
14:17:35 Processing: SFExtActiveX
14:17:35 Selected: SFExtActiveX
14:17:35 Processing: SFExtActiveXRes1033
14:17:35 Selected: SFExtActiveXRes1033
14:17:35 Processing: SFExtActiveXResIntl
14:17:35 Selected: SFExtActiveXResIntl
14:17:35 Processing: SFExtRes1033
14:17:35 Selected: SFExtRes1033
14:17:35 Processing: SFExtResIntl
14:17:35 Selected: SFExtResIntl
14:17:35 Processing: Trace
14:17:35 Selected: Trace
14:17:35 Processing: TraceRes1033
14:17:35 Selected: TraceRes1033
14:17:35 Processing: TraceResOther
14:17:35 Selected: TraceResOther
14:17:35 Processing: CnctBinn
14:17:35 Processing: MiscCore
14:17:35 Selected: MiscCore
14:17:35 Processing: MC
14:17:35 Selected: MC
14:17:35 Processing: MCMC1033
14:17:35 Selected: MCMC1033
14:17:35 Processing: MCMCIntl
14:17:35 Selected: MCMCIntl
14:17:35 Processing: MCHelp
14:17:35 Selected: MCHelp
14:17:35 Processing: UI
14:17:35 Processing: UIUIHlp
14:17:35 Processing: UIUI1033
14:17:35 Processing: UIUIIntl
14:17:35 Processing: ClstSys
14:17:35 Processing: SQLMgr
14:17:35 Selected: SQLMgr
14:17:35 Processing: SQLMgrRes1033
14:17:35 Selected: SQLMgrRes1033
14:17:35 Processing: SQLMgrResIntl
14:17:35 Selected: SQLMgrResIntl
14:17:35 Processing: SvrTool
14:17:35 Selected: SvrTool
14:17:35 Processing: SvrToolRes1033
14:17:35 Selected: SvrToolRes1033
14:17:35 Processing: SvrToolResIntl
14:17:35 Selected: SvrToolResIntl
14:17:35 Processing: DTSUI
14:17:35 Selected: DTSUI
14:17:35 Processing: DTSUIRes1033
14:17:35 Selected: DTSUIRes1033
14:17:35 Processing: DTSUIResIntl
14:17:35 Selected: DTSUIResIntl
14:17:35 Processing: ClFTSys
14:17:35 Processing: ClFtdata
14:17:35 Processing: MSOlap
14:17:35 Selected: MSOlap
14:17:35 Processing: MSOlapRes1033
14:17:35 Selected: MSOlapRes1033
14:17:35 Processing: MSOlapResIntl
14:17:35 Selected: MSOlapResIntl
14:17:35 Processing: ATL
14:17:35 Selected: ATL
14:17:35 Processing: ATLwinnt
14:17:35 Selected: ATLwinnt
14:17:35 Processing: ATLwin9x
14:17:35 Selected: ATLwin9x
14:17:35 Processing: MFC42U
14:17:35 Selected: MFC42U
14:17:35 Processing: VC
14:17:35 Selected: VC
14:17:35 Processing: VB
14:17:35 Selected: VB
14:17:35 Processing: OCX1
14:17:35 Processing: SQLAdHlp
14:17:35 Selected: SQLAdHlp
14:17:35 Processing: SQLAdHlpRes1033
14:17:35 Selected: SQLAdHlpRes1033
14:17:35 Processing: SQLAdHlpResOther
14:17:35 Selected: SQLAdHlpResOther
14:17:35 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
14:17:35 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
14:17:35 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
14:17:35 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
14:17:35 End: LogSelectedComponents()
14:17:35 Processing: SQLProg
14:17:35 Processing: SQLProgSQLServr
14:17:35 Processing: SQLProgSQLServrHelp
14:17:35 Processing: SQLProgSQLServrSCMDev
14:17:35 Processing: SQLProgSQLServrSCMDevSCMh
14:17:35 Processing: SQLProgSQLServrSCMDevSCMX86Lb
14:17:35 Processing: SQLProgSQLServrSCMDevSCMALb
14:17:35 Processing: SQLProgSQLServrRs1033
14:17:35 Processing: SQLProgSQLServrRsIntl
14:17:35 Processing: SQLProgSQLServrActiveX
14:17:35 Processing: SQLProgSQLServrSystem
14:17:35 Processing: SQLProgSQLServrWatson
14:17:35 Processing: SQLProgSQLServrWatsonWatson1033
14:17:35 Processing: SQLProgSQLServrWatsonWatsonOther
14:17:35 Processing: SQLProgSQLServrMSXMLSQL
14:17:35 Processing: SQLProgSQLServrMSXMLSQLRes1033
14:17:35 Processing: SQLProgSQLServrMSXMLSQLResIntl
14:17:35 Processing: SQLProgUpgTools
14:17:35 Processing: SQLProgUpgToolsUpgSys
14:17:35 Processing: SQLProgUpgToolsActiveX
14:17:35 Processing: SQLProgUpgToolsRes1033
14:17:35 Processing: SQLProgUpgToolsResOther
14:17:35 Processing: SQLProgUpgToolsResld
14:17:35 Processing: SQLProgReplSupp
14:17:35 Processing: SQLProgReplSuppReplDat
14:17:35 Processing: SQLProgReplSuppRepComm
14:17:35 Processing: SQLProgReplSuppRepNoDk
14:17:35 Processing: SQLProgReplSuppActiveX
14:17:35 Processing: SQLProgInstall
14:17:35 Processing: SQLProgSystem
14:17:35 Processing: SQLProgSvrExt
14:17:35 Processing: SQLProgSvrExtHelp
14:17:35 Processing: SQLProgSvrExtSvrExtRs
14:17:35 Processing: SQLProgSvrExtResIntl
14:17:35 Processing: SQLProgDat
14:17:35 Processing: SQLProgDatSmpl
14:17:35 Processing: SQLProgBaseSys
14:17:35 Processing: SQLProgBaseBinn
14:17:35 Processing: SQLProgMSSearch
14:17:35 Processing: SQLProgMSSearchHelp
14:17:35 Processing: SQLProgMSSearchActiveX
14:17:35 Processing: SQLProgBaseInst
14:17:35 Processing: SQLProgUI
14:17:35 Processing: SQLProgSymbols
14:17:35 Processing: SQLProgSymbolsEXE
14:17:35 Processing: SQLProgSymbolsDLL
14:17:35 Processing: SQLProgPerfmon
14:17:35 Processing: SQLProgPerfmonSystem
14:17:35 Processing: SQLProgRoot
14:17:35 Processing: SQLProgEXE
14:17:35 Processing: SQLProgDLL
14:17:35 Processing: MgtTool
14:17:35 Processing: MgtToolSEM
14:17:35 Processing: MgtToolSEMHTML
14:17:35 Processing: MgtToolSEMMSD98
14:17:35 Processing: MgtToolSEMMSD98SYS
14:17:35 Processing: MgtToolSEMMSD98Res
14:17:35 Processing: MgtToolSEMMSD98Hlp
14:17:35 Processing: MgtToolSEMHelp
14:17:35 Processing: MgtToolSEMRes1033
14:17:35 Processing: MgtToolSEMResIntl
14:17:35 Processing: MgtToolSEMMSD98RsI
14:17:35 Processing: MgtToolSEMActiveX
14:17:35 Processing: MgtToolSEMActiveXRes1033
14:17:35 Processing: MgtToolSEMActiveXResIntl
14:17:35 Processing: MgtToolSEMScripts
14:17:35 Processing: MgtToolSEMOLEDB
14:17:35 Processing: MgtToolSEMOLEDBRes1033
14:17:35 Processing: MgtToolSEMOLEDBResIntl
14:17:35 Processing: MgtToolSEMMSD7
14:17:35 Processing: MgtToolSEMMSD7Res
14:17:35 Processing: MgtToolSEMMSD7RsI
14:17:35 Processing: MgtToolProfiler
14:17:35 Processing: MgtToolProfilerHelp
14:17:35 Processing: MgtToolProfilerRes1033
14:17:35 Processing: MgtToolProfilerResIntl
14:17:35 Processing: MgtToolQryanlz
14:17:35 Processing: MgtToolQryanlzHelp
14:17:35 Processing: MgtToolQryanlzRes1033
14:17:35 Processing: MgtToolQryanlzResIntl
14:17:35 Processing: MgtToolDTCCLi
14:17:35 Processing: MgtToolWzcnflct
14:17:35 Processing: MgtToolWzcnflctWzcnHlp
14:17:35 Processing: MgtToolWzcnflctWzcn1033
14:17:35 Processing: MgtToolWzcnflctWzcnOthr
14:17:35 Processing: MgtToolWzcnflctWzcnCmn
14:17:35 Processing: MgtToolUtilSys
14:17:35 Processing: MgtToolUtilBinn
14:17:35 Processing: Connect
14:17:35 Processing: ConnectConnSys
14:17:35 Processing: Books
14:17:35 Processing: BooksBookso
14:17:35 Processing: BooksBooksoUtils
14:17:35 Processing: DevTools
14:17:35 Processing: DevToolsHeaders and Libraries
14:17:35 Processing: DevToolsHeaders and LibrariesInclude
14:17:35 Processing: DevToolsHeaders and LibrariesLibx86
14:17:35 Processing: DevToolsHeaders and LibrariesLibAlpha
14:17:35 Processing: DevToolsHeaders and LibrariesESQLC
14:17:35 Processing: DevToolsMDAC SDKs
14:17:35 Processing: DevToolsVDI
14:17:35 Processing: DevToolsVDIInc
14:17:35 Processing: DevToolsVDISamples
14:17:35 Processing: DevToolsDbg Int
14:17:35 Processing: DevToolsDbg IntDbg Int Common
14:17:35 Processing: DevToolsDbg IntEXE
14:17:35 Processing: Samples
14:17:35 Processing: SamplesADO
14:17:35 Processing: SamplesDBLIB
14:17:35 Processing: SamplesDesktop
14:17:35 Processing: SamplesDTS
14:17:35 Processing: SamplesESQLC
14:17:35 Processing: SamplesMisc
14:17:35 Processing: SamplesMSDTC
14:17:35 Processing: SamplesODBC
14:17:35 Processing: SamplesODS
14:17:35 Processing: SamplesOLEAut
14:17:35 Processing: SamplesRepl
14:17:35 Processing: SamplesSilverstoneDB
14:17:35 Processing: SamplesSQLDMO
14:17:35 Processing: SamplesSQLNS
14:17:35 Processing: SamplesUtils
14:17:35 Processing: SamplesXML
14:17:35 Processing: CoreRepl
14:17:35 Processing: CoreReplRes1033
14:17:35 Processing: CoreReplResIntl
14:17:35 Processing: Core
14:17:35 Processing: CoreRes1033
14:17:35 Processing: CoreResOther
14:17:35 Processing: Repostry
14:17:35 Processing: RepostryRepstSys
14:17:35 Processing: RepostryRes1033
14:17:35 Processing: RepostryResIntl
14:17:35 Processing: CoreMisc
14:17:35 Processing: CoreMiscActiveX
14:17:35 Processing: CoreMiscActiveXRes1033
14:17:35 Processing: CoreMiscActiveXResIntl
14:17:35 Processing: CoreMiscRes1033
14:17:35 Processing: Monarch
14:17:35 Processing: MonarchMonr1033
14:17:35 Processing: MonarchMonrIntl
14:17:35 Processing: Jet
14:17:35 Processing: CoreInst
14:17:35 Processing: CoreCOM
14:17:35 Processing: CoreCOMRes1033
14:17:35 Processing: CoreCOMResIntl
14:17:35 Processing: CoreTool
14:17:35 Processing: CoreToolRes1033
14:17:35 Processing: CoreToolResOther
14:17:35 Processing: DBLibCli
14:17:35 Processing: SFExt
14:17:35 Processing: SFExtActiveX
14:17:35 Processing: SFExtActiveXRes1033
14:17:35 Processing: SFExtActiveXResIntl
14:17:35 Processing: SFExtRes1033
14:17:35 Processing: SFExtResIntl
14:17:35 Processing: Trace
14:17:35 Processing: TraceRes1033
14:17:35 Processing: TraceResOther
14:17:35 Processing: CnctBinn
14:17:35 Processing: MiscCore
14:17:35 Processing: MC
14:17:35 Processing: MCMC1033
14:17:35 Processing: MCMCIntl
14:17:35 Processing: MCHelp
14:17:35 Processing: UI
14:17:35 Processing: UIUIHlp
14:17:35 Processing: UIUI1033
14:17:35 Processing: UIUIIntl
14:17:35 Processing: ClstSys
14:17:35 Processing: SQLMgr
14:17:35 Processing: SQLMgrRes1033
14:17:35 Processing: SQLMgrResIntl
14:17:35 Processing: SvrTool
14:17:35 Processing: SvrToolRes1033
14:17:35 Processing: SvrToolResIntl
14:17:35 Processing: DTSUI
14:17:35 Processing: DTSUIRes1033
14:17:35 Processing: DTSUIResIntl
14:17:35 Processing: ClFTSys
14:17:35 Processing: ClFtdata
14:17:35 Processing: MSOlap
14:17:35 Processing: MSOlapRes1033
14:17:35 Processing: MSOlapResIntl
14:17:35 Processing: ATL
14:17:35 Processing: ATLwinnt
14:17:35 Processing: ATLwin9x
14:17:35 Processing: MFC42U
14:17:35 Processing: VC
14:17:35 Processing: VB
14:17:35 Processing: OCX1
14:17:35 Processing: SQLAdHlp
14:17:35 Processing: SQLAdHlpRes1033
14:17:35 Processing: SQLAdHlpResOther
14:17:35 SQL program folder: C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME
14:17:35 SQL data folder: C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAME
14:17:35 Windows system folder: C:WINDOWSsystem32
14:17:35 Prog req: 61137, Data req: 3072, Sys req: 50573
14:17:35 Prog avail: 1573556, Data avail: 1573556, Sys avail: 1573556
14:17:35 Prog req vs. avail, 114782, 1573556
14:17:35 Data req vs. avail, 3072, 1573556
14:17:35 Sys req vs. avail, 53645, 1573556
14:17:35 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe -Silent 1 -Action 6 -Timeout 5000 -Service SQLAgent$INSTNAME
14:17:35 Process Exit Code: (0)
14:17:35 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe -Silent 1 -Action 6 -Timeout 5000 -Service MSSQL$INSTNAME
14:17:35 Process Exit Code: (0)
14:17:35 Begin: InstallPkgs(ID_INSTALLMDAC)
14:17:35 Begin Action: Locked Connectivity Files Check
14:17:35 ConnectivityLocked returned: 0
14:17:35 The operation completed successfully.

14:17:35 End Action: Locked Connectivity Files Check
14:17:35 Setup is installing Microsoft Data Access Components (MDAC) ...
14:17:35 D:SQL2KSP42x86Othersqlredis.exe /q:a /C:"setupre.exe MDACQFE=0 WARN=1 -s -SMS"
14:17:35 Unloading library - sqlsut.dll (#U2)
14:17:43 Loading library - sqlsut.dll (#L2)
14:17:43 ExitCode: 0
14:17:43 End: InstallPkgs(ID_INSTALLMDAC)
14:17:43 **** STARTING OPEN OP IN WRITE MODE ****
14:17:43 **** CLOSED OPEN OP IN WRITE MODE ****
14:17:43 Begin: MoveFileData()
14:17:43 Enabled SELFREGISTERBATCH
14:17:43 Enabled CORECOMPONENTHANDLING
14:17:49 Begin Action: MoveFileDataSpecial
14:17:49 End Action: MoveFileDataSpecial
14:17:49 End: MoveFileData()
14:17:49 Begin: ProcessAfterDataMove()
14:17:49 Begin Action : Installing Server Net
14:17:49 Server Instance : INSTNAME
14:17:49 Server Net Will only be installed on server only in Enterprise Editions
14:17:49 End: ProcessAfterDataMove()
14:17:49 Begin: BuildServer()
14:17:49 Begin Action: CreateRegistrySetSQL
14:17:49 End Action: CreateRegistrySetSQL
14:17:49 Begin Action: RegWriteSetupEntry
14:17:49 End Action: RegWriteSetupEntry
14:17:49 *** Unable to get RegisteredOwner to apply to Serial number
14:17:49 Begin Action: CreateSer
14:17:49 End Action: CreateSer
14:17:49 SetFileSecuritySQLAndAdmin for C:WINDOWSsetup.iss returned: 0, 0
14:17:49 SetFileSecuritySQLAndAdmin for C:WINDOWSsqlsp.log returned: 0, 0
14:17:49 SetFileSecuritySQLAndAdmin for returned: 3, 3
14:17:49 SetFileSecuritySQLAndAdmin for C:WINDOWSsqlsp.log returned: 0, 0
14:17:49 SetFileSecuritySQLAndAdmin for C:WINDOWSsqlstp.log returned: 0, 0
14:17:49 SetFileSecPerfAndLogUsers for C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEBinnSQLCTR80.DLL returned: 0, 0
14:17:49 Begin ServPriv (INSTNAME)
14:17:49 End ServPriv()
14:17:50 Upgrading databases
14:17:50 Upgrading databases on instance 'INSTNAME'
14:17:50 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe -Silent 1 -Action 6 -Service MSSQL$INSTNAME
14:17:50 Process Exit Code: (0)
14:17:50 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe -Silent 1 -Action 6 -Service MSSQL$INSTNAME
14:17:50 Process Exit Code: (0)
14:17:50 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe -Silent 1 -Action 1 -Service MSSQL$INSTNAME -StartupOptions -T4022 -T4010 -m
14:18:41 Process Exit Code: (0)
14:18:41 D:SQL2KS~1x86BINNosql.exe -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
eplsys.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
eplsys.sql" -Usa -P"
14:19:18 Process Exit Code: (0)
14:19:18 D:SQL2KS~1x86BINNosql.exe -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
eplcom.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
eplcom.sql" -Usa -P"
14:19:35 Process Exit Code: (0)
14:19:35 D:SQL2KS~1x86BINNosql.exe -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
epltran.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
epltran.sql" -Usa -P"
14:19:57 Process Exit Code: (0)
14:19:57 D:SQL2KS~1x86BINNosql.exe -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
eplmerg.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
eplmerg.sql" -Usa -P"
14:20:25 Process Exit Code: (0)
14:20:25 D:SQL2KS~1x86BINNosql.exe -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
emove_old_msx_accounts.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall
emove_old_msx_accounts.sql" -Usa -P"
14:20:25 Process Exit Code: (0)
14:20:25 D:SQL2KS~1x86BINNosql.exe -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstallsp4_serv_uni.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstallsp4_serv_uni.sql" -Usa -P"
14:20:27 Process Exit Code: (0)
14:20:27 D:SQL2KS~1x86BINNosql.exe -SlpcERVER01INSTNAME -b -n -d master -o "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall80sp4-tools.out" -i "C:Program FilesMicrosoft SQL ServerMSSQL$INSTNAMEinstall80sp4-tools.sql" -Usa -P"
14:20:28 Process Exit Code: (1)
14:20:33 Error running script: 80sp4-tools.sql (1)
14:20:33 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe -Silent 1 -Action 6 -Service MSSQL$INSTNAME
14:21:08 Process Exit Code: (0)
14:21:08 Action CleanUpInstall:
14:21:08 Installation Failed.




I hope for any help, because re-installing is not an option.There are 250 db's on it.



thanks so far.



rb

View 6 Replies View Related

Running Query In SQL 2005 Stored Procedure Against Table On SQL 2000

Nov 18, 2005

I'm trying to set up Service Broker Services on SQL 2005 x86.  I've got two services set up, and a stored procedure associated with one of them.

View 5 Replies View Related

Long Running Query In SQL 2005 But Works Fine In SQL 2000

Mar 28, 2008

I have a simple update statement that is running forever in SQL 2005 but works fine in SQL 2000. We have a new server we put SQL 2005, restored db. The table in question WEEKLYSALESHISTORY I even re-indexed all the indexes and rebuilt the stats as well. But still no luck, still running extremely long. 1 hour 20 minutes.

I'll try to give you some background on these table. Weeklysalehistory has approx 30 fields. I have 11 indesxes set up weekending date being one of them. And replication control has index on lasttrandatetime as well. So I think my indexes are fine.

/* Update WeekEnding Date for current weeks WeeklySales Records */
Update WeeklySalesHistory set
weekendingdate =
(SELECT LastTransDateTime from ReplicationControl
where TableName = 'WEEKHST')
where weekendingdate is null

Weekly sales has approx 100,000,000 rows
Replication control has 631,000 (Ithink I can delete some from here to bring it down to 100 or 200 records) Although I don't think this is issue since on 2000 has same thing and works fine.


I was trying to do this within SSIS and thought that was issue. I am new so SSIS but it runs long even if I just run it as a job with this simple Update statement so I think its something with tables, etc that is wrong.

One thing on noticed if I look at the statistics in SQL Server Management studio there is a ton of stats. some being statistics on indexes which makes sense then I have a ton of hind_113_9_6 and simiiar one like this. I must have 90 or so named like this. Not sure how to check on SQL 2000 all the stats to see if they moved over from there or what. I checked a few other tables and don't have all these extra stats. Could this be causing the issue do I need to delete all these extras? Any help would be greatly appreciated.


Stacy

View 5 Replies View Related

Upgrading 32 Bit SQL 2000 SP4 Ent Running On 64 Bit Windows 2003 Enterprise To SQL2005 64 Bit In Place

Sep 14, 2005

Will it be possible to do an in-place upgrade from SQL 2000 Server Enterprise SP4 32 bit running on top of 64 bit Windows 2003 Enterprise , clustered, to SQL 2005 Enterprise 64 bit?
The 32 bit SQL 2000 to 64 bit SQL 2005 in place upgrade seems questionable to me...
Anybody tried anything like this?

View 1 Replies View Related

SQL Server 2005 Running In 2000 Compatibility Mode And Reporting Services

Sep 17, 2007

Can you run SQL Server 2005 in SQL Server 2000 compatibility mode and still use it with Reporting Services 2005?

View 4 Replies View Related

Visual Basic Slow Down Sql Server 2000 Running A Stored Procedure

Nov 30, 2007

I hav the following problem. I have written an stored procedure in sql server 2000 as the following
CREATE PROCEDURE dbo.pa_rellena
@pFechaInicio datetime

AS
declare @pFechaFin datetime
declare @auxcod_cen char(10)

declare @importeEfectivo decimal(17,2)
declare @importeTarjetas1 decimal(17,2)
declare @importeTarjetas2 decimal(17,2)
declare @importeVales decimal(17,2)
declare @importeTalones decimal(17,2)
declare @importeGastos decimal(17,2)


select @pFechaFin=@pFechaInicio+1


--Borramos las tablas temporales si las hemos creado con anterioridad y no se han borrado
if object_id('tmpCentros') is not null
drop table tmpCentros

if object_id('tmpCentros2') is not null
drop table tmpCentros2

if object_id('tmpMaxCajas') is not null
drop table tmpMaxCajas

if object_id('tmpCajasCentro') is not null
drop table tmpCajasCentro

if object_id('tmpVales') is not null
drop table tmpVales

if object_id('tmpDiarioEfectivo') is not null
drop table tmpDiarioEfectivo

if object_id('tmpDiarioTalones') is not null
drop table tmpDiarioTalones

if object_id('tmpDiarioTarjetas') is not null
drop table tmpDiarioTarjetas

if object_id('tmpDiarioSegundaForma') is not null
drop table tmpDiarioSegundaForma

if object_id('tmpDiarioGastosTarjetas') is not null
drop table tmpDiarioGastosTarjetas

if object_id('temp1') is not null
drop table temp1

--Seleccionamos todos los centros de Salvador Bachiller
select * into tmpCentros2
from centros
where centros.tienda=1
order by cod_cen

--Seleccionamos el maximo de cajas por cada centro

select cod_cen, max(cod_caja) as cajas into tmpMaxCajas
from cierrecaja
where fecha>=@pFechaInicio and fecha<@pFechaFin
group by cod_cen
order by cod_cen

--Mezclamos los centros con el maximo de cajas
select c.cod_cen, c.Centro, c.Direccion, c.localidad, c.provincia, c.cpostal, c.telefono, m.cajas, operaciones, cajas_tot, tienda, franquicia into tmpCentros
from tmpCentros2 as c left outer join tmpMaxCajas as m on c.cod_cen=m.cod_cen

--Cajas por centro
select distinct cod_cen as cod_cen, cod_caja as cod_caja into tmpCajasCentro
from cierrecaja
where fecha>=@pFechaInicio and fecha<@pFechaFin

--Los vales de cada centro
select cod_cen,sum(importe) as imp1 into tmpVales
from vales where
fecha>=@pFechaInicio and fecha<@pFechaFin
group by cod_cen

--Efectivo de cada centro
select cod_cen,'01' as vendedor,'EFECTIVO' as descripcion, (sum(diario.TotEuro)-Sum(Diario.Imppa2)) as importe1,0 as exp1, (sum(Diario.TotEuro)-sum(Diario.imppa2)) as importe2 into tmpDiarioEfectivo
from diario
where fecha>=@pFechaInicio and fecha<@pFechaFin and cod_cen in (select cod_cen from tmpCentros) and cod_caja in (select cod_caja from tmpCajasCentro) and diario.cod_pago='01'
group by cod_cen

--Talones por centro
select centros.cod_cen,'02' as vendedor,'TALONES' as descripcion, sum(diario.TotEuro) as importe1,0 as exp1, sum(Diario.TotEuro) as importe2 into tmpDiarioTalones
from centros inner join diario on centros.cod_cen=diario.cod_cen
where fecha>=@pFechaInicio and fecha<@pFechaFin and diario.cod_cen in (select cod_cen from tmpCentros) and cod_caja in (select cod_caja from tmpCajasCentro) and diario.cod_pago='02'
group by centros.cod_cen

--Tarjetas por centro
select cod_cen,'03' as vendedor,'TARJETAS' as descripcion, sum(diario.TotEuro) as importe1,0 as exp1, sum(Diario.TotEuro*(FPago.Descuento/100)) as importe2, sum(Diario.TotEuro) - sum(Diario.TotEuro*(FPago.Descuento/100)) as importe3 into tmpDiarioTarjetas
from FPago left join Diario on fpago.Cod_pago=Diario.cod_pago
where fecha>=@pFechaInicio and fecha<@pFechaFin and cod_cen in (select cod_cen from tmpCentros) and cod_caja in (select cod_caja from tmpCajasCentro) and Fpago.Descuento<>0
group by cod_cen

--Segunda Froma de Pago
select cod_cen,'03' as vendedor,'TARJETAS' as descripcion,sum(diario.imppa2) as importe1 into tmpDiarioSegundaForma
from fpago left join Diario on Fpago.cod_pago=diario.cod_pa1
where fPago.cod_pago<>'99' and fecha>=@pfechaInicio and fecha<@pFechaFin and cod_cen in (select cod_cen from tmpCentros) and cod_caja in (select cod_caja from tmpCajasCentro) and Fpago.Descuento<>0
group by cod_cen

--Comisiones tarjetas de pago
select cod_cen,'10' as vendedor, 'GASTOS (-)' as descripcion, sum(Diario.imppa2*(fPago.Descuento/100)) as importe2 into tmpDiarioGastosTarjetas
from Fpago left join Diario on FPago.cod_pago= Diario.cod_pa1
where fPago.cod_pago<>'99' and fecha>=@pFechaInicio and fecha<@pFechaFin and cod_cen in (select cod_cen from tmpCentros) and cod_caja in (select cod_caja from tmpCajasCentro) and Fpago.Descuento<>0
group by cod_cen
/*
--Venta neta por centro
declare cursortemporal cursor for select cod_cen from TmpCentros2

open cursortemporal
delete detallecaja_aux
fetch next from cursortemporal into @auxcod_cen
while @@fetch_status=0
Begin
select @importeVales=imp1 from tmpVales where cod_cen=@auxcod_Cen
select @importeEfectivo=importe2 from tmpDiarioEfectivo where cod_cen=@auxcod_Cen
select @importeTalones=importe2 from tmpDiarioTalones where cod_cen=@auxcod_cen
select @importeTarjetas1=importe3 from tmpDiarioTarjetas where cod_cen=@auxcod_cen
select @importeTarjetas2=importe1 from tmpDiarioSegundaForma where cod_cen=@auxcod_cen
select @importeGastos=importe2 from tmpDiarioGastosTarjetas where cod_cen=@auxcod_cen

select @importeVales=isnull(@importeVales,0)
select @importeEfectivo=isnull(@importeEfectivo,0)
select @importeTalones=isnull(@importeTalones,0)
select @importeTarjetas1=isnull(@importeTarjetas1,0)
select @importeTarjetas2=isnull(@importeTarjetas2,0)
select @importeGastos=isnull(@importeGastos,0)

print @auxcod_cen
print @importeVales
print @importeEfectivo
print @importeTalones
print @importeTarjetas1
print @importeTarjetas2
print @importeGastos

insert into detallecaja_aux (cod_cen,importe1)
values(@auxcod_cen, @importeVales+@importeEfectivo+@ImporteTalones+@ImporteTarjetas1+@importeTarjetas2-@importeGastos)
fetch next from cursortemporal into @auxcod_cen

select @importeVales=0
select @importeEfectivo=0
select @importeTalones=0
select @importeTarjetas1=0
select @importeTarjetas2=0
select @importeGastos=0
end

close cursortemporal
*/
select * from detallecaja_aux
GO

When I try to run it from visual basic it slow down the sql server.

What can I do?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved