Select = min(id), = max(id) from #Databases Select identity(int,1,1) as, sd.name as into #Databases from sd where sd.name not in ('master', 'tempdb', 'model', 'msdb') We have not had a problem with intellisense since. Once a week to perform this optimization. This seemed to clean up what ever was blocking intellisense. Work until I ran an optimize routine that included running DBCC DBReindex, sp_updateStats, and sp_Recompile. We tried everything and nothing seemed to We were having problems also with intellisense, as it completely stopped working on a SQL Server 2012 instance that was hosting over 100 client databases in a non-transactional development only environment.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |