most importantly what recovery model does the database(s) use?

exec sp_msforeachtable 'alter index all on ? rebuild'

works for me

most likey that during the SSRS configuration the databases were installed to another server.

open Reporting Services configuration on the server and click on "Database Setup". The "Server Name" option will...

also online index rebuilds are a SQL enterprise feature only, it will be ignored if not using enterprise version.

no you cant. If you install 1 as...

its very rare though you would capture every column for an event 😉

Hi Lowell

you only really want to capture the events\columns you require otherwise...

Venki

you didnt indicate in your first post that the backup was a sql2005 database going into sql2000. This cannot be done. Only option is to DTS the data across to...

mixed mode does help

if you are not sure what you are doing i would leave well alone (and i mean that in the nicest way possible). Bring the cluster down and you could...

The problem is (and i have come across this before) if you do point out a dev's bad piece of code mostly they get uptight, jumpy and defensive instead...

Paul

what Jeff is saying (and you have to agree is quite correct),You shouldnt do it expecting a massive increase in performance otherwise you could well be dis appointed. There are...

if its a VM and you have the OS licence, may as well install 64 bit. As a VM you can scale memory, cpu and disk when required

here you go, courtesy of uncle Bill

http://www.microsoft.com/downloads/details.aspx?familyid=2ec9e842-40be-4321-9b56-92fd3860fb32&displaylang=en

what version vmware server you using?

have you mapped your VM's virtual NIC to the physical network or to a private virtual network, double check your config