I try to install SP1 for SQL 2000, W2K server.
I get an error: MSVCR&!.DLL not found.
How can I fix it so i can go on with the installation?

2 instances SQL2005, 1 instance SQL2000.
We have set the max memory to 500MB on the SQL2005 and 512MB on the SQL2000.
the SQL 2000 maintains between 480MB and 500MB, but the memory keeps creeping
up daily past the 500MB Max setting on the SQL 2005 . Currently the Memory is

My first problem is one that has come up before, but I have yet to see
a suitable (read: one that fixes the problem for me) answer to it.
When I try to increase the size of one of my databases, I get the
following error:

The 3 kinds of replication for SQL2000 compare to log shipping.
My question is,
1. log shipoping needs to kill all connections before restore log file to a
standby box --- not good for using of reporting and other data lookup

Hello, I have a live database and a test database on my sql 2000. I need to
restore a backup of my live database to my test database. I want to make sure
I have all the settings correct in Enterprise manager. This is what I have
set.

I have a database (SQL 2005) that is used internally and the various
internal user's applications can access the tables, views, stored
procedures, etc.  Note that the owner on all objects within the db is 'dbo'
They want an external user to access specific data in the database ...

A couple of more questions oh mighty SQL admins! What do the
following command(s) do? Is this one command or several different
ones? And can I execute this in the same manner as the previous
command (OSQL)?

Should an Integrity Checks job that exludes indexes be casuing the tempdb to
grow substantially during execution?
Any help greatly appreciated!
Thanks in advance.

Is there a way to set up a sql server so that a querry run against database 1
on SQL server1 can pull data from databse 2 on sql server 2 as if database 2
existed on sql server 1?
I though I had seen a feature to link a sql server to see the databases

hi, SQL transactional replication.
Can i have triggers in standby db not in production so the standby server
could do some jobs and it won't use prod resource?
Thanks

I don't know if this is possible and I couldn't understand what Books Online
says about this (there's a surprise!), but...
Is it possible to declare a variable (not an input or output parameter)
inside a table-valued function? I need to make the select statement dynamic,

I have a column of int data type consisting of values such as 10001, 9657 and
2389 in a sql server database. How can I convert these to values of 100.01,
96.57 and 23.89 in Transact-sql? Thanks.

Can't find "Other data source" as an option in the "SQL Import Wizard"  ->
"Data source" drop down list on our MS SQL 2005 server (64-bit).
Anyone know how I'll get it back or installed? Is it "user" dependent?
Kind regards

Not sure this is the correct forum or not, but it related to SQL server
I had one PB8 (8.0.2.9506) program that FAIL to connect to two
different untrusted domain where the SQL version is SQL2K.
I able to connect it using SQL enterprised manager at the same PC and

I have a .sql file which contains several stored procedures used for report
generation, and I know how to insert/import it into sql server database by
Management Studio.
My question is how can I do the same action using command line syntax, like