SQL Server Database

Error message while restoring the a SQL database onto a mirror database

I took a backup of my main SQL database, and I have created a new database with the name of MirrorDB. When I tried to restore the main database with NORECOVERY, MirrorDB is constantly listed as "Recovering," and it won't stop. I am getting a message that it is in the middle of the restore and...

Using the snapshot feature in SQL Server 2005 to replicate an operational database

We are trying to keep a replicated copy of a customer’s operational database at our hosting facility. Our copy of their operational system will be used to run ETL against each night to refresh a data reporting database. Our hope is that, each night, we will receive a snapshot file and apply...

Restoring a SQL database with an .mdf file

How can I restore a SQL database with an .mdf file?

Webpage and SQL interaction

The problem I need to figure out is that I need to have client information stored on an SQL server database and I need something to be able to use this information to get quotes from several insurance companies. All these companies require different info in a different order. So my questions are as...

Differences between values in a SQL Server 2005 database

What is the difference between the Checksum and TornPageDetection values of the PageVerify option in a SQL Server 2005 database's properties?

Securing a SQL Server 2008 database

I am on SQL Server 2000, and to secure my database, I want the user to be prompted for a user ID and password before the database is expanded. How might I do this?

os on data base servers

do you need an os on a data base server if you have sql loaded

Backing up SQL Server 2005 databases to a tape drive

I am currently running SQL Server 2005 and I’ve set up a maintenance plan that backs up my databases to the disk. I'd like to change that and backup my databases to a backup tape drive that's attached to a backup server. Can this done, and if so, how?

Connection of VB6 with SQL Server 2000

I want to connect VB6 application with SQL SErver database such that if anything is saved in VB6 forms it will be saved in the database tables of SQL Server.

Error message while querying a linked server SQL database

We have two remote servers, both with SQL Server 2000 databases. An ODBC data source was setup on the first server to point to the SQL Server database on the second server. Also, a linked server was setup on the first server between the SQL Server databases on both server. It was based on the...

Rolling back a SQL Server 2005 database while retaining data added

I have a database that has been running for about six months in SQL Server 2005 on 64-bit Windows Server 2003. There are no backups, but recovery mode is set to full and I have never deleted the log file. I need to rollback to a recent point in time while also retaining data added since that point...

how to delete dup records from a table to ?

basically i want to remove dups in a table. i have a table called productincludes it has a few fields listed here: ParentProductID ChildProductID SummarizedRowID IncludeStatus LastUpdateDate DisplayOrderByID i ran a update for a business request that made many dup rows and want to clean this up....

Sql Server Database doesn't updated

Hello, iam developing an ASP.NET2 Application using SQL Server2005 database, i have updated data from a web page ,the data updated successfuly and displays a meessage that itis updated successfuly , but when i refresh the page or when i display the data from the database ,i found that no changes...

Accessing another database using a variable

I have a select like this: SELECT a.part_id, a.descript, b.location from PART_MASTER a, anotherdatabase.INVENTORY b where a.part_id = b.part_id Is it possible to use a @variable to identify the other database, rather than hard coding it? (I've tried @db2.INVENTORY b) but SQL SERVER 2000 doesn't...

Analyzing Existing Indexes

Hello, I am trying to analyze existing indexes on few tables. I think I can do this by using system views like sys.db_dm_index_usagestats, physicalstats and operationalstats. I am here trying to figure out disk space used by each index, I/O stats ,fragmentation etc I am wondering if ,Apart these...

Storing general files in a SQL Server database

Is it wise to store files such as .doc's or .pdf's as binary objects in a SQL Server database? If there can be issues down the line, is there a way to design the SQL database to make it easier to work with?

Producing a nightly tab delineated file for a SQL Server database

I wish to produce a nightly tab delineated file, based on a recordset, for our SQL Server database. How could I program this to be produced at a specific time each night?

Connect SQL Server 2005 Express db to Visual Basic 2005 Express

I get an error "Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances. I run the store procedure on SQL Server and it looks like it worked, but "Test Connection" gives me the same error. What can I do to resolve this error?

Re-linking database user

Hi Guys, What I am trying to do is relink a database user to a new domain user, and also keeping the same database user name. I am able to do this when I run the following command, and if the database user isn't the same as the login name. use temp alter user TestUser2 with name= TestUser2,...

Using SQL Profiler to identify the cause of data loss

We have a SQL database where a table is having information vanish. We plan to use SQL Profiler to identify the cause of this sudden data loss. When using SQL Profiler, what counters should be captured? Also, what trace format should be used?