Hi all, I am currently running into the following error when run a stored procedure with BEGIN TRANS: ”Could not find server ‘VS-DEVELOPERDEVELOPER_SQL’ in sysservers. Execute sp_addlinkedserver to add the server to sysservers.” The server shown above is the a local sql server instance that is running the stored procedure and therefore shouldn’t need to [...]
folks, i am not a db guy altogether, but I am a developer, and someone had asked me that question, and i got interested in the resolution. Lets say you have 50K users that hit the same stored procedure at the same time. The stored procedure is computation intensive and goes out to lunch for [...]
Hi: The easy part is the databases will be on the same server. However at the moment I am writing code in database SOMEDATABASE_TEST which is accessing objects in SOMEOTHERDATABASE_TEST. When its time to go to production the names are going to change to SOMEDATABASE and SOMEOTHERDATABASE. However the queries in SOMEDATABASE_TEST stored procedures read: [...]
Will you please explain me about Stored Procedures in Sql server 2005
after migrating store procedures from 2000 to 2005 sql server, how we can check the store procedures are migrated correctly without executing them?
sir,plz tell me the procedure from strating that how to create stored procedure
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
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?
Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData ‘some_remote_db_name’; and [...]
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
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.
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,
Hi, Does anyone know how to calculate the procedure cache ratio in SQL Server 2005 by selecting specific table in SQL Server? Thanks.
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 [...]
Hi, This is Pushan Chakraborty from Kolkata.I have complied 2 stored procedure to retrieve the names of 2 user defined tables that I have created . The stored procedures are: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go — ============================================= — Author: <Pushan Chakraborty> — Create date: <23rd nov> — Description: <retrives the name of [...]
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.
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
Does anyone know where I can get a list describing, in layman’s terms, all the sp_usr… stored prodedures in the Master database? New to all this and don’t have the time or knowledge to decipher the TSQL behind it. Hope someone can help! Cheers
How can I call a trigger in a SQL Server stored procedure?
How do you create stored procedures in SQL Server 2000?





