I am new to MSSQL and I was set up to access this server so I can store data
in it, either through ColdFusion or MS Access. Not sure about the version of
MSSQL.
My problem: Among other fields, I have two similar fields which are numbers

I have a table with just 75,000 rows that has 1 column as the PK. When I
attempted to run the rebuild command (either through a maintenance plan or
directly running the sql, the process would run many hours (6-8) and
sometimes it did not end at all. This locks the table so that ...

Does each DSN connection to SQL 2005 use a CAL? What is the best way to
monitor CAL and connection usage?
Thanks for the input

I'm having issues with my db backup mp - it looks like all my system db's
have multiple users connected..thing is this plan runs at 9:00 PM and no one
is connected at that time...
error msg's below:

Data appears to be missing in over 10 SQL tables in a database on our SQL
2005 server.  Here are the facts:
1.    The data missing is from 3/31/2008 to 6/9/2008
2.    The data was in the table on 6/9/2008 as we have reports that show data

SQL Server 2000 SP4.
I have this problem. I have a text column coming out in Some data Extract
for a client.
They need us to remove (replace) the carriage control characters in the

After power failure i have this error when try to attach DB
this is the command
sp_attach_db MYDB','S:SQLDB\MYDBnew.mdf','S:\SQLDB\MYDB_lognew.ldf'
and this is the error:

All,
I am still trying to find some script or set of actions that will
prove the best practice of having 1 data file for each processor on a
multi processor box.  Any help or direction is greatly appreciated!

We currently use BrightStor/Arcserve as our backup software which includes
the option to use either their own database product or use Microsoft's SQL
server.
In September 2007 I decided to switch and place the database on the SQL 2005

SQL Server 2005, Excel 2003
I would like to populate some tables in a SQL database from some tables in
Excel.
Previously I have used the Concatenate function in Excel to construct SQL

Hi.
I am working with an account that has limited access to the SQL server.
Using Sharepoints API, I am opening a list on a web, and get the following
error.

We have an server that runs SQL Server 7 on an NT system. One database has
processes running that are not documented. I have written triggers to report
any deletions, inserts or updates made against the database's tables. All I
can report is that an insert, update or delete has ...

I have just updated an existing SQL Server Express server to SQL Server
Developer Edition 9.0.1399. In general this has worked fine, but I cannot
create a Maintenance Plan, either using the Wizard or by using "New
Maintenance Plan..." The latter brings up a dialog saying that:

When I ran SQL Profile on one of SQL 2005 server, it captured a lot of
sp:Recompile ( 2  Statistics changed) anf they all belong to the same
statement in the same SP. The statement is just a SELECT statement join 3
table and a temp table, could the statistics of one joined table ...

Is there a tool or a way to save off the specs for a SQL Server
failover cluster?  I have and SQL 2000 cluster environment that I need
to rebuild to SQL 2005 and would like to save of the current config
specs for reference.  You know, resource specs such as ip addresses