Warning: This script has no DBA value, but is useful for DBAs who have inclination towards occultƒº.Yesterday I had to decide the name of my new website. Since I wanted the name to be numerological correct. I wrote a T-SQL script for the same.For those of you who are not familiar with Numerology let me […]
2007-11-12 (first published: 2007-09-04)
591 reads
This SP will be create C# classes using all table in the specified Database
2007-11-13 (first published: 2007-09-04)
2,490 reads
this procedure takes a sql login name and returns information about the login.anyone who knows Sybase will recognise the name and layout. use :- exec sp_displaylogin 'loginname' to get login information returned.this procedure has been tested on SQL Server 2005 sp2any problems email pgr_consulting @ yahoo.com
2007-11-09 (first published: 2007-08-31)
1,093 reads
Get space for all user defined table information like size and row counts.
2013-12-27 (first published: 2007-08-29)
7,518 reads
List permissions for an object in various ways.
2013-12-19 (first published: 2007-08-27)
18,487 reads