sp_MSTableSpace and sp_MSforeachtable combined
The following stript combines two previous articals. sp_MStablespace was being demonstrated with a cursor. To reduce the code the sp_MSforeachtable could be used.
2003-07-08
535 reads
Blogs
Renewed as a Friend of Red Gate
By Brian Kelley
I recently received the news that I’ve been renewed as a Friend of Red...
Redgate Software Needs You!
I’ve been very blessed to be able to work for Redgate Software. We’ve done...
Extended Events: Database Auditing
Extended Events can do things that simply are not possible with Profiler and another...
Forums
SSMA 8.6 Unable to find functions in extended stored procedures
I have an instance of SQL Server 2017 (Developer) installed with SSMA for Oracle...
Running generic query for table information
Hi, I want to run the below query to get information about the tables...
Instance level trigger to store login information (who created what)
Hello SSC, I am looking for a simplified way to track which user created...
Ask SSC