got it on...

you sqlserver services are running on the Local account, used for the installation

Typing "Sel" or "Ins" etc...and pressing Tab, waiting for auto complete...like cmd.....

:pinch:

Select Distinct FLTNBR,STARTTI

:w00t:

I completed the cert.....

use BOL.

You will need to provide the error on Step level, and not only package level.

Go into the SQL Agent, under jobs, drop down the specific job, focus on the step...

make use of COLLATE before your "IN"...

COLLATE Latin1_General_CI_AS

they could as you to explain what you will do when presented...

use:

1. SSIS

2. Import/Export Tool

3. Tsql

right click any database, tasks, Import data...

I am getting a bit confused about what you actually want....

Instead of giving your backups custom names, do default backups in sql server which will include a date and timestamp....example:...

in windows explorer you can view the modified date as a column header.

activate it if it's not there by default (which it should be)...

Familiarize yourself with how SQL Server utilizes CPU and Memory from the Host.

Read up on AWE & PAE, maximum & minimum memory usage; Lock pages in memory; differences in 32bit...

SELECTt.name as [DB Name],

t.user_access_desc as [Access State],

t.state_desc as [Online/Offline],

((SELECT (CASE t.is_in_standby WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' ELSE 'Other' END))) as [In Standby],

(COALESCE(Convert(datetime, MAX(u.backup_finish_date), 101),'Not Yet Taken')) as...

Jason, I'm actually aware of a few places who are forced by legacy apps to run 6.5....and by the looks of this:

Correct answers: 38% (54)

Incorrect answers: 62% (89)

Total...

http://www.sqlservercentral.com/Forums/Search1-2-1.aspx?SessionID=qqepqxjqectt1q45bhztsfqb&SortBy=12&SortOrder=1