• Can SQL Server Reporting Services query a .csv file to use as report data?

    Can SQL Server Reporting Services query a .csv file to use as report data?

    SQL Server Ask the Experts2,585 pointsBadges:
  • After Unicode, SAP release strategy sequence changed

    Help, please!We recently did a Unicode conversion (SAP 4.7 from SQL 2000 to 2005, and from 32 bit O/S to 64 bit also). We now find that even though in config the release strategy has the correct sequence, when the approver views the screen (via workflow or even ME52N) to a Purchase Requisition, the...

    Jahmusical5 pointsBadges:
  • How do I import a file to a SQL Server table with dates before 1970?

    I have a package created in SQL Server Integration Services (SSIS) to load data from three flat files to a table in SQL Server 2005. I use the loop to go through the folder. I need to make sure that I don’t insert rows where a date column includes a year before 1970 (the epoch). I'm really new to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • unable to modify field in SQL Server 2005

    I have a database that was working perfectly on SQL 2000. We moved the data to SQL 2005. Now when our program accessing the SQL 2005 Server we get "Field 'optional' cannot modify." The Field optional is a bit field. The program is able to modify other tables in the database. It just won't modify...

    only1rb15 pointsBadges:
  • vb.net connection string for ms sql database for window application

    vb.net connection string for ms sql server database in window application

    Nikhil2110 pointsBadges:
  • Copy a SQL Server 2005 database into a SQL Server 2000 instance?

    Hi, Greg. After an upgrade from SQL Server 2000 to SQL Server 2005, the application team would now like to go back to SQL Server 2005 without data loss. We have built a new SQL Server 2000 instance for them, but now need to get the user databases copied over or restored. What is the best way to...

    Kmcfry45 pointsBadges:
  • help with t-sql recursion

    I have a table CREATE TABLE [dbo].[chart_hiera2](

    Ilay5 pointsBadges:
  • Converting from 2000 to 2005

    I was given an existing application/database with stored procedures to work on. The existing database is in 2000 however the manager would like it converted to 2005 (she thought it already was a 2005 database). My system is only configured for 2005 so my analysis tools are not working on the...

    GUI Girl5 pointsBadges:
  • Systems Management Server 2003 with SP3 and SQL 2000 sp3a advertisements at logon question.

    I've deployed SMS 2k3 with SP3 and SQL 2000 sp3a. My issue is with Advertisements that I want to run at logon. I have some Advertisements working fine at logon. When I create a new one, I need to have two entries in the mandatory field. one for logon and the other at an interval..(Strange) if I log...

    WinIT ATE110 pointsBadges:
  • sql 2005 log shipping versus DoubleTake for MS SQL 2005

    We were going to use log shipping from a cluster back to a dr site in a different city. Our network Operations folks want us to use a product called DoubleTake for MS SQL 2005. Anyone had any experience or insight with this. Log shipping has worked for us for 8 years, and if I am going to change I...

    tcstl95 pointsBadges:
  • Check for Inserting Same ID Number using VB.NET and SQL Server 2000

    I have ID Number Based Application once i enter one ID Number how can i put a check to stop entering same ID number am using VB.Net with Sql2000

    Flyhigh5 pointsBadges:
  • Is firewall preventing SQL Server from showing up in the EM?

    I have a corporate Dell Image laptop running SQL server 2000. Enterprise manager (EM) shows up without my registered SQL server (local or remote). When I try to re-register I see the other registered servers, however, they are grayed out. When I use the MMC Snap-In from computer management, I can...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Can SQL Server 2003 provide CPU usage information by application?

    I have a Windows Server 2003 Service Pack 1 (SP1) machine and need to find out how much of the central processing unit (CPU) each application is using. I am familiar with task list for Windows XP, but the only task list I see on the Windows 2003 machine is a command line tool and it does not...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Having problems converting SQL Server queries to stored procedures

    I am using SQL Server queries as in-script and I have now decided to use the queries as stored procedures. However, I am facing some problems while converting the SQL Server queries into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I move all stored procedures to a new SQL server?

    I recently moved a database from SQL Server 2000 to a new server running SQL Server 2005. Is it possible to move all of the stored procedures to the new server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Stored Procedure Problem

    Hi Greg, I am using SQL queries as in-script and now decided to use them as stored procedure. I am facing some problem while converting them into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query, which I was using with asp. SQL = “Select *...

    Anilak singh5 pointsBadges:
  • Learning SQL 2005/2008

    I would like to start from the grounds up in learning SQL 2005 and 2008. Any recomendations? I have been working with databases for sometime now including SQL 2000, but I have not jumped to anything newer. Thanks.

    NKaram5 pointsBadges:
  • How can I set the database password by the SQL Server Enterprise Manager?

    How can I set the database password by the SQL Server Enterprise Manager?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SUB-QUERIES

    Hi, Good you give me an best real example for using the sub query, correlation of sub query & Top analysis using subqueries. Thanks in Advance.................

    134915 pointsBadges:
  • SQL Server – I would like a stored procedure that will take the name of a table as input.

    I would like a stored procedure that will take the name of a table as input. What the procedure would do is drop all indexes on that table except any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another stored procedure that takes a table name as...

    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