Brian Donahue wrote:I guess SQL Server just had a lock on the information schema. Sounds like a possibility from what you've said...
I have a similar issue. When I run SQL Profiler at the same time I see the following command repeating over and over:
SELECT revisions.value AS Revision, scripts.value AS ScriptsLocation, migrations.value AS MigrationScriptsLocation
FROM [cmbs].sys.extended_properties AS revisions
JOIN [cmbs].sys.extended_properties AS migrations
ON migrations.minor_id = revisions.major_id
JOIN [cmbs].sys.extended_properties AS scripts
ON revisions.minor_id = scripts.minor_id
WHERE revisions.name = 'SQLSourceControl Database Revision'
AND migrations.name = 'SQLSourceControl Migration Scripts Location'
AND scripts.name = 'SQLSourceControl Scripts Location';
We have a fair amount of databases of various sizes over the years and they've all run great. A possible difference is that this database is larger then the others and I recently upgraded to SQL Compare 10.
Any ideas why that command would repeat over and over?