| SQL Server (view all ...) | Last Post | Replies |
|
| Orphaned Primary Key Constraint | 02 Sep 2010 23:55 GMT | 6 |
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
|
| Find UnUsed Stored procedure | 02 Sep 2010 23:39 GMT | 2 |
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).
|
| A good database modelling tool | 02 Sep 2010 23:16 GMT | 1 |
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?
|
| Varbinary(Max) Data compression | 02 Sep 2010 23:06 GMT | 2 |
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 ...
|
| Trapping losing commands | 02 Sep 2010 22:47 GMT | 1 |
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 ...
|
| SQLState=S1000, NativeError=0 | 02 Sep 2010 22:39 GMT | 4 |
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
|
| Maintenance Plan and Read Only DB | 02 Sep 2010 20:35 GMT | 1 |
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?
|
| Small DBMS | 02 Sep 2010 20:01 GMT | 1 |
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.
|
|
| MSDE (view all ...) | Last Post | Replies |
|
| MSDE install | 01 Sep 2010 07:35 GMT | 3 |
Can MSDE install on windows 7 Pls advise Michael
|
| SQL Server Import and Export Wizard - export slow after upg to SQL | 13 Aug 2010 21:28 GMT | - |
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 ...
|
| Chi hair straightener, Best Choice | 08 Aug 2010 17:34 GMT | - |
|
| download msdex86.exe | 21 Jul 2010 02:14 GMT | 10 |
how can I download msdex86.exe
|
| Copy / Paste records in SQL server tables? | 04 Jul 2010 22:35 GMT | 1 |
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?
|
| Help with upgrade from SQL 2000 sp3 to 2005 | 25 Jun 2010 22:52 GMT | 1 |
|
| Deleting Blobs -SQL 2005 Express | 06 Apr 2010 03:30 GMT | 5 |
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 ...
|
| How to recover deleted records in transaction log | 29 Mar 2010 17:49 GMT | 7 |
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
|
|
| SQL Server CE (view all ...) | Last Post | Replies |
|
| Command.SetRange + Row Count | 01 Sep 2010 11:29 GMT | - |
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
|
| SSCE losing indexes | 16 Aug 2010 18:29 GMT | - |
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
|
| Re-Use SqlCeResultSet troubles when binding to a DataGrid | 16 Aug 2010 00:51 GMT | - |
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
|
| Problem Opening SDF Database on Desktop | 31 Jul 2010 09:41 GMT | 2 |
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
|
| Compact Edition 3.5 and Service Broker 2005? | 26 May 2010 12:13 GMT | 6 |
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.
|
| Premature EOF for database errors | 20 May 2010 06:51 GMT | 3 |
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.
|
| System.Data.DBConcurrencyException after insert of new row, SQLCE 3.5 SP1/(2?) | 17 May 2010 17:53 GMT | 2 |
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
|
| VS2010, Local Database Template, Error: "...Path is to long. " | 20 Apr 2010 19:39 GMT | 4 |
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:
|