Viewing 15 posts - 9,001 through 9,015 (of 9,241 total)
Redgate gets my vote
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 5:22 am
create a domain account and have the agent service runas that account (use sql configuration manager to change the account details). Give this account permissions to whichever remote folders it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 5:21 am
none of my registered servers have the green and white arrow only connected servers
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 18, 2008 at 9:48 am
Scott Duncan (8/11/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 2:52 pm
fully review all operations that occur over the weekend before the log backup happens on the monday, something is interrupting your backup chain. Does your index rebuild or maintenance plan...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 2:45 pm
are both machines on a network?
if so, put the cd into the drive of the machine where installation was successful and share the disk out. The launch setup from the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 2:34 pm
you can also run the SQL setup from cd and that can be used to modify installed instances
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 2:30 pm
i would apply some normaliastion to table 2 as suggested first as you'll find yourself ending up with some extra tables which will change the query anyway
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 12:32 pm
i always favour migrating to a clean install rather than upgrade existing instances
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 12:27 pm
have you tried re running the patch? it'll tell if if its already installed, might be worth re applying if you can
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2008 at 11:54 am
am i correct in saying you want to remove the extra filegroup and extra log file?
to remove the filegroup all objects in that filegroup would need to be moved to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 5:43 am
the 64 bit database backend should be transparent to the apps. SQL is SQL.
However check with the vendor that their app supports sql2005 as a database platform
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 5:38 am
use the SP_Addumpdevice stored proc, syntax is as follows
'type', 'device name', 'drive:\path\file'
type is either disk or tape
device name is the logical name you want to use
drive:\path\file should be self explanatory
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 4:48 am
which apps in particular?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 4:35 am
use this handy script to change object owner to another user for objects ion the database
select 'exec sp_changeobjectowner '''+user_name(Uid)+'.'+name+''','' ''' /*owner to assign to, dbo for example*/
from sysobjects
where user_name(uid) <>...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 4:34 am
Viewing 15 posts - 9,001 through 9,015 (of 9,241 total)