I need to restore a backup of a db in SQL 2005 with 80-compatibility level
into SQL Server 2000. I have tried to do it but I have an error. Is it
possible to do it?
Does exist another fast method to bring a SQL Server 2005 db into 2000?

I want to retrive the licensing information such as Licensing count, which
licensing is currently in use, whats its type (per processer or per user),
licensing code etc. From where i can retrive the information? I want to do it
for Sql Server 2005 and 2000. I read the blog ...

I have a problem with the xp_cmdshell stored procedure on SQL Server
2005.
I've allowed its execution on the databases which require it, using
the sp_configure 'show advanced options' and sp_configure

Is there a best practice in determining whether MSDE installed on a
workstation or if SQL Express is installed?  The SQL Express installs
are all with the default named instance of .\SQLExpress, but it's not
otherwise generally known as to which version is present.

Can someone point me to the right direction?
I need to synchronize data updates in relational schema with data in it's
flat (denormalized) equivalent in near real time mode.
What is the best way to achieve this if using triggers is not an option ?

When I use the import Wizard in SQL-2005 I get the following message:
TITLE: SQL Server Import and Export Wizard
------------------------------
Error 0xc002f210: Preparation SQL Task: Executing the query "" failed

I have a database which has logical fragmentation in some of the tables.
I have scripts that now will run an update_statisitics with fullscan on all
the objects.
I also have a job that perfroms a dbcc dbreindex on the indexes if the

I have an x86 version of SQL Server 2005 installed on an x64 Windows Server
box.
Which SQL Server SP2 do I install?  The x86 one or the x64 one?

Hi
I need to provide following information:
1. Size of all the current databases on all sql server (2000 and 2005). Is
these a query I can use to get this information.

SQL server 2000
When i select size of files using sql server using
"select name,filename,size from sysaltfiles" I get size of files as
File one size: file1.mdf = 4976

We are using 2 CPUs which are quad core. We have one SQL 2000 License with
1CPU license.
The queries are  slow when upgraded to SQL 2000, We thought of upgrading to  
2 CPU license, Before buying we increased the SQL Proccessor usage to two the

we have a field under nText which contains both text and RTF text!(database
design and app are by another company, no way to modify them)
simple select query returns normal values under text data, but when it is
RTF we get unnecessary info such as:

Our weekly maintenance plan takes up so much RAM on our Windows Server 2003  
with service pack 2 (2 GB of RAM) that we have to reboot the server the next
day in order to free up the RAM.
Besides adding more RAM, is there anything else that can be done to

I want to pull records from a "Column" within a "Table".  I recall in the
past doing a:
SELECT COUNT "n" FROM .... (This is where I am lost!).
I am hoping to pull the contents of the column in a table.

SQL Server 2005 sp2
Windows Server 2003
I have a scheduled stored proc that executes Bulk Insert.  It works
fine.  Agent runs under a domain, sys admin account.  I know, I know,