• SQL Monitoring

    I am just wondering what others are currently usig for monitoring and projection of databases and server? Currently I use code I wrote allong with Excel.

    Taney20000 pointsBadges:
  • After Patch Installation Documentation / Checklist

    just wondering once you guys patch windows servers (any type), SQL server, windows xp or even as400, do you guys come out with a checklist or a document to show that the patch has been installed on the servers?

    jinteik16,930 pointsBadges:
  • Why does SQL server use no more than 500MB in RAM?

    Why does sql server use no more than 500mb in ram? We have sql server 2005 running on server 2003 32bit with 32GB of ram and in the task manager under processes, Mem Usage sqlservr.exe is only using 430, 268 K. SQL Server min memory is set to use 25GB and max is set to use 29GB. Our database is...

    Rick Martinez585 pointsBadges:
  • Parameter in select statement

    Hi, I need to pass a parameter into a stored procedure which values are dynamic always. Executing a variable which having the Select statement. Following query working fine. BEGIN DECLARE @strQuery NVARCHAR(MAX) DECLARE @CountryId INT DECLARE @CityId INT SET @CountryId = 2 SET @CityId = ' AND...

    Plugsharma40 pointsBadges:
  • Copy a SQL Binary Large Object (BLOB) from one database to another

    Is there  a way to find out the name of a Blob stored in a database. I am trying the code below and apparently the name is not correct. SQL> Declare   2   tpsr Blob;   3   spsr blob;   4  Begin   5   Select '8502' into tpsr from ca90joetmp.spec_form_psr where spec_form_id = '90710';...

    Bobf15 pointsBadges:
  • NTVDM encountered a hard error installing SQL 2000 onto Windows Server 2003

    Trying to install SQL server 2000 on windows 2003 Server SP2 I got ntvdm encountered a hard error. Please help

    Mamamama5 pointsBadges:
  • Business Objects XI Enterprise – Repository License

    What are the BOE license requirements (if any) for the BOE repositiory (System & Audit repository) if it is located on a separate server that the BOE server? (Note: The server is licensed appropriately as a MS SQL database.)  

    LifeWay10 pointsBadges:
  • iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio

    My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...

    JohndeCoville0 pointsBadges:
  • Powershell 2

    Hello I installed PS (ver 2) from windows updates. I have a couple of Q: 1)The event viewer shows a bunch of event id 4374 package not applicable 'warnings' but I tried running some cmdlets and they work fine in 2 However, I get an exec of scripts is disabled on this system for version 1 execution...

    Sense2k10 pointsBadges:
  • Upcoming Live Expert Chat on 10/26: Virtualizing Business-Critical Applications (sponsor post)

    VMware vSphere runs business-critical applications, including Exchange, SQL, Oracle and SAP, with breakthrough performance and outstanding  reliability. Many VMware customers are now virtualizing large Tier 1 applications to consolidate their x86 infrastructure and minimize infrastructure costs....

    EmNichs3,250 pointsBadges:
  • openquery no records returned SQL Express 2008

    I run theis procedure against a link server (Quickbooks) It runs with no errors but will not return records. SELECT   *   FROM QODBC ...Customer

    Dendic5 pointsBadges:
  • SQL Server 2005

    Is user cloning the only way to use windows authentication in sql server?

    Kingjah15 pointsBadges:
  • SQL Server Profiler

    What numbers are considered high when using sql server profiler for reads, writes, and duration

    Rick Martinez585 pointsBadges:
  • Combo Box Selection Locks Form

    I have a combo box that locks/corrupts all of the controls on a Access 2003 form.  The locking symptom only seems to occur when the list index is greater than 0. The problem control may not be the combo box.  It may be one of two list boxes that are affected by the combo box's 'after update'...

    McNitro255 pointsBadges:
  • sql Reporting services – report name

    I have a report that runs nightly for daily invoices. It runs everyday using a subscription and places the report in a shared folder. It's called "Daily Invoice Report". How do I get the the Report Name "Daily Invoice Report" to also include the date that the report is for. This date is a parameter...

    Cubsklm5 pointsBadges:
  • Disaster recovery for SQL 2005

    How can we setup a disaster recovery sql server? We are running SQL 2005 on a 2003 box. We need a real time exact replica we can switch to?

    NewnanIT1,110 pointsBadges:
  • SQL Server Express 2008 with Advanced Services Installation

    I am trying to install this program on a Windows 7 OS, and I'm having a very difficult time. I have a 64-bit computer, but I'm trying to install the 32-bit version (x86) because I only have a 32-bit version at work, and I'm practicing at home what I eventually want to do at work and I want...

    Dataempress115 pointsBadges:
  • How to make a graph always visible when there is no data?

    Hi, I am currently creating a report in SSRS which contains many tables including a graph on one page. The formatting is nice generally, but when there is no data in the graph, everything will be different. So, I am trying to keep the graph always visible to keep the formatting. Is that possible?...

    Zhounan5 pointsBadges:
  • Upgrading from SQL Server 2000 to SQL Server 2005

    We want to upgrade our SQL Server 2000 to SQL 2005. What should we watch out for and what is the actual procedure for the upgrade? Will it require another server or can the upgrade be done in place?

    NewnanIT1,110 pointsBadges:
  • SQL Server Express 2008 w/Tools vs. Advanced

    Hi, I installed SQL Server Express 2008 w/Tools on my Windows 7 OS. I just found out that if I want to download the AdventureWorks database .msi from codeplex, I need SQL Server Express 2008 w/Advanced Services. Do I need to uninstall the SQL Server Express 2008 w/Tools and install SQL Server...

    Dataempress115 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