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- Speeding Up Visual Studio by Disabling the Startup Page May 28, 2018to Tools -> Options then select the Environment node and then select the Startup child node. You can set it up to “Show empty environment”. Advertisementsambatisreedhar
- 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 Groupambatisreedhar
- 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 GOambatisreedhar
- 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/ambatisreedhar
- 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-databaseambatisreedhar
- 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’ambatisreedhar
- 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
- Speeding Up Visual Studio by Disabling the Startup Page May 28, 2018
Recent Comments
- RSS
- Speeding Up Visual Studio by Disabling the Startup Page
- 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
Advertisements
