• SQL Server 2005 procedure to Create stored procedure

    sir,plz tell me the procedure from strating that how to create stored procedure

    Gkhlhlhjhhghgg15 pointsBadges:
  • How to find particular database in SQL stored procedures other than manually?

    Hi all, i have a Stored Procedure, i need to find the database in which the particular SP is available, i dont want to go through all the SP's........... Is there any way to find the database using server name, i need the query for this.. Please help me

    Sagi5 pointsBadges:
  • Log of stored procedures run on my SQL 2005 box.

    How can I tell who ran which stored procedure on our SQL 2005 server and at what time? Can we see if one stored procedure called other stored procedures there as well? Can we enable verbose logging somehow as well for more data?

    Karl Gechlik9,860 pointsBadges:
  • To write a stored procedure

    there are two tables one ZipCode and one tempTable each has ZipCode and CongDist as columns. Each Zipcode has more than one CongressionalDistrict. How can I write a SP to have a seperate entry for each senario of Zipcode and Congressional District in tmp Table

    SProcedure25 pointsBadges:
  • Using stored Procedure in SSRS

    Hi.... I am trying to create a Report using Report wizard in MSSRS 2005, I am trying to use Stored Procedure. The steps which I am following are below.... Solution Explorer--> Add New Report--> Next(as DB is already shared one)--> Query Builder (But when going into query builder the...

    Rohitd235 pointsBadges:
  • SQL Server Business INtelligence

    While creating a report, is it ok to create data set using stored procedure by calling an existing one from the database, or, by creating a stored procedure within BIDS and imeplement it? Please, explain. Thanx in advance.

    RonitReno25 pointsBadges:
  • SQL 2008 stored procedures and execution plans

    Hi, Is it any significant difference in performance between stored procedure with many parameters (some of them can be null sometimes) and creating many stored procedures that will contains only subset of this parameters ? Thx,  

    Bink15 pointsBadges:
  • Procedure cache ratio calculation in SQL Server?

    Hi, Does anyone know how to calculate the procedure cache ratio in SQL Server 2005 by selecting specific table in SQL Server? Thanks.

    Db23290 pointsBadges:
  • Create Excel file on web server by using SQL

    How can I create an excel sheet on web server by using a stored procedure in SQL Server 2005. I'm retriving data from sql select query and creating Excel file dynamically on we server of that data using asp.net. But I want to do this with the help of SQL stored prcedure. i.e. In a stored procedure...

    SwapnilD25 pointsBadges:
  • PRINT statement in Stored Proc SQL Server 2005

    Does PRINT statement in stored proc cause network traffic or any performance issues? Can i get some tips to write good store proc that gains performance.   Thanks.

    Jsql155 pointsBadges:
  • Purpose of creating SQL Server stored procedures at run time

    Hi Experts, I am a programmer in SQL. Please explain me the purpose of creating stored procedures during run time and it's effects on performance and memory. Please provide me if there is any best alternative for this. Thanks in advance

    Skothamasu15 pointsBadges:
  • Output errors from SQL Server stored procedure

    I have a stored procedure using SQL Express that update a table using data from another table. All is well except that from time to time the source table might have data that causes an error. I would like to add some code to the stored procedure that will catch the error, output the details to a...

    Spionred35 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:
  • How do I refresh the Stored Procedure used for Crystal Reports datasource

    I have an existing Crystal Report that uses a Stored Procedure as a datasource. The requirements have changed and the Procedure has been updated to have only one parameter instead of two. How do I refresh the Stored Procedure without removing it. I have tried to Verify the Database but just get an...

    Flyght55 pointsBadges:
  • How do I avoid a security exposure using XP_SendMail

    I'm using XP_Sendmail in a trigger on my database. In order to run the trigger, I have to give database access to the "guest" user. I'm concerned about security. I've tried a Stored Proc called SP_Sendmail that calls XP_Sendmail, but I still have to grant db access to the "guest". Any help here...

    Arlin70 pointsBadges:
  • I need to up load an excel file to sql server db with vb

    I need to upload a excell file to sql server. I made a Stored procedure with the openrowset but if i run de stored procedure works, but embebed in visual basic or in crystal repor an error appears.Somethig about serverliked or server trusted i don't rememeber. does somebody an idea? thanks in...

    Xs4010 pointsBadges:
  • Creating tables on a SQL Server

    I am creating a directory of local businesses. I have found that my city is divided in to 4,816 business categories, which means I need that many tables in my database. Is there any way that I can create these table with a stored procedure, a SQL function, or a SQL script file? I want to use a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Unreported error in an order entry application designed in SQL

    I have developed an order entry application in SQL Server for a client. One of its functions is to insert invoices into the relevant tables. The procedure only does the job 997 times out of 1000 on average. In a single day, that means that hundreds of invoices are incomplete. No errors are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is there a query to retrieve datatypes from SQL stored procedures?

    I have used the following simple query to retrieve datatypes from SQL Server 2000 tables: select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = '<tablename>' and column_name = '<columnname>' Along these...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Convert SAS to Stored Procedure

    How do I convert a SAS job into a Stored Procedure to run on MS SQL Server 2005?

    VelameLaCosa110 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