Browse by Tags

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: sql server, stored procedure, tsql, information schema, parameter, views

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, backup, table, drop, stored procedure, tsql, best practice, views

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: sql server, function, stored procedure, tsql, schema, parameter

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: sql server, function, system, stored procedure, tsql, best practice, information schema, views, triggers

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: sql server, kba, transaction, enterprise, x64, stored procedure, tsql

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: stored procedure, tsql

Conditional Failed because the followng SET operations has incorrect settings: 'ARITHABORT'

Published 16 July 7 3:10 AM | SSQA.net

I got this error when trying to drop and create an index on a table. Create failed for index IX_USER_ID (Microsoft.SQLServer.Smo) Additional Information An exception occured while executing a transact sql statement or batch (Microsoft.SQLServer.ConnectionInfo...

Filed under: sql server, indexes, compiled, stored procedure, tsql, arithabort