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

Matthew,

It's one thing to go to 2-3 servers, and another to go to 50. If you have 50, then it could easily be 30 or 100 in a year, so...

Look for any entries prior to this. It's a generic error, so likely something else was logged before this.