• How to push the Database into deadlock state?

    Hi, We are doing Database FailOver testing (DBFO). As part of this, we want to check if primary db is in deadlock state then what happens? whether the transactions will go to back up db or not? How to get the primary db into deadlock state? Appreciate your help.

    Saimadhu455 pointsBadges:
  • How to import Microsoft Access to SQL Server 2005

    hi, while i am importing database MS-Access to sql server 2005 its could not importing its Showing like this: The operation could not be completed. Additional information: -> Not a valid password.(Microsoft JET Database Engine) What to do? can you give the solution. Thanks, Deepa

    Deepatss5 pointsBadges:
  • SQL 2005 32 bit – SQL 2005 64 bit

    Moving from SQL 2005 32 bit - SQL 2005 64 bit. What are the problems which can be faced during this move.

    Vani175 pointsBadges:
  • Database SQL

    During the copy paste the old data (*.MDF and *.Ldf) with current data same files. When going to open database showing error like " server: msg 945,level 14,state 2 database 'vimalind'cannot be opened becouse some of the files could not be activated." How can rectify this... Pls tell me ..

    SAP Cum IT35 pointsBadges:
  • SQL select

    SELECT obj.object_type FROM apps.opt_log_issue log, discov.opt_changed_database_objects obj WHERE --(UPPER(log.resolution(+)) like '%'||obj.object_name||'%' -- and trunc(log.resolution_date(+)) - trunc(to_date(substr(obj.last_ddl_time,1,11),'dd-mon-yy')) <=5 -- and trunc(log.resolution_date(+))...

    QAQA65 pointsBadges:
  • SQL Writer

    SQL Writer library failed initialization. Your installattion iseither corrupt or has been tampered with. Please uninstall then re-run setupto correct this problem. How should I handle this?

    Wnic5 pointsBadges:
  • SQL Server database backup (URGENT)

    Hi I have a db backup requirement. As shown in the attached image current system is as follows: There are three source databases such as DB001, DB002 and DB003. Each DB having one table as dbo.EMP and same table schema. Emp table consists of EmpID (PK) and EmpName. One backup database i.e, DBbackup...

    Plugsharma40 pointsBadges:
  • cluster

    what's the steps to use ( Clustering ) in any SQL Server 2005 System??

    ScorpionSQL10 pointsBadges:
  • I want to retrieve always the first record via sql

    I want to retrieve always the first record of a group of records i.e. a history of sold articles, I want to see the date of every first sold article

    Fra90820 pointsBadges:
  • Error message while implementing mirroring between two databases on separate servers

    I've attempted to implement mirroring between two databases on separate servers. The database names are exactly the same but I've been receiving the following error: Alter failed for Database 'databasename'. (Microsoft.SQLServer.Smo) An exception occurredwhile executing a Transact-SQL statement or...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to upload data from Excel into SQL Server 2005

    hi, Please tell me , how can i upload data from excel into SQL2005 thanks & regards Ambrish Srivastav

    Ambrish 82310 pointsBadges:
  • Accessing a mirror database without main database failover

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

    SQL Server Ask the Experts2,585 pointsBadges:
  • Best database replication strategy for a consolidated SQL Server

    What database replication strategy would you employ on a consolidated SQL server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Triggering a stored procedure from C#

    how to tigering a sp from c#???

    Gane10 pointsBadges:
  • Hiding Columns in Report in SSRS

    How can I hide or show columns based on a parameter in SQL Server Reporting Services.

    Jamisoe10 pointsBadges:
  • SQL query to select highest test score

    I am writing a sql to bring someone's highest test score into a table. The sql is bringing in the highest test score possible, rather than the person's test score. I assume MAX is making that happen. If I take MAX out, it returns the single row subquery returns more than one row error. What can I...

    Cmyers40 pointsBadges:
  • Backing up and copying a database across SQL Servers

    I have SQL Sever 2005 on both servers A and B, although I do not have SQL Studio Manager on server A. I would like to backup a SQL database from server B onto server A, and then copy it over to server B and restore it to the same database. How would I go about doing this?

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

    SQL Server Ask the Experts2,585 pointsBadges:
  • Two programs with separate SQL Databases

    I have one program that uses an SQL database and I want to install a different program that also uses an SQL database on the same machine. Will this cause a problem? Why or why not?

    Cstanley25 pointsBadges:
  • Configuring a password message prompt on SQL Server 2000

    On SQL Server 2000, how can I make it so that the server will prompt me for a password when I am click on my database through Enterprise Manager?

    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