SQL Server Database

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...

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...

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.

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?

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?

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...

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.

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...

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?

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?

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?

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?

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?

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 do this?

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, but...

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?

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?

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???

Accessing a mirror database without main database failover

How can I access my mirror database on a SQL Server without a main database failover?

Adding columns and updating a SQL table in a reporting database-

My SQL table contains about 80 columns; it is a reporting database, so I update this table data daily from an application database. I need to add 20 more columns, but when I add for the present job, it is not completing. The present job logic is using a permanent table to get all the records at a...