• 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:
  • 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,605 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:
  • 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:
  • Finding the 3rd highest in the table using SQL.

    The table name is 'Employee' with the columns Empname Sal Age A 8000 25 B 7000 24 C 6000 26 D 9000 25 what is the syntax used to find the 3rd highest. I have tried with all the syntax but no gain. I have searched in w3schools.com but was not able to find the right answer. Kindly help.... Reks

    19757910 pointsBadges:
  • Setting a range constraint without a stored procedure in a SQL Server table

    I have a table in SQL Server named CustInfo that is as follows: table CustInfo ( startdate datetime enddate datetime CustomerCode int address nvarchar(200) ) I want to define a range constraint to insure that only one address is allowed for a specific customer in a specific range of dates. For...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000 DTS Designer components are required to edit DTS packages Error even after installing sqlserver2005_dts.msi

    Hi, I am new to Database Technology and was asked to upgrade from MS SQL Server 2000 to 2005. I followed the procedure regarding the upgration found in one of the posts.THe Upgrade advisor says "SQL Server 2000 DTS Designer components are required to edit DTS packages" and In how to resolve this we...

    Psweta435 pointsBadges:
  • Backing up and upgrading a SQL Server 2000 database

    We have a database of around 3GB on SQL Server 2000 Standard Edition. What is the quickest way to backup the database at minimal cost, and how much time would it take to upgrade this database to SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error message while running a report created in SQL Server Report Builder

    I am trying to use Report Model in SQL Server Report Builder, but when I run the created report I am getting the following error: "Cannot create a connection to data source 'dataSource1'. ---------------------------- An error has occurred during report processing." What can I do to avoid this error?

    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