Argument #1: "During a DBCC CHECKDB, REPAIR_ALLOW_DATA_LOSS operation" This operation adds no records to the table, so how can this statement be true with regards to "the suspect_pages table...

Save the package from the Import/Export Wizard, and see how it compares to the one you created. Maybe some critical settings like rows/buffer are different.

There is a difference between...

Start by adding a table or group of tables to a new diagram. Select all tables and run "Add related tables". Repeat until no more tables are added....

The lookup task will not run synchronously with the following insert task. An entire buffer (or multiple buffers) will be processed by the lookup task before info is passed...

Using an error message ID in RAISERROR requires adding the error message text to sys.messages.

You can use custom message text in RAISERROR, but the error number will be...

Query the backup history tables to find the physical file names of all the .trn files backed up from the source database. Add a "WHERE filename NOT IN" clause...

You can get the trace file names in use from fn_trace_getinfo, assuming you know the traceid.

SELECT value

FROM fn_trace_getinfo( @traceid )

WHERE property = 2

Or if the traceid is uncertain but...

I created this function for use in CATCH blocks.

CREATE PROC dbo.RethrowError AS

DECLARE

@ErrorMessage NVARCHAR(4000),

@ErrorNumber INT,

@ErrorSeverity INT,

@ErrorState ...

Declaring large field sizes can affect memory usage in Integration Services. When it sets up row buffers it has to allocate space for the largest possible row, so you...

My guess would be you want to monitor the active node specifically.

You only need one Excel connection manager, but you probably need three different data flows to get the data from the three worksheets. If the worksheet layouts are the...

I agree that Total Server Memory > Total Target Server Memory indicates memory pressure, but what I've read is that if they are equal there is probably no memory pressure.

You...

CREATE TABLE dbo.TestTable (

IDINT NOT NULL)

GO

INSERT INTO dbo.TestTable VALUES (1)

-- Use the OUTPUT clause to return the new value in a resultset

UPDATE dbo.TestTable SET ID = ID + 1

OUTPUT INSERTED.ID

GO

--...

CHAR(222) will be interpreted differently depending on the code page. If you are using code page 1252 (US English), it is Þ. It would only be an ASCII...

Sign_in and Sign_out don't have to be on the same day, but the time span has to be less than 24 hours for the expression I used. Your latest...