You might also want to use SCOPE_IDENTITY() rather than @@IDENTITY. See BOL for IDENT_CURRENT for an example of these three concepts.

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

Whether or not you have too many indexes, depends on your system and the queries against the db. There is no general answer to this. But I'd like to think...

Sorry to hear that! Hope you have a good insurance for that!

You are a non-native speaker, too???

Yes, that's a way to achieve somethings similar. Have a look at BOL for ALTER TABLE. Section G. deals with how to disable and reenable a constraint.

Btw, not everything what other RDBMS...

One might be inclined to think, you're trying to reinvent the wheel.

Isn't that something for log shipping?

Finally it hit me where I have read this term "Ghost records" before.

When you examine a data page via DBCC PAGE you also...

Thanks for this. Is there a great difference when someone is familiar with PHP?

Doesn't make too much sense now, but have a look at this and you'll get the idea:

USE PUBS

SELECT TOP 10

 au_fname

 , au_lname

FROM

 authors

WHERE

 au_fname > 'L%'

ORDER BY

 NEWID()

...ORDER BY NEWID() is a good randomizer, though not really supported for that.

Here's an example using a cursor I picked up from SQL Server MVP Steve Kass

declare @keys...

Are you after something like this?

SELECT

 CAST(SO.[name] AS CHAR(20)) AS TableName

 , CAST(SI.[name] AS CHAR(30)) AS IndexName

 , CAST(SC.[name] AS CHAR(15)) AS ColName

 , CAST(ST.[name] AS CHAR(10)) AS TypeVal

 , CASE

  WHEN (SI.status &...

You might want to try dbcc log( your_db, -1) first. However, I doubt, you will be very happy with what you see there.

But what are you really after anyway?

Sure, at the moment 1206 links related to SQL Server to be found here:

http://www.insidesql.de/component/option,com_bookmarks/Itemid,42/

Almost all are in english

The following is a brute-force method and should not be every day's practise.

Can you detach the db? If so, detach it, rename or delete the log, attach the db....