Error running report: March 2012

Thursday, March 29, 2012

Error when using SSL encryption for SQL server 2000

Hi,
I am having trouble connecting to SQL server 2000 using SSL.
My environment is as follows:
1. Microsoft Certificate server running on a Windows 2000 server machine.
2. SQL Server 2000 running on a Win NT machine with SP6 installed. SQL
Server service pack 3a has been installed.
3. Client machine running Windows XP with SQL Server service pack 3a
installed.
We use a type 4 JDBC secure driver to connect to SQL server from our Java ap
plication running on the client machine.
We also setup the certificate as described in the article 276553 - HOW TO: E
nable SSL Encryption for SQL Server 2000 with Certificate Server.
The installation of the certificate was successful. However, when I tried to
connect to the SQL server using SQL Query Analyzer, I received the followin
g error message.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Encryption not supported on SQL Serv
er
Thanks,
Chacko.Usually, you receive that error if you enable SSL from the client and the
server doesn't have the certificate.
But, the bad news is you won't be able to use SSL with a type 4 Java driver.
The implementation of protocol encryption requires the driver to access
SSL. In
particular protocol encryption uses SSL APIs implemented in NT. Type 4 JDBC
drivers have a problem in that they are not allowed to directly call system
dlls. There is no library in Java 1.4 or below that emulates the protocol
encryption behavior of SSL from Windows NT.
If your JDBC application requires protocol encryption to SQL 2000,
you will have to use alternate method of encryption such as IPSEC or use a
suitable SSL enabled Type 3 JDBC Driver.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Kevin,
Thanks for your response.
We did generate and install the certificate using the web browser and not us
ing MMC since it is a Win NT 4.0 box. When we look at the certificate on the
database server machine via the IE properties applet, the certificate shows
up fine as described in th
e Microsoft setup document. So, I am not sure where I am going wrong. Is the
re any way to trouble shoot this issue?
Also, we are not even trying the connectivity with the type 4 JDBC driver ye
t even though that is what we want to do ultimately. However, right now we a
re using Query Analyzer on the client machine to test the communication. We
get the error when we try a
nd login to the database via Query Analyzer.
About the type 4 JDBC driver, the documentation from i-net OPTA type 4 JDBC driver says
that it supports SSL for SQL Server 2000. Am I misunderstanding something here? You ca
n find information about i-net OPTA at [url]http://www.inetsoftware.de/English/Produkt[
/url]
e/OPTA/default.htm
Your thoughts are greatly appreciated.
Thanks Kevin.
Chacko.

Error when using SQL Import / Export Wizard

I am attempting to import data from an access db using the wizard and I get the following error when the wizard attempts to save.

- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
- Saving (Error)
Messages
* Error 0xc0208220: Data Flow Task: Unable to save to XML.
(SQL Server Import and Export Wizard)

Does anyone have any ideas about how to correct this?

Without out more information I would have to say that the error is occurring because the path is non-existant, the account running the package does not have permissions to the path, or the file connection manager was set up to use an existing file and one is not there, or to create a file and one of that name already exists.sql

Error when using SP in data flow

I want to execute a stored procedure in an OLE DB source in a Data Flow Task.

The stored procedure has a parameter.

When I put in an SQL command as :

EXEC sp_readcustomers 1

(thus passing 1 as the parameter value I can use the Preview button and I get a list of columns being returned.

The data flow task should run inside a ForEach Loop where I assign the value of an ADO resultset to a variable and it is this variable I want to pass to the SP :

EXEC sp_readcustomers ?

In the Parameter mapping I then name the parameter @.par_company_id (which is the exact same name as in the SP) and map it to the variable var_company_id.

@.par_company_id has been declared as int, var_company_id as Int16

When I now try to Parse or Preview the query from the OLE DB Source Edit window I get the following errors :

Parse : Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Preview : No value given for one or more required parameters (Microsoft SQL Native Client)

I have already installed SQL 2005 SP2 and VS2005 SP1.

I have tried everything I know, please help ?!?!

Have you tried putting the SQL Statment in a variable? You can parametrized queries using expressions in variables; then the source component will get the sql statemnt from the variable. There are a lot of example on this forum.|||

I have tried that.

I created a variable, set EvaluateAsExpression to True and entered the select statement as an expression.

Problem is that I can't select the variable, it is in the correct scope but it doesn't show up in the drop-down list of the OLE DB Source.

When you look at the documentation (Books online, etc. ...) I'm using the correct method to pass parameters to a stored procedure, is this a bug in VS/SQL ?

|||

Ronald Dirkx wrote:

I have tried that.

I created a variable, set EvaluateAsExpression to True and entered the select statement as an expression.

Problem is that I can't select the variable, it is in the correct scope but it doesn't show up in the drop-down list of the OLE DB Source.

When you look at the documentation (Books online, etc. ...) I'm using the correct method to pass parameters to a stored procedure, is this a bug in VS/SQL ?

To use the variable in an OLE DB Source, select the data access mode of "SQL command from variable." Then your variable will show up in the drop down.

Error when using rskeymgmt to backup encryption key

When I run the rskeymgmt program to backup the encryption key, I get the
following error:
The Report Server Windows service is not responding to RPC requests. The
service may not be running.
I have checked, and the service is running. We are using SQL Server 2005
sp2. The command I am using is:
rskeymgmt -e -fc:\rskey\rsdbkey.txt -psomepassword
Any ideas why this is failing. I was able to run the program some time ago.
Thanks.On May 2, 11:50 am, "Tim Kelley" <tkel...@.company.com> wrote:
> When I run the rskeymgmt program to backup the encryption key, I get the
> following error:
> The Report Server Windows service is not responding to RPC requests. The
> service may not be running.
> I have checked, and the service is running. We are using SQL Server 2005
> sp2. The command I am using is:
> rskeymgmt -e -fc:\rskey\rsdbkey.txt -psomepassword
> Any ideas why this is failing. I was able to run the program some time ago.
> Thanks.
This link might be helpful:
http://www.technologyone.org/new-6210113-3731.html
Regards,
Enrique Martinez
Sr. Software Consultant

Error when using rsconfig utility

When i try to use the rsconfig utility to add the values to the

The WMI Provider returned an error: HRESULT=0x8004021D

I too am getting this error. Has any resolution been found?

Error when using rsconfig utility

When i try to use the rsconfig utility to add the values to the

The WMI Provider returned an error: HRESULT=0x8004021D

I too am getting this error. Has any resolution been found?

Error when using more then one comment

Helo,
I=B4ve two comments and between them i put some code, but=20
when i execute Query Analyser show the following error
"Server: Msg 113, Level 15, State 1, Line 40
Missing end comment mark '*/'.
Server: Msg 170, Level 15, State 1, Line 34
Line 34: Incorrect syntax near '/'."
If i execute the code with the first comment it executes=20
without any error but if i try to execute evrything it=20
shows me the error
When was created the second comment i've done it like in=20
the first part of code, this is not a problem but i dont=20
know why SQL shows this message to me!!!
Best regards
Sounds like you have a 'go' in the middle of a multi line comment... Query
Analyzer behaves poorly when this occurs... Use a single line comment -- to
comment out the go statement.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1c03b01c42143$7e978080$a101280a@.phx.gbl...
Helo,
Ive two comments and between them i put some code, but
when i execute Query Analyser show the following error
"Server: Msg 113, Level 15, State 1, Line 40
Missing end comment mark '*/'.
Server: Msg 170, Level 15, State 1, Line 34
Line 34: Incorrect syntax near '/'."
If i execute the code with the first comment it executes
without any error but if i try to execute evrything it
shows me the error
When was created the second comment i've done it like in
the first part of code, this is not a problem but i dont
know why SQL shows this message to me!!!
Best regards
|||Thanks Wayne, you're right
Best regards

>--Original Message--
>Sounds like you have a 'go' in the middle of a multi line=20
comment... Query
>Analyzer behaves poorly when this occurs... Use a single=20
line comment -- to
>comment out the go statement.
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in=20
message
>news:1c03b01c42143$7e978080$a101280a@.phx.gbl...
>Helo,
>I=B4ve two comments and between them i put some code, but
>when i execute Query Analyser show the following error
>"Server: Msg 113, Level 15, State 1, Line 40
>Missing end comment mark '*/'.
>Server: Msg 170, Level 15, State 1, Line 34
>Line 34: Incorrect syntax near '/'."
>If i execute the code with the first comment it executes
>without any error but if i try to execute evrything it
>shows me the error
>When was created the second comment i've done it like in
>the first part of code, this is not a problem but i dont
>know why SQL shows this message to me!!!
>Best regards
>
>.
>
sql

Error when using more then one comment

Helo,
I=B4ve two comments and between them i put some code, but=20
when i execute Query Analyser show the following error
"Server: Msg 113, Level 15, State 1, Line 40
Missing end comment mark '*/'.
Server: Msg 170, Level 15, State 1, Line 34
Line 34: Incorrect syntax near '/'."
If i execute the code with the first comment it executes=20
without any error but if i try to execute evrything it=20
shows me the error
When was created the second comment i've done it like in=20
the first part of code, this is not a problem but i dont=20
know why SQL shows this message to me!!!
Best regardsSounds like you have a 'go' in the middle of a multi line comment... Query
Analyzer behaves poorly when this occurs... Use a single line comment -- to
comment out the go statement.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1c03b01c42143$7e978080$a101280a@.phx
.gbl...
Helo,
Ive two comments and between them i put some code, but
when i execute Query Analyser show the following error
"Server: Msg 113, Level 15, State 1, Line 40
Missing end comment mark '*/'.
Server: Msg 170, Level 15, State 1, Line 34
Line 34: Incorrect syntax near '/'."
If i execute the code with the first comment it executes
without any error but if i try to execute evrything it
shows me the error
When was created the second comment i've done it like in
the first part of code, this is not a problem but i dont
know why SQL shows this message to me!!!
Best regards|||Thanks Wayne, you're right
Best regards

>--Original Message--
>Sounds like you have a 'go' in the middle of a multi line=20
comment... Query
>Analyzer behaves poorly when this occurs... Use a single=20
line comment -- to
>comment out the go statement.
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in=20
message
> news:1c03b01c42143$7e978080$a101280a@.phx
.gbl...
>Helo,
>I=B4ve two comments and between them i put some code, but
>when i execute Query Analyser show the following error
>"Server: Msg 113, Level 15, State 1, Line 40
>Missing end comment mark '*/'.
>Server: Msg 170, Level 15, State 1, Line 34
>Line 34: Incorrect syntax near '/'."
>If i execute the code with the first comment it executes
>without any error but if i try to execute evrything it
>shows me the error
>When was created the second comment i've done it like in
>the first part of code, this is not a problem but i dont
>know why SQL shows this message to me!!!
>Best regards
>
>.
>

Error when using more then one comment

Helo,
I=B4ve two comments and between them i put some code, but when i execute Query Analyser show the following error
"Server: Msg 113, Level 15, State 1, Line 40
Missing end comment mark '*/'.
Server: Msg 170, Level 15, State 1, Line 34
Line 34: Incorrect syntax near '/'."
If i execute the code with the first comment it executes without any error but if i try to execute evrything it shows me the error
When was created the second comment i've done it like in the first part of code, this is not a problem but i dont know why SQL shows this message to me!!!
Best regardsSounds like you have a 'go' in the middle of a multi line comment... Query
Analyzer behaves poorly when this occurs... Use a single line comment -- to
comment out the go statement.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1c03b01c42143$7e978080$a101280a@.phx.gbl...
Helo,
I´ve two comments and between them i put some code, but
when i execute Query Analyser show the following error
"Server: Msg 113, Level 15, State 1, Line 40
Missing end comment mark '*/'.
Server: Msg 170, Level 15, State 1, Line 34
Line 34: Incorrect syntax near '/'."
If i execute the code with the first comment it executes
without any error but if i try to execute evrything it
shows me the error
When was created the second comment i've done it like in
the first part of code, this is not a problem but i dont
know why SQL shows this message to me!!!
Best regards|||Thanks Wayne, you're right
Best regards
>--Original Message--
>Sounds like you have a 'go' in the middle of a multi line comment... Query
>Analyzer behaves poorly when this occurs... Use a single line comment -- to
>comment out the go statement.
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
>news:1c03b01c42143$7e978080$a101280a@.phx.gbl...
>Helo,
>I=B4ve two comments and between them i put some code, but
>when i execute Query Analyser show the following error
>"Server: Msg 113, Level 15, State 1, Line 40
>Missing end comment mark '*/'.
>Server: Msg 170, Level 15, State 1, Line 34
>Line 34: Incorrect syntax near '/'."
>If i execute the code with the first comment it executes
>without any error but if i try to execute evrything it
>shows me the error
>When was created the second comment i've done it like in
>the first part of code, this is not a problem but i dont
>know why SQL shows this message to me!!!
>Best regards
>
>.
>

Error when using 'LIKE'

I am running the following query using Query Analyzer against an MSDE version. The query seems like a textbook use of 'LIKE', so the error makes to sense to me. Thanks for any help.

SELECT _FAX

FROM _IRISH_BNB_DETAILS

WHERE _FAX LIKE "[A-Z]%"

Error:

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name '[A-Z]%'.

Try executing:

SET QUOTED_IDENTIFIER OFF

Dave

|||

In SQL, use the single quote character to delimit strings, so:

LIKE '[A-Z]%'

instead of

LIKE "[A-Z]%"

Double quotes are used to allow for quoted identifiers, so it is thinking that "[A-Z]%" is a column name

|||

Thank you!

I was following an example in "SQL Server 2000 Administrator Companion" on page 309 that uses double quotes.

|||

Sorry, my answer is too short. Try this:

SET QUOTED_IDENTIFIER OFF
SELECT _FAX
FROM _IRISH_BNB_DETAILS
WHERE _FAX LIKE "[A-Z]%"

SET QUOTED_IDENTIFIER ON

and then try this:

SELECT _FAX
FROM _IRISH_BNB_DETAILS
WHERE _FAX LIKE '[A-Z]%'

You are really better changing your literal, that is "[A-Z]%" into a single quote delimited literal for the sake of ANSI compliance; however, an alternative is to set QUOTED_IDENTIFIER on so that the original code can work as is.

Dave

|||Yeah, Louis answered before I could correct myself. Sorry about that.|||Yeah, and you answered while I was answering :)|||

Hey, it was a typing war! You won!

:-)

error when using IIF with sum()

I have a field I need to have a count for, which is fine, but if that count is equal to nothing I don't want anything to print out in that textbox.

It works if the count is equal to nothing BUT if the count has a value I get an error message.

My logis is
if count = "" then print nothin else print the count

=iif( Sum(Fields!delStatusCount.Value, "dsDelStatusCount") = "", "", "DEL = " & Sum(Fields!delStatusCount.Value, "dsDelStatusCount"))

Thanks

The function sum will return a value. So you can not compare with a string ("") try to replace the string of just =iif(sum(x), x, "").

|||

You can also explicitly state it like:

=IIF(ISEMPTY(sum(x)), x, "")

Error when using a stored procedure in OLE DB source

I am trying to use a stored procedure in the OLE DB source, I am using the SQL Command for the Data Access mode. It returns values when using the preview but when I test the package I receive the error, "A rowset based on the SQL command was not returned by the OLE DB provider."how is the ole db source configured?|||For the the connection manager I just have a basic connection to the Sql server and then I am using the SQL command for the data access mode. The connection manager does work when I use other access modes like the table and view option.|||how is the connection manager configured? you may need to use a different configuration.|||ConnectionManagerType = OLEDB
Data Source = ABCSERVER;Initial Catalog=ABCDATABASE;Provider=SQLNCLI.1;OLE DB Services=-13;Integrated Security=SSPI;Auto Translate=True;
DataSourceID =
DelayValidation = False
Description =
RetainSameConnection = False
SupportsDTCTransactions = True|||

DustinT wrote:
ConnectionManagerType = OLEDB
Data Source = ABCSERVER;Initial Catalog=ABCDATABASE;Provider=SQLNCLI.1;OLE DB Services=-13;Integrated Security=SSPI;Auto Translate=True;
DataSourceID =
DelayValidation = False
Description =
RetainSameConnection = False
SupportsDTCTransactions = True

if i'm not mistaken, the sql native client provider (SQLNCLI.1) only works with sql server 2005.

if you are using a different version of sql server, then try using the microsoft ole db provider for sql server (SQLOLEDB.1)

|||See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=366077&SiteID=1

error when using "Referenced" dimension usage against an oracle data source

Hi All,

I've built a cube using a data source and DSV that point to an Oracle 10g database. I am able to process this cube so long as the dimensions are all related to the main fact table using regular dimension usage. The problem I'm having arises when the dimension has to have "referenced" usage through an intermediate dimension. In this case, when the cube processes, the SQL that gets generated and run looks akin to the following:

SELECT [CstOrds].[CstOrdsDISCOUNT0_0] AS [CstOrdsDISCOUNT0_0],[CstOrds].[CstOrdsBUY_QTY_DUE0_1] AS [CstOrdsBUY_QTY_DUE0_1],[CstOrds].[CstOrdsDESIRED_QTY0_2] AS [CstOrdsDESIRED_QTY0_2],[CstOrds].[CstOrdsQTY_ASSIGNED0_3] AS [CstOrdsQTY_ASSIGNED0_3],[CstOrds].[CstOrdsQTY_ON_ORDER0_4] AS [CstOrdsQTY_ON_ORDER0_4],[CstOrds].[CstOrdsQTY_PICKED0_5] AS [CstOrdsQTY_PICKED0_5],[CstOrds].[CstOrdsQTY_RETURNED0_6] AS [CstOrdsQTY_RETURNED0_6],[CstOrds].[CstOrdsQTY_SHORT0_7] AS [CstOrdsQTY_SHORT0_7],[CstOrds].[CstOrdsQTY_TO_SHIP0_8] AS [CstOrdsQTY_TO_SHIP0_8],[CstOrds].[CstOrdsQTY_SHIPPED0_9] AS [CstOrdsQTY_SHIPPED0_9],[CstOrds].[CstOrdsQTY_SHIPDIFF0_10] AS [CstOrdsQTY_SHIPDIFF0_10],[CstOrds].[CstOrdsQTY_INVOICED0_11] AS [CstOrdsQTY_INVOICED0_11],[CstOrds].[CstOrdsCOST0_12] AS [CstOrdsCOST0_12],[CstOrds].[CstOrdsNET_AMOUNT0_13] AS [CstOrdsNET_AMOUNT0_13],[CstOrds].[CstOrdsGROSS_AMOUNT0_14] AS [CstOrdsGROSS_AMOUNT0_14],[CstOrds].[CstOrdsSPTA0_15] AS [CstOrdsSPTA0_15],[CstOrds].[CstOrdsTCA0_16] AS [CstOrdsTCA0_16],[CstOrds].[CstOrds0_17] AS [CstOrds0_17],[CstOrds].[CstOrdsCUSTOMER_NO0_18] AS [CstOrdsCUSTOMER_NO0_18],[CstOrds].[CstOrdsINVOICE_DATE0_19] AS [CstOrdsINVOICE_DATE0_19],[CstOrds].[CstOrdsREAL_SHIP_DATE0_20] AS [CstOrdsREAL_SHIP_DATE0_20],[CstOrds].[CstOrdsPDDNT0_21] AS [CstOrdsPDDNT0_21],[CstOrds].[CstOrdsDENT0_22] AS [CstOrdsDENT0_22],[CstOrds].[CstOrdsORDER_NO0_23] AS [CstOrdsORDER_NO0_23],[CstOrds].[CstOrdsLINE_NO0_24] AS [CstOrdsLINE_NO0_24],[CstOrds].[CstOrdsREL_NO0_25] AS [CstOrdsREL_NO0_25],[CstOrds].[CstOrdsCATALOG_NO0_26] AS [CstOrdsCATALOG_NO0_26],[sPart_8].[PART_NO] AS [sPartPART_NO2_0]

FROM

OPENROWSET

(

N'OraOLEDB.Oracle',

N'detest';N'bi';N'',

SELECT "DISCOUNT" "CstOrdsDISCOUNT0_0","BUY_QTY_DUE" "CstOrdsBUY_QTY_DUE0_1","DESIRED_QTY" "CstOrdsDESIRED_QTY0_2","QTY_ASSIGNED" "CstOrdsQTY_ASSIGNED0_3","QTY_ON_ORDER" "CstOrdsQTY_ON_ORDER0_4","QTY_PICKED" "CstOrdsQTY_PICKED0_5","QTY_RETURNED" "CstOrdsQTY_RETURNED0_6","QTY_SHORT" "CstOrdsQTY_SHORT0_7","QTY_TO_SHIP" "CstOrdsQTY_TO_SHIP0_8","QTY_SHIPPED" "CstOrdsQTY_SHIPPED0_9","QTY_SHIPDIFF" "CstOrdsQTY_SHIPDIFF0_10","QTY_INVOICED" "CstOrdsQTY_INVOICED0_11","COST" "CstOrdsCOST0_12","NET_AMOUNT" "CstOrdsNET_AMOUNT0_13","GROSS_AMOUNT" "CstOrdsGROSS_AMOUNT0_14","SALES_PRICE_TOTAL_API" "CstOrdsSPTA0_15","TOTAL_COST_API" "CstOrdsTCA0_16",1 "CstOrds0_17","CUSTOMER_NO" "CstOrdsCUSTOMER_NO0_18","INVOICE_DATE" "CstOrdsINVOICE_DATE0_19","REAL_SHIP_DATE" "CstOrdsREAL_SHIP_DATE0_20","PROMISED_DELIVERY_DATE_NO_TIME" "CstOrdsPDDNT0_21","DATE_ENTERED_NO_TIME" "CstOrdsDENT0_22","ORDER_NO" "CstOrdsORDER_NO0_23","LINE_NO" "CstOrdsLINE_NO0_24","REL_NO" "CstOrdsREL_NO0_25","CATALOG_NO" "CstOrdsCATALOG_NO0_26"

FROM "IAL"."BP_BI_CUSTOMER_ORDER_LINE"'

)

AS [CstOrds],

OPENROWSET

(

N'OraOLEDB.Oracle',

N'detest';N'bi';N'',

N'"IAL"."SALES_PART"'

)

AS [sPart_8]

WHERE

(

[CstOrds].[CstOrdsCATALOG_NO0_26] = [sPart_8].[CATALOG_NO]

)

The error that is returned when I run the query from SQL Server Management Studio is as follows:

Msg 7357, Level 16, State 2, Line 1

Cannot process the object ""IAL"."SALES_PART"". The OLE DB provider "OraOLEDB.Oracle" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.

Note that it seems to attempt to query the table behind the referenced dimension (SALES_PART) by simply opening the table, rather than selecting something specific from it. Unfortunately this doesn't work when processing the cube, nor does it work when I paste the same query into SQL Server Management Studio. However if I modify it a little to use

N'select * from "IAL"."SALES_PART"'

instead of just

N'"IAL"."SALES_PART"'

then it runs no problem. Is there any way to control the SQL that Analysis services produces to process the cube, or is there some other way to resolve this problem so I can include dimensions with "referenced" usage? (Note that I've tried with both the Microsoft and the Oracle OLEDB providers, in both cases the behaviour & error were the same)

Thanks in advance.

Kind regards,

Miles

Miles, do you have multiple data sources involved here?

What appears to be happening is that the server detects a remote data source for the intermediate dimension and has to use remote queries to join the results together.

Some choices would be:

- Avoid the need for the remote query if possible (this would improve performance). If all your data is really coming from the same data source, then maybe something has just been improperly configured and is incorrectly causing a remote query.

- Create a linked server between the SQL Server and the Oracle server and then point to the SQL Server as the source of the tables in the DSV. This would mean credentials from the SQL Server to the Oracle server would be saved as part of the linked server.

- Change the referenced dimension to be unmaterialized (there is a check box in the dimension usage dialog for referenced dimensions). This would mean that query performance might be impacted because the join between the two dimensions would have to be done at query time instead of during processing.

- Perhaps you can change the table in the DSV to look like SELECT * FROM "IAL"."SALES_PART"

HTH,

Akshai

|||

Hi Akshai,

You're absolutely right that there were 2 data sources involved. The eventual solution was to make the primary data source for my DSV the oracle one, and then it all started behaving itself properly. As you rightly pointed out, it was doing an unnecessary remote query, tunnelling the requests to Oracle through SQL server leading to all kinds of problems. When the queries go directly to oracle, it all works fine. Thanks for the reply :)

Kind regards,

Miles

error when using "Referenced" dimension usage against an oracle data source

Hi All,

FROM

OPENROWSET

(

N'OraOLEDB.Oracle',

N'detest';N'bi';N'',

FROM "IAL"."BP_BI_CUSTOMER_ORDER_LINE"'

)

AS [CstOrds],

OPENROWSET

(

N'OraOLEDB.Oracle',

N'detest';N'bi';N'',

N'"IAL"."SALES_PART"'

)

AS [sPart_8]

WHERE

(

[CstOrds].[CstOrdsCATALOG_NO0_26] = [sPart_8].[CATALOG_NO]

)

The error that is returned when I run the query from SQL Server Management Studio is as follows:

Msg 7357, Level 16, State 2, Line 1

N'select * from "IAL"."SALES_PART"'

instead of just

N'"IAL"."SALES_PART"'

Thanks in advance.

Kind regards,

Miles

Miles, do you have multiple data sources involved here?

What appears to be happening is that the server detects a remote data source for the intermediate dimension and has to use remote queries to join the results together.

Some choices would be:

- Perhaps you can change the table in the DSV to look like SELECT * FROM "IAL"."SALES_PART"

HTH,

Akshai

|||

Hi Akshai,

Kind regards,

Miles

Error when upsizing Access 2K Database

When I try to upsize an Access 2K database, I get the following two errors,
one after the other:
SQL Server does no exist or access denied.
The Upsizing Wizard only works with MS SQL Server (Versions 6.50 SP5 or
higher). Please log onto a SQL Server data source.
I doesn't matter whether I login as 'sa' or use a trusted connection, create
a new database or use an existing one, or use '(local)' or the name of my
computer as the server name. If trying to use an existing database, I am
using a File Data Source that appears to work just fine elswhere (test
connection returns success, and I can import/link tables in an Access
database). I have read the KB article that says to use a file DS, but that
hasn't helped. I have even tried a machine DS, but same errors.
I am the dbo of the existing database, and I and the sa account should have
database create priviliges. I can create databases and tables in SQL
Enterprise manager just fine.
I get these same two errors if I try to create a new adp file and selecting
New Database. I am using XPPro and Office XP Developer Edition.
Thanks.You might find this page helpful troubleshooting the upwiz:
http://office.microsoft.com/en-us/a...0894261033.aspx
FWIW, the upsizing wizard does not do a very good job of migrating
from Access/Jet to SQL Server even when it does work. It creates an
unholy mess of triggers, views and inefficient data type conversions.
You'd be better off recreating the schema in SQL Server to take
advantage of SQLS features like constraints and stored procedures, and
then migrate the data using DTS or even queries from linked tables.
--Mary
On Fri, 15 Oct 2004 13:21:06 -0700, "Fred Yarvin" <Fred
Yarvin@.discussions.microsoft.com> wrote:

>When I try to upsize an Access 2K database, I get the following two errors,
>one after the other:
>SQL Server does no exist or access denied.
>The Upsizing Wizard only works with MS SQL Server (Versions 6.50 SP5 or
>higher). Please log onto a SQL Server data source.
>I doesn't matter whether I login as 'sa' or use a trusted connection, creat
e
>a new database or use an existing one, or use '(local)' or the name of my
>computer as the server name. If trying to use an existing database, I am
>using a File Data Source that appears to work just fine elswhere (test
>connection returns success, and I can import/link tables in an Access
>database). I have read the KB article that says to use a file DS, but that
>hasn't helped. I have even tried a machine DS, but same errors.
>I am the dbo of the existing database, and I and the sa account should have
>database create priviliges. I can create databases and tables in SQL
>Enterprise manager just fine.
>I get these same two errors if I try to create a new adp file and selecting
>New Database. I am using XPPro and Office XP Developer Edition.
>Thanks.

Error when updating database

Hi all,
I'm getting an error when updating my database. The connection is fine and the dropdown menu is good also so i think it's the way i've formed my sql string. Here's the line i think i'm having probs with:

SQLString = "UPDATE project_descriptions SET " & _
"lecturer_name = '" & Replace(LecturerName.Text,"'","''") & "'," & _
"project_title = '" & Replace(ProjectTitle.Text,"'","''") & "', " & _
"Project_description = '" & Replace(ProjectDescription.Text,"'","''") & "'," & _
" WHERE project_code = '" & ProjectCode.SelectedItem.Value & "'"

Can anyone rearrange it so i stop getting an error?

Here's my code. if it helps.

<%@. Import Namespace="System.Data.OleDb" %
<SCRIPT language="VB" runat="server"
Dim DBConnection As OleDbConnection
Dim DBCommand As OleDbCommand
Dim DBReader As OleDbDataReader
Dim SQLString As String

Sub Page_Load

If Not Page.IsPostBack Then

'-- Load drop-down list with item numbers
DBConnection = New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\finalyearproject2\projectallocation.mdb")
DBConnection.Open()
SQLString = "SELECT project_code FROM project_descriptions ORDER BY project_code"
DBCommand = New OleDbCommand(SQLString, DBConnection)
DBReader = DBCommand.ExecuteReader()
ProjectCode.DataSource = DBReader
ProjectCode.DataTextField = "project_code"
ProjectCode.DataValueField = "project_code"
ProjectCode.DataBind()
DBReader.Close()
DBConnection.Close()

End If

End Sub

Sub SelectRecord (Src As Object, Args As EventArgs)

DBConnection = New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\finalyearproject2\projectallocation.mdb")
DBConnection.Open()
SQLString = "SELECT * FROM project_descriptions WHERE " & _
"project_code = '" & ProjectCode.SelectedItem.Value & "'"
DBCommand = New OleDbCommand(SQLString, DBConnection)
DBReader = DBCommand.ExecuteReader()
DBReader.Read()
LecturerName.Text = DBReader("lecturer_name")
ProjectTitle.Text = DBReader("project_title")
ProjectDescription.Text = DBReader("project_description")
DBReader.Close()
DBConnection.Close()
UpdateButton.Visible = True

End Sub

Sub UpdateRecord (Src As Object, Args As EventArgs)

'-- CHECK FOR VALID RECORD --
Dim ValidRecord As Boolean = True

'-- Check for missing Project Title
If ProjectTitle.Text = "" Then
ProjectTitleMessage.Text = "Missing Project Title"
ValidRecord = False
End If

'-- Check for missing Lecturer Name
If LecturerName.Text = "" Then
LecturerNameMessage.Text = "Missing Lecturer Name"
ValidRecord = False
End If

'-- Check for missing Project Description
If ProjectDescription.Text = "" Then
ProjectDescriptionMessage.Text = "Missing Project Description"
ValidRecord = False
End If

If ValidRecord = True Then

'-- UPDATE A RECORD --
Try
DBConnection = New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\finalyearproject2\projectallocation.mdb")
DBConnection.Open()

SQLString = "UPDATE project_descriptions SET " "lecturer_name = '" & Replace(LecturerName.Text,"'","''") & "'," "project_title = '" & Replace(ProjectTitle.Text,"'","''") & "', " "Project_description = '" & Replace(ProjectDescription.Text,"'","''") & "'," " WHERE project_code = '" & ProjectCode.SelectedItem.Value & "'"
DBCommand = New OleDbCommand(SQLString, DBConnection)
DBCommand.ExecuteNonQuery
DBConnection.Close()
UpdateMessage.Text = "Record updated"
Catch
UpdateMessage.Text = "Update problem. Record not changed. " & SQLString
End Try

End If

End Sub

</SCRIPT
<html>
<head
<style>
.head {font-family:arial; font-size:12pt; font-weight:bold; width:560px;
border:outset 1 #F0F0F0; padding:2pt; background-color:#990000;
color:#FFFFFF; text-align:center}
.box {font-family:arial; font-size:8pt; line-height:9pt; width:200px;
height:20px; overflow:auto}
.right {text-align:right}
.center {text-align:center}
table {font-family:arial; font-size:8pt; line-height:9pt; width:560px;
background-color:#F9F9F9; border-collapse:collapse}
th {font-family:arial; font-size:8pt; line-height:14pt;
font-weight:bold; text-align:center; vertical-align:bottom;
background-color:#990000; color:#FFFFFF}
td {font-family:arial; font-size:8pt; line-height:9pt;
vertical-align:top}
</style>
</head
<body>
<form runat="server"
<div class="head">Project Update</div
<table id="UpdateTable" border="1" rules="rows">
<tr>
<th> Project Code: </th>
<td><asp:DropDownList id="ProjectCode" runat="server"/>
<asp:Button Text="Select" OnClick="SelectRecord" runat="server"/>
</td>
<td></td>
</tr>
<tr>
<th> Lecturer Name: </th>
<td><asp:TextBox id="LecturerName" runat="server"
Columns="40"
MaxLength="50"/></td>
<td><asp:Label id="LecturerNameMessage" runat="server"
ForeColor="#FF0000"
EnableViewState="False"/></td>
</tr
<tr>
<th> Project Title: </th>
<td><asp:TextBox id="ProjectTitle" runat="server"
Columns="40"
MaxLength="50"/></td>
<td><asp:Label id="ProjectTitleMessage" runat="server"
ForeColor="#FF0000"
EnableViewState="False"/></td>
</tr
<tr>
<th> Project Description: </th>
<td><asp:TextBox id="ProjectDescription" runat="server"
TextMode="MultiLine"
Columns="45"
rows="3"/></td>
<td><asp:Label id="ProjectDescriptionMessage" runat="server"
ForeColor="#FF0000"
EnableViewState="False"/></td>
</tr
</asp:Panel
</table>
<br>
<asp:Button id="UpdateButton" runat="server"
Text="Update Record"
Visible="False"
OnClick="UpdateRecord"/>
<asp:Label id="UpdateMessage" runat="server"
ForeColor="#FF0000"
EnableViewState="False"/>
</form>
</body>
</html>Please, please use parameterized SQL statements, not SQL statements concatenated together with user-supplied data!! What you have now is exposing your application/server/network to SQL injection attacks.

See theServer Side Data Access QuickStart Tutorial, in particularInserting Data in a SQL Database. The techniques used here should be directly applicable to your situation.

Terri|||Thanks for the reply Terri, but in this case I have to do it this way (long story). Any ideas?|||You should post exact error messages -- these go a long way to solving the problem. I am reasonably sure the problem is that you have a comma before your WHERE.

It would be interesting to know why you have to do it this way. It is an ill-advised practice and I have to strongly urge you to use parameters instead.

Terri|||Got it workin, thanks a lot!!! This method is for an assignment. We have to do it both ways. Thanks againsql

Error when updating bigint columns using ADO

I am attempting to write a conversion of our product for Compact Edition; we already provide it based on SQL Server. The database interface uses ADO through a Python-win32com adaptor, and has worked fine so far. (Note: *not* ADO.net, just plain old COM)

Now, a curious thing happens. When inserting new data through a Recordset, everything works fine - except for columns defined as bigint. There are no exceptions thrown, but when you read the columns back they contain nothing but zeroes. Do the same to any other column type - I've tried integer, numeric, float, nvarchar and ntext so far, and they all seem to work just fine. It does not seem to be conversion-related either, since I've tested the exact same data to various column types. And using bigint on regular SQL Server works just fine.

The code involved is quite unspectacular, and simply switching the column types to integer would solve the immediate problem, but causes potential future issues since we normally store internal IDs in bigint columns, and the values may grow quite large.
This may indicate a problem with compatibility betweeen the 3rd party python ADO adaptor and the SQL CE OLEDB provider.

Error when updating

I get the following error when I execute the statement below. 'Invalid
length parameter passed to the substring function'
Update Tbl_Txn_UT
Set Fxd_Units =
CASE
WHEN TxnUnitsBase is Null and (TxnUnits like '%,%' or TxnUnits like
'%M%' and TxnUnitsDur like '%M%')
THEN Cast(left(TxnUnitsDur,len(TxnUnitsDur)-1)as Float)/15
WHEN TxnUnitsDur is Null and (TxnUnits like '%,%' or TxnUnits like
'%M%')
THEN TxnUnitsBase
WHEN (TxnUnits like '%,%' or TxnUnits like '%M%')
THEN Cast(left(TxnUnitsDur,len(TxnUnitsDur)-1)as Float)/15 +
TxnUnitsBase
Else TxnUnits
END
Where TxnUnits is not Null
It took a while to get this code correct with help and now evidently one of
the answers from the math causes an error. Any help is appreciated.Hi
Posting DDL an example data would help to see what you are trying to achive
and help re-create the problem. The statement is assuming that TxnUnitsDur i
s
at least one character which could is probably causing the problem.
John
"Job" wrote:

> I get the following error when I execute the statement below. 'Invalid
> length parameter passed to the substring function'
> Update Tbl_Txn_UT
> Set Fxd_Units =
> CASE
> WHEN TxnUnitsBase is Null and (TxnUnits like '%,%' or TxnUnits like
> '%M%' and TxnUnitsDur like '%M%')
> THEN Cast(left(TxnUnitsDur,len(TxnUnitsDur)-1)as Float)/15
> WHEN TxnUnitsDur is Null and (TxnUnits like '%,%' or TxnUnits like
> '%M%')
> THEN TxnUnitsBase
> WHEN (TxnUnits like '%,%' or TxnUnits like '%M%')
> THEN Cast(left(TxnUnitsDur,len(TxnUnitsDur)-1)as Float)/15 +
> TxnUnitsBase
> Else TxnUnits
> END
> Where TxnUnits is not Null
>
> It took a while to get this code correct with help and now evidently one o
f
> the answers from the math causes an error. Any help is appreciated.
>
>|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:B6369D9E-3B4A-4F9B-A443-13463C76635C@.microsoft.com...
> Hi
> Posting DDL an example data would help to see what you are trying to
> achive
> and help re-create the problem. The statement is assuming that TxnUnitsDur
> is
> at least one character which could is probably causing the problem.
> John
> "Job" wrote:
>|||Ju
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:B6369D9E-3B4A-4F9B-A443-13463C76635C@.microsoft.com...
> Hi
> Posting DDL an example data would help to see what you are trying to
> achive
> and help re-create the problem. The statement is assuming that TxnUnitsDur
> is
> at least one character which could is probably causing the problem.
> John
> "Job" wrote:
>|||Hi
You seem to have some problem posting?
John
"Job" <Job@.nomail.com> wrote in message
news:uUH$jpCoFHA.708@.TK2MSFTNGP09.phx.gbl...
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:B6369D9E-3B4A-4F9B-A443-13463C76635C@.microsoft.com...
>|||John, your correct. I included the case statement if len(TxnUnitsDur )
= 0 then TxnUnitsBase and it worked perfectly.
Cheers!
Job wrote:
> Ju
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:B6369D9E-3B4A-4F9B-A443-13463C76635C@.microsoft.com...
>
>
>

Error when trying to use checkpoint file

I have a package with settings SaveCheckpoints=True and CheckpointUsage = Never. After the package failed I fixed the cause of failure by setting a database column to allow nulls. Then I went to our web app that we built to monitor package execution and clicked on the button to restart the package. The web app loads the package and then sets the CheckpointUsage property of the package object to 'Always'. Then it executes the package in a new thread. The package then produced this error:

Checkpoint file "E:\Package1Checkpoint" failed to open due to error 0x80070005 "Access is denied.".

Since there was only one remaining task to run in the package I ran it manually.

Now here is the really interesting part. I then needed to run the same package but with different parameters. When I attempted to run it with the saved checkpoint settings (CheckpointUsage=Never, SaveCheckpoints=True) I got this error:

"An existing checkpoint file is found with contents that do not appear to be for this package, so the file cannot be overwritten to start saving new checkpoints. Remove the existing checkpoint file and try again. This error occurs when a checkpoint file exists, the package is set to not use a checkpoint file, but to save checkpoints. The existing checkpoint file will not be overwritten. "

So I then attempted to rename the checkpoint file so it would not interfere, however, it would not let me, saying that the file was in use.

So what I had to do was add a configuration entry which set SaveCheckpoints to False. Then I was able to run the package.

Any ideas?

Could it be that the web app was still executing, and the package executed by web app was still running and holding the checkpoint file? This would explain both "Access denied" when trying to read checkpoint, and "file in use" when trying to delete it.|||

TFYR. I'm reviewing the log entries for when the package "failed". I do not see the 'PackageEnd' log entry so I believe you are correct in that the package was still running and was holding the checkpoint file. I believe it was running a very long-running ExecuteDTS2000 task. ' I must have assumed that when a previous task failed that it had failed the package also, which evidently was not the case. Anyway, below is the code from the web app that launches the package if you are interested. Thanks.

...

pkg.CheckpointUsage = DTSCheckpointUsage.Always;

RunPackage();

}

private void RunPackage() {

ThreadStart threadStart = new ThreadStart(PackageExecute);

Thread thread = new Thread(threadStart);

thread.Name = pkg.Name;

thread.Start();

}

private void PackageExecute() {

try

{

pkg.Execute();

}

catch (Exception ex)

{

lblMessage.Text = ex.Message;

}

Error when trying to update

Hi All
I get this error when i open a specific table from enterprise manager and
try to update values in it.
Data has changed since the results pane was last updated. Do you want to
save your changes now?
Click Yes to save your chnages and update the database.
Click No to discard your changes and refresh the results pane.
Click Cancel to continue editing.
If i click Yes which is of course what i wnated to do from the begining i
get this error:
Row cannot be located for updating.Some values may have been changed since
it was last Read.
So i was wonderring if anybody can give me some help with that.
Thanks in Advance
Naderseems like someone else already made a change to your data or that you are
trying to make a change to a key value that is used by em to locate the
record you want to update
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Nader Galal" <ngalal@.health-insights.com> wrote in message
news:uNxO%23CD1DHA.3224@.tk2msftngp13.phx.gbl...

quote:

> Hi All
> I get this error when i open a specific table from enterprise manager and
> try to update values in it.
> Data has changed since the results pane was last updated. Do you want to
> save your changes now?
> Click Yes to save your chnages and update the database.
> Click No to discard your changes and refresh the results pane.
> Click Cancel to continue editing.
> If i click Yes which is of course what i wnated to do from the begining i
> get this error:
> Row cannot be located for updating.Some values may have been changed since
> it was last Read.
> So i was wonderring if anybody can give me some help with that.
> Thanks in Advance
> Nader
>

sql

Error when trying to start Management Studio

Hello Guys,

I am getting the following error when I try to start SQL 2005 Management Studio to manage my SQL Server :

Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

Any ideas ?

Thanks,

Hello

I have managed to sort it by reinstalling SQL over the current installation.

Thanks

|||

Hello,

Do you have a good idea instead of reinstall MS-SQL?

I've a lot of data in DB and always serve to customer. Can't reinstall as your suggess.

Regards,

XNOIE.

|||

Did you ever get this error fix.

I did a search for that dll and i found it, the only weird things is its not located in the same directory as my database.

Error when trying to start Management Studio

Hello Guys,

I am getting the following error when I try to start SQL 2005 Management Studio to manage my SQL Server :

Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

Any ideas ?

Thanks,

Hello

I have managed to sort it by reinstalling SQL over the current installation.

Thanks

|||

Hello,

Do you have a good idea instead of reinstall MS-SQL?

I've a lot of data in DB and always serve to customer. Can't reinstall as your suggess.

Regards,

XNOIE.

|||

Did you ever get this error fix.

I did a search for that dll and i found it, the only weird things is its not located in the same directory as my database.

Error when trying to start Management Studio

Hello Guys,

I am getting the following error when I try to start SQL 2005 Management Studio to manage my SQL Server :

Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

Any ideas ?

Thanks,

Hello

I have managed to sort it by reinstalling SQL over the current installation.

Thanks

|||

Hello,

Do you have a good idea instead of reinstall MS-SQL?

I've a lot of data in DB and always serve to customer. Can't reinstall as your suggess.

Regards,

XNOIE.

|||

Did you ever get this error fix.

I did a search for that dll and i found it, the only weird things is its not located in the same directory as my database.

Error when trying to setup replication

I am trying to setup replication on my server, but was getting an error that said:

"The Distributor is not available Error 6. Specified SQL Server not found"

So, I did some searching and found a couple things to check and found

sp_helpserver...the server with id of 0 was a remote server, not the local server instance...and

select @.@.servername also returned the name of that remote server!!

I'm assuming this is my problem, but how did it get this way and how do I fix it?

ThanksOk, I fixed the @.@.servername issue with:

use master
go
exec sp_dropserver 'incorrect server name'
go
exec sp_addserver 'servername','local'
go

Restart sql server service.

sp_helpserver now lists the local server as id of 0 and @.@.servername returns the correct server.

HOWEVER, the same error is there for replication?!?!

There is an entry in sp_helpserver for this:

repl_distributor repl_distributor rpc,dist,rpc out,use remote collation 6 NULL 0 0

Not sure if that helps with anybody trying to help me but anyway...|||Can you describe how you setup the Replication? At which step you get the error and how did you prepare your db server?|||Thanks for the help.

I did not do anything except for click on the server instance->Tools->Wizards and then click Replication->Configure Publishing and Distribution Wizard

I'm new to this server. It appears it has been messed with before but I cannot give you the details of that.|||Joe,

I was able to get it working. For those that find this post, here is what I did.

First, using the commands above, make sure your server is iniitally setup correct!

Next, I disabled publishing on the local server. Tools->Replication->Publishing

Next, I then configured the distributor for the local server. Tools->Replication->Configure Publishing, Subscribers and Distribution

Thanks

Error when trying to save report in pdf

I developed a report using sql server reporting services and the vs.net
designer. Then I wrote another class that downloads the result into
pdf and excel formats. When I run the program, the excel file opens
fine but the pdf says "there was an error opening this document. the
file is damaged and cannot be repaired". I have seen other forums with
the same issue and microsoft is yet to provide an answer to this
problem. Can someone help please? Any suggestions are well appreciated.
Thanks.There are a variety of reasons this could happen. I'd start by first
looking at the Report Server log file and see what exception (if any) occurs
when you render to PDF. Secondly, I'd dump the PDF into notepad and see if
there are any errors embedded at the end of the stream.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<csuman@.gmail.com> wrote in message
news:1130708307.146769.204230@.g49g2000cwa.googlegroups.com...
>I developed a report using sql server reporting services and the vs.net
> designer. Then I wrote another class that downloads the result into
> pdf and excel formats. When I run the program, the excel file opens
> fine but the pdf says "there was an error opening this document. the
> file is damaged and cannot be repaired". I have seen other forums with
> the same issue and microsoft is yet to provide an answer to this
> problem. Can someone help please? Any suggestions are well appreciated.
> Thanks.
>|||I am having the same problem - just upgraded Adobe Reader to 7.0.5.
Looking at the pdf created in NotePad: Starts with
%PDF-1.3%
1 0 obj [/PDF /Text /ImageB /ImageC /ImageI] . . . has a bunch of stuff . . .
"ends" trailer << /Size 10 /Root 8 0 R/Info 9 0 R >>
startxref
3893
%%EOF
then after the EOF is a full dump of the HTML code:
%%EOF
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title> . . .
I've asked the database manager to look at the reporting services logs but
if this gives anyone a clue to the cause/solution . . .
--
gwf
"Donovan Smith [MSFT]" wrote:
> There are a variety of reasons this could happen. I'd start by first
> looking at the Report Server log file and see what exception (if any) occurs
> when you render to PDF. Secondly, I'd dump the PDF into notepad and see if
> there are any errors embedded at the end of the stream.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> <csuman@.gmail.com> wrote in message
> news:1130708307.146769.204230@.g49g2000cwa.googlegroups.com...
> >I developed a report using sql server reporting services and the vs.net
> > designer. Then I wrote another class that downloads the result into
> > pdf and excel formats. When I run the program, the excel file opens
> > fine but the pdf says "there was an error opening this document. the
> > file is damaged and cannot be repaired". I have seen other forums with
> > the same issue and microsoft is yet to provide an answer to this
> > problem. Can someone help please? Any suggestions are well appreciated.
> >
> > Thanks.
> >
>
>sql

Error when trying to save or write to table

Hi,
I am doing a tuning exercise on a SQL 2K5 instance, I am encountering
a problem when Profiler goes to create a table. I have profiled
Profiler and have extracted the following code
CREATE TABLE [dbo].[con1] ([RowNumber] int IDENTITY(0,1) PRIMARY KEY,
[EventClass] int NULL,[Duration] bigint NULL,,
[TextData] ntext NULL,[SPID] int NULL,[BinaryData] image NULL,[CPU]
int NULL,[Reads] bigint NULL,[Writes] bigint NULL,[ApplicationName]
nvarchar(128) NULL,[ClientProcessID] int NULL,[DatabaseID] int NULL,
[DatabaseName] nvarchar(128) NULL,[EventSequence] int NULL,
[EventSubClass] int NULL,[HostName] nvarchar(128) NULL,[IntegerData]
int NULL,[IsSystem] int NULL,[LoginName] nvarchar(128) NULL,[LoginSid]
image NULL,[NTDomainName] nvarchar(128) NULL,[NTUserName]
nvarchar(128) NULL,[RequestID] int NULL,[ServerName] nvarchar(128)
NULL,[SessionLoginName] nvarchar(128) NULL,[StartTime] datetime NULL,
[TransactionID] bigint NULL)
As you can see, after Duration (the 3rd column), there is a double
comma inserted which of course is erroring.
This occurs when defining a table to save to prior to running the
trace, and defining a table after running the trace.
I have tried the standard profiler which appears to work fine.
I also updated to SP2 CTP (this is a test server) because it appeared
to be an issue simular to this http://support.microsoft.com/?
kbid=925335.
A quick response would be appreciated as I am a contractor and I am on
tight timescales.
Cheers
Steve
Steve,
I don't know how to fix the error with profiler but I recommend you not do
that in the fist place. Tracing to a table can be a huge performance hit and
can skew your results. It is recommended that you trace directly to a file
using sp_trace_create and then use fn_trace_gettable to retrieve the data.
You can do something like this to put the trace results in a table:
SELECT * INTO YourTable FROM fn_trace_gettable(xxx)
If you already have a trace in profiler you can save it to a file and do the
same.
Andrew J. Kelly SQL MVP
"Steve L" <steve_lawrenson@.tiscali.co.uk> wrote in message
news:1170411376.241148.280690@.v33g2000cwv.googlegr oups.com...
> Hi,
> I am doing a tuning exercise on a SQL 2K5 instance, I am encountering
> a problem when Profiler goes to create a table. I have profiled
> Profiler and have extracted the following code
> CREATE TABLE [dbo].[con1] ([RowNumber] int IDENTITY(0,1) PRIMARY KEY,
> [EventClass] int NULL,[Duration] bigint NULL,,
> [TextData] ntext NULL,[SPID] int NULL,[BinaryData] image NULL,[CPU]
> int NULL,[Reads] bigint NULL,[Writes] bigint NULL,[ApplicationName]
> nvarchar(128) NULL,[ClientProcessID] int NULL,[DatabaseID] int NULL,
> [DatabaseName] nvarchar(128) NULL,[EventSequence] int NULL,
> [EventSubClass] int NULL,[HostName] nvarchar(128) NULL,[IntegerData]
> int NULL,[IsSystem] int NULL,[LoginName] nvarchar(128) NULL,[LoginSid]
> image NULL,[NTDomainName] nvarchar(128) NULL,[NTUserName]
> nvarchar(128) NULL,[RequestID] int NULL,[ServerName] nvarchar(128)
> NULL,[SessionLoginName] nvarchar(128) NULL,[StartTime] datetime NULL,
> [TransactionID] bigint NULL)
> As you can see, after Duration (the 3rd column), there is a double
> comma inserted which of course is erroring.
> This occurs when defining a table to save to prior to running the
> trace, and defining a table after running the trace.
> I have tried the standard profiler which appears to work fine.
> I also updated to SP2 CTP (this is a test server) because it appeared
> to be an issue simular to this http://support.microsoft.com/?
> kbid=925335.
> A quick response would be appreciated as I am a contractor and I am on
> tight timescales.
> Cheers
> Steve
>
|||On 2 Feb, 14:11, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> Steve,
> I don't know how to fix the error with profiler but I recommend you not do
> that in the fist place. Tracing to a table can be a huge performance hit and
> can skew your results. It is recommended that you trace directly to a file
> using sp_trace_create and then use fn_trace_gettable to retrieve the data.
> You can do something like this to put the trace results in a table:
> SELECT * INTO YourTable FROM fn_trace_gettable(xxx)
> If you already have a trace in profiler you can save it to a file and do the
> same.
> --
> Andrew J. Kelly SQL MVP
> "Steve L" <steve_lawren...@.tiscali.co.uk> wrote in message
> news:1170411376.241148.280690@.v33g2000cwv.googlegr oups.com...
>
>
>
>
>
>
> - Show quoted text -
Hi Andrew
thanks for the response, I will use the method above as a workaround
and thanks for that information. It would be nice to know if this is a
recognised issue by MS and what their recommended workarounds are for
it.
Cheers
Steve L

Error when trying to run database engine tuning advisor

Hi,

I am getting "R6031- Attempt

to initialize the CRT more than once. This indicates a bug in your

application." when I am trying to database engine tuning advisor. I already followed the workaround from http://support.microsoft.com/default.aspx/kb/913395 but it did not help as I did not have any explorer.exe or any file in that registry folder.

I am using windows XP Sp2, using SQL server developer edition. I am wondering if anyone else has experienced this issue and can help me.

Thanks.

Have you tried attempted to invoke using the DTA on another machine?

I believe this could be the issue with Client tools, try to reinstall the Developer edition on this machine.

|||I will give it a try. I did try to reinstall on this machine but it did not help.

error when trying to restore a sql7 master database

I'm trying to restore a sql7 database on a NT4 Entreprise
SQL server.
I rebuild the master database with Rebuildm.exe and I
start the single user mode with d:\mssql7
\binn\sqlservr.exe -m
When I start the restore with Brighstore ArcServe, I have
this error:
Error: 605. Severity: 21, State: 1.
Error: 63151. Severity: 21, State: 0.
The master database falied to restore. Use the
rebuildm.exe utility to rebuild the master database.
Shutting down SQL Server.
Anyone can help me ?Sorry, you have the wrong usergroup.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Francosi Thibault" <anonymous@.discussions.microsoft.com> wrote in message
news:23a7601c45eac$24a9a520$a401280a@.phx.gbl...
> I'm trying to restore a sql7 database on a NT4 Entreprise
> SQL server.
> I rebuild the master database with Rebuildm.exe and I
> start the single user mode with d:\mssql7
> \binn\sqlservr.exe -m
> When I start the restore with Brighstore ArcServe, I have
> this error:
> Error: 605. Severity: 21, State: 1.
> Error: 63151. Severity: 21, State: 0.
> The master database falied to restore. Use the
> rebuildm.exe utility to rebuild the master database.
> Shutting down SQL Server.
> Anyone can help me ?

Error when trying to process cube after SP2

Hi Guys

Seems a nasty error started to appear after I installed SP2 on the corporate server and my machine and then trying to process a cube. Process goes through fine, but when I try to browse it a following error pops up. If anyone can help me with this, that would be great.

Parser: The end of the input was reached. (Microsoft SQL Server 2005 Analysis Services)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, String requestNamespace, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, IDictionary adomdRestrictions, Boolean throwOnInlineErrors)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, AdomdRestrictionCollection restrictions, Boolean throwOnInlineErrors)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, AdomdRestrictionCollection restrictions)
at Microsoft.AnalysisServices.Browse.CubeBrowser.BrowsableObjectsManager.Refresh()
at Microsoft.AnalysisServices.Browse.CubeBrowser.BrowsableObjectsManager.UpdateComboBox()
at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdateAll(Boolean translate)
at Microsoft.AnalysisServices.Browse.CubeBrowser.ReconnectCanFail()
at Microsoft.AnalysisServices.Browse.CubeBrowser.SupportFunctionWhichCanFail(FunctionWhichCanFail function)

Thank you

Found a problem: the default measures were not set up in perspectives. Hmm... I thought the first one will be selected automatically.

Error when trying to open report in VS.NET

Hi,
I'm trying to open a report that was created a few days ago to make
modifications. When I double click on it in the Solutions Explorer in
VS.NET, I get an Exception from HRESULT error.
The report has been published to the report server.
Does anyone know how I can troubleshoot this?
ThanksDoes this describe your problem?
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/1ab023b68d2ca2ed/4e31690c8f70c2fa?q=rdl++0x80131500&_done=%2Fgroups%3Fq%3Drdl++0x80131500%26&_doneTitle=Back+to+Search&&d#4e31690c8f70c2fa
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"T." <asdfasdf@.adfasdf.com> wrote in message
news:e1amHtoGFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I'm trying to open a report that was created a few days ago to make
> modifications. When I double click on it in the Solutions Explorer in
> VS.NET, I get an Exception from HRESULT error.
> The report has been published to the report server.
> Does anyone know how I can troubleshoot this?
> Thanks
>sql

Error when trying to modify a table in Sql Server 2005 beta 2

Hi there.
All the times when I try to modify a table, I receive a COM error and the
modify windows is not showed. Below you can see the exception message. That
way, I am unable to modify a table using Sql Server 2005 beta 2. Any
suggestions?
************** Exception Text **************
System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT
E_FAIL has been returned from a call to a COM component.
at
Microsoft.VisualStudio.DataTools.UI.Grid.IDTGridSt orage.GetCellDataAsString(Int64 nRowIndex, Int32 nColIndex)
at
Microsoft.VisualStudio.DataTools.UI.Grid.DTGridSto rageWrapper.GetCellDataAsString(Int64 nRowIndex, Int32 nColIndex)
at
Microsoft.SqlServer.Management.UI.Grid.GridTextCol umn.DrawCell(Graphics g,
Brush bkBrush, Brush textBrush, Font textFont, Rectangle rect, IGridStorage
storage, Int64 nRowIndex)
at
Microsoft.SqlServer.Management.UI.Grid.GridControl .DoCellPainting(Graphics g,
SolidBrush bkBrush, SolidBrush textBrush, Font textFont, Rectangle cellRect,
GridColumn gridColumn, Int64 rowNumber, Boolean enabledState)
at
Microsoft.SqlServer.Management.UI.Grid.GridControl .PaintOneCell(Graphics g,
Int32 nCol, Int64 nRow, Int32 nEditedCol, Int64 nEditedRow, Rectangle& rCell,
Rectangle& rCurrentCellRect, Rectangle& rEditingCellRect)
at Microsoft.SqlServer.Management.UI.Grid.GridControl .PaintGrid(Graphics g)
at
Microsoft.SqlServer.Management.UI.Grid.GridControl .OnPaint(PaintEventArgs pe)
at System.Windows.Forms.Control.PaintWithErrorHandlin g(PaintEventArgs e,
Int16 layer, Boolean disposeEventArgs)
at System.Windows.Forms.Control.WmPaint(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at Microsoft.SqlServer.Management.UI.Grid.GridControl .WndProc(Message& m)
at Microsoft.VisualStudio.DataTools.UI.Grid.GridContr ol.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage (Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(M essage& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
Thanks.
Carlos
Senior Developer
www.byteshift.com
Regarding SQL Server 2005, you should probably post to the beta newsgroups
http://communities.microsoft.com/new...r2005&slcid=us
If you want to access the newsgroups via your newsreader just scroll through
the top right hand frame for connection information
Keith
"Carlao" <Carlao@.discussions.microsoft.com> wrote in message
news:0646E034-A0F4-4692-9B3A-48A790A48FAC@.microsoft.com...
> Hi there.
> All the times when I try to modify a table, I receive a COM error and the
> modify windows is not showed. Below you can see the exception message.
That
> way, I am unable to modify a table using Sql Server 2005 beta 2. Any
> suggestions?
> ************** Exception Text **************
> System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT
> E_FAIL has been returned from a call to a COM component.
> at
>
Microsoft.VisualStudio.DataTools.UI.Grid.IDTGridSt orage.GetCellDataAsString(
Int64 nRowIndex, Int32 nColIndex)
> at
>
Microsoft.VisualStudio.DataTools.UI.Grid.DTGridSto rageWrapper.GetCellDataAsS
tring(Int64 nRowIndex, Int32 nColIndex)
> at
> Microsoft.SqlServer.Management.UI.Grid.GridTextCol umn.DrawCell(Graphics g,
> Brush bkBrush, Brush textBrush, Font textFont, Rectangle rect,
IGridStorage
> storage, Int64 nRowIndex)
> at
> Microsoft.SqlServer.Management.UI.Grid.GridControl .DoCellPainting(Graphics
g,
> SolidBrush bkBrush, SolidBrush textBrush, Font textFont, Rectangle
cellRect,
> GridColumn gridColumn, Int64 rowNumber, Boolean enabledState)
> at
> Microsoft.SqlServer.Management.UI.Grid.GridControl .PaintOneCell(Graphics
g,
> Int32 nCol, Int64 nRow, Int32 nEditedCol, Int64 nEditedRow, Rectangle&
rCell,
> Rectangle& rCurrentCellRect, Rectangle& rEditingCellRect)
> at
Microsoft.SqlServer.Management.UI.Grid.GridControl .PaintGrid(Graphics g)
> at
> Microsoft.SqlServer.Management.UI.Grid.GridControl .OnPaint(PaintEventArgs
pe)
> at System.Windows.Forms.Control.PaintWithErrorHandlin g(PaintEventArgs
e,
> Int16 layer, Boolean disposeEventArgs)
> at System.Windows.Forms.Control.WmPaint(Message& m)
> at System.Windows.Forms.Control.WndProc(Message& m)
> at Microsoft.SqlServer.Management.UI.Grid.GridControl .WndProc(Message&
m)
> at
Microsoft.VisualStudio.DataTools.UI.Grid.GridContr ol.WndProc(Message& m)
> at System.Windows.Forms.ControlNativeWindow.OnMessage (Message& m)
> at System.Windows.Forms.ControlNativeWindow.WndProc(M essage& m)
> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> IntPtr wparam, IntPtr lparam)
> Thanks.
> Carlos
> --
> Senior Developer
> www.byteshift.com

Error when trying to log in to SQL server

I've just finished developing a web app, which works fine on my PC, running IIS locally. It uses windows authentication and a trusted connection to retrieve data from SQL server. So far so routine. When I deploy the app to my live server, it returns the error:

The stack trace seems to indicate that it's at the point where the app tries to retrieve data that the error occurs. I proved this by changing my connection string to explicitly define the log on, and it retrieved the data no problem.

I set up a very simple webform with a label on, to return what it thought the user's log on name was, and it returns the correct name.

Any ideas as to why the username isn't being correctly passed to SQL server?Have you made sure the Web Account is a valid user of the SQL Server? If the IIS box and the SQL box are different you have to ensure the user has network rights too.|||Yes, the user (me!) definitely has rights on the SQL server. How come it works locally on my PC, but not on the server?

What network rights do you think I should investigate?

Thanks.|||Sorry I mis-read your original post, I didn't notice that your site was using NT Authentication. So here is my mental checklist:
1. Web Server has access to the Domain server to authenticate the user
2. The Web Server isn't the Domain Server
3. SQL Server security logins knows about the Windows user/user group
4. The SQL Database knows about the Windows user/user group

I mentioned the network security because when you use anon web access the user must have network access to go across machines. That "shouldn't" be an issue here.

Also run SQL Profiler to see if the user is getting set to SQL and then going wrong. Sounds more like its a problem on the web server though, something wrong with the impersonation.|||I'm positive that the user is being authenticated properly on the app, because when I load a simple page with a label which displays the user name, it displays correctly. For some reason this user name isn't getting passed to SQL server correctly.

I tried deploying the application to the box which has the SQL server running, and gess what? It worked. So does this mean that the first box can't access the domain server? Any idea how I can check that?

I'll have a think, and let you know how I get on.

Cheers.|||Hang on, just cause you're using Web Authentication doesn't mean it will impersonate the user onto SQL Server. Do you set the principal security when the user connects?

Check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch03.asp

Error when trying to filter a table

Hi!!
I have 2 tables in a report that runs against the same dataset. And
when I try to filter on a field called T0650_CONDITION_TYPE_ID, I get
an error.
"The processing of filter expression for the table 'table2' cannot be
performed. The comparison failed. Please check the data type retured
by filter expression."
The filter is =Fields!T0650_CONDITION_TYPE_ID.Value = 2
I've searched the internet and found different suggestions to
solutions but none of them works.
I've tried to =2 in the value-field, I have tried to convert, but I
doesn't get it to work.
And I need this filter to just show T0650_CONDITION_TYPE_ID.Value = 1
in one table and T0650_CONDITION_TYPE_ID.Value = 2 in the other.
I have tried to hide, but then I get empty spaces, and it doesn't look
good.
T0650_CONDITION_TYPE_ID is a tinyint.
I'm grateful for any help
BR LottaCould you try
=(CInt(Fields!T0650_CONDITION_TYPE_ID.Value) = 2) ?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lotta" <lotta.svensson@.europeiska.com> wrote in message
news:7ec6061a.0503020012.eb2f8f0@.posting.google.com...
> Hi!!
> I have 2 tables in a report that runs against the same dataset. And
> when I try to filter on a field called T0650_CONDITION_TYPE_ID, I get
> an error.
> "The processing of filter expression for the table 'table2' cannot be
> performed. The comparison failed. Please check the data type retured
> by filter expression."
> The filter is =Fields!T0650_CONDITION_TYPE_ID.Value = 2
> I've searched the internet and found different suggestions to
> solutions but none of them works.
> I've tried to =2 in the value-field, I have tried to convert, but I
> doesn't get it to work.
> And I need this filter to just show T0650_CONDITION_TYPE_ID.Value = 1
> in one table and T0650_CONDITION_TYPE_ID.Value = 2 in the other.
> I have tried to hide, but then I get empty spaces, and it doesn't look
> good.
> T0650_CONDITION_TYPE_ID is a tinyint.
> I'm grateful for any help
> BR Lotta

Error when trying to execute a job from windows service.

Hi,
I'm trying to execute a DTS package from a .NET service. The service is
running under a domain account that owns the job which it executes using
'sp_start_job'. The call to the sp succeeds however checking the Job history
gives: -
"The job failed. Unable to determine if the owner (DOMAIN\ServiceUser) of
job <JobName> has server access (reason: Could not obtain information about
Windows NT group/user 'DOMAIN\ServiceUser'. [SQLSTATE 42000] (Error 8198
))."
SQL Server 2000 SP4
Both SQLServer + SQLAgent run under a domain account (different to the
service)
ServiceUser has login to sql server not an admin, however I've tried using
the SQL Agent Proxy account still no success.
Any ideas?
thanks Paul> SQL Server 2000 SP4
> Both SQLServer + SQLAgent run under a domain account (different to the
> service)
> ServiceUser has login to sql server not an admin, however I've tried using
> the SQL Agent Proxy account still no success.
The SQL 2000 Books Online <instsql.chm::/in_overview_6k1f.htm> states that
the SQL Agent service account must be a member of the local Administrators
group in order to "Create CmdExec and ActiveScript jobs belonging to someone
other than a SQL Server administrator".
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul Coulson" <nospam@.nospam.net> wrote in message
news:OZUDQ3WOGHA.3144@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm trying to execute a DTS package from a .NET service. The service is
> running under a domain account that owns the job which it executes using
> 'sp_start_job'. The call to the sp succeeds however checking the Job
> history gives: -
> "The job failed. Unable to determine if the owner (DOMAIN\ServiceUser) of
> job <JobName> has server access (reason: Could not obtain information
> about Windows NT group/user 'DOMAIN\ServiceUser'. [SQLSTATE 42000] (Er
ror
> 8198))."
> SQL Server 2000 SP4
> Both SQLServer + SQLAgent run under a domain account (different to the
> service)
> ServiceUser has login to sql server not an admin, however I've tried using
> the SQL Agent Proxy account still no success.
> Any ideas?
> thanks Paul
>|||Hi Dan,
Thanks that's sorted it. Also got it working using the proxy account
again this needed local admin rights.
Cheers Paul
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:ueU6PriOGHA.1192@.TK2MSFTNGP11.phx.gbl...
> The SQL 2000 Books Online <instsql.chm::/in_overview_6k1f.htm> states that
> the SQL Agent service account must be a member of the local Administrators
> group in order to "Create CmdExec and ActiveScript jobs belonging to
> someone other than a SQL Server administrator".
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Paul Coulson" <nospam@.nospam.net> wrote in message
> news:OZUDQ3WOGHA.3144@.TK2MSFTNGP11.phx.gbl...
>|||I'm glad you were able to get it working. However, I'd be leery about
granting admin rights the proxy account since that allows non-sysadmins to
run processes with admin rights. Now that you got the service accounts
sorted out, I would expect your DTS package to run fine as long as the proxy
account has permissions on data and files accessed by the package.
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul Coulson" <nospam@.nospam.net> wrote in message
news:eCdaOR4OGHA.812@.TK2MSFTNGP10.phx.gbl...
> Hi Dan,
> Thanks that's sorted it. Also got it working using the proxy account
> again this needed local admin rights.
> Cheers Paul
>
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:ueU6PriOGHA.1192@.TK2MSFTNGP11.phx.gbl...
>

Error when trying to enable a server for replication

I am trying to setup a server to be enabled for replication. It is a SQL 2000
Sp 3a server. The error appears at the end of the wizard as it stepping down
the entries setting up replication. It gets to configuring Distributor and
then gives the following error and then drops the distribtuion database. This
server is a new install running on a cluster.
Any ideas?
Error 14113:
Could not execute ""C:\Program Files\Microsoft SQL Server\80\Tools\binn\osql"
-E -l60 -t60 -d"distribution" -b -i"C:\Progam Files\Microsoft SQL
Server\MSSQL\install\insdist.sql" -o"C:\Progam Files\Microsoft SQL
Server\MSSQL\install\insdist.out"". Check insdist.out in the insall directory.
'distribution' is not configured as the distribution database.
Deleting the distribution transaction log
Deleting the distribution database file
The contents of insdist.out are below:
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29>
----
At top, db_name()=
distribution
(1 row affected)
1> 2> 3> 4> 5> 6> 1> 2> 3> 1> 2> DBCC execution completed. If DBCC printed
error messages, contact your
system administrator.
Configuration option 'allow updates' changed from 1 to 1. Run the
RECONFIGURE statement to install.
1> 2> 1> 2> 3> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
18> 1> 2> 3> 4> 5> 6> 7> 8>
Creating distribution tables
Creating table MSrepl_version
(1 row affected)
Creating table MSpublisher_databases
Creating clustered index ucMSpublisher_databases
Creating table MSpublications
Creating clustered index ucMSpublications
Creating table MSarticles
Creating clustered index ucMSarticles
Creating table MSsubscriptions
Creating clustered index ucMSsubscirptions
Creating index iMSsubscriptions
Creating index iMSsubscriptions2
Creating table MSmerge_subscriptions
Creating clustered index ucMSmerge_subscriptions
Creating table MSrepl_transactions
Creating clustered index usMSrepl_transactions
Creating table MSrepl_commands
Creating clusterd index ucMSrepl_commands
Creating table MSrepl_orginators
Creating clustered index usMSrepl_originators
Creating table MSsubscriber_info
Creating clustered index ucMSsubscriber_info
Creating table MSsubscriber_schedule
Creating table MSsnapshot_history
Creating clustered index ucMSsnapshot_history
Creating clustered index nc1MSsnapshot_history
Creating table MSlogreader_history
Creating clustered index ucMSlogreader_history
Creating nonclustered index nc1MSlogreader_history
Creating table MSdistribution_history
Creating clustered index ucMSdistribution_history
Creating clustered index nc1MSdistribution_history
Creating table MSmerge_history
Creating clustered index ucMSmerge_history
Creating nonclustered index nc1MSmerge_history
Creating table MSrepl_errors
Creating clustered index ucMSrepl_errors
Creating table MSsnapshot_agents
Creating clustered index ucMSsnapshot_agents
Creatingindex iMSsnapshot_agents
Creating table MSlogreader_agents
Creating clustered index ucMSlogreader_agents
Creatingindex iMSlogreader_agents
Creating table MSdistribution_agents
Creating clustered index ucMSdistribution_agents
Creatingindex iMSdistribution_agents
Creating table MSmerge_agents
Creating clustered index ucMSmerge_agents
Creatingindex iMSmerge_agents
Creating table MSrepl_identity_range
Creating table MSpublication_access
Creating clustered index ucMSpublication_access
Creating table MSqreader_agents
Creating unique index ucMSqreader_agents
Creating table MSqreader_history
Creating clustered index ucMSqreader_history
Creating table MSrepl_backup_lsns
Creating clustered index ucMSrepl_backup_lsns
1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36>
37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55>
56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74>
75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93>
94> 95> DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Dropping all distribution stored procedures
1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36>
37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55>
56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74>
75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93>
94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109>
110> 111> 112> 113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124>
125> 126> 127> 128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139>
140> 141> 142> 143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154>
155> 156> 157> 158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169>
170> 171> 172> 173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184>
185> 186> 187> 188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199>
200> 201> 202> 203> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214>
215> 216> 217> 218> 219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229>
230> 231> 232> 233> 234> 235> 236> 237> 238> 239> 240> 241> 242> 243> 244>
245> 246> 247> 248> 249> 250> 251> 252> 253> 254> 255> 256> 257> 258> 259>
260> 261> 262> 263> 264> 265> 266> 267> 268> 269> 270> 271> 272> 273> 274>
275> 276> 277> 278> 279> 280> 281> 282> 283> 284> 285> 286> 287> 288> 289>
290> 291> 292> 293> 294> 295> 296> 297> 298> 299> 300> 301> 302> 303> 304>
305> 306> 307> 308> 309> 310> 311> 312> 313> 314> 315> 316> 317> 318> 319>
320> 321> 322> 323> 324> 325> 326> 327> 328> 329> 330> 331> 332> 333> 334>
335> 336> 337> 338> 339> 340> 341> 342> 343> 344> 345> 346> 347> 348> 349>
350> 351> 352> 353> 354> 355> 356> 357> 358> 359> 360> 361> 362> 363> 364>
365> 366> 367> 368> 369> 370> 371> 372> 373> 374> 375> 376> 377> 378> 379>
380> 381> 382> 383> 384> 385> 386> 387> 388> 389> 390> 391> 392> 393> 394>
395> 396> 397> 398> 399> 400> 401> 402> 403> 404> 405> 406> 407> 408> 409>
410> 411> 412> 413> 414> 415> 416> 417> 418> 419> 1> 2> 3> 4> 5> 6> 7> 8> 1>
2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2>
3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15>
16> 17> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19>
20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38>
39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57>
58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76>
77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95>
96> 97> 98> 1> 2> 3> 4> 5> 6> 1> 2> 3> Creating procedure
sp_MSislogreaderjobnamegenerated
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 1> 2> 3> Creating procedure
sp_MSisqueuereaderjobnamegenerated
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 1> 2> 3> 4>
Creating procedure sp_MSissnapshotjobnamegenerated
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 1> 2> 3> 4> Creating
procedure sp_MSisdistributionjobnamegenerated
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
129> 130> 131> 132> 1> 2> 3> 4> Creating procedure
sp_MSismergejobnamegenerated
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 1> 2> 3> 4> 5>
6> 7> 8> Creating 'fn_MSmask_agent_type'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 1> 2> 3> Creating 'sp_MScheck_pull_access'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
129> 130> 131> 132> 133> 134> 135> 1> 2> 3> 4> Creating
'sp_MSquery_syncstates'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 1> 2> 3> 4> Creating
'sp_MSset_syncstate'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 1> 2> 3>
Creating 'sp_MSadd_repl_command'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 1> 2> 3> 4> Creating 'sp_MSadd_repl_commands27'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143>
144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158>
159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173>
174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187> 188>
189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202> 203>
204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217> 218>
219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229> 230> 231> 232> 233>
234> 235> 236> 237> 238> 239> 240> 241> 242> 243> 244> 245> 246> 247> 248>
249> 250> 251> 252> 253> 254> 255> 256> 257> 258> 259> 260> 261> 262> 263>
264> 265> 266> 267> 268> 269> 270> 271> 272> 273> 274> 275> 276> 277> 278>
279> 280> 281> 282> 283> 284> 285> 286> 287> 288> 289> 290> 291> 292> 293>
294> 295> 296> 297> 298> 299> 300> 301> 302> 303> 304> 305> 306> 307> 308>
309> 310> 311> 312> 313> 314> 315> 316> 317> 318> 319> 320> 321> 322> 323>
324> 325> 326> 327> 328> 329> 330> 331> 332> 333> 334> 335> 336> 337> 338>
339> 340> 341> 342> 343> 344> 345> 346> 347> 348> 349> 350> 351> 352> 353>
354> 355> 356> 357> 358> 359> 360> 361> 362> 363> 364> 365> 366> 367> 368>
369> 370> 371> 372> 373> 374> 375> 376> 377> 378> 379> 380> 381> 382> 383>
384> 385> 386> 387> 388> 389> 390> 391> 392> 393> 394> 395> 396> 397> 398>
399> 400> 401> 402> 403> 404> 405> 406> 407> 408> 409> 410> 411> 412> 413>
414> 415> 416> 417> 418> 419> 420> 421> 422> 423> 424> 425> 426> 427> 428>
429> 430> 431> 432> 433> 434> 435> 436> 437> 438> 439> 440> 441> 442> 443>
444> 445> 446> 447> 448> 449> 450> 451> 452> 453> 454> 455> 456> 457> 458>
459> 460> 461> 462> 463> 464> 465> 466> 467> 468> 469> 470> 471> 472> 473>
474> 475> 476> 477> 478> 479> 480> 481> 482> 483> 484> 485> 486> 487> 488>
489> 490> 491> 492> 493> 494> 495> 496> 497> 498> 499> 500> 501> 502> 503>
504> 505> 506> 507> 508> 509> 510> 511> 512> 513> 514> 515> 516> 517> 518>
519> 520> 521> 522> 523> 524> 525> 526> 527> 528> 529> 530> 531> 532> 533>
534> 535> 536> 537> 538> 539> 540> 541> 542> 543> 544> 545> 546> 547> 548>
549> 550> 551> 552> 553> 554> 555> 556> 557> 558> 559> 560> 561> 562> 563>
564> 565> 566> 567> 568> 569> 570> 571> 572> 573> 574> 575> 576> 577> 578>
579> 580> 581> 582> 583> 584> 585> 586> 587> 588> 589> 590> 591> 592> 593>
594> 595> 596> 597> 598> 599> 600> 601> 602> 603> 604> 605> 606> 607> 608>
609> 610> 611> 612> 613> 614> 615> 616> 617> 618> 619> 620> 621> 622> 623>
624> 625> 626> 627> 628> 629> 630> 631> 632> 633> 634> 635> 636> 637> 638>
639> 640> 641> 642> 643> 644> 645> 646> 647> 648> 649> 650> 651> 652> 653>
654> 655> 656> 657> 658> 659> 660> 661> 662> 663> 664> 665> 666> 667> 668>
669> 670> 671> 672> 673> 674> 675> 676> 677> 678> 679> 680> 681> 682> 683>
684> 685> 686> 687> 688> 689> 690> 691> 692> 693> 694> 695> 696> 697> 698>
699> 700> 701> 702> 703> 704> 705> 706> 707> 708> 709> 710> 711> 712> 713>
714> 715> 716> 717> 718> 719> 720> 721> 722> 723> 724> 725> 726> 727> 728>
729> 730> 731> 732> 733> 734> 735> 736> 737> 738> 739> 740> 741> 742> 743>
744> 745> 746> 747> 748> 749> 750> 751> 752> 753> 754> 755> 756> 757> 758>
759> 760> 761> 762> 763> 764> 765> 766> 767> 768> 769> 770> 771> 772> 773>
774> 775> 776> 777> 778> 779> 780> 781> 782> 783> 784> 785> 786> 787> 788>
789> 790> 791> 792> 793> 794> 795> 796> 797> 798> 799> 800> 801> 802> 803>
804> 805> 806> 807> 808> 809> 810> 811> 812> 813> 814> 815> 816> 817> 818>
819> 820> 821> 822> 823> 824> 825> 826> 827> 828> 829> 830> 831> 832> 833>
834> 835> 836> 837> 838> 839> 840> 841> 842> 843> 844> 845> 846> 847> 848>
849> 850> 851> 852> 853> 854> 855> 856> 857> 858> 859> 860> 861> 862> 863>
864> 865> 866> 867> 868> 869> 870> 871> 872> 873> 874> 875> 876> 877> 878>
879> 880> 881> 882> 883> 884> 885> 886> 887> 888> 889> 890> 891> 892> 893>
894> 895> 896> 897> 898> 899> 900> 901> 902> 903> 904> 905> 906> 907> 908>
909> 910> 911> 912> 913> 914> 915> 916> 917> 918> 919> 920> 921> 922> 923>
924> 925> 926> 927> 928> 929> 930> 931> 932> 933> 934> 935> 936> 937> 938>
939> 940> 941> 942> 943> 944> 945> 946> 947> 948> 949> 950> 951> 952> 953>
954> 955> 956> 957> 958> 959> 960> 961> 962> 963> 964> 965> 966> 967> 968>
969> 970> 971> 972> 973> 974> 975> 976> 977> 978> 979> 980> 981> 982> 983>
984> 985> 986> 987> 988> 989> 990> 991> 992> 993> 994> 995> 996> 997> 998>
999> 1000> 1001> 1002> 1003> 1004> 1005> 1006> 1007> 1008> 1009> 1010> 1011>
1012> 1013> 1014> 1015> 1016> 1017> 1018> 1019> 1020> 1021> 1022> 1023> 1024>
1025> 1026> 1027> 1028> 1029> 1030> 1031> 1032> 1033> 1034> 1035> 1036> 1037>
1038> 1039> 1040> 1041> 1042> 1043> 1044> 1045> 1046> 1047> 1048> 1049> 1050>
1051> 1052> 1053> 1054> 1055> 1056> 1057> 1058> 1059> 1060> 1061> 1062> 1063>
1064> 1065> 1066> 1067> 1068> 1069> 1070> 1071> 1072> 1073> 1074> 1075> 1076>
1077> 1078> 1079> 1080> 1081> 1082> 1083> 1084> 1085> 1086> 1087> 1088> 1089>
1090> 1091> 1092> 1093> 1094> 1095> 1096> 1097> 1098> 1099> 1100> 1101> 1102>
1103> 1104> 1105> 1106> 1107> 1108> 1109> 1110> 1111> 1112> 1113> 1114> 1115>
1116> 1117> 1118> 1119> 1120> 1121> 1122> 1123> 1124> 1125> 1126> 1127> 1128>
1129> 1130> 1131> 1132> 1133> 1134> 1135> 1136> 1137> 1138> 1139> 1140> 1141>
1142> 1143> 1144> 1145> 1146> 1147> 1148> 1149> 1150> 1151> 1152> 1153> 1154>
1155> 1156> 1157> 1158> 1159> 1160> 1161> 1162> 1163> 1164> 1165> 1166> 1167>
1168> 1169> 1170> 1171> 1172> 1173> 1174> 1175> 1176> 1177> 1178> 1179> 1180>
1181> 1182> 1183> 1184> 1185> 1186> 1187> 1188> 1189> 1190> 1191> 1192> 1193>
1194> 1195> 1196> 1197> 1198> 1199> 1200> 1201> 1202> 1203> 1204> 1205> 1206>
1207> 1208> 1209> 1210> 1211> 1212> 1213> 1214> 1215> 1216> 1217> 1218> 1219>
1220> 1221> 1222> 1223> 1224> 1225> 1226> 1227> 1228> 1229> 1230> 1231> 1232>
1233> 1234> 1235> 1236> 1237> 1238> 1239> 1240> 1241> 1242> 1243> 1244> 1245>
1246> 1247> 1248> 1249> 1250> 1251> 1252> 1253> 1254> 1255> 1256> 1257> 1258>
1259> 1260> 1261> 1262> 1263> 1264> 1265> 1266> 1267> 1268> 1269> 1270> 1271>
1272> 1273> 1274> 1275> 1276> 1277> 1278> 1279> 1280> 1281> 1282> 1283> 1284>
1285> 1286> 1287> 1288> 1289> 1290> 1291> 1292> 1293> 1294> 1295> 1296> 1297>
1298> 1299> 1300> 1301> 1302> 1303> 1304> 1305> 1306> 1307> 1308> 1309> 1310>
1311> 1312> 1313> 1314> 1315> 1316> 1317> 1318> 1319> 1320> 1321> 1322> 1323>
1324> 1325> 1326> 1327> 1328> 1329> 1> 2> 3> Creating
'sp_MSadd_repl_commands27hp6x'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143>
144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158>
159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173>
174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187> 188>
189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202> 203>
204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217> 218>
219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229> 230> 231> 232> 233>
234> 235> 236> 237> 238> 239> 240> 241> 242> 243> 244> 245> 246> 247> 248>
249> 250> 251> 252> 253> 254> 255> 256> 257> 258> 259> 260> 261> 262> 263>
264> 265> 266> 267> 268> 269> 270> 271> 272> 273> 274> 275> 276> 277> 278>
279> 280> 281> 282> 283> 284> 285> 286> 287> 288> 289> 290> 291> 292> 293>
294> 295> 296> 297> 298> 299> 300> 301> 302> 303> 304> 305> 306> 307> 308>
309> 310> 311> 312> 313> 314> 315> 316> 317> 318> 319> 320> 321> 322> 323>
324> 325> 326> 327> 328> 329> 330> 331> 332> 333> 334> 335> 336> 337> 338>
339> 340> 341> 342> 343> 344> 345> 346> 347> 348> 349> 350> 351> 352> 353>
354> 355> 356> 357> 358> 359> 360> 361> 362> 363> 364> 365> 366> 367> 368>
369> 370> 371> 372> 373> 374> 375> 376> 377> 378> 379> 380> 381> 382> 383>
384> 385> 386> 387> 388> 389> 390> 391> 392> 393> 394> 395> 396> 397> 398>
399> 400> 401> 402> 403> 404> 405> 406> 407> 408> 409> 410> 411> 412> 413>
414> 415> 416> 417> 418> 419> 420> 421> 422> 423> 424> 425> 426> 427> 428>
429> 430> 431> 432> 433> 434> 435> 436> 437> 438> 439> 440> 441> 442> 443>
444> 445> 446> 447> 448> 449> 450> 451> 452> 453> 454> 455> 456> 457> 458>
459> 460> 461> 462> 463> 464> 465> 466> 467> 468> 469> 470> 471> 472> 473>
474> 475> 476> 477> 478> 479> 480> 481> 482> 483> 484> 485> 486> 487> 488>
489> 490> 491> 492> 493> 494> 495> 496> 497> 498> 499> 500> 501> 502> 503>
504> 505> 506> 507> 508> 509> 510> 511> 512> 513> 514> 515> 516> 517> 518>
519> 520> 521> 522> 523> 524> 525> 526> 527> 528> 529> 530> 531> 532> 533>
534> 535> 536> 537> 538> 539> 540> 541> 542> 543> 544> 545> 546> 547> 548>
549> 550> 551> 552> 553> 554> 555> 556> 557> 558> 559> 560> 561> 562> 563>
564> 565> 566> 567> 568> 569> 570> 571> 572> 573> 574> 575> 576> 577> 578>
579> 580> 581> 582> 583> 584> 585> 586> 587> 588> 589> 590> 591> 592> 593>
594> 595> 596> 597> 598> 599> 600> 601> 602> 603> 604> 605> 606> 607> 608>
609> 610> 611> 612> 613> 614> 615> 616> 617> 618> 619> 620> 621> 622> 623>
624> 625> 626> 627> 628> 629> 630> 631> 632> 633> 634> 635> 636> 637> 638>
639> 640> 641> 642> 643> 644> 645> 646> 647> 648> 649> 650> 651> 652> 653>
654> 655> 656> 657> 658> 659> 660> 661> 662> 663> 664> 665> 666> 667> 668>
669> 670> 671> 672> 673> 674> 675> 676> 677> 678> 679> 680> 681> 682> 683>
684> 685> 686> 687> 688> 689> 690> 691> 692> 693> 694> 695> 696> 697> 698>
699> 700> 701> 702> 703> 704> 705> 706> 707> 708> 709> 710> 711> 712> 713>
714> 715> 716> 717> 718> 719> 720> 721> 722> 723> 724> 725> 726> 727> 728>
729> 730> 731> 732> 733> 734> 735> 736> 737> 738> 739> 740> 741> 742> 743>
744> 745> 746> 747> 748> 749> 750> 751> 752> 753> 754> 755> 756> 757> 758>
759> 760> 761> 762> 763> 764> 765> 766> 767> 768> 769> 770> 771> 772> 773>
774> 775> 776> 777> 778> 779> 780> 781> 782> 783> 784> 785> 786> 787> 788>
789> 790> 791> 792> 793> 794> 795> 796> 797> 798> 799> 800> 801> 802> 803>
804> 805> 806> 807> 808> 809> 810> 811> 812> 813> 814> 815> 816> 817> 818>
819> 820> 821> 822> 823> 824> 825> 826> 827> 828> 829> 830> 831> 832> 833>
834> 835> 836> 837> 838> 839> 840> 841> 842> 843> 844> 845> 846> 847> 848>
849> 850> 851> 852> 853> 854> 855> 856> 857> 858> 859> 860> 861> 862> 863>
864> 865> 866> 867> 868> 869> 870> 871> 872> 873> 874> 875> 876> 877> 878>
879> 880> 881> 882> 883> 884> 885> 886> 887> 888> 889> 890> 891> 892> 893>
894> 895> 896> 897> 898> 899> 900> 901> 902> 903> 904> 905> 906> 907> 908>
909> 910> 911> 912> 913> 914> 915> 916> 917> 918> 919> 920> 921> 922> 923>
924> 925> 926> 927> 928> 929> 930> 931> 932> 933> 934> 935> 936> 937> 938>
939> 940> 941> 942> 943> 944> 945> 946> 947> 948> 949> 950> 951> 952> 953>
954> 955> 956> 957> 958> 959> 960> 961> 962> 963> 964> 965> 966> 967> 968>
969> 970> 971> 972> 973> 974> 975> 976> 977> 978> 979> 980> 981> 982> 983>
984> 985> 986> 987> 988> 989> 990> 991> 992> 993> 994> 995> 996> 997> 998>
999> 1000> 1001> 1002> 1003> 1004> 1005> 1006> 1007> 1008> 1009> 1010> 1011>
1012> 1013> 1014> 1015> 1016> 1017> 1018> 1019> 1020> 1021> 1022> 1023> 1024>
1025> 1026> 1027> 1028> 1029> 1030> 1031> 1032> 1033> 1034> 1035> 1036> 1037>
1038> 1039> 1040> 1041> 1042> 1043> 1044> 1045> 1046> 1047> 1048> 1049> 1050>
1051> 1052> 1053> 1054> 1055> 1056> 1057> 1058> 1059> 1060> 1061> 1062> 1063>
1064> 1065> 1066> 1067> 1068> 1069> 1070> 1071> 1072> 1073> 1074> 1075> 1076>
1077> 1078> 1079> 1080> 1081> 1082> 1083> 1084> 1085> 1086> 1087> 1088> 1089>
1090> 1091> 1092> 1093> 1094> 1095> 1096> 1097> 1098> 1099> 1100> 1101> 1102>
1103> 1104> 1105> 1106> 1107> 1108> 1109> 1110> 1111> 1112> 1113> 1114> 1115>
1116> 1117> 1118> 1119> 1120> 1121> 1122> 1123> 1124> 1125> 1126> 1127> 1128>
1129> 1130> 1131> 1132> 1133> 1134> 1135> 1136> 1137> 1138> 1139> 1140> 1141>
1142> 1143> 1144> 1145> 1146> 1147> 1148> 1149> 1150> 1151> 1152> 1153> 1154>
1155> 1156> 1157> 1158> 1159> 1160> 1161> 1162> 1163> 1164> 1165> 1166> 1167>
1168> 1169> 1170> 1171> 1172> 1173> 1174> 1175> 1176> 1177> 1178> 1179> 1180>
1181> 1182> 1183> 1184> 1185> 1186> 1187> 1188> 1189> 1190> 1191> 1192> 1193>
1194> 1195> 1196> 1197> 1198> 1199> 1200> 1201> 1202> 1203> 1204> 1205> 1206>
1207> 1208> 1209> 1210> 1211> 1212> 1213> 1214> 1215> 1216> 1217> 1218> 1219>
1220> 1221> 1222> 1223> 1224> 1225> 1226> 1227> 1228> 1229> 1230> 1231> 1> 2>
3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> Creating
'sp_MSadd_repl_commands27hp'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143>
144> 145> 146> 147> 148> 149> 150> 151> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11>
12> 13> 14> 15> 16> 17> 18> 19> 20> 21> Creating
'sp_MSadd_repl_commands27hp_mcit'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143>
144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158>
159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173>
174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187> 188>
189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 1> 2> 3> 4> Creating
'sp_MSvalidate_distpublisher'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 1> 2> 3> Creating
'sp_MSdrop_distribution_agent'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143>
144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158>
159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173>
174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187> 188>
189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> Msg 207,
Level 16, State 3, Server PARSQL, Procedure sp_MSdrop_distribution_agent,
Line 32
Invalid column name 'queue_server'.
1> 2> 3>
Also the paths all exist and OSQL is ok aswell.
"Russell" wrote:

> I am trying to setup a server to be enabled for replication. It is a SQL 2000
> Sp 3a server. The error appears at the end of the wizard as it stepping down
> the entries setting up replication. It gets to configuring Distributor and
> then gives the following error and then drops the distribtuion database. This
> server is a new install running on a cluster.
> Any ideas?
> Error 14113:
> Could not execute ""C:\Program Files\Microsoft SQL Server\80\Tools\binn\osql"
> -E -l60 -t60 -d"distribution" -b -i"C:\Progam Files\Microsoft SQL
> Server\MSSQL\install\insdist.sql" -o"C:\Progam Files\Microsoft SQL
> Server\MSSQL\install\insdist.out"". Check insdist.out in the insall directory.
> 'distribution' is not configured as the distribution database.
> Deleting the distribution transaction log
> Deleting the distribution database file
> The contents of insdist.out are below:
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29>
>
> --
> ----
> ----
> At top, db_name()=
> distribution
>
> (1 row affected)
> 1> 2> 3> 4> 5> 6> 1> 2> 3> 1> 2> DBCC execution completed. If DBCC printed
> error messages, contact your
> system administrator.
> Configuration option 'allow updates' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
> 1> 2> 1> 2> 3> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
> 18> 1> 2> 3> 4> 5> 6> 7> 8>
> Creating distribution tables
> Creating table MSrepl_version
> (1 row affected)
> Creating table MSpublisher_databases
> Creating clustered index ucMSpublisher_databases
> Creating table MSpublications
> Creating clustered index ucMSpublications
> Creating table MSarticles
> Creating clustered index ucMSarticles
> Creating table MSsubscriptions
> Creating clustered index ucMSsubscirptions
> Creating index iMSsubscriptions
> Creating index iMSsubscriptions2
> Creating table MSmerge_subscriptions
> Creating clustered index ucMSmerge_subscriptions
> Creating table MSrepl_transactions
> Creating clustered index usMSrepl_transactions
> Creating table MSrepl_commands
> Creating clusterd index ucMSrepl_commands
> Creating table MSrepl_orginators
> Creating clustered index usMSrepl_originators
> Creating table MSsubscriber_info
> Creating clustered index ucMSsubscriber_info
> Creating table MSsubscriber_schedule
> Creating table MSsnapshot_history
> Creating clustered index ucMSsnapshot_history
> Creating clustered index nc1MSsnapshot_history
> Creating table MSlogreader_history
> Creating clustered index ucMSlogreader_history
> Creating nonclustered index nc1MSlogreader_history
> Creating table MSdistribution_history
> Creating clustered index ucMSdistribution_history
> Creating clustered index nc1MSdistribution_history
> Creating table MSmerge_history
> Creating clustered index ucMSmerge_history
> Creating nonclustered index nc1MSmerge_history
> Creating table MSrepl_errors
> Creating clustered index ucMSrepl_errors
> Creating table MSsnapshot_agents
> Creating clustered index ucMSsnapshot_agents
> Creatingindex iMSsnapshot_agents
> Creating table MSlogreader_agents
> Creating clustered index ucMSlogreader_agents
> Creatingindex iMSlogreader_agents
> Creating table MSdistribution_agents
> Creating clustered index ucMSdistribution_agents
> Creatingindex iMSdistribution_agents
> Creating table MSmerge_agents
> Creating clustered index ucMSmerge_agents
> Creatingindex iMSmerge_agents
> Creating table MSrepl_identity_range
> Creating table MSpublication_access
> Creating clustered index ucMSpublication_access
> Creating table MSqreader_agents
> Creating unique index ucMSqreader_agents
> Creating table MSqreader_history
> Creating clustered index ucMSqreader_history
> Creating table MSrepl_backup_lsns
> Creating clustered index ucMSrepl_backup_lsns
> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36>
> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55>
> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74>
> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93>
> 94> 95> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Dropping all distribution stored procedures
> 1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36>
> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55>
> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74>
> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93>
> 94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109>
> 110> 111> 112> 113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124>
> 125> 126> 127> 128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139>
> 140> 141> 142> 143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154>
> 155> 156> 157> 158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169>
> 170> 171> 172> 173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184>
> 185> 186> 187> 188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199>
> 200> 201> 202> 203> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214>
> 215> 216> 217> 218> 219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229>
> 230> 231> 232> 233> 234> 235> 236> 237> 238> 239> 240> 241> 242> 243> 244>
> 245> 246> 247> 248> 249> 250> 251> 252> 253> 254> 255> 256> 257> 258> 259>
> 260> 261> 262> 263> 264> 265> 266> 267> 268> 269> 270> 271> 272> 273> 274>
> 275> 276> 277> 278> 279> 280> 281> 282> 283> 284> 285> 286> 287> 288> 289>
> 290> 291> 292> 293> 294> 295> 296> 297> 298> 299> 300> 301> 302> 303> 304>
> 305> 306> 307> 308> 309> 310> 311> 312> 313> 314> 315> 316> 317> 318> 319>
> 320> 321> 322> 323> 324> 325> 326> 327> 328> 329> 330> 331> 332> 333> 334>
> 335> 336> 337> 338> 339> 340> 341> 342> 343> 344> 345> 346> 347> 348> 349>
> 350> 351> 352> 353> 354> 355> 356> 357> 358> 359> 360> 361> 362> 363> 364>
> 365> 366> 367> 368> 369> 370> 371> 372> 373> 374> 375> 376> 377> 378> 379>
> 380> 381> 382> 383> 384> 385> 386> 387> 388> 389> 390> 391> 392> 393> 394>
> 395> 396> 397> 398> 399> 400> 401> 402> 403> 404> 405> 406> 407> 408> 409>
> 410> 411> 412> 413> 414> 415> 416> 417> 418> 419> 1> 2> 3> 4> 5> 6> 7> 8> 1>
> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2>
> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15>
> 16> 17> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19>
> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38>
> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57>
> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76>
> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95>
> 96> 97> 98> 1> 2> 3> 4> 5> 6> 1> 2> 3> Creating procedure
> sp_MSislogreaderjobnamegenerated
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
> 98> 99> 100> 101> 102> 103> 1> 2> 3> Creating procedure
> sp_MSisqueuereaderjobnamegenerated
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 1> 2> 3> 4>
> Creating procedure sp_MSissnapshotjobnamegenerated
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 1> 2> 3> 4> Creating
> procedure sp_MSisdistributionjobnamegenerated
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
> 129> 130> 131> 132> 1> 2> 3> 4> Creating procedure
> sp_MSismergejobnamegenerated
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 1> 2> 3> 4> 5>
> 6> 7> 8> Creating 'fn_MSmask_agent_type'.
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 1> 2> 3> Creating 'sp_MScheck_pull_access'.
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
> 129> 130> 131> 132> 133> 134> 135> 1> 2> 3> 4> Creating
> 'sp_MSquery_syncstates'.
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 1> 2> 3> 4> Creating
> 'sp_MSset_syncstate'.
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 1> 2> 3>
> Creating 'sp_MSadd_repl_command'.
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
> 79> 80> 81> 82> 1> 2> 3> 4> Creating 'sp_MSadd_repl_commands27'.
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143>
> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158>
> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173>
> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187> 188>
> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202> 203>
> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217> 218>
> 219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229> 230> 231> 232> 233>
> 234> 235> 236> 237> 238> 239> 240> 241> 242> 243> 244> 245> 246> 247> 248>
> 249> 250> 251> 252> 253> 254> 255> 256> 257> 258> 259> 260> 261> 262> 263>
> 264> 265> 266> 267> 268> 269> 270> 271> 272> 273> 274> 275> 276> 277> 278>
> 279> 280> 281> 282> 283> 284> 285> 286> 287> 288> 289> 290> 291> 292> 293>
> 294> 295> 296> 297> 298> 299> 300> 301> 302> 303> 304> 305> 306> 307> 308>
> 309> 310> 311> 312> 313> 314> 315> 316> 317> 318> 319> 320> 321> 322> 323>
> 324> 325> 326> 327> 328> 329> 330> 331> 332> 333> 334> 335> 336> 337> 338>
> 339> 340> 341> 342> 343> 344> 345> 346> 347> 348> 349> 350> 351> 352> 353>
> 354> 355> 356> 357> 358> 359> 360> 361> 362> 363> 364> 365> 366> 367> 368>
> 369> 370> 371> 372> 373> 374> 375> 376> 377> 378> 379> 380> 381> 382> 383>
> 384> 385> 386> 387> 388> 389> 390> 391> 392> 393> 394> 395> 396> 397> 398>
> 399> 400> 401> 402> 403> 404> 405> 406> 407> 408> 409> 410> 411> 412> 413>
> 414> 415> 416> 417> 418> 419> 420> 421> 422> 423> 424> 425> 426> 427> 428>
> 429> 430> 431> 432> 433> 434> 435> 436> 437> 438> 439> 440> 441> 442> 443>
> 444> 445> 446> 447> 448> 449> 450> 451> 452> 453> 454> 455> 456> 457> 458>
> 459> 460> 461> 462> 463> 464> 465> 466> 467> 468> 469> 470> 471> 472> 473>
> 474> 475> 476> 477> 478> 479> 480> 481> 482> 483> 484> 485> 486> 487> 488>
> 489> 490> 491> 492> 493> 494> 495> 496> 497> 498> 499> 500> 501> 502> 503>
> 504> 505> 506> 507> 508> 509> 510> 511> 512> 513> 514> 515> 516> 517> 518>
> 519> 520> 521> 522> 523> 524> 525> 526> 527> 528> 529> 530> 531> 532> 533>
> 534> 535> 536> 537> 538> 539> 540> 541> 542> 543> 544> 545> 546> 547> 548>
> 549> 550> 551> 552> 553> 554> 555> 556> 557> 558> 559> 560> 561> 562> 563>
> 564> 565> 566> 567> 568> 569> 570> 571> 572> 573> 574> 575> 576> 577> 578>
> 579> 580> 581> 582> 583> 584> 585> 586> 587> 588> 589> 590> 591> 592> 593>
> 594> 595> 596> 597> 598> 599> 600> 601> 602> 603> 604> 605> 606> 607> 608>
> 609> 610> 611> 612> 613> 614> 615> 616> 617> 618> 619> 620> 621> 622> 623>
> 624> 625> 626> 627> 628> 629> 630> 631> 632> 633> 634> 635> 636> 637> 638>
> 639> 640> 641> 642> 643> 644> 645> 646> 647> 648> 649> 650> 651> 652> 653>
> 654> 655> 656> 657> 658> 659> 660> 661> 662> 663> 664> 665> 666> 667> 668>
> 669> 670> 671> 672> 673> 674> 675> 676> 677> 678> 679> 680> 681> 682> 683>
> 684> 685> 686> 687> 688> 689> 690> 691> 692> 693> 694> 695> 696> 697> 698>
> 699> 700> 701> 702> 703> 704> 705> 706> 707> 708> 709> 710> 711> 712> 713>
> 714> 715> 716> 717> 718> 719> 720> 721> 722> 723> 724> 725> 726> 727> 728>
> 729> 730> 731> 732> 733> 734> 735> 736> 737> 738> 739> 740> 741> 742> 743>
> 744> 745> 746> 747> 748> 749> 750> 751> 752> 753> 754> 755> 756> 757> 758>
> 759> 760> 761> 762> 763> 764> 765> 766> 767> 768> 769> 770> 771> 772> 773>
> 774> 775> 776> 777> 778> 779> 780> 781> 782> 783> 784> 785> 786> 787> 788>
> 789> 790> 791> 792> 793> 794> 795> 796> 797> 798> 799> 800> 801> 802> 803>
> 804> 805> 806> 807> 808> 809> 810> 811> 812> 813> 814> 815> 816> 817> 818>
> 819> 820> 821> 822> 823> 824> 825> 826> 827> 828> 829> 830> 831> 832> 833>
> 834> 835> 836> 837> 838> 839> 840> 841> 842> 843> 844> 845> 846> 847> 848>
> 849> 850> 851> 852> 853> 854> 855> 856> 857> 858> 859> 860> 861> 862> 863>
> 864> 865> 866> 867> 868> 869> 870> 871> 872> 873> 874> 875> 876> 877> 878>
> 879> 880> 881> 882> 883> 884> 885> 886> 887> 888> 889> 890> 891> 892> 893>
> 894> 895> 896> 897> 898> 899> 900> 901> 902> 903> 904> 905> 906> 907> 908>
> 909> 910> 911> 912> 913> 914> 915> 916> 917> 918> 919> 920> 921> 922> 923>
> 924> 925> 926> 927> 928> 929> 930> 931> 932> 933> 934> 935> 936> 937> 938>
> 939> 940> 941> 942> 943> 944> 945> 946> 947> 948> 949> 950> 951> 952> 953>
> 954> 955> 956> 957> 958> 959> 960> 961> 962> 963> 964> 965> 966> 967> 968>
> 969> 970> 971> 972> 973> 974> 975> 976> 977> 978> 979> 980> 981> 982> 983>
> 984> 985> 986> 987> 988> 989> 990> 991> 992> 993> 994> 995> 996> 997> 998>
> 999> 1000> 1001> 1002> 1003> 1004> 1005> 1006> 1007> 1008> 1009> 1010> 1011>
> 1012> 1013> 1014> 1015> 1016> 1017> 1018> 1019> 1020> 1021> 1022> 1023> 1024>
> 1025> 1026> 1027> 1028> 1029> 1030> 1031> 1032> 1033> 1034> 1035> 1036> 1037>
> 1038> 1039> 1040> 1041> 1042> 1043> 1044> 1045> 1046> 1047> 1048> 1049> 1050>
> 1051> 1052> 1053> 1054> 1055> 1056> 1057> 1058> 1059> 1060> 1061> 1062> 1063>
> 1064> 1065> 1066> 1067> 1068> 1069> 1070> 1071> 1072> 1073> 1074> 1075> 1076>
> 1077> 1078> 1079> 1080> 1081> 1082> 1083> 1084> 1085> 1086> 1087> 1088> 1089>
> 1090> 1091> 1092> 1093> 1094> 1095> 1096> 1097> 1098> 1099> 1100> 1101> 1102>
> 1103> 1104> 1105> 1106> 1107> 1108> 1109> 1110> 1111> 1112> 1113> 1114> 1115>
> 1116> 1117> 1118> 1119> 1120> 1121> 1122> 1123> 1124> 1125> 1126> 1127> 1128>
> 1129> 1130> 1131> 1132> 1133> 1134> 1135> 1136> 1137> 1138> 1139> 1140> 1141>
> 1142> 1143> 1144> 1145> 1146> 1147> 1148> 1149> 1150> 1151> 1152> 1153> 1154>
> 1155> 1156> 1157> 1158> 1159> 1160> 1161> 1162> 1163> 1164> 1165> 1166> 1167>
> 1168> 1169> 1170> 1171> 1172> 1173> 1174> 1175> 1176> 1177> 1178> 1179> 1180>
> 1181> 1182> 1183> 1184> 1185> 1186> 1187> 1188> 1189> 1190> 1191> 1192> 1193>
> 1194> 1195> 1196> 1197> 1198> 1199> 1200> 1201> 1202> 1203> 1204> 1205> 1206>
> 1207> 1208> 1209> 1210> 1211> 1212> 1213> 1214> 1215> 1216> 1217> 1218> 1219>
> 1220> 1221> 1222> 1223> 1224> 1225> 1226> 1227> 1228> 1229> 1230> 1231> 1232>
> 1233> 1234> 1235> 1236> 1237> 1238> 1239> 1240> 1241> 1242> 1243> 1244> 1245>
> 1246> 1247> 1248> 1249> 1250> 1251> 1252> 1253> 1254> 1255> 1256> 1257> 1258>
> 1259> 1260> 1261> 1262> 1263> 1264> 1265> 1266> 1267> 1268> 1269> 1270> 1271>
> 1272> 1273> 1274> 1275> 1276> 1277> 1278> 1279> 1280> 1281> 1282> 1283> 1284>
> 1285> 1286> 1287> 1288> 1289> 1290> 1291> 1292> 1293> 1294> 1295> 1296> 1297>
> 1298> 1299> 1300> 1301> 1302> 1303> 1304> 1305> 1306> 1307> 1308> 1309> 1310>
> 1311> 1312> 1313> 1314> 1315> 1316> 1317> 1318> 1319> 1320> 1321> 1322> 1323>
> 1324> 1325> 1326> 1327> 1328> 1329> 1> 2> 3> Creating
> 'sp_MSadd_repl_commands27hp6x'.
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143>
> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158>
> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173>
> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187> 188>
> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202> 203>
> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217> 218>
> 219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229> 230> 231> 232> 233>
> 234> 235> 236> 237> 238> 239> 240> 241> 242> 243> 244> 245> 246> 247> 248>
> 249> 250> 251> 252> 253> 254> 255> 256> 257> 258> 259> 260> 261> 262> 263>
> 264> 265> 266> 267> 268> 269> 270> 271> 272> 273> 274> 275> 276> 277> 278>
> 279> 280> 281> 282> 283> 284> 285> 286> 287> 288> 289> 290> 291> 292> 293>
> 294> 295> 296> 297> 298> 299> 300> 301> 302> 303> 304> 305> 306> 307> 308>
> 309> 310> 311> 312> 313> 314> 315> 316> 317> 318> 319> 320> 321> 322> 323>
> 324> 325> 326> 327> 328> 329> 330> 331> 332> 333> 334> 335> 336> 337> 338>
> 339> 340> 341> 342> 343> 344> 345> 346> 347> 348> 349> 350> 351> 352> 353>
> 354> 355> 356> 357> 358> 359> 360> 361> 362> 363> 364> 365> 366> 367> 368>
> 369> 370> 371> 372> 373> 374> 375> 376> 377> 378> 379> 380> 381> 382> 383>
> 384> 385> 386> 387> 388> 389> 390> 391> 392> 393> 394> 395> 396> 397> 398>
> 399> 400> 401> 402> 403> 404> 405> 406> 407> 408> 409> 410> 411> 412> 413>
> 414> 415> 416> 417> 418> 419> 420> 421> 422> 423> 424> 425> 426> 427> 428>
> 429> 430> 431> 432> 433> 434> 435> 436> 437> 438> 439> 440> 441> 442> 443>
> 444> 445> 446> 447> 448> 449> 450> 451> 452> 453> 454> 455> 456> 457> 458>
> 459> 460> 461> 462> 463> 464> 465> 466> 467> 468> 469> 470> 471> 472> 473>
> 474> 475> 476> 477> 478> 479> 480> 481> 482> 483> 484> 485> 486> 487> 488>
> 489> 490> 491> 492> 493> 494> 495> 496> 497> 498> 499> 500> 501> 502> 503>
> 504> 505> 506> 507> 508> 509> 510> 511> 512> 513> 514> 515> 516> 517> 518>
> 519> 520> 521> 522> 523> 524> 525> 526> 527> 528> 529> 530> 531> 532> 533>
> 534> 535> 536> 537> 538> 539> 540> 541> 542> 543> 544> 545> 546> 547> 548>
> 549> 550> 551> 552> 553> 554> 555> 556> 557> 558> 559> 560> 561> 562> 563>
> 564> 565> 566> 567> 568> 569> 570> 571> 572> 573> 574> 575> 576> 577> 578>
> 579> 580> 581> 582> 583> 584> 585> 586> 587> 588> 589> 590> 591> 592> 593>
> 594> 595> 596> 597> 598> 599> 600> 601> 602> 603> 604> 605> 606> 607> 608>
> 609> 610> 611> 612> 613> 614> 615> 616> 617> 618> 619> 620> 621> 622> 623>
> 624> 625> 626> 627> 628> 629> 630> 631> 632> 633> 634> 635> 636> 637> 638>
> 639> 640> 641> 642> 643> 644> 645> 646> 647> 648> 649> 650> 651> 652> 653>
> 654> 655> 656> 657> 658> 659> 660> 661> 662> 663> 664> 665> 666> 667> 668>
> 669> 670> 671> 672> 673> 674> 675> 676> 677> 678> 679> 680> 681> 682> 683>
> 684> 685> 686> 687> 688> 689> 690> 691> 692> 693> 694> 695> 696> 697> 698>
> 699> 700> 701> 702> 703> 704> 705> 706> 707> 708> 709> 710> 711> 712> 713>
> 714> 715> 716> 717> 718> 719> 720> 721> 722> 723> 724> 725> 726> 727> 728>
> 729> 730> 731> 732> 733> 734> 735> 736> 737> 738> 739> 740> 741> 742> 743>
> 744> 745> 746> 747> 748> 749> 750> 751> 752> 753> 754> 755> 756> 757> 758>
> 759> 760> 761> 762> 763> 764> 765> 766> 767> 768> 769> 770> 771> 772> 773>
> 774> 775> 776> 777> 778> 779> 780> 781> 782> 783> 784> 785> 786> 787> 788>
> 789> 790> 791> 792> 793> 794> 795> 796> 797> 798> 799> 800> 801> 802> 803>
> 804> 805> 806> 807> 808> 809> 810> 811> 812> 813> 814> 815> 816> 817> 818>
> 819> 820> 821> 822> 823> 824> 825> 826> 827> 828> 829> 830> 831> 832> 833>
> 834> 835> 836> 837> 838> 839> 840> 841> 842> 843> 844> 845> 846> 847> 848>
> 849> 850> 851> 852> 853> 854> 855> 856> 857> 858> 859> 860> 861> 862> 863>
> 864> 865> 866> 867> 868> 869> 870> 871> 872> 873> 874> 875> 876> 877> 878>
> 879> 880> 881> 882> 883> 884> 885> 886> 887> 888> 889> 890> 891> 892> 893>
> 894> 895> 896> 897> 898> 899> 900> 901> 902> 903> 904> 905> 906> 907> 908>
> 909> 910> 911> 912> 913> 914> 915> 916> 917> 918> 919> 920> 921> 922> 923>
> 924> 925> 926> 927> 928> 929> 930> 931> 932> 933> 934> 935> 936> 937> 938>
> 939> 940> 941> 942> 943> 944> 945> 946> 947> 948> 949> 950> 951> 952> 953>
> 954> 955> 956> 957> 958> 959> 960> 961> 962> 963> 964> 965> 966> 967> 968>
> 969> 970> 971> 972> 973> 974> 975> 976> 977> 978> 979> 980> 981> 982> 983>
> 984> 985> 986> 987> 988> 989> 990> 991> 992> 993> 994> 995> 996> 997> 998>
> 999> 1000> 1001> 1002> 1003> 1004> 1005> 1006> 1007> 1008> 1009> 1010> 1011>
> 1012> 1013> 1014> 1015> 1016> 1017> 1018> 1019> 1020> 1021> 1022> 1023> 1024>
> 1025> 1026> 1027> 1028> 1029> 1030> 1031> 1032> 1033> 1034> 1035> 1036> 1037>
> 1038> 1039> 1040> 1041> 1042> 1043> 1044> 1045> 1046> 1047> 1048> 1049> 1050>
> 1051> 1052> 1053> 1054> 1055> 1056> 1057> 1058> 1059> 1060> 1061> 1062> 1063>
> 1064> 1065> 1066> 1067> 1068> 1069> 1070> 1071> 1072> 1073> 1074> 1075> 1076>
> 1077> 1078> 1079> 1080> 1081> 1082> 1083> 1084> 1085> 1086> 1087> 1088> 1089>
> 1090> 1091> 1092> 1093> 1094> 1095> 1096> 1097> 1098> 1099> 1100> 1101> 1102>
> 1103> 1104> 1105> 1106> 1107> 1108> 1109> 1110> 1111> 1112> 1113> 1114> 1115>
> 1116> 1117> 1118> 1119> 1120> 1121> 1122> 1123> 1124> 1125> 1126> 1127> 1128>
> 1129> 1130> 1131> 1132> 1133> 1134> 1135> 1136> 1137> 1138> 1139> 1140> 1141>
> 1142> 1143> 1144> 1145> 1146> 1147> 1148> 1149> 1150> 1151> 1152> 1153> 1154>
> 1155> 1156> 1157> 1158> 1159> 1160> 1161> 1162> 1163> 1164> 1165> 1166> 1167>
> 1168> 1169> 1170> 1171> 1172> 1173> 1174> 1175> 1176> 1177> 1178> 1179> 1180>
> 1181> 1182> 1183> 1184> 1185> 1186> 1187> 1188> 1189> 1190> 1191> 1192> 1193>
> 1194> 1195> 1196> 1197> 1198> 1199> 1200> 1201> 1202> 1203> 1204> 1205> 1206>
> 1207> 1208> 1209> 1210> 1211> 1212> 1213> 1214> 1215> 1216> 1217> 1218> 1219>
> 1220> 1221> 1222> 1223> 1224> 1225> 1226> 1227> 1228> 1229> 1230> 1231> 1> 2>
> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> Creating
> 'sp_MSadd_repl_commands27hp'.
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143>
> 144> 145> 146> 147> 148> 149> 150> 151> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11>
> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> Creating
> 'sp_MSadd_repl_commands27hp_mcit'.
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143>
> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158>
> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173>
> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187> 188>
> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 1> 2> 3> 4> Creating
> 'sp_MSvalidate_distpublisher'.
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 1> 2> 3> Creating
> 'sp_MSdrop_distribution_agent'.
> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59>
> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78>
> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97>
> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113>
> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128>
> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143>
> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158>
> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173>
> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187> 188>
> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> Msg 207,
> Level 16, State 3, Server PARSQL, Procedure sp_MSdrop_distribution_agent,
> Line 32
> Invalid column name 'queue_server'.
> 1> 2> 3>
|||Is the Distributor the same as the Publisher. Are you choosing the default
options, if so try changing the drive locations for the Data and Log files for the Distribution DB. Can you reinstall the SQL Server again or is this not possible.
Thanks.|||what happens if you issue a command like this through Query Analyzer:
sp_adddistributiondb 'distribution',
@.data_folder='D:\Program Files\Microsoft SQL
Server\Mssql\Data', @.data_file='distribution.mdf',
@.log_folder='D:\Program Files\Microsoft SQL
Server\Mssql\Data', @.log_file='distribution.ldf',
@.log_file_size=50,@.create_mode=1
"Russell" <Russell@.discussions.microsoft.com> wrote in message
news:2D9B7C4B-1ECA-4237-BADC-C5FFEA6F746A@.microsoft.com...[vbcol=seagreen]
> Also the paths all exist and OSQL is ok aswell.
> "Russell" wrote:
2000[vbcol=seagreen]
down[vbcol=seagreen]
and[vbcol=seagreen]
This[vbcol=seagreen]
Server\80\Tools\binn\osql"[vbcol=seagreen]
directory.[vbcol=seagreen]
21>[vbcol=seagreen]
printed[vbcol=seagreen]
17>[vbcol=seagreen]
17>[vbcol=seagreen]
36>[vbcol=seagreen]
55>[vbcol=seagreen]
74>[vbcol=seagreen]
93>[vbcol=seagreen]
contact your[vbcol=seagreen]
17>[vbcol=seagreen]
36>[vbcol=seagreen]
55>[vbcol=seagreen]
74>[vbcol=seagreen]
93>[vbcol=seagreen]
109>[vbcol=seagreen]
124>[vbcol=seagreen]
139>[vbcol=seagreen]
154>[vbcol=seagreen]
169>[vbcol=seagreen]
184>[vbcol=seagreen]
199>[vbcol=seagreen]
214>[vbcol=seagreen]
229>[vbcol=seagreen]
244>[vbcol=seagreen]
259>[vbcol=seagreen]
274>[vbcol=seagreen]
289>[vbcol=seagreen]
304>[vbcol=seagreen]
319>[vbcol=seagreen]
334>[vbcol=seagreen]
349>[vbcol=seagreen]
364>[vbcol=seagreen]
379>[vbcol=seagreen]
394>[vbcol=seagreen]
409>[vbcol=seagreen]
8> 1>[vbcol=seagreen]
1> 2>[vbcol=seagreen]
15>[vbcol=seagreen]
19>[vbcol=seagreen]
38>[vbcol=seagreen]
57>[vbcol=seagreen]
76>[vbcol=seagreen]
95>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
78>[vbcol=seagreen]
97>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
78>[vbcol=seagreen]
97>[vbcol=seagreen]
Creating[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
78>[vbcol=seagreen]
97>[vbcol=seagreen]
113>[vbcol=seagreen]
128>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
78>[vbcol=seagreen]
97>[vbcol=seagreen]
4> 5>[vbcol=seagreen]
21>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
78>[vbcol=seagreen]
97>[vbcol=seagreen]
113>[vbcol=seagreen]
128>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
78>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
78>[vbcol=seagreen]
97>[vbcol=seagreen]
113>[vbcol=seagreen]
128>[vbcol=seagreen]
143>[vbcol=seagreen]
158>[vbcol=seagreen]
173>[vbcol=seagreen]
188>[vbcol=seagreen]
203>[vbcol=seagreen]
218>[vbcol=seagreen]
233>[vbcol=seagreen]
248>[vbcol=seagreen]
263>[vbcol=seagreen]
278>[vbcol=seagreen]
293>[vbcol=seagreen]
308>[vbcol=seagreen]
323>[vbcol=seagreen]
338>[vbcol=seagreen]
353>[vbcol=seagreen]
368>[vbcol=seagreen]
383>[vbcol=seagreen]
398>[vbcol=seagreen]
413>[vbcol=seagreen]
428>[vbcol=seagreen]
443>[vbcol=seagreen]
458>[vbcol=seagreen]
473>[vbcol=seagreen]
488>[vbcol=seagreen]
503>[vbcol=seagreen]
518>[vbcol=seagreen]
533>[vbcol=seagreen]
548>[vbcol=seagreen]
563>[vbcol=seagreen]
578>[vbcol=seagreen]
593>[vbcol=seagreen]
608>[vbcol=seagreen]
623>[vbcol=seagreen]
638>[vbcol=seagreen]
653>[vbcol=seagreen]
668>[vbcol=seagreen]
683>[vbcol=seagreen]
698>[vbcol=seagreen]
713>[vbcol=seagreen]
728>[vbcol=seagreen]
743>[vbcol=seagreen]
758>[vbcol=seagreen]
773>[vbcol=seagreen]
788>[vbcol=seagreen]
803>[vbcol=seagreen]
818>[vbcol=seagreen]
833>[vbcol=seagreen]
848>[vbcol=seagreen]
863>[vbcol=seagreen]
878>[vbcol=seagreen]
893>[vbcol=seagreen]
908>[vbcol=seagreen]
923>[vbcol=seagreen]
938>[vbcol=seagreen]
953>[vbcol=seagreen]
968>[vbcol=seagreen]
983>[vbcol=seagreen]
998>[vbcol=seagreen]
1011>[vbcol=seagreen]
1024>[vbcol=seagreen]
1037>[vbcol=seagreen]
1050>[vbcol=seagreen]
1063>[vbcol=seagreen]
1076>[vbcol=seagreen]
1089>[vbcol=seagreen]
1102>[vbcol=seagreen]
1115>[vbcol=seagreen]
1128>[vbcol=seagreen]
1141>[vbcol=seagreen]
1154>[vbcol=seagreen]
1167>[vbcol=seagreen]
1180>[vbcol=seagreen]
1193>[vbcol=seagreen]
1206>[vbcol=seagreen]
1219>[vbcol=seagreen]
1232>[vbcol=seagreen]
1245>[vbcol=seagreen]
1258>[vbcol=seagreen]
1271>[vbcol=seagreen]
1284>[vbcol=seagreen]
1297>[vbcol=seagreen]
1310>[vbcol=seagreen]
1323>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
78>[vbcol=seagreen]
97>[vbcol=seagreen]
113>[vbcol=seagreen]
128>[vbcol=seagreen]
143>[vbcol=seagreen]
158>[vbcol=seagreen]
173>[vbcol=seagreen]
188>[vbcol=seagreen]
203>[vbcol=seagreen]
218>[vbcol=seagreen]
233>[vbcol=seagreen]
248>[vbcol=seagreen]
263>[vbcol=seagreen]
278>[vbcol=seagreen]
293>[vbcol=seagreen]
308>[vbcol=seagreen]
323>[vbcol=seagreen]
338>[vbcol=seagreen]
353>[vbcol=seagreen]
368>[vbcol=seagreen]
383>[vbcol=seagreen]
398>[vbcol=seagreen]
413>[vbcol=seagreen]
428>[vbcol=seagreen]
443>[vbcol=seagreen]
458>[vbcol=seagreen]
473>[vbcol=seagreen]
488>[vbcol=seagreen]
503>[vbcol=seagreen]
518>[vbcol=seagreen]
533>[vbcol=seagreen]
548>[vbcol=seagreen]
563>[vbcol=seagreen]
578>[vbcol=seagreen]
593>[vbcol=seagreen]
608>[vbcol=seagreen]
623>[vbcol=seagreen]
638>[vbcol=seagreen]
653>[vbcol=seagreen]
668>[vbcol=seagreen]
683>[vbcol=seagreen]
698>[vbcol=seagreen]
713>[vbcol=seagreen]
728>[vbcol=seagreen]
743>[vbcol=seagreen]
758>[vbcol=seagreen]
773>[vbcol=seagreen]
788>[vbcol=seagreen]
803>[vbcol=seagreen]
818>[vbcol=seagreen]
833>[vbcol=seagreen]
848>[vbcol=seagreen]
863>[vbcol=seagreen]
878>[vbcol=seagreen]
893>[vbcol=seagreen]
908>[vbcol=seagreen]
923>[vbcol=seagreen]
938>[vbcol=seagreen]
953>[vbcol=seagreen]
968>[vbcol=seagreen]
983>[vbcol=seagreen]
998>[vbcol=seagreen]
1011>[vbcol=seagreen]
1024>[vbcol=seagreen]
1037>[vbcol=seagreen]
1050>[vbcol=seagreen]
1063>[vbcol=seagreen]
1076>[vbcol=seagreen]
1089>[vbcol=seagreen]
1102>[vbcol=seagreen]
1115>[vbcol=seagreen]
1128>[vbcol=seagreen]
1141>[vbcol=seagreen]
1154>[vbcol=seagreen]
1167>[vbcol=seagreen]
1180>[vbcol=seagreen]
1193>[vbcol=seagreen]
1206>[vbcol=seagreen]
1219>[vbcol=seagreen]
1> 2>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
78>[vbcol=seagreen]
97>[vbcol=seagreen]
113>[vbcol=seagreen]
128>[vbcol=seagreen]
143>[vbcol=seagreen]
11>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
78>[vbcol=seagreen]
97>[vbcol=seagreen]
113>[vbcol=seagreen]
128>[vbcol=seagreen]
143>[vbcol=seagreen]
158>[vbcol=seagreen]
173>[vbcol=seagreen]
188>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
21>[vbcol=seagreen]
40>[vbcol=seagreen]
59>[vbcol=seagreen]
78>[vbcol=seagreen]
97>[vbcol=seagreen]
113>[vbcol=seagreen]
128>[vbcol=seagreen]
143>[vbcol=seagreen]
158>[vbcol=seagreen]
173>[vbcol=seagreen]
188>[vbcol=seagreen]
207,[vbcol=seagreen]
sp_MSdrop_distribution_agent,[vbcol=seagreen]
|||The distributor is the same as the publisher. The only thing that I am
changing from the default is the location of the snapshot folder.
It is a bit akward to reinstall the server as it is a live server in a
cluster. However we are going to try applying service pack 3a again.
"gurnav" wrote:

> Is the Distributor the same as the Publisher. Are you choosing the
> default
> options, if so try changing the drive locations for the Data and Log
> files for the Distribution DB. Can you reinstall the SQL Server again
> or is this not possible.
> Thanks.
>
> --
> gurnav
> Posted via http://www.mcse.ms
> View this thread: http://www.mcse.ms/message1301878.html
>
|||Reapplying SQL SP3 has solved this issue.
"Russell" wrote:
[vbcol=seagreen]
> The distributor is the same as the publisher. The only thing that I am
> changing from the default is the location of the snapshot folder.
> It is a bit akward to reinstall the server as it is a live server in a
> cluster. However we are going to try applying service pack 3a again.
> "gurnav" wrote:
sql

Thursday, March 29, 2012

Error when using SSL encryption for SQL server 2000

Error when using SQL Import / Export Wizard

Error when using SP in data flow

Error when using rskeymgmt to backup encryption key

Error when using rsconfig utility

Error when using rsconfig utility

Error when using more then one comment

Error when using more then one comment

Error when using more then one comment

Error when using 'LIKE'

error when using IIF with sum()

Error when using a stored procedure in OLE DB source

error when using "Referenced" dimension usage against an oracle data source

error when using "Referenced" dimension usage against an oracle data source

Error when upsizing Access 2K Database

Error when updating database

Error when updating bigint columns using ADO

Error when updating

Error when trying to use checkpoint file

Error when trying to update

Error when trying to start Management Studio

Error when trying to start Management Studio

Error when trying to start Management Studio

Error when trying to setup replication

Error when trying to save report in pdf

Error when trying to save or write to table

Error when trying to run database engine tuning advisor

error when trying to restore a sql7 master database

Error when trying to process cube after SP2

Error when trying to open report in VS.NET

Error when trying to modify a table in Sql Server 2005 beta 2

Error when trying to log in to SQL server

Error when trying to filter a table

Error when trying to execute a job from windows service.

Error when trying to enable a server for replication

Error running report

Blog Archive

About Me