I'm not sure how you'd change the owner. Export the plan, import as the other user?

Changing the owner on the job should affect that, but I guess is you edited...

IO latency can contribute only if new transactions need to be written and the checkpoint cannot complete to clear space. I'd say no in general, but it could cause larger...

Can't use sp_update_jobstep to change the commend you run?

Sorry about that; should have noticed the forum 🙁

SQL Server doesn't look at the internal space counters, AFAIK, to determine when to grow the file. It looks to allocate space from one of the IAM/GAM/SGAM pages and if...

I'd say go for 2005. There are plenty of 2000 and 2005 instances out there and I'm not sure how many people will go to 2008. Some 2008 exams are...

This sounds like homework or a test question, so it would be good for you to try some queries. We don't like to do work for you, but rather help...

I saw something similar a few years ago, but I can't remember what was causing it. I'd call PSS since this is one of those strange errors and they can...

I've always had to store locally as a CSV and then import with DTS.

There are a few great series on XML here on the site.

You might start here: http://www.sqlservercentral.com/search/?cx=000517265726492607871%3Agqdiynsp-y0&cof=FORID%3A9&q=xml+workshop&sa=Go#1194

what were you using for the connection string? IP?

Sorry about the image. The link was to something else and it must have changed on the other end.

New image loaded.

with MyCTE as

( select

empno

, datediff(d, startdate, enddate) 'worktime'

from test

)

select empno, sum(worktime) 'total'

from MyCTE

group by empno

You can right click the database in SQL 2000 and generate a script. There is a checkbox to include security.

Don't cross post. Post for the correct version and stop.

Answered here: http://www.sqlservercentral.com/Forums/Topic558880-146-1.aspx