• Toggling a case sensitive query in SQL Server 2005

    It appears that my queries of stored procedures, tables, columns, etc. are case sensitive in SQL Server 2005. Is there a “case sensitive” option that I can toggle on and off?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sage Mas 500 setting up Microsoft Project link.

    I am running Sage M500 - I need to be able to link my project files to my M500/SQL data and vice versa. I see lots of information on functionality but only consultants that want to set it up! HELP Me do this for free and save the day!

    Karl Gechlik9,860 pointsBadges:
  • Avoiding shut down to update windows

    If an sql server is being used for asp solutions, what is the best way to avoid having to shut down when running windows updates? Trying to come up with solution to keep clients from losing access to software.

    Newbie275 pointsBadges:
  • Increasing the performance of a slow query in SQL Server 2000

    I am using SQL Server 2000 SP4 on Windows 2003 Server, and I am having a problem with my queries. One of them was running fine a couple of weeks ago, but all of a sudden it is taking considerably longer to process than it used to. How might I resolve an issue like this from the database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL: Using a column created in the SELECT in the WHERE CLAUSE

    Can I use a column in the WHERE clause that I created with 'AS' in the WHERE clause. I have tried and SQL tells me that the column is not in the table? Thanks, Ray

    RayT30 pointsBadges:
  • Initialization DB-Connect Failed, Return Code 000256

    I have migradted 4.6C with 4.6D Kernel from HPUNIX, and Oracle to Windows 2003 Server, 4.6C, and MSSQL 2000, when updating the Kernel getting above mentioned error, can someone please help

    Budi4655 pointsBadges:
  • Refusal to recognize SQL Server 2005 Express on a client PC

    I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that was...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Excluding Data Usin NOT IN

    I'm trying to export data from a sql table into sql reporter. The information I'm trying to retrieve is information regarding permissions (this is audit stuff). The problem is, there are spaces (and always a different amount of spaces) between the user and the permissions; for example: Type Account...

    Jerzdevs10 pointsBadges:
  • Create a sequence called Store_seq with the following values: increment by 10, start with 500

    Create a sequence called Store_seq with the following values: increment by 10, start with 500

    VB RD45 pointsBadges:
  • i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??

    i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??

    Pandu5 pointsBadges:
  • cube data fails to display

    Working through the Foodmart 2000 sample sales cube in SQL Analysis Manager, all goes smoothly but at the end data does not display. The error message is "unspecified error", unable to browse the cube. This is the Sales cube created with the Quickstart example on Foodmart 2000.mdb.

    Psf55 pointsBadges:
  • unable to attach sample database in SQL 2005

    Hi, I installed SQL server 2000 and SQL 2000 SP4. Than I installed SQL Server 2005. But when I am trying to attach the AdventureWorks Sample database, I am getting the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ An error occurred when attaching the...

    Ismav5 pointsBadges:
  • datamining SQL with access

    I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that access will see the database...

    Daiishi0 pointsBadges:
  • Linked Servers????

    Hi everybody, I'm an IT student and i'm doing professional practices. A simple project was assigned to me. This company uses SMS to collect information of all his PC's and stores this information in a MSSQL database. A manager checks this information and fills another database located in another...

    EVX5 pointsBadges:
  • Optimizing Query

    Hi, I am having a table which is having around 170 Columns(Don't blame me but my Developer) and there are only 989 records in the table.I created all sorts of Indexes but still the query (Select * from Table) takes almost 2 mins to display 989 records.I need all the columns to be displayed.Is there...

    Sachin VCO15 pointsBadges:
  • Archiving databases on SQL Server 2000

    Could you help me to estimate how long it takes to archive 400 GB records from one of our test databases located on SQL Server 2000? Also, what would be the best approach?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database migration from SQL Server 2000 to SQL Server 2005

    I am attempting to migrate a database from SQL Server 2000 to SQL Server 2005; the size of the database is almost in terabytes. During migration, I would like to interact with the database on the SQL 2000 server. Is it possible to achieve migration without detaching the database from SQL 2000? If...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up and restoring a LIVE database in SQL Server 2000

    I am using SQL Server 2000, and I backup and restore my LIVE database to a new backup server every night. Do you have any ideas as to why my restored database runs slow when compared to the LIVE database? Do I need to rebuilding indexes? Is there any way of backing up indexes as part of the main...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looking for a database name query in SQL

    Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using a .bak file with SQL Server 7

    I currently use SQL Server 7, and I have a .bak file downloaded. Can you direct me on how to open this .bak file and how to convert it to allow usage with SQL Server 7?

    SQL Server Ask the Experts2,585 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