yup I did not even see the subquery. my eyes when straight to the where clause.

Sorry about that.

Without seeing any sample data it would be pretty hard to tell why the first query is not returning any results. I could only offer that you might want to...

Becuase you are updating extended properties I beleive you would have to run this as a user with Admin rights to each database you plan to update.

I do not beleive there are any tools for that but I am also not sure how that would be useful information. If you removed all data from a...

I mocked up the tables and data and have provided a solution but I would warn that this may not be that simple unless the data is really that simple....

Here is a link to a fourm thread with some information on this that may be helpful.

http://www.sqlservercentral.com/Forums/Topic351864-5-1.aspx

I guess I am confused by the question so I wanted to rephrase. you want to know how big the database would be if it had no data in...

If you can provide some sample data and table structure that would help us help you.

I can relate with you comments Steve. I have been to new orleans twice when I worked for another company and both times I could not wait to leave....

The short answer is you can do that rather simply. Install SQL on the other server to the exact same level as the server you wish to migrate. ...

The problem is simple! Society as it stands today no longer understands or appreaciates the effort that goes into technology. Most ppl using technology will never understand how or...

with out seeing some sample data it would be hard to provide much of an answer but I would group the data by your primary key or possibly multiple fields...

Here is a link with more information but the long an short is no you can not install a 64 bit package on a 32 bit OS

http://connect.microsoft.com/SQLServer/feedback/details/241535/setup-exe-is-valid-but-is-for-a-machine-type-other-than-the-current-machine

Here is my take on it. basically I would use Row_Number() function to create an event_ID for the BOOK/RELS events and then create the same for the RELS event....

I can't imagine that being a straight forward question. I would estimate that the majority of installs are ready to run with no additional configuration out of the box....