Is this an OS scheduled task? I'm sure there is, but it involves giving your privileges on the web that you might not want to do.

What I'd suggest is that...

Also be sure if you have a package or something that you're not waiting for user input. If you are, you're stuck.

Can you add some logging to the steps, to be sure it's completed? Maybe an insert into a table as the last part of a proc or package?

5 if on XP home, 10 on W2K Pro or XP Pro. OS limitations, not Express (http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx).

I mentioned it, but Roy's post made me think about it again. Be sure you argue for a development/test system that's the same size. Becomes really hard to work on...

I tend to agree with Wayne. While a good general knowledge of all parts of systems (all parts of SQL as well as windows, etc.), is good, if there's something...

Sorry about the links. Not sure what's wrong, but I'll see if I can track it down.

There are lots of stored procs in AdventureWorks. I know some authors use it as well on this site:

http://www.sqlservercentral.com/articles/Administration/2771/

http://www.sqlservercentral.com/articles/Product+Reviews/3050/

Active threads does show all threads receiving a post since your last login. It doesn't show just what you participated in.

The "Recent Posts" above has a few other options.

Gail is correct, you need to query every table with a GUID. And every column.

Use Jeff's query to find the tables/columns and then query each of those.

Apologies, looks like they've been moved to Codeplex (http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en).

Check permissions on that file. Be sure that the SQL Server service can access it. There could be permissions on that particular...

SQL Slammer used 1434 and it can be a problem. This port is used to discover other SQL Server instances and is a pain if it's not open, but you...

The DMV for plans shows what's in cached, but that doesn't tell you what's been run recently. If you had lots of different procs run, you might see them getting...

I don't know that there's a good collection anywhere that you can reference. Lots of blogs and short notes/articles around. Search "VLDB SQL Server".

You will probably have to consider filegroups...

Question has been changed to say 2005. Thanks for the comments.