• Exporting SQL Server 2005 database to SQL Server 2008

    This is more a basic question but is it possible to import (or migrate) SQL Server 2005 databases to SQL Server 2008? Or can I have 2005 and 2008 running on the same machine (without any complications)?

    ITKE355,460 pointsBadges:
  • SSIS on SQL Server 2012

    We're in the middle of upgrading from SQL Server 2005 to SQL Server 2012. However, there's a good amount of SSIS running on this server. Can we re-deploy these packages on the new SQL instance? Will we have to go through Visual Studio upgrade for each? Thanks!

    ITKE355,460 pointsBadges:
  • Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime

    Hi, This is Pushan Chakraborty from Kolkata. I have complied 2 stored procedures to retrieve the names of 2 user defined tables that I have created. The stored procedures are set: ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: -- Create date:...

    Pushan12345 pointsBadges:
  • How to use SQL Server 2005

    I have installed SQL Server 2005 but I want to know how to open SQL Server and connect the DB.

    Anand79865 pointsBadges:
  • Setting up access rights in a SQL Server 2005 database

    Hello, I'm using MS SQL Server 2005. I'm connecting to the server via ADO. I have a question about access rights. Let me explain this with an example. Let's say I have a database named DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL Server user that will have all rights on...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Encrypt a Column in SQL Server 2005

    I'm trying to encrypt a column. Unfortunately I don't have access to the C# source code that is accessing the data. All the instructions I've found require me to use the decrypt function in my SQL command. How do I automatically encrypt and decrypt without being able to change the source code? Is...

    Jfw10075 pointsBadges:
  • How to retrieve, add and update data manually using VB.NET 2005

    Hey guys! I'm quite new to VB.NET 2005. I need to know how to add, update and retrieve data manually using VB.NET 2005. In the software which I'm trying to implement, data is entered in text boxes and then they are updated/added into an SQL table. When retrieving the data, for example: A student is...

    Obhasha0795 pointsBadges:
  • SQL Server 2005 using VB.NET 2005

    How do I retrieve, add and update data from SQL Server 2005 manually using VB.NET 2005?

    Bbm5 pointsBadges:
  • Setting up SQL Server 2005 memory

    My SQL 2005 Enterprise Edition SP1 on server 2003 Enterprise SP2 has 12GB memory. I set min memory 10MB,10GB for max memory and set 'lock page on memory', but Task Manager show only 4.50GB only and performance monitor show SQL server manager - total memory on 4GB. Expert: Do I setup memory wrong?

    Maylee6330 pointsBadges:
  • SQL Server 2005 memory issue

    SQL server 2005 running on Windows XP. The memory grows steadily then SQL (system) hangs when memory gets to 1.7 GB and then the server must be re-started. What could cause this?

    Uphs25 pointsBadges:
  • Transfer data from DB2 file to SQL Server file

    I want to transfer a data from a DB2 file to a SQL Server file. I do not want to buy a software that do it. I want to do it by myself (perhaps using ODBC) Thanks all for help. Abdou

    HABDOU5 pointsBadges:
  • DB2 (AS/400) data transfer to SQL Server 2005

    How do I do a Data transfer from DB2 (AS400) TO SQL SERVER 2005?

    Hamadaeg15 pointsBadges:
  • SQL Server 2005 information

    What exactly does SQL Server 05 do and if I'm looking out for a job in this field, is there any exam which I have to take?. I'm new in this and have less knowledge about SQL. Please help. Thank you.

    Naughtyrohit15 pointsBadges:
  • SQL Server 2005: SQL statement in a variable

    Can anybody help me? "HOW TO ASSIGN A SQL-STATEMENT IN A VARIABLE". FOR EXAMPLE : TO ASSIGN A STRING IN A VARIABLE, WE DO LIKE THIS: DECLARE @A AS VARCHAR(20) SET @A='HAI' PRINT @A OUTPUT: HAI SIMILARLY HOW TO ASSIGN A SQL-STATEMENT IN A VARIABLE.

    Narendar30 pointsBadges:
  • Writing a SQL Query

    Is it possible to write a query that goes through the entire database to search out a particular phrase to delete it, instead of going table by table? This is on a SQL 2005 Database that was injected. The following appears throughout the database tables: <script...

    Bosco32225 pointsBadges:
  • Flowchart and algorithm

    How can I find a flow chart and algorithm of a program that finds the minimum of three values?

    melkamu15 pointsBadges:
  • IF ELSE in SQL Server stored procedure

    I am using this code which is giving error: if (@report_type = 'CM') Begin Select distinct Region,sum(ClientCount) as ClientTotal Into #NewTemp From ( End else if (@report_type = 'AM' ) Begin ( Select distinct Region,Area,sum(ClientCount) as ClientTotal Into #NewTemp1 From End else if (@report_type...

    Rrj15 pointsBadges:
  • SQL Studio 2005 expired but it is not evaluation copy?

    What happened? SQL Studio 2005 says evaluation period has expired even though I have a licensed copy of SQL Server 2005 installed. Please help.

    Nan57225 pointsBadges:
  • How to open SQL 2005 after installation

    How do I use SQL 2005 after installation?

    lathalakshmichitra5 pointsBadges:
  • Attaching AdventureWorks database To SQL Server 2005 SP1

    How can I get the AdventureWorks database for SQL Server 2005 SP1??

    Never5 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