Viewing 15 posts - 8,491 through 8,505 (of 9,253 total)
dude madhu
BOL makes some assumptions here. Generally rebuild is used for corrupt installations of sql server and the restore of the system databases is standard routine, even then you may...
February 1, 2009 at 3:34 am
the following can be used to generate the scripts to grant execute on all SP's in a database if required
select 'grant execute on ' + s.name + '.' + o.name...
January 31, 2009 at 4:46 pm
am i right in thinking you have rebuilt the system databases to a different collation but then trying to restore the original databases with the original collation?
January 31, 2009 at 4:12 pm
madhu
what is the geographical location of your sql server?
January 31, 2009 at 4:10 pm
as Gail pointed out remember that to make the passive node active would require a new set of disk resources for the 2nd active instance. Is it worth the trouble,...
January 31, 2009 at 3:54 pm
Bear in mind that you will only be able to implement a 2 node cluster due to the limitations of virtual SCSI adapters. Clustering requires windows 2003 Enterprise OS. For...
January 31, 2009 at 3:51 pm
Jason try
select name, state, state_desc from sys.databases where state = 6
will show offline databases. Or check for
where state_desc = 'OFFLINE'
January 31, 2009 at 3:42 pm
did you try opening computer management console from your machine to remote server and viewing the services? My guess is this will fail. What permissions does your windows account have...
January 29, 2009 at 6:27 am
Jeff Moden (1/14/2009)
you floor a 4 week drive on black ice on a curve, all wheels loose traction at the same time.
that's neat. On the flip side, due to...
January 27, 2009 at 4:42 pm
yes, post installation just creates the windows service and licences it before creating the objects, but under 9.2 the SDE is part of the application server suite, even under 9.1...
January 27, 2009 at 4:36 pm
sblock (1/27/2009)
ArcSDE is installed on the same server as the Sql Server.
in an ideal world no. In v9.2 SDE is part of the ArcGIS server suite and the SDE libraries...
January 27, 2009 at 11:38 am
we're not using SQL 2008 but SQL2005. Have you checked the ESRI website for details of ArcGIS 9.2 and SQL2008
January 26, 2009 at 11:05 am
GSquared (1/22/2009)
how often in a DBA's career does it really matter that pages are 8k in size,
database sizing springs to mind, something a DBA may well be required to...
January 22, 2009 at 3:48 pm
sridevi_kj (10/21/2008)
I added the SMO reference in .net 2.0 in one machine in which sql server 2005 is installed. I used the SMO...
January 22, 2009 at 6:14 am
Viewing 15 posts - 8,491 through 8,505 (of 9,253 total)