you can use the ALTER LOGIN command, i believe.

--name change due to marriage

ALTER LOGIN [DOMAIN_NAME\gallan] WITH NAME = [DOMAIN_NAME\gshepherd];

--domain name change?

ALTER LOGIN [DOMAIN_NAME\lowell] WITH NAME = [NEW_DOMAIN\lowell];

Ben have you ruled out parameter sniffing?

if your procedures have default values for some of the parameters, no matter whether you updated statistics or not, parameter sniffing could occur,...

Lowell (3/8/2010)

---

halifaxdal (3/8/2010)

---

thanks. it won't work.

The records are all associated with a UserID, all non 0 value.

When the input parameter is 0, all records should be pulled out.

When the input...

halifaxdal (3/8/2010)

---

thanks. it won't work.

The records are all associated with a UserID, all non 0 value.

When the input parameter is 0, all records should be pulled out.

When the input parameter...

yeah, to get you an intelligent example, instead of a crappy peudocode example, we'd need...

since you posted this in SQL Compact Edition, I'm guessing you are asking how to connect to a compact database?

http://www.connectionstrings.com/sql-server-2005-ce

Data...

there's a lot of factors in optimization; you'd really want to attach the execution plan here to get any really significant answers.

are all your joins on PK to FK relationsships?...

Rajesh this is a common security issue. The problem is that when you access any resource OUTSIDE ofSQL server, like network shares, local hard drives,sp_OA type functions etc, it...

Jeff i think you want to join the archiv table to the SELECt so you can exclude records already transferred;

i don't know the PK of the tables, but this should...

how up to date does the data need to be between servers? does it really need to be up-to-the-second as a linked server?

if it can be a day or so...

in my experience, deleting all rows in all tables is not the right thing to do; i'm sure there are many tables that are "lookup' tables used to populate drop...

jayanth linked servers can be notoriously slow, and there's a couple of reasons.

if you are joining two tables, i.e.

SELECT *

FROM Server1.Db.dbo.Customers X

INNER...

masterpeice the part you are missing is how to test (along witht he DENY statement already identified.

here's a working example: note the EXECUTE AS and then the REVERT when i'm...

if you can't infer the missing item due to the sum(0 of the dollar amounts not matching, is there some other logic to help infer something is missing?

for example, if...

would something like this help?

if i know you are going to take 12/21/2010 off thru 12/25/2010 for the holidays, you want to generate teh 5 days of records?

--results:

myuserID ...