Just to be explicit- we will be getting a backup copy every now and again so want this to be done on DB Level. Totally understand we can do in...

Hi John,

Thanks for your reply. Will look for the script but regard you advice "Better still, restore on a server that has the same collation!"

It's a DB which is restored...

Hi,

Found the solution.

Because SQL Server Management Studio properties changed to run as 'Administrator' it does not like that. Unticked the option and its working fine.

Thanks

Thanks for your reply. I would be greatful if you can get me something where it give me the name of store procedure as well. When I am running this...

Hi Abdul,

I do use the below which I have done when asked to check for active user on a specific Db.

you might have to tweak a bit.

USE [DataBaseName]

select ...

Hi

Could be various reasons; mostly hardware failure or deleted ldf's.

Good advice here

Thanks

Imran

Hi Shilpa

Start with this one to understand SSSIS

http://msdn.microsoft.com/en-us/library/cc917721.aspx

This is a simple example how to configure SSIS

http://www.sql-server-performance.com/2007/package-configuration-2005/

Thanks

Imran

Hi Gail

I know its written by you and that 's why I was looking for clarification.

You are advising here;

1. The BACKUP LOG WITH TRUNCATE_ONLY will break the log chain...

GilaMonster (7/25/2011)

Imran Nadeem (7/25/2011)

Don't do that. Very, very, very bad log mismanagement. That's going to cause the log to grow again, it's going to cause log fragmentation (unless by some...

Hi

Here is what I use to reduce my logs but as Gale advised it would be good to find out why those are getting filled.

USE DatabaseName

DBCC SHRINKFILE('Database_log', 1)

BACKUP LOG...

Hi

Here is something which I do use ; It might not perfect for you but at least it will give you a starting point. In my case all user...

I am doing this using the SSIS package and setup job which drops the existing tables and recreate overnight.Might be that's the option

Thanks

Thanks Craig,

That's where I was looking already but it does not give me the full details.

I am going to watch tonight if its getting enabled itself on schedule time as...

Looks to me that the particular user is opened some long running Transactions and now whatever he is doing is not working for him because the open transection is blocking...

Agree with Lowell.

The following steps required to create an indexed view are critical to the successful implementation of the view:

Verify the setting of ANSI_NULLS is correct for all existing...