Yes it does looks surprising.

But the amazing thing is that the overall DB size and the back up size also is much larger.

Also...

After running updatusage I get the following

DBCC UPDATEUSAGE: counts updated for table 'Tbl_FaoTrades' (index 'IDX_TD_LOGINID_TD_DATE', partition 1):

USED pages (In-row Data): changed from...

Asked here also

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=169550

Not sure..But cant we just take SQL totally out...

Cant you just write a 4 line code VBscript in a batch file to create a folder and schedule it using windows scheduler ?

Something like this

Dim folder

folder= "Yourpath"

set objFSO...

Yes it is a know bug.

What you can do is open a new instance of SSMS in a new window and the edit the same job and it will work...

Maybe you can go for a certificate based authentication where you create users from a certificate in database A and then create a SP in database B which executes a...

I wouldnt worry about fragementation for indexes having less than 1000 pages.

Run this and try

Grant Execute to Win_Read

Ok maybe snapshots were not such a good idea.

How about setting up LogShipping (if latency is accepatable) or snapshot replication ?

sqlnaive (10/14/2011)

---

i have set up new sql 2008 database server. I have created windows group Win_Read and provided it db_datareader and VIEW DEFINITION ON DATABASE DB_Test. Still the users inside...

gary.dunn (10/13/2011)

---

Hello, we have a production SQL Server 2008 R2 STD database stored at a remote site. The users would like a copy of this database created on a...

sqlbuddy123 (9/13/2011)

---

If you want Reporting Dbs to be in R\W mode, you can't use LS or DB mirroring. You need to use Replication but the setup would be a huge...

Thanks for the reply Ashish.

The client needs a separate reporting database for each OLTP DB.So if he has 350 DB's he wants 350 reporting databases each containing 20000 tables(not sure...