SQL Error - String or binary data would be truncated

What is SQL Error - String or binary data would be truncated?

Read more

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...

Read more

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...

Read more

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...

Read more

Search

Social

Weather

Monthly Posts