Displays Identity Column Values
Displays identity column values, number of rows in the table, and the difference between the two. The difference can indicate the amount of deletions that could be going on.
2001-10-21
921 reads
Display Identity Values and Other Info
Displays identity values, number of rows in the table, and the difference between the two. The difference can indicate the amount of deletions that could be going on.
2001-09-06
325 reads
Display Stored Procedure Parameters
Display any stored procedures using input and output parameters. I took the view, PARAMETERS that ships with SQL 2000 and cleaned it up a bit.
2001-09-04
1,221 reads
2001-09-04
518 reads
2001-08-22
386 reads
hx_DatabaseProperties
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
525 reads
hx_dbMaintancePlans
Displays Maintance plan history if any. I used distinct to filter out and return only what is relevent to what I need. You may not wish this for your purposes. Feel free to make changes
2001-08-22
356 reads
2001-08-22
710 reads
2001-08-22
537 reads
2001-08-22
693 reads
Blogs
Daily Coping 21 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
It’s 2021, so why are you reading this?
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....
Daily Coping 20 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Save results from Stored procedure to a CSV file.
I have a SqlAgentJob calling a stored proc. that loops through a list of...
Search Report definitions
I know that there is a query you can run in SQL to search...
Lookup and insert into column without dynamic SQL?
Hi all, 99% sure the answer to this question is "it is not possible",...
Ask SSC