I found there is a sql 2000 server with OS 2000 has multiple databases with
identical structure in one instance. Each database is used by one client. Is
this good idea? They are sharing one tempdb and tempdb is used very heavily.
I was told this server is 2 Cpus quad core, does ...

It seems that it is not possible to backup a database on SQL Server 2008 and
restore it back again on SQL Server 2005.
The database is originally coming from the same SQL Server 2005 and it is in
SQL 2005 compatibility format.

I threw a query thats was taking time to delete records at the DB tunning
advisor (SQL 2005 standard).
It suggested the creation of the following non-clustered index:

After my mssql 2005 server hit the roof in disk space all my maintenance
plans dissappeared. I find them in jobs, in history i can see the jobs go
successfully but there is no history of each maintenance plan anymore.
When i try to create one with the same name, it reports it ...

I have the following script. Why can't i use @tbname when doing drop
or create?
Thanks,
Lorenzo

I have a main SP that is scheduled using SQL Agent. This SP calls other SPs
in a transaction block. The other SPs just inserts data into NBIFeed table.
Code is
Create Procedure SP_Main

We currently use this code to backup our database:
BACKUP DATABASE [my_db] TO
 DISK = N'E:\SQL Backups\my_db_Backup.bak',
 DISK = N'F:\SQL Backups\my_db_Backup.bak'

I am hoping some of your talented minds can help me with a query.  I
have two tables that look like this.
Table1
UID--NAME--PROGRAM--COMPANY

For my application, I need to show previous changes (like who change it,
their comments,changedate etc.) for the particular record .  For that
purpose, i need to
Concatenating Row Values into single variable.

The Dutch training center Twice tells on the website that you should do 2
exams to upgrade the SQL 2005 MCITP DBA to SQL 2008 MCITP DBA.
On the Microsoft website
(http://www.microsoft.com/learning/mcp/mcitp/sql/2008/default.mspx) I read

I have a Windows Server 2003 Enterprise Edition 64-bit machine with SQL
Server 2005 64-bit Ent. Edition instances in Microsoft Cluster (2 node,
active/passive).  The system is a Quad-Core, Quad-Proc HP530 G5 with 20GB of
RAM, Paging set to 1.5 times.

I wanted to purchase Microsoft SQL 2005 Server Standard Edition to
install into Windows 2003 Server, as the DB for accpac.
I logged onto amazon and saw two products...
1)

      I am using openrowset to import from a csv file. Here is the
code
INSERT INTO [surveymonkeytest82608].[dbo].[Respondents]
SELECT * FROM OPENROWSET ('MSDASQL', 'Driver={Microsoft Text Driver

Can someone help me in understanding the Protocol Layer in SQL Server?
As far as i know, it's the TCP/IP and is used to communicate with external
app/systems, and access to SQL is possible through these protocols. Any more
info will be helpful.

Hi Friends,
I am using SQL  Developer Edition SP2. My problem is that in
taskmanager it is showing, sqlserver.exe is increasing unusually and
it continues to grow and server showing network error. I have to