
	Home > Ask the SQL Server Experts > Archive: Development Questions & Answers > Calling an extended stored procedure in SQL Server 2005

Ask The SQL Server Expert: Questions & Answers

EMAIL THIS

Calling an extended stored procedure in SQL Server 2005

EXPERT RESPONSE FROM: Greg Low

		Pose a Question

		Other SQL Server Categories

		Meet all SQL Server Experts
		Become an Expert for this site

Expert advice on database development

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 11 September 2007
I'm having a problem calling an extended stored procedure (specifically xp_cmdshell) from java, using the JDBC for SQL Server 2005. By using the JDBC for SQL Server 2000 Service Pack 3, I can call it like a normal stored procedure. With SQL Server 2005, I get the following:
om.microsoft.sqlserver.jdbc.SQLServerException: The request for procedure 'xp_cmdshell' failed because 'xp_cmdshell' is a procedure object.

It is a SQL Server 2000 server. I want to use the new 2005 JDBC because it does not have problems with cloned connections in manual transaction mode. I had problems with the selectMethod=cursor property on my webserver, it just didn't seem to take. It worked fine from my local webserver during development, but for some reason doesn't work when running on the live webserver. Is it even possible to call this extended stored procedure?

Yes, by default, it's disabled in 2k5 as it's not considered safe. You can enable it using the Surface Area Configuration Tool if you think it's appropriate.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	SQL Server Stored Procedures
	SQL Server Mailbag: CALs, witnesses and unwanted changes
	SQL Server Mailbag: Stored procedures, triggers and SSRS reports
	Top tips and tricks for SQL Server database development
	Top 10 SQL Server development tips of 2008
	SQL Server trigger vs. stored procedure to receive data notification
	SQL Server errors, failures and other problems fixed from the trenches
	SQL Server and data manipulation in T-SQL
	How to use SQL Server 2008 hierarchyid data type
	SQL Server stored procedures tutorial: Write, tune and get examples
	Check SQL Server database and log file size with this stored procedure

Microsoft SQL Server 2005

End of life comes for SQL Server 2005 SP2, 2008

SQL Server Reporting Services Fast Guide

SQL Server Service Broker Tutorial and Reference Guide

Tips for tuning SQL Server 2005 to improve reporting performance

SQL Server consolidation: Why it's an optimization technique

Parent-child dimensions in SQL Server 2005 with Analysis Services MDX

Enforcing data integrity in a SQL Server database

SSIS error message due to installation problem on SQL Server 2005

Should you upgrade to SQL Server 2005 or SQL Server 2008?

Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005

Microsoft SQL Server 2005 Research

Archive: Development

Copy stored procedure between SQL Server 2005 databases

Should developers have permissions to SQL Server production queue?

Schedule stored procedure and save output to network drive

Query to find SQL Server database names created by users

Is it possible to find disabled indexes in SQL Server 2000?

SQL Server id permission to create and modify tables

Problem attaching stored procedure and SQL Server trigger

Installing different SQL Server versions on one machine

Multiple SQL Server instances vs. multiple databases

VARCHAR and NVARCHAR data types in SQL Server 2005

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

library (SearchSQLServer.com)

trigger (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SQL Solutions - SQL Database Design

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy