Can you see the registered server?

Hi,

Not 100% sure what your question is.  If you are asking what is archiving, then put it simply, it is moving data from a table/database to another table/database.

For example, you...

Well your in the right place!

Also, Steve's topic which heads off te Newbies section is a good read.

What error are you getting?  In my experience, we transfered a Julian Date and had a bit of VBScript on the transformation to convert that to a date field.

Sounds about right.  The dotted line sounds like you are sending an on completion, on success or on failure call.

a transformation will be displayed as a bold arrow pointing from...

If they are actually using TRUNCATE TABLE then it isn't logged or won't fire any triggers, so you can't capture it that way.

You do need to be in sysadmin, dbo, ...

Hey Ricka,

We used DTS to do a direct data migration (no explicit sql code) and we also used sql statements or vbscript to read/write from DB2.  Our issues with dates...

DTS definately.

In a previous job, we used DTS to move data between an AS/400 DB2 database and SQL Server.

We had a mix of straight copies from table to table as...

Agreed.  Its something like 20% of changes in the table before the procs against that table are marked that the statistics are out of date.  Unless the dev's will hit...

Always use stored procedures.  I really see absolutely no need to hardcode SQL code.

Cached execution plans.  If you execute a stored proc, it will be compiled and held in memory,...

Just a quick one.

Only pass in the parameters and build the query within the proc.  I have seen on more than one occsasion (unfortunately) someone building dynamic SQL code and...

No, he wasn't hired.

Although I felt strongly against his comments towards other candidates cv/resumes, I did look beyond that at the other plus/negative points I picked up on but I...

Good article!!

Some good tips to remember there, although in saying that, I only started this job on January and I have no intentions on leaving for a good while yet!

I...

Good article. Couldn't agree more with regards to the quality of service issue you posed regarding DBA's.

I've worked in IT as a DBA & Developer long...

Hi Matthew,

You can reference different SQL Server boxes from a stored procedure but you will need to have set up a Linked Server.  I don't know if this option is...