rambilla4 (10/10/2009)

I have took a backup in the morning 9:00 AM to a perform a task and then the regular backup job at night (ran at 9:00 PM) appended the...

Thanks bitbucket 🙂

This contains a script for finding Roles per user in each database... That is what i was looking for.

Beware of the consequences too!!

using NOLOCK, you'll read inconsistent data at times. If...

http://msmvps.com/blogs/omar/archive/2006/09/15/How-to-setup-SQL-Server-2005-Transaction-Log-Ship-on-large-database-that-really-works.aspx

This site has good tutorial on how to setup log shipping in...

mchinnaian (10/9/2009)

Anyone Can Help me.. What is the Difference between Incremental Backup and Full Backup in SQL Server 2005. What are all the Steps to...

The recommendation from microsoft is that you should rebuild your indexes if they are fragmented more than 30%.

Look at example D from this url. That script...

Can you rebuild your indexes and see if the performance improves.

I was just trying to install an instance. The screen after you select "components to install" should be the screen asking you for the instance name...

I think thats where the problem lies. It's trying to upgrade the default instance (which u might have patched to higher builds)... It should throw you a screen asking you...

The error says, you are trying to upgrade to an older version!

Are you typing a unique instance name or you're keeping the default instance?

The other way to do this is to use isnull function.

select isnull(col1,'') + isnull(col2,'') + isnull(col3,'')+ isnull(col4,'')+ isnull(col5,'')+ isnull(col6,'')

from MyTable

that may happen if there are inserts/deletes going on in the primary database. Until the log is backed up next, copied and restored on the secondary, there will be difference...

If you do not need point in time recovery (that's the reason u must have put the db in full recovery mode), why dont keep it in simple recovery mode?

09.00.3330

http://support.microsoft.com/kb/937137/

use RaiseError or xp_logevent sp.

refer : http://tejasnshah.wordpress.com/2009/04/02/sql-sever-how-to-make-an-entry-in-event-viewer-using-sql-server/

http://www.codeproject.com/KB/database/Raiserror.aspx