Viewing 15 posts - 8,806 through 8,820 (of 9,208 total)
how are you creating\starting the trace?
is it a server side trace?
October 7, 2008 at 5:46 am
yulichka (10/6/2008)
can't see the location where we moving
:exclamationmark: :exclamationmark:
October 6, 2008 at 9:59 am
timscronin (10/3/2008)
domain admin
not a good idea, remove that straight away. Create yourself a standard domain user account (no admin) and use sql server config manager to change the user account...
October 3, 2008 at 8:30 am
you could still use backup\restore
October 2, 2008 at 5:34 pm
timscronin (10/2/2008)
The sql server is running under the same account for all our sql servers, never changed
user account or local system?
October 2, 2008 at 5:31 pm
there is no upgrade path for express. detach the databases and re attach them under sql2005 standard, also script off the logins and apply those too
October 2, 2008 at 5:29 pm
also bear in mind regular autogrowths can leave you with physical file fragmentation 😉
October 1, 2008 at 4:02 pm
what account are the SQL services running under?
October 1, 2008 at 3:53 pm
shakti (10/1/2008)
updations
now there's a word for you
October 1, 2008 at 3:46 pm
Loner (10/1/2008)
I chose not to detach and attach the database because the database is a production database.
use backup and restore then!!
October 1, 2008 at 3:42 pm
JMSM (10/1/2008)
get all database owners of one specific database.
there is only one database owner, schemas however may be owned by more than 1 object!!
October 1, 2008 at 9:10 am
george sibbald (9/30/2008)
as long as you are using 32 bit SQL server, you will need to enable AWE to access memory over 4GB
and don't enable the /3GB switch in the...
September 30, 2008 at 3:23 pm
that's what i mean, i'm surprised you haven't seen the old BSOD
September 30, 2008 at 3:20 pm
net start will show a list of services that have started, you would need to cycle the list looking for SQL server. You could use WMI!!
September 30, 2008 at 3:18 pm
Viewing 15 posts - 8,806 through 8,820 (of 9,208 total)