Hi mike.johnson, I suggest you create a view for your query with whatever WHERE clause is required then execute the stored procedure calling the view. Thanks

Hi Sector7, yes, I've made a few assumptions about configuration and access rights with this and haven't coded for every possible error.

Hi

Just submitted an updated version of the script to address to identity issue.

Thanks

Thanks Hugo, feeling much better after reading your post. Thought I had Monday morning madness.

Thought the typo was actually a trick so selected error for both. Turns out it's just a typo! 🙁

Hi, just wondering why you would do this and not just use the model database? Thanks

Good point! Generally I've been dumping out views of data where identity values hadn't been included so didn't spot this issue.

Thanks for the feedback

Paul

Hi

Nice framework, we use something similar to load are data warehouses each night, but create the parallel processes dynamically as SQL agent jobs. Gives you a bit more visibility on...

Thanks Scott, I was a little confused by the SQL injection comment from Eric in relation to this script. Espically when something like an ASP.Net web app gives you all...

Hi Eric

You could use the system procedure sp_MSforeachdb to create a none dynamic version, but you'll still need to pass it a SQL string and check for the users existence...

Nice, didn't realise there was such a system procedure to do that! Many thanks

In one of our data warehouses we deploy similar database schemes to handle customer data sets. From time to time it's useful to know which databases contain the same objects,...