what is the actual error message of the job step, not the whole job

RESTORE DATABASE databasename FROM DISK = 'path to unc bak file' WITH REPLACE,

MOVE 'data file logical file name' TO 'physical file name', --must be a local drive

MOVE 'log file logical...

i always thought that DBCC INPUTBUFFER only returns the last statement in the batch which is being executed, so you might give it 10 commands to do and it will...

i wouldnt go down that route personally

i would go for one of the second two, install express or push the data instead of pulling

express will only be there as a...

Right, going back to a post I said earlier.

You say you are running SQL Mail on this server. This means that you must have a linked server to which...

i would prefer to do this side by side if at all possible that way you have a good rollback plan should it all go the wrong way.

if you have...

local access is accessed from only the SQL server itself, local and remote is the share name which can be used to unc from a client machine to the SQL...

from the article there are three options

install SQL 32bit instead of 64bit

install SQL Express 32bit side by side your 64bit instance and use a three hop method 64bit to...

if i am reading this right, you want to install SSRS 2008 but leave the ReportServer and ReportServerTempDB on SQL 2005 as SQL 2005 databases, not new databases created with...

what you need is a string spliter then if they are all in one field but you want to break it into 5.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

the above should help, you could use ,...

you say the table has four columns in the following order

DirName | ReadAccess | WriteAccess | FullAccess

And you want the table to be returned as

DirName | ReadAccess | WriteAccess |...

the 4gb limit still applies to 2008 Express R1, the limit was increased to 10GB in R2

this is a limitation of FILESTREAM from what I have been reading, the FILESTREAM file needs to be on a local drive to the SQL server hosting the DB.

I would...

you could create a role, put the users in the role, grant the access needed to that role, that way you can add and remove users as you wish and...

Is this a 64 bit server?

There are some issues in connecting on 64 bit SQL

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/4887d91f-6ac7-40c0-9fc8-5cdd0634e603, its about Vista x64 and SQL 2008 x64.