Clear all user objects
This procedure will drop (with care) all user-defined objects: constraints, procedures, functions, triggers, views and tables. Used for re-creating database schema without drop and create database.
2003-04-07
90 reads
Enhanced sp_password
This is a sp_password enhanced by Dmitri Bobkov (see http://www.sqlservercentral.com/scripts/contributions/718.asp) and re-enhanced with a small changes from SQL2kSP3.For SQL Server in Mixed Authentication mode this stored 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 […]
2003-03-27
409 reads
Blogs
Daily Coping–3 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Data Céilí 2020 Cancelled
Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing...
Code from Redgate Streamed
By Steve Jones
I presented a session today at Redgate Streamed and did a number of demos....
Forums
Delet old backup in azure
Hello, How to delete backups in blob storage from azure sql server VM to...
Fully Qualified Name
First time poster...not sure this the correct section to post this question. I have...
expand field and fill with zeros
I am using this statement: Select @Data = @Data + RIGHT('00000000000' + CAST( (SUBSTRING(STR(@qtramt1),1,11))...
Ask SSC