When the defauld DB of the user is deleted. We could not able to login to DB.
Cannot open user default database. Login failed.
Login failed for user 'xyz'. (Microsoft SQL Server, Error: 4064)
Change the default DB.
ALTER LOGIN [FAREAST\v-prcher]
I need to check in a table, is the all day data available, here is the handy script to check the same.. DECLARE @startdate DATETIME ...
What is view state and use of it? The current property settings of an ASP.NET page and those of any ASP.NET server controls contained with...
In SQL Server Integration services, we have Script Component, which can be used in Data Flow Task as Source, Destination or Transformation. ...