I have a few tables that store data about a remote control aircraft.
These tables that I am working on now contact the components that are
on a specific aircraft. If the user decides to change some components,
they basically create a new configuration, and then store the new

This question has probably been asked before, but I can't find an answer.
Simple question: How do I go about backing up an SQL Server 2005 database,
and then restore a SINGLE table from that back up?
Thanks in advance for any help.

I'm trying to upgrade my SQL version from Standard to Enterprise using
SKUUPGRADE=1 and once the process is done and I run SELECT
SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition') to verify the version, I'm still seeing either

I'm trying to create a report with Crystal reports on a Windows Vista
machine. When i try to add the Database ,which is on a windows server 2003,
using a Oledb connection i'm getting the following error.
[dbnetlib][ConnectonOpen(Connect()).]Sql server does not exist or access

Does SQL Server 2005 Developer Edition place any limits on database size ?

I have both sql 2000 and sql2005 installed on a machine and with management
studio it seems to show the databases created in 2000 but does not seem to
have many of the new features of 2005.  It seems as though it is not
operating against a SQL Server 2005 installation although ...

I have created a view SS on the Person.Address table in AdventureWorks
database, taking addressid and a substring of the addressline1 column. Next,
I created an index on it. Both the index 3 of person.address (on some
address fields), and the indexed view are not (heavily) ...

I have a script that configures a database as I need it.
Here is a little bit of it:
CREATE TABLE [Albums] (
[AlbumID] [int] IDENTITY (1, 1) NOT NULL ,

OK - so I have a number of test users and each user is to have dbo
access to multiple databases, no big deal as I just map this user to
the databases and provide the dbo role..
My question is, what database should be used as the default? Should

I am trying to use the copy database wizard to move a database from SQL 2000
to SQL 2005.  The dbo user for the database is linked to
[domain]\Administrator.  Unfortunately I cannot copy the database because the
[domain]\Administrator account was renamed a couple of years ago, ...

I created a table with two columns as below
Id-int,
EmpName-Varchar(20).
Create table test1(Id int,empname varchar(20))

I am getting the “Invalid column name” error when creating a table valued
function.  It is true that the column does not exist in the table however the
logic used within the function will not allow the table to be queried until
the table has been modified.  Is there any way of ...

Hi
I am running SQL Server 2005 and have found a procedure with appears to
compile ok even though the syntax is looking for a database that does not
exist. How does this sp compile without error?

is there a query I can use to list all running values?
I can right click on a server object and see all properties of that
server but I want them all gathered in a file
thnx

I have a weird problem here that I'm trying to understand. My setup is
a replication one with 2 servers, says S1 and S2 in Domains A & B
which are non-trusted. The authentication mode is set to mixed on both
servers, all the services (Agent, SQL, etc.) are running as Local