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.c
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
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
the "collation" indeed specifies how characters are encoded and compared.
So then would i have a character set and then collation set or are they the same thing? i get the compared part
but i thought that there were 2 disctinct and seperate "Packages" 1 being the charcerter set and the other
being the collation set that is then applied to the charcter set?
Business Accounts
Answer for Membership
by: angelIIIPosted on 2009-11-08 at 13:53:56ID: 25772110
1. ms sql 2000 does not implement ssis packages, but DTS packages.
however, if you have the sql 2005 client tools installed, you can still run the ssis package from command line (and hence for a sql agent job, even from a sql 2000 instance).
so, the line "sql 2000" is correct, especially reading the last line:
"In SQL Server 2005, SQL Server Agent addresses this security concern by using multiple proxy accounts"
this feature is new in sql 2005..
2. to start with: the database "collation" is the "default collation" used, whenever no explicit collation is specified.
this includes varchar/nvarchar constant values in queries run against that database, or when creating tables with n/varchar columns without specifying the collation...
the "collation" indeed specifies how characters are encoded and compared.