Help has anyone come across a way to automatic db creation.

Hi I've been given a project that requires me to produce a users friendly web base administarion menu that creates a new customer for one of our systems.

The problem is this Project it needs to create a database for each user, in SQL server 2000. This has me stumpted, has anybody ever done this before and could they point me in the correct direction! The majority of our administration menu are written in ASP but any help automating this procedure would be useful.

Thanks a lot, EdYou can create a database simply using the T-SQL command

CREATE DATABASE

that can be invoked as any other command from your client.

You can also use it in a Stored Procedure.|||Originally posted by manowar
You can create a database simply using the T-SQL command

CREATE DATABASE

that can be invoked as any other command from your client.

You can also use it in a Stored Procedure.

Excellent, thanks

Help finding MSDE installation error

Hi
A customer has problems installing MSDE. I cannot understand what the
error is. Any help is very appriciated.
Regards
//Patrik
Here is the contents of the log file from where I find the first
occurence of
the word "fail" and a bit forward:
MSI (s) (2C:C8): Creating MSIHANDLE (181) of type 790536 for thread
968
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
MSI (s) (2C:C8): Executing op:
ActionStart(Name=InstallSQLAdHlp.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
Action 12:28:24: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
MSI (s) (2C:C8): Executing op:
CustomActionSchedule(Action=InstallSQLAdHlp.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSQLAdHlp,)
MSI (s) (2C:C8): Creating MSIHANDLE (188) of type 790536 for thread
968
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action CallSQLAdHlp
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe : 0
MSI (s) (2C:C8): Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
Action 12:28:24: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B.
MSI (s) (2C:C8): Executing op:
CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (2C:C8): Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
Action 12:28:24: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B.
MSI (s) (2C:C8): Executing op:
CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
MSI (s) (2C:C8): Creating MSIHANDLE (195) of type 790536 for thread
968
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (ELECTRO-5D23BA5,LocalSystem,87).
Action ended 12:28:25: InstallFinalize. Return value 3.
MSI (s) (2C:C8): User policy value 'DisableRollback' is 0
MSI (s) (2C:C8): Machine policy value 'DisableRollback' is 0
MSI (s) (2C:C8): Executing op:
Header(Signature=1397708873,Version=200,Timestamp= 841900906,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
MSI (s) (2C:C8): Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (2C:C8): Executing op: DialogInfo(Type=1,Argument=Microsoft
SQL Server Desktop Engine)
MSI (s) (2C:C8): Executing op:
RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
action:,RollbackTemplate=,CleanupAction=RollbackCl eanup,CleanupDescription=Removing
backup files,CleanupTemplate=File: )
Action 12:28:25: Rollback. Rolling back action:
Rollback: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B
MSI (s) (2C:C8): Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (2C:C8): Executing op:
ProductInfo(ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},ProductName=Microsoft
SQL Server Desktop Engine,PackageName=SqlRun01.msi,Language=1033,Vers ion=134218488,Assignment=1,ObsoleteArg=0,,PackageM ediaPath=\Msde\Setup\
,PackageCode={43D02102-CDCE-40C6-8D1E-4DF809870C28},,,InstanceType=0)
Rollback: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
MSI (s) (2C:C8): Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (2C:C8): Executing op:
CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (2C:C8): Creating MSIHANDLE (202) of type 790536 for thread
968
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action UnInstSQLAgentSecurity
Starting custom action UnInstSQLAgentSecurity
Rollback: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
MSI (s) (2C:C8): Executing op:
ActionStart(Name=InstallSQLAdHlp.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
Rollback: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B
MSI (s) (2C:C8): Executing op:
ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
Rollback: Installing new services
MSI (s) (2C:C8): Executing op:
ActionStart(Name=InstallServices,Description=Insta lling new
services,Template=Service: )
MSI (s) (2C:C8): Executing op:
ServiceControl(,Name=MSSQLSERVER,Action=8,,)
MSI (s) (2C:C8): Executing op:
ServiceControl(,Name=SQLSERVERAGENT,Action=8,,)
Rollback: Registering type libraries
MSI (s) (2C:C8): Executing op:
ActionStart(Name=RegisterTypeLibraries,Description =Registering type
libraries,Template=LibID: )
MSI (s) (2C:C8): Executing op:
TypeLibraryUnregister(,,FilePath=C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\dtspump.DLL,LibID={10010200-740B-11D0-AE7B-00AA004A34D5},Version=-2147483648,,Language=0,,BinaryType=0)
MSI (s) (2C:C8): Note: 1: 1402 2:
UNKNOWN\TypeLib\{10010200-740B-11D0-AE7B-00AA004A34D5}\0.0\0\win32 3:
2
MSI (s) (2C:C8): CMsiServices::ProcessTypeLibrary runs in local
context, not impersonated.
MSI (s) (2C:C8): ProcessTypeLibraryCore returns: 0. (0 means OK)
MSI (s) (2C:C8): Executing op:
TypeLibraryUnregister(,,FilePath=C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\dtspkg.DLL,LibID={10010001-EB1C-11CF-AE6E-00AA004A34D5},Version=-2147483648,,Language=0,,BinaryType=0)
MSI (s) (2C:C8): Note: 1: 1402 2:
UNKNOWN\TypeLib\{10010001-EB1C-11CF-AE6E-00AA004A34D5}\0.0\0\win32 3:
2
MSI (s) (2C:C8): CMsiServices::ProcessTypeLibrary runs in local
context, not impersonated.
MSI (s) (2C:C8): ProcessTypeLibraryCore returns: 0. (0 means OK)
MSI (s) (2C:C8): Executing op:
TypeLibraryUnregister(,,FilePath=C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQLDMO.dll,LibID={10010001-E260-11CF-AE68-00AA004A34D5},Version=-2147483648,,Language=0,,BinaryType=0)
MSI (s) (2C:C8): Note: 1: 1402 2:
UNKNOWN\TypeLib\{10010001-E260-11CF-AE68-00AA004A34D5}\0.0\0\win32 3:
2
MSI (s) (2C:C8): CMsiServices::ProcessTypeLibrary runs in local
context, not impersonated.
MSI (s) (2C:C8): ProcessTypeLibraryCore returns: 0. (0 means OK)
Rollback: Updating environment strings
MSI (s) (2C:C8): Executing op:
ActionStart(Name=WriteEnvironmentStrings,Descripti on=Updating
environment strings,Template=Name: , Value: , Action )
MSI (s) (2C:C8): Executing op:
RegOpenKey(Root=-2147483646,Key=System\CurrentControlSet\Control\Se ssion
Manager\Environment,,)
MSI (s) (2C:C8): Executing op:
RegAddValue(Name=PATH,Value=#%%SystemRoot%\system3 2;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Progr am
Files\Common Files\Adaptec Shared\System,)
Rollback: Writing system registry values
MSI (s) (2C:C8): Executing op:
ActionStart(Name=WriteRegistryValues,Description=W riting system
registry values,Template=Key: , Name: , Value: )
MSI (s) (2C:C8): Executing op:
RegOpenKey(Root=-2147483646,Key=SYSTEM\CurrentControlSet\Services\E ventLog\Application\MSSQLSERVER,,BinaryType=0)
MSI (s) (2C:C8): Executing op:
RegRemoveValue(Name=TypesSupported,Value=#255,)
MSI (s) (2C:C8): Executing op: RegCreateKey()
Here is the end of the log:
MSI (s) (2C:C8): Executing op:
ComponentUnregister(ComponentId={9F8BD7FC-0607-4B60-BCB1-49EED4E18347},ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},BinaryType=0,)
MSI (s) (2C:C8): Executing op:
ComponentUnregister(ComponentId={EB28E3F2-4957-4B0A-B0EA-649F45DFEB9D},ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},BinaryType=0,)
MSI (s) (2C:C8): Executing op:
ComponentUnregister(ComponentId={AF87A101-EBBE-4E33-A0E2-C2AE9BFDC875},ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},BinaryType=0,)
MSI (s) (2C:C8): Executing op:
ComponentUnregister(ComponentId={8C669E46-2D35-47BD-90FA-C756A83ED281},ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},BinaryType=0,)
MSI (s) (2C:C8): Executing op:
ComponentUnregister(ComponentId={6D36DDE7-B112-45DB-A62C-B800713BA47B},ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},BinaryType=0,)
MSI (s) (2C:C8): Executing op:
ComponentUnregister(ComponentId={F85CC7C0-7DBF-4846-9D64-8FC2DC110F05},ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},BinaryType=0,)
MSI (s) (2C:C8): Executing op:
ComponentUnregister(ComponentId={BEA3F834-7C08-4C02-8F74-644AD6F4C6B1},ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},BinaryType=0,)
MSI (s) (2C:C8): Executing op:
ComponentUnregister(ComponentId={1E86B1D3-9AF0-48D1-A084-9B828D16ABF5},ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},BinaryType=0,)
MSI (s) (2C:C8): Executing op:
ComponentUnregister(ComponentId={8BCDD8F9-1CAC-4CF4-A9E7-0D8EE337D989},ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},BinaryType=0,)
MSI (s) (2C:C8): Executing op:
ComponentUnregister(ComponentId={586CE7CE-10C3-4871-BB52-B1A71FB75F69},ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},BinaryType=0,)
MSI (s) (2C:C8): Executing op:
ComponentUnregister(ComponentId={90F630BE-3C8F-46E3-882E-523A4D35E1C6},ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},BinaryType=0,)
MSI (s) (2C:C8): Executing op:
ComponentUnregister(ComponentId={8D1347B2-CCB1-4579-AB47-77517173B837},ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},BinaryType=0,)
Rollback: RollbackStreamSupportFiles.2D02443E_7002_4C0B_ABC9 _EAB2C064397B
MSI (s) (2C:C8): Executing op:
ActionStart(Name=RollbackStreamSupportFiles.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (2C:C8): Executing op:
CustomActionRollback(Action=RollbackStreamSupportF iles.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionTy pe=1281,Source=BinaryData,Target=RemoveSupportFile s,)
MSI (s) (2C:C8): Creating MSIHANDLE (217) of type 790536 for thread
968
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Deleted Support file :
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\setupex.dll
Deleted Support file :
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqdedev.dll
Deleted Support file :
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlsut.dll
Deleted Support file :
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlunirl.dll
Deleted Support file :
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlresld.dll
Deleted Support file :
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.rll
Deleted Support file :
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.dll
Deleted Support file :
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.rll
Deleted Support file :
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
Rollback: RollbackDeferProperties.2D02443E_7002_4C0B_ABC9_EA B2C064397B
MSI (s) (2C:C8): Executing op:
ActionStart(Name=RollbackDeferProperties.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (2C:C8): Executing op:
CustomActionRollback(Action=RollbackDeferPropertie s.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType= 1281,Source=BinaryData,Target=DeferProperties,)
MSI (s) (2C:C8): Creating MSIHANDLE (228) of type 790536 for thread
968
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
Defer Properties returns: 0
MSI (s) (2C:C8): Executing op: End(Checksum=0,ProgressTotal=0)
MSI (s) (2C:C8): Error in rollback skipped. Return: 5
MSI (s) (2C:C8): FEATURECACHE: Entering Invalidate
MSI (s) (2C:C8): Unlocking Server
Action ended 12:28:46: INSTALL. Return value 3.
MSI (s) (2C:C8): Note: 1: 2262 2: Control 3: -2147287038
Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(S): SqlCollation = SQL_Latin1_General_Cp1_CS_AS
Property(S): SqlDataDir = C:\Microsoft SQL Server\
Property(S): SqlProgramDir = C:\Microsoft SQL Server\
Property(S): SqlInstanceName = MSSQLSERVER
Property(S): SqlSecurityMode = SQL
Property(S): SqlBlankSa...
Property(S): VersionNT = 500
Property(S): ALLUSERS = 1
Property(S): ARPNOMODIFY = 1
Property(S): DefaultUIFont = Tahoma8
Property(S): INSTALLLEVEL = 3
Property(S): LIMITUI = 1
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(S): ProductLanguage = 1033
Property(S): ProductName = Microsoft SQL Server Desktop Engine
Property(S): ProductVersion = 8.00.760
Property(S): MsiHiddenProperties = SqlSa...
Property(S): TARGETDIR = C:\Microsoft SQL Server\
Property(S): SourceDir = D:\Msde\Setup\
Property(S): ProgramFilesFolder.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B =
C:\Program Files\
Property(S): Data.2D02443E_7002_4C0B_ABC9_EAB2C064397B = C:\Microsoft
SQL Server\
Property(S): DataInstance.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Microsoft SQL Server\MSSQL\
Property(S): SqlTarget.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Microsoft SQL Server\
Property(S): SqlInstance.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Microsoft SQL Server\MSSQL\
Property(S): DataInstanceData.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B =
C:\Microsoft SQL Server\MSSQL\Data\
Property(S): DataInstanceInstall.2D02443E_7002_4C0B_ABC9_EAB2C0 64397B
= C:\Microsoft SQL Server\MSSQL\Install\
Property(S): DataInstanceJobs.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B =
C:\Microsoft SQL Server\MSSQL\JOBS\
Property(S): DataInstanceLog.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B =
C:\Microsoft SQL Server\MSSQL\LOG\
Property(S): Sql.2D02443E_7002_4C0B_ABC9_EAB2C064397B = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlInstanceBin.2D02443E_7002_4C0B_ABC9_EAB2C064397 B =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlInstanceJet.2D02443E_7002_4C0B_ABC9_EAB2C064397 B =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlInstanceOther.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlVer.2D02443E_7002_4C0B_ABC9_EAB2C064397B = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlTools.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlTools4Dev.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlToolsBin.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlToolsDev.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\
Property(S): SqlToolsDevInclude.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B =
C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Include\
Property(S): SqlToolsDevLib.2D02443E_7002_4C0B_ABC9_EAB2C064397 B =
C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Lib\
Property(S): SqlVerCom.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Program Files\Microsoft SQL Server\80\
Property(S): SqlVerComBin.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Program Files\Microsoft SQL Server\80\COM\
Property(S): StartupFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\Documents and Settings\All Users\Start Menu\Programs\Startup\
Property(S): SystemFolder.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\WINNT\system32\
Property(S): System.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\WINNT\system32\
Property(S): SystemX86.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\WINNT\system32\
Property(S): SQLVersion.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
8.00.194
Property(S): InstanceName.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
MSSQLSERVER
Property(S): InstanceDir.2D02443E_7002_4C0B_ABC9_EAB2C064397B = MSSQL
Property(S): InstanceRegKey.2D02443E_7002_4C0B_ABC9_EAB2C064397 B =
MSSQLServer
Property(S): Collation.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
SQL_Latin1_General_Cp1_CS_AS
Property(S): CommitDeferProperties.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
= {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(S): CommitNoRebootReplace.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
= {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(S): APPIE.2D02443E_7002_4C0B_ABC9_EAB2C064397B =
C:\WINNT\system32\shdocvw.dll
Property(S): SQLExitCode.2D02443E_7002_4C0B_ABC9_EAB2C064397B = 0
Property(S): APPS_TEST = 1
Property(S): SQLMSDESelected = 1
Property(S): CSDVersionNumber = 768
Property(S): CSDVersion = 8.00.760
Property(S): InstanceComponentSet.1 = 1
Property(S): SQLVersion = 8.00.194
Property(S): SqlToolsBin.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlTools.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SystemFolder.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4 =
C:\WINNT\system32\
Property(S): System.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4 =
C:\WINNT\system32\
Property(S): SqlSetup.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4 =
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\
Property(S): SqlSetupTemp.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4 =
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Temp\
Property(S): ProgramFilesFolder.F26FFD4A_05B4_4969_A552_30C7F9B AB1F4 =
C:\Program Files\
Property(S): Sql.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4 = C:\Program
Files\Microsoft SQL Server\
Property(S): TempFolder.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4 =
C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\
Property(S): SqlVer.F26FFD4A_05B4_4969_A552_30C7F9BAB1F4 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): InstanceRegKey.F26FFD4A_05B4_4969_A552_30C7F9BAB1F 4 =
MSSQLServer
Property(S): SqlToolsBin.F5ABDAB8_DDBD_4D92_BEAD_A0511D9C85DB =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlTools.F5ABDAB8_DDBD_4D92_BEAD_A0511D9C85DB =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlVerCom.F5ABDAB8_DDBD_4D92_BEAD_A0511D9C85DB =
C:\Program Files\Microsoft SQL Server\80\
Property(S): SqlVerComBin.F5ABDAB8_DDBD_4D92_BEAD_A0511D9C85DB =
C:\Program Files\Microsoft SQL Server\80\COM\
Property(S): SqlTarget.F5ABDAB8_DDBD_4D92_BEAD_A0511D9C85DB =
C:\Microsoft SQL Server\
Property(S): SqlInstance.F5ABDAB8_DDBD_4D92_BEAD_A0511D9C85DB =
C:\Microsoft SQL Server\MSSQL\
Property(S): ProgramFilesFolder.F5ABDAB8_DDBD_4D92_BEAD_A0511D9 C85DB =
C:\Program Files\
Property(S): Sql.F5ABDAB8_DDBD_4D92_BEAD_A0511D9C85DB = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlInstanceBin.F5ABDAB8_DDBD_4D92_BEAD_A0511D9C85D B =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlVer.F5ABDAB8_DDBD_4D92_BEAD_A0511D9C85DB = C:\Program
Files\Microsoft SQL Server\80\
Property(S): InstanceName.F5ABDAB8_DDBD_4D92_BEAD_A0511D9C85DB =
MSSQLSERVER
Property(S): InstanceDir.F5ABDAB8_DDBD_4D92_BEAD_A0511D9C85DB = MSSQL
Property(S): SqlToolsDevInclude.AC2DB678_071D_4330_A52D_9286D61 8F650 =
C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Include\
Property(S): SqlToolsDev.AC2DB678_071D_4330_A52D_9286D618F650 =
C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\
Property(S): SqlToolsDevLib.AC2DB678_071D_4330_A52D_9286D618F65 0 =
C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Lib\
Property(S): ProgramFilesFolder.AC2DB678_071D_4330_A52D_9286D61 8F650 =
C:\Program Files\
Property(S): Sql.AC2DB678_071D_4330_A52D_9286D618F650 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlVer.AC2DB678_071D_4330_A52D_9286D618F650 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlTools4Dev.AC2DB678_071D_4330_A52D_9286D618F650 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlToolsBin.9B023A3C_3C86_4E4B_90D5_DE42FB9019F7 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlTools.9B023A3C_3C86_4E4B_90D5_DE42FB9019F7 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): ProgramFilesFolder.9B023A3C_3C86_4E4B_90D5_DE42FB9 019F7 =
C:\Program Files\
Property(S): Sql.9B023A3C_3C86_4E4B_90D5_DE42FB9019F7 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlVer.9B023A3C_3C86_4E4B_90D5_DE42FB9019F7 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlToolsBinRes1033.6496AA57_4ABB_4A5B_A0A9_E712ECF A8092 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\
Property(S): SqlToolsBinRes.6496AA57_4ABB_4A5B_A0A9_E712ECFA809 2 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\
Property(S): ProgramFilesFolder.6496AA57_4ABB_4A5B_A0A9_E712ECF A8092 =
C:\Program Files\
Property(S): Sql.6496AA57_4ABB_4A5B_A0A9_E712ECFA8092 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlVer.6496AA57_4ABB_4A5B_A0A9_E712ECFA8092 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlTools.6496AA57_4ABB_4A5B_A0A9_E712ECFA8092 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlToolsBin.6496AA57_4ABB_4A5B_A0A9_E712ECFA8092 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlToolsBin.55BCEE28_CDBF_4D7F_97C4_082D6B58B9FF =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlTools.55BCEE28_CDBF_4D7F_97C4_082D6B58B9FF =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): ProgramFilesFolder.55BCEE28_CDBF_4D7F_97C4_082D6B5 8B9FF =
C:\Program Files\
Property(S): Sql.55BCEE28_CDBF_4D7F_97C4_082D6B58B9FF = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlTarget.55BCEE28_CDBF_4D7F_97C4_082D6B58B9FF =
C:\Microsoft SQL Server\
Property(S): SqlVer.55BCEE28_CDBF_4D7F_97C4_082D6B58B9FF = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlToolsBinRes1033.9240E1C0_49D2_40A2_93CE_E62CD8B 48DDC =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\
Property(S): SqlToolsBinRes.9240E1C0_49D2_40A2_93CE_E62CD8B48DD C =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\
Property(S): ProgramFilesFolder.9240E1C0_49D2_40A2_93CE_E62CD8B 48DDC =
C:\Program Files\
Property(S): Sql.9240E1C0_49D2_40A2_93CE_E62CD8B48DDC = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlVer.9240E1C0_49D2_40A2_93CE_E62CD8B48DDC = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlTools.9240E1C0_49D2_40A2_93CE_E62CD8B48DDC =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlToolsBin.9240E1C0_49D2_40A2_93CE_E62CD8B48DDC =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlVerComBin.185C1D8F_1545_4277_BB64_857D2622DB57 =
C:\Program Files\Microsoft SQL Server\80\COM\
Property(S): SqlVerCom.185C1D8F_1545_4277_BB64_857D2622DB57 =
C:\Program Files\Microsoft SQL Server\80\
Property(S): DataInstance.185C1D8F_1545_4277_BB64_857D2622DB57 =
C:\Microsoft SQL Server\MSSQL\
Property(S): DataInstanceInstall.185C1D8F_1545_4277_BB64_857D26 22DB57
= C:\Microsoft SQL Server\MSSQL\Install\
Property(S): SqlInstance.185C1D8F_1545_4277_BB64_857D2622DB57 =
C:\Microsoft SQL Server\MSSQL\
Property(S): SqlInstanceBin.185C1D8F_1545_4277_BB64_857D2622DB5 7 =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): Data.185C1D8F_1545_4277_BB64_857D2622DB57 = C:\Microsoft
SQL Server\
Property(S): SqlTarget.185C1D8F_1545_4277_BB64_857D2622DB57 =
C:\Microsoft SQL Server\
Property(S): ProgramFilesFolder.185C1D8F_1545_4277_BB64_857D262 2DB57 =
C:\Program Files\
Property(S): Sql.185C1D8F_1545_4277_BB64_857D2622DB57 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlVer.185C1D8F_1545_4277_BB64_857D2622DB57 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): InstanceName.185C1D8F_1545_4277_BB64_857D2622DB57 =
MSSQLSERVER
Property(S): InstanceDir.185C1D8F_1545_4277_BB64_857D2622DB57 = MSSQL
Property(S): InstanceRegKey.185C1D8F_1545_4277_BB64_857D2622DB5 7 =
MSSQLServer
Property(S): SqlVerComBinRes1033.D9BC9C10_2DCD_44D3_AACC_9C58CA F76128
= C:\Program Files\Microsoft SQL Server\80\COM\Resources\1033\
Property(S): SqlVerComBinRes.D9BC9C10_2DCD_44D3_AACC_9C58CAF761 28 =
C:\Program Files\Microsoft SQL Server\80\COM\Resources\
Property(S): ProgramFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF 76128 =
C:\Program Files\
Property(S): Sql.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlVer.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlVerCom.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 =
C:\Program Files\Microsoft SQL Server\80\
Property(S): SqlVerComBin.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 =
C:\Program Files\Microsoft SQL Server\80\COM\
Property(S): InstanceName.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 =
MSSQLSERVER
Property(S): InstanceDir.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = MSSQL
Property(S): SqlToolsBin.DCDF3AA8_FCF8_49F6_9877_752F754DD676 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlTools.DCDF3AA8_FCF8_49F6_9877_752F754DD676 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlInstance.DCDF3AA8_FCF8_49F6_9877_752F754DD676 =
C:\Microsoft SQL Server\MSSQL\
Property(S): SqlInstanceBin.DCDF3AA8_FCF8_49F6_9877_752F754DD67 6 =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlTarget.DCDF3AA8_FCF8_49F6_9877_752F754DD676 =
C:\Microsoft SQL Server\
Property(S): ProgramFilesFolder.DCDF3AA8_FCF8_49F6_9877_752F754 DD676 =
C:\Program Files\
Property(S): Sql.DCDF3AA8_FCF8_49F6_9877_752F754DD676 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlVer.DCDF3AA8_FCF8_49F6_9877_752F754DD676 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): InstanceName.DCDF3AA8_FCF8_49F6_9877_752F754DD676 =
MSSQLSERVER
Property(S): InstanceDir.DCDF3AA8_FCF8_49F6_9877_752F754DD676 = MSSQL
Property(S): SqlToolsBinRes1033.EF490CFB_7BC2_4102_8395_426CE58 70B18 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\
Property(S): SqlToolsBinRes.EF490CFB_7BC2_4102_8395_426CE5870B1 8 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\
Property(S): SqlInstanceBinRes.EF490CFB_7BC2_4102_8395_426CE587 0B18 =
C:\Microsoft SQL Server\MSSQL\Binn\Resources\
Property(S): SqlInstanceBinRes1033.EF490CFB_7BC2_4102_8395_426C E5870B18
= C:\Microsoft SQL Server\MSSQL\Binn\Resources\1033\
Property(S): SqlTarget.EF490CFB_7BC2_4102_8395_426CE5870B18 =
C:\Microsoft SQL Server\
Property(S): SqlInstance.EF490CFB_7BC2_4102_8395_426CE5870B18 =
C:\Microsoft SQL Server\MSSQL\
Property(S): ProgramFilesFolder.EF490CFB_7BC2_4102_8395_426CE58 70B18 =
C:\Program Files\
Property(S): Sql.EF490CFB_7BC2_4102_8395_426CE5870B18 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlInstanceBin.EF490CFB_7BC2_4102_8395_426CE5870B1 8 =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlVer.EF490CFB_7BC2_4102_8395_426CE5870B18 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlTools.EF490CFB_7BC2_4102_8395_426CE5870B18 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlToolsBin.EF490CFB_7BC2_4102_8395_426CE5870B18 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): InstanceName.EF490CFB_7BC2_4102_8395_426CE5870B18 =
MSSQLSERVER
Property(S): InstanceDir.EF490CFB_7BC2_4102_8395_426CE5870B18 = MSSQL
Property(S): SqlInstanceBin.C4D32C83_C28D_4329_A829_31C4C6034F5 9 =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlInstance.C4D32C83_C28D_4329_A829_31C4C6034F59 =
C:\Microsoft SQL Server\MSSQL\
Property(S): SqlTools.C4D32C83_C28D_4329_A829_31C4C6034F59 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlToolsBin.C4D32C83_C28D_4329_A829_31C4C6034F59 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): Data.C4D32C83_C28D_4329_A829_31C4C6034F59 = C:\Microsoft
SQL Server\
Property(S): DataInstance.C4D32C83_C28D_4329_A829_31C4C6034F59 =
C:\Microsoft SQL Server\MSSQL\
Property(S): SqlTarget.C4D32C83_C28D_4329_A829_31C4C6034F59 =
C:\Microsoft SQL Server\
Property(S): DataInstanceJobs.C4D32C83_C28D_4329_A829_31C4C6034 F59 =
C:\Microsoft SQL Server\MSSQL\JOBS\
Property(S): DataInstanceLog.C4D32C83_C28D_4329_A829_31C4C6034F 59 =
C:\Microsoft SQL Server\MSSQL\LOG\
Property(S): ProgramFilesFolder.C4D32C83_C28D_4329_A829_31C4C60 34F59 =
C:\Program Files\
Property(S): Sql.C4D32C83_C28D_4329_A829_31C4C6034F59 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlVer.C4D32C83_C28D_4329_A829_31C4C6034F59 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlVerCom.C4D32C83_C28D_4329_A829_31C4C6034F59 =
C:\Program Files\Microsoft SQL Server\80\
Property(S): SqlVerComBin.C4D32C83_C28D_4329_A829_31C4C6034F59 =
C:\Program Files\Microsoft SQL Server\80\COM\
Property(S): InstanceName.C4D32C83_C28D_4329_A829_31C4C6034F59 =
MSSQLSERVER
Property(S): InstanceDir.C4D32C83_C28D_4329_A829_31C4C6034F59 = MSSQL
Property(S): InstanceRegKey.C4D32C83_C28D_4329_A829_31C4C6034F5 9 =
MSSQLServer
Property(S): ServiceNameAgent.C4D32C83_C28D_4329_A829_31C4C6034 F59 =
SQLSERVERAGENT
Property(S): ServiceNameSQL.C4D32C83_C28D_4329_A829_31C4C6034F5 9 =
MSSQLSERVER
Property(S): SqlInstanceBinRes1033.BF65A835_E76E_4CA5_8B97_E8FD 33E7C475
= C:\Microsoft SQL Server\MSSQL\Binn\Resources\1033\
Property(S): SqlInstanceBinRes.BF65A835_E76E_4CA5_8B97_E8FD33E7 C475 =
C:\Microsoft SQL Server\MSSQL\Binn\Resources\
Property(S): SqlToolsBinRes.BF65A835_E76E_4CA5_8B97_E8FD33E7C47 5 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\
Property(S): SqlToolsBinRes1033.BF65A835_E76E_4CA5_8B97_E8FD33E 7C475 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\
Property(S): SqlTarget.BF65A835_E76E_4CA5_8B97_E8FD33E7C475 =
C:\Microsoft SQL Server\
Property(S): SqlInstance.BF65A835_E76E_4CA5_8B97_E8FD33E7C475 =
C:\Microsoft SQL Server\MSSQL\
Property(S): ProgramFilesFolder.BF65A835_E76E_4CA5_8B97_E8FD33E 7C475 =
C:\Program Files\
Property(S): Sql.BF65A835_E76E_4CA5_8B97_E8FD33E7C475 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlInstanceBin.BF65A835_E76E_4CA5_8B97_E8FD33E7C47 5 =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlVer.BF65A835_E76E_4CA5_8B97_E8FD33E7C475 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlTools.BF65A835_E76E_4CA5_8B97_E8FD33E7C475 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlToolsBin.BF65A835_E76E_4CA5_8B97_E8FD33E7C475 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): InstanceName.BF65A835_E76E_4CA5_8B97_E8FD33E7C475 =
MSSQLSERVER
Property(S): InstanceDir.BF65A835_E76E_4CA5_8B97_E8FD33E7C475 = MSSQL
Property(S): SqlToolsBin.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlTools.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlInstance.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\Microsoft SQL Server\MSSQL\
Property(S): SqlInstanceBin.CC1A8C58_27D1_4D38_BF1B_C0A5CBB9061 6 =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): DataInstance.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\Microsoft SQL Server\MSSQL\
Property(S): DataInstanceData.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90 616 =
C:\Microsoft SQL Server\MSSQL\Data\
Property(S): SqlVerCom.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\Program Files\Microsoft SQL Server\80\
Property(S): SqlVerComBin.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\Program Files\Microsoft SQL Server\80\COM\
Property(S): SqlInstanceJet.CC1A8C58_27D1_4D38_BF1B_C0A5CBB9061 6 =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlTarget.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\Microsoft SQL Server\
Property(S): Readme.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\Microsoft SQL Server\MSSQL\
Property(S): DataInstanceInstall.CC1A8C58_27D1_4D38_BF1B_C0A5CB B90616
= C:\Microsoft SQL Server\MSSQL\Install\
Property(S): DataInstanceLog.CC1A8C58_27D1_4D38_BF1B_C0A5CBB906 16 =
C:\Microsoft SQL Server\MSSQL\LOG\
Property(S): Data.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = C:\Microsoft
SQL Server\
Property(S): DataInstanceJobs.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90 616 =
C:\Microsoft SQL Server\MSSQL\JOBS\
Property(S): ProgramFilesFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB 90616 =
C:\Program Files\
Property(S): Sql.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlInstanceOther.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90 616 =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlVer.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlTools4Dev.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlToolsDev.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\
Property(S): SqlToolsDevInclude.CC1A8C58_27D1_4D38_BF1B_C0A5CBB 90616 =
C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Include\
Property(S): SqlToolsDevLib.CC1A8C58_27D1_4D38_BF1B_C0A5CBB9061 6 =
C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Lib\
Property(S): StartupFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\Documents and Settings\All Users\Start Menu\Programs\Startup\
Property(S): SystemFolder.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\WINNT\system32\
Property(S): System.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\WINNT\system32\
Property(S): SystemX86.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
C:\WINNT\system32\
Property(S): Collation.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
SQL_Latin1_General_Cp1_CS_AS
Property(S): InstanceName.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
MSSQLSERVER
Property(S): InstanceRegKey.CC1A8C58_27D1_4D38_BF1B_C0A5CBB9061 6 =
MSSQLServer
Property(S): PipeName.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
\\.\pipe\\sql\query
Property(S): ServiceNameAgent.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90 616 =
SQLSERVERAGENT
Property(S): ServiceNameSQL.CC1A8C58_27D1_4D38_BF1B_C0A5CBB9061 6 =
MSSQLSERVER
Property(S): SQLVersion.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 =
8.00.194
Property(S): TcpPort.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = 1433
Property(S): PipeName = \\.\pipe\\sql\query
Property(S): TcpPort = 1433
Property(S): SqlToolsBinRes1033.88C26F26_166C_4CD7_8175_38297C2 276D7 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\
Property(S): SqlToolsBinRes.88C26F26_166C_4CD7_8175_38297C2276D 7 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\
Property(S): SqlInstanceBinRes.88C26F26_166C_4CD7_8175_38297C22 76D7 =
C:\Microsoft SQL Server\MSSQL\Binn\Resources\
Property(S): SqlInstanceBinRes1033.88C26F26_166C_4CD7_8175_3829 7C2276D7
= C:\Microsoft SQL Server\MSSQL\Binn\Resources\1033\
Property(S): SqlTarget.88C26F26_166C_4CD7_8175_38297C2276D7 =
C:\Microsoft SQL Server\
Property(S): SqlInstance.88C26F26_166C_4CD7_8175_38297C2276D7 =
C:\Microsoft SQL Server\MSSQL\
Property(S): ProgramFilesFolder.88C26F26_166C_4CD7_8175_38297C2 276D7 =
C:\Program Files\
Property(S): Sql.88C26F26_166C_4CD7_8175_38297C2276D7 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlInstanceBin.88C26F26_166C_4CD7_8175_38297C2276D 7 =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlInstanceJet.88C26F26_166C_4CD7_8175_38297C2276D 7 =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlInstanceOther.88C26F26_166C_4CD7_8175_38297C227 6D7 =
C:\Microsoft SQL Server\MSSQL\Binn\
Property(S): SqlVer.88C26F26_166C_4CD7_8175_38297C2276D7 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlTools.88C26F26_166C_4CD7_8175_38297C2276D7 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlToolsBin.88C26F26_166C_4CD7_8175_38297C2276D7 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): InstanceName.88C26F26_166C_4CD7_8175_38297C2276D7 =
MSSQLSERVER
Property(S): InstanceDir.88C26F26_166C_4CD7_8175_38297C2276D7 = MSSQL
Property(S): InstanceRegKey.88C26F26_166C_4CD7_8175_38297C2276D 7 =
MSSQLServer
Property(S): SqlToolsBin.0C7570D6_6225_4960_B951_4D16DD906838 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlTools.0C7570D6_6225_4960_B951_4D16DD906838 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): ProgramFilesFolder.0C7570D6_6225_4960_B951_4D16DD9 06838 =
C:\Program Files\
Property(S): Sql.0C7570D6_6225_4960_B951_4D16DD906838 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlVer.0C7570D6_6225_4960_B951_4D16DD906838 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): Path.0C7570D6_6225_4960_B951_4D16DD906838 = C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlToolsBinRes1033.ACD7EC22_4989_4067_B267_6DB5716 695BC =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\
Property(S): SqlToolsBinRes.ACD7EC22_4989_4067_B267_6DB5716695B C =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\
Property(S): ProgramFilesFolder.ACD7EC22_4989_4067_B267_6DB5716 695BC =
C:\Program Files\
Property(S): Sql.ACD7EC22_4989_4067_B267_6DB5716695BC = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlVer.ACD7EC22_4989_4067_B267_6DB5716695BC = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SqlTools.ACD7EC22_4989_4067_B267_6DB5716695BC =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): SqlToolsBin.ACD7EC22_4989_4067_B267_6DB5716695BC =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlToolsBin.66CDF039_0EDE_453E_A1E5_1931046C4056 =
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
Property(S): SqlTools.66CDF039_0EDE_453E_A1E5_1931046C4056 =
C:\Program Files\Microsoft SQL Server\80\Tools\
Property(S): ProgramFilesFolder.66CDF039_0EDE_453E_A1E5_1931046 C4056 =
C:\Program Files\
Property(S): Sql.66CDF039_0EDE_453E_A1E5_1931046C4056 = C:\Program
Files\Microsoft SQL Server\
Property(S): SqlVer.66CDF039_0EDE_453E_A1E5_1931046C4056 = C:\Program
Files\Microsoft SQL Server\80\
Property(S): SystemFolder = C:\WINNT\system32\
Property(S): Redist.51D569E2_8A28_11D2_B962_006097C4DE24 =
C:\WINNT\system32\
Property(S): MS.51D569E2_8A28_11D2_B962_006097C4DE24 =
C:\WINNT\system32\
Property(S): System.51D569E2_8A28_11D2_B962_006097C4DE24 =
C:\WINNT\system32\
Property(S): MS.3CE1F932_C090_11D2_977B_006097C4DE24 =
C:\WINNT\system32\
Property(S): Redist.3CE1F932_C090_11D2_977B_006097C4DE24 =
C:\WINNT\system32\
Property(S): System.3CE1F932_C090_11D2_977B_006097C4DE24 =
C:\WINNT\system32\
Property(S): MS.51D569E0_8A28_11D2_B962_006097C4DE24 =
C:\WINNT\system32\
Property(S): Redist.51D569E0_8A28_11D2_B962_006097C4DE24 =
C:\WINNT\system32\
Property(S): System.51D569E0_8A28_11D2_B962_006097C4DE24 =
C:\WINNT\system32\
Property(S): MS.7EBEDD3E_AA66_11D2_B980_006097C4DE24 =
C:\WINNT\system32\
Property(S): Redist.7EBEDD3E_AA66_11D2_B980_006097C4DE24 =
C:\WINNT\system32\
Property(S): System.7EBEDD3E_AA66_11D2_B980_006097C4DE24 =
C:\WINNT\system32\
Property(S): MS.7EBEDD68_AA66_11D2_B980_006097C4DE24 =
C:\WINNT\system32\
Property(S): Redist.7EBEDD68_AA66_11D2_B980_006097C4DE24 =
C:\WINNT\system32\
Property(S): System.7EBEDD68_AA66_11D2_B980_006097C4DE24 =
C:\WINNT\system32\
Property(S): ANSI.7EBEDD68_AA66_11D2_B980_006097C4DE24 =
C:\WINNT\system32\
Property(S): DataInstanceInstall.24170C3F_A9E4_47C1_8DFE_FD79C2 714697
= C:\Microsoft SQL Server\MSSQL\Install\
Property(S): DataInstance.24170C3F_A9E4_47C1_8DFE_FD79C2714697 =
C:\Microsoft SQL Server\MSSQL\
Property(S): Data.24170C3F_A9E4_47C1_8DFE_FD79C2714697 = C:\Microsoft
SQL Server\
Property(S): DataInstanceData.24170C3F_A9E4_47C1_8DFE_FD79C2714 697 =
C:\Microsoft SQL Server\MSSQL\Data\
Property(S): DataInstanceJobs.24170C3F_A9E4_47C1_8DFE_FD79C2714 697 =
C:\Microsoft SQL Server\MSSQL\JOBS\
Property(S): DataInstanceLog.24170C3F_A9E4_47C1_8DFE_FD79C27146 97 =
C:\Microsoft SQL Server\MSSQL\LOG\
Property(S): InstanceName.24170C3F_A9E4_47C1_8DFE_FD79C2714697 =
MSSQLSERVER
Property(S): PackageCode = {43D02102-CDCE-40C6-8D1E-4DF809870C28}
Property(S): ProductState = -1
Property(S): PackagecodeChanging = 1
Property(S): BLANKSA...
Property(S): DATADIR = C:\Microsoft SQL Server\
Property(S): COLLATION = SQL_Latin1_General_Cp1_CS_AS
Property(S): SECURITYMODE = SQL
Property(S): CURRENTDIRECTORY = D:\
Property(S): CLIENTUILEVEL = 3
Property(S): CLIENTPROCESSID = 1056
Property(S): CURRENTMEDIAVOLUMELABEL = SERVICE SOFTWARE
Property(S): VersionDatabase = 110
Property(S): VersionMsi = 2.00
Property(S): WindowsBuild = 2195
Property(S): ServicePackLevel = 4
Property(S): ServicePackLevelMinor = 0
Property(S): MsiNTProductType = 1
Property(S): WindowsFolder = C:\WINNT\
Property(S): WindowsVolume = C:\
Property(S): System16Folder = C:\WINNT\system\
Property(S): TempFolder = C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\
Property(S): ProgramFilesFolder = C:\Program Files\
Property(S): CommonFilesFolder = C:\Program Files\Common Files\
Property(S): AppDataFolder = C:\Documents and
Settings\Administrator\Application Data\
Property(S): FavoritesFolder = C:\Documents and
Settings\Administrator\Favorites\
Property(S): NetHoodFolder = C:\Documents and
Settings\Administrator\NetHood\
Property(S): PersonalFolder = C:\Documents and
Settings\Administrator\My Documents\
Property(S): PrintHoodFolder = C:\Documents and
Settings\Administrator\PrintHood\
Property(S): RecentFolder = C:\Documents and
Settings\Administrator\Recent\
Property(S): SendToFolder = C:\Documents and
Settings\Administrator\SendTo\
Property(S): TemplateFolder = C:\Documents and Settings\All
Users\Templates\
Property(S): CommonAppDataFolder = C:\Documents and Settings\All
Users\Application Data\
Property(S): LocalAppDataFolder = C:\Documents and
Settings\Administrator\Local Settings\Application Data\
Property(S): MyPicturesFolder = C:\Documents and
Settings\Administrator\My Documents\My Pictures\
Property(S): AdminToolsFolder = C:\Documents and Settings\All
Users\Start Menu\Programs\Administrative Tools\
Property(S): StartupFolder = C:\Documents and Settings\All Users\Start
Menu\Programs\Startup\
Property(S): ProgramMenuFolder = C:\Documents and Settings\All
Users\Start Menu\Programs\
Property(S): StartMenuFolder = C:\Documents and Settings\All
Users\Start Menu\
Property(S): DesktopFolder = C:\Documents and Settings\All
Users\Desktop\
Property(S): FontsFolder = C:\WINNT\Fonts\
Property(S): GPTSupport = 1
Property(S): OLEAdvtSupport = 1
Property(S): ShellAdvtSupport = 1
Property(S): Intel = 6
Property(S): PhysicalMemory = 256
Property(S): VirtualMemory = 499
Property(S): AdminUser = 1
Property(S): LogonUser = Administrator
Property(S): UserSID = S-1-5-21-602162358-789336058-1343024091-500
Property(S): UserLanguageID = 1033
Property(S): ComputerName = ELECTRO-5D23BA5
Property(S): SystemLanguageID = 1033
Property(S): ScreenX = 1024
Property(S): ScreenY = 768
Property(S): CaptionHeight = 19
Property(S): BorderTop = 1
Property(S): BorderSide = 1
Property(S): TextHeight = 16
Property(S): ColorBits = 16
Property(S): TTCSupport = 1
Property(S): RedirectedDllSupport = 1
Property(S): Time = 12:28:47
Property(S): Date = 1/14/2005
Property(S): Privileged = 1
Property(S): USERNAME = Electro Rent
Property(S): COMPANYNAME = Electro Rent Corporation
Property(S): DATABASE = C:\WINNT\Installer\10aaae.msi
Property(S): OriginalDatabase = D:\Msde\Setup\SqlRun01.msi
Property(S): UILevel = 2
Property(S): ACTION = INSTALL
Property(S): AgentServiceName = SQLSERVERAGENT
Property(S): InstanceRegKey = MSSQLServer
Property(S): InstanceSubDir = MSSQL
Property(S): SqlPerfMonRegKey = SQLCTR
Property(S): SQLServiceName = MSSQLSERVER
Property(S): SqlStates = 0
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SqlFeature = SqlRun
Property(S): SOURCEDIR = D:\Msde\Setup\
Property(S): SourcedirProduct = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(S): ProductToBeRegistered = 1
=== Logging stopped: 1/14/2005 12:28:47 ===
MSI (s) (2C:C8): Note: 1: 1708
MSI (s) (2C:C8): Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
MSI (s) (2C:C8): Cleaning up uninstalled install packages, if any
exist
MSI (s) (2C:C8): MainEngineThread is returning 1603
MSI (c) (20:40): Decrementing counter to disable shutdown. If counter
>= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (20:40): MainEngineThread is returning 1603
=== Verbose logging stopped: 1/14/2005 12:28:48 ===
hi Patrik,
Patrik Johansson wrote:
> Hi
> A customer has problems installing MSDE. I cannot understand what the
> error is. Any help is very appriciated.
> Regards
> //Patrik
please have a look at http://tinyurl.com/5y8kn if helps...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Help finding group totals for year end

My SQLServer 2k database has the following tables:
Transaction
Customer
Employee
Every Transaction is assigned a customerId
Every Customer is assigned an employee id
All Transactions have a total
What I am trying to do is calculate the top 5 customers by total for each
employee
I have the following which gives me the top 5 customers, but how do I get
the top 5 for each employee?
WB
Syntax:
SELECT t.CustomerId, sum(t.total)
FROM tblTransaction t
WHERE Year(t.TransactionDate) = 2005
GROUP BY t.CustomerId
ORDER BY sum(t.total) DESCSELECT t.employeeid, sum(t.total)
FROM tblTransaction t INNER JOIN employee e
on t.customerid = e.customerid
WHERE Year(t.TransactionDate) = 2005
GROUP BY t.employeeid
ORDER BY sum(t.total) DESC
"WB" wrote:

> My SQLServer 2k database has the following tables:
> Transaction
> Customer
> Employee
> Every Transaction is assigned a customerId
> Every Customer is assigned an employee id
> All Transactions have a total
> What I am trying to do is calculate the top 5 customers by total for each
> employee
> I have the following which gives me the top 5 customers, but how do I get
> the top 5 for each employee?
>
> WB
> Syntax:
> SELECT t.CustomerId, sum(t.total)
> FROM tblTransaction t
> WHERE Year(t.TransactionDate) = 2005
> GROUP BY t.CustomerId
> ORDER BY sum(t.total) DESC
>
>|||Is there any uniqueness about the TransAction table like an IDENTITY
Column..? I've assumed there is :-
select * from tblTransAction t1 WHERE PK_TranID IN
(SELECT TOP 5 t2.PK_TranID
FROM tblTransAction as t2
WHERE t2.CustomerID = t1.CustomerID
GROUP BY t2.CustomerID, t2.TransactionID, t2.Total
ORDER BY SUM(t2.Total) DESC)
HTH. Ryan
"WB" <none> wrote in message news:eiqpObVFGHA.376@.TK2MSFTNGP12.phx.gbl...
> My SQLServer 2k database has the following tables:
> Transaction
> Customer
> Employee
> Every Transaction is assigned a customerId
> Every Customer is assigned an employee id
> All Transactions have a total
> What I am trying to do is calculate the top 5 customers by total for each
> employee
> I have the following which gives me the top 5 customers, but how do I get
> the top 5 for each employee?
>
> WB
> Syntax:
> SELECT t.CustomerId, sum(t.total)
> FROM tblTransaction t
> WHERE Year(t.TransactionDate) = 2005
> GROUP BY t.CustomerId
> ORDER BY sum(t.total) DESC
>
>

Help - SQL Server Price extreme price variation

Hello,
I'm looking to purchase SQL Server 2000 for a customer and there seems to be
a wide price range ($2500 - $20,000). What can I tell the customer he
should expect to pay and how can I explain the price variance?
Rignt now I had planned on installing the application and using MSDE but I
understand this is a 5 user limit with a 2gb limit per database. Are there
any other considerations I should be aware of?
Thanks for info!
VicThe following link should give some info:
http://www.microsoft.com/sql/howtobuy/faq.asp
- Rob.
>--Original Message--
>Hello,
>I'm looking to purchase SQL Server 2000 for a customer
and there seems to be
>a wide price range ($2500 - $20,000). What can I tell
the customer he
>should expect to pay and how can I explain the price
variance?
>Rignt now I had planned on installing the application and
using MSDE but I
>understand this is a 5 user limit with a 2gb limit per
database. Are there
>any other considerations I should be aware of?
>
>Thanks for info!
>
>Vic
>
>.
>

Help

I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE=3D flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 =BD......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.This seems to be a duplicate post to the one in "Clients".
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 ......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.|||Hi,
To truncate the log file in 6.5 do the below steps:-
use dbname
go
dbcc checktable(syslogs)
go
Dump tran dbname with no_log
After running that execute below command to get the log size.
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
SQL Server MVP
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 ......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.|||Thanks for your help!!
I have a cpl questions if you would not mind.
do users have to be off to run this procedure?
will running this procedure endanger any of the data?
any special things I need to know or do because this is version 6.5?
what do I need to back up before running this procedure?
I really thank you for your help!!
Tom
Hari Prasad wrote:
> Hi,
> To truncate the log file in 6.5 do the below steps:-
> use dbname
> go
> dbcc checktable(syslogs)
> go
> Dump tran dbname with no_log
>
> After running that execute below command to get the log size.
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> SQL Server MVP
> "tommy2" <tommy2@.ptd.net> wrote in message
> news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
> I am having a issue with a customers server. the specs are:
> 2003 server
> sql 6.5
> log file size is 1998MB (customer increased this 2 times this week) Log
> space avail:600mb
> In EM i try and truncate the log file... but the free space never
> increases. Also there is no maint. plan on this database. When I try
> and create one it advises against creating one with databases over
> 400MB.
> SQL has been on this server for 6 months. The problem just started.
> The past day or so these errors are showing up:
>
> Any help?
>
> Event Type: Error
> Event Source: MSSQLServer
> Event Category: (2)
> Event ID: 17060
> Date: 8/4/2006
> Time: 7:51:20 AM
> User: N/A
> Computer: AUX-SERVER
> Description:
> The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE=3D flag to retrieve this
> description; see Help and Support for details. The following
> information is part of the event: Error : 701, Severity: 17, State: 2,
> There is insufficient system memory to run this query..
> Data:
> 0000: bd 02 00 00 11 00 00 00 =BD......
> 0008: 00 00 00 00 07 00 00 00 ......
> 0010: 6d 61 73 74 65 72 00 master.

Help

I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE=3D flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 =BD......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.This seems to be a duplicate post to the one in "Clients".
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 ½......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.|||Hi,
To truncate the log file in 6.5 do the below steps:-
use dbname
go
dbcc checktable(syslogs)
go
Dump tran dbname with no_log
After running that execute below command to get the log size.
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
SQL Server MVP
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb
In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.
SQL has been on this server for 6 months. The problem just started.
The past day or so these errors are showing up:
Any help?
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 7:51:20 AM
User: N/A
Computer: AUX-SERVER
Description:
The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00 ½......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.|||Thanks for your help!!
I have a cpl questions if you would not mind.
do users have to be off to run this procedure?
will running this procedure endanger any of the data?
any special things I need to know or do because this is version 6.5?
what do I need to back up before running this procedure?
I really thank you for your help!!
Tom
Hari Prasad wrote:
> Hi,
> To truncate the log file in 6.5 do the below steps:-
> use dbname
> go
> dbcc checktable(syslogs)
> go
> Dump tran dbname with no_log
>
> After running that execute below command to get the log size.
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> SQL Server MVP
> "tommy2" <tommy2@.ptd.net> wrote in message
> news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
> I am having a issue with a customers server. the specs are:
> 2003 server
> sql 6.5
> log file size is 1998MB (customer increased this 2 times this week) Log
> space avail:600mb
> In EM i try and truncate the log file... but the free space never
> increases. Also there is no maint. plan on this database. When I try
> and create one it advises against creating one with databases over
> 400MB.
> SQL has been on this server for 6 months. The problem just started.
> The past day or so these errors are showing up:
>
> Any help?
>
> Event Type: Error
> Event Source: MSSQLServer
> Event Category: (2)
> Event ID: 17060
> Date: 8/4/2006
> Time: 7:51:20 AM
> User: N/A
> Computer: AUX-SERVER
> Description:
> The description for Event ID ( 17060 ) 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. You may be able to use the /AUXSOURCE=3D flag to retrieve this
> description; see Help and Support for details. The following
> information is part of the event: Error : 701, Severity: 17, State: 2,
> There is insufficient system memory to run this query..
> Data:
> 0000: bd 02 00 00 11 00 00 00 =BD......
> 0008: 00 00 00 00 07 00 00 00 ......
> 0010: 6d 61 73 74 65 72 00 master.

hellp with the sql is needed

hello i am a beginner:

on the .mdf sql.s 2005Ex

i need to present:

the 12 month as field name

whan the first filed is the customer name

and the rest is the sum(sale)

so the result will be like this

name 1 2 3 4 5 6 7 8 9 10 11 12

name1 $1 $2 0$ 8$ $1 $2 0$ 8$ $1 $2 0$ 8$

name2 $1 $2 0$ 8$ $1 $23 0$ 8$ $1 $23 0$ 8$

name3 $1 $2 0$ 8$ $1 $2 0$ 8$ $13 $2 0$ 8$

name4 $1 $2 0$ 83$ $1 $2 0$ 8$ $1 $2 0$ 8$

well so far i reached this - wich do the sum but on 12 row per name: well .. so if you could help me ?

SELECT
CASE WHEN MONTHs = 1 THEN MONEY ELSE 0 END AS '1',
CASE WHEN MONTHs = 2 THEN MONEY ELSE 0 END AS '2',
CASE WHEN MONTHs = 3 THEN MONEY ELSE 0 END AS '3',
CASE WHEN MONTHs = 4 THEN MONEY ELSE 0 END AS '4',
CASE WHEN MONTHs = 5 THEN MONEY ELSE 0 END AS '5',
CASE WHEN MONTHs = 6 THEN MONEY ELSE 0 END AS '6',
CASE WHEN MONTHs = 7 THEN MONEY ELSE 0 END AS '7',
CASE WHEN MONTHs = 8 THEN MONEY ELSE 0 END AS '8',
CASE WHEN MONTHs = 9 THEN MONEY ELSE 0 END AS '9',
CASE WHEN MONTHs = 10 THEN MONEY ELSE 0 END AS '10'

FROM

(SELECT DISTINCT MONTH(tblActoin.MyDate) AS MONTHs, SUM(tblActoin.amount) AS MONEY, tblIdentity.name
FROM tblActoin INNER JOIN
tblIdentity ON tblActoin.IdentityID = tblIdentity.id
GROUP BY tblActoin.MyDate, tblIdentity.name) AS derivedtbl_1

thanks

try this

SELECT Names,
sum(CASE WHEN MONTHs = 1 THEN MONEY ELSE 0 END) AS '1',
sum(CASE WHEN MONTHs = 2 THEN MONEY ELSE 0 END) AS '2',
sum(CASE WHEN MONTHs = 3 THEN MONEY ELSE 0 END) AS '3',
sum(CASE WHEN MONTHs = 4 THEN MONEY ELSE 0 END) AS '4',
sum(CASE WHEN MONTHs = 5 THEN MONEY ELSE 0 END) AS '5',
sum(CASE WHEN MONTHs = 6 THEN MONEY ELSE 0 END) AS '6',
sum(CASE WHEN MONTHs = 7 THEN MONEY ELSE 0 END) AS '7',
sum(CASE WHEN MONTHs = 8 THEN MONEY ELSE 0 END) AS '8',
sum(CASE WHEN MONTHs = 9 THEN MONEY ELSE 0 END) AS '9',
sum(CASE WHEN MONTHs = 10 THEN MONEY ELSE 0 END) AS '10,
sum(CASE WHEN MONTHs = 11 THEN MONEY ELSE 0 END) AS '11',
sum(CASE WHEN MONTHs = 12 THEN MONEY ELSE 0 END) AS '12'

FROM

(SELECT DISTINCT MONTH(tblActoin.MyDate) AS MONTHs, SUM(tblActoin.amount) AS MONEY, tblIdentity.name as Names
FROM tblActoin INNER JOIN
tblIdentity ON tblActoin.IdentityID = tblIdentity.id
GROUP BY tblActoin.MyDate, tblIdentity.name) AS derivedtbl_1)

group by Names

|||Yes!!! Thank you!!!