Find a string in Procedures, Triggers, Constraints, Defaults, Functions, and Views. First off this will not work for any items that have the WITH ENCRYPTION remark in them. With this is can pose a string such as 'INSERT' against all the 'P'rocedures to get a return of which Procedures have an INSERT statment in them […]
2002-02-21
1,740 reads
You can effectively rename a user account but as this is messing wit the system tables I would suggest dropping and adding the user back. But for those of you who really want to know how here it is.First off I tested this and it works fine renaming a user. However this is directly modifying […]
2002-02-14
958 reads
In SQL 7 you had no way to convert local time to GMT (UTC time) which was added in SQL 2K as GETUTCDATE() which will output the current date you would get with GETDATE() but a it's GMT counterpart. Although this was a great improvement I work with data on another server that's front end […]
2002-02-05
695 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Wa:082374977784 Jl. Mayor Abdurahman No.181-183, Kotakaler, Kec. Sumedang Utara, Kabupaten Sumedang, Jawa Barat 45322
Wa:082374977784 Jl, Jl. Boulevard Raya Blok FX No.9-10, RT.8/RW.13, Klp. Gading Tim., Kec. Klp....
Comments posted to this topic are about the item Risk Vs Reward, The never...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers