I was disappointed by the backlash from this. It seems there are some architects and developers that are concerned this won' allow them to work on problems in other platforms,...

How did you stop SQL Server and what do you mean "impossible"? It can take time for the system to shut down as transactions need to be rolled back to...

the general construct in t-SQL is

If (condition)

begin

true statements

end

else

begin

false statements

end

http://msdn.microsoft.com/en-us/library/ms182717%28SQL.90%29.aspx

Search for a paging script. That's the idea of what you're trying to do. I'm not sure how to do it in SSIS, but that's the idea.

I would guess it could, but you'd end up processing row by row. If you don't get the data in any order, how do you know which items are linked...

Had a great, unwired weekend and I'm back.

And buried in work.

You can set up a trace for this and filter it by selected logins. Or you might be able to use the SQL 2008 audit feature: http://msdn.microsoft.com/en-us/library/dd392015.aspx

The error from the OS is a simple error that means what it says. There is not enough space. If you get any errors that have OS Error in them,...

http://msdn.microsoft.com/en-us/library/ms188004%28SQL.90%29.aspx

The link provided will help you script out the users and passwords, which you can then run on the new server.

do you mean for all rows? If so, you can do a SELECT and use the + operator to concatenate fields.

SELECT name + CHAR(13) + class + CHAR(13) +...

DATEADD is the way to pick the dates based on today, as ALZDBA has mentioned. You can read more about it here:

http://msdn.microsoft.com/en-us/library/ms186819%28SQL.90%29.aspx

I agree with Jack. Why do you need to loop?

If you are working on position, you would have to have some column that lets you now what order is where. Once data is in SQL Server, it has no...

It's an interesting question to ask of people. I think that we are all givers and takers, but at different points in our careers. I know many people that don't...