Viewing 15 posts - 8,311 through 8,325 (of 9,241 total)
did you create a default or named instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2009 at 3:31 am
change your windows file association for .SQL scripts to something other than SSMS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2009 at 3:30 am
cloud (3/20/2009)
The machine doesn't have a lot of space...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2009 at 3:02 am
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 21, 2009 at 2:59 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 []
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2009 at 10:30 am
most importantly what recovery model does the database(s) use?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2009 at 10:24 am
exec sp_msforeachtable 'alter index all on ? rebuild'
works for me
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2009 at 11:00 am
Viewing 15 posts - 8,311 through 8,325 (of 9,241 total)