Thank you all !

Yes, I have been using sp_helpdb databasename. this gives me DB name, logical DB name, physical file locations, size, owner.....

From there I am able to cut and...

Thanks but I got some crazy HTML output that really isn't very usefull to me..

I just wanted to know if the character '/' was allowed in the varchar datatype. I had an import blow up this morning and the constraint that it...

Thank you all !!!!!

How are you doing your Backups?  are you backing up to a 2nd Server or Backing up locally and then copying the Backup Files?

To backup\restore across the Network, I...

Thank you so much!!!  I logged onto my server with the Domain account that starts the services and created my outlok profile that way.  and it WORKS!!!!

I restared both services and the option to set a mil profile in the general properties of the agent are still greyed out? 

Just an FYI ..  I found what I was looking for here:

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

Thanks!!!!

One more time..  : )

Here's what I changed my query to: (looking for text 'RECOVERY')

drop table #tmp

go

create table #tmp (table_name varchar(50), column_name varchar(50), num_records int)

declare @table_name varchar(50), @column_name varchar(50), @sql...

Thank you.   Changed the query to dbo.sysobjects and dbo.syscolumns and I'm not getting this:

Invalid column name 'object_id'

Thanks very much. You guys are awesme.   The code from that previous post looks like what I'm looking for - but I get this error when I execute it:

Server: Msg...

WHen I run any maintenance JOBS, it is writing to a file called SQLAGENT.OUT

Still, the sp_cycle_errolog appears to run, but does nothing - does not checkpoint the log.  still not...

They are also NOT apprearing in EM.

Here are my startup parameters:

-dF:\DR_datafiles\master\masater.mdf

-lE:\DR_logfiles\master\mastlog.ldf

-ef:\dr_datafiles\log\errorlog

I logged onto the database server with the domain account that starts the services and I CAN write...

Yes, In the same destination folder where I should see current and past errlog files, I have 3 Agnet Log files called  sqlagent.1 sqlagent.2 and sqlagent.out