• Shell script within Stored Procedure

    How do I execute a UNIX shell (.sh) script from within an MS SQL Stored Procedure?

    VelameLaCosa110 pointsBadges:
  • ODBC Connection to iSeries

    Hi, My company has just upgraded to V6RM0 of iSries and I have had problems connecting to the new server through ODBC using Crystal Reports or SQL server DTS. The packages I already had set up are still functioning and I can get a connection OK, but whern I try to create a new package I get an a...

    MBell40 pointsBadges:
  • Increasing SQL Server performance by excluding files from anti-virus scanning

    To increase our SQL Server’s performance, we would like to take these certain steps: 1. Exclude the anti-virus software from scanning .mdf, .ldf, .ndf, .dtsx, .sql and .msc files. 2. Turn off I/O scanning for the writing to disk and reading from disk processes. 3. Disable buffer overflow...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to config iSQL Plus on computer without a domain

    Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message "The server encountered an internal error or misconfiguration and was unable to complete your...

    DerrickOra5 pointsBadges:
  • SQL 2008 Identity column values 0

    We recently migrated our application from sql 2005(32 bit) to sql 2008(64 bit). I have observed that one of our tables with an identity column is now having all values are 0. I am yet to find out the reason .Could this be related to migration??

    Swetaleena5 pointsBadges:
  • Does something similar to Oracle’s optimizer hints exist in SQL Server ?

    In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc... Does something similar exist in Microsoft Sql Server ?

    carlosdl71,415 pointsBadges:
  • 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:

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