[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

11/08/2009 at 01:47PM PST, ID: 24882000 | Points: 250
[x]
Attachment Details

WIndows 2003 - SQL 2005 - SQL 2000

Asked by castellansolutions in MS SQL Server

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
[+][-]11/08/09 01:53 PM, ID: 25772110

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/08/09 05:05 PM, ID: 25772833

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20090824-EE-VQP-74 - Hierarchy / EE_QW_3_20080625