SQL Error - String or binary data would be truncated
What is SQL Error - String or binary data would be truncated?
Login failed for user 'NT AUTHORITY\LOCAL SERVICE' - SQL Server 2008 Error
Today I was debugging some issue in some application. I looked in event log on my machine and saw that log was full of Sql Server Errors as shown below.
Login failed for user 'NT AUTHORITY\LOCAL SER...
The database principal owns a database role and cannot be dropped
This morning I was migrating Microsoft SQL databases from an old server to a new server. After migrating the database, I needed to delete an existing login user from the database and add a new one. Wh...
How to find empty tables in database
I was working on deployment of a new application. Part of the deployment plan was to clean certain tables and bootstrap some configuration tables. I had some SQL scripts to accomplish these tasks. But...