ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE DatabaseName SET MULTI_USER
GO
Advertisements
code siblings,adventures,songs and excerpts of my daily work
My adventures in coding from last 10 years
code siblings,adventures,songs and excerpts of my daily work- jquery select2 length keeps increasing December 7, 2016width:198px !important; Fixing the Width of a Select 2 with a Long Value in a Bootstrap Form Group or Input GroupFiled under: JQuery Tagged: Jquery notesambatisreedhar
- Remove “Restricted User” in SQL Server 2008 October 10, 2016ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO ALTER DATABASE DatabaseName SET MULTI_USER GOFiled under: Sqlserver notes Tagged: SqlServerambatisreedhar
- Dotnet Bangalore training Institute : pragimtech June 15, 2016http://www.pragimtech.com/Home.aspx https://www.youtube.com/user/kudvenkat/playlists http://csharp-video-tutorials.blogspot.in/Filed under: Dotnet Interview Questions, Dotnet notes Tagged: Dotnet Interview Questionsambatisreedhar
- entity framework view not refreshing November 23, 2015https://christianarg.wordpress.com/2013/06/13/entityframework-refreshall-loaded-entities-from-database/ AsNoTracking http://stackoverflow.com/questions/22177491/how-to-force-entity-framework-to-always-get-updated-data-from-the-databaseFiled under: Uncategorized Tagged: Entity Frameworkambatisreedhar
- Sharepoint notes : Sharepoint 2013 in maintenance mode November 16, 2015http://blog.portiva.nl/2014/06/25/sharepoint-2013-site-stuck-in-read-only-mode/ https://nasironline.wordpress.com/tag/we-apologize-for-any-inconvenience-but-weve-made-the-site-read-only-while-were-making-some-improvements/ Issue : “We apologize for any inconvenience, but we’ve made the site read only while we’re making some improvements.” So I woke up this m […]ambatisreedhar
- Sharepoint notes : Invalid characters in filenames October 30, 2015As per share point, the below are invalid character in a file name which we are already handing from UI. ” # % & * : ? \ / { | } ~ the below things about share point file names which we have to implement across all the processes. • Do not use: ” […]ambatisreedhar
- Sqlserver notes : Issue – The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(2 rows). October 19, 2015http://allenbuckley.com/blog/the-row-values-updated-or-deleted-either-do-not-make-the-row-unique-or-they-alter-multiple-rows/ SET ROWCOUNT 1 DELETE FROM Table1 WHERE col1 = ‘0001’Filed under: Sqlserver notes Tagged: Sqlserver notesambatisreedhar
- Sqlserver notes October 16, 2015Before deleting data from production server follow these steps. Its a good practice select * from WriteOff_ReworkUsers where Ref_ID in (189538,201177,201185,203533,203534,203563,203567) begin tran delete from WriteOff_ReworkUsers where Ref_ID in (189538,201177,201185,203533,203534,203563,203567) rollback tran begin tran delete from WriteOff_ReworkUsers where […]ambatisreedhar
- Entity framework stored procedure always returning int October 5, 2015http://www.devtoolshed.com/using-stored-procedures-entity-framework-scalar-return-values http://stackoverflow.com/questions/18245567/stored-procedure-returns-int-instead-of-result-set I have a stored procedure that contains dynamic select. Something like this: ALTER PROCEDURE [dbo].[usp_GetTestRecords] –@p1 int = 0, –@p2 int = 0 @groupId nvarchar(10) = 0 AS […]ambatisreedhar
- Sqlserver notes: Minus operator in Oracle – Sqlserver Except or Not Exists September 30, 2015http://www.sqlservercurry.com/2011/01/minus-keyword-in-sql-server.html MINUS operator (in oracle) is used to subtract the rows which are available in the second result, from the first result set. SQL Server does not have a built-in MINUS keyword, but in SQL Server, it’s equivalent is the EXCEPT operator or using NOT EXISTS Here’s an example. Consider the fol […]ambatisreedhar
- jquery select2 length keeps increasing December 7, 2016
Recent Comments
- RSS
- jquery select2 length keeps increasing
- Remove “Restricted User” in SQL Server 2008
- Dotnet Bangalore training Institute : pragimtech
- entity framework view not refreshing
- Sharepoint notes : Sharepoint 2013 in maintenance mode
- Sharepoint notes : Invalid characters in filenames
- Sqlserver notes : Issue – The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(2 rows).
- Sqlserver notes
- Entity framework stored procedure always returning int
- Sqlserver notes: Minus operator in Oracle – Sqlserver Except or Not Exists
