• 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:
  • 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:
  • 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:
  • How do my database sql2005 database to another server with management studio

    Has sql 2005, using management studio to do a full backup of my database. Using maintenance wizard to set the backup. I only see my local drive and not my share folder created onthe other server where i want to place the .bak file. Any idea will be helpfull.

    DRE125 pointsBadges:
  • Storing BLOB to file through SQL Server 2005

    I want to know how to Export BLOB data to a JPG File at the SQL Server end ... NOT USING C# or VB

    Naeem5 pointsBadges:
  • What are the steps to install multiple instances of SQL Server 2005 on Windows Server 2003 SP1 cluster?

    What are the steps to install multiple instances of SQL Server 2005 on Windows Server 2003 SP1 cluster?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looking for best approach to upgrade SQL Server 2000 databases to SQL Server 2005

    I will be upgrading a number of SQL Server 2000 databases to SQL Server 2005 and was wondering what database objects I have to worry about? I believe to run Data Transformation Services (DTS)in 2005, I will have to have legacy installed. Is that correct? Other than that, should there be any...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is it possible to increase the amount of memory used by SQL Server 2005 to speed up response time?

    We have 1 server Proliant ML570T04 with 16GB di ram and 11 SAS Disk 70 gb. The software installed is SQL Server 2005, 32-bit and the application is Navision. With < 15 clients, the response time is slow because the SQL Server utilizes only 4 GB of ram. Is it possible to utilize the remaining...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Build 09.00.3239.00 (cumulative update)

    I just patched my servers to this build and noticed that the time used to 'Delete files based on the age of the file at task run time' within a maintenance cleanup task is screwed up. Hours become days, days become weeks, weeks become months when the Maintenance Plan executes. Anyone else noticed...

    Kurthp195 pointsBadges:
  • Patches for new SQL2005 instance

    HI would like to know if we need to apply patches for a newly created instance if the default instance has already been patched to SP2 Thks for any info

    fartman50 pointsBadges:
  • SQL 2005 error code = 80004003: Invalid Pointer

    After (successfully???) attaching a database to a VM Ware instance of MS SQL Server 2005 and setting what appear to be appropriate access to the SQL server itself and the database involved, and making sure that sharing and security are properly set on the SQL server, I am receiving the following...

    Pressler29042,190 pointsBadges:
  • SQL 2005 Active/Active/Passive

    We have a SQL cluster server running with SQL 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 after I have done it, the cluster will be a Active/Active/Passive cluster. Because...

    Kjrichmond15 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