As others have alluded to, there is no inherent order to data in a relatational database thus trying to sort it before inserting it has no value. To retrieve...

I love that you can drag the columns node into an edit session and get a comma separated list of the columns. Sure helps with not using 'select *'...

Someone has put together the script needed to have an XML destination from SSIS.

http://tinyurl.com/33lnkg

The instructor for a SS 2008 class pointed this out.

Steve

You can do a select of the fields you're interested in from master.dbo.sysprocesses (db_name(dbid) gives you the database name when it is not 0). This works on SS 2000...

I did notice that in the very beginning you stated that your position was not considered a DBA position. Maybe more than the raise (which it sounds like you...

And when the time comes to actually start deleting the tables, I would rename them first, say saveTableName. Then if it is really needed it will be quite easy...

I just found out yesterday that if you are trying to restore the database that is your default database, it will not work from SSMS. You can set your...

Microsoft may have an easier way in SS 2008. To run a package by using a SQL Server Agent job:

?To run a package in 32-bit mode from a 64-bit version...

Microsoft Press put out a book name "MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008—Business Intelligence Development and Maintenance" that does some step by step learning.

Steve

After more work, I found the Preparation Task needed to be changed.

Exec sp_MSForEachTable

'

ALTER TABLE ? NOCHECK CONSTRAINT all

ALTER TABLE ? DISABLE TRIGGER all

'

GO

Exec sp_MSForEachTable

'

IF object_name(Object_ID(''?'')) NOT IN

(''table1_not...

After some research and trial and error, I plan to use the following steps:

1) Using the Import / Export Wizard and select all tables with the CheckBox

2) Edit Mappings and...

CEWII,

I was afraid of that. I'm sure that the wizard is quicker. I wish that it would default to delete existing rows instead of append so I wouldn't...

I got cured of the all-nighter mentality when I deleted a program about three AM. That and getting married.

My Dad used to have a saying: "The hurry-der I go,...

sql.rohit,

Look into running a trace for the specific information and events you need. You can do this with Profiler but if you want to run it more long term,...

After being distracted for a while with something as mundane as work, I was able to set up my tracking of logins/failed logins using a server side trace. Every...