The error says that

does not exist.

When you paste that string in the start/run box, what happens? Does it have any difficulty finding the file?

Hmm. Microsoft says their independent SP2 upgrade is good for all SQL 2005 except Express (http://www.microsoft.com/downloads/details.aspx?FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en). There it reads,

Note: To upgrade SQL Server 2005 Express Edition, obtain the SP2...

Normally, on a table with a clustered index...

ALTER INDEX ALL ON mytable

REBUILD

reclaims space when a variable or fixed column is dropped.

Since you have no index, you could add and drop...

After connecting (sqlcmd -Sserver\instance, etc.), you can even PASTE MULTILINE TEXT in a single paste, such as an entire alter procedure script or stack of other commands (including "go" statements...

In the function I wrote, you'll need to change the input param away from int, and then rename the columns and tables to match your latest submission. You might also...

As another option, you could create a function to concat the data by acctID, and then call that function in a select statement, like this:

Create FUNCTION dbo.Concat(@n AS INT) --@N...

I don't know of a script, but just to be sure you know about these options for identifying instances, whether they are running or not...

1) In Administrative Tools/Services, you'll find...

The link in my previous post in turn offers a link for "setup documentation," which is a help file (.chm) that includes detailed documentation for installing from a command prompt.

SQL 2005 SP2 is available online at

http://www.microsoft.com/downloads/details.aspx?FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en.

I have installed it quietly with these flags

SQLServer2005SP2-KB921896-x86-ENU.exe /instancename=MyInst /quiet /sapwd=MyPwd

By remote, do you mean accessing an existing Express instance across something like pcAnywhere?

Are you working without the Management Studio?

If so, then you can launch a command window and use...

Others experiencing your error found it to be a permissions issue

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=309967&SiteID=1

Attaching the MDF and LOG files from a 2000 instance to a 2005 instance can be done with the "for...

Junior_DBA, you asked,

Upgrading from...

I also noted some occurrences where statement_end_offset came back as 0, so I made the change for my purposes to treat it like -1. Otherwise you get back only one...

I hadn't noticed that. No point multiplying and dividing by 2.

I should've dug further when I saw it was you, Gail. You always do nice work.

Run DBADave's original query as is and check the result; it won't return the full query.

Add the "*2" and you'll get the whole thing.

I also ran with a second query...