Stack Overflow
Stack Overflow

Questions tagged [system-stored-procedures]

Pre-compiled and pre-designed subroutines available to applications to access specific system level details. They can not be modify because of the lack of user privileges.

11 questions
10
votes
2 answers

How do I check the size of an indexed view in SQL Server?

Its easy to check storage sizes for Tables and Indexes, you can right-click the table object on SSMS explorer and voila, the details appear in a nice popup. But since Indexed Views are displayed the same as Normal Views, there is no storage…
Steven de Salas
  • 20,944
  • 9
  • 74
  • 82
6
votes
3 answers

retrieve most recently executed SQL command (T-SQL)

One of my developers working on a trigger-based logging facility in SQL Server 2008 asked me if there was a command to retrieve the most recently executed SQL command within T-SQL. I thought there was a system stored procedure for just such a…
Hardryv
  • 755
  • 7
  • 12
5
votes
1 answer

T-SQL: sp_MSdependencies Flags parameter

can anybody tell me what are valid values for the flags parameter of the sp_MSdependencies stored procedure and especially what do they mean.
Dimi Takis
  • 4,924
  • 3
  • 29
  • 41
4
votes
1 answer

How to use a system stored procedure in LINQ to SQL

I'd like to add the "msdb.dbo.sp_help_job" system stored procedure to a LINQ to SQL object, but I can't figure out how to specify it. If I create a new Data Connection in Server Explorer and specify the "msdb" database of the server I want, and…
gfrizzle
  • 12,419
  • 19
  • 78
  • 104
2
votes
2 answers

How to detect and replace non-printable characters from table?

I have imported data from xls file into table. but there are some garbage (non ascii charactors). I want to remove those non printable characters from database. here is the query i found which can select the entries which has non-ascii characters …
Prabhu
  • 178
  • 2
  • 12
1
vote
1 answer

sp_send_dbmail is missing in sqlserver2008

I am unable to find the system stored procedure sp_send_dbmail, which should be under System Databases -> msdb. msdb.[dbo].sp_send_dbmail . But it's missing under the location where it should be. What should i do?
kaarthick raman
  • 793
  • 2
  • 13
  • 41
1
vote
5 answers

Generate Multiple and Filtered Drop + Create Stored Procedures

I have this script: select name,create_date,modify_date from sys.procedures order by modify_date desc I can see what procedures were modified lately. I will add a "where modify_date >= " And I'd like to use some system stored procedure, that will…
Swoosh
  • 33
  • 2
  • 7
0
votes
1 answer

What DML operations a table is performing inside Stored Procedure or SQL Functions

I am using SQL Server 2014. I have some user defined tables like Customer, PurchaseOrder, User, and so on. I am using those tables inside many stored procedures. In some cases, those stored procedures are almost 1000/1500 lines long. Now I want to…
Kuntal Ghosh
  • 3,548
  • 2
  • 17
  • 21
0
votes
1 answer

How to include parameter when inserting stored procedure results into table?

This code inserts the results of a stored procedure into a table. eg sp_configure etc. CREATE TABLE #toto (v1 int, v2 int, v3 char(4), status char(6)) INSERT #toto (v1, v2, v3, status) EXEC dbo.sp_fulubulu(sp_param1) SELECT * FROM #toto DROP TABLE…
Danny Rancher
  • 1,923
  • 3
  • 24
  • 43
0
votes
2 answers

System Stored Procedure Missing

I'm beginning in SQL Server dev. I'm working with 2 servers, one has a System Stored Procedure called "sp_send_dbmail" from the dbo schema on the System Database msdb but the second hasn't it. When something is missing on one of theses servers, I…
M. Ozn
  • 1,018
  • 1
  • 19
  • 42
0
votes
0 answers

What sys.sp_addextendedproperty doing?

I am deleteing one month data from table tbl_testrecord (diagrev is one of the colume )in test database now .And i will going to do same in Production database. When i am comparing script of the same table in test database and production database,…
sony921
  • 109
  • 13