InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 10:39:41 GMT20http://www.sqlservercentral.com/Forums/Topic1090417-2698-1.aspxSorry, I wasn't clear in my previous post. When you created your post at [url=http://www.sqlservercentral.com/Contributions/New/Script]http://www.sqlservercentral.com/Contributions/New/Script[/url], I believe you ticked the box to "Include code for SQL Scripts Manager", and then you pasted your T-SQL script into the box that's supposed to contain the XML-wrapped script that runs within the SQL Scripts Manager tool; whereas you needed to paste your code into the box entitled "Insert your SQL code here".So your script is now showing up at [url=http://www.sqlservercentral.com/Scripts/rgtool/]http://www.sqlservercentral.com/Scripts/rgtool/[/url], which is a list of scripts that have been wrapped up in the XML format that allows them to run within SQL Scripts Manager.Are you able to edit your contribution, to remove the SQL Scripts Manager content?Best regards,Colin.Mon, 18 Apr 2011 16:44:13 GMTColin Millerchiphttp://www.sqlservercentral.com/Forums/Topic1090417-2698-1.aspxSorry, couldn't get the hyperlink. Could you please suggest where you can see the interlink?Mon, 18 Apr 2011 14:09:19 GMTSQL-DBA-01http://www.sqlservercentral.com/Forums/Topic1090417-2698-1.aspxHi Sourav,You've marked this as being compatible with SQL Scripts Manager ([url=http://www.red-gate.com/products/dba/sql-scripts-manager/]http://www.red-gate.com/products/dba/sql-scripts-manager/[/url]), but I don't think it is. Are you able to edit it to correct this?Thanks,Colin.Mon, 18 Apr 2011 10:45:57 GMTColin Millerchiphttp://www.sqlservercentral.com/Forums/Topic1090417-2698-1.aspxIf your application or access to the database doesn't use dbo or sa authority you can just use: ALTER DATABASE [i]db_name[/i] SET RESTRICTED_USER With ROLLBACK IMMEDIATEThis will drop all user connections and rollback any non-committed transactions. When RESTRICTED_USER is specified, only members of the db_owner, dbcreator, or sysadmin roles can use the database.We use this to restrict access to a system so we can backup Production databases prior to a deployment.:-)Fri, 08 Apr 2011 07:10:37 GMTSQL@DOShttp://www.sqlservercentral.com/Forums/Topic1090417-2698-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/kill/72838/">Killing User Connection(session) connected to the Database.</A>[/B]Fri, 08 Apr 2011 00:17:35 GMTSQL-DBA-01