easiest route is this

1.create a new blank database in SQL

2.right click the new db --> tasks --> import data

3.follow the wizard step by step up to Save and Run package

4.save...

happy to help.

as i said in my original post, what is the business requirement for having dates as varchars? if there isnt any, I would recommend putting a task...

first of all, can you detail why you are storing dates as varchar and not datetime and what is the business requirements for doing this

secondly you could set dateformat =...

thats good that the database has come back online, but the root cause should be investigated as to why the DB went into recovery_pending and should be fixed to stop...

if you have the operators already set up on the job then it should work, as you have not change the way in which SQL agent sends its mail, just...

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 ,...