Ray synonyms are Per Object, with an object being a Table, typically;

so you need a synonym for each object coming from the linked server.

so you create say , 4 synonyms...

KermitTheRock (3/23/2011)

---

Yeah, I know it sounds crazy that I want to "avoid" optimization. But if the data and tables and query have not changed from one day to the next,...

ok see if this is even close to what you are looking for;

i'm assuming you need to generate the delete statements because you know a certain key must be deleted...

you can build your tree based on the foreign keys, but the decision on what to do with rows of data containing FK references is still a business decision. Once...

Tara the other person could be mapped to a remote user that has full access, and everyone else's connection made with no context; that way, everyone EXCEPT the people i've...

ok answering my own question, I definitely do not want the serverproperty;

what i foudn that since one of the first things SQL does on startup is create a new tempdb,...

ok I'm poking around trying to find what might be the most accurate server start time; I'm not sure the first date i find in the DMV's would be perfect..i'd...

Based on that blog by Aaron, I put the script below together.

My only issue is whether i'm using the right date for when the server was restarted...i was just assuming...

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...