You can't alter the system resourse database. It's not visible and can't be modified. In SQL 2005, the files must be in the same location as master.

Providing you don't mind which rows you get back, yes.

All that means is that you can't use the STOPAT command if there was a bulk operation within the log backup that covers the time requested.

If log backups occur at...

Run the log backup job every 15 min from midnight. That's probably the safest way. Log backups aren't blocked by full backups in SQL 2005. even if they were, the...

gints.plivna (11/1/2008)

---

BTW rownum has nothing to do with the row position in table. Rownum...

Grant Fritchey (11/1/2008)

---

Clearly not nearly enough people recall the SQL Server 6.5 sp5/sp5a debacle. You would have a heck of a lot more fear of the SP's when they come...

After an encounter with auditors that resulting in the entire DBA team receiving verbal warnings and been threatened with dismissal if we ever allowed an audit to fail again, I...

Bear in mind that if you lessen the checkpoint frequency you're going to increase the impact it has on your system. If it runs less often then when it does...

Now things make sense....

CREATE PROCEDURE [dbo].[LoadGalery]

(@rowNumber INT)

AS

WITH Im AS (

SELECT Id,Name,Tag,ROW_NUMBER() OVER(ORDER BY Name DESC)AS RowNumber FROM Galery ...

Continued here - http://www.sqlservercentral.com/Forums/Topic595406-8-1.aspx

dr_csharp (11/1/2008)

---

its not good for me,because i need some another field from Im besides count(*) :O(

i mean i need to select max(rownumber) and other fields but you are going to...

The first one throws an error because the last select refers to a table that doesn't exist. The derived table myTable is just a named subquery and it doesn't persist...

Please post in the correct forum in the future. This is the SQL 2000 forum and CTEs doen't exist on SQL 2000

Try this.

DECLARE @state BIT

SET @state='0'

;WITH Im AS (

SELECT Id,Name,Tag,ROW_NUMBER() OVER(ORDER BY Name DESC)AS 'RowNumber' FROM Galery ...

Does it throw an error? If so, what error? Does it give unexpected results?