Getting this error off qry1:

TITLE: Microsoft SQL Server Management Studio Express

------------------------------

Error loading execution plan XML file C:\ssc\qry1.sqlplan. (Microsoft.SqlServer.Express.SQLEditors)

------------------------------

ADDITIONAL INFORMATION:

There is an error in XML document (1009, 15). (System.Xml)

------------------------------

Data at the...

You can post it here, or if it's very large, there's an 'edit attachments' button at the bottom of all posts. You can copy/paste your script to MSWord, notepad,...

Ah! So, to clarify, you're looking for a script or some other way to change all your objects from dbo.object to rescon.object?

Such as dbo.TableA to Rescon.TableA?

And you want to do...

I'm afraid to help you puzzle out your solution, I'm going to need more from you. DDL's of all the base tables, sample data, and expected results from the...

Ahhh. That's needed to...

There's your 15 gig bump, needed snapshot room.

Cross posted, please direct all replies and discussion here: http://www.sqlservercentral.com/Forums/Topic989922-360-1.aspx

You'll want to try it without the NOEXPAND then, or we'll need to look at optimizing it. Either way, to get the correct values, you're subquerying and then reconnecting...

IF it's taking largish snapshots to deal with multiple enforced relationships... yeah, I could see it, especially if you're meticulous about FK relationships.

As to affecting the log, hm... That...

I'm curious, but what's wrong with adding additional filters after the view's built? This is a short form of your code, but it's to help me understand what you're...

What's your free space like at the moment? 🙂 It may have just needed...

Take two: Please actually read the link. You're going to want to give us a CREATE TABLE, INSERT INTO SELECT ... UNION SELECT... structure. Well, unless someone gets...

Ayie,

I'll save you some trouble before the optimization experts swing through and they can look at your code immediately, you'll want to follow the directions in this link:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

What you've got...

Balaji, can you post the actual error you're getting? I think I followed your predicament but it would help to see the actual error.

Hey Threadizens...

Can someone do a flyby on this post and make sure I haven't missed something that ends up with me blowing smoke and sunshine, and sending this soul off...