homework question:

Auto commit has been turned off.

1- William logs into the database

2- Julianna logs into the database

3- William sees 12 rows in the TOYS table

4-...

you posted the same question in a SQL 2000 forum here:

http://www.sqlservercentral.com/Forums/Topic1080006-5-1.aspx

in that thread I had posted a link to aaron bartrands blog on how to read the DMV's to find...

your ttableB.Earlylate has more than one value...you might want the MAX date or the MIN date, depending on your logic, instead

update tableA

SET TableA.validateTime = (select MAX(tableB.Earlylate) from tableB

where tableA.ID =...

assumning if that field HF00340 is zero, you want to set that result to zero, else the calcualtion:

Update a

set HF56390 =

CASE

WHEN HF00340 = 0

THEN 0

...

yes SQL Express will run on Windows 7 no problem.

Express, by default, does not set itself up for remote connectionsso users can't access it from other machines immediately... so...

actually, MS provides a stored procedure that will give you all objects(procs, views, tables, etc) in dependency order:

try this in SSMS:

EXEC sp_msdependencies @intrans = 1

if...

vishnubhotla.uday your solution is changing the collation of the master database, and then the default collations of each of the databases...that's only 5% of the solution,and typically you need to...

i think you are abstracting stuff out, and leaving out critical details.

show us the EXACT command you ran. it really sounds like you say you did one thing, but actually...

'LinkedServerName' was the example...you never mentioned the name you gave that server, so all i could post was examples i thought would be intuitive enough that you knew you'd need...

that's the difference between a JOIN(INNER JOIN) and a LEFT OUTER JOIN

inner joins only show matches, where OUTER JOINS (LEFT and RIGHT) can show you where something doesn't match, if...

In addition to what Sean said, a lot of out-of-the-box portal software, like Dot Net Nuke and Sharepoint store the html in fields in the database, for dynamic content; codebase...

you can set up the linked server so if a specific local user tries to use the linked server, it uses a different set of remote credentials instead:

the way you...

diagnose the linked server before using it in your code;

if you run EXEC sp_tables_ex 'LinkedServerName' do you get any results? in theory, it will return all available tables fo rthe...

another pair of eyes can certainly help; can you post the execution plans from each server so we can see them too?

so many talented folks here, one person might see...

your on the right track; a case statement can help you filter your resulting value;

it might not be obvious, but a CASE statement can have more than one test ,...