SQL Server Error 7202 Could not find server
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 [...]

Answer Question   |  March 31, 2012  2:12 PM
SQL error messages, SQL Server, SQL Server error messages, SQL Server stored procedures

Thousands and thousands of simultaneous users hitting a sproc — what do you do?
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 [...]

Answer Question   |  February 16, 2011  12:14 AM
SQL Server, SQL Server 2008, SQL Server stored procedures, Stored Procedures

Cross-database name change in SQL Server 2008 stored procedures
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: [...]

Answer Question   |  February 2, 2011  5:03 PM
SQL 2008, SQL Server 2008 R2, SQL Server stored procedures, Stored Procedures

Stored Procedures in SQL Server 2005
Will you please explain me about Stored Procedures in Sql server 2005

Answer Question   |  January 13, 2011  4:53 AM
SQL Server, SQL Server 2005, SQL Server stored procedures, SQL stored procedures, Stored Procedures

Migrating stored procedures from SQL Server 2000 to 2005
after migrating store procedures from 2000 to 2005 sql server, how we can check the store procedures are migrated correctly without executing them?

Answer Question   |  January 3, 2011  4:06 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server stored procedures

SQL Server 2005 procedure to Create stored procedure
sir,plz tell me the procedure from strating that how to create stored procedure

Answer Question   |  December 11, 2010  11:19 AM
SQL 2005, SQL Server 2005, SQL Server stored procedures, SQL stored procedures

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

Answer Question   |  November 11, 2010  6:28 AM
SQL Database, SQL Server, SQL Server stored procedures, Stored Procedures

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?

Answer Question   |  September 15, 2010  5:22 PM
SQL, SQL 2005, SQL Log Files, SQL Server 2005, SQL Server stored procedures, Stored Procedures

Calling stored procedure in a database to query data in another database
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 [...]

Answer Question   |  February 14, 2012  3:20 PM
SQL 2005, SQL Query, SQL Select, SQL Server, SQL Server 2005, SQL Server 2005 administration, SQL Server stored procedures, T-SQL

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

Answer Question   |  June 10, 2010  1:49 PM
Relational databases, SQL Server stored procedures, Stored Procedures

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.

Answer Question   |  April 25, 2010  9:16 AM
SQL Server 2005, SQL Server Reporting Services, SQL Server stored procedures

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,  

Answer Question   |  February 16, 2010  4:04 PM
SQL Server 2008, SQL Server 2008 extended stored procedures, SQL Server stored procedures

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.

Answer Question   |  February 11, 2010  2:21 AM
SQL Server, SQL Server 2005, SQL Server stored procedures

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 [...]

Answer Question   |  January 13, 2010  12:02 PM
Microsoft Excel, SQL Server 2005, SQL Server stored procedures

Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime
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 [...]

Answer Question   |  November 30, 2009  3:27 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server stored procedures

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.

Answer Question   |  August 12, 2009  6:27 AM
SQL Server 2005, SQL Server stored procedures

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

Answer Question   |  June 3, 2009  7:33 AM
RunTime, SQL Server 2000, SQL Server development, SQL Server stored procedures

stored procs in Master db, sql server 2005
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

Answer Question   |  May 16, 2009  3:49 PM
SQL Server 2005, SQL Server stored procedures, T-SQL

How can I call a trigger in a SQL Server stored procedure?
How can I call a trigger in a SQL Server stored procedure?

Answer Question   |  May 2, 2009  7:20 PM
SQL Server, SQL Server stored procedures, SQL Server triggers

How do you create stored procedures in SQL Server 2000?
How do you create stored procedures in SQL Server 2000?

Answer Question   |  May 15, 2009  7:18 PM
SQL Server 2000, SQL Server stored procedures