are you looking to update based on any type of criteria as well?

if so, throw a WHERE a.key = "something" clause, otherwise, the update statement look good

SQL Book Online is a good free source. The other one I have lying around is from...

applebutton (1/27/2011)

---

I need to update a column in table A, A.key, based on Table B, column B.Key, with value from table C, column C.key.

eg.

update

set A.key = C.key

where A.key in (select...

In Active Directory, your admin has to right click on the user account and enable 'Account is Trusted for Delegation'

Hi OP,

in my environment, we got it setup like you are talking about. What I did was make a variable and store the entire backup statement into the...

where col1 is null

and col2 = ""

you can use a unique index to prevent dupes from being entered into your table. avoid triggers since this will cause a performance hit if you have a lot...

are you talking about DDL & DML changes to the sql data or change to the actual server, such as a new user has been added, timeout connections setting has...

i don't know how you would do it in SQL but here's how you can do it in Powershell

$filexml = gc 'C:\Users\a\sc.xml'

[xml]$file = $filexml

$newData = 'xs:string(sql:variable("@dTxtPubdate")'

$file.SelectSingleNode("resRefDate/refDate")."#text" = $newData

$file.Save("C:\Users\a\sc.xml")

Also you have...

that's what I was going to say. can't tell what the query is doing exactly w/o it. you can also fire sql...

The only way to backup the entire server would be to ghost it. The windows backup tool will backup folders and system information, which you can use to restore...

try using the ObservableCollection, check to see if there has been any change in your table, if not; don't call the method.

if not, maybe use some sort of event to...

it was suppose to point to a post i made an app i created that would ease db backup but it looked like it violated some TOA/TOS/rule and the mod...

anyone know how to change sql 2005 server service password on an active/active cluster via script?

I hate having to click my way thru changing passwords for 50+ servers.

thx

hrmm ... don't know if that function and default trace captures anything about linked server. I just added a linked server and then queried that all the trace files...