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?

It would help immensely if you were to provide the DDL for the destination table, and a representative sample of the data that would reside in that table using the...

SQL Server is unaware of the image format. You could store a Word doc or a PDF in a VARBINARY(MAX) column for all it cares. The bits are stored in...

:exclamation: Note: this is a year-old thread.

Koen Verbeeck (5/24/2012)

---

opc.three (5/24/2012)

---

The two Execute SQL Tasks you mention point to the same database, using the same connection, sounds good. What happens to that transaction if an exception occurs...

I'll second, third, and fourth that...education, education, education!

If that is a lost cause, I know it was in some shops where I have been, you might look into enabling...

It is a function, not a global variable. Try it like this:

return SCOPE_IDENTITY()

A no-cursor option:

DECLARE @sql NVARCHAR(MAX);

SET @sql = N'';

SELECT @sql = @sql + 'EXEC msdb.dbo.sp_send_dbmail

@recipients = ''' + REPLACE(email,'''','''''') + ''',

@subject...

This may help:

SELECT TOP 10

DB_NAME(x.dbid) AS db,

OBJECT_SCHEMA_NAME(x.objectid, x.dbid) AS schemaname,

...

By all means dig in and learn the internals but there is no sense in re-inventing the wheel. May I recommend a solution...

Koen Verbeeck (5/24/2012)

---

opc.three (5/23/2012)

---

MisLead (5/23/2012)

---

I have an execute task that truncates the table when the package runs. Downstream I have dataflow tasks that fetches fresh data and populates that data...

What bruce provided is exactly what I described. You can use the Split-Path cmdlet to get the directory names as you move thorugh the collection of data and log files....

Read the Remarks section here: DBCC UPDATEUSAGE

No, compat mode is not a concern for udpateUsage.

I see it uses statistics...