• ExcelSource file – metadata validation

    I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output columns...

    Mayre5 pointsBadges:
  • SQL Find a number between the given ranges of number / Find a row which has range of given number

    I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value in...

    Bsethi245 pointsBadges:
  • SQL “NOT CONNECTED” icon in my taskbar

    there is an icon in my taskbar and when i highlight it it says NOT CONNECTED. when i right click it it pops up a menu with OPEN SQL SERVER SERVICE MANAGER on the top...what is this and why is the icon in my taskbar?

    Pennymae10195 pointsBadges:
  • SSIS package that will copy a table from one server to another based on a var.

    Another NeeBee question....I would like to have an SSIS package that would check if a variable "RefreshTable" = 'YES' which is found on a table from server A, delete all the data from a table on server B and then load that table on server B with data from an identical table which is on server A....

    NewBee7105 pointsBadges:
  • I want to parse data from one field into two based upon criteria.

    I have lots of data with disparate information in one field and I need to take all information to the right of any * that might appear into a separate field? There will be an * about 10% of the time. Examples of the field in question. Example 1: CKD Stage I ****250.40/585.1 Example 2: /Prosthesis...

    JohnSouthFlorida5 pointsBadges:
  • Conditional processing in embedded SQL

    I'd like to conditionally control the host variable into which the data from an SQL select statement is retrieved. This is for flexibility, so that I can use the same code in my program more than once. Here is a code sample: C/EXEC SQL C+ If :ResultName = 'AgtMaster' C+ Then C+ Fetch Next From...

    Cwc4,290 pointsBadges:
  • Password Policy for SQL Server 2000

    Is there any way to set Password expiration Policies on SQL Standard Users in SQL 2000?

    Rickmcd1,560 pointsBadges:
  • Moving SQL Stored Procedures

    My developers create MS SQL Stored Procedures on a development server. What is the best way to move/copy those SPs to the production server (different machine)?

    VelameLaCosa110 pointsBadges:
  • SQL Server 2005 Upgrade Advisor in a cluster/SAN environment

    I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when I go to the pull-down, nor does it recognize it when I key in the instance name. We are running on a...

    Trig15 pointsBadges:
  • SQL Error

    SQSQL Error :Component SARWFNUM:SQLSTATE 37000L Error :Component SARWFNUM:SQLSTATE 37000SQL Error :Component SARWFNUM:SQLSTATE 37000

    Odunsi5 pointsBadges:
  • Need help…My Sql server 2000 has error

    My Sql server 2000 has error when created a new database or create a new table in my database. There is the error : "[Microsoft SQL-DMO(ADBC SQLState : 42000)] - Cannot use empty object or column names. Use a single space if necessary" I think my SQL server 2000 was created a no name database, but...

    W3bdiv3r5 pointsBadges:
  • SQL Server 2000 Drive selection

    I have a software package (Pinnacle Studio 10) that installed a SQL Server 2000 database. When I first loaded the SQL software on the C drive it created a database on the D drive. I now need to create a database (or move the database) to a new H drive. How can I do this? Can I change the swap the...

    Ralow015 pointsBadges:
  • Users in a data base

    How many users concurrents does the database SQL support???

    Users5 pointsBadges:
  • Database offline vs Database stopped vs Database network disconnected?

    How Database Offline is different from Database Stopped? How Database Offline is different from DB network disconnection? How Database Stopped is different from DB network disconnection? Appreciate your help.

    Saimadhu455 pointsBadges:
  • Moving a database from SQL Server 2000 to SQL Server 2005 and back again

    I moved my database from SQL Server 2000 to SQL Server 2005, but now, if possible, I'd like to move it back. When I open SQL Server Management Studio 2005 and check my database's properties, its compatibility is "SQL Server 2000(8.0)". Can I move my database back to SQL Server 2000, and if so, how?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Round GPA to tenths and remove decimal in SQL

    I have a field in a table, ACT_OVGPA that represents a student's current overall gpa. The field is a 2 digit number on a scale of 00-40 where I believe there is an implied decimal point and actually represents 0.0 - 4.0. This is what I have written, but it returns an error "too many values". Can...

    Cmyers40 pointsBadges:
  • What data should I index in a SQL database?

    When advice is given to only index on selective data in a SQL database, would you therefore index on a four digit integer (ID number) or a patient's name, for example? Would this make sense logistically?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SSRS Memory Performance

    Microsoft SQL Server Reporting Services Version 9.00.3239.00 We are experiencing problems with memory and other performance related issues. This is a scaled out deployment with ssrs installed on 2 server web farm (used to be 3) with windows 2003 sp2, 32GB RAM. Customers run 100s of subscriptions...

    MJT20 pointsBadges:
  • DataBase Restore

    I'm working with SQL Server 7 and I made a backup from a DataBase and I need to restore it, but this error appear: "The RAID set for database is missing member number 1". What can I do???

    Claudiofuentes15 pointsBadges:
  • Reading the content of a URL into a table in SQL Server 2005 Express

    I need to insert the contents of httplog (which is basically http://xx.xx.xx.xx/httplog) into a table in SQL Server 2005 Express. How can I do this? Can I read the contents of httplog directly into the table (with a varchar 1000), or I need to use third party software?

    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