For SQL Server in Mixed Authentication mode thisstored procedure helps to validate users password. Currently this procedure checks for the next requrements: password must have length at least 8 characters plus among them at least one digit and at least one of the characters must be in upper case.
2003-03-11
786 reads
Do you hate using bitwise operands? I do, a lot. I wrote the following function to try to minimize the need for using them. When testing 'status' variables in the 'sysobjects' table, for example, I decided there just had to be an easier way to see if bit 31 is set than asking if STATUS […]
2003-03-07
776 reads
Purpose: This SP is used to add a logfile and a datafile to each file group in a database or all databases. This is handy when you have a lot of databases and you want to add a new big SAN-disk and stop db expansion on the old disks.Consider: Avoid running any large updates when […]
2003-03-06
135 reads
Some of my developers had created jobs that executed VB applications that never ended. Aparently they could not figure out when, why and what was going wrong. They could not repro the situation.Now I've created this litle system so the users can assign max elaps times for their jobs. These jobs will then be intercepted […]
2003-03-04
485 reads
This Stored procedure is used for granting rights to a particular role. user has to just Pass Role Name as argument.It will assign Right on User Table and Stored Procedures.
2003-02-27
153 reads
I do a lot of SQL Server Desktop Edition instance testing and I cobbled together this script from BOL and other scripts I've seen posted. It is intended to show version, service pack level, machine and instance name and the security type among other information. Hopefully someone else may find it of use.
2003-02-27
261 reads
A week ago I posted this script. It was a much simpeler version without error checking. Now all the sprocs return the same errors. 0 THERE WERE NO ERRORS -99 UNEXPECTED NR OF RECORDS AFFECTED 0 THE SQL ERROR NUMBER Also with the insert statement the @ID is set. So you can retrieve the […]
2003-02-25
412 reads
A procedure send message to all active SQL Server users(SQL Server Connections) on your Server.I use Win command NET SEND.
2003-02-25
547 reads
You can use this procedure to find any word or sentance, which u used in procedures, views, triggers and function. This procedure is basically a modified form of system procedure "sp_helptext". Now its upto you to use that and modified that. To execute the procedure, first create it in your Database and then execute it […]
2003-02-24
161 reads
A Procedure send Alert by E-Mail about allfiles with option "Restrict File Growth" ifavailable space less then 10%.
2003-02-24
327 reads
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Hub Via Wa:628218154374 Alamat: Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Hub Via Wa:628218154374 Alamat: Jl. P Jayakarta Komp. No.127, RT.7/RW.7, Mangga Dua Sel., Kecamatan...
Hub Via Wa:628218154374 Alamat: Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5,...
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers