Yes, just use the FILE = 6 option in your RESTORE statement.

John

Werner

In order to eliminate the NIC as the cause of the reduced performance, select your query results into a temp table instead of having them returned to the caller. ...

If it's a live server, definitely not. Sysadmin should only be given to DBAs. We don't live in an ideal world, so sometimes we have to make exceptions...

http://msdn.microsoft.com/en-us/library/hh231187(v=sql.110).aspx

John

Dave

Here's what I'd do.

(1) Script all indexes and constraints and then drop them

(2) Add the new column to the table. You should only need int - it will allow...

Does it make any difference if you rewrite the last part of your query like below? You haven't given us anything to work with, so obviously I haven't been...

Ah yes - didn't notice that! Thanks, Gail.

John

Just as a matter of interest, why are you switching to single user mode? It's not necessary under normal circumstances to do so before taking a transaction log backup.

John

If we don't understand your requirement, it's difficult to advise you. Such arbitrary stipulations make this sound a bit like a homework assignment. So, what makes you so...

WITH Names (personid, firstname, lastname, gender) AS ( -- sample data

SELECT 1, 'John', 'Smith', 'M' UNION ALL

SELECT 2, 'Sandy', 'Smith', 'F' UNION ALL

SELECT 3, 'Sandy', 'Jones', 'M' UNION ALL

SELECT 4,...

Excellent. By the way, you can avoid repeating that concatenation in the GROUP BY clause by using a CTE:

WITH CTE AS (

SELECT

CONCAT(CONVERT(varchar(5),LEFT(IMADD.Postcode, 5)collate DATABASE_DEFAULT),

'/',

CASE

WHEN DATEDIFF([year],IMIND.DOB, GETDATE()) - CASE...

Since the error occurred in the concat operation, you just need to make sure that all the things you are concatenating have the same collation. One way of doing...

If you don't have BIDS or SSDT or Visual Studio, but you know the name of the stored procedures(s) you wish to compare, you can script them out and use...

You can use ranges for pattern-matching, such as [0-9] and [A-Z]. See the LIKE topic in Books Online for more information.

John

Please will you post the result of this query?

John

SELECT type_desc, data_space_id, name, size, max_size, growth

FROM MyDB.sys.database_files