Hi,

I forgot the R2... I meant going to 2008R2 or 21012 from 2005.

Thanks

Thanks for your help.

Is there a way to get the user, server name, application name of the one who makes the change?

Thanks

I have 2 fields in a tables that are updated. I want to find which application/user/DDL is doing it.

How I can set a trigger to get these information?

When I remove the primary key on my destination table, the execution time is decent. I need to have this for performance issue. This is my fact table...

Thanks SteveB,

I am already using fast load on the destination, a select statement at the source (without grouping and sorting)

I found this strange that data flow is much slower than...

What are the steps to rollback if needed?

Thanks.

If I add a data file on my primary group, is there a was to move objects form the current one to the new one? If I want to...

For an unknown reason the user was granted Admin on the local server :w00t:

Thanks

Installing SP4 (RTM) on Microsoft SQL Server 2005 - 9.00.3282.00 (X64) the weekend in production

Any last minutes information needed?

I am trying to find the steps to rollback form SP4 to SP3 if needed. Is there a way to do that or we need to uninstall SQL2005 and...

is RTM version good to use?

Sorry for spamming the forum. I found the previous post I did.

http://www.sqlservercentral.com/Forums/Topic1020797-149-1.aspx

I am moving my question there...

Oh I see.

I am still have the problem once a while. Anyone has hint of how to fix this?

My process is running every business day. We had the...

What was the solution here?

Can someone help here? I got the same issue again. The first time since a few months.