I'm finalizing a backup strategy for a production SQL Server with several
databases.  I intend to use the same setup for several new production SQL
Servers.  Please let me know if there are any "holes" in this plan or if you
have any suggestions.

Does anyone know how to track the actual execution plan the server uses? I
have one query designed for a frequently run report that normally takes about
3 seconds to return. However, the Profiler logs show me that in certain
cases, it took more than 3 minutes to return and it ...

I have a quick question about renaming an instance.
I used sp_dropserver and dropped the instance name
I used sp_addserver '<servername>, 'local' and changed the local instance
name.

Is it possible to change the default collation on SQL2L post install, and if
so how?

Hello. I'm having problems moving a database from SQL 7 to SQL 2000. The way
I did it was copy the .mdf and .ldf files over to SQL 2000. Both SQL servers
are using different computer names. But I'm missing some views, stored
procedures, jobs, and user accounts. I'm assuming this ...

Periodically our server gets into a "state", typically because Access died
with a query running. The result is a blocking process, typically on a
heavily used table.
In theory I should just kill that process, but it never works. I click on it

We are on SQL Server 7.00.1063 (SP4) and Windows 2000 5.00.2195 (SP4).
I had to reboot our server this AM as SQL Server was not responding.  It
seems to be fine, now.  
Afterward, I reviewed the Windows 2000 Server Log in Event Viewer and ran

i want to set up a SQL server with 4 hd
c:\ --> OS & SQL servedr
d:\ Mirror of C:\
e: data files

Hi, All.
I am wondering if anyone has seen this error before:
dbcc checkdb ("EMIOPER")
Server: Msg 2574, Level 16, State 1, Line 1

I support a server that has over 200 databases on 1 instance.  Each database
is about 2 megs.  Does anyone know how I can automate a script that will
increase the size to 500 megs for ALL DBs.  I want to run this script during
the evening hours.

I know If I store the DTS packages in SQL Server it will be stored in the
msdb database.
Also all the job scheduling information is stored in the msdb database.
Even though I am taking backup of system databases, I would like to know if

I need help with stored procedure, where do I post my question? The
question is related to syntax and how to so it is not really fit in this
topic.
Thanks

I have Sql Server 200 Entreprise (FR) running under win XP (FR) sp2. I had
never install previous sql service pack. I have tried to install sp4 using
SQL2000-KB884525-SP4-x86-FRN.EXE and SQL2000.AS-KB884525-SP4-x86-FRN.EXE.
After I reboot and still show the older version when I'm ...

Does anybody know how SQL server behaves when below event is logged? Will it
stop or only part of its functionality will become unavailable?
Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
full. Back up the transaction log for the database to free up some ...

Differential and Transaction backup restore.
I have scheduled differential backup to run at 3PM and the transactional
backup to run at 3pm. In the event of data restore work, should I restore
the data from differential as well as transactional backups.