Right click on the database name, select view, select taskpad.  You will now see the space allocated and space used for the database and log files.  If you then click...

Will the data always be in the formats that you showed us?

ie, there won't be a value of 'AB2' or '3A4', but always a number followed by an alpha, or...

The extension is not nearly as important as the format.  What format is the file?  What application created it?  Is it a text file?  comma delimited, tab delimited?

Steve

Try this...

declare @user sysname

set @user = 'dbo'

select so.[name], so.xtype, su.[name]

 from sysobjects so

 join sysusers su

 on so.uid = su.uid

 where su.[name] = @user

-- Steve

Are T and H mapped drives or are they allocated at the system level?

/*

First, a couple of suggestions….

You should probably plan to make backups more frequently than once...

Not sure if this applies to your situation, but I've had the registered servers "disappear" from EM before as well.  This probably does apply to Mike's situation.

In Em, on the...

I thought this seemed interesting and that functions to convert between julian and gregorian might be useful. 

So, here goes -

-- Steve

/*

Usage examples -

DECLARE

 @Date datetime,

 @Julian int

SET @Date = '2004-08-03'

SELECT @julian-2...

same server?

If so, just qualify the table names with the database and owner....

Pubs.dbo.authors

Northwind.dbo.Customers

Steve

Take a look at the "SP Wildcard" thread in this topic

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=129509

Steve

If I understand your question....

where column is not null

and column <> ' '

Steve

I was puzzled about what was wrong with Phil's query, so I tried it against the employee table in the pubs database.  It seems to work perfectly!

declare

 @var1 varchar(30),

 @var2 char(1)

set @var1...

Yes.  Your Select statement is ok.  Just remember to qualify the tablename (otherwise SQL thinks the table should be in the current database).

SELECT *

FROM DB_2..syscolumns

WHERE name = '<column_name>'...

What error did you receive when you attempted to run the restore with move?  The syntax looks ok.

Steve

From Books Online (Backup/Restore Architecture)