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,...

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...

If we chose transactional replication what happens to the changes made in dev databases.

it should be read-write, but only one way synchronize from prod to dev.

Hi Lynn,

Thanks a lot for your help.

Actually im importing the values using import export wizard.

This was not helpful. Is there some query that doesn't require to create any trigger,sp etc.

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...

Hi Gail/Ninja's_RGR'us

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...

Hi Gail ,

I ran DBCC UpdateUsage (0) againt the database but the result is the same.

Hi Anish,

Im not sure if its something to do with the edition.

Im running offline index rebuild in the 2008R2 Standard edition.

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...

Please find the attached screenshot of filegroup and autogrowth setting.

Its all default indexes present from 2005 database.

Sorry,

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...

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...

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...