Is this the bug in SQL2000?

HI Group
I have shared memory enable on client network utility
on my sql2000 server but every time I restart the service
I will lost my setting even the box still check enable
shared memory but my sql only listen to TCP and Name pipe
Does any one have this same problem ? I must restart the
sql service 4 to 5 times before the sql server listen to
the share memory. Any clue ?
ThanksThe "Client Network Utility" is only used to configure how clients connect.
The "Server Network Utility" controls what connections SQL Server will
accept/listen on. It does not have an option for shared memory, that is
always on unless there is a failure at startup (which would be documented
in the SQL error log).
Which utility are you using? Where are you checking what SQL Server listens
on (check the SQL error log)? What is the actual failure you see?
Hint: To force a client to connect with a certain protocol, include it in
the connection string. If your instance name is MyServer\Inst1, you would
use:
for TCP/IP sockets: tcp:MyServer\Inst1
for shared memory: lcp:MyServer\Inst1
for named pipes: np:MyServer\Inst1
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||HI
I checked in the error log when SQL started
the only TCP and Namepipe is listen by server
then if I use query analyzer on the console
it will connect at TCP protocol
I wolud like to connect client from sql console
using LPC protocol not TCP. Again there is no error
indicated any thing failed on sql startup log but
it only listen to TCP and Name pipe even shared memory
have been checked.
Thanks
>--Original Message--
>The "Client Network Utility" is only used to configure
how clients connect.
>The "Server Network Utility" controls what connections
SQL Server will
>accept/listen on. It does not have an option for shared
memory, that is
>always on unless there is a failure at startup (which
would be documented
>in the SQL error log).
>Which utility are you using? Where are you checking what
SQL Server listens
>on (check the SQL error log)? What is the actual failure
you see?
>Hint: To force a client to connect with a certain
protocol, include it in
>the connection string. If your instance name is
MyServer\Inst1, you would
>use:
>for TCP/IP sockets: tcp:MyServer\Inst1
>for shared memory: lcp:MyServer\Inst1
>for named pipes: np:MyServer\Inst1
>Cindy Gross, MCDBA, MCSE
>http://cindygross.tripod.com
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>|||There is no checkbox to make SQL Server listen on shared memory. I suspect
you're talking about the checkbox that allows a client to connect with
shared memory. Shared memory only works on the same box.
You mentioned that SQL Server is only listening on TCP and named pipes. If
the error log doesn't list shared memory as a protocol it is listening on
then you should check to see if there are other errors, particularly
related to ssnetlib.dll. Can you post your errorlog file?
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.sql

Is this a hack? Is it bad news for me?

Sorry if this is elementary, but while I've been using SQL7 and SQL2000 for quite a while, I'm new to setting up a server.

I am setting up a new testing server, with WinXP Pro and SQLServer2000, amongst other things. After a day or so of tinkering with it, I noticed that when I was offline, (my broadband wont be installed until late Jan, so I'm using a dialup in the mean time) the machine would just start dialling my isp all by itself, including in the middle of the night, when I most definitely have NOT been doing anything on the system. Trying to trace the source of this activity, I have seen in the event viewer that there's a lot of activity in my SQL2000.

I'm particularly interested in a number of items labeled

8128 :
Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.

These have run at a time when I have been in bed asleep and certainly not doing anything on my system. I haven't set up any stored procedures myself yet - this is a brand new SQL2000 installation and hasn't got any live data on it yet.

I'm thinking this is a hack attempt (probably successful). Is there any legitimate reason why SQL2000 should be active when nothing else is on my system? Since this is (or at least WAS) a default installation, is there anything called xp_qv that has a legitimate use?

Should I be suspecting a hack if it's SQL2000 that's trying to dial out to the internet all the time? How else can i find out what's doing it? (All the entries in the WinXP event viewer at this time are related to SQL2000.)

Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.master.dbo.xp_qv is undocumented Microsoft XP
I heard it can be used to find installation type
of SQL Server. No more data ...|||Originally posted by ispaleny
master.dbo.xp_qv is undocumented Microsoft XP
I heard it can be used to find installation type
of SQL Server. No more data ...

So does anyone know how I can find out why SQLServer2000 is waking up at all hours and trying to connect to my isp? Or indeed if it's not SQLServer but something else?

The event viewer shows only SQLServer activity at those hours and now that I have disabled SQLServer, the computer is no longer trying to connect to the internet.

What could be causing this behaviour? I dont want my system just connecting up to the net when it feels like it.

Cheers
Mike Kear
AFP Webworks
Windsor, NSW, Australia.|||MSSQLSERVER can be really used to perform attack on server. There are many SPs and XPs
which can run programs or call COM objects, but I have never seen such an attack yet.

I think, that your server is just badly configured, probably at network level.
MSSQLSERVER is only pinging connection and this is detected as I-net access.|||Turn it off when you're not using it!!

is there anyway to raise a warning from a UDF (in sql2000 and/or in SQL2005)

cos RAISERROR isnt callable, but I really want to indicate a non-fatal warning to be passed back to the client (C++ code)

You are limited to a single output either way dealing with a scalar or table valued function. The only way you could pass back a message of some sort would be to overwrite the scalar return value or add a column to your table return. Neither of those sound particulary appealing but you have few options.|||In SQL Server 2005, you could replace the TSQL UDF with CLR UDF and raise exception in your CLR code. But this is not a pretty implementation and depending on the TSQL code you will get worse performance. So best is to modify the UDF to a SP or just check for absence of row or special value like NULL.

Is there any free tools taht I could read t sql 2005 log files

Hi,
I need to read sql2005 log files. Red gate has sql2000 one for free. I need
sql2005.
any ideas?
thanks
I don't of any free tools. As a matter of fact, they are pretty pricey since
people are usually in a bind when they go looking for them. However, I
believe they are just a gui on dbcc log so you could look into that command.
It is pretty cryptic though.
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>
|||I tried. It desn't really tell me anything.
What I need is that It shows the sql stetement (update, select and delete
ect.. and user name....)
Thanks
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
>I don't of any free tools. As a matter of fact, they are pretty pricey
>since people are usually in a bind when they go looking for them. However,
>I believe they are just a gui on dbcc log so you could look into that
>command. It is pretty cryptic though.
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://feeds.feedburner.com/statisticsio
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
>
|||On Thu, 10 Apr 2008 15:59:48 -0400, Mecn wrote:

> I tried. It desn't really tell me anything.
> What I need is that It shows the sql stetement (update, select and delete
> ect.. and user name....)
> Thanks
The log does not store sql statements. It only stores information regarding
changes that were made to pages in the database (i.e. were rows
inserted/updated/deleted).
Thanks,
Marcel van der Holst
SQL Server Storage Engine Team.
[vbcol=seagreen]
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
|||Pay the money (surprisingly little, actually) for apexsql.com's Log product.
Every production environment should have a tool such as this available for
the 'holy-shit' times. Also helps trememdously during
debugging/troubleshooting scenarios too.
Disclaimer: I work closely with Apex, I use and promote their products to
my clients. If you tell them TheSQLGuru sent you you can pick up a nice
discount (and I will receive a small referral fee). They have a wide array
of very useful SQL Server-specific tools.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>

Is there any free tools taht I could read t sql 2005 log files

Hi,
I need to read sql2005 log files. Red gate has sql2000 one for free. I need
sql2005.
any ideas?
thanksI don't of any free tools. As a matter of fact, they are pretty pricey since
people are usually in a bind when they go looking for them. However, I
believe they are just a gui on dbcc log so you could look into that command.
It is pretty cryptic though.
--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>|||I tried. It desn't really tell me anything.
What I need is that It shows the sql stetement (update, select and delete
ect.. and user name....)
Thanks
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
>I don't of any free tools. As a matter of fact, they are pretty pricey
>since people are usually in a bind when they go looking for them. However,
>I believe they are just a gui on dbcc log so you could look into that
>command. It is pretty cryptic though.
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://feeds.feedburner.com/statisticsio
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
>> Hi,
>> I need to read sql2005 log files. Red gate has sql2000 one for free. I
>> need sql2005.
>> any ideas?
>> thanks
>|||On Thu, 10 Apr 2008 15:59:48 -0400, Mecn wrote:
> I tried. It desn't really tell me anything.
> What I need is that It shows the sql stetement (update, select and delete
> ect.. and user name....)
> Thanks
The log does not store sql statements. It only stores information regarding
changes that were made to pages in the database (i.e. were rows
inserted/updated/deleted).
Thanks,
Marcel van der Holst
SQL Server Storage Engine Team.
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
>>I don't of any free tools. As a matter of fact, they are pretty pricey
>>since people are usually in a bind when they go looking for them. However,
>>I believe they are just a gui on dbcc log so you could look into that
>>command. It is pretty cryptic though.
>> --
>> Jason Massie
>> Web: http://statisticsio.com
>> RSS: http://feeds.feedburner.com/statisticsio
>> "Mecn" <mecn@.yahoo.com> wrote in message
>> news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
>> Hi,
>> I need to read sql2005 log files. Red gate has sql2000 one for free. I
>> need sql2005.
>> any ideas?
>> thanks
>>|||Pay the money (surprisingly little, actually) for apexsql.com's Log product.
Every production environment should have a tool such as this available for
the 'holy-shit' times. Also helps trememdously during
debugging/troubleshooting scenarios too.
Disclaimer: I work closely with Apex, I use and promote their products to
my clients. If you tell them TheSQLGuru sent you you can pick up a nice
discount (and I will receive a small referral fee). They have a wide array
of very useful SQL Server-specific tools.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>