I'll move to the SSIS forum.

Note that you might want to still pick up a beginner's C# book. The concepts of the language will help you debug packages. You...

If you look under the scripts section of this site, there are lots of Index Management scripts you can use.

I'll add one more question. How long did you notice that the SPID was executing?

How will you set the primary to restoring? you can't back up the tail log, set the database to restoring, and then restore a log from the secondary. You will...

There is a runtime for DTS packages in 2005/2008 that will allow you to run your old packages

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.