Question about Microsoft SQL Server 2000 Standard Edition for PC

1 Answer

How to stop sql sp_procedure_params_rowset

Hi Friends

can you tell me

how can we stop sql store procedure sp_procedure_params_rowset ?

Rikin Pandya

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert whose answer gotĀ voted for 20 times.


    An expert who has answered 20 questions.

  • Expert
  • 118 Answers
Re: how to stop sql sp_procedure_params_rowset

Sp_procedure_params_rowset is called internally by client APIs to get stored
procedure meta data. For example, I believe the .Net SqlCommandBuilder uses
it. If you don't want to call it, you can change the application code to
avoid using the functionality provided by the proc.

Posted on Dec 19, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

4 Answers

What the presager of SQL repair by any tool

Latest tool is here if you want try please use SQL repair tool to repair and recover MDF file with loss of any data. Visit here:-

Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...

3 Answers

Better and safe way to repair and recover MDF files

To choose a reliable and 100% safe and secure, a SQL server database recovery utility guarantee the zero loss of quality. You can refer to this page: and also read this post

Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...

4 Answers

Some great advice for all SQL server user

You should try some MDF file recovery tool if the file is corrupt.

Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

I want to decrypt encrypted SQL Stored Procedure 2008?

Hi walllerry,
I have read your problem and I go through it by reading some tutorials or searching some best software that quickly solves your problem. At last I found SysTools SQL Decryptor Software and read its features or information. It's really amazing software and it also having the solution for your problem that it decrypt encrypted SQL Stored procedure 2008. I am giving you the link please visit:

May 22, 2013 | Business & Productivity Software

2 Answers

Sql procedure

Dear friend you can get all your answers about stored procedure in sql server through this link:

good luck

Feb 25, 2009 | Microsoft SQL Server 2005 Enterprise...

1 Answer

DB2 Connect and Excel

hi, you can use the SQL Drill freeware addin ( It is an addin which lets you connect to ODBC compliant databases (DB2, Oracle, SQL Server etc..)

Dec 03, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

SQL Server 2000

An easy way to transfer objects (tables, user defined functions, stored procedures, etc.) is to use Enterprise Manager's "Generate SQL" feature. Use this process at your own risk. Doing it wrong could mess up your existing database.

1. In Enterprise Manager, right-click on the old database and choose "All Tasks" then "Generate SQL Script".
2. In the dialog that comes up, click "Show All" then select the checkboxes for "all stored procedures" and "all user defined functions". (You might also want to check some other boxes, depending on your exact situation.)
3. Click the "generate" button and save the script that it creates.
4. Run the script in the NEW database.

If you run the script in your OLD database, it may destroy your objects, and that would be very bad. Make sure you run the script in your NEW database. (While we're on this subject, it's a good time to mention that you should back up your database before you start this process, and you should make changes to a test system before migrating it to production.)

That should move your stored procedures and user defined functions over.

You can use a similar process to move tables, views, users, and other objects over as well.

Jan 17, 2008 | Business & Productivity Software

1 Answer

Stored procedures

They are permanent procedures stored in the database that allow repeated execution of reusable SQL code. They are also compiled and stored in a cache repository to make their repeated execution more efficient.

The alternative to Stored Procedures is to use in-line queries "select * from table where field1 = value" hard-coded in your VB or C# application. This option though is less than ideal. Any change to the in-line query and you have to recompile the application.

The better way is to use a stored procedure, whose name doesn't change, and the parameters don't change. If the code has to change, then it's done in the stored procedure and recompiling the application isn't needed.

Oct 02, 2007 | Microsoft SQL Server Standard Edition for...

1 Answer

How to write stored procedures

SQL: A Beginner's Guide (Paperback) by Forrest Houlette, a pretty easy to follow book! ZT3000 "Beta tester of "0"s and "1's"

Aug 23, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Microsoft SQL Server 2000 Standard Edition for PC Logo

Related Topics:

745 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides