TCP Port 1434 is typically used by the Dedicated Administrator Connection.

UDP Port 1434 is typically used by the SQL Browser Service.

The fact that the two servers are in different domains is only relevant if you want to use NT Authentication to fire off usp_B using a Linked Server.

If you have...

TrimEnd accepts a char array, not a string. This is a more explicit way to write the code:

[char[]]$charArray = @('_','D','a','t','a','.','m','d','f')

"ccra_Data.mdf".TrimEnd($charArray) #1

"ccrb_Data.mdf".TrimEnd($charArray) #2

"Project_Data.mdf".TrimEnd($charArray) #3

"Projecs_Data.mdf".TrimEnd($charArray) #4

Notice the letters I bolded above are...

Uripedes Pants (5/25/2012)

---

Hey my friend opc.three!

Just before you replied the lightbulb over my head fired off. I noticed in the output from the package the FEL throws a...

Msg 154, Level 15, State 1, Procedure TestProc, Line 4

a USE database statement is not allowed in a procedure, function or...

DO you have any non-default settings setup on the OLE DB Destination, e.g. "Ignore Failure" in the "Error Output" page?

Please read the section titled "Writing to the Windows Security Log"

Microsoft White Paper > Auditing in SQL Server 2008

thunderousity (5/25/2012)

---

Edition: Standard Edition

Product Version: 9.00.4309.00

Product Level: SP3

Physical Memory_MB: 8184

min server memory (GB): 2.00

max server memory (GB) 4.00

VAS_GB: 2.00

awe enabled: 0

Looks like I am at a sufficient version SQL Server...

N.D (5/25/2012)

---

Thanks both,

To clarify, it's the non-custom messages I'm trying to get to write to the log, eg - a 9002 log full event without having to force the log...

Abrar Ahmad_ (5/24/2012)

---

[font="Verdana"]

We dump data in history tables via triggers etc logic in...

Just to add to what Steve said, you can see which system errors are automatically logged:

SELECT *

FROM sys.messages

WHERE is_event_logged = 1

...

Hi again Kevin 🙂

Since you are mapping a variable in your FEL you can use an expression in a precedence constraint to check if the variable was set to something...

I see. In that case I think the solution will require dynamic sql. Here is a start to help you get your column names. From here you can build a...

The 0x is how SSMS displays a binary column. It shows it as a hex-value for benefit of us humans. Internally it is only 0's and 1's.

Hmmm, can you store hexadecimal or base64 data in a binary column, hmmm :Whistling:

Did it help to re-read that?