Instance/sqlservr.exe problem

Hi! I have SQL 2000 server with several instance. Every instance start own
sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
time, but I don't know to which instance it belongs?
regards, Tomatoma
DBCC MEMORYSTATUS on the both instances
"toma" <toma@.kolumbus.fi> wrote in message
news:ab32h.43057$8W7.25630@.reader1.news.jippii.net...
> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100%
> CPU time, but I don't know to which instance it belongs?
> regards, Toma
>|||From Task Manager, you can find the process ID of the sqlservr.exe process.
If the ProcessID column is not displayed, Go to Views -> Select Columns...
and click on PID.
In the errorlog of a SQL instance, the process ID of that instance is
reported at the beginning of the errorlog. Alternatively, you can query the
process ID of the instance with SERVERPROPERTY('ProcessID').
Linchi
"toma" wrote:
> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
> time, but I don't know to which instance it belongs?
> regards, Toma
>
>|||You can get the PID you see in Task Manager by executing the
following on an instance:
SELECT SERVERPROPERTY('ProcessID')
-Sue
On Wed, 1 Nov 2006 17:37:38 +0200, "toma" <toma@.kolumbus.fi>
wrote:
>Hi! I have SQL 2000 server with several instance. Every instance start own
>sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
>time, but I don't know to which instance it belongs?
>regards, Toma
>

Installing Sql25k client without using CD/DVD?

Hi everyone,

We've found some problems when trying such thing. It seems that is compulsory to do via own CD/DVD.

Any comment would be very appreciated.

Thanks in advance,

enric

How are you trying to do the install? If you share out the DVD/CD to a network drive and maintain the folder structures from the media, you should be able to install just fine.

Thanks,
Sam Lester (MSFT)

|||

Yes, be sure to follow the instructions in this KB, and you should be able to install from a network path or from a hard drive.

http://support.microsoft.com/kb/916760/en-us

|||Thanks for that.sql

Installing sql25k client without using CD

Hi everyone,

We've found some problems when trying such thing. It seems that is compulsory to do via own CD/DVD.

Any comment would be very appreciated.

Thanks in advance,

Please use setup forum to get attention of the right people
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1

Installing SQL service on its own

We Managed to install the MSDE system but it did not
install the SQL service again.
Is there a way to setup a MSSQL SERVER service manually on
Windows NT4.
Many Thanks
ITS Support
hi again,
"ITS Support" <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:047b01c4dec3$effb0150$a501280a@.phx.gbl
> We Managed to install the MSDE system but it did not
> install the SQL service again.
> Is there a way to setup a MSSQL SERVER service manually on
> Windows NT4.
> Many Thanks
> ITS Support
what problems are raised and reported in the installation log text file?
search for
RETURN VALUE 3
about 10/15 lines before or after each entry a description of the problem(s)
is reported
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

integrate report manager in an asp.net application

I thought I can probably find out how the report manager works and create a similar application so that I can define my own things in there.

Looks like there is no sample where I could get a lead. Now I have decided if I can include the report manager in a new aspx page in my application and disable the stuff which is not required by the user to look at it.

I can definitely include the report manager url in the Iframe but how do I disable the stuff from the report manager.

Please help, I am having real hard time.

Thanks in advance.

There is no way that I know of to customize report manager and include its functionality in your own app like you would a control.

Have you looked at the report viewer web control? If you need to integrate report viewing and report export capability in your asp.net application, it is very powerful. You could use this, along with the available Web services in reporting services to build your own version of the report manager in asp.net with most, if not all of the same functionality.

A link to the report viewer control:

http://msdn2.microsoft.com/en-us/library/ms251671(VS.80).aspx

A link to the web services provided by report server:

http://msdn2.microsoft.com/en-us/library/ms154697.aspx

integrate report manager in an asp.net application

I thought I can probably find out how the report manager works and create a similar application so that I can define my own things in there.

Looks like there is no sample where I could get a lead. Now I have decided if I can include the report manager in a new aspx page in my application and disable the stuff which is not required by the user to look at it.

I can definitely include the report manager url in the Iframe but how do I disable the stuff from the report manager.

Please help, I am having real hard time.

Thanks in advance.

There is no way that I know of to customize report manager and include its functionality in your own app like you would a control.

Have you looked at the report viewer web control? If you need to integrate report viewing and report export capability in your asp.net application, it is very powerful. You could use this, along with the available Web services in reporting services to build your own version of the report manager in asp.net with most, if not all of the same functionality.

A link to the report viewer control:

http://msdn2.microsoft.com/en-us/library/ms251671(VS.80).aspx

A link to the web services provided by report server:

http://msdn2.microsoft.com/en-us/library/ms154697.aspx