Viewing 15 posts - 8,281 through 8,295 (of 9,244 total)
after the upgrade from sql2000 to sql2005 did you run the DBCC Updateusage and rebuild indexes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2009 at 3:54 pm
kiran.kamuganti (4/3/2009)
FYI: I tried with generate script from all tasks by selecting the object level permissions and it is of no use.
you havent tried very hard then have you!
either the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 3, 2009 at 5:23 am
webqatesting (4/3/2009)
I have an application with SQL Server 2005 as the database.
Recently i'm getting an error " transaction log of the [mydatabase] is full ".
I searched for this error and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 3, 2009 at 5:14 am
what is the OS version/edition you are using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 3, 2009 at 5:10 am
once you start the restore process if you then kill it you have to wait for it to roll back, this could take some time, hence why it still shows...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 4:12 pm
in future, for sql2000 queries please post in the correct forum area 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 4:10 pm
it should live in the following location
C:\Program Files\Microsoft SQL Server\90\DTS\Binn
it should look like the file attached. Once you have changed this file you will need to restart the “SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 3:58 pm
Achtang (4/2/2009)
Thanks for that,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 9:54 am
Achtang (4/2/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 9:50 am
prvreddy (4/2/2009)
which is pirated one.
sorry matey, as the old saying goes "all pirates should find their own treasure", i cant be seen to be helping someone who condones piracy
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 9:25 am
it did work.
i restored master onto another instance called the db "Newone" and it created the files
newone.mdf
newone_1.ldf
i then detached the db after restoring it and copied the disk files to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 8:22 am
Achtang (4/2/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 8:13 am
Achtang (4/2/2009)
What is the dfference between service packs and hotfixes?
a hotfix addresses a single issue. A service pack is a roll up of many independant hotfixes, etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 7:56 am
if master is truly hosed you will need to rebuild first using the cd
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 7:54 am
prvreddy (4/2/2009)
How it is possible to run sql server if master database corrupted?.
read Gails link below
http://msdn.microsoft.com/en-us/library/ms190190.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2009 at 7:42 am
Viewing 15 posts - 8,281 through 8,295 (of 9,244 total)