Error 15336
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you column cannot be renamed because the object participates in enforced dependencies might have Meta Discuss the workings and policies of this sp_rename column cannot be renamed because the object participates in enforced dependencies site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers sql schema binding or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community
Tsqlt Cannot Be Renamed Because The Object Participates In Enforced Dependencies
of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up sql 2005 force table rename that has dependencies up vote 11 down vote favorite 3 How do you force a rename??? Rename failed for Table 'dbo.x. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+%28%28Katmai%5FPCU%5FMain%29.090329-1045+%29&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Rename+Table&LinkId=20476 An exception occurred while how to rename table in sql server executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Object '[dbo].[x]' cannot be renamed because the object participates in enforced dependencies. (Microsoft SQL Server, Error: 15336) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=15336&LinkId=20476 sql sql-server tsql share|improve this question edited Oct 8 '09 at 23:42 OMG Ponies 198k36356415 asked Oct 8 '09 at 23:00 Scott Kramer 82621633 add a comment| 4 Answers 4 active oldest votes up vote 24 down vote accepted Find the "enforced dependencies", then remove or disable them. By "enforced dependencies", it means Schema binding, so you'll have to look specifically for that. Here's a query to look for schema binding references to your object: select o.name as ObjName, r.name as ReferencedObj from sys.sql_dependencies d join sys.objects o on o.object_id=d.object_id join sys.objects r on r.object_id=d.referenced_major_id where d.class=1 AND r.name = @YourObjectName As I noted in the comments, there is no way to FORCE-ibly override Schema Binding. When you use Schema Binding, you are explicitly saying "Do not let me or anyo
installation of incompatible software, driver or devices, attack of virus, trojan or malware etc. However, there may be also various reasons that may raise this error on your pc, but above mention causes are most common that origins 15336 error. Symptoms: You may alter table add column sql server get infinite force reboot, BSOD error, system not responding, windows hangs, unable to install or uninstall software or driver, unable to update windows etc. You may also get slow system performance and taking long time to boot your PC. Solution: Most useful way to fix error code 15336 is restoring your PC at earlier stage when it was working good. Restoring your PC will not cause data loss and it makes your window stable and error free. If it doesn't work then you may http://stackoverflow.com/questions/1540988/sql-2005-force-table-rename-that-has-dependencies also use third party removal tool to fix this problem easily. It can easily clean 15336 windows error and also repair damages caused by error. Download Windows Error 15336 Repair Tool Compatible:Windows 98, 2000, ME, XP, Vista, 7, 8 (32/64) File Size: 4.9MB (IMPORTANT) Instruction to Fix Windows Errror 15336 Step 1. Click here to download windows repair tool 15336 Step 2.Install in your pc and Open the Tool to run Step 3.Scan and Click on "Fix All" button Windows Repair Tool Features http://www.fixwinpcerror.com/15336.php PC Health Advisor repair tool is fully designed to scan and fix all complex problem in your computer and it will quickly solve all the issue of system. It can recover and repair all damaged files, speedup pc performaces and also keep secure from virus of your system. User Comments By Carol Mitchell, Canada 08:15:00 AM I was very irritated with stop error codes. While working on PC suddenly flash this error and my PC boot again. I was totally helpless and suddenly while googling I got this tool. It is very amazing and helpful tool that I recommend to every user. By Sarah Smith, California 05:45:00 PM I would like to send my Thanks and best wishes to development team of this tool. It is one of the best PC optimizer tool that not only fix bsod or stop error but also increase PC speed. By James Martin 12:15:00 PM Suddenly 15336 error code occur on my laptop and creating several problem, i was very frusted by this but thanks to PC Health Advisor to fix all windows error and now it has been solved. Thanks to PC Health Advisor!!! Download Software System Requirements Internet Connection 20MB Free Hard Disk Space 1024MB of Ram Login as Administrator Repair Tool Screenshort SiteMap Home Free Download Buy Now Privacy Policy Affiliate Disclosure Terms & Conditions Contact Us Category stoperror1 | stoperror2 | stoperror3 | stoperror4 | stoperror5 | errorcode1-2000 | errorcode2001-4000 | errorcod