Help in Case statement

Hi,

I have to use case statement in where condition of a sql query. I get an error

Incorrect syntax near '<'.

Declare @.iPostingID int

set @.iPostingId = 1

Select PostingID from JobsDB_JobPostings where DateDiff(day,PostingDate,getdate())

case @.iPostingId

when 1 then '<1'

when 2 then '<7'

when 3 then '<30'

when 4 then '<60'

when 5 then '<90'

end

Can anyone help me please

Thanks,

Uma Ramiya

Hi,

Maybe you want this:

Code Snippet

SELECT

CASE PostingID

WHEN 1 THEN '<1'

WHEN 2 THEN '<7'

WHEN 3 THEN '<30'

WHEN 4 THEN '<60'

WHEN 5 THEN '<90'

END

FROM JobsDB_JobPostings WHERE DATEDIFF(DAY,PostingDate,GETDATE())

Regards,

Janos

|||The parameter @.iPostingId is used for comparison and not the column field.|||Well, you need the select before the CASE|||Hi,

We use similar construct in our daily life here. Have a look on following query, this will really work.

DECLARE @.iPostingID int

SET @.iPostingId = 1

SELECT
PostingID
FROM
JobsDB_JobPostings
WHERE
DateDiff(day,PostingDate,getdate()) < (CASE
WHEN @.iPostingId = 1 THEN 1
WHEN @.iPostingId = 2 THEN 7
WHEN @.iPostingId = 3 THEN 30
WHEN @.iPostingId = 4 THEN 60
WHEN @.iPostingId = 5 THEN 90
END)|||

Hi I have the following case.i would like a precise and efficient SQL Statement for it.

I have 7 parameters which are used for comparison. I need to run the query with these parameters. which ever is not null should be compared and the null ones should be ignored. AS a result I end with lots of "if' statements as the parameters form a lot of copmbination. Is there any way to cut short the code

ALTER PROCEDURE [dbo].[JobsDb_Resumes_SelectForMatchingSkills]

@.sSkill varchar(50),

@.iCountryID int=NULL,

@.iStateID int=NULL,

@.iJobTypeID int=NULL,

@.iMinSal int=NULL,

@.iMaxSal int NULL,

@.iPeriodPosted int NULL

AS

IF @.iCountryID!=NULL AND @.iStateID=NULL AND @.iJobTypeID = NULL and @.iMinSal = NULL and @.iMaxSal = Null and iPeriodPosted = NULL

SELECT * FROM [dbo].[JobsDb_Resumes]

where targetcountryid=@.iCountryID and

resumetext like ('%' + @.sSkill + '%')

ORDER BY [postdate] DESC

IF @.iCountryID!=NULL AND @.iStateID!=NULL AND @.iJobTypeID = NULL and @.iMinSal = NULL and @.iMaxSal = Null and iPeriodPosted = NULL

SELECT * FROM [dbo].[JobsDb_Resumes]

where targetcountryid=@.iCountryID AND

targetstateid=@.iStateID and

resumetext like ('%' + @.sSkill + '%')

ORDER BY [postdate] DESC

IF @.iCountryID!=NULL AND @.iStateID!=NULL AND @.iJobTypeID != NULL and @.iMinSal = NULL and @.iMaxSal = Null and iPeriodPosted = NULL

SELECT * FROM [dbo].[JobsDb_Resumes]

where targetcountryid=@.iCountryID AND

targetstateid=@.iStateID and

jobtypeid=@.iJobTypeID and

resumetext like ('%' + @.sSkill + '%')

ORDER BY [postdate] DESC

IF @.iCountryID!=NULL AND @.iStateID!=NULL AND @.iJobTypeID != NULL and @.iMinSal != NULL and @.iMaxSal = Null and iPeriodPosted = NULL

SELECT * FROM [dbo].[JobsDb_Resumes]

where targetcountryid=@.iCountryID AND

targetstateid=@.iStateID and

jobtypeid=@.iJobTypeID and

minsalary >= @.iminsal and

resumetext like ('%' + @.sSkill + '%')

ORDER BY [postdate] DESC

IF @.iCountryID!=NULL AND @.iStateID!=NULL AND @.iJobTypeID != NULL and @.iMinSal != NULL and @.iMaxSal != Null and iPeriodPosted = NULL

SELECT * FROM [dbo].[JobsDb_Resumes]

where targetcountryid=@.iCountryID AND

targetstateid=@.iStateID and

jobtypeid=@.iJobTypeID and

minsalary >= @.iminsal and

maxsalary >= @.imaxsal and

resumetext like ('%' + @.sSkill + '%')

ORDER BY [postdate] DESC

IF @.iCountryID!=NULL AND @.iStateID!=NULL AND @.iJobTypeID != NULL and @.iMinSal != NULL and @.iMaxSal != Null and iPeriodPosted = NULL

SELECT * FROM [dbo].[JobsDb_Resumes]

where targetcountryid=@.iCountryID AND

targetstateid=@.iStateID and

jobtypeid=@.iJobTypeID and

minsalary >= @.iminsal and

maxsalary >= @.imaxsal and

resumetext like ('%' + @.sSkill + '%')

ORDER BY [postdate] DESC

IF @.iCountryID!=NULL AND @.iStateID!=NULL AND @.iJobTypeID != NULL and @.iMinSal != NULL and @.iMaxSal != Null and iPeriodPosted != NULL

SELECT * FROM [dbo].[JobsDb_Resumes]

where targetcountryid=@.iCountryID AND

targetstateid=@.iStateID and

jobtypeid=@.iJobTypeID and

minsalary >= @.iminsal and

maxsalary >= @.imaxsal and

resumetext like ('%' + @.sSkill + '%')

ORDER BY [postdate] DESC

Help I am getting an error when I run my insert statement

Please help I am getting the same error no matter how I change my
quotes.
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'Plan'.
conn.Execute("INSERT INTO jmiles.Plan([startdate],[finishdate],
[revfinish],[responsible],[action],[title],[dept],[author],[type])
values ('" & request.Form("startdate") &"' ,"&
Request.Form("finishdate") &" ," & Request.Form("revfinish") & ",'" &
Request.Form("responsible") & "','" & Request.Form("action") & "','" &
Request.Form("title") & "','" & Request.Form("dept") & "','" &
session("empid") & "','" & Request.form("type") & "')")
'set Rs =conn.Execute("SELECT * FROM Equipment")
startdate, finshdate,revfinish are all smalldatetime
[Action], responsible, dept, author, type are all text
title is nvarchar
any Ideas?
Try the OLEDB group?
"Tescumeh" <tescumeh@.gmail.com> wrote in message
news:1165868180.115810.136290@.l12g2000cwl.googlegr oups.com...
> Please help I am getting the same error no matter how I change
> my
> quotes.
> Microsoft OLE DB Provider for SQL Server error '80040e14'
> Incorrect syntax near the keyword 'Plan'.
> conn.Execute("INSERT INTO jmiles.Plan([startdate],[finishdate],
> [revfinish],[responsible],[action],[title],[dept],[author],[type])
> values ('" & request.Form("startdate") &"' ,"&
> Request.Form("finishdate") &" ," & Request.Form("revfinish") &
> ",'" &
> Request.Form("responsible") & "','" & Request.Form("action") &
> "','" &
> Request.Form("title") & "','" & Request.Form("dept") & "','" &
> session("empid") & "','" & Request.form("type") & "')")
> 'set Rs =conn.Execute("SELECT * FROM Equipment")
> startdate, finshdate,revfinish are all smalldatetime
> [Action], responsible, dept, author, type are all text
> title is nvarchar
> any Ideas?
>
|||What error message are you getting?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Tescumeh" <tescumeh@.gmail.com> wrote in message
news:1165868180.115810.136290@.l12g2000cwl.googlegr oups.com...
> Please help I am getting the same error no matter how I change my
> quotes.
> Microsoft OLE DB Provider for SQL Server error '80040e14'
> Incorrect syntax near the keyword 'Plan'.
> conn.Execute("INSERT INTO jmiles.Plan([startdate],[finishdate],
> [revfinish],[responsible],[action],[title],[dept],[author],[type])
> values ('" & request.Form("startdate") &"' ,"&
> Request.Form("finishdate") &" ," & Request.Form("revfinish") & ",'" &
> Request.Form("responsible") & "','" & Request.Form("action") & "','" &
> Request.Form("title") & "','" & Request.Form("dept") & "','" &
> session("empid") & "','" & Request.form("type") & "')")
> 'set Rs =conn.Execute("SELECT * FROM Equipment")
> startdate, finshdate,revfinish are all smalldatetime
> [Action], responsible, dept, author, type are all text
> title is nvarchar
> any Ideas?
>
|||Imposter!
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Arnie" <99yoda@.newsgroup.nospam> wrote in message
news:u0e%23N%23XHHHA.3616@.TK2MSFTNGP02.phx.gbl...
> Try the OLEDB group?
>
> "Tescumeh" <tescumeh@.gmail.com> wrote in message
> news:1165868180.115810.136290@.l12g2000cwl.googlegr oups.com...
>
|||Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'Plan'.
imposter?
|||> imposter?
We're both "Arnie".
- Arnie
|||Tescumeh said (on or about) 12/11/2006 15:16:
> Please help I am getting the same error no matter how I change my
> quotes.
> Microsoft OLE DB Provider for SQL Server error '80040e14'
> Incorrect syntax near the keyword 'Plan'.
> conn.Execute("INSERT INTO jmiles.Plan([startdate],[finishdate],
> [revfinish],[responsible],[action],[title],[dept],[author],[type])
> values ('" & request.Form("startdate") &"' ,"&
> Request.Form("finishdate") &" ," & Request.Form("revfinish") & ",'" &
> Request.Form("responsible") & "','" & Request.Form("action") & "','" &
> Request.Form("title") & "','" & Request.Form("dept") & "','" &
> session("empid") & "','" & Request.form("type") & "')")
> 'set Rs =conn.Execute("SELECT * FROM Equipment")
> startdate, finshdate,revfinish are all smalldatetime
> [Action], responsible, dept, author, type are all text
> title is nvarchar
> any Ideas?
>
When I have a problem like that, I find it very helpful to
break the code into parts so I can assign the SQL statement
to a variable, place a breakpoint in the code and inspect
the variable. Then I try copying the SQL and pasting it
into Query Analyzer. It almost always shows me the exact
problem.
|||Thank you I will try that.

Help I am getting an error when I run my insert statement

Please help I am getting the same error no matter how I change my
quotes.
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'Plan'.
conn.Execute("INSERT INTO jmiles.Plan([startdate],[finishdate],
[revfinish],[responsible],[action],[title],[dept],[a
uthor],[type])
values ('" & request.Form("startdate") &"' ,"&
Request.Form("finishdate") &" ," & Request.Form("revfinish") & ",'" &
Request.Form("responsible") & "','" & Request.Form("action") & "','" &
Request.Form("title") & "','" & Request.Form("dept") & "','" &
session("empid") & "','" & Request.form("type") & "')")
'set Rs =conn.Execute("SELECT * FROM Equipment")
startdate, finshdate,revfinish are all smalldatetime
[Action], responsible, dept, author, type are all text
title is nvarchar
any Ideas?Try the OLEDB group?
"Tescumeh" <tescumeh@.gmail.com> wrote in message
news:1165868180.115810.136290@.l12g2000cwl.googlegroups.com...
> Please help I am getting the same error no matter how I change
> my
> quotes.
> Microsoft OLE DB Provider for SQL Server error '80040e14'
> Incorrect syntax near the keyword 'Plan'.
> conn.Execute("INSERT INTO jmiles.Plan([startdate],[finishdate],
> [revfinish],[responsible],[action],[title],[dept],[
;author],[type])
> values ('" & request.Form("startdate") &"' ,"&
> Request.Form("finishdate") &" ," & Request.Form("revfinish") &
> ",'" &
> Request.Form("responsible") & "','" & Request.Form("action") &
> "','" &
> Request.Form("title") & "','" & Request.Form("dept") & "','" &
> session("empid") & "','" & Request.form("type") & "')")
> 'set Rs =conn.Execute("SELECT * FROM Equipment")
> startdate, finshdate,revfinish are all smalldatetime
> [Action], responsible, dept, author, type are all text
> title is nvarchar
> any Ideas?
>|||What error message are you getting?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Tescumeh" <tescumeh@.gmail.com> wrote in message
news:1165868180.115810.136290@.l12g2000cwl.googlegroups.com...
> Please help I am getting the same error no matter how I change my
> quotes.
> Microsoft OLE DB Provider for SQL Server error '80040e14'
> Incorrect syntax near the keyword 'Plan'.
> conn.Execute("INSERT INTO jmiles.Plan([startdate],[finishdate],
> [revfinish],[responsible],[action],[title],[dept],[
;author],[type])
> values ('" & request.Form("startdate") &"' ,"&
> Request.Form("finishdate") &" ," & Request.Form("revfinish") & ",'" &
> Request.Form("responsible") & "','" & Request.Form("action") & "','" &
> Request.Form("title") & "','" & Request.Form("dept") & "','" &
> session("empid") & "','" & Request.form("type") & "')")
> 'set Rs =conn.Execute("SELECT * FROM Equipment")
> startdate, finshdate,revfinish are all smalldatetime
> [Action], responsible, dept, author, type are all text
> title is nvarchar
> any Ideas?
>|||Imposter!
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Arnie" <99yoda@.newsgroup.nospam> wrote in message
news:u0e%23N%23XHHHA.3616@.TK2MSFTNGP02.phx.gbl...
> Try the OLEDB group?
>
> "Tescumeh" <tescumeh@.gmail.com> wrote in message
> news:1165868180.115810.136290@.l12g2000cwl.googlegroups.com...
>|||Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'Plan'.
imposter?|||> imposter?
We're both "Arnie".
- Arnie|||Tescumeh said (on or about) 12/11/2006 15:16:
> Please help I am getting the same error no matter how I change my
> quotes.
> Microsoft OLE DB Provider for SQL Server error '80040e14'
> Incorrect syntax near the keyword 'Plan'.
> conn.Execute("INSERT INTO jmiles.Plan([startdate],[finishdate],
> [revfinish],[responsible],[action],[title],[dept],[
;author],[type])
> values ('" & request.Form("startdate") &"' ,"&
> Request.Form("finishdate") &" ," & Request.Form("revfinish") & ",'" &
> Request.Form("responsible") & "','" & Request.Form("action") & "','" &
> Request.Form("title") & "','" & Request.Form("dept") & "','" &
> session("empid") & "','" & Request.form("type") & "')")
> 'set Rs =conn.Execute("SELECT * FROM Equipment")
> startdate, finshdate,revfinish are all smalldatetime
> [Action], responsible, dept, author, type are all text
> title is nvarchar
> any Ideas?
>
When I have a problem like that, I find it very helpful to
break the code into parts so I can assign the SQL statement
to a variable, place a breakpoint in the code and inspect
the variable. Then I try copying the SQL and pasting it
into Query Analyzer. It almost always shows me the exact
problem.|||Thank you I will try that.

Help getting error when using operation rename a file in the File system task editor?

Does anyone know how to do this using variables? Everytime I try it, I get the

Error: Failed to lock variable for read access with error 0xc00100001.

I also tried it writing a script and still the same error. If I hard code the values into the variables it works fine but I will be running this everday so that it will pull in the current date along with the filename. So the value of the variables will change everyday. Here is my expression:

@.[User::Variable] +(DT_WSTR,4) YEAR( GETDATE() )+"0"+(DT_WSTR,2) MONTH( GETDATE() ) + (DT_WSTR,2) DAY( GETDATE() )

The result:

C:\Documents and Settings\mroush\Desktop\OSU20060818

the 20060818 part will change everyday ie.(tomorrow will be 20060819, next day 20060820 and so on.)

I am not sure how you are doing this, were is the expression and which variable is selected in the File System Task editor.

How about this-

Create a variable called Filename.

Then go to the Properties grid for the Filename variable and set the EvaluateAsExpression to true. Now set the Expression property to your expression.

Now go back to the File System Task, and select variable Filename for the operation you want.

Is this what you have done or not?

Do you really need to rename the file? Normally I would use an Expression, like you have above, but on the ConnectionString property for my File/FlatFile connection, such that when I use the connection it automatically gets the "current" filename.

|||

Darren, thanks for the reply and

yes I done this in the expression property of the variable and set it to true, that works except it adds the file name twice. The result is below.

C:\Documents and Settings\mroush\Desktop\Cnet Apps File\Apps0821.txt0821.txt

How do I get it to only evaluate once and and it looks like everyday that it runs, it is going to just keep adding to the string? Is there away to make it clear the old filename before renaming the current one everyday or is there another way to do this? I have to rename the file with the current date everyday, instead of using 1 filename and setting the overwrite destination to true. Maybe this can't be done using this task?

Mike

|||

I don't get why there appears to be two filename parts. You have got two variables, one for the base path an then one for the full filename, upon which you set the expression?

Creating a new file everyday should be fine using an expression. If you are exporting thsi file, then why not set the expression on the flat file connection manager's connection string property, and save the extra step of the rename.

|||

Hi Darren, thanks again for responding.

Here are the two files that I am working with:

The file comes in everyday and is zipped as AAA20060822 with no extension. The numbers are the date and it changes everyday with the current date so I need the expression to get that date everyday when a new file appears. Like tomorrows file will be AAA20060823

The filename that I need to rename it as is BBBB0822.txt. It has to be renamed this way with the date format this way. I'm using 2 variables so that the dates are updated everyday automatically so that the task can be scheduled nightly. I know this is confusing but this is how the file comes in everday and this is how it needs to be renamed so the data can be processed correctly through our mainframe.

I've tried setting the isdestination and issourcepath variables to true and using the expressions in the source and destination properties through the expressions option but it errors telling me that it can't lock the variables or the variables have been renamed or do not exist in the container. Error 0xC00100001

So then I tried putting the expressions in the variables expression property and setting the evaluateasexpression property to true but it evaluates the expression twice each time I run the task adding the dates twice to the path causing it not to find the source file. I'm stupmed! I don't know what else to do? I works either way without an expression hard coding the filenames but not using variables that will change everday with the date?

Thanks,

mike

Help for bcp command for export data to txt file

I have follow the syntax to export table to .txt file like this.

bcp UL.dbo.CFP OUT C:\a.txt -T -c -S NOTEBOOK-F47731

But it always show error which is:

Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '.'.

I have try it many time. Can anyone help me to solve this problem?

Sorry if this is a simplistic answer, but have you tried putting single quotes around your query like so...

'bcp UL.dbo.CFP OUT C:\a.txt -T -c -S NOTEBOOK-F47731'

Here's how I'm using bcp at the moment.

USE MYDATABASE
GO

DECLARE @.LINE_ITEM_DATA SYSNAME
SET @.LINE_ITEM_DATA = 'bcp MYDATABASE.LINE_ITEM_DETAIL OUT c:\LineItemData.txt -T -c -t ","'
EXEC XP_CMDSHELL @.LINE_ITEM_DATA, NO_OUTPUT

Hope that helps!

help fixing a divide by zero error

I am very new to using SQL Server 2005. I have used Microsoft Access in the
past for my queries and reports.
I have the following calculation will give me the divide by zero error
message and not show the affected records.
The calculation is used to calculate how much footage (in feet) different
materials will give me.
The formula that I use is (material thickness * material width * 12 *
density) I have the density set up as a parameter to allow me to enter the
density of the particular material I am looking up.
The problem that I have is that on some material thickness and material
width may have either a 0 or may be blank.
I want the output field for the calculation to show a 0 for the calculated
footage, or something to show me that this record is not calculated but still
shows up on the report.
Thank you in advance for any help.
--
joef1946On Nov 3, 2:42 pm, joef1946 <joef1...@.discussions.microsoft.com>
wrote:
> I am very new to using SQL Server 2005. I have used Microsoft Access in the
> past for my queries and reports.
> I have the following calculation will give me the divide by zero error
> message and not show the affected records.
> The calculation is used to calculate how much footage (in feet) different
> materials will give me.
> The formula that I use is (material thickness * material width * 12 *
> density) I have the density set up as a parameter to allow me to enter the
> density of the particular material I am looking up.
> The problem that I have is that on some material thickness and material
> width may have either a 0 or may be blank.
> I want the output field for the calculation to show a 0 for the calculated
> footage, or something to show me that this record is not calculated but still
> shows up on the report.
> Thank you in advance for any help.
> --
> joef1946
The divide by zero error usually only occurs when dividing by zero.
You should be able to avoid the error if you use a conditional
statement/expression similar to this where you are doing the
calculation (in the report field/cell).
=iif(Fields!MaterialThickness.Value is Nothing or Fields!
MaterialThickness.Value = 0 or Fields!MaterialWidth.Value is Nothing
or Fields!MaterialWidth.Value = 0 or Parameters!Density.Label is
Nothing or Parameters!Density.Label = 0, 0, (Fields!
MaterialThickness.Value * Fields!MaterialWidth.Value * 12 * Parameters!
Density.Label))
This expression basically says if any of the variables or the
parameter are zero or null/empty, set the calculation to zero,
otherwise, set the calculation to the formula with the values
provided. Of course, if you are truly dividing by zero, use a similar
expression that checks for the denominator/bottom of the fraction
variable to see if it is zero or null/empty. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

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 Files driving me crazy

I have broken HTML links all over in my help files. It
drives me nuts. The error I get is :
An error has occured on this page.
Object does not support this property.
What can I do to fix this ? I have Windows XP Professional.reinstall them.
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:f57801c3bdc1$1c798690$a601280a@.phx.gbl...
> I have broken HTML links all over in my help files. It
> drives me nuts. The error I get is :
> An error has occured on this page.
> Object does not support this property.
> What can I do to fix this ? I have Windows XP Professional.

Help Converting Character string to smalldatetime data type

I am attempting to pass a string variable from a form to an SQL statement an
d
I get this error "Syntax error converting character string to smalldatetime
data type"
Your assistance is appreciated in advance....
Here is my code
<%
Dim TESTTHIS__MMColParam1
TESTTHIS__MMColParam1 = "0"
If (Request.Form("StartDate") <> "") Then
TESTTHIS__MMColParam1 = Request.Form("StartDate")
End If
%>
<%
Dim TESTTHIS__MMColParam2
TESTTHIS__MMColParam2 = "0"
If (Request.Form("EndDate") <> "") Then
TESTTHIS__MMColParam2 = Request.Form("EndDate")
End If
%>
<%
Dim TESTTHIS
Dim TESTTHIS_numRows
Set TESTTHIS = Server.CreateObject("ADODB.Recordset")
TESTTHIS.ActiveConnection = MM_CSSMetricsCONN_STRING
TESTTHIS.Source = "SELECT Team, SumofInAdherenceSecsQty /
(SumofInAdherenceSecsQty + SumofOutOfAdherenceSecsQty) AS Adherence FROM
(SELECT TOP 1000 Team, SUM(OutOfAdherenceSecsQty) AS
SumofOutOfAdherenceSecsQty, SUM(InAdherenceSecsQty) AS
SumofInAdherenceSecsQty FROM bo.[National Call Stats] WHERE (Site =
'Dallas') AND ([Date] >='" + Replace(TESTTHIS__MMColParam1, "'", "''") + "')
AND ([Date] <= '" + Replace(TESTTHIS__MMColParam2, "'", "''") + "')
GROUP BY Team, Site ORDER BY Team, Site) DERIVEDTBL"
TESTTHIS.CursorType = 0
TESTTHIS.CursorLocation = 2
TESTTHIS.LockType = 1
TESTTHIS.Open()
TESTTHIS_numRows = 0
%>
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200606/1Run a Profiler trace to see the actual select statement being sent to SQL
Sever. Also, consider using parameters instead of concatenating values.
Parameters are more secure and you don't have to double-up embedded quotes.
Hope this helps.
Dan Guzman
SQL Server MVP
"Chamark via webservertalk.com" <u21870@.uwe> wrote in message
news:6168f7c85cf47@.uwe...
>I am attempting to pass a string variable from a form to an SQL statement
>and
> I get this error "Syntax error converting character string to
> smalldatetime
> data type"
> Your assistance is appreciated in advance....
> Here is my code
> <%
> Dim TESTTHIS__MMColParam1
> TESTTHIS__MMColParam1 = "0"
> If (Request.Form("StartDate") <> "") Then
> TESTTHIS__MMColParam1 = Request.Form("StartDate")
> End If
> %>
> <%
> Dim TESTTHIS__MMColParam2
> TESTTHIS__MMColParam2 = "0"
> If (Request.Form("EndDate") <> "") Then
> TESTTHIS__MMColParam2 = Request.Form("EndDate")
> End If
> %>
> <%
> Dim TESTTHIS
> Dim TESTTHIS_numRows
> Set TESTTHIS = Server.CreateObject("ADODB.Recordset")
> TESTTHIS.ActiveConnection = MM_CSSMetricsCONN_STRING
> TESTTHIS.Source = "SELECT Team, SumofInAdherenceSecsQty /
> (SumofInAdherenceSecsQty + SumofOutOfAdherenceSecsQty) AS Adherence FROM
> (SELECT TOP 1000 Team, SUM(OutOfAdherenceSecsQty) AS
> SumofOutOfAdherenceSecsQty, SUM(InAdherenceSecsQty) AS
> SumofInAdherenceSecsQty FROM bo.[National Call Stats] WHERE (Site =
> 'Dallas') AND ([Date] >='" + Replace(TESTTHIS__MMColParam1, "'", "''") +
> "')
> AND ([Date] <= '" + Replace(TESTTHIS__MMColParam2, "'", "''") + "')
> GROUP BY Team, Site ORDER BY Team, Site)
> DERIVEDTBL"
> TESTTHIS.CursorType = 0
> TESTTHIS.CursorLocation = 2
> TESTTHIS.LockType = 1
> TESTTHIS.Open()
> TESTTHIS_numRows = 0
> %>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Forum...amming/200606/1|||Also keep in mind that if something is a valid date it still might not
be able to be converted into smalldatetime (for example dates before
19000101 and after 20790606)
Denis the SQL Menace
http://sqlservercode.blogspot.com/
Chamark via webservertalk.com wrote:
> I am attempting to pass a string variable from a form to an SQL statement
and
> I get this error "Syntax error converting character string to smalldatetim
e
> data type"
> Your assistance is appreciated in advance....
> Here is my code
> <%
> Dim TESTTHIS__MMColParam1
> TESTTHIS__MMColParam1 = "0"
> If (Request.Form("StartDate") <> "") Then
> TESTTHIS__MMColParam1 = Request.Form("StartDate")
> End If
> %>
> <%
> Dim TESTTHIS__MMColParam2
> TESTTHIS__MMColParam2 = "0"
> If (Request.Form("EndDate") <> "") Then
> TESTTHIS__MMColParam2 = Request.Form("EndDate")
> End If
> %>
> <%
> Dim TESTTHIS
> Dim TESTTHIS_numRows
> Set TESTTHIS = Server.CreateObject("ADODB.Recordset")
> TESTTHIS.ActiveConnection = MM_CSSMetricsCONN_STRING
> TESTTHIS.Source = "SELECT Team, SumofInAdherenceSecsQty /
> (SumofInAdherenceSecsQty + SumofOutOfAdherenceSecsQty) AS Adherence FROM
> (SELECT TOP 1000 Team, SUM(OutOfAdherenceSecsQty) AS
> SumofOutOfAdherenceSecsQty, SUM(InAdherenceSecsQty) AS
> SumofInAdherenceSecsQty FROM bo.[National Call Stats] WHERE (Site =
> 'Dallas') AND ([Date] >='" + Replace(TESTTHIS__MMColParam1, "'", "''") + "')
> AND ([Date] <= '" + Replace(TESTTHIS__MMColParam2, "'", "''") + "')
> GROUP BY Team, Site ORDER BY Team, Site) DERIVEDTB
L"
> TESTTHIS.CursorType = 0
> TESTTHIS.CursorLocation = 2
> TESTTHIS.LockType = 1
> TESTTHIS.Open()
> TESTTHIS_numRows = 0
> %>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Forum...amming/200606/1|||I am able to see that it is getting to the server because I get a return of
the column headers but I am not getting any data. When I hard code the dates
in the query works fine. I am sending for example 8/1/2005 from the form. If
I take out the two / and send 812005 I get an overflow error?
Dan Guzman wrote:
>Run a Profiler trace to see the actual select statement being sent to SQL
>Sever. Also, consider using parameters instead of concatenating values.
>Parameters are more secure and you don't have to double-up embedded quotes.
>
>[quoted text clipped - 43 lines]
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200606/1|||On Wed, 07 Jun 2006 20:12:46 GMT, "Chamark via webservertalk.com"
<u21870@.uwe> wrote:

>I am able to see that it is getting to the server because I get a return of
>the column headers but I am not getting any data. When I hard code the date
s
>in the query works fine. I am sending for example 8/1/2005 from the form. I
f
>I take out the two / and send 812005 I get an overflow error?
You will get an error, as '812005' does not convert to datetime:
select convert(datetime,'812005')
Server: Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in
an out-of-range datetime value.
The most reliable format for a date string is YYYYMMDD:
select convert(datetime,'20050801')
--
2005-08-01 00:00:00.000
Roy Harvey
Beacon Falls, CTsql

Help bcp import reports row size too large error

Hi
I want to use bcp tool to export a table from one machine to another
machine. And now the export works fine. But when I want to import the
text file generated by the export process to the target database, bcp
reports an error, and the operation fails. The error is
"Cannot sort a row of size 22416, which is greater than the allowable
maximum of 8094."
I think this error happens because my target table row size is too
big. Because I can not change the schema of target table, I do not how
to resolve it. Anybody can help me? Thanks.Hi
Your row size of 22416 is far more than 8094, therefore I would expect that
the row terminator is not being specified correctly. What command did you use
to BCP out the file and how are you trying to load it?
Are the versions of SQL Server on each machine the same or different?
John
"Hailin.Cai@.gmail.com" wrote:
> Hi
> I want to use bcp tool to export a table from one machine to another
> machine. And now the export works fine. But when I want to import the
> text file generated by the export process to the target database, bcp
> reports an error, and the operation fails. The error is
> "Cannot sort a row of size 22416, which is greater than the allowable
> maximum of 8094."
> I think this error happens because my target table row size is too
> big. Because I can not change the schema of target table, I do not how
> to resolve it. Anybody can help me? Thanks.
>|||If you are using Microsoft's BCP utility to extract the data from the
source database, then I assume the source is SQL Server 2005 and is
using something like VARCHAR(MAX) to allow row size greater than the
normal limit.
If the target table can not be changed you have to decide what is the
proper thing to do with the rows that have the problem. Should they
be discarded? Should the problem column(s) be truncated?
Once you know how you want to deal with the problem, I suggest writing
a VIEW on the source system. The view should truncate the output (if
that is the choice), or skip the rows, whatever you have to do so the
output from the view matches the table on the target system. Then BCP
out from the view, rather than the table.
Roy Harvey
Beacon Falls, CT
On Thu, 27 Sep 2007 16:29:51 -0700, Hailin.Cai@.gmail.com wrote:
>Hi
>I want to use bcp tool to export a table from one machine to another
>machine. And now the export works fine. But when I want to import the
>text file generated by the export process to the target database, bcp
>reports an error, and the operation fails. The error is
>"Cannot sort a row of size 22416, which is greater than the allowable
>maximum of 8094."
>I think this error happens because my target table row size is too
>big. Because I can not change the schema of target table, I do not how
>to resolve it. Anybody can help me? Thanks.|||On Sep 28, 9:42 am, "Roy Harvey (SQL Server MVP)"
<roy_har...@.snet.net> wrote:
> If you are using Microsoft's BCP utility to extract the data from the
> source database, then I assume the source is SQL Server 2005 and is
> using something like VARCHAR(MAX) to allow row size greater than the
> normal limit.
> If the target table can not be changed you have to decide what is the
> proper thing to do with the rows that have the problem. Should they
> be discarded? Should the problem column(s) be truncated?
> Once you know how you want to deal with the problem, I suggest writing
> a VIEW on the source system. The view should truncate the output (if
> that is the choice), or skip the rows, whatever you have to do so the
> output from the view matches the table on the target system. Then BCP
> out from the view, rather than the table.
> Roy Harvey
> Beacon Falls, CT
>
> On Thu, 27 Sep 2007 16:29:51 -0700, Hailin...@.gmail.com wrote:
> >Hi
> >I want to use bcp tool to export a table from one machine to another
> >machine. And now the export works fine. But when I want to import the
> >text file generated by the export process to the target database, bcp
> >reports an error, and the operation fails. The error is
> >"Cannot sort a row of size 22416, which is greater than the allowable
> >maximum of 8094."
> >I think this error happens because my target table row size is too
> >big. Because I can not change the schema of target table, I do not how
> >to resolve it. Anybody can help me? Thanks.- Hide quoted text -
> - Show quoted text -
Thanks for your suggestion. I will try.

Help : "error: 40 - Could not open a connection to SQL Server"

I'm using VS2005 and SQL2000. I created a database name "myDatabase" inSQL Server 2000 and built a website that connet to this database. WhenI'm running this website in VS2005 IDE (press F5 or Ctrl-F5),everything is OK. I publiced this site. When I connect to database onmy computer, everything is OK also, but when I connect to database onanother computer, an error occurred like this :
"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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)"
Now, I don't know how to fix it. Pls help me as soon as possible.
Regards.
By default, SQL Server 2005 doesn't have TCP/IP connectivity enabled after installation. To enable TCP/IP connectivity, go to SQL Server Configuration Manager, select the Network Configuration Node, select TCP/IP and set it to Enabled. After enabling TCP/IP connectivity, you should be able to connect.|||

I'm getting the same error but when I try to access my SQL Database on my Web Hosts server. How do I enable TCP/IP on their server if I don't have access to it?

|||Is the username, password, database name, and address of the SQL server correct?

Help (error 17883, under sql 2000 sp4 US)

Hello,
I have this error:
http://support.microsoft.com/kb/909734/en-us
But microsoft france is close at this time and support say that they send me
a patch tomorrow, ...
If you have this magic patch you can send me (zipped) at:
ericg@.catalina-mkt.fr
Thanks for you help,
Best regards
EricOnly option is to have the server patched with the Hotfix by MS.
"Eric" wrote:

> Hello,
> I have this error:
> http://support.microsoft.com/kb/909734/en-us
> But microsoft france is close at this time and support say that they send
me
> a patch tomorrow, ...
> If you have this magic patch you can send me (zipped) at:
> ericg@.catalina-mkt.fr
> Thanks for you help,
> Best regards
> Eric

Help (error 17883, under sql 2000 sp4 US)

Hello,
I have this error:
http://support.microsoft.com/kb/909734/en-us
But microsoft france is close at this time and support say that they send me
a patch tomorrow, ... :(
If you have this magic patch you can send me (zipped) at:
ericg@.catalina-mkt.fr
Thanks for you help,
Best regards
EricOnly option is to have the server patched with the Hotfix by MS.
"Eric" wrote:
> Hello,
> I have this error:
> http://support.microsoft.com/kb/909734/en-us
> But microsoft france is close at this time and support say that they send me
> a patch tomorrow, ... :(
> If you have this magic patch you can send me (zipped) at:
> ericg@.catalina-mkt.fr
> Thanks for you help,
> Best regards
> Eric

HELP !Please . Urgent

after i done the replication from sql server 7.0(pub/dist) with sql server
2000(subscription) there will promt out the error like below :
Agents Last Action
Snapshot No such interface supported.NOTE:The step was retried
the
requested number of times(10)without succeeding.
The step failed.
Log Reader No such interface supported.NOTE:The step was retried
the
requested number of times(10)without succeeding.
The step failed.
202.168.xx:XXXXX No such interface supported.NOTE:The step was retried the
requested number of times(10)without succeeding.
The step failed.
ALL ERROR!!!!!
Please help...
thanks a lot
Sam,
are you doing merge replication by any chance - this configuration is not
supported.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||It sounds like your com components did not get registered. Did you apply an
sp recently? If so you should reapply it.
If not, is this relevant?
http://groups.google.com/group/microsoft.public.sqlserver.replication/msg/6252b9649b296145
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sam@.discussions.microsoft.com> wrote in message
news:F09CBB95-050E-4704-AEB0-4C8B0AE77809@.microsoft.com...
> after i done the replication from sql server 7.0(pub/dist) with sql server
> 2000(subscription) there will promt out the error like below :
> Agents Last Action
> Snapshot No such interface supported.NOTE:The step was
> retried
> the
> requested number of times(10)without succeeding.
> The step failed.
> Log Reader No such interface supported.NOTE:The step was retried
> the
> requested number of times(10)without succeeding.
> The step failed.
> 202.168.xx:XXXXX No such interface supported.NOTE:The step was retried
> the
> requested number of times(10)without succeeding.
> The step failed.
> ALL ERROR!!!!!
> Please help...
> thanks a lot
>
|||I doing transactional replication.
Thanks for your replied.
"Paul Ibison" wrote:

> Sam,
> are you doing merge replication by any chance - this configuration is not
> supported.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||OK - please see if this applies:
[url]http://groups.google.co.uk/group/microsoft.public.sqlserver.replication/browse_thread/thread/bdd1dfac50797c18/190e2af45971b1cb?lnk=st&q=No+such+interface+suppor ted+sql+server+replication&rnum=1&hl=en#190e2af459 71b1cb[/url]
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Help ! Error after (windows update) of .NET Framework

Hi all,
today i updated my .NET framework to 1.1 SP 1 (via windows update).
After than, my reporting services failed with the error key
"rsReportServerDisabled".
I have just a german full error message, but it is something with
"...decode symetric key ...". I use Win XP Professional as operating system.
Please apologize my english.
Thank your help in advance.
ThomasMost likely the ASP.NET account got reset. If you have the encryption key
saved, you can restore it using rskeymgmt. If not, you will need to reset
the encryption via rskeymgmt -d.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Thomas" <Thomas@.discussions.microsoft.com> wrote in message
news:D5EEE105-6F19-411C-A820-FBCE3940E699@.microsoft.com...
> Hi all,
> today i updated my .NET framework to 1.1 SP 1 (via windows update).
> After than, my reporting services failed with the error key
> "rsReportServerDisabled".
> I have just a german full error message, but it is something with
> "...decode symetric key ...". I use Win XP Professional as operating
> system.
> Please apologize my english.
> Thank your help in advance.
> Thomas
>
>|||I just tried it and you will probably also need to reconfigure the
connection string via rsconfig before you restore the encryption key.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:uCvrjDElEHA.3428@.TK2MSFTNGP14.phx.gbl...
> Most likely the ASP.NET account got reset. If you have the encryption key
> saved, you can restore it using rskeymgmt. If not, you will need to reset
> the encryption via rskeymgmt -d.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Thomas" <Thomas@.discussions.microsoft.com> wrote in message
> news:D5EEE105-6F19-411C-A820-FBCE3940E699@.microsoft.com...
>> Hi all,
>> today i updated my .NET framework to 1.1 SP 1 (via windows update).
>> After than, my reporting services failed with the error key
>> "rsReportServerDisabled".
>> I have just a german full error message, but it is something with
>> "...decode symetric key ...". I use Win XP Professional as operating
>> system.
>> Please apologize my english.
>> Thank your help in advance.
>> Thomas
>>
>>
>|||OK, one more correction. :) I was told by the developers that you won't need
to restore the encryption key. After resetting the connection string, you
just need to do an rsactivate -r -c and things will start working again.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ePMQzNFlEHA.3452@.TK2MSFTNGP15.phx.gbl...
>I just tried it and you will probably also need to reconfigure the
>connection string via rsconfig before you restore the encryption key.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:uCvrjDElEHA.3428@.TK2MSFTNGP14.phx.gbl...
>> Most likely the ASP.NET account got reset. If you have the encryption key
>> saved, you can restore it using rskeymgmt. If not, you will need to reset
>> the encryption via rskeymgmt -d.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Thomas" <Thomas@.discussions.microsoft.com> wrote in message
>> news:D5EEE105-6F19-411C-A820-FBCE3940E699@.microsoft.com...
>> Hi all,
>> today i updated my .NET framework to 1.1 SP 1 (via windows update).
>> After than, my reporting services failed with the error key
>> "rsReportServerDisabled".
>> I have just a german full error message, but it is something with
>> "...decode symetric key ...". I use Win XP Professional as operating
>> system.
>> Please apologize my english.
>> Thank your help in advance.
>> Thomas
>>
>>
>>
>|||Thank you Brian !
I will try it at once...
Best regards from Germany
Thomas
"Brian Welcker [MSFT]" wrote:
> OK, one more correction. :) I was told by the developers that you won't need
> to restore the encryption key. After resetting the connection string, you
> just need to do an rsactivate -r -c and things will start working again.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:ePMQzNFlEHA.3452@.TK2MSFTNGP15.phx.gbl...
> >I just tried it and you will probably also need to reconfigure the
> >connection string via rsconfig before you restore the encryption key.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:uCvrjDElEHA.3428@.TK2MSFTNGP14.phx.gbl...
> >> Most likely the ASP.NET account got reset. If you have the encryption key
> >> saved, you can restore it using rskeymgmt. If not, you will need to reset
> >> the encryption via rskeymgmt -d.
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "Thomas" <Thomas@.discussions.microsoft.com> wrote in message
> >> news:D5EEE105-6F19-411C-A820-FBCE3940E699@.microsoft.com...
> >> Hi all,
> >> today i updated my .NET framework to 1.1 SP 1 (via windows update).
> >> After than, my reporting services failed with the error key
> >> "rsReportServerDisabled".
> >> I have just a german full error message, but it is something with
> >> "...decode symetric key ...". I use Win XP Professional as operating
> >> system.
> >> Please apologize my english.
> >>
> >> Thank your help in advance.
> >> Thomas
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>