• Store and retrieve data in UTF-8 on SQL Server 2005

    (Apologies:I put this question under Windows Server 2003 tag by mistake, so I copied and pasted it here where it should be) I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table...

    MrGeorge65 pointsBadges:
  • update the tables in to two server using a single ssis package

    i have 2 servers server A and Server B.i have written a package in server A.i want to update the tables in both server A and B.when i execute the package from BIDS it is working fine when i schedule the package in agent job i am getting the below error.  Executed as user: RICRDWDEVSYSTEM....

    Knowledgesharing5 pointsBadges:
  • SQL Server profiler duration empty

    Hi I choosed all events with starting and completed but still duration is empty, tried also by swithching to microseconds from tools/options, but still empty. any reasons for this? thanks Elod

    Zsoelod15 pointsBadges:
  • Update SQL Server 2005 Scripts

    I don't right code & don't have the confidence to try on my own so, I'm asking for help. I need to run an update script to clear out the data from iweb_conf_demo.Attendee_ribbons.Then I’ll need to run multiple scripts to update multiple records on the same field iweb_conf_demo.Attendee_ribbons...

    DJandLO130 pointsBadges:
  • Updating a Date Time Field

    I need to update the Confirmation Date Time field to NULL for a specific meeting but am unsure how to insert it.  The script below works for an individual but if they have more than 1 confirmation date it clears then all. Meet_Master.MEETING is where the meeting code AM2011 is. UPDATE   ORDERS...

    DJandLO130 pointsBadges:
  • Add/Rename SQL Server 2005 Server Name

    Hi experts, I have am trying to rename and add new server name to Microsoft SQL server 2005. I as using following steps for rename step 1. select @@servername ' for seeing current server name step 2. sp_dropserver 'ray' ' for deleting current server step 3. sp_addserver 'raynew', local ' for adding...

    itspirit55 pointsBadges:
  • Reg:Problem with SSAS

    Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I need to first migrate the...

    48102145 pointsBadges:
  • Halt audit trace if audit file doesn’t rollover

    I have a security requirement for SQL Server 2005 and 2008: "SQL Server shall be configured to halt if a failure in audit file rollover occurs". How do I accomplish this?

    VelameLaCosa110 pointsBadges:
  • error in creating new database using sql server

    I enter as the administrator, and when creating a new database a message always appear stating that permission denied in database master! what shall i do?

    Ladylynn15 pointsBadges:
  • Connecting SQL server 2005 with IAN connection

    how we can connect sql server2005 with lan area? what are all the settings and options want to change?

    Shajidjame5 pointsBadges:
  • Calling stored procedure in a database to query data in another database

    Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData...

    Ssss12315 pointsBadges:
  • Calling stored procedure in a database to query data in another database

    Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData...

    Ncs5 pointsBadges:
  • load balancing in sql server

    Is there any Load Balancing in SQL Server 2005 to distribute CPU load between more than one server?

    Rabinarayan5 pointsBadges:
  • Can I install SQL Server 2005 32-bit on Vista 64-bit?

    I have a processor of 64-bit and windows vista SP1 64-bit. But i want to install sql server 2005 32-bit does it support or can i install it on 64-bit. shekhar.parate@wipro.com

    Shekhar085 pointsBadges:
  • Merge two companies into one network

    The company I work for has decided to merge with its Sister Company on the lower floor. While we share the same room to house our independent servers, both companies have separate physical networks. Each with their own separate File Servers & SQL servers. Allowing Company "A" employees to log into...

    PatM5 pointsBadges:
  • SQL Server 2005 backup server

    Is there a way to replicate a SQL server database to another SQL server with the same hardware and software? I want a live copy of the data up to date in case something goes wrong and we need to switch to the backup server.

    NewnanIT1,110 pointsBadges:
  • What are basic differences between SQL Server 2000 and 2005?

    What are basic differences between SQL Server 2000 and 2005?

    Rupam5 pointsBadges:
  • Crystal Reports XI period in database name

    SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?

    Fortuna35 pointsBadges:
  • SQL SERVER 2005 Performance Monitoring

    Hello, is there a free software tool to monitor sql server 2005 similar to Quest FogLight? Quest FogLight is just too expensive for my budget. I am an independent consultant and I want to be able to monitor my client’s sql server.

    Rick Martinez585 pointsBadges:
  • sql server 2005 do not show Add new administrator in Surface area Configuration

    Hi  all I haved a problem with the installation of SQL Server 2005 SP3 in a WIn xp OS.   I proceed to install the free application but when i try to check the permisions to create a DB i went to Configuration tools > SQL Server Surface area Configuration, but the screen did not present the...

    Mcom5 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