Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- The OLE DB provider "SQLNCLI10" for linked server "SRV01" supplied inconsistent metadata for a column. The column "INSTANCE" (compile-time ordinal 1) of object "IF NOT EXISTS (SELECT 1
- FROM MASTER.dbo.sysprocesses
- WHERE program_name = N'SQLAgent - Generic Refresher')
- BEGIN
- IF EXISTS (select 1 where convert(varchar(30), convert(sql_variant, SERVERPROPERTY('edition')))
- not like 'Express%')
- BEGIN
- SELECT @@SERVERNAME [INSTANCE], null [DB_NAME], 'SQLAgent not running on ' + @@SERVERNAME [CHANGE_INFO], GETDATE() [CHANGE_DATE]
- END
- ELSE
- SELECT 'dird' [INSTANCE],'dird' [DB_NAME],'dird' [CHANGE_INFO], getdate() [CHANGE_DATE]
- END
- ELSE
- SELECT 'dird' [INSTANCE],'dird' [DB_NAME],'dird' [CHANGE_INFO], getdate() [CHANGE_DATE]" was reported to have a "DBTYPE" of 130 at compile time and 129 at run time.
Advertisement
Add Comment
Please, Sign In to add comment