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]
Recently, we had a scenario, where we need a simple SQL Role which gets read access to bunch of views. While it was easy to create the vie...
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. ...