Hi Nelson,

No problem and I hope you found the trigger useful.

Yes, the trigger executes as Auditor, a user that has the minimum level of permissions required to insert to the...

70-458 scheduled for ?Tuesday, November 18, 2014? my confirmation email said "Appointment Length: 120? Minutes?".

for my re-scheduled test for Thursday, January 15, 2015?, my confirmation email said "Appointment Length: 180?...

I too failed 70-458 today (Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2).

I passed 70-457 (Transition Your MCTS on SQL Server 2008 to MCSA:...

Also, see the following article: -

http://www.sqlservercentral.com/columnists/kfeit/portabledtspackages.asp

Regards,

Andy Jones

You can declare the connection parameters as global variables within the package. You can assign these global variables at run-time then have a dynanic properties task within the DTS package...

You can create an internal representation of an XML doc using sp_xml_preparedocument and then query using OPENXML. Search for sp_xml_preparedocument and OPENXML in BOL.

Regards,

Andy Jones

There is also an article about this, see: -

http://www.sqlservercentral.com/columnists/dPriyankara/versionservicepack.asp

Regards,

Andy Jones

I would use DTS to import the data with no modifications into (2 or more) holding tables. Then use TSQL statements to move the data into the live tables including...

Sure, here is a simplified version.

I am loading data from a flat file into a holding table (T1), each record is identifiable by the code in the first field e.g.

T1

C1(varchar(3))C2...

Follow the link above and click the SQLPASS link in the first sentence.

Regards,

Andy Jones

Hi, see: -

http://www.sqlservercentral.com/columnists/awarren/commentsonpasscommunitysummit2002.asp

Regards,

Andy Jones

Hi, see the following thread.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=9753&FORUM_ID=5&CAT_ID=1&Topic_Title=Stored%20procedure%20changed%20date&Forum_Title=Administration

Regards,

Andy Jones

Hi, see the article: -

http://vyaskn.tripod.com/moving_sql_server.htm

Regards,

Andy Jones