What is the error?  Are you using OLE/DB or ODBC? 

I assume that the userid you signed on with is a valid login for the server as well as having...

The CD has a warranty.  For replacement info see the last page in your book for instructions.

When executing xp_sqlmaint there is a limited number of options to use.  RebldIdx is the option to rebuild indexes.  I don't think you can change it to execute INDEXDEFRAG rather...

You can use xp_sendmail to send mail that inclues the results of a query.  ie:

Declare @sql nvarchar(200)

Declare @parmindex nvarchar(20)

Declare @sid varchar(3)

set @sid = 34

set @sql='select cast(Client as char(30)) from Clients...

see http://vyaskn.tripod.com/watch_your_timeouts.htm for a timeout discussion. It may not help with ODBC connection butit may help with IIS.

I like #1, but I think the cube should be yellow because that has the most RAM. 

Check out http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=99545#bm99584 for some opinions on this.  Basically use WITH ENCRYPTION option when creating the stored procs or use some 3rd party tool like SQL Shield.

You can use the Export/Import Wizard (but this is really just DTS) SO if you don't want to do this then try either:

a.  Backup you database (copy the backup file...

How about something like:

DECLARE @sql nvarchar(2000)

DECLARE @out integer

--loop through all tables in tablelist

DECLARE @objName VARCHAR(50)

SET @objName = ''

WHILE @objName IS NOT NULL

 BEGIN

  SELECT @objName = MIN( TableName )

  FROM TableList

  WHERE TableName > @objName

  IF @objName IS NOT NULL

   BEGIN

    -- Insert...

I'm not sure what the 16 means- that column is marked as for internal use only.  Did you try to drop the user using the sp_dropuser command?  That table could be...

If you have configured memory to be dynamic as opposed to fixed size, and you have checked off use all available processors; then you should have to do anything after...

Have you looked at this script to see the approach used?

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=594

ApexSQL Log also works very nicely for this.

The conversion to carbinary is important.  The problem isn't a syntax one so much as you are cutting and pasting the output then reexecuting it.  Passsords (and sometime other system...

Try CAST or CONVERT.  For more info see http://www.sqlservercentral.com/columnists/sjones/castyourdata_printversion.asp