sp_refreshsqlmodule [ @name = ] N'name' [ , [ @namespace = ] { OBJECT | DATABASE_DDL_TRIGGER | SERVER_DDL_TRIGGER } ] [ ; ] 参数 [ @name = ] N'name' 存储过程、用户定义函数、视图、DML 触发器、数据库级 DDL 触发器或服务器级 DDL 触发器的名称。 @name 是nvarchar(776),没有...
Database项目中关于Procedure sp_refreshsqlmodule_internal的错误 最近项目中发现一怪问题,使用DB项目发布数据库时,总提示 “(110,1): SQL72014: .Net SqlClient Data Provider: Msg 1222, Level 16, State 56, Procedure sp_refreshsqlmodule_internal, Line 67 Lock request time out period exceeded. An erro...
Sp_refreshsqlmodule changes object definitionVerkhedkar, Sameer
当前标签:sp_refreshsqlmodule_internal > 日一二三四五六 282930123 458910 11121314151617 18192021222324 25262728293031 1234567
관련 콘텐츠 저장 프로시저 데이터베이스 엔진(Transact-SQL) 시스템 저장 프로시저(Transact-SQL) sys.sql_expression_dependencies(Transact-SQL) sp_refreshsqlmodule(Transact-SQL)피드백 이 페이지가 도움이 되었나요? ...
メタデータを更新するには、sp_refreshsqlmoduleまたはsp_refreshviewを使います。 現在のデータベース内のオブジェクトまたはデータ型の名前のみを変更できます。 ほとんどのシステム データ型とシステム オブジェクトの名前は変更できません。
System stored procedures (Transact-SQL) sys.sql_expression_dependencies (Transact-SQL) sp_refreshsqlmodule (Transact-SQL) Feedback Was this page helpful? YesNo Provide product feedback|Get help at Microsoft Q&A Additional resources Events Join AI Skills Fest Challenge ...
See Also Reference Database Engine Stored Procedures (Transact-SQL) System Stored Procedures (Transact-SQL) sys.sql_expression_dependencies (Transact-SQL) sp_refreshsqlmodule (Transact-SQL)
Refresh the metadata using sp_refreshsqlmodule or sp_refreshview. You can change the name of an object or data type in the current database only. The names of most system data types and system objects can't be changed. If you use more than 128 characters for the new name, only the ...
example, if you rename a table column and that column is referenced by a non-schema-bound view or function that SELECTs all columns (using the*), the metadata for the view or function continues to reflect the original column name. Refresh the metadata usingsp_refreshsqlmoduleorsp_refresh...