This proc compares the table definition and the data in a table which is in two of your databases. Typically you may have a development database and a production database on the same server and you just want to know that the table is the same on both. (This proc will express the data differences […]
2002-02-11
292 reads
This script runs from the master database and records all the databases on the server. It then checks each database for users and records their name and the database(s) on which they have access. You can then create a nice cross tab report using any report designer (I used crystal) showing users on the databases […]
2002-02-11
510 reads
This is a simple function I use to get the month/day/year of a datetime value.Usage:Select mydb.dbo.udfmmddyyyy(Getdate()) Note: This is easily modified for British/Australian date format.
2002-02-11
1,178 reads
I occasionally need to return a month and year but would like the month as a 3 letter abbreviation instead of a number. This is useful for reports.Usage:Select mydb.dbo.udfmmm_yyyy(Getdate())
2002-02-11
1,006 reads
Since SQL Server stores time as a full datetime value, I use this script to return just the time part formatted as hh:mm:ss.Usage:Select mydb.dbo.udfHHMMSS(Getdate())
2002-02-11
925 reads
This script provides the DDL required to unconstrain and then reconstrain a table so that in between you can modify the tables contents without being hampered by referential integrity constraints a long the way.Typical call:- utl_UnConstrain 'MyTable'
2002-02-11
252 reads
If you need to check that the tape back of your database backup files was successful, you would generally read the errorlog for the backup software.If you are just interested in today's results or a particular day's log it can be a pain to get. You could have a shortcut on the desktop or you […]
2002-02-10
386 reads
This is an updated scripts with some useful modification for the script submitted by Seshu Kanuri
2002-02-07
739 reads
I use the following script to find out what was running at around the time something of interest happens on our SQL Server. I haven't got around to making this a stored procedure, but it is easy enough to change the date and time interval.
2002-02-06
720 reads
This stored procedure implements a kind of SELECT NEXT x TOP y Columns FROM Table WHERE Condition ORDER BY Order. It works on any table that has a unique id column and it works with any WHERE clause and any ORDER BY condition. The only drawback is its very poor performance on large tables. This […]
2002-02-06
1,240 reads
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
You kick off a distributed job expecting it to finish in minutes — but...
A while ago we suddenly had an error while trying to deploy one Fabric...
Tlp/Wa_Cs:0817-866-887 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175 @BCA KCU...
Tlp/Wa_Cs:0817-866-887 Jl. Jend. Sudirman Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa Tengah...
Tlp/Wa_Cs:0817-866-887 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec. Kebayoran Lama,...
Which types of currency does the money data type represent?
See possible answers