filter on dbid

USE master

SELECT name, DB_ID(name) AS DB_ID

FROM sysdatabases

ORDER BY dbid

The install works fine, the warning message is informational. After the install simply add the sp.

This will give you what you need (think I got it from here originaly) delete or add a line to get more or less digits:

select CAST ( CONVERT ( INT,...

You could have a look at this ms article: http://support.microsoft.com/default.aspx?scid=kb;en-us;271509

Schedule this to run whenever the dts is going to be run and then look at the output file.

Look up sp_changedbowner in bol, should give you what you need

If its a dev box are you looking to get data back or code, if its code then you could Reset the Suspect Status and try and run a dbcc...

Might be an idea to create a user table on a test box and then run the sql to change the user table to system table, while this is happening...

instead of referencing a mapped drive use the full unc path:

\\servername\drivename\folder\etc

First easy thing to do is put in more ram if you have more slots, its relativley cheap and usualy gives a good return. Depending on the sql version you...

DOH!

Thanks cmille19, should have actualy used my brain on this. Working like a charm now.

I am having message server does not exist. Any tips on what I am doing wrong would be appreciated.

create a sql job and have the first step execute this code:

--set recovery model

Set quoted_identifier off

use master

go

DECLARE @dataname varchar(100)

DECLARE datanames_cursor CURSOR FOR SELECT '['+name+']' FROM sysdatabases

        WHERE name not in...

You could save them as visual basic files and then open each one in text editor and search.

Don't know if the log file is corrupt or not, but you could use sp_attach_single_file_db (look it up in bol) stored proc which will recreate the log file if the database...

I believe sql is doing an implicit conversion of int to date.