40F in Denver, no need for pants today.:-P

Hardly, too many articles to keep track of. :w00t:

That uses SSRS. While that's the preferred method, if you don't have an SSRS server, I don't want to give you another...

I would not expect that the client tools work on XP, but I'll try to test.

Verify the path, if it's not working, include some MSGBOX lines in there, and see what values are being sent for the files and folders. It's basic debugging here for...

I assume you are backing up your production database, correct? Just copy the latest full backup to the development server.

If you are replacing the databases on the Dev server with...

database permissions do not cross database boundaries by default. You can enable this, but be aware of the security implications.

The filegroups matter. If you have other files in the filegroups that contain the full files, then the other files will be receive data. SQL Server sends data to filegroups....

There is a free SQL Search tool from Red Gate that will integrate into SSMS and let you quickly search for objects.

Disclosure: I work for Red Gate

Red Gate has the dependency tool that will allow you to find out what is linked to what.

However if you are expecting to right click on an piece of code...

I don't know a lot of people using Resource Governor, but they have been successful. It is a little more complicated to setup and understand, but it does do a...

Run the query for the top 20 and then loop through it, running additional queries.

In T-SQL, I'm not sure how easy this is. In SSIS, you can create a new...

If you use formal parameters, and you're not concatenating user input with code, then I think you are safe for the most part. I wouldn't say that you're completely safe,...

Is there an error when you put it in? If you've registered with the new email already, or it's in the system, it won't change. The error message sometimes isn't...

I tend to follow Gail's advice. 2 Full backups + all logs.

Going back more than a couple days is almost always impractical for any system. For auditing purposes, I'd rather...

Job is the way to do this. You're scheduling something.

However I'd make it fairly generic. Run it every day, enable/disable people based on a day of the month. Building...