Take the following table...
TABLE_A
id    value
----------

I have SQL 2005 Enterprise 64bit running on Windows 2003 64bit. I ran
sp_configure to show advanced options. When I try to execute RECONFIGURE it
fails stating that ad hoc updates to the system catalogs are not allowed.
Any ideas?

is there a way to copy a table from database A to database B?
I use sql server 2005 express and Management Studio.
Thanks
Albert

Dear Friends,
Dear Friends,
I would like to write a stored prcedure which reads data from one
table and inserts into different table.

I feel sure its a simple question but can someone give me the correct syntax
to alter a column to enable a unique constraint.
I thought the following would work
alter table tabname alter column colname add constraint constname unique

SQL Server 2005:
Our database is set to autogrow which has resulted in fragmentation of the
.mdf file across the disk.  If we restore the database from a .bak file to
the identical location over the existing database, would this maintain the

i made a database 'mydb' in sql server 2005 express and a backup of it
'mydb.bak'.
I changed some tables, indexes etc ... in the database and made a new backup
of this new version of 'mydb' but before that, i changed the previous backup

A scheduled job failed yesterday.  We would like to know where can we find
the error message of that failed job ?  From view history, it gives us part
of the message but truncated (due to limited space).
Thanks

Hi! How to check that SQL Server 2005 Express is installed in a system?
I want to create a small program that will create or modify a specific
database for my software. How do i check for the existance of the sql
server? Then prompt the user if he wants to set up sql server ...

Is it possible we set a default location ONLY for all log files of user
databases?
Thanks,
Felipe

Is it a good practice separate master.mdf and master_log.ldf in different
drives?
If yes, how?
Thanks,

I setup an Integrity and Optimization job to be ran once a week on one
of my SQL 2005 Servers.  The job failed over the weekend.
This is the output that I get:
NEW COMPONENT OUTPUT

Win2k3 2-Node Active/Passive config cluster
SP2 Win2k3 and SQL2005 SP2
2 small questions
1) SQL is writing events into the Application Log. I am not too sure how to

environment sqlserver 2000 SP4 enterprise
SAN -Virtual Array storage
I have a database which has 3 datafiles under one filegroup(not on
primary) and one log file. two of those data file size is around 30GB

Is there another forum with more traffic about SQL 2008?
Thx,
J.