Have you tried the Integration Services Tutorials in BOL that comes with SS 2005? I know that you said you did not want Microsoft tutorials but if you haven't...

Are you using 2005? I'm in the process of learning for switching from 2000 but according to 2005 BOL, isql is no longer supported and sqlcmd should be is...

If you use ftp to transfer data between a windows machine and a unix machine, it normally strips out the the Carriage Return and leaves just the Line Feed that...

I can see one advantage and one disadvantage to the reasons already listed for dummying up data in the test environment:

- dummy data is better to obscure information for user...

If you are restoring a 2000 database to 2005 or detaching it and reattaching it, the users and roles will be contained in the database.

For some of the system roles,...

I am curious as to why you are moving from Enterprise Edition to Standard Edition if it is already paid for?

Steve

There is a version of sp_help_revlogin to go from 2000 to 2005. See the following article, Method 2.

http://support.microsoft.com/kb/246133/

Steve

Where are you located? Perhaps there is someone on this forum that is near by that (for a fee) could come and help you identify the scope of you...

You can also get the Sql Server 2005 Developers Edition for $50. It has all the functionality of Enterprise Edition but is to only be used for development and...

I'm sorry that old link doesn't work now. Try this one.

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

Steve

One other thought on converting from sp_ to some other prefix like usp_. If you use sp_ there could be times when you (or someone else) can get unexpected...

If your friend did not detach the database before copying the files, you will not be able to attach them.

Steve

In Access you can only have one statement per query. The way you run multiple statements is to create one query for each statement and then create a macro...

Am I correct in thinking that the size of the model database data and log files is the original size for tempdb when it is recreated? To change the...

I believe that in Sql 2000 the tempdb and log file get rebuilt when you reboot the server. Not sure if this applies to 2005. Of course, this...