• 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:
  • Connectiveity JAVA to Sql server 2000

    Dear all, I have problam to connect SQL 2000 server with jdbc driver.\ i m using windows 2003 server SQL server 200000 and jbuilder. anyone have jdbc driver for the same environment thnaks

    M.Asif5 pointsBadges:
  • Error installing the client tools for SQL Server 2000 onto an XP desktop

    When attempting to install the client tools for SQL Server 2000 onto an XP desktop, I get an error stating that “A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.” Rebooting only leads to the same...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating from MS Access to SQL Server Express

    I've just installed SQL Server Express and I want to create a local instance. I would like to use SQL Server to do my analysis in running queries instead of Microsoft Access. I want to import my tables from Access to SQL Server Express. How can I migrate from MS Access to SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2008 R2: User table with clustered indexes

    I recently found that a couple of my tables in SQL Server 2008 R2 with no clustered indexes defined. However, there are non-clustered indexes defined (so basically they're on HEAP). After I did some searching, I learned that some select statements were using a filter on the columns defined (in...

    ITKE350,280 pointsBadges:
  • .dts and .dtsx config files in SQL Server 2005

    Hi I have .dts and .dtsx config files. i want to execute these packages in the db server, can u tel me what are the steps required to attach and configure these packages for it to execute?

    Sangeeth30 pointsBadges:
  • how can make this SQL Server query faster

    All, how can I make this query faster? Here is my code of stored procedure: ALTER procedure [dbo].[GetLMPReport] ( @typeId tinyint, @dataType varchar(2), @date date ) AS begin select distinct p.name, ISNULL (td24.price, 0) as '00', ISNULL (td1.price, 0) as '100', ISNULL (td2.price, 0) as '200',...

    Singhal120 pointsBadges:
  • Front-End Reporting Tools for Secure Web Service Application with MS-SQL server-2

    Hi... We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small secure web service application for reporting purposes that will require minimal IT expertise to build or maintain, and will deliver maximum...

    Mmosystem0 pointsBadges:
  • Creating a SQL Server trigger to capture data

    How can I create a SQL Server trigger that captures the user name and system date in fields within a record after any field in that record has been updated?

    SQL Server Ask the Experts2,585 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:
  • full text search in sql server 2000

    can anyone tell me how I can get full text search to work in SQL Server 2000 ? Ive installed it, created a catalogue, selected a table (with a primary key) stepped through the wizard, in fact followed all instructions to the letter. When I run this query SELECT * FROM guidance WHERE CONTAINS(Title,...

    Mark...w10 pointsBadges:
  • Deny domain administrators to select from sql server tables ( SQL server 2005)

    I have added the "domain admin" group to the Sql Server, and set permission as "Deny" to connect to the database engine. All employees of this group can still select from any table. The sql server "public" role does not have any permissions on any database table. The "domain admin " group has local...

    IgorS5 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:
  • SQL Server 2000/2005 – Creating Unique Constraints allowing multiple NULLs

    Hi there! I'm having a problem maintaining data integrity on a database table in MS SQL-Server 2000. To ensure maintaining the integrity I need to implement a Unique Constraint on one of my coloumns. The problem however is, that this coloumn also has to allow multiple NULL-values - but for every...

    LeChuck0 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:
  • Is a Microsoft certified database administrator (MSDBA) certification course good with my SQL Server experience?

    I am working in a data migration team on SQL Server. I am planning to do the Microsoft certified database administrator (MSDBA) course. Please let me know if this certification matches with the line of work I am doing, or if there is a more preferable certification that would contribute to my SQL...

    NetworkingATE1,545 pointsBadges:
  • Looking for detailed synchronization logging in SQL Server 2008

    We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the...

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

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