One aspect I forgot to include was when someone uses MS Office to connect to your databases. I'm thinking of MS Excel and the pivot report/charts. I haven't...

Not if you're British it shouldn't.

Sorin Petcu (1/15/2008)

---

The line:

INSERT INTO @InputBuffer(EventType,Parameters,EventInfo) EXEC (@SQL)

gave me an error:

Server: Msg 197, Level 15, State 1, Line 65

EXECUTE cannot be used as a source when inserting into a...

If the length of your ntext field is under 4000 characters then cast it to a VARCHAR and use the REPLACE statement.

This is a mamoth task. I would omit SQL6.5 from the presentation. In about 4 years time there will be DBAs working who were not born when SQL6.5...

Have you got a server somewhere where you can do a test restore of your backup. I know restoring system databases is a pain but for peace of mind...

See if this helps

http://www.sqlservercentral.com/articles/Administering/utilityprocedures/2272/

ISO8859 seems to refer to Latin character sets.

Can you give a specific example of what is going wrong?

I use XML EXPLICIT when I need a specifc layout but only when...

I deployment and rollback scripts for everything as a matter of course that way I know I have a way of installing and uninstalling software in a hurry if need...

I would create a table that holds a flag.

Have your trigger set the flag

Set up a schedule job that runs every minute or so with a task that says

IF EXISTS(SELECT...

SELECT *

FROM tblEmp

WHERE empjob=1

AND emprole <>'clerk'

Sad:

Just found out why it was so important to back up the database master key.

Forgot to put a WHERE clause on a DELETE/UPDATE.

Selfish:

Implements something in LIVE 5 minutes before leaving...

Do you have the option to move use another server as your distributor?

I'm thinking that if your production server fills due to growth in your distribution database then this will...

I'm not sure about that Jeff.

I have come across situations where the firehose cursor is faster than the loop.

I pinned it down to the loop running many separate queries where...

SELECT P.*

FROM PurchaseOrders AS P

INNER JOIN (

SELECT PurchaseOrderNumber, Max(Posuf) AS LastPosuf

FROM PurchaseOrders

GROUP BY PurchaseOrderNumber

) AS PM

ON P.PurchaseOrdernumber = PM.PurchaseOrdernumber

AND P.Posuf = PM.LastPosuf