because SERVERPROPERTY() is a function, even if you had " FROM RemoteServer.master.dbo.sysobjects" as the from clause, the function will return the info from the machine you are connected to...not the...

the old chicken and the egg; which do you need first?

you need to connect before you can run a query to try and find the IP,

....but you need the...

among the same versions (ie 8.* to any other v8 or 9.* to any other v9) all backups are compatible with the same version..

so if i backup with SQL2005...

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

http://www.sqlservercentral.com/Forums/Topic687890-357-1.aspx

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

http://www.sqlservercentral.com/Forums/Topic687890-357-1.aspx

i'm still reading your code, but it looks like it is doing nothing more than getting a bunch of links for navigation recursively right?

i'd like to see the code of...

both != and <> are "not equal" and are valid operators for SQL server...i used != because the web site sometimes interprets that as html and makes it disappear.

did you accidentally run the script on the master database instead of a specific database? or a different database than the one you needed to?

to do it the hardway, you have to check @@error after each update/insert: each command changes the @@error:

ALTER procedure MyProc

As

BEGIN

begin transaction

update1

if @@error != 0 GOTO Bailout

update2

if @@error != 0...

it depends on the scope;

outside of a stored procedure, if you issue that command, it is for the life of the session/window or until you set XACT_ABORT to OFF;

if you...

it really depends...the devil is in the details.

why are you breaking up related data into two separate servers? This looks like a red flag to me; are you archiving the...

use a transaction like his:

SET XACT_ABORT ON --any error, rollback any trnasactions

BEGIN TRAN

--do first update

--second update

....

--last update

COMMIT TRAN --if there was any error, everything rollsback, no error checking needed

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread...

syntax wise, your query is fine; you didn't say what the issue is you need help explaining.

can you tell us what is wrong? does the query fail? do you need...

In order to "Use" a server, a connection has to already be established...SSMS does not have any commands that you can use in TSQL to change or modify your connection...so...