with cte (id,srno,acc_quantity)

as

(select a.id,A.SrNo,isnull(sum(b.actual_quantity),0) as acc_quantity from

(Select ROW_NUMBER() OVER(PARTITION BY ID order by start_dt) as SrNo,id ,actual_quantity, start_dt from #actual ) A

left join (Select ROW_NUMBER() OVER(PARTITION BY ID order by...

We do database mirroring and replicate from database mirroring

Refer to this document as well

Database Mirroring and Log Shipping Working Together

In your posting you mention you drop and rebuilt clustered index

You should drop and rebuilt this index instead,

select object_name(1649597115)

table :MultiSpuDownloads

index :U_IXN_MultiSpuEdptProp_spuId

Your dbcc checkdb result mention that

Table error: Table...

1. Log file size=276 gb,

you can check how much it actually occupied.

If you backup transaction log, The data will clear from transaction log and you see how much free space...

malcolm 81944 (7/6/2011)

I created a FULL backup job that runs every Sunday, and creates a new file each time.

I created a DIFF backup job that runs every night, and creates...

If you want deny user from select the table

you should

Deny select on test_table to test_user

"revoke select on test_table to test_user"

only remove the select permission of this user (test_user) from...

we use this to check the log

sp_dbmmonitorresults

example :

exec sys.sp_dbmonitorresults @database_name =N'Adventureworks', @mode=9, @update_table=0

retrieve mirroring log for adventureworks for Last 1,000,000 rows

or

we can launch database mirroring monitor, that is...

"Synchronized/restoring"

- Database mirroring setup ok

- Both principal and database mirroring in already synchronized.

- Database mirroring in restoring mode and user can't be read/write until we failover the principal to...

I want go for MCM SQL. I already pass the required exam and start download the 70 video when it start release from Microsoft site. From the feedback, the exam...

1st question: IS there a way to get the trace files to collect data even while Profiler is not up and running? ]

trace and collect data without running profiler GUI

You...

you can try to check the log file locate in %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\ ?

I have the same problem and I do this

1. My computer- > right click

2. Advance -> environment Variables

3. System variables- > path

** Please change with careful **

let say you have...

Thanks for quick response,

I actually already include SQL2000.AS-KB884525-SP4-x86-ENU.EXE in this analysis service

Read from blog,

with title.. SQL Server 2005 SP3 - coming soon

Published 15 April 08 05:00 PM

http://blogs.technet.com/dataplatforminsider/archive/2008/04/15/sql-server-2005-sp3-coming-soon.aspx

how true is it? It should a good news for SQL 2005...

If i backup transaction log every 2 hours and the log file size grow until 35 gb

I will

Check backup size of log file which i backup every 2 hours.

one day...