Viewing 15 posts - 8,326 through 8,340 (of 9,253 total)
is that just the data file or does that include log as well?
is it absolutely critical to release the space, why not just leave it there. it will most likely...
March 20, 2009 at 10:58 am
homebrew01 (3/20/2009)
I guess I'm wondering if there's some quirk about a particular table that could make it fail
no quirk, you just dont need the []
March 20, 2009 at 10:56 am
how big is the database currently and how much space is free?
PS. for sql2000 issues you may want to post in the sql2000 section
March 20, 2009 at 10:48 am
check the NFTS permissions on the database files, the user you are logged on as likely doesn't have permissions to the files
March 20, 2009 at 10:30 am
most importantly what recovery model does the database(s) use?
March 20, 2009 at 10:24 am
exec sp_msforeachtable 'alter index all on ? rebuild'
works for me
March 20, 2009 at 10:22 am
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...
March 20, 2009 at 10:17 am
also online index rebuilds are a SQL enterprise feature only, it will be ignored if not using enterprise version.
March 19, 2009 at 1:04 pm
karan457 (3/19/2009)
if i want to install ss 2000 & 2005 on one windows boxq) can i install both as default instance
no you cant. If you install 1 as...
March 19, 2009 at 12:54 pm
Lowell (3/19/2009)
the level of granularity seemed a bit tedious to invoke.Thanks!
its very rare though you would capture every column for an event 😉
March 19, 2009 at 12:42 pm
Lowell (3/19/2009)
That's what made me think there must be a reason to enable some columns and not all columns.
Hi Lowell
you only really want to capture the events\columns you require otherwise...
March 19, 2009 at 11:00 am
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...
March 17, 2009 at 6:23 am
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...
March 15, 2009 at 10:30 am
Viewing 15 posts - 8,326 through 8,340 (of 9,253 total)