• SQL Server Database Restore

    When i restore a database from server1 to server2 as stand by/read-only mode the database restores with a database owner "domainrmartinez". How can i restore a database from server1 to server2 and the database owner as "sa"?

    Rick Martinez585 pointsBadges:
  • Adding data in SQL 2005 server

    i am trying to add data on an sql database from backend problem is it does not acceptnull values kindly help. My email address is edmuia@yahoo.com

    Zippyyepee15 pointsBadges:
  • SQL Server Database Date Time Values

    I am developing a software using Date Time values. i am using SQL server 2000 as the database. can i create a coloumn with only time value or data value. Only datetime is available. how can i eliminate a part of it in the database. when inserting the time values the date part is 01 jan 1900. i want...

    RAYNISH35 pointsBadges:
  • SQL Server error: Cannot find log file

    I am receiving the error, "cannot find log file." I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql in C#

    How can I attach And detach a database file to sqlserver in C# code ? please give me an example of this

    Sajjadzare5 pointsBadges:
  • Shrinking a SQL Server database

    What is the best way to shrink a database? What are the alternative methods?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up SQL Server 2008 databases to a tape drive

    I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?

    Phrathepmali30 pointsBadges:
  • Linked SQLServer

    Hi, In oracle database you are able to link the oracle database to a SQLServer 2005 database, I want to be able to link a SQLServer 2005 another SQLServer 2005 database (not another SQLServer 2005), does SQLServer 2005 allow us to do this? Does it only allow server to server linking? Thanks.

    Db23290 pointsBadges:
  • Using SQL Server databases on data with numerous checks

    I am interesting in cleaning census data, and I have a number of edit checks, consistency checks, validation checks and range checks to perform. What is the best practice you would recommend, using SQL Server as the database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backup Performance Compare

    How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.

    0 pointsBadges:
  • 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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    SuperCoolMoss140 pointsBadges:
  • 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...

    Joshi4u5 pointsBadges:
  • 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.

    Labnuke9932,960 pointsBadges:
  • 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 Ask the Experts2,585 pointsBadges:
  • 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...

    Ajf10 pointsBadges:
  • 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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    Rah15 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following