Here are a few things I'd consider:

* Can you ping the target server from the computer the package is running on? If not, the server may be down or...

Think of it as rearranging the books on your shelf so that they're in alphabetical order. Because each book is now in a different place, that counts as a...

I'm sorry, but I still don't understand. Please will you post table DDL in the form of CREATE TABLE statements, sample data in the form of INSERT statements and...

I don't know enough about SSRS to know whether that's possible. But if it isn't, you could try using SSIS instead.

John

Just make the column a computed column as PK + 199? I suspect that your requirement is a little more complicated than that, but it's difficult if you keep...

ronan.healy (5/22/2014)

---

thanks for that. will try that.

just 1 thing would that still work if say i had 10 different pieces of data in the second table that i wanted to...

You can set up a subscription that will e-mail the report as an Excel spreadsheet.

John

The only problem I've ever seen with that is if your job has a schedule. Your script will have a section something like this:

EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'Daily...

Something like this should work - a simple stored procedure with an @ErrorCount parameter. If @ErrorCount is 0, do nothing, otherwise raise an error that will cause the task...

You may be having intermittent network problems. Try setting up a continuous ping test and compare times of any dropped packets to the times you get the timeout errors.

John

Mark

I think your first problem is mathematical rather than programmatical. 400 values means 2^400 combinations, which is a much larger number than SQL Server can (as far as I...

Mark

Here's a couple of ways to limit the amount of processing you need to do:

(1) Work out the maximum rows you need to consider.

If you put all the rows in...

Try building the string you're going to execute as a variable and then PRINTing that variable instead of executing it. That'll make it much easier to see what the...

Nancy

Shrinking is fine as a one-off, so long as that table won't grow to 87GB again. If you think it will, leave the database as it is and ask...

I'm arriving in Telford at 8pm on the Wednesday, but leaving immediately after Thursday's proceedings have finished. Happy to share a couple of ales on my arrival if you're...