Viewing 15 posts - 8,311 through 8,325 (of 9,244 total)
GilaMonster (3/22/2009)
naimish_2005 (3/22/2009)
I got this software from online sharing website.??????
yeah i know slightly supsect and worrying.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2009 at 7:47 am
the OS reqs are at the following link
http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx
you can install either Standard, workgroup, express or developer only on XP Pro SP2
and developer or express on XP Home
is your OS XP...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2009 at 6:47 am
ok, try from another angle! Did you accept all the defaults during installation or did you change any sections of the installer (such as the part where it indicates create...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2009 at 4:42 am
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
Viewing 15 posts - 8,311 through 8,325 (of 9,244 total)