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]
In SQL Server Management Studio (SSMS) you can generate script out the DB Object, you can also generate script for data (Insert statements...
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. ...