jwhisman (4/9/2012)

---

opc.three (4/9/2012)

---

This is a very small amount of info to go on....but I'll take a guess. It looks like your inner proc is not raising an exception whenever it...

Right...what I was thinking is the COMMIT in the outer proc would be called when @@TRANCOUNT was 0.

This is a very small amount of info to go on....but I'll take a guess. It looks like your inner proc is not raising an exception whenever it rolls back...

+1

@Half Bubble

SSMS Tools Pack can help.

SELECT LEN('SELECT w.ID,

w.[Rdc],

w.[Pby],

...

L' Eomot Inversé (4/9/2012)

---

Jeff Moden (4/8/2012)

---

I prefer they both be NOT NULL and, like Gail identified, will make both the same on INSERT. I also use a trigger to...

Using your sample code from earlier the bold string-literal is the 'query' argument:

SELECT *

FROM...

sqldba_newbie (4/9/2012)

---

opc.three (4/9/2012)

---

An alternative to using OPENQUERY is to use the EXECUTE...AT syntax to also force the query to execute on the remote server. OPENQUERY is a bit more flexible...

Computers are either joined to a domain or they are not. You can either check the computer, or check Active Directory to see if the computer is part of the...

An alternative to using OPENQUERY is to use the EXECUTE...AT syntax to also force the query to execute on the remote server. OPENQUERY is a bit more flexible in that...

sanj_love89 (4/7/2012)

---

LOG file

2012-04-07 10:40:29.41 Logon Error: 17806, Severity: 20, State: 2.

2012-04-07 10:40:29.41 Logon SSPI handshake failed with...

Keeping the same server name would cover you, but in my experience that is an option less so than it is an option.

Ideally I try to use something like Cisco's...

I am thinking of a data flow that goes like this:

1. OLE DB Source from ServerA.Database1 selects customerIDs where name/address is null

2. OLE DB Destination to ServerB.tempdb table with customerID

3....

You said you already knew about backing up and restoring msdb, however did you know you could restore msdb with a name other than msdb? This would allow you to...

Stairways[/url]

Also, see the "Stairways" link in the left nav of this site.