You can start by backing up the TLOG to a network location and then shrinking the log files, which will start to free up some space.

If you add additional storage,...

This is because the servername(or network name) must have changed in the past. the serverproperty('servername') will reflect the new name. however @@servername will reflect the old name.

To fix this issue,...

The Max LogSize allowed in 2TB. it is pretty big a size for a log file and i will be surprised if you are reaching that limit!

You can specify multiple...

Books On Line will be helpful.

you can read about some of these views for a start:

sys.server_principals

sys.server_permissions

sys.database_principals

sys.database_role_members

sys.database_permissions

Users will generally be placed in the databases they would need access to. they will be mapped to Logins which reside in the master database. if the Login does not...

You can use a profiler or one of the Set Statistics [time / IO]...

would this help?

declare @tblattendance table ([Week Number] tinyint identity(0,1), num_att_on_day int, [Site ID] smallint)

insert into @tblattendance

select count(*) as num_att_on_day, [site id]

from tblattendance

where [Attendance date], > DATEADD(wk, DATEDIFF(wk,...

Why are you trying to pause the inactive node. from my understanding, the installation will need both nodes and will apply the SP on both of them. The first error...

One way I generally achieve this is by setting the default database for those users to a database that they dont have access to. for e.g. Database2(they DONOT have access...

try using CTE.

you can also use cursor(smartly) or a while loop for all the duplicate appointmentids..

Yes the rebuild will increase the transaction log. however, if you carefully do the index maintenence, the increase can be controlled. there is no need to do index maintenence on...

This is correct.

2. If so, does the inactive VLFs...

Shriji (8/17/2010)

---

Thanks for the replies guys.

While waiting on the reply, I created this small script and it proves what I assumed. The results are different:

create table #a (x int, y...

You should check page splits through perfmon. if there are a lot of page splits occuring, then you need to look and adjust the fill factor. Also look at the...

you need to make the database trustworth.

Try this:

alter database [DBNAME] set trustworthy on