Nice script

The following is missing AND is_read_only = 0 in select

INSERT INTO @LoopExecuteScripts

SELECT 'ALTER AUTHORIZATION ON DATABASE::' + name + ' TO sa'

FROM sys.databases

WHERE owner_sid <> 0x01

AND state_desc =...

Issue was surpassed after I changed the...

Correct!

Thank you

IgorMi

GilaMonster (8/23/2013)

---

That's a client error, not server. It's a .Net memory error (sql server is not written in .net)

You're running Management Studio, on your client machine out of memory. Nothing...

...and additional

The insert operations execute under an explicit transaction.

I wanted to try to create a snapshot of the database and was not able because of the

SQL Server version:

Microsoft SQL...

Erland Sommarskog (8/19/2013)

---

No, it may be OK. In this case, the jfgrocha removed 200...

It is not good to shrink without rebuild.

If you shrink and rebuild after...

Hi

Can you check whether you have open transactions?

SELECT * FROM sys.sysprocesses sp WHERE sp.open_tran = 1 and sp.dbid = DB_ID()

or

DBCC OPENTRAN

Regards

IgorMi

The temp objects are not deleted. They are just truncated and then reused for other purposes, hence you cannot know which temp object from which user object is created/used. The...

Dird (8/1/2013)

---

Hi Igor,

No. The issue is "''''''''''''''''"...so many! because for every ' I have to do '' to escape it. Is there another way to escape in TSQL? So I...

I think i get your issue. What about this:

set quoted_identifier off

declare @query nvarchar(1000)

declare @server nvarchar(100)

set @query =...

I mean if you can put your code with many apostrophes in another script/sp and use it from another place...

SQLRNNR (8/1/2013)

---

IgorMi (8/1/2013)

---

Hi,

The widely used thresholds are: Reorganize if fragmentation is between 10-30%. Rebuild if > 30%.

Indexes with small number of pages (<1000) will usually not loose fragmentation. Try...

Hi,

The widely used thresholds are: Reorganize if fragmentation is between 10-30%. Rebuild if > 30%.

Indexes with small number of pages (<1000) will usually not loose fragmentation. Try your own...

Hi,

How about the refdate dates? are they two months ago, or fresher?

Regards,

IgorMi