Guest User

Untitled

a guest
Sep 17th, 2013
227
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. 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
  2. FROM MASTER.dbo.sysprocesses
  3. WHERE program_name = N'SQLAgent - Generic Refresher')
  4. BEGIN
  5. IF EXISTS (select 1 where convert(varchar(30), convert(sql_variant, SERVERPROPERTY('edition')))
  6. not like 'Express%')
  7. BEGIN
  8. SELECT @@SERVERNAME [INSTANCE], null [DB_NAME], 'SQLAgent not running on ' + @@SERVERNAME [CHANGE_INFO], GETDATE() [CHANGE_DATE]
  9. END
  10. ELSE
  11. SELECT 'dird' [INSTANCE],'dird' [DB_NAME],'dird' [CHANGE_INFO], getdate() [CHANGE_DATE]
  12. END
  13. ELSE
  14. 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