Geeks With Blogs
Mayank Sharma SQL Server
User Already Exists in the Current Database - SQL Server
I was moving a lot of databases from one SQL Server to another, and my applications were giving me errors saying "Login failed for <user>". The user was already in the database with appropriate rights to allowed objects in the database. I tried mapping the user to the database and that's when I got this message: "User Already Exists in the Current Database"... I googled and found this very useful post about orphaned users when moving databases. These are the steps you should take to fix this ......

Posted On Wednesday, April 21, 2010 7:59 AM

SQL Server: DateTime and Indexes

A nice post about handling DateTime fields and indexing.

http://itknowledgeexchange.techtarget.com/sql-server/dates-can-easily-be-the-hardest-datatype-to-work-with/

Posted On Tuesday, September 22, 2009 12:52 PM

SQL Azure Database Preview released
Microsoft has released a trial version of SQL Azure DB. Get more details here

Posted On Wednesday, August 19, 2009 3:54 PM

SQL Server: Disaster Recovery...some tips

Again a nice arctile by Don Jones, where he talks about different SQL Server backup options and disaster recovery plans...a good read.

SQL Server Disaster Recovery by Don Jones

Posted On Friday, August 14, 2009 10:35 AM

SQL Server: Optimizing Indexes

A good article about types of SQL Server Indexes and how to optimize them when they go bad...

Optimizing SQL Server Indexes by Don Jones

Posted On Friday, August 14, 2009 10:26 AM

Copyright © bullpit | Powered by: GeeksWithBlogs.net