does Sql server has command equalent to Rollback to in Oracle

HI All

does Sql server has command equalent to Rollback to in Oracle. That means when you do some update operation and i want to revertback the original record. If so what is that command.

With Regards,

AHARI

Yes it does:

BEGIN TRAN

UPDATE....<your update statement>

ROLLBACK/COMMIT TRAN

By the way, you should try the T-SQL forum for this sort of question: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=85&SiteID=1

-Jamie

Does RS use the MS FullText Search Engine?

Not sure what this question means, but I am being asked this by our
Technology Department.
Somehow the SQL Server instance where the Report Server databases were got
dettached. They were able to re-enable it, but they cannot restart this
engine because of a corrupt configuration file.
They are asking me whether they should keep researching and trying to fix
this file or they can just remove the engine from the cluster.
Thanks!
Ray G.The FullText search engine is not used by RS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"RayG" <RayG@.discussions.microsoft.com> wrote in message
news:44515EB2-37F2-4073-B085-023B8051A788@.microsoft.com...
> Not sure what this question means, but I am being asked this by our
> Technology Department.
> Somehow the SQL Server instance where the Report Server databases were got
> dettached. They were able to re-enable it, but they cannot restart this
> engine because of a corrupt configuration file.
> They are asking me whether they should keep researching and trying to fix
> this file or they can just remove the engine from the cluster.
> Thanks!
> Ray G.

does it means there is still a index there?

i know when I set a primary key for a table.i will get a cluster index.
but if i remove that cluster option on INDEX/KEY OPTION　PAGE.　i still
find i can choose ASC /DESC?
does it means there is still a index there?An index is always created for a primary key constraint. By default this is
a clustered index but you can also choose a non-clustered index (by
deselecting the clustered option). The ASC/DESC option applies to both types
of index.
David Portas
SQL Server MVP
--|||we know, INDEX may some time affect performance of DataBase if we often
update data. why SQL SERVER compel us bind a index to a primary key?|||Because that is by far the fastest and most efficient way to enforce
uniqueness. Without index, SQL-Server would have to do a table scan
whenever a new row is added, just to see if it's primary key is unique.
In addition to that, if you do not update the indexed column(s) or the
column(s) of the clustered index, then the index will not affect UPDATE
performance.
Gert-Jan
why bind a index to a primary key? wrote:
> we know, INDEX may some time affect performance of DataBase if we often updat
e data. why SQL SERVER compel us bind a index to a primary key?
(Please reply only to the newsgroup)

Does anyone know what this means? Anyone?

AuthzInitializeContextFromSid: Win32 error: 234
get this when trying to send an email subscription or a file-share
subscription. Running the service as a domain account and made the account a
member of the WAA group.I should probably mention that I love the "there is more information in the
log file" message that you can find....you guessed it...in the log file.
"chicagoclone" wrote:
> AuthzInitializeContextFromSid: Win32 error: 234
> get this when trying to send an email subscription or a file-share
> subscription. Running the service as a domain account and made the account a
> member of the WAA group.|||In fact, I read the log file, it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
so I checked the log file, and it said "there is more information in the log
file".
I eventually got out of this endless loop after about 16 hours of
recursively checking the log file.
"chicagoclone" wrote:
> AuthzInitializeContextFromSid: Win32 error: 234
> get this when trying to send an email subscription or a file-share
> subscription. Running the service as a domain account and made the account a
> member of the WAA group.

Does anyone have a script to reset all logins on a server?

We want to merge 2 SQL servers into one. This means we will have duplicate logins with differing passwords.

We want to reset all the passwords on one server to something memorable. Does anyone have a script that cursor through (or trans - I'm not shy) all the logins in a mster db? I really don't fance going through hundreds of logins changing their passwords by hand!

Looking into it, I think I can cursor through master.dbo.sysxlogins and reset the passwords using sp_password, as such:

sp_password Null, 'Newpassword', 'loginname'

Anyone see a problem with the above?