• 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:
  • How to prevent SQL update trigger from firing on insert?

    Category: SQL Server 2005, T-SQL I have an insert trigger on TableA that updates Column1 in TableA. I also have an update trigger on TableA that I don't want to fire, or at least not to execute certain code, when a new record is inserted in the table. How can this be achieved? I don't want to use a...

    Leo W5 pointsBadges:
  • Problem occuring while performing Mirroring

    Hi, I underwent the following Steps for creating a mirror in sql server 2005. 1. Downloaded and isntalled sp2 in principal,mirror as well as witness servers 2. Created a new database named it as FinalMirror 3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak...

    Cmrhema5 pointsBadges:
  • SQL Server 2005 – Are There Any Easy Appl. Builders

    Hi, Is there a easy application builder for a PC to access a SQL Server 2005 Database that will give it the ability to do Inserts, Update, and Deletes? Is there a program that can read in a SQL Server 2005 Schema and generate forms to do updates and reporting? Are there any Open Source Apps or low...

    Tsmith235 pointsBadges:
  • Microsoft SQL 2005 Networking

    Hi I'm a software developer and i use Visual C# 2005 and Microsoft SQL 2005 to create my desktop applications my application is a software will be installed in to client machines as 2 home PC and i want to make the two software's connect throw Ethernet to my database which it located on one of the...

    M200015 pointsBadges:
  • Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?

    Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrade to SQL Server 2005 resulted in 100% CPU utilization and application timeout error

    My server is DL580 running on Intel Xeon Dual core Dual CPU. I have recently migrated from SQL Server 2000 to SQL Server 2005. The server is dying and showing 100% CPU utilization and applications are getting Server Timeout expired error. What can I do?

    SQL Server Ask the Experts2,585 pointsBadges:
  • After Unicode, SAP release strategy sequence changed

    Help, please!We recently did a Unicode conversion (SAP 4.7 from SQL 2000 to 2005, and from 32 bit O/S to 64 bit also). We now find that even though in config the release strategy has the correct sequence, when the approver views the screen (via workflow or even ME52N) to a Purchase Requisition, the...

    Jahmusical5 pointsBadges:
  • How do I import a file to a SQL Server table with dates before 1970?

    I have a package created in SQL Server Integration Services (SSIS) to load data from three flat files to a table in SQL Server 2005. I use the loop to go through the folder. I need to make sure that I don’t insert rows where a date column includes a year before 1970 (the epoch). I'm really new to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • unable to modify field in SQL Server 2005

    I have a database that was working perfectly on SQL 2000. We moved the data to SQL 2005. Now when our program accessing the SQL 2005 Server we get "Field 'optional' cannot modify." The Field optional is a bit field. The program is able to modify other tables in the database. It just won't modify...

    only1rb15 pointsBadges:
  • Copy a SQL Server 2005 database into a SQL Server 2000 instance?

    Hi, Greg. After an upgrade from SQL Server 2000 to SQL Server 2005, the application team would now like to go back to SQL Server 2005 without data loss. We have built a new SQL Server 2000 instance for them, but now need to get the user databases copied over or restored. What is the best way to...

    Kmcfry45 pointsBadges:
  • Converting from 2000 to 2005

    I was given an existing application/database with stored procedures to work on. The existing database is in 2000 however the manager would like it converted to 2005 (she thought it already was a 2005 database). My system is only configured for 2005 so my analysis tools are not working on the...

    GUI Girl5 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