Browse by Tags

All Tags » stored procedure (RSS)
Quick and simple way to know the stored procedures parameters using TSQL
Published 8 July 8 6:13 AM | SSQA.net
As you may be aware that you can pass parameters to the stored procedure when you have the selection of data requirement such as stored procedure with data type,length, parameter position and also the mode of parameter (Input or Output). Using INFORMATION_SCHEMA...
Filed under: , , , , ,
FIX: Error message when you run a long stored procedure that is encrypted in SQL Server 2005: "A stack overflow occurred in the server while compiling the query"
Published 24 June 8 8:33 AM | SSQA.net
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New FIX: Error message when you run a long stored procedure that is encrypted...
Filed under: , , , , , ,
Error message when you run the bcp utility to copy a result set of a stored procedure that contains a dynamic query in SQL Server 2005: "BCP host-files must contain at least one column"
Published 2 June 8 4:1 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Error message when you run the bcp utility to copy a result set of a stored procedure that...
Filed under: , , , , , ,
How to drop all tables, all views, and all stored procedures from a SQL Server 2005 Database?
Published 20 May 8 3:12 AM | SSQA.net
It may not be a hardcore requirement on day-to-day basis to drop all tables, views and stored procedures from a SQL Server database within your environment, but it will be handy to have such a code at your end when such task is required. There are 2 ways...
Filed under: , , , , , , ,
SQL Server 2005 debug a stored procedure, how-to?
Published 11 February 8 3:38 AM | SSQA.net
If you are Developer then debugging your own code is an usual practice and when you got used to perform the same on SQL Server 2000 version, it is not an easy way in SQL Server 2005 version. As you may be aware that SQL Server 2000 engine includes a debugger...
Filed under: , , , , , ,
SQL Server error - The linked server has been created but failed a connection test. Do you want to keep the linked server?
Published 16 January 8 1:40 AM | SSQA.net
Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual...
Filed under: , , , , , , , , , ,
SQL Server undocumented stored procedure to get information on login mapping name
Published 24 December 7 6:55 AM | SSQA.net
They say better not to use UNDOCUMENTED stored procedures, which is true in the aspect when any Service Pack or version is released that may not be included and your task might have issues in working out. Similar to this I was going through various methods...
Filed under: , , , , ,
How do I find the parameters for a specified stored procedure or function?
Published 10 December 7 5:21 PM | SSQA.net
USE < database_name >; GO SELECT SCHEMA_NAME ( schema_id ) AS schema_name , o . name AS object_name , o . type_desc , p . parameter_id , p . name AS parameter_name , TYPE_NAME ( p . user_type_id ) AS parameter_type , p . max_length , p . precision...
Filed under: , , , , ,
Database Mirroring sys.sp_dbmmonitorupdate stored procedure fails with error "Incorrect syntax near '-'"
Published 12 November 7 3:23 AM | SSQA.net
Recently got stuck with the stored procedure sys.sp_dbmmonitorupdate which is used to monitor the database mirroring session. As usual you could do using the GUI tool, but sometimes using TSQL methods is good enough to see what is happening on your system...
Filed under: , , , , , , , , ,
Stored Procedures caught me with too many recomplies - way out to avoid it
Published 25 October 7 3:35 AM | SSQA.net
A common scenario in SQL Server environment that often application users complained about slow performance and same time you observe high CPU usage/spikes on the SQL Server instance, so better to follow the methods from HighCPU-whyitis blog and still...
Filed under: , , , , , , , ,
Ways to make best use of INFORMATION_SCHEMA Views - Stored procedures & Functions?
Published 15 October 7 7:59 AM | SSQA.net
How many of you took help from using INFORMATION_SCHEMA views in SQL Server? Have you ever wondered in returning the informaiton of a Stored procedure or function, you may be thinking using SP_HELPTEXT would get you. Parts of the solution is yes with...
Filed under: , , , , , , , ,
FIX: You may receive an error message when you run a CLR stored procedure or CLR function that uses a context connection in SQL Server 2005
Published 12 September 7 12:36 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: You may receive an error message when you run a CLR stored procedure or...
Filed under: , , , , , ,
FIX: SQL Server 2005 does not reclaim the disk space that is allocated to the temporary table if the stored procedure is stopped
Published 12 September 7 12:35 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: SQL Server 2005 does not reclaim the disk space that is allocated to the...
Filed under: , , , , , ,
Need to grant permission to view stored procedure text
Published 10 September 7 3:24 AM | SSQA.net
If you need to grant permissions to a login that only needs to view stored procedures (contents not just names of SP's). Further you may not want to grant that login with DB_OWNER or DB_DDLADMIN roles within that database, so how to achieve this task...
Filed under: , , , , , , ,
How to use a stored procedure to monitor traces in SQL Server 2005
Published 4 September 7 11:39 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications How to use a stored procedure to monitor traces in SQL Server 2005 http://support...
Filed under: , , , , ,
TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)
Published 4 September 7 9:32 AM | SSQA.net
PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query...
Filed under: , , , , , , , , ,
FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 2005
Published 23 August 7 6:29 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Filed under: , , , , , ,
FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor"
Published 23 August 7 6:25 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Filed under: , , , , , ,
Performance Tuning - will I loss the indexing when using derived table?
Published 21 August 7 3:19 AM | SSQA.net
This was the question asked by a Developer when we are investigating a performance loss issues on a database. To the point a derived table means a virtual table that's calculated on the fly from a select statement. By default using derived tables...
Filed under: , , , , , ,
TSQL to get list of Stored Procedures created in last x days
Published 2 August 7 6:4 AM | SSQA.net
SELECT name FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,create_date, GETDATE()) > 7...( read more ) Read More...
Filed under: ,
More Posts Next page »