• Documenting stored procedure jobs in SQL 2005 enterprise

    Our consultant created several stored procedure jobs within SQL 2005 enterprise. How can we view them to document them? SQL runs on a Windows 2008 box with 32gb of memory.

    TeachMeIT975 pointsBadges:
  • Can’t log in after upgrading SQL Server 2005 express to SQL 2005 standard

    I have upgraded SQL Server Express 2005 to Standard 2005. Every thing is updated and all Services are well running, But not able to login because I have got only Configuration Tools in Menu- Start->Programs->MSS 2005->Configuration Tools. and if I try through Run SQLWB,it's shows not...

    SQL815 pointsBadges:
  • IT Book Giveaway: Oracle Solaris Cluster Essentials

    We've got your ultimate in-depth resource on the start-to-finish lifecycle guidance for planning, implementation, management and troubleshooting your Oracle Solaris Cluster. There's even helpful advice for both Oracle and non-Oracle database environments. Win this valuable resource by answering one...

    MelanieYarbrough6,345 pointsBadges:
  • Improve performance on Insert rows into DB2 400 table from SQL server

    Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for Inserts to...

    Code2live55 pointsBadges:
  • SQL SERVER 2005 Database Options

    We have a database in production that is 500GB, what are the pros and cons for setting the "Page Verify" option to "NONE" on the database for best performance? How will "TORN_PAGE_DETECTION" and "CHECKSUM" affect performance?

    Rick Martinez585 pointsBadges:
  • Extracting in SQL Server 2005

    IS THERE ANY WAY TO EXTRACT FROM A FIED EXAMPLE: I HAVE A ADDRESS LINE AS 1065 VALLEY LANE APT 120                                                       SCHAUMBURG...

    Hydrostani20 pointsBadges:
  • ESXi v4.1 White Box

    I'm looking to put together a server to run ESXi v4.1.  I've selected the following hardware components and would appreciate any advice/input good/bad:  Case: Athena Power CA-SWH02BH7  Mobo: TYAN S8230GM4NR-DL  PSU: Athena Power AP-P4ATXK110FEP  CPU: AMD Opteron 6134 Magny-Cours 2.3GHz  64gig...

    DaveMPA55 pointsBadges:
  • Write Record to table as XML from RecordSet destination

    Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?

    Kayj5 pointsBadges:
  • How can I take a backup of a SQL Server stored procedure only?

    How can I take a backup of a SQL Server stored procedure only?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 Memory

    I have a server with 8 dual core processors, 32GB of RAM, windows server 2003 32bit, sql server 2005 enterprise, and a 500GB database running on it. 1. How does sql server use memory in this case? 2. I have heard from sql server pro's that sql server can only use 4GB of RAM is that true?

    Rick Martinez585 pointsBadges:
  • PL/SQL Query

    Create table other_sess( s_name varchar2(10)); insert into other_sess values('s2007'); insert into other_sess values('s2009'); insert into other_sess values('s2009'); commit; now i want to write a PL to retrive data from these sessions (s2007, s2008, s2009). from my current session. declare...

    FaheemNawaz15 pointsBadges:
  • Virtualizing Business-Critical Applications VMware expert live chat TOMORROW (10/26)

    Don't forget about the LIVE VMware expert chat TOMORROW, October 26th from 11am-2pm EDT: Virtualizing Business-Critical Applications. You'll learn about application performance considerations, best practices and use cases for deploying Tier 1 applications on VMware. Click here and bookmark this...

    EmNichs3,250 pointsBadges:
  • Sponsor Post: VMware Expert Live Chat – Tuesday 10/26 at 11am EDT

    Join us on October 26 from 11am-2pm EDT for Virtualizing Business-Critical Applications. In this LIVE chat with VMware experts, you’ll learn about application performance considerations, best practices and use cases for deploying Tier 1 applications on VMware. Click here for reminder email to...

    EmNichs3,250 pointsBadges:
  • How do I modify stored procedures in sql 2005?

    Where can I view in SQL 2005 when a stored procedure was run and what its outcome was? Can I see who ran it? Can I see who modified the job?

    Karl Gechlik9,860 pointsBadges:
  • Rolling back a SQL server 2005 database.

    We need to roll back a copy of our database 5 hours. We are running sql 2005 on a windows 2003 server. How can we do this? We do not want to effect production data but want to report against the 5 hour old data.

    Karl Gechlik9,860 pointsBadges:
  • 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:

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