With this code you will get a list of all tables with a column name of "DeptNo".

select

sys.tables.name as TableName

, sys.columns.name as ColumnName

, sys.columns.column_id

from

sys.tables

inner join sys.columns

on sys.tables.object_id = sys.columns.object_id

where

sys.columns.name = 'DeptNo'

Using...

Look at the DMV's for index usage.

taken from https://www.sqlservercentral.com/blogs/brian_kelley/archive/2006/06/12/639.aspx

sys.dm_db_missing_index_details

sys.dm_db_missing_index_columns

sys.dm_index_usage_stats

The first two allow us to identify cases when we need an index but one isn't present. If we...

you can also use "Activity monitor" from SSMS

I don't really know what you are asking, but I will try to answer.

To see when a user connects and disconnects from a database and to see what the user...

Do you have more specific error messages? (see LOGs)

Can you manually execute the command when you copy the code from the job to a query window?

Has anything changed 5 days...

SQL 2000 is not compatible with SQL 2005. Connect to the SQL 2005 instance using the SQL 2005 tools.

Are you able to break down the batch into seperate commands? If you run each part seprately, you can see wich part of the batch is causing the failure.

This is...

This error is generated by the...

More info is needed. Can you post the batch code?

Maybe a trace can pinpoint the problem?

For my knowledge, there is no such event. When the service is (going) down or hangs it is obvious no scripts can be executed.

I think you should act on entries...

You can see in the execution plan that both options are executed alike.

But only use DISTINCT or GROUP BY when required, because they can cause real performance hits.

In my experience data is given without being obfuscated or not given at all. There is nothing in between. But I think it is something that the market will require...

Mike John (3/4/2009)

---

Alternative answer is :

2009-09-02 17:30:00.000 -- which is exactly what you will see if you are configured for a UK date format. ie the dateadds behave as...

I think it's answer B. Microseconds are...

Does your account has the required rights? And is the import transaction committed?