• 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:
  • Update a Date_Time Field

    I'm trying to update a DATE_TIME field to a NULL value. When I run the script below I get an error. Any ideas on what I'm missing? UPDATE Orders SET CONFIRMATION_DATE_TIME = ' ' WHERE ST_ID = 102690 ERROR: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value 'Ê' to a column...

    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...

    itspirit45 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:
  • Limiting SQL injection in SQL Server 2005

    I have a site in ASP and on the back-end in SQL Server 2005, but I keep finding SQL injection on my site. Is there code that will prevent SQL injection from getting onto my site?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Invalid String or buffer length ERROR

    I am trying to connect to SQL server 2005 express edition using JDBCODBC bridge driver. I have succesfuly configured the data source but when I use DriverManager.getConnection("jdbc:odbc:sql")-->sql is the data source name.. I catch this Exception.. Many thanks in advance

    1023965 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:

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