This script can be used when we can not obtain the data dictionary of a database
SELECT TAB.NAME AS NOMBRE_TABLA, COL.NAME AS NOMBRE_COLUMNA, TIP.NAME AS TIPO_DATO, COL.MAX_LENGTH AS TAMAO, CASE WHEN COL.IS_NULLABLE = '0' THEN 'NO' ELSE 'SI' END AS ACEPTA_NULL, EXT.VALUE AS DESCRIPCION FROM SYS.TABLES TAB INNER JOIN SYS.COLUMNS COL ON TAB.OBJECT_ID = COL.OBJECT_ID INNER JOIN SYS.TYPES TIP ON TIP.USER_TYPE_ID = COL.USER_TYPE_ID LEFT OUTER JOIN SYS.EXTENDED_PROPERTIES EXT ON EXT.MAJOR_ID = TAB.OBJECT_ID AND COL.COLUMN_ID = EXT.MINOR_ID
If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.
2007-09-22 (first published: 2004-03-31)
59,154 reads
The second part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2003-12-25
13,154 reads
So you've created a diagram that you now need to transfer to a different server or database. This article will show give you a step-by-step guide on how to do this.
2003-11-13
11,688 reads
When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.
2007-10-02 (first published: 2002-08-14)
24,644 reads
An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge
an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL.
2001-06-27
14,816 reads
