2004-03-04
133 reads
2004-03-04
133 reads
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
122 reads
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,394 reads
By Patrick
One of my customers recently wanted to rename each of the SQL audit files...
The post The pros and cons of self-service BI: What every industry leader should...
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
Morning all, I've inherited a small (on prem) SQL estate. I'm a DBA, used...
insert into NewKms8081..members SELECT (select u2.Id from SecurityKms8081..users u2 join SecurityKms8081..Import_users_barghGharb i2 on i2.code_personeli=u2.PersonnelNumber...
I am running SQL Server 20.2. When I copy a query into the query...
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers