• i want to change the true bits to false and vice versa

    i have a table where i have true and false bits..i need to replace the true bits to false and vise versa

    Sam535 pointsBadges:
  • HOw do I restore a database from a backup in MS SQL Server 2000

    I have no knowledge of MS SQL Server. Have software (BOOMI) that uses a database in this. I found a folder where the database is being backed up. i.e. there is a *.BAK file and hourly logs *.TRN. I need to update the boomi software and they say I need to make a back up of the database. If this is...

    Arlocoder50 pointsBadges:
  • Flush the query plan from the RAM.

    Our clients are reporting that the sql server is slowing down over a period of time. Once the SQL Server is restarted everything is fine.SQL server slowing down over a period of time though has technical reasons. SQL server caches (in memory) the queries that are sent it to, expecting to reuse it...

    MNA20 pointsBadges:
  • SQL and Moss 2007 from Jameel Ur Rahman (Abbottabad)

    hi, I recently done Moss 2007 certification . an di want to know the relation of SQL and Moss 2007 , and also let me know for Moss 2007 implemention how i prepaer my self regarding SQL because SQ L new for me any book or white paper that help me and also SQL 2005 Administration thanks jameel

    Jameelrk5 pointsBadges:
  • jobs runing on the server

    hi every 1, i am having a real tough time to figure this one out . i need to find out what jobs are schedule in the server that sends data out to ever . we are doing the migration from 2000 to 2005 and need to know which jobs send data to the another server . i looked at the sysjobs_view , it tells...

    deal11deal110 pointsBadges:
  • Connect to Sybase ASE 15 via MS SQL 2005

    I'm in a test phase and would like to connect to a Sybase ASE 15 server in much the same way as linking tables in access. How would I accomplish that?

    Bhassel25 pointsBadges:
  • Migrate an Oracle database to SQL2005

    I need to migrate an Oracle database to SQL2005. How many users have done this and what tool did you use? How effective was it? I know Microsoft has a migration tool, but just want to cover my bases as this is a very high profile project. Thanks all!!

    mnman66265 pointsBadges:
  • how to get list of encrypted objets in sqlserver 2005?

    i need a list of encrypted store procedure name,encrypted trigger ,encrypted functions from sql server 2005.

    Subrata735 pointsBadges:
  • Home Network Configuration SQL Express 2005

    Hello, I am pretty new to Sql. I had setup a SQL Express 2005 Advanced on a computer w/ xp on it before and had no problems. I recently purchased a installed a new computer (the other one died) w/ Windows Vista. As before, I downloaded and configured Sql Express per instructions for the software...

    Ddog06295 pointsBadges:
  • Scheduling a DTS Package

    Hi On MS Windows Server 2003 I have a DTS Package in SQL Server Enterprise Manager. The DTS package runs fine in SQL Server Enterprise Manager. How do I add that DTS package as a scheduled task? Thanks P

    Pmwhelan5 pointsBadges:
  • How to install a passive node on an active/active SQL Server cluster

    We have a SQL cluster server running with SQL Server 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So once I’m done, the cluster will be a Active/Active/Passive cluster. Because...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connecting Crystal Repor2008 to SQL 2005 database

    Via Crystal Report2008 I have to produce a number of reports collecting data from a SQL2005 database running on another computer(2). This computer is not in my domain, but in a workgroup. However, the computer has the same IPaddress category. Anybody can help me with the steps to connect to the SQL...

    Antillas15 pointsBadges:
  • schedule a restore plan

    using sql 2005, management studio,, how to schedule a daily database and restore plan.

    DRE125 pointsBadges:
  • Data Migration Betrieve Tables to MS SQL Server 2005

    Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.

    Wonderer0820 pointsBadges:
  • Moving a SQL database from one host to another

    I need to help out in a move of a site coded in ASP/VBScript from one host we're having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don't know how to move the SQL database along with the site. Can...

    Kwoodall10 pointsBadges:
  • How to Schedule jobs in DTS in sql server 2000

    I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it

    SRI HARSHA10 pointsBadges:
  • Query error when using application role with ADO connection

    I am developing an application with an ADO connection. I need to run a query on two different databases on the same server using an application role. When I run the query I get an error \domainusername does not have a logon on database (referring to the second database). Is there any way around it?...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backup SQL database with BRMS AS400

    Running BRMS on i520 v5r4 LTO 4 tape library. Company just installed on seperate machines, same network: Windows2003 Server with MSSQL Database. I want to use BRMS and our robust LTO library system to get to the data on the SQL Database. Have little success with the LTO 4 being supported by...

    Vic58535 pointsBadges:
  • Error when upgrading SQL Server 2000 to SQL Server 2005

    I am upgrading SQL Server from 2000 to 2005. While upgrading I have received the below mentioned error. Kindly review and advise me on this. By the way, I have sufficient disk space on my server. "TITLE: Microsoft SQL Server 2005 Setup SQL Server Setup has encountered the following problem:...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?

    I'm setting up database mirroring in SQL Server 2005 Standard Edition and was wondering if there is a way for SQL Server to send me a notification of a failover and for it to automatically run a script when the mirror is brought online.

    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