That can be difficult if you are QA'ing schema changes as most tools that I know of won't sync data if you change the schema. You can look at...

The answer depends on how you want the data formatted. Here is one way:

Select

A.id,

A.id_name,

...

That is pretty funny.

sys.traces has more information and I find it to be in a more usable format than fn_trace_getinfo.

Adam,

Nice article. According to BOL you should use sys.traces instead of fn_trace_getinfo. Here is the BOL quote:

The sys.traces catalog view contains the current running traces on the system....

It's not dbo.cust.Customers. You only have dbo.Customers. cust is an alias that you would use in place of the table name (dbo.Customers).

Is your dev or production database suspect?

You would need to create a Subscription. Lookup Subscriptions in BOL.

Angelindiego (11/10/2008)

---

Fair enough....I would like to re-write it, but I am not sure what '=*" means??

It is in this context in my query:

select

something s

from

...

Similar to what Seth has already said and based on your existing procedure:

[font="Courier New"]ALTER PROCEDURE [dbo].[BILLTO_Customers]  

AS

SET NOCOUNT ON

-- updates existing customers

UPDATE dbo.Customers

     SET Name = A.Customer_Name,

         ShortName = A.Known_As,

        ...

I believe this is the code you want:

[font="Courier New"]SELECT  

      m.vid,

      m.mwhid,

      m.begin_time,

      m.end_time,

      DATEDIFF(minute, m.begin_time, m.end_time) AS [duration],

      m.miletenths / 10.0 AS [miles],

      m.mwh_type,

      CASE m.mwh_type

           WHEN 0 THEN 'unassigned'

           WHEN 1 THEN 'driving'

           ELSE 'unknown'

      END AS [typedesc],

      m.trucknum,

      md.logged_in...

Check out this article: http://www.builderau.com.au/program/sqlserver/soa/Reviewing-SQL-Server-Permissions/0,339028455,339293054,00.htm. I think it has the T-SQL you need.

Check security on the table and remove any users that may have those rights that don't absolutely need those rights.

Also you can use Profiler to trace or create a Server-side...

Yes, within reason. It does not demonstrate how to start the trace when SQL Server starts.

SQL Server 2005 has a basic trace that is created when you install SQL Server and starts on start-up. You could remove this trace if you wanted to, but...

• This reply was modified 6 years, 11 months ago by Jack Corbett.
• This reply was modified 6 years, 6 months ago by Dave Convery.

You can simply set up a data flow task for each table with an excel source and a sql server destination.

To get the ParentCategory from the Category worksheet, if you...