Take a look at this article from Jeff Moden. http://www.sqlservercentral.com/articles/Tally+Table/72993/

"Registered Server" is a feature within SSMS only. If you want to write a query using other servers (instances) you could set up a linked server.

I've created a list of the last backups for each database and join this with the [backupset] to get the associated "media_set_id". I've put this query inside a CTE so...

Do the tables hold data for a single client, or...

What do you mean with the above quoted phrase:

1. two instances (with each one database) on the same...

When you specify the body_format as HTML you also need to use HTML paragraph endings. Try using "<p> </p>" instead of the "CHAR(10)+CHAR(13)"...

The CHAR(10)+CHAR(13) does add a linefeed+return to the string, so it looks like you used a SELECT to return the results (like Koen mentioned in the previous post).

Btw: the following...

The code in my post does NOT check if an email address is present in the string. If you have values without an @-sign, the code will fail. You can...

You have an error in the dynamic SQL part. The statement inside the VALUES part doesn't work with the comma before the FROM and you need to move the @name...

You need to use the CHARINDEX function to determine the start position (semi column or space) and end-position of the e-mail part inside the string.

if object_id('tempdb..#test') is not null

drop table...

DBCC CHECKDB creates a database snapshot by its own. In your case this is failing.

Are you able to create a snapshot yourself? If so, you can run the DBCC CHECKDB...

I would suggest to script out all users (and logins) with their permissions. You can find many script to do that on the internet and on this forum (http://www.sqlservercentral.com/search/?q=permissions&t=s&sort=relevance). Use...

Basicly: Allow the LOG file to grow and keep enough free space on disk.

Try to figure out why the LOG has been growing this big and see if it can...

At first glance I think you've added an extra line that doesn't belong there:

IF DB_ID('Northwind') IS NULL

BEGIN

RESTORE DATABASE [Northwind]

FILE = N'Northwind_Data' -- this line needs to be removed

FROM

DISK =...

When you specify the schame name in the CREATE command, the table will be created in the mentioned schema

CREATE TABLE [DB_SQL].[table_new] (column datatype, ....)