I'm late here ...anyway Congratz Jonathan!

If you are sure that you install SSAS during the installation, be sure that your service is running at the SQL Server Configuration Manager!

Do we have any possibilities to make snapshot just in particular objects not snapshot all DB!???

Example is if I want to snapshot 3-4 tables every 15 min, then these results...

it's sure that you can find many ways one above and this one for is the best:

USE Your_Database;

GO

SELECT o.name AS "Table Name", i.rowcnt AS "Rows"

FROM sysobjects o, sysindexes i

WHERE...

I'm not sure why do you want to run SP, till you can run this script and see some results anywhere in your DB, try it:

SELECT o.name TableName ,i.rows TblRowCount

FROM...

Do you have active constraints ... try to disable constraints and after that try deletion then enable constraints again !

Jeff Moden (11/18/2008)

---

Dugi (11/18/2008)

---

Try to truncate table

TRUNCATE TABLE name_of_your_table

couz the DELETE command is logged and every deleted action will recorded on log file and if you have million of records...

Try to truncate table

TRUNCATE TABLE name_of_your_table

couz the DELETE command is logged and every deleted action will recorded on log file and if you have million of records sure that you...

yes the row_number() combination with CTE works perfect to find the values as you want to show couz you have also other function like rank() dense_rank() Ntile()

great post here,...

Good stuff here about logs! Nice article Gail! 😎

Be more specific for your problem ...!?

homebrew01 (10/3/2008)

---

I don't mean to sound like a wise-guy or anything. But why don't people back up their databases ?? How many posts have there been over...

Profi solution and nice stuff here about this problem!

If the process is a routine maybe the best way is SSIS Package and run it whenever you want!

😉

Ok I have experience from SQL Server...