Greg,

Thanks for the tip (I didn't know you could do that!); unfortunately, the problem appears to be system related (what it is I am unsure!). The error after the restore is...

The strange thing is that the database was restored with the RECOVERY option. The database was left in a LOADING state due to the error that was raised...

Hi Terry,

No they are different in a number of config values; but I can't see anything obvious that would help me to resolve the problem!

As a work around to restoring...

I simply perform a normal full backup of a database (doesn't matter which one) with the INIT command. Then created a new database, and perform the restore. The error is...

Thanks tosscrosby.

I did read the article from ITtoolbox, though helpful, it did not resolve my problem.

The backup of the databases have been restored successfully on a different server but not...

There is a 'compatibility collation', which is somewhat different to either SQL Collation or Windows Collation. This knowledge base article has more about it, if you're interested:

http://support.microsoft.com/kb/270042/

You will have issues if the SP has temp table or declared table variables having character fields not defined with the COLLATE DATABASE_DEFAULT option. As these tables are created in...

You should always create a windows account with password set to 'does not expire' as a service account for starting the SQL Server and SQL Agent services; otherwise, everytime you...

Just make sure that no one else is using the database. After which you can use the sp_detach_db and sp_attach_db after the relevant files are moved to their new location.

One should always take comments like this to be instructive, which is what it was meant to be! In any case, BOL should be your first point of call -...

It looks kosher to me! What is so peculiar about it?

This seems to work:

select convert(varchar,cast(12345 as money),1)

A Foreign Key (FK) column is a column that has a FK constraint defined. Assuming you have these two tables:

Create Table dbo.TableA (ID1 INT NOT NULL PRIMARY KEY, ColA1 VARCHAR(10))

Create...

Search BOL for the DATEPART() function. You can use this in the body of your SP to associate the year, month and day parameters; or simply use it in-situ!

You may need to store the files in a table first, eg.

create table #files (file_properties varchar(1000))

INSERT INTO #files (file_properties)

EXEC master..xp_cmdshell 'DIR <switches and parameters>'

The DOS command 'DIR' provides a switch...