All Columns from user tables and views
This script lists the columns with type and length. It eliminates system tables.
2001-12-13
749 reads
List all primary keys
Thanks to Raul Sharma for his brilliant ideas. This is a modification of one of his scripts. The script takes only the user tables. Those tables which does not have PK are not listed!
2001-12-13
717 reads
Blogs
Extended Events Misperceptions: Profiler is Easier, Part 2
I wrote a short blog post about the misperception that Profiler was easier than...
CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))
If you read the title to this post and your first thought was That’s...
sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019
sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...
Forums
Auditing System questions- no personal experience
Good Morning All -I have used triggers to do some basic auditing, but I...
SQL replication in real-time
Hello, Our company has used SQL replication to refresh our staging data on a...
Ask SSC