Here are some sql server tips and tricks. To get all the Tables Information in SQL Server SELECT * from SYS.Tables To get all the views...
Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
Wednesday, November 30, 2011
Wednesday, October 26, 2011
While I am trying to use sql server authentication mode, i got the following error Unable to use SQL Server because ASP.NET version 2.0 ...
I got this error Cannot drop database "ASPState" because it is currently in use. while trying to uninstall ASPState database by us...
Monday, February 7, 2011
The below sql error usually comes while taking SQL Server backup. Error message is: System.Data.SqlClient.SqlError; The backup set holds a...
Tuesday, January 25, 2011
Select 'Delete from '+name from sysobjects where xtype='u'
Hello, my name is Bijay. I'm a SharePoint MVP. 