SELECT *

FROM sys.databases

WHERE database_id > 4

Jan Van der Eecken (5/17/2009)

---

Jan Van der Eecken (5/17/2009)

---

But if you are serious about donating a bat, why don't you hand it to Gail? We would surely figure out...

monsieurmark777 (5/18/2009)

---

The problem is the following: As the trigger sends the ten feeds to table2, if one of the batch of ten feeds violates the primary key, the...

Yup. Family came to SA when I was 4

Its still raining by...

There isn't one.

SQL 2005 (from SP2 onwards) has vardecimal, SQL 2008 has...

Don't shout at me.

You posted in the 2000 forums, hence I answered for SQL 2000.

In 2005 you can use...

Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

DBCC TRACEON(1222,-1)

Not in SQL 2000.

Yes, there's no single table restore in the native SQL tools. Some 3rd party backup tools (like litespeed) can.

You need to restore the backup as a new database, not one...

Corrupted table as in database corruption? (and if so, what are the errors?)

There's no way with the native tools to restore a single table. You can restore file, filegroup or...

If you're using SQL 2005 or 2008, you can use RowNumber.

Roughly, something like this

;With ContigDates (ID, BeginDt, EndDt, RowNo) AS (

SELECT ID, BeginDate, EndDate, ROW_NUMBER() OVER (Partition by ID Order...

South Africa is not Down Under. That term refers to the rather large continent somewhere to the east of...

Does the user that the web app connects as have rights to that table?

Please read through this - Managing Transaction Logs[/url]

Please don't repost existing questions in new threads. It just wastes people's time and fragments replies

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic715000-338-1.aspx