Run this script from any database.
Help! My Database is Marked Suspect.
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)
58,842 reads
Mohamed Qasim,
2011-11-11 (first published: 2011-09-27)
Run this script from any database.
SET NOCOUNT ON declare @db_list table( row_no smallint identity (1,1), db varchar(200)) INSERT into @db_list select name from master..sysdatabases declare @first smallint declare @last smallint declare @db varchar(200) declare @sql varchar(500) select @first = min(row_no) from @db_list select @last = max(row_no) from @db_list create table #db_file_list ( db_name varchar(100), Filename varchar(200), file_location varchar(500)) while @first <= @last BEGIN select @db = db from @db_list where row_no = @first SET @sql = 'INSERT INTO #db_file_list select '+ CHAR(39) + @db + CHAR(39)+' ,name,filename from '+ @db+'..sysfiles ' --print (@sql) exec (@sql) SET @first = @first + 1 END --select * from #db_file_list where file_location like '%N:%' select * from #db_file_list drop table #db_file_list SET NOCOUNT OFF
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)
58,842 reads
The second part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2003-12-25
13,017 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,576 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,376 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,697 reads