TJ-356724 (10/3/2012)

---

Problem one: Databases in shutdown mode

We are migrating from our current production environment from sql 2000 to 2008 r2 in about two weeks. Like the old environment...

thanks for the reply Gail

See Gail Shaw's article at this link[/url] for more info

Is that absolutely true?

The way i understand it is that with snapshot isolation you first...

Please provide details of the steps you took!

Jai-SQL DBA (10/4/2012)

---

Date 3:A was established again and now we Need...

ananda.murugesan (10/4/2012)

---

I have configured index rebuild on weekly basis at 3 AM..in production server,

I have checked at 9 AM there is no table locking and blocking that particular table...

Incorrect, if you only have the primary and the witness and the witness goes down the principal...

you're welcome

To help combat sql injection ensure you assign only the required privileges to your accounts that access the database.

I'm still learning at the moment, caught some of it though

qew420 (10/1/2012)

---

2. It is possible to run another Instance from...

This will display the data more accurately

selectdf.name AS LogicalFileName

, isnull(fg.name, 'Log') AS FilegroupName

, physical_name AS PhysicalOSName

, (df.size * 8 / 1024) AS SizeMBs

, case df.max_size

when 0 then 'No Growth'

when -1...

you would need to use the forcequorum switch, have a search for this and you'll find more info

Larry Kruse (9/28/2012)

---

True dat Benjamin, but you can click an option to hide that VM Tool icon in the sys-tray.

I was hoping that there might be a DMV which might...

Hmm, this is a difficult one as there are already some very good scripts "out there".

I'm sure others will jump in here. 1000 pages is generally the perceived point at...