Throw the results into a parameter table, then loop through the table and send the email to each recipient - this is a very rough example but should get you...

Try DBCC CHECKTABLE on the table that has the clustered index. No point in checking the entire DB when it's just the one table reporting the issue?

Remember Grant is the "Product Evangelist for Red Gate Software" 🙂 :-D...

You got me, seems rather odd the issue you are experiencing with the network share....are you using a fully qualified domain name? Or mapping to am admin share?

1. Are any of your databases offline?

2. What happens when you press Ctrl-J?

3. What compatibility level is the database? If it's an earlier version of SQL Server, intellisense may...

Agreed, scalar function isn't the best application but the main thing I wanted to provide the OP, was some example code to use. Using Jeff's DelimitedSplit8K is a much...

+1 @Sean, I keep the important stuff in my brain but all the little odds-n-ends are cleaned out daily - that's why I have Google!!! 😀

Have you tried "Edit" > "Intellisense" > "Refresh local Cache"

?

Just a shot in the dark here but try setting "Retain Same Connection" to True in your Connection Managers

You could create a simple scalar function and call that as needed (or take the code from this to use as well) CREATE FUNCTION [dbo].[fx_SetStringPadding] (

@OriginalString varchar(100),

@PadToLen int,

@PadChar char(1) =...

Since you have many tables, I would recommend doing this via simple TSQL - the article below outlines the process quite well. If you have any further questions...

Can you attach an example of the data in a flat file to this thread?

NO problem, glad it helped!

Create a temp table and insert the results from proc1 into it, do the same for proc2

select from temp table 1 use EXCEPT on the select from temp table...

@Lempster and @brandon - quite right, my ID10T error. I am fully aware of the flag in the publication options to replicate schema changes, however as a quick test...