• SQL Server 2000 performance issues

    Running SQL Server 2000, SP4 on Windows Server 2003 R2. 4GB RAM; 3GHz dual-processor, dual-core. The databases and logs are on an ISCSI SAN. This is the original implementation design. Since the beginning the users have said the system does not perform as well as they would like. The database...

    Labnuke9932,960 pointsBadges:
  • SQL Server 2005 backup

    how to take backup of live site

    Amin4rmOvexTechnology250 pointsBadges:
  • How do I populate an SQL table created on the fly in RPGLE?

    I am writing a report program where I create a table that is then converted to an Excel spreadsheet using SQL2JXL. I am able to dynamically create a table with Execute Immediate but I have been unable to populate it. The problem is the table name is stored in a variable within the program and I...

    SteveFletcher80 pointsBadges:
  • Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?

    hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver... i believe every thing should be fine. I have check the access permission for that user. that is not the issue. when...

    Sagar20005 pointsBadges:
  • Database Mirror connection string in sql 2008

    Hi All, I have three databases which i have configured mirror on sql server 2008 for all the databases. Manual Failover with one principal and mirror. (Witness planning in the future) Using Windows authentication (Since same login and pass, neither new endpoints are created and not certificate...

    GIG240 pointsBadges:
  • VB.NET app cannot login to SQL Server 2005 after upgrade from SQL Server 2000

    I have a VB.Net application which connects to an SQL2000 database and I recently upgraded to SQL2005 and after the upgrade my app does not want to connect to SQL2005 using the same password I used to connect to SQL2000. if I change the login password to all uppercase characters in SQL2005...

    Sanisto45 pointsBadges:
  • SQL Server Agent job Failures

    I would like to know if there is any way to get Agent jobs such as backups, Update Stats jobs to write to the error log on failure. I have written a monitoring program that looks in the errorlog and alerts on pertinent errors. I would like to be able to use this solution for agent job failures...

    Colin Smith885 pointsBadges:
  • Can you replicate SQL 2003/8 to SQL 2000

    I am upgrading a server running SBS w/SQL2000. New server will be 2003 or 2008. Would like to use old server for backup off site. Can I replicate, or would I need a new 2003/2008 license to accomplish this?

    AtlantaRookie5 pointsBadges:
  • How to get started in a SQL Environment

    I have been in an AS/400 world up until now. We are moving to SQL for a JDE EnterpriseOne implementation. What would be the best way for me to get up to speed on a SQL Server Database? Thank you for any and all insight.

    Kacerc65 pointsBadges:
  • SQL Server security bulletin MS09-004

    Has anyone dealt with issues related to this security bulletin ?

    Rik5 pointsBadges:
  • Running .NET Code to manipulate sql tables

    is it possible to retrieve a table using .NET code manipulate in code e.g calculating formulas based on values stored in table retrieved and then pivoting it in code and putting it back into another table

    Ankur7715 pointsBadges:
  • How to use embedded SQL in a RPG program used as a stored procedure

    When I use embedded SQL in a RPG program and call it from another program it works fine. But, when I try to use the program as a stored procedure it gives me a SQL error. I have worked with stored procedures and understand them, but have not been successful using embedded SQL with them. Any ideas...

    Warykat20 pointsBadges:
  • SSRS 2005 report error

    I keep receiving the following error in a certain report i have developed. My other reports work fine except for this one. Does anyone have a solution for this? Server Error in '/ReportServer/Pages' Application. --------------------------------------------------------------------------------...

    Mark12345615 pointsBadges:
  • Predefine a named range for an exported SQL Server Reporting Services report

    How can you predefine a named range for an SQL Server Reporting Services report exported to Excel? In particular, the named range must have a specific name, along with referring to a set of cells with specific columns for all rows rendered for the given table control. I am running SQL Server 2005...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Kaplan IT Learning SelfTest software

    Hallo community, 70-448 Microsoft Certification Practice Products 70-432 70-433 have you purchesed this software ? what is your experience? I want to prepare for these exams. Thank you very much in advanced for the Answer. DeshRaja

    DeshRaja25 pointsBadges:
  • Copying view from remote to local SQL Server with SSMS

    Hi I'm currently trying to get to grips with an upgrade from sql server 2000 to 2008, forced by an upgrade at my ISP. I'm used to using Enterprise Manager to export data from my ISP to my local machine for backup, and this process copying tables as tables, views as views and so on. But using Export...

    Tsp196520 pointsBadges:
  • Trouble backing up our SQL Server transaction logs

    Our SQL Server transaction logs have not been backing up, and I discovered it’s because a database was not selected in the maintenance plan. When I select the database and save it, however, it is not saving. It keeps reverting back to the previous option. Does anyone know why?

    SQL Server Ask the Experts2,585 pointsBadges:
  • To retrieve records from SQL Server database

    Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named "Name" in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on.... Now, through...

    Pichha5 pointsBadges:
  • Microsoft SQL Server certification – Exams 70-432, 70-433 and 70-448

    Hall Mrdanny, i did put following question two day ago. I can see (in google.de) that some one answered. But when i open this Answer (in firefox, internet expolerer) i do not see anything. That is why i am asking this question once again. you wrote on 21st nov 2008, that you have pass these 70-432...

    DeshRaja25 pointsBadges:
  • PL/SQL – Attribute to test not null and can take specific value instead

    Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure

    Inprise610 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