Google should've answered this quickly

http://www.singingeels.com/Articles/Pagination_In_SQL_Server_2005.aspx

ROW_NUMBER() Books Online

SELECT * FROM

(

SELECT *

, row = ROW_NUMBER() OVER (ORDER BY ID)

FROM task_log

)

WHERE row BETWEEN 51 AND 60

I give up trying to understand the question 😛

My bet is on NUMERIC being deprecated (keeping DECIMAL)

but it's an easy fix of Find-and-Replace anyway, and probably be a long while anyway

DECLARE @TableNo INT

SET @TableNo = ((select count(*) from MasterList) / 10000)

DECLARE @TableCount Int

SET @TableCount = 1

DECLARE @MasterName varchar(50)

DECLARE @sql nvarchar(500)

WHILE @TableCount <= @TableNo + 1

BEGIN

SET...

For you Run As credential

can you try SERVERNAME\account?

if you don't have the NewDomain\WindowsAccount

and is that local account Administrator?

worst case, Remote Desktop in and start perfmon

As far as I know, you will affect the performance either Remotely or Locally

Relative Theory eh...

oh, the official window title of "perfmon" is "Performance"

so I meant I just ran Perfmon...

http://msdn.microsoft.com/en-us/library/ms187746(SQL.90).aspx

SQL Server 2005 Books Online (September 2007)

decimal and numeric (Transact-SQL)

Numeric data types that have fixed precision and scale.

decimal[ (p[ , s] )] and numeric[ (p[ , s] )]

...

You can Remote Desktop in and start perfmon locally?

We use different domain here, I just ran "Performance" with Run As under different account

connect to a SQL Server, and got the...

Do you necessarily need to create tables for them though?

or if you really do, select all 40000 into 1 temp table with Identity column

work on all 40000 records at once

then...

Mathematically, it is correct to show 1 instead of 00001 for the INTEGER data type

Maybe you can explicitly select it as NVARCHAR

if not, use REPLICATE to fill in the 0's

SELECT...

Fortunately I can install and use SSMS Tools Pack (for 2005 and 2008), which generates the INSERT statements for me

http://www.ssmstoolspack.com

Best Practice for forum code

SELECT dbo.JobActual.TitleID,

...

If you can afford to send a test email to "sqldba@company.com" in Outlook or whatever email program, do that. That's the best way

If that works, SQL Database Mail should work...

Yes, the lovely UTC vs Daylight Savings Time

Looking around the sp_update_schedule Books Online

http://msdn.microsoft.com/en-us/library/ms187354(SQL.90).aspx

I am thinking 3 options

1. the way you did, update schedule

2. Create all the jobs with new schedule,...

sorry my bad

Replace the WHERE in my code with ON, that should do it