2004-03-04
135 reads
Checks Triggers status on User- Databases.
Introduction:SQL Server 7.0 introduced a new class of functions that return a wide range of property information that isn't readily available in SQL Server 6.5 and earlier versions. These functions have three general classes: TypeProperty, which returns information about a data type; ObjectProperty, which returns information about objects in the current database; and ColumnProperty, which […]
2002-07-19
123 reads
Recompile Compiled Objects
This stored procedure, updates the schema version of user table(s), which in turn marks the Stored Procedures and Triggers for recompile.
2001-09-05
1,396 reads
Blogs
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
SQL Server 2025
By Vinay Thakur
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...
Advice I Like: Apologies
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Forums
Influencing a Local AI
Comments posted to this topic are about the item Influencing a Local AI
Data API Builder Operations
Comments posted to this topic are about the item Data API Builder Operations
SQL Clustered Resource in online pending for about 3-5 mins before coming online
Hello! SQL Clustered resource used to come online during manual or automatic failover in...
Question of the Day
Data API Builder Operations
What types of database operations does the Data API Builder support?
See possible answers