• Setting a range constraint without a stored procedure in a SQL Server table

    I have a table in SQL Server named CustInfo that is as follows: table CustInfo ( startdate datetime enddate datetime CustomerCode int address nvarchar(200) ) I want to define a range constraint to insure that only one address is allowed for a specific customer in a specific range of dates. For...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000 DTS Designer components are required to edit DTS packages Error even after installing sqlserver2005_dts.msi

    Hi, I am new to Database Technology and was asked to upgrade from MS SQL Server 2000 to 2005. I followed the procedure regarding the upgration found in one of the posts.THe Upgrade advisor says "SQL Server 2000 DTS Designer components are required to edit DTS packages" and In how to resolve this we...

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

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error message while running a report created in SQL Server Report Builder

    I am trying to use Report Model in SQL Server Report Builder, but when I run the created report I am getting the following error: "Cannot create a connection to data source 'dataSource1'. ---------------------------- An error has occurred during report processing." What can I do to avoid this error?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to enable a trace for SQL Server Analysis Services using T-SQL?

    Hi I want to enable a trace on analysis services Filter only the errors and notifications log them in a table and send a mail. I am right now doing using sql profiler, but i dont want to do this using profiler as i have to log on the server continuously. I need to do this in T-sql like an SP or a...

    GIG240 pointsBadges:
  • 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:
  • 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:
  • 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:

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