You should increase the column lengths in your

"(CODE nVARCHAR(20),CIPHER nVARCHAR(20))"

to more

e.g.:

(CODE nVARCHAR(1000),CIPHER nVARCHAR(1000))

so that it can hold the concatenated results,

Regards,

Andras

Of course I would not like to stop you deleting the transaction log, but I hope you know that the transaction log is a rather critical file(s) for a database....

Here is a version that shows the information you need, you just need to dump the output to your audit table:

CREATE TRIGGER auditTrigger_my_table ON my_table
    AFTER INSERT
AS
...

SELECT DISTINCT
        t1.ID
      , STUFF(( SELECT DISTINCT TOP 100 PERCENT
        ...

Hi Inesh,

Pivot can do what you want to achieve. Since you do not know what columns you need to specify for the pivot operator, you need to construct the query...

Hi Steve,

have you looked at the UNPIVOT operator?

Regards,

Andras

SQL Server is using the OS for this. But it is highly optimized. It uses both scatter-gather (NT: ReadFileScatter and WriteFileGather) and asynchronous calls.

Regards,

Andras

I'd hope such changes would come to the SQL Standard first . Including the above syntactic sugar in TSQL would probably confuse more than...

What recovery mode is your database in (full, simple, bulk)

select recovery_model_desc from sys.databases where database_id=db_id()

If it is in full, you will need to back up the log, then truncate it.

If...

SELECT DISTINCT
        t1.GroupID
      , STUFF(( SELECT DISTINCT TOP 100 PERCENT
        ...

Yes you can. The column definition accepts identity(seed, increment) specification, but you cannot alter a column to become an identity column, or drop this property while keeping the column. You...

In case you do not have a primary key, or any way to identify the row, and have duplicates, you can do something horribly ugly with set rowcount. An example...

A simple example:

SELECT  sts.name
      , st.name
      , si.name
      , ssc.name
    ...

Unfortunately sp_helpindex does not contain this information. You have to dig this out from the system views. The ones you will need are sys.indexes and sys.index_columns. The later has a...

There are different types of principals in SQL Server. There are server and database principals. (as in sys.database_principals and sys.server_principals)

database users are part of the database_principal level.

Regards,

Andras