Viewing 15 posts - 1 through 15 (of 245 total)
You can find service stopped and started time and date from msmdsrv.log.By default the C:\Program Files\Microsoft SQL Server\MSAS13.MSSQLSERVER\OLAP\Config..You can also find the location of msmdsrv.log from SSMS connect Analysis server,...
December 18, 2019 at 2:10 am
These flags were enabled after the install of security patch KB4293807.
Microsoft is not publicly stating what the effects of the enabled trace flags were, but has to pulled KB4293807...
September 12, 2018 at 1:03 am
If we chose transactional replication what happens to the changes made in dev databases.
October 28, 2013 at 9:03 am
it should be read-write, but only one way synchronize from prod to dev.
October 28, 2013 at 8:23 am
Thanks a lot for your help.
Actually im importing the values using import export wizard.
March 28, 2012 at 5:38 am
This was not helpful. Is there some query that doesn't require to create any trigger,sp etc.
January 30, 2012 at 8:58 pm
Actullay it is working fine in 2005 Enterprice edtion with the same cofiguration but its failing in 2008R2 standared edtion to which the database was migrated. The free space became...
December 15, 2011 at 6:18 am
Im running rebuild index using the maintenance task against the entire databases and not a single index.
from sp_spaceused i get
index_size is 254032088 KB
and each file is having less...
December 15, 2011 at 1:01 am
Hi Gail ,
I ran DBCC UpdateUsage (0) againt the database but the result is the same.
December 15, 2011 at 12:54 am
Im not sure if its something to do with the edition.
Im running offline index rebuild in the 2008R2 Standard edition.
December 14, 2011 at 1:45 am
Im running rebuild index from maintenance plan its not run for one index its for the entire database i dont know how to check how big the index is there...
December 13, 2011 at 7:20 am
Please find the attached screenshot of filegroup and autogrowth setting.
Its all default indexes present from 2005 database.
December 12, 2011 at 7:42 am
There was one more instance
Windows Internal Database (SQL Server Embedded Edition) is a variant of SQL Server Express 2005 that is included with Windows Server 2008.
Service name is...
May 31, 2011 at 2:53 am
Thanks a lot.....
Actually I wanted to know where exactly the published data will be stored 'Snapshot folder or Distributor database' and how much disk space we should need to give...
March 2, 2011 at 4:11 am
Thanks a lot Adi,
it is working fine.
Do you have any idea how to pass "like wildcard" in DB2.
--I'm able to create the table.
create table Demo (vc varchar(6) constraint CK_CheckOnlyDigits check...
April 21, 2010 at 2:14 am