I have just recently started leaning sql and am reading through my 70-431 as i have limited experience with SQL (All versions, all vendors) I have a few questions:
1. Did MSSQL 2000 Support SSIS Packages? My understanding was that
ssis was introduced with SQL 2005
This document from MS is confusing me:
http://technet.microsoft.com/en-us/library/cc966397.aspx Specifically: This paragraph:
In SQL Server 2000, when a user wanted to execute a SQL Server Integration Services (SSIS) package as a job step, the sysadmin had to enable the SQL Server Agent proxy account. After the account was enabled, any SQL Server Agent user could create job steps for certain subsystems, such as CmdExec, and run them by using this account. In SQL Server 2005, SQL Server Agent addresses this security concern by using multiple proxy accounts.
TO me the first line should say Server 2005 not 2000?
Next Question:
When discussing database collation does this definition fit:
1. Database collation is the process (or rules) of comapring data within a character set? But not the character set itsef?
Meaning us-ascii + "Collation Rules" = proper function of character within database?
Thanks,
Robert
