• how to capture cases in store procedure codes

    I wish to creat a query in store procedure (with variables such as Start Datetime, End Datetime, Parameter varchar(3) as you can see on my store procedure for other reports). But for this report, I wish to capture a case might fall into one of the columns (only one column such as DECLEAREDDATE OR...

    Josephptran15 pointsBadges:
  • log sql queries?

    queries seem get mangled by our report writer middleware; I'd like to see the actual SQL received by Oracle9i from a particular user. how?

    Ktpierce5 pointsBadges:
  • Execute SSIS package in SQL Server 2005

    how to execute SSIS package in sql server 2005

    Sangeeth30 pointsBadges:
  • Attaching a SQL Server 2005 database to SQL Server 2000?

    Is it possible to attach a database that was created in SQL Server 2005 to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looking for a query tool for SQL Server 2000 and SQL Server 2005

    Many of our developers would like to have a client utility like Query Browser or Query Analyzer installed on their machine, so that they can personally query our SQL Server 2000 and 2005 servers and view the results from their workstations. I am unable to find the appropriate way to install...

    SQL Server Ask the Experts2,585 pointsBadges:
  • MSSQL Reporting services

    Can a single report show more than one graph? Consider I have 4 queries to show graphs for and I'd like to have all of them in one single report, is this possible?

    alessandro.panzetta9,725 pointsBadges:
  • Drop Database Connections

    Hi,How can I drop all connections of a database through TSQL commands.(NOT SMO)

    Javad5 pointsBadges:
  • Where to place the tempdb log file?

    I've heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I correct sCaller errors in T-SQL?

    How can I correct generic sCaller errors in T-SQL?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to create new ramco test server?

    Plz help me,when i restore my sql database with ramco backup then my database is restore but problem is that front-end not lounch in my system.

    Amitshukla60 pointsBadges:
  • SELECT statement in SAP

    what are various select statements used and where are they used.what is value table.

    Anil40610 pointsBadges:
  • SQL Server Stored Procedure

    An interesting question asked to me. We always mention, we can do lots of things inside a SQL Server Stored Procedure. But does anyone know what cannot be done inside a SQL Server Stored Procedure?

    Topsidestone5 pointsBadges:
  • SQL 6.5 Upgrade

    We recently upgraded an application from MS SQL 6.5 to MS SQL 2008. We took quite a performance hit. Is this to be expected?

    DickRich15 pointsBadges:
  • Adding SQL perfrmon counters

    Recently a site administrator installed a SQL2000 server on Windows 2003. For some reason the perfmon counters for SQL do not show up when trying to check performance. How should these counters be added and/or activated post-installation? In the IT trenches? So am I - read my IT-Trenches blog

    Labnuke9932,960 pointsBadges:
  • SQL Stored Procedure

    Is there a way to call a child stored procedure form a parent sp but then immediately stop the parent?

    Bbdezine235 pointsBadges:
  • Using SQL Server databases on data with numerous checks

    I am interesting in cleaning census data, and I have a number of edit checks, consistency checks, validation checks and range checks to perform. What is the best practice you would recommend, using SQL Server as the database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Viewing distinct records in a SQL query result

    I have a set of records in a SQL query result. I only want to see one record, per the data field "ID". I am getting 2 records for some ID's, as there is one field that is different in the 2 records. This happens even if I start the query out with SELECT, DISTINCT, and then all of the fields I need....

    SQL Server Ask the Experts2,585 pointsBadges:
  • Delete names from an email list in SQL Server Integration Services

    How can I delete names from an email list in SQL Server Integration Services?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Refresh a SQL View in ILE

    I have created a view and am using in an ILE module. I have updated one of the files that the view is built with. How do I refresh the View to see this record the next time I run the SQL view? Is there a CREATE OR REPLACE VIEW in RPGILE? Thank you.

    BisonHawk25 pointsBadges:
  • Running queries causing system to hang

    A few weeks ago we had a major crash that was caused by a bad install. I wiped the machine and reinstalled the OS (Windows Server 2003). At first everything appeared to be fine. We are using: 2 x 4 core 2.33 GHz Xeon E5345 Intel s5000XVN motherboard 12GB Ram ATI Radeon x300 Video The machine is...

    WindowsServerATE335 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