Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
henriquerey
Starting Member
3 Posts |
 Posted - 2008-05-21 : 13:38:11
|
| Hi everyone,I'm new to SQL Server, but have worked a lot with oracle. I'm not sure if some of the terms I'll use is specific to oracle or if SQL server DBAs also use it. Please bear with me.I was wondering if I could change the default temporary database or file group (sql equivalent to oracle's default temporary tablespace)for a user.I also would like to change the rollback segment for a transaction. In oracle it would be: set transaction use rollback segment 'seg_name'.My sql server version is 2000 by the way.I would be very greatful if anyone could help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-21 : 13:40:43
|
| Users do not have filegroups. You can place objects in filegroups. Those objects can be owned by users. There is no default setting for an owner. Check SQL Server Books Online for details about filegroups.Could you explain in words what a rollback segment is?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
henriquerey
Starting Member
3 Posts |
Posted - 2008-05-21 : 13:49:03
|
| Tara, firstly, thanks for helping.A rollback segment is a space in the disk where oracle keeps the information necessary to rollback a transaction. Would that be the Transaction Log in sql server?With Oracle, you can create multiple rollback segments and set a specific transaction to use a specific one. Can you do that with sql server? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-21 : 13:50:51
|
| You can mark your transactions via BEGIN TRAN using the WITH MARK option. Check SQL Server Books Online for details.It is very rare to use this option though, meaning hardly anyone uses it. Typically we just restore to a point in time instead.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-21 : 22:25:50
|
| By the way, all users use same tempdb in sql server. |
|
|
|
|
|
|
Temp Segment / Rollback Segment