I have a database that has somehow become corrupt in that there is a primary
key constraint in sysobjects that is no longer connected to the table (The
parent_object_id is invalid).
I am having diffciulty removing\reattaching this constraint, any ideas on

I have lots of unused SP in my DB and i'd like to delete them.
I need to find them.
How can I know that a Stored procedure is not used. (with the tables i look
at the DMV).

I am looking for a good database modelling tool in order to design an
sql server database.
What is about VISIO and which version is the best?

I need to compress hudge files (PDF + TIFF) stored in a varbinary field. I
found in BOL that :" Because of their size, large-value data types are
sometimes stored separately from the normal row data on special purpose
pages. Data compression is not available for the data that is ...

In our applications once in a while the commands don't get through to the SQL
Server for different reasons. Since it is an automatic process there is
nobody in the front end to rerun those command, and they are getting lost.
The rezones for the lost could be: Time out, broken ...

I am trying to use the BCP command to execute the following statement, but I
keep getting the following error:
Starting copy...
SQLState = S1000, NativeError = 0

I'd like to use a Maintenace plan to run DBCC + Update Statistics on my DBs,
but since i have one DB which is Read Only it stacs on that DB.
What can I do?

I'm looking for a small DBMS to hold one data table with 10 columns (one of
them is the data - varchar(max) avg is 1000 chars) and another few reference
code tables.
The data table has ~1M recs.

Can MSDE install on windows 7
Pls advise
Michael

We are using SQL Server Import and Export Wizard to export from a view to a
flat file.  This export worked in under 20 seconds in SQL Server 2005 SP3 but
after we upgraded to SQL Server 2008 SP1 the same export will take up to 2
hours or more.  Also it appears to dominate one CPU ...

how can I download msdex86.exe

Is it possible to copy records from one SQL server table, while the table is
open inside the management studio express, and paste the records in another
table in the same or different database?

Do I just run setup.exe?

I'm on the verge of exceeding the 4GB limit on a database.  The program we
use has 2 databases, the first is customer transactions, the second is a
historical database containing images of customer ID's.  Each time a customer
shows his ID it is updated in the transaction DB and the ...

I have a question regarding how to to read the database transaction log? The
purpose is to recover any accidentally deleted records in tables.
The technical environments are as follow:
•    Database version                             : MSDE 2000 SP4

I would like to know how to get the row count of a SqlCeResultSet when
using the SetRange - Option. If said option is not used, I just issue
a second Command.ExecuteScalar with "SELECT COUNT(*) FROM 'table'" (+
where clause if neccessary, and with Text / TableDirect depending on

I'm having an issue where indexes and primary keys are disappearing
from tables in a SQLCE 3.0 database.  There is nowhere in the program
where I'm explicitly dropping indexes.  All data transactions are via
a common connection either through a command object or a resultset.  I

I try to rewrite our application to make use of SqlCeResultSet instead
of DataTable. I try to reuse SqlCeResultSet objects as much as
possible. I have the following problem:
I have a result set which I use for searching. Basically, the user can

I have copied the SDF (SQL Compact Edition) file to the desktop.   I
remember writing code to open to this file, but I can't remember how I did
it.   So, here is what I am doing:
Dim oConn As OleDb.OleDbConnection

I'm seeking for ideas on how to design a mobile data acquisition
architecture in the world of Windows CE 6 as mobile OS, Windows Server
2003/2008 as server OS, SQL Compact Edition 3.5 on the mobile device and
SQL Server 2005 Standard on the server.

We are having a problem with SQL Server compact reporting the error:-
25047-  "OS Error: SQL Server Compact encountered a premature EOF for the
database file. Running the repair utility might help recover some data."
This problem is currently stopping our project going to beta.

I knocked up a very quick database editing program using C# 2008 express.
I had my database which has an integer autonumber ID, and a bunch of other
text fields.
I then built a simple form with a DataGridView, and a couple of stray edit

Hello,
I get the following error message in VS2010, while adding a new item to the
project with template "local database":
"An error occurred while retrieving the information from the database: