is it possible to make a duplicate of a table (with another name of course)
with a command like 'copy' or 'duplicate' or ...?
Thanks
Chris

I'm a little bit confused about index and 'order by'.
1) when doing 'order by' in a select statement, the table is sorted, even if
no index is defined. How does sql server then sort the table?
2) does an index (non clustered) sort data or it's only used for retrieving

I am working a SQL Server that was improperly upgraded.
The person who installed SQL 2005 blew away the SQL 2000 installation and
just restored the database to a new installation of SQL 2005.
Now, DBCCs result in the following error message. How does one repair this

I've put this in setup since it seems setup/config has been corrupted.
I'm getting several MMC errors, the most problematic is not being able to
run EM on my dev box!  I get "mmc could not create the snap-in" and a red x.  
This happens in my custom consoles, as well as a straight ...

I understand TS is not supported by SQL 2005 in any type of clustering.  But
can SQL 2005 be installed on a TS (it is in application mode) as a single TS
and single instance of SQL 2005 (no clustering of either)?
TIA

I have a problem with SQL server being very slow to access and use while I'm
backing up transaction logs. I'm backing up the logs every half hour, and it
makes the whole thing run so slowly it's driving the users nuts. It puts the
application into a spin while the logs are being ...

Can someone guide on the following SQL Server setup error?
Installation details:-
SQL Server 2005 Std. Edition
Non-default instance

We are currently running SQL version 6.5 and are planning to install another
application that requires SQL 2000 to be installed on the same server. May I
know is it possible to have two version running concurrently and what are the
things to take note?

I have never built a SQL Server before.  Is it possible to install a
full version of SQL Server 2000 on top of Windows Server 2003 (one
server for an application and database server)?  If so, are there any
tricks to it or would I simply install Server 2003 first then install

I am having a hard time monitoring performance counters related to SQL
Server.  The installed OS is Windows Server 2003 64-bit.  The edition of SQL
Server 2005 is 32-bit.  I am only able to see the SQL specific counters when
I run System Monitor with the mmc /32 switch on the ...

We have a customer whose database now exceeds 8 GB in size. They have 30
concurrent users running a VB application that we wrote that calls Stored
Procedures for all queries/updates. They are running SQL Server Standard
edition on a Windows 2003 Server with 8-way Zeon processors ...

How can I exactly idetify if SP2 is installed?
For example: Is anywhere on www.microsoft.com translate table between
MS-SQL property "Version" and identification of SP?

I do not have the option to install SSIS on a fresh SQL 2005 setup or as an
addition after the install. Is there anything I am missing?

I performed an in-place upgrade from SQL 2k to SQL2k5 last night.
Everything worked well, but I was a little surprised that the dbs were left
in 8.0 compatibility mode.  Is this on purpose, or did I miss a checkbox
somewhere that would have upgraded the dbs to 9.0 compatibility ...

I have a few Maintenance tasks that I'd like to copy the entire task and
then tweak just a bit.
Is there an easy way to copy the entire task??
Thanks,