• How does oracle avoid dead lock when I create an index on the foreign key column?

    How does oracle avoid dead lock when we create an idex on the foreign Key column ? Found many experts say this, but i never really found what is the logic behind this. So any replies provided are appreciated . thanks in advance gangadhar

    Gangadhar2610 pointsBadges:
  • SSRS 2008 from SSRS 2005, Authentication

    Currently I am running a 2005 SSRS Website, and 7/9 of my reports are done in 2005, and when I try access the 2 reports in 2008, it prompts me to enter my user name and password again, with this converter, will it solve this issue? I need a solution to get around the authentication of 2008 (with...

    MrPryor15 pointsBadges:
  • java

    Can u tell me how to connectivity in java & oracle / my sql. I know connectivity in java & Ms Access. But i want to connect java & oracle. Pls give each & every steps. Bcause i'll be connecting 1st time. Pls tell me all settings & which file for connect & .......

    Varsha500950 pointsBadges:
  • Migrating from AS/400 to SQL Server

    We have an AS/400 that no one in our agency knows anything about except that it has been running for a few years and the data needs to be removed from the AS/400 to another platform, either DB2 or SQL Server. I have read that a SQL ssis package can be used to migrate the data - I need to know what...

    Dharder15 pointsBadges:
  • Web Hosting strategy – NAT’ing and ARR

    I'm looking to develop a new strategy for our web hosting farm. Currently I've got  set of standalone IIS 6 web servers and sql 2005 database servers sitting in a network behind a kerio winroute proxy (which handles our nat'ing and intrusion prevention and VPN to our office location) which in turn...

    Phil4mat5 pointsBadges:
  • The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly.

    We have installed sql server 2008 (64 bit) on windows server 2008 enterprise edition, in which around 10 jobs to populate the dimensions from relational db to analysis cubes. I am frequently facing the same error and the services gets stopped. "The SQL Server Analysis Services (MSSQLSERVER) service...

    GIG240 pointsBadges:
  • 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?

    jinteik18,085 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:
  • 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:

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