• sp_OACreate is missing

    Hi I'm trying to create a stored procedure to send mail, and 1 line in my SP states: EXEC @hr = sp_OACreate 'CDONTS.NewMail', @MailID OUT But I get an error that sp_OACreate is missing. How it happened I don't know. But how do I fix the problem? Is it possible to recreate sp_OACreate manually?...

    Kowalski5 pointsBadges:
  • Spawning additional stored procedures in SQL Server 2000

    Is it possible in SQL Server 2000 for a stored procedure to spawn a second stored procedure which will not interfere or slow down the processing of the original? I need the original procedure to finish and return its output variables to the calling program before the second (whose function is to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating stored procedures from SQL Server 2000 compatibility mode to a SQL Server 2005 database

    I recently migrated some reports and stored procedures from a SQL Server 2005 database server in SQL Server 2000 compatibility mode to a SQL Server 2005 database. Afterwards, we have not been able to get the stored procedures to run to completion. We have found two issues: one is collation between...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copying a SQL Server stored procedure with a query

    I want to copy a SQL Server 2005 stored procedure by using a query, much like the way a table is copied with one. Does a query exist that could perform this task for me?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Executing a Stored procedure using Excel Macro

    I am an amateur in SQL programming. Could you please tell me how to execute a Stored procedure using Excel Macro (VBA Programming) and then save the record set into different Excel sheets?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Stored procedures in SSRS

    Can we call the stored procedure in SSRS when creating reports.I am new to sql server plaese help me in this question

    Sriradhi25 pointsBadges:
  • Execution time is varying with query analyzer and visual studio 2005

    when a stored procedure is executed in query analyzer its working fine and getting the result quickly.but when same procedure is executed through visual studio timeout expired error is generated.can any one olve this issue

    Abcp5 pointsBadges:
  • Is it possible to have a SQL Server stored procedure in Domain A read data from tables in Domain B?

    I want to have a stored procedure on a server in Domain A, read data from some tables in Domain B. Is this possible in SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Running Procedures within the PL/SQL program

    WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!

    Nimsalwayz5 pointsBadges:
  • How to pass Parameter of stored procedure Crystal report

    How to pass parameter of Crystal report from visual Basic while crystal report created with stored procedure

    N75 pointsBadges:
  • How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel

    I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t know...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I collect database/server information across multiple MSSQL versions.

    I would like to collect database info(backups, databases, logins, etc) as well as server information ( MSSQL version, patch level, etc). I would like to use one server to collect information from all of my servers. I have MSSQL 7, 2000, & 2005 on Windows servers 2000 & 2003. I am also new to MSSQL...

    AngieJo20 pointsBadges:
  • Having problems converting SQL Server queries to stored procedures

    I am using SQL Server queries as in-script and I have now decided to use the queries as stored procedures. However, I am facing some problems while converting the SQL Server queries into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I move all stored procedures to a new SQL server?

    I recently moved a database from SQL Server 2000 to a new server running SQL Server 2005. Is it possible to move all of the stored procedures to the new server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Stored Procedure Problem

    Hi Greg, I am using SQL queries as in-script and now decided to use them as stored procedure. I am facing some problem while converting them into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query, which I was using with asp. SQL = “Select *...

    Anilak singh5 pointsBadges:
  • SQL Server – I would like a stored procedure that will take the name of a table as input.

    I would like a stored procedure that will take the name of a table as input. What the procedure would do is drop all indexes on that table except any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another stored procedure that takes a table name as...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I initialize arrays in stored procedures?

    How can I initialize arrays in stored procedures?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Passing a database name as a stored procedure parameter

    I would like to be able to pass the name of a database as a parameter to a stored procedure. This db would be used for certain queries and may be different from the db where the stored procedure runs. Is it possible to specify a database name from within the T-SQL of the stored procedure? If so,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Equivolent SQL Server function for Access DoCmd.TransferText

    I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?

    Paul4815 pointsBadges:
  • Stored Procedure for dropping indexes

    I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another strored procedure that takes a table name as...

    Dangagne30 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