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
919 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
321 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,216 reads
2001-09-04
514 reads
2001-08-22
383 reads
hx_DatabaseProperties
Displays database properties. Was this the best way of doing it? Probably not, but it works.
2001-08-22
521 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
353 reads
2001-08-22
706 reads
2001-08-22
532 reads
2001-08-22
689 reads
Blogs
AWS RDS SQL Server Announcements - 2019
1. Amazon RDS SQL Server Supports differential and log and restores: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/ 2. Amazon RDS SQL...
What is a strong password anyway?
Background Fellow Microsoft MVP Troy Hunt (blog | Twitter) has been operating the website Have...
Forums
Looking for SQL Code
Hi I am having situation where I would like to update the existing data...
Looking for SQL Code
Hi I am having situation where I would like to update the existing data...
SQL Server new Linked Server
hello my friends. I have a suuuuuper weird question about sql server, at my...
Ask SSC