Change CONVERT(VARCHAR(20)... to CONVERT(VARCHAR(25)... Some of the converted date is getting cut off.

Hmm. If you look at the printed out dynamic string, what does that last part (with the dates) look like?

Regardng attaching excel, it depends how you're doing the mailing what...

Might be possible, but you would have to express it as a logical expression

(Col1 between 0 and 5 and Col2 between 0 and 5 and Col3 between ...)

Rather don't use...

DBCC ShrinkDatabase or DBCC ShrinkFile

You can find all the details for both in Books online.

Be aware that a DB does need some empty space to function properly, so maybe shrink...

Does this help? I can't test it, since you haven't given the table schemas or any sample data.

Select Usr_ID

from User_roles

inner join ACCESS_RIGHTS ON

((Access_Rights.MEMBERSHIP_OBJECT_ID = User_Roles.Rol_ID AND MEMBERSHIP_OBJECT_TYPE =...

Try a planguide for adhoc code

@type = 'SQL', @module_or_batch = NULL

sp_executesql's just executing a string passed to it. The @type=object is for a query that's within a stored procedure.

Sure.

CREATE TABLE TestingDates (

ID INT IDENTITY PRIMARY KEY,

Starts DATETIME,

Ends DATETIME

)

ALTER TABLE TestingDates ADD CONSTRAINT ck_DateCheck CHECK (Starts <= Ends)

INSERT INTO TestingDates (Starts, Ends)

VALUES (GETDATE(), GETDATE()+1) -- succeeds

INSERT INTO TestingDates...

In sysobjects, the uid column will be different. You can join to sysusers to get the name of the table owner

I wouldn't think so. As far as index selectivity's concerned, 1 million nulls or 1 million 0s selects much the same.

I'm not sure about nulls, but I think that a...

Restore your transaction log backups, starting with the one you took right after the full backup on the 25th. Restore them in order, with the NoRecovery option and with the...

A full database backup contains the contents of the DB at the point in time...

What time did the full backup start and finish?

What time did the log backup run?

What time are you trying to stop at?

Steve Jones - Editor (4/7/2008)

---

Most people don't participate 🙁

Of the 10k-20k people, and 45-50k pages, we get about 300-500 responses quite often to polls and surveys. Probably should add them...

If you're running SQL 2005 (as I assume you are, based on the forum this is posted in), could you please save the exec plan as a .sqlplan file, zip...

Different owners?

Someone messing with Allow Updates?