Viewing 15 posts - 27,271 through 27,285 (of 39,768 total)
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...
August 26, 2008 at 8:35 am
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...
August 26, 2008 at 8:33 am
Can't use sp_update_jobstep to change the commend you run?
August 26, 2008 at 8:30 am
Sorry about that; should have noticed the forum 🙁
August 26, 2008 at 8:29 am
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...
August 26, 2008 at 8:25 am
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...
August 26, 2008 at 8:21 am
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...
August 26, 2008 at 8:19 am
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...
August 26, 2008 at 8:16 am
I've always had to store locally as a CSV and then import with DTS.
August 26, 2008 at 8:14 am
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
August 26, 2008 at 8:14 am
what were you using for the connection string? IP?
August 26, 2008 at 8:13 am
Sorry about the image. The link was to something else and it must have changed on the other end.
New image loaded.
August 26, 2008 at 8:13 am
with MyCTE as
( select
empno
, datediff(d, startdate, enddate) 'worktime'
from test
)
select empno, sum(worktime) 'total'
from MyCTE
group by empno
August 26, 2008 at 8:10 am
You can right click the database in SQL 2000 and generate a script. There is a checkbox to include security.
August 26, 2008 at 8:07 am
Don't cross post. Post for the correct version and stop.
Answered here: http://www.sqlservercentral.com/Forums/Topic558880-146-1.aspx
August 26, 2008 at 8:07 am
Viewing 15 posts - 27,271 through 27,285 (of 39,768 total)