SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SQL Script to compare Database
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

zero1de
Yak Posting Veteran

Germany
66 Posts

Posted - 11/10/2012 :  15:15:32  Show Profile  Reply with Quote
Hi,
the script runs great on some database but on one database, it causes problems? I have installed Service Pack 2 on SQL 2008 R2 and i get still this message with erroid:8623 !! Have you any idear whats going wrong here ??

THX for your help

Message Windows for the DB-Compare Script.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(9167 row(s) affected)

(11200 row(s) affected)

(11200 row(s) affected)

(302 row(s) affected)
Msg 8623, Level 16, State 1, Line 1
The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000