jpSQLDude (5/16/2011)

---

I'm pretty sure the...

I just ran the script for the fun of it... so many undocumented options it makes your head spin!

/****** Object: Table [dbo].[dba_indexDefragLog] Script Date: 05/16/2011 11:09:41...

Reformated code...

DECLARE

@LoginG as uniqueidentifier = (

...

SQL New New (5/16/2011)

---

The DB is crazy. In orde to get the index to rebuild we are going to have to exclude about 10 and place them into another job....

simflex-897410 (5/16/2011)

---

Sure, I agree - that's for integer though.

What prevents 1234 from being inserted into the maintName fieldname?

That's what I am hoping the constraint is intended to do - prevent...

GilaMonster (5/16/2011)

---

Depends. It's not just the blocking, it's that SQL doesn't bother taking any locks at all. Gone is the time required to ask for locks, overhead of lock memory,...

Ninja's_RGR'us (5/16/2011)

---

Well it doesn't <completely> break it. that's why...

Ya, but if the db only has selects running on it, how...

Ah, I think I read this one too fast :w00t:.

The problem you were having is that you validated both at the same time. So if either was valid, the...

Well it doesn't <completely> break it. that's why I...

The backup only contains the pages with data on them. So that means you have quite a lot of free space in that db.

What's the advantage of setting the db or files to read_only?.. and which ones do you set ro?

SET IMPLICIT_TRANSACTIONS ON

GO

Create Table dbo.Maintenance

(

maintName varchar(225) NOT NULL,

maintid int NOT NULL,

CONSTRAINT Only_Characters

CHECK (maintid NOT LIKE '%[^A-Z ]%'),

CONSTRAINT Only_Numbers

CHECK (maintName NOT LIKE '%[^0-9 ]%')

)

GO

INSERT into Maintenance (maintid, maintName) VALUES('1',...

I had the same problems here. Here's the script that solved it.

Now I agree with Gail that this should be a 1 off execution because you had a strange...

I think he needs to find all the varchar variables and change them to nvarchar.

In that I'd do a search in the proc's definition for varchar. You could also...