I have to call stored precedure in C#.net where i have to use one stored
procedure in another, so how is it possible?

my sql2000 manual says that sql server minimises vm swapp [thus de-creasing
overall memory usage swapp+phys] trying to dedicate disk i/o mostly to
database access.
but what if swapp is not located on same drive as database files are?

SQL 2000 is installed with 5 per device CALs. Looking to convert to 2
per processor licensing. How do we convert from per device to per
processor licensing? I hope that doesn't require reinstallation.

[sql2000]
i want to put tempdb on some realy fast device, but device is limited with
size.
my question is how to determine the maximum size temdb may grow [since it

We have a server setup as Raid 1 for the OS C drive
and Raid 5 for the Datafiles and transaction logs D drive.
We have a 3rd party app that creates lots of temporary tables and slows the
server down,

I've been trying without success to install SQL 2005 Express Edition.
In the preliminary examination of my system, it passes all the tests
except hardware requirements.
- Minimum Hardware Requirement (Warning)

I am trying to install SP4 to an SQL 2000 Cluster (currently sp3a) running
on Windows 2003 (sp1). It fails with an error "Setup failed to perform
required operations on the cluster nodes" and I have tried everything in
every article I can find, but it still fails. Here is the log ...

Following are the system requirements stated by Microsoft, and my
configuration.  Why am I getting a warning that requirements have not been
met:
Required:    Processor    600-megahertz (MHz) Pentium III-compatible or faster;

The documentation from Microsofts Express SQL is incorrect. I have two
machines running xp pro with 512 megs, enuf hd (over 10gigs), 1ghz processor
for both, and everything the lousy documents can throw at me. but i still
simply get "hardware requirements warning",.. plz see ...

I was trying to install MS SQL Server 2005 Express edition. First, I get the
following warning:
"The current system does not meet the recommended hardware requirements for
this SQL server release."

I have SQL Server 2000 at my XP SP2 box.
Can SQL Server 2005 (Express edition) be installed without affecting the
existing SQL Server 2000?
Thanks.

Is there a way to force Sql Server Express to install on XP Pro SP1?

Just a note. The SP2 CTP BOL says September 2006 rather than the advertised
November 2006.
Chris

I tried to do "in place upgrade to sql server 2005" on virtual server.
The install went fine no errors but I couldn't find the client tools:
ex: Microsoft Sql Server 2005 Mangement Studio
I can see only the followings Under Programs\Microsoft SQL Server

Can you upgrade SQL Server 7.0 to SQL Server 2005?
And, if so, could someone please post for me here some links to
documentation on how to do so?
Thanks!