• How to match CSV field values in SQL Server 2005

    i have an table in sql-server 2005, in which my one field is storing csv values.Suppose i have two tables; one is roles and another is users; and multiple role can be assign to one user. so that i have make a fields i.e roles in user table which is keeping the values in csv format. now my problem...

    Sanjeevgoyal5 pointsBadges:
  • SQL Server 2005 Query Very Slow in the first run

    Hi, I have an sql query which takes 8 seconds in the first run. The next run there after takes 0.5 seconds and all consecutive runs take 0.5 seconds. Is the plan getting cached? How do i make this query run in 0.5 second in the first run itself? Please find the query below. select...

    Jsql155 pointsBadges:
  • Sorting hierachy data alphabetically in SQL Server 2005

    I have a follow-up question to the article Navigate hierarchies using recursive common table expressions. I have an employee hierarchy that follows a similar pattern to the article, but I need to be able to sort my data alphabetically within each level. Do you have any advice on how to accomplish...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Accessing the Northwind database in SQL Server 2005

    In SQL Server 2005, I am not able to access the Northwind database. Some people have said that it is built into the SQL Server, but I can't access it. How would I do so?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backup Programmability in SQL Server 2005

    How can I backup the Programmability (functions, triggers stored procedures etc.) as part of a schedule job? Do I need to write code or can I use the wizard?

    IT Systems Analyst15 pointsBadges:
  • Error message in the Copy Database Wizard in SQL Server 2005

    I am attempting to make a copy of a database using the Copy Database Wizard in SQL Server 2005, but I am receiving the following error: TITLE: Copy Database Wizard ------------------------------: The action you attempted to perform on a remote SQL Server instance failed because the action requires...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Loading an XML file’s dataset into an existing SQL Server 2005 table

    I have a dataset in an XML file that needs to load into an existing SQL Server 2005 table. It also needs to check existing rows before loading. What will be a good way to do that?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using indexes in SQL Server 2005

    What is the main purpose of using indexes in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Writing a specific query in SQL Server 2005

    I have a table called "ticketing" and I want to bring from that table the record with the most current date. What kind of query should I write in SQL Server 2005 to bring up that result?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connecting MS SQL server and database.

    Hi, i am trying to connect MS SQL server and database from visual c++ 2005. Can anybody help me please.

    Aranjan5 pointsBadges:
  • Retrieving data from two tables in SQL Server 2005 Expree Edition using C#

    how to Retrieve data from two tables in SQL Server 2005 Expree Edition using C#.

    Aras10 pointsBadges:
  • Running SSIS on a clustered server with SQL Server 2005

    We are using SQL Server 2005, 64-bit, on a Windows 2003 clustered server with Active/Passive 'A' and 'B' nodes. Databases are on a shared LUN. I can run all my SQL Server Integration Services packages on the 'A' node with no problem. When we fail over to the 'B' node, though, packages are failing....

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 ‘alter user’

    Hello, I have been trying to run the following instruction in QA use database_name alter user db_user_name with login = [domain\login_name] but keep getting the error Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. I know this method exist in SQL Server 2005, are any of you able...

    Db23290 pointsBadges:
  • Connecting to SQL Server 2005 after installing PowerBuilder

    I have installed PowerBuilder 11.1 and I am trying to access SQL Server 2005 from my system. I use SQL Native Client for connecting to SQL Server 2005, but I am receiving the error, "Could not connect to Data Source". However, I am able to connect to that server using ODBC and SQL Server Management...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I write the code to connect an .aspx webform to a MS SQL server and database

    This was done in VS 2008 the web forms are registration and log in forms with aspx controls. I created the database and the tables ( but am having issues with the constraints for 3 columns). I am trying to find out how to connect the 2 and where would I put the code. I am not a programmer and I am...

    Twinkles rules5 pointsBadges:
  • Create a database in SQL Server 2005

    Create a database in sql server 2005 but database name passed as parameter into a stored procedure

    Let5 pointsBadges:
  • bulk update in sql server 2005

    hi.. i have tried UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableB WHERE TableA.A3 = TableA.B3 this query but it is not working.. plz any one suggest me.. thx in advance...

    MinteeLoki5 pointsBadges:
  • SQL Server 2005 database mirroring over a VPN router

    Can SQL Server 2005 database mirroring work if the mirror server is to be in another building with the networks connected via VPN router?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looking to create and populate a numbers table in SQL Server 2005

    Now in SQL Server 2005, I know there are different ways to create and populate a numbers table. But, what's the best way? I'm looking for the best way to optimize these characteristics:Table created with optimal indexingrows generated fastestsimple code used to create and populate

    ITKE351,965 pointsBadges:
  • How to split a string in SQL Server 2005?

    While in SQL Server 2005, how do I split a string so I can access item x? Let’s say I have a string “Peyton Manning”. Is there a way to split the string by adding a space and accessing the item at index 1 so that it reads "Peyton"?

    ITKE351,965 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