Indexes and Deadlocks
Friday, March 30, 2012
Informational Queries
›
Hello, Are there any commands that would give infomation on all DBs on a SQL server? (IE size, location of files, name, that sort of thing?)...
Information_Shema as a user in Master database
›
Hi, All Recently, I was running a script like: declare @.sql nvarchar(4000) declare @.db sysname ; set @.db = DB_NAME() declare @.u sysname ...
INFORMATION_SCHEMA: Probably bug in SQL-2005
›
Try to run this script, first in any database under SQL-2000, then in SQL-2005: select COLUMN_DEFAULT from INFORMATION_SCHEMA.COLUMNS WHERE ...
INFORMATION_SCHEMA.SCHEMATA does not return all rows on SQL 2005
›
Hi, In SQL 2000, the following query used to return all the database names: SELECT CATALOG_NAME FROM INFORMATION_SCHEMA.SCHEMATA However, in...
INFORMATION_SCHEMA.ROUTINES LAST_ALTERED not changing
›
Why is the LAST_ALTERED datetime column in INFORMATION_SCHEMA.ROUTINES NOT changing when I perform a ALTER PROCEDURE statement? When would i...
INFORMATION_SCHEMA.ROUTINES LAST_ALTERED not changing
›
Why is the LAST_ALTERED datetime column in INFORMATION_SCHEMA.ROUTINES NOT changing when I perform a ALTER PROCEDURE statement? When would...
INFORMATION_SCHEMA.ROUTINES LAST_ALTERED not changing
›
Why is the LAST_ALTERED datetime column in INFORMATION_SCHEMA.ROUTINES NOT changing when I perform a ALTER PROCEDURE statement? When would i...
›
Home
View web version