Error 165 - Sql state Hy000

Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupo
Pupo
take a look at following article:
http://support.microsoft.com/default...b;en-us;811889
Also ,check your SQLAgent service and make sure the account is right.
"Pupo" <123star@.libero.it> wrote in message
news:%2310q9c34FHA.2548@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have Sql 2000 Server Sp4 with two instances from some day the Sql server
> agent of second instance don't start and i can't do automatically backup.
> In Sql log i try Error 165, error odbc [sql state HY000]
> Can help me to risolve this problem.
> Tia pupo
>

Error 165 - Sql state Hy000

Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupoPupo
take a look at following article:
http://support.microsoft.com/defaul...kb;en-us;811889
Also ,check your SQLAgent service and make sure the account is right.
"Pupo" <123star@.libero.it> wrote in message
news:%2310q9c34FHA.2548@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have Sql 2000 Server Sp4 with two instances from some day the Sql server
> agent of second instance don't start and i can't do automatically backup.
> In Sql log i try Error 165, error odbc [sql state HY000]
> Can help me to risolve this problem.
> Tia pupo
>

Error 165 - Sql state Hy000

Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupo
Pupo
take a look at following article:
http://support.microsoft.com/default...b;en-us;811889
Also ,check your SQLAgent service and make sure the account is right.
"Pupo" <123star@.libero.it> wrote in message
news:%2310q9c34FHA.2548@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have Sql 2000 Server Sp4 with two instances from some day the Sql server
> agent of second instance don't start and i can't do automatically backup.
> In Sql log i try Error 165, error odbc [sql state HY000]
> Can help me to risolve this problem.
> Tia pupo
>

Error 165 - Sql state Hy000

Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupo
Pupo
take a look at following article:
http://support.microsoft.com/default...b;en-us;811889
Also ,check your SQLAgent service and make sure the account is right.
"Pupo" <123star@.libero.it> wrote in message
news:%2310q9c34FHA.2548@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have Sql 2000 Server Sp4 with two instances from some day the Sql server
> agent of second instance don't start and i can't do automatically backup.
> In Sql log i try Error 165, error odbc [sql state HY000]
> Can help me to risolve this problem.
> Tia pupo
>
sql

Error 15633

Hi
I get this error on my Full-Text population job
Full-text auto propagation is currently enabled for
table '[dbo].[tablename]'. [SQLSTATE 42000] (Error 15633
Does anyone have any idea on this ?
There is not information on Net on this, so your input
will be highly appreciated.
Thanks
Thyagu
Thyagu,
Can I assume you are using SQL Server 2000? Could you post the full output
of SELECT @.@.version -- as this can be very helpful in understanding SQL
FTS issues.
For your table "tablename", is Change Tracking enabled?
Regards,
John
"thaygu" <pgthyagu@.hotmail.com> wrote in message
news:b45801c4374c$120ed2a0$a501280a@.phx.gbl...
> Hi
> I get this error on my Full-Text population job
> Full-text auto propagation is currently enabled for
> table '[dbo].[tablename]'. [SQLSTATE 42000] (Error 15633
> Does anyone have any idea on this ?
> There is not information on Net on this, so your input
> will be highly appreciated.
> Thanks
> Thyagu

Error 14294 in replication

Hi
I have a server with Windows 2000 Server SP4 and SQL 2000 with SP3.
This server has several published databases that they replicate data to
another server.
All the replications is of transactional type.
When creating to publish another database it leaves me the following error:
Error 14294
Supply either @.job_id or @.job_name to indentify the job.
That I can make to correct the problem?
Thank you
are you or have you deployed the other publications using a script?
If you, you must use unique publication names and ensure that you don't
specify a snapshot agent name, log reader agent name, or distribution agent
name.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Mario" <Mario@.discussions.microsoft.com> wrote in message
news:C083E5F7-8740-4ACC-B73E-51B6B35FCE62@.microsoft.com...
> Hi
> I have a server with Windows 2000 Server SP4 and SQL 2000 with SP3.
> This server has several published databases that they replicate data to
> another server.
> All the replications is of transactional type.
> When creating to publish another database it leaves me the following
error:
> Error 14294
> Supply either @.job_id or @.job_name to indentify the job.
> That I can make to correct the problem?
> Thank you
|||Hi Hilary
I don′t use a script, my publications was created by wizard.
"Hilary Cotter" wrote:

> are you or have you deployed the other publications using a script?
> If you, you must use unique publication names and ensure that you don't
> specify a snapshot agent name, log reader agent name, or distribution agent
> name.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Mario" <Mario@.discussions.microsoft.com> wrote in message
> news:C083E5F7-8740-4ACC-B73E-51B6B35FCE62@.microsoft.com...
> error:
>
>
|||Can you do a Select @.@.SERVERNAME on your publisher and see what server name
it returns? Did you rename this server recently.
There are some reports that this error can be cleared by disabling
replication on your publisher and then recreating it.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Mario" <Mario@.discussions.microsoft.com> wrote in message
news:C083E5F7-8740-4ACC-B73E-51B6B35FCE62@.microsoft.com...
> Hi
> I have a server with Windows 2000 Server SP4 and SQL 2000 with SP3.
> This server has several published databases that they replicate data to
> another server.
> All the replications is of transactional type.
> When creating to publish another database it leaves me the following
error:
> Error 14294
> Supply either @.job_id or @.job_name to indentify the job.
> That I can make to correct the problem?
> Thank you

error 0x80004005 when copying tables between servers

hi
I've got a job which copy tables between different servers .
I am feeding the tables one by one and the process of copying is in a loop so I have cotrol over the copying process.
it works fine but sometimes randomly I am getting

Execution failed with the following error: "ERROR : errorCode=-1071636471 description=SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".

and the process fails and this might happen for in any point and on any table and sometimes it runs all the way successfully!!
any idea what the problem might be!
ThanksDo the tables have exactly the same structure? If not then I'd suggest it is as indicated a simple conversion error due to a type mismatch.|||Yes they are exactly the same is if it isn't it shouldn't run successfully sometimes!|||

Kolf wrote:

Yes they are exactly the same is if it isn't it shouldn't run successfully sometimes!

Unless they aren't the same, but normally the data can be explicitly cast to the destination type. Perhaps, though, that sometimes there is data in the source that cannot be cast.

How do you copy the tables?|||using the SSIS Object trasfer task object, and also I have to mention it is from sql 2000 to 2005
thanks|||

Kolf wrote:

using the SSIS Object trasfer task object, and also I have to mention it is from sql 2000 to 2005
thanks

Can you by chance post the create table statement for your table in SQL Server 2000?

error 0: cannot load the dll, xpstar.dll

hi
i use sql 2000 server and windows 2003 standart server.
i have problem, when i open the database in sql server,
i see this error message
"error 0: cannot load the dll, xpstar.dll .. reason 126"
what can i do?
thankskucuktosbiii (aliyorulmaz2006@.gmail.com) writes:

Quote:

Originally Posted by

i use sql 2000 server and windows 2003 standart server.
i have problem, when i open the database in sql server,
i see this error message
"error 0: cannot load the dll, xpstar.dll .. reason 126"
what can i do?

NET HELPMSG 126 says "The specified module could not be found." That
would indicate that the DLL or a file it depends on is missing.

I search on Google on "XPSTAR" and 126 and found a few hits that
agreed with this diagnosis. The one at
http://forums.microsoft.com/MSDN/Sh...753428&SiteID=1
looks particularly promising.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Error - trying to get only latest

Hi

I'm trying to get some data fra a few tables, but I'm having a few
problems.

What I would like is this:

The tables contain somn info on manuscripts and which process that
manuascript has received.

a manuscript is represented once in manuascript table
that manuascript can have several records in the process table.

What I want is to get data for each manuscript and the last process that
the manuscript received from the process table.

This SQL gets the manuscript for each process it has received. SO if a
manuscript has 5 process records I will get 5 records back...

SELECT
Manuscript.m_id, Manuscript.uniqueIDCountry,
Manuscript.uniqueIDNo, Manuscript.m_title,
Manuscript.country, Manuscript.m_receivedDate,
Process.p_id, Process.m_id, Process.processDate,
ProcessTypes.ps_id, ProcessTypes.processName
FROM
Manuscript,
Process,
ProcessTypes
WHERE [Process].m_id = [Manuscript].m_id
AND [Process].ps_id = [ProcessTypes].ps_id

Please help... I'm getting desperate..

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Try (untested)

SELECT
M.m_id,
M.uniqueIDCountry,
M.uniqueIDNo,
M.m_title,
M.country,
M.m_receivedDate,
P.p_id,
P.m_id,
MAX(P.processDate) AS ProcessDate,
PT.ps_id,
PT.processName

FROM
Manuscript M
LEFT JOIN Process P
ON M.M_Id = P.M_Id
LEFT JOIN ProcessTypes PT
ON P.PS_Id = PT.PS_Id

GROUP BY
M.m_id,
M.uniqueIDCountry,
M.uniqueIDNo,
M.m_title,
M.country,
M.m_receivedDate,
P.p_id,
P.m_id,
PT.ps_id,
PT.processName

I've taken a guess that the max of the ProcessDate from your process
table will give you the last record that you want. You may need to
look at which columns are appropriate for giving you the correct
record, your column names aren't the most helpful hence the guess. The
left join is what you were missing though.

I've not added in anything for your third table and assumed that it is
a stright one to one relationship, but you should easily see how to do
anything further. I've also added some table aliases and tidied things
up a bit to make it easier to read.

Hope that helps

Ryan

Thomas Stark <stark@.newidentity.dk> wrote in message news:<41777eca$0$24956$c397aba@.news.newsgroups.ws>...
> Hi
> I'm trying to get some data fra a few tables, but I'm having a few
> problems.
> What I would like is this:
> The tables contain somn info on manuscripts and which process that
> manuascript has received.
> a manuscript is represented once in manuascript table
> that manuascript can have several records in the process table.
> What I want is to get data for each manuscript and the last process that
> the manuscript received from the process table.
>
> This SQL gets the manuscript for each process it has received. SO if a
> manuscript has 5 process records I will get 5 records back...
> SELECT
> Manuscript.m_id, Manuscript.uniqueIDCountry,
> Manuscript.uniqueIDNo, Manuscript.m_title,
> Manuscript.country, Manuscript.m_receivedDate,
> Process.p_id, Process.m_id, Process.processDate,
> ProcessTypes.ps_id, ProcessTypes.processName
> FROM
> Manuscript,
> Process,
> ProcessTypes
> WHERE [Process].m_id = [Manuscript].m_id
> AND [Process].ps_id = [ProcessTypes].ps_id
>
> Please help... I'm getting desperate..
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Thanks a lot.

Yeah thats pretty much what I was looking for.

I've spent hours trying to sort it out.. Maybe I should try and learn a
bit more SQL..

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Erratic Performance on 5,000,000 records

Hi
I have a mssql 2000 database with 5 mil records in a table and the
performance seems to change from one day to the next from 5 sec result set
returns to 30sec. If i change the index sort order or sometimes move the
position of one of the lines in the "where" statement then it improves to 5
sec only to change the next day or two to 30 sec again.
Other variables like loading on the server, db etc are constant - it;s a
test system still so no users hitting DB.
Simple things like changing the position of the "null" condition below
improved things yesterday but today it's slow (3 sec to 30sec).
eg:
WHERE (@.DEPTCODE IS NULL OR CL.DEPTCODE = @.DEPTCODE)
worked well yesterday after being the other way around but now does not.
(This is for a param that could be passed thru as null or with a value)
Thanks
MikeHi,
According to information you provide i can only say that
WHERE (@.DEPTCODE IS NULL OR CL.DEPTCODE = @.DEPTCODE)
is not SARGABLE. It will perform Index Scan instead of Index Seek. If you're
index will grow or get fragmented you will have more costs.
Did you run this code in Stored Procedure?
I recommend you to use Dynamic SQL or if this is a SP then use wrapper sp
according to parameter passed to sp .
Many of the programmers using this kind of code but this type of usage is
easy to write for programmers but bad for performance.
Hope this helps.
"Mike C" wrote:

> Hi
> I have a mssql 2000 database with 5 mil records in a table and the
> performance seems to change from one day to the next from 5 sec result set
> returns to 30sec. If i change the index sort order or sometimes move the
> position of one of the lines in the "where" statement then it improves to
5
> sec only to change the next day or two to 30 sec again.
> Other variables like loading on the server, db etc are constant - it;s a
> test system still so no users hitting DB.
> Simple things like changing the position of the "null" condition below
> improved things yesterday but today it's slow (3 sec to 30sec).
> eg:
> WHERE (@.DEPTCODE IS NULL OR CL.DEPTCODE = @.DEPTCODE)
> worked well yesterday after being the other way around but now does not.
> (This is for a param that could be passed thru as null or with a value)
> Thanks
> Mike
>
>|||Try using isnull(CL.DEPTCODE,'') = isnull(@.DEPTCODE,'')
"Mike C" wrote:

> Hi
> I have a mssql 2000 database with 5 mil records in a table and the
> performance seems to change from one day to the next from 5 sec result set
> returns to 30sec. If i change the index sort order or sometimes move the
> position of one of the lines in the "where" statement then it improves to
5
> sec only to change the next day or two to 30 sec again.
> Other variables like loading on the server, db etc are constant - it;s a
> test system still so no users hitting DB.
> Simple things like changing the position of the "null" condition below
> improved things yesterday but today it's slow (3 sec to 30sec).
> eg:
> WHERE (@.DEPTCODE IS NULL OR CL.DEPTCODE = @.DEPTCODE)
> worked well yesterday after being the other way around but now does not.
> (This is for a param that could be passed thru as null or with a value)
> Thanks
> Mike
>
>|||Again this will perform index scan ..
(Assuming you have an index on DEPTCODE column)
"Saket" wrote:
[vbcol=seagreen]
> Try using isnull(CL.DEPTCODE,'') = isnull(@.DEPTCODE,'')
> "Mike C" wrote:
>|||If column DeptCode does not contain NULLs, then you can use the
following statement. It assumes DeptCode is of datatype varchar. If is
of a different data type, then post back.
WHERE CL.DeptCode LIKE COALESCE(@.DeptCode,'%')
Hope this helps,
Gert-Jan
Mike C wrote:
> Hi
> I have a mssql 2000 database with 5 mil records in a table and the
> performance seems to change from one day to the next from 5 sec result set
> returns to 30sec. If i change the index sort order or sometimes move the
> position of one of the lines in the "where" statement then it improves to
5
> sec only to change the next day or two to 30 sec again.
> Other variables like loading on the server, db etc are constant - it;s a
> test system still so no users hitting DB.
> Simple things like changing the position of the "null" condition below
> improved things yesterday but today it's slow (3 sec to 30sec).
> eg:
> WHERE (@.DEPTCODE IS NULL OR CL.DEPTCODE = @.DEPTCODE)
> worked well yesterday after being the other way around but now does not.
> (This is for a param that could be passed thru as null or with a value)
> Thanks
> Mike

Erratic Performance on 5,000,000 records

Hi
I have a mssql 2000 database with 5 mil records in a table and the
performance seems to change from one day to the next from 5 sec result set
returns to 30sec. If i change the index sort order or sometimes move the
position of one of the lines in the "where" statement then it improves to 5
sec only to change the next day or two to 30 sec again.
Other variables like loading on the server, db etc are constant - it;s a
test system still so no users hitting DB.
Simple things like changing the position of the "null" condition below
improved things yesterday but today it's slow (3 sec to 30sec).
eg:
WHERE (@.DEPTCODE IS NULL OR CL.DEPTCODE = @.DEPTCODE)
worked well yesterday after being the other way around but now does not.
(This is for a param that could be passed thru as null or with a value)
Thanks
Mike
Hi,
According to information you provide i can only say that
WHERE (@.DEPTCODE IS NULL OR CL.DEPTCODE = @.DEPTCODE)
is not SARGABLE. It will perform Index Scan instead of Index Seek. If you're
index will grow or get fragmented you will have more costs.
Did you run this code in Stored Procedure?
I recommend you to use Dynamic SQL or if this is a SP then use wrapper sp
according to parameter passed to sp .
Many of the programmers using this kind of code but this type of usage is
easy to write for programmers but bad for performance.
Hope this helps.
"Mike C" wrote:

> Hi
> I have a mssql 2000 database with 5 mil records in a table and the
> performance seems to change from one day to the next from 5 sec result set
> returns to 30sec. If i change the index sort order or sometimes move the
> position of one of the lines in the "where" statement then it improves to 5
> sec only to change the next day or two to 30 sec again.
> Other variables like loading on the server, db etc are constant - it;s a
> test system still so no users hitting DB.
> Simple things like changing the position of the "null" condition below
> improved things yesterday but today it's slow (3 sec to 30sec).
> eg:
> WHERE (@.DEPTCODE IS NULL OR CL.DEPTCODE = @.DEPTCODE)
> worked well yesterday after being the other way around but now does not.
> (This is for a param that could be passed thru as null or with a value)
> Thanks
> Mike
>
>
|||Try using isnull(CL.DEPTCODE,'') = isnull(@.DEPTCODE,'')
"Mike C" wrote:

> Hi
> I have a mssql 2000 database with 5 mil records in a table and the
> performance seems to change from one day to the next from 5 sec result set
> returns to 30sec. If i change the index sort order or sometimes move the
> position of one of the lines in the "where" statement then it improves to 5
> sec only to change the next day or two to 30 sec again.
> Other variables like loading on the server, db etc are constant - it;s a
> test system still so no users hitting DB.
> Simple things like changing the position of the "null" condition below
> improved things yesterday but today it's slow (3 sec to 30sec).
> eg:
> WHERE (@.DEPTCODE IS NULL OR CL.DEPTCODE = @.DEPTCODE)
> worked well yesterday after being the other way around but now does not.
> (This is for a param that could be passed thru as null or with a value)
> Thanks
> Mike
>
>
|||Again this will perform index scan ..
(Assuming you have an index on DEPTCODE column)
"Saket" wrote:
[vbcol=seagreen]
> Try using isnull(CL.DEPTCODE,'') = isnull(@.DEPTCODE,'')
> "Mike C" wrote:
|||If column DeptCode does not contain NULLs, then you can use the
following statement. It assumes DeptCode is of datatype varchar. If is
of a different data type, then post back.
WHERE CL.DeptCode LIKE COALESCE(@.DeptCode,'%')
Hope this helps,
Gert-Jan
Mike C wrote:
> Hi
> I have a mssql 2000 database with 5 mil records in a table and the
> performance seems to change from one day to the next from 5 sec result set
> returns to 30sec. If i change the index sort order or sometimes move the
> position of one of the lines in the "where" statement then it improves to 5
> sec only to change the next day or two to 30 sec again.
> Other variables like loading on the server, db etc are constant - it;s a
> test system still so no users hitting DB.
> Simple things like changing the position of the "null" condition below
> improved things yesterday but today it's slow (3 sec to 30sec).
> eg:
> WHERE (@.DEPTCODE IS NULL OR CL.DEPTCODE = @.DEPTCODE)
> worked well yesterday after being the other way around but now does not.
> (This is for a param that could be passed thru as null or with a value)
> Thanks
> Mike