I need to install SQLServer 2000 SP4 on Logshipping Standby server
without dropping the logshipping setup. The source databases are
publishers for transactional replication. How can i upgrade the standby
server to SP4 with standby databases

I would like to do an inplace upgrade (same hardware) from W2K/SQL
2000 to W2K3/SQL2005.
Can this be done successfully and if so can any one direct me to some
documentation.

Is there a way to redistribute the data on the files AFTER you add files to a
filegroup so that it is not lopsided.  I know when you create it from scratch
it distributes them evenly via round robin but how can I split the data
evenly when it is not created from scratch.

Lets say I have a 20 GB TempDB and decide to split it into 4 files based on
having four processors.  This means I would set each file to 5 GB a piece (5
x 4 = 20).  When  running a query that makes use of the TempDB is there a
possiblity of running out of space because one of the ...

A few days ago I planned to use reporting services of SQL Server 2005 SP2.
It was in integrated mode with SharepointServer 2007. I deinstalled
sharepointserver 2007 and wanted to go back to "native mode" in Reporting
Services. While deinstalling Reporting services, I realized a ...

My operation is win2003 ,now ,When I install SQL server 2005 ,My camputer
always appears errors
Product         : SQL Server Database Services
Error           : SQL Server °²×°³ÌÐòÎÞ·¨Á¬½Óµ½Êý¾Ý¿â·þÎñ½øÐзþÎñÆ÷ÅäÖᣠ´íÎóΪ: [Microsoft][SQL Native Client]¹²ÏíÄÚ´æÌṩ³ÌÐò: ³¬Ê±´íÎó ...

i'm trying to test the DB mirror feature under this envinronment:
Windows 2003 Server Enterprise (ITA)
SQL Server 2005 Enterprise (ENG) (version 9.00.1399.06)
The windows servers are without domain and the SQL services run under

I am using SQL express 2005, I loged on as a system admin to create a
maintenance plan. When I expand the management folder to select a new
maintace plan, I see only SQL server log and activity monitor. How can I get
the maintenace plan so that set p my backup scheduale and ...

We created an application on SQL Server 2000.  We backed it up and restored
it to another computer running SQL Server 2005.  The Enterprise manager is
different with regard to DTS for 2005.  According to the Help, we have to
access the Integration Services.  Can someone list the ...

I am having a difficult time deciding which raid option to go with.  Here are
my options.
Option1:
 OS - Raid 1

Does anyone know how to start the turorials?

i got problem with one program which works on sql 2003 server. We backuped
data from other base and created new base on other server. When we try to
connect from client to that base - we cant see our new base in chose base
menu. What can be wrong? Other bases works fine, we can see ...

I have worked with SQL for nearly 15+ years and never had to create and link
tables in that time.  I'm wanting to learn how to do this as I want to
create something for myself.  I need to know how to associate UID's between
tables where the linking or association of the records ...

I know it should be very easy – just following the wizard’s steps and
installation should be ok. It doesn’t work for me this way. No matter what I
do I can’t install instance of server. I had express edition, I uninstalled
it, now I’m trying to install Enterprise, it does install ...

My company plan to move the existing database server (SQL Server 2005
Standard Ed) to a new machine.
The issue we faced is mainly moving the System databases such as master and
Resource database.