To clarify:

I do recommend that people get certified, but not because that it will not guarantee a job (it won't). But because in the process of studying for the cert...

bcp is a command line import/export tool. There are a multitude of command line options and switches. Books Online has a full list of all and some examples on usage.

Basically...

I have different ways I feel about certifications in different circumstances.

When I'm interviewing, I assume that the fact that a person has a certification means that he/she knows that area....

Doctor Who 2 (7/4/2008)

---

I've got a couple of SQL Server 2005 databases on a 32-bit OS, which I want to move to a 64-bit OS. Can I just copy...

That's a little extreme as a fix for missing counters.

If you query the dmv sys.dm_exec_connections, you will see the ip address.

I don't know of any way to lock someone out by IP. If they are using a specific...

Do you perhaps have a backup from before the attack hit? Restoring is probably the fastest way to clean up. Bear in mind, the attack may have done more than...

That would work in 2005. In SQL 2000, try rowcount.

SET ROWCOUNT @NumRows

SELECT *

FROM Northwind.dbo.Customers

ORDER BY NEWID();

SET ROWCOUNT 0

Please note, I don't have a 2000 server handy to test this. I...

Can you maybe post the code of the trigger?

Congrats! What was your score?

So, which exam's next on your list? :hehe:

It should do. It is recommended that the statistics of all tables (in all databases) get updated after upgrading from 2000 to 2005.

The reason is that 2005 keeps more detailed...

Do NOT use testking. They are a braindump site. Their stuff is...

This should get you started

SELECT execution_count, total_worker_time, total_physical_reads, total_logical_reads, total_elapsed_time, creation_time, st.text,

qs.sql_handle, qs.plan_handle, qp.query_plan

FROM sys.dm_exec_query_stats qs INNER JOIN sys.dm_exec_cached_plans cp ON qs.plan_handle = cp.plan_handle

CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st

You could disable the trigger, run the delete and reenable it. There's the risk that another delete runs while the trigger is disabled.

Is there anything about the session/connection properties that...

You said you wanted to change the dates to something like '1900/01/01'?

If...