Gerard,

What platform is your experience with?

BY default SQL Server does pessimistic locking. So, within a transaction it will lock what it needs to lock to maintain consistency. So...

Did you install SQL Server 2008 with the same collation as the 2005 server?

Have you verified that source definition hasn't changed to allow more characters and thus the conversion is...

I don't know of a way to keep anyone from being able to see that the linked server exists but you can use the local login to remote login mappings...

pwalter83 (7/17/2012)

---

SQLRNNR (7/10/2012)

---

You can have 1 connection manager and have a variable to overwrite the server expression for that connection manager. But only 1 at a time.

A better description...

Sure that's a possibility. Depending on indexing summing the totals for a customer might be acceptable and might be a lesser load on the server than adding a step...

gerard-593414 (7/17/2012)

---

The AccountNum field will identify the account. This will have come from an Customer master table and the table I am updating is a Balances Table (Just to hold...

From my perspective a once a day process says SSIS. Are the imports the same for each site? If they are then it is on package that has...

Do you want to return the column name of the column(s) that contain the value or do you want to return the each row that has a column that contains...

You could do something like this:

SELECT

*

FROM

sys.dm_exec_cached_plans AS DECP

CROSS APPLY sys.dm_exec_sql_text(DECP.plan_handle) AS DEST

YOu don't want to do select *...

Yes you need to know or learn some .NET to script in SSIS. You should avoid the ActiveX Script Task because it is basically added to support migration from...

I don't think that there is a way to do that. I normally try to avoid subreports if I can. I'll often bring back all the data in...

First couple of results from this search seem to be a good place to start for backups anyway.

chewychewy (7/16/2012)

---

Hi Guys,

Am new to profiler.

For example, I have this set up: (client side tracing)

Host A: SQL Server 2005 Production Database

Host B: Profiler GUI started and running to capture required...

But how do you know that it is really the same account? How is the customer number created?

I think what you really want is MERGE. IN a nutshell...

Based on the business rules you have provided, having a duplicate customer number IS an error and a unique constraint or a primary key are the only ways to guarantee...