Deleting in a complicated data structure on SQL Server 2000
I have a complicated data structure on SQL Server 2000 which, at times can go four levels deep. It is all designed using foreign keys, as expected. I am having difficulty getting deletion to work from the top level, which is an orders table. Some child tables have cascade deletes on, and some are dealt [...]

Answer Question   |  March 25, 2009  5:49 PM
SQL Server 2000, SQL Server database, SQL Server tables

How to connect my application using Visual Studio 2005 to a SQL Server database?
how to connect my application using visual studio 2005 to a database using sql server?

Answer Question   |  May 30, 2009  12:27 AM
Database connectivity, Database programming, SQL Server connectivity, SQL Server database, Visual Studio, Visual Studio 2005

Large DB, low capacity line, resync log-shipping options.
Hello, We’ve a large SQL2000 DB which is 335GBs in size and a majority of tables are geographically replicated to a subscriber using transactional replication across a 10Mbit line. We’re going through the process of converting the DBs’ environment to SQL 2005. Unforetunately I think this means we’ll have to re-synch replication (either using snapshot, [...]

Answer Question   |  March 22, 2009  1:53 PM
SQL database replication, SQL Server 2000, SQL Server 2005, SQL Server 2005 Database, SQL Server database

inserting null record in SQLServer2005 SSMEI through ASP.Net
I’m developing my 1st website but when I’m trying to insert data into the SQLServer 2005 it inserting null record. I tried as it is on access. again their is a same problem. Here is my code: Imports System.IO Imports System.Data Imports System.Data.Sql Imports System.Data.SqlClient Public Class contactus Inherits System.Web.UI.Page Protected Sub submit_ServerClick(ByVal sender As [...]

Answer Question   |  March 17, 2009  5:01 PM
SQL Server 2005, SQL Server database

SQL 2000 db transactions/sec
What number of SQL 2000 database transactions/sec would be of concern on a system? Windows Server 2003, 4GB RAM, 2CPU (dual core). Thanks for the guidance.

Answer Question   |  March 11, 2009  2:25 PM
SQL Server 2000, SQL Server database, SQL Server Database Transactions, SQL Server performance, SQL Server performance tuning, Windows Server 2003

Preparing a report on a SQL Server database
I have a SQL Server database of customers that called our company, and now i want to prepare a report that indicates which ones are new to our database. How would I do this?

Answer Question   |  March 4, 2009  7:52 PM
SQL Server database, SQL Server Report Builder, SQL Server reporting, SQL Server Reports

SQL Server 2005 database mirroring over a VPN router
Can SQL Server 2005 database mirroring work if the mirror server is to be in another building with the networks connected via VPN router?

Answer Question   |  February 27, 2009  3:34 PM
Database mirroring, SQL Server 2005, SQL Server database, SQL Server Database Mirroring, VPN routers

SQL Server 2005 SP2 backup failing
This is my first post and thanks in advance for any replies. I have a backup that failed midway (about 120G of 230G) into the backup twice in the last 2 weeks. Each time, the first error that gets reported in the Application log has been, “BackupMedium::ReportIoError: write failure on backup device ‘\server_namedb_dump.bak’. Operating system [...]

Answer Question   |  February 23, 2009  7:54 PM
SQL Server 2005, SQL Server 2005 SP2, SQL Server backup, SQL Server backup and restore, SQL Server database

Error message when restoring a SQL Server database
This error received when restoring a SQL Server database: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 4096MB per database.

Answer Question   |  August 4, 2011  7:16 PM
SQL Server backup and restore, SQL Server database, SQL Server error messages, SQL Server restore

Pulling rows from SQL Server and loading the data into column textboxes
I am trying to load data into 13 column textboxes, and I need the ability to pull any number of rows from the SQL Server based on these parameters: control group number, accounting period and posting date. The results will be about 50 lines of transactions, and I want those loaded to textboxes on my [...]

Answer Question   |  January 27, 2009  7:49 PM
SQL Server, SQL Server database, SQL Server database design and modeling, SQL Server Row Versioning

Hiding the system views table from Microsoft Access
How can you hide the system views table from applications like Microsoft Access? For example, whenever I link to tables in our SQL Server database, INFORMATION_SCHEMA and sys system views are included in the list of tables. This prevents us from finding our tables immediately. How can this be done?

Answer Question   |  December 9, 2009  5:05 PM
Microsoft Access, SQL Server database, SQL Server tables

Changing Compatability Level from 65 to 80
SQL 2000 (sp4) instance with databases at compatibility level of 65 and 80. Is changing the compatibility level from 65 to 80 actually upgrading the database to 80? What should be done before and after changing the Compatibility level?

Answer Question   |  January 11, 2009  6:06 PM
SQL Server 2000, SQL Server 2000 SP4, SQL Server Compatibility Level, SQL Server database

Error when restoring a SQL Server 2005 database
Every time I restore one of my SQL Server 2005 databases to a point in time, my log shipping restore job fails on my secondary server. Any ideas on how to correct this?

Answer Question   |  December 20, 2008  7:41 PM
Log Shipping, SQL Server 2005, SQL Server database

Corrupting database in an VB.NET application in SQL Server 2005
I have a application in VB.NET with SQL Server 2005 Express Edition. In the last few days, the database is continuously corrupting. I repair it, but the problem continues. I revise my code, but I can’t find transactions errors that could produce the problems. Do you have any general ideas?

Answer Question   |  December 23, 2008  7:40 PM
SQL Server 2005, SQL Server database, VB.NET

Connecting to SQL Server from an Oracle procedure
We need to pull data from a SQL Server database, and our database is Oracle. How would I connect to SQL Server from an Oracle procedure?

Answer Question   |  December 9, 2008  9:08 PM
Oracle, SQL Server database

Combo box question when developing a SQL database in Visual Basic 6
I am developing a SQL database using Visual Basic 6 with ADO and Microsoft Access, but in it, I have a combo box with two options – yes and no. I want the combo box, after yes or no is selected, to open another form where a user can enter other details. How would I [...]

Answer Question   |  December 5, 2008  6:20 PM
ADO, Microsoft Access, SQL Server database, Visual Basic, Visual Basic 6

Need help…My Sql server 2000 has error
My Sql server 2000 has error when created a new database or create a new table in my database. There is the error : “[Microsoft SQL-DMO(ADBC SQLState : 42000)] – Cannot use empty object or column names. Use a single space if necessary” I think my SQL server 2000 was created a no name database, [...]

Answer Question   |  December 4, 2008  4:41 PM
SQL Server 2000, SQL Server database, SQL Server errors

What data should I index in a SQL database?
When advice is given to only index on selective data in a SQL database, would you therefore index on a four digit integer (ID number) or a patient’s name, for example? Would this make sense logistically?

Answer Question   |  December 2, 2008  4:31 PM
SQL Server database, SQL Server Database Indexing

Backing up and upgrading a SQL Server 2000 database
We have a database of around 3GB on SQL Server 2000 Standard Edition. What is the quickest way to backup the database at minimal cost, and how much time would it take to upgrade this database to SQL Server 2005?

Answer Question   |  December 2, 2008  2:51 PM
SQL Server 2000, SQL Server 2005, SQL Server backup, SQL Server database, SQL Server upgrades

DataBase Restore
I’m working with SQL Server 7 and I made a backup from a DataBase and I need to restore it, but this error appear: “The RAID set for database is missing member number 1″. What can I do???

Answer Question   |  December 2, 2008  2:00 PM
RAID, SQL Server 7.x, SQL Server database, SQL Server database restore, SQL Server errors