Just make sure it does. You could put some logic at the...

To find out where the breaks are, you just LEFT JOIN your tally table to your table of IDs, and find the values in your tally table corresponding to NULLs...

Place it wherever is most apposite. I think I would use the master database. If it's not there then your procedure's going to fail, unless you define it...

OK, this is getting outside my area of knowledge. However, I'd say that if one part of your application is connecting to SQL Server, and another part is failing...

Well, how are you going to know if you...

If you look in the SQL Server error log, assuming that it is configured to log failed logins, you will find information that will enable you to deduce the reason...

OK, so your Treepath column contains a delimited list that you need to split into its individual components? You need a function to do that for you. If...

I think I answered the first problem in the 18th message in this thread.

As for calculating the size of the result set, build a table of all the possible data...

Problem? I inferred from your previous post that it was resolved. Please let us know what the outstanding issues are.

John

I'm glad you've made some progress. Your SET @par2 and SET @filter statements will fail if the respective temp tables contain more than one row, however.

John

This is where dynamic SQL starts to get ugly and is one of the reasons why you should try to avoid it. I think you would have to loop...

There's a stored procedure sp_delete_backuphistory that you can use to purge old backup records from the msdb database.

John

Resender (12/10/2010)

---

OK so the function I found (DelimitedSplit8K)

returns me the delimited varchar as a table where each record is the next value

turns into

ID ColumnName

1 MachineId

2 RegisterId

3 UtcTime

4 Value

I...

Resender (12/9/2010)

---

Problem with this is that I need to have MachineRegistration.INFORMATION_SCHEMA.COLUMNS

I could off course put that in a variable and execute the variable.

Then the problem would be to then calculate...

Wrong way round. You can restore a SQL Server 2000 database to SQL Server 2005, but as far as I know, you can't restore a SQL Server 2005 database...