Steve,

I appreciate the reply.  My main problem in checking load is that I don't currently have a DW side to check the load against.  I will, however, check the load against...

There is a TON of data in Books Online about XML under the heading "XML".  The very first thing I thought of when I saw your post was mapping the...

Absolutely.  The key is knowing what the carriage return character looks like (which I, unfortunately, don't).

You can do this one of two ways.  1) Use an SSIS package to pull the...

I think you should test this.  Create a job that does a few daily backups via the traditional SQL Server method, but backs up to the SAN drive.  Tack on...

YOu'd have to talk to the hardware guys to verify everything, but you absolutely CAN take one server and hook it up to a SAN after another server crashes.  The...

SQLBill?  Tek-Tips SQLBill?  If so, this is Catadmin.  Hi!  @=)

NB, SQLBill is correct.  You cannot backup SQL Server on a network share.  It has to be backed up to a...

We've never had any problems with doing traditional SQL backups on our SANs.  We just set our maintenance plans to delete backups after X number of days and Transaction logs...

Are you trying to enter your server name as opposed to creating a Mail connection object?  Or are you just needing the server name as the "FROM" part?

If the later,...

I'd be interested in hearing this too.  Please post your solution.

Thanks, @=)

Ah.  Thanks, Brian.  I'll try that.

Select cu.*, c.Data_Type, c.Numeric_Precision, c.Column_Default

from information_schema.Constraint_Column_Usage cu

join information_Schema.Columns c

on cu.Table_Name = c.Table_Name

and cu.Column_Name = c.Column_Name

WHOOHOO!  It works.  Thanks again.  And, this is the query I'd...

I'm trying to.  And it always double spaces it even though SSMS has things single spaced.

Oh, right.

Try joining to Information_Schema.Columns on TableName and ColumnName.  This should give you all the column information details.

How are you guys getting your code pasted into one line...

Or you could make it really simple.

Select

* from information_Schema.constraint_column_usage

Should work on both SQL 2000 and SQL 2005 and gives you table names as...

Of the logins you've listed, the only two native to SQL Server 2005 are the NT Authority \ Network Services and NT Authority \ System logins.  Because they are native...

We use Erwin by Computer Associates.  It's pretty nifty.  Took me a little time to get used to it, but now I love the Reverse Engineering and Complete Compare tools. ...