Viewing 15 posts - 8,266 through 8,280 (of 9,253 total)
mldetch (4/8/2009)
I receive an error message stating the 'common criteria compliance enabled' does not exist or it may be an advanced option.'
it doesnt exist as you are not running sql...
April 8, 2009 at 2:48 pm
no as Lynn pointed out id 2 is the default trace
what version of sql server is this as common criteria is only available in dev or Ent sql editions
April 8, 2009 at 2:41 pm
so it sounds like it is common criteria, did you run the code Jack posted above?
April 8, 2009 at 2:39 pm
this is not a default trace as that logs to the LOG directory not the data directory
stop and close the trace as i specified, then go hunt down how this...
April 8, 2009 at 2:33 pm
from this
1 1 6
1 2 \\?\C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\audittrace20090407090827_200.trc
1 3 200
1 4 NULL
1 5 1
traceid 1 is your culprit and this "1 5 1" means its still running. Try stopping...
April 8, 2009 at 2:21 pm
FAT32 does not support file sizes of over 4GB (4294967296 bytes - 1), also your partition size is capped @ 32GB.
April 8, 2009 at 2:10 pm
google found this, it gives you uptime of sql instance in minutes
SELECT datediff(mi, login_time, getdate())
FROM master..sysprocesses WHERE spid = 1
April 8, 2009 at 1:51 pm
simply
backup and restore
or
detach and attach
the SQL 7 database to the SQL 2005 server and all the identities should be fine
dont forget to update usages and rebuild indexes afterwards
April 8, 2009 at 1:41 pm
what file system is the USB drive formatted with?
April 8, 2009 at 1:22 pm
Achtang (4/8/2009)
April 8, 2009 at 8:46 am
Krishna Potlakayala (3/28/2009)
You can't copy the .mdf file if the server is online.
"Au contrair mon pere"
you dont need to shutdown sql server!
you dont need to detach the database!
you dont...
April 8, 2009 at 6:39 am
Achtang (4/7/2009)
I want to configure cluster and...
April 8, 2009 at 5:31 am
use the alter index command, this is also minimally logged under bulk-logged and i think simple recovery too
April 8, 2009 at 5:12 am
Viewing 15 posts - 8,266 through 8,280 (of 9,253 total)