• Clustering in SQL Server 2005/Windows Server 2003

    Does clustering become Active/Active when using SQL Server 2005 and Windows Server 2003?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sql Server 2005 ensure columns sum within a table

    How can I ensure the total sum of 5 columns within the same table equals 100 during insert or update in SQL Server 2005?

    Timmytong5 pointsBadges:
  • How to implement an Entity Relationship Diagram into a working database?

    I need to implement a ER diagram into a working database. I'm hoping to use Microsoft SQL Server 2005 Developer edition. I need to know all the details of how to implement an ER diagram such as what happens to a relationships between entities, how to implement "Is a" relationhips, how to implement...

    Obhasha0795 pointsBadges:
  • Implementing Encrypted SQL Server Database Columns

    This is the problem I'm facing: The database (SQL Server 2005) holds more than 5 million customer records. These records contain sensitive credit-card information that must be encrypted. Implementing an application-side encryption solution involves VB6 and .Net technologies. How to achieve a...

    Kansai5 pointsBadges:
  • Deleted SQL Server 2005 database

    Hi, actually I know the importance of backup, but I don't have the back up in any-how condition. Accidentally the database deleted by me. How do I recover it? How to use the transaction.log file to restore deleted database in SQL Server 2005?

    Lalit35 pointsBadges:
  • ASP.NET

    I have four textboxes and a database which is already created. What I want to do is if i enter the value in the four textboxes and press button, it should automatically gets updated or saved in the database.

    5555544425 pointsBadges:
  • How to backup a SQL Server database

    Hello, I wonder if you can help. We are just about to start implemetation of SQL 2005 Server. Can anybody, let me know how we go about backing up the database? We have veritas 9.1 but I guess we need to back-up live if possible. What is our best option?

    Garrybreed45 pointsBadges:
  • How can I structure this in SSIS?

    Within SSIS, I need to do the following: Select the max(to_date) + 1 from a table in SQL Server. Pass this value to a view where clause statement; this view is an Oracle view that needs this date value so I can get the new data from Oracle and load it into this same table in Step 1. How can I do...

    SQL Server Ask the Experts2,585 pointsBadges:
  • What are basic differences between SQL Server 2000 and 2005

    What are the Basic difference between SQL 2000 and 2005? Thanks!

    Amin4rmOvexTechnology250 pointsBadges:
  • I am using SQL Server 2005. How can I retrieve data from live server through the Internet using VB.Net 2005?

    I am using SQL Server 2005. How can I retrieve data from live server through the Internet using VB.Net 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to install SQL 2005

    Hey what was minimum hardware required for SQL 2005?

    Roony5 pointsBadges:
  • Execute a view/query is slower in SQL Server 2005 than 2000

    Hi, I have migrated a database from 2000 to 2005, updated the statistic and rebuild the index. When I run the following query "select top 500 * from myview order by name", it is extremely slower in 2005 than 2000. The myview simply does an inner join with 2 table. The name is varchar(50). Strangely...

    Db23290 pointsBadges:
  • How to convert XML data into tabular form in SQL Server 2005

    Hi, I have a concatenated string of XML data. I need to convert the string into tabular form. Please suggest how it can be done. Thanks in advance!

    Shama5 pointsBadges:
  • Getting “An error has occurred while establishing a connection to the server” error message

    While running the setup on client machine, An error Number 5 occurred telling - "An error has occurred while establishing a connection to the server. When connecting to SQL server 2005., this failure may be caused by the fact that under default settings SQL server does not allow remote connections....

    Pchandrachoudhary5 pointsBadges:
  • Database Newbie

    I'm quite new to database security and MS SQL server 2005 and 2008 and was hoping to find some extra sites or books to help as I am currently writing an application to send OS info and service tags to our SQL server. I obviously can t have the SQL server directly on the internet with an open port...

    Neutrino50 pointsBadges:
  • Do all versions of Microsoft SQL Server 2005 support database mirroring?

    Do all versions of Microsoft SQL Server 2005 support database mirroring?

    SQL Server Ask the Experts2,585 pointsBadges:
  • What are the differences between SQL Server 2000 & SQL Server 2005

    Hi, Can anyone tell me what are the main differences between SQL Server 2000 & SQL Server 2005? Thanks and Regards.

    Sukumardba5 pointsBadges:
  • Duplicate SQL Server 2005 database

    What is the best way to duplicate a SQL Server 2005 database to another server as a standby machine? Can I do this with another installation and some scripting? I have a separate box with SQL 2005 already installed. Can I backup and restore from one machine to the other using scripts and no human...

    ITKE350,945 pointsBadges:
  • How to split a column into SQL data..

    I have table called  country having one column called complete_name (varchar(max)) which is as under   [table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> [tbody] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent;...

    Anamika8315 pointsBadges:
  • VB.NET – Can’t insert data into database.

    I used insert command it worked successfully that your data has updated.But it is not showing in the database. Please look in the below code and tell me where I'm wrong: Imports System Imports System.Collections Imports System.Data Imports System.IO Imports System.Xml.Serialization Imports...

    Shaz255 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