Browse by Tags

Site sponsored by:

Try Idera’s new SQL admin toolset

RSS Feeds

stored procedure (RSS)

SQL Server Migration Assistant - what are the conversion rules between Oracle and SQL Server during the migration?

This was the big question posed by the users when a migration project is initiated at one of client's place. SQL_Server_Migration_Assistant is a must tool to asses the issues when you have a mammoth task of data migration between SQL Server and other data sources such as Oracle & SYBASE. You...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 09-09-2008
Insert-Exec local vs Linked server

I have a proc that collect disk space usage from the server. When I execute that proc it works fine. When I insert the results into a table it fails with the error: An INSERT EXEC statement cannot be nested. The command: insert into dba_diskspaces (server,Drive,Free_MB,Total_MB,Free_Per) exec dba_diskspace...

Posted to SQL Server 2005 General Developer Questions (Forum) by ScubaFuz on 08-29-2008
Re: SP problem

How about populating a temp table from each query? Also consider indexes.

Posted to SQL Server 2005 General DBA Questions (Forum) by Anoop on 08-01-2008
Quick and simple way to know the stored procedures parameters using TSQL

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 views you can get further information...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 07-08-2008
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"

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 in SQL Server 2005: "A stack overflow occurred...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 06-24-2008
How to check the performance issue in procedure cache in sql 2000

Hi, Pls let me know how to identify the performance issues in procedure cache using syscacheobjects.

Posted to Performance Tuning for DBAs (Forum) by DuraiRaj on 06-20-2008
Re: To delete log files

HI Satya, Actualy i want to create a sp for this .Once i have sp i will schedule that sp as a job to run every day. I want the sp to schedule in production.If you have that sp please share with me. Thanks, Thulasi R

Posted to General DBA Questions (Forum) by rayala.thulasi on 06-11-2008
To delete log files

HI All, I want to delete one month old log files in production serevr .For this i need schedule the script to run everyday. Can any one suggest me on the same. Thanks, Thulasi R

Posted to General DBA Questions (Forum) by rayala.thulasi on 06-11-2008
What Settings Will Speed This Up?

Hi, This has been driving me nuts for a few days now. I'm more a developer than DBA, but the answer I suspect lies in the Server configuration. Apologies for the length of this, but I have tried a lot of things. Scenario : We get a monthly database dump in the form of a 1.5Gb csv file, comma delimited...

Posted to Performance Tuning for DBAs (Forum) by peridian on 06-09-2008
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"

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 contains a dynamic query in SQL Server 2005: "BCP...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 06-02-2008