Use this script to create a warm standby database server for all your user database. This new version has a new feature to allow the standby database to be in a ready-only mode so that users can access it. You can change the job schedule to suit your requirement. One bug has been fixed that […]
2002-10-31
286 reads
This simple script make a comparison between two given database. It compare: The table present in both database The data type, lenght, nullability, precision for each table. The object present in both database. The StoredProc is able to compare database across different server, simple make […]
2002-10-31
800 reads
This is not an original script - but one I modified from an article by Darren Green on databasejournal.com (02/21/2000). His original script changed the owner of all DTS packages owned by @old_owner to be owned by @new_owner. This script will change the owner of the most recent version of a specific DTS package (@p_name) […]
2002-10-29
493 reads
Here is another Number of Days in the Month function for SQL Server without the use of Case or if statements. It uses the DATEPART and DATEADD built-in functions.
2002-10-28
412 reads
The script will do the following:- build a ten digit phone number regardless of input column size.- Ignores extensions- Ignores leading 1, as in 1(800)...- Ignores most special characters or spaces- converts literals to digitsIt can be easily convert to a UDFEnjoy.C. Z. Ovits
2002-10-28
563 reads
2002-10-28
77 reads
Using the sp_help to get a table structure is very cumbersome. First, in order to print it you have to use"Results in Text" not "Results in Grid". Second, the results are very wide screen-wise and very hard to read or print. Third, you do not get the size or number rows with the same request.This […]
2002-10-28
184 reads
This script will list the spaceused by all tables in a database. You can order the output by changing one of the parameters.It also provides totals
2002-10-27
669 reads
Recently I saw here a script that returns the number of days of the month however I made my own script and I think that it's better elaborated. It's true that this is my opinion, but here it's. Evaluate it yourself.print dbo.f_days_in_month('2000-02-21')
2002-10-26
469 reads
This stored procedure extract the error code and description form the DTS package log tables in the msdb database.You just pass it the package name, step name and the time that the step started ( because you could end up with many entries in the log ) and it will return the Error Code and […]
2002-10-25
2,668 reads
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...
The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...
With in the paginated report I am trying to display on each new page...
Hi All, I have plan to upgrade SSIS and SSRS from SQL Server 2016,...
Comments posted to this topic are about the item Do You Want a Microsoft...
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers