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

I think you just need to add [font="Courier New"]@Startingdate =[/font] before [font="Courier New"]s2.StartDate[/font]. Can you guarantee that the SELECT query will always return a single row only?

John

Are you looking for separate rows for each backup type for each database? If so, just add backup type to your SELECT list and GROUP clause. If ,...

Petr

In that case, yes, change CategoryID to varchar something, and then use something like this page[/url] for tips on how to perform your concatenation.

John

Petr

This isn't possible - CategoryID is int, so you can't change it to 2,7. Even if you could, I'd advise you not to - you're breaking the laws of...

I would suggest a slight modification to the above, since the previous ID is not always going to be the current ID minus 1 (there will be gaps). Also,...

Dave

The problem with a maintenance plan is you don't have much control over what it does. What you want to do is only rebuild the indexes that need it....