You did restart the server (the physical server, not SQL Server) after doing this didn't you?  If not, you need to.  We had the same problem a couple weeks ago. ...

SELECT CAST(spv.name AS VARCHAR(5)) FROM master.dbo.spt_values spv

SELECT spv.name FROM master.dbo.spt_values spv

Use ROWCOUNT and see what that gives you.

To do this, you need to:

1.  Create a temp table with columns that match the output of the Stored Procedure.

CREATE TABLE #recordset(

ident INT IDENTITY(1,1) PRIMARY KEY,etc,etc)

2.  Do an INSERT...EXEC.  You...

Hi Chris.  You should go to http://www.asp.net and download one of the starter kits.  They have SQL Server databases included and you can learn several different ways of connecting...

You can't.  If you can find someone who got Beta 1, they can share it with you.  They handed it out at last years PASS conference and a few other...

There are several ways to do this Erik.

1.  You can set up a linked server from server A to server B. (Look up linked server in Books Online).

You can then...

Don't divide by zero.    You need to figure out where you are doing this and fix it. 

Ahhhhh....pobrecito.

You followed what syntax?  You might want to post the code.  Also, the account has to have sufficient priviliges to run sp_attach_db.

Only members of the sysadmin and dbcreator fixed server...

Telecommuting.......are you kidding!!!!!   It's Costa Rica.  I would move there in a heartbeat.  Just pay me enough I can fly back to the USA every 3 months or so.

If you don't want to do log backups on the msdb database, and I don't know why you would, you can just set the recovery mode to simple.  This will...

--Also, here's a script for you while I'm at it. 

DECLARE

 @int_counter INT,

 @int_max INT,

 @txt_name NVARCHAR(255),

 @txt_sql NVARCHAR(2500)

DECLARE @databases TABLE (

 int_id INT IDENTITY(1,1) PRIMARY KEY,

 txt_name NVARCHAR(255))

INSERT @databases(txt_name)

 SELECT name FROM...

sp_changedbowner

Read all about it in Books Online.  It really shouldn't be owned by a person BTW.