grant CREATE procedure TO

GO

grant CREATE FUNCTION TO

GO

Thanks for your kind response but there are 35 tables and all these tables have to be created in 150+ DBs. I already generated the script from the QA environment...

Any help on this?

anthony.green (10/2/2015)

---

Something like this

CREATE TABLE #Temp (ParentObject VARCHAR(100), Object VARCHAR(100), Field VARCHAR(100), Value VARCHAR(100))

INSERT INTO #Temp

EXECUTE ('DBCC DBINFO (''YourDBNameHere'') WITH TABLERESULTS')

select

distinct

'Last Known Good DBCC CHECKDB',

Value,

datediff(day,convert(datetime,value),getdate()) AS...

Sorry for the confusion. I got it.

Thanks!

So I am guessing it is not possible to track what data/value is getting inserted.

Eirikur Eiriksson (5/18/2015)You can tap into the activities with a trigger, extended events or even a trace, but that might in the end give you even a bigger head ache....

CKX (5/12/2015)

---

You might want to try updating the statistics on that table prior to running that query.

I say this because there is quite a difference between the estimated and actual...

Lynn Pettis (5/11/2015)

---

New Born DBA (5/11/2015)

---

Lynn Pettis (5/11/2015)So the following (hopefully I mapped everything correctly using the VIEW definition) didn't help:

CREATE NONCLUSTERED INDEX [Test] ON [dbo].[T387]

(

[C6] ASC

)

INCLUDE

(

...

Lynn Pettis (5/11/2015)So the following (hopefully I mapped everything correctly using the VIEW definition) didn't help:

CREATE NONCLUSTERED INDEX [Test] ON [dbo].[T387]

(

[C6] ASC

)

INCLUDE

(

C1,

...

ALTER TABLE [dbo].[T387] ADD PRIMARY KEY CLUSTERED

(

[C6] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY...

CKX (5/11/2015)

I think you may find this particular response from Lynn probably explains what is going on here.

You can experiment by "including" the other columns in your index and see...

My Manager and people who have developed this application.

Putting a clustered...

J Livingston SQL (5/8/2015)

---

New Born DBA (5/6/2015)

---

I have this query which runs every night pulls 800,000+ records. I just wanted to know if there is a way to make it...

Long story short is that the clustered index on C1 column cannot be dropped. I was going to suggest maybe using C1 column in where clause, but I don't think...