Do you have any columns of this type??

text, ntext, varchar(max), varbinary(max).

Do you have other indexes besides those 2?

Why is having that table at 50MB a problem (other than being odd).

Maybe a weird coordination bug between the list of databases and the permissions of the users looking at that list.

Of course paint seems more likely here.

I'm not a big fan of the RIGHT(output, 38), That script will break if the filename ever changes.

I know it's more complex but I preffer to figuring out the...

GilaMonster (11/23/2010)

---

Brandie Tarvin (11/23/2010)

---

Only ever use Dynamic SQL when you absolutely have to because dynamic SQL can't cache any execution plans for re-use later, which is a performance hit (I...

Yup, good old dos. Still works better than windows in some area!!

here's a start

IF OBJECT_ID('tempdb..#Out') > 0

DROP TABLE #Out

CREATE TABLE #Out (output VARCHAR(MAX))

INSERT INTO #Out (output)

--exec xp_cmdshell 'dir \\whatever\backup'

exec xp_cmdshell 'dir z:'

--you may test if adding a leading space after the...

You're on the right track... 10% fragmentation minimum, reorg @ 29% or less rebuild at 30% and make sure to have at least 1000 pages in there.

Not much else for...

page_count.

If you have the time to learn then go for it... make sure you test on a test machine rather than prod server.

Any errors there can cause serious issues.

You're not filtering on the page count. Fragmentation is not really an issue untill you hit at least 1000 pages in the index.

So if you defrag or reorg a...

pavan_srirangam (11/12/2010)

---

There will be no issues till you run in older compatibility mode

ex: Running in higher version box with no change of compatibility mode

like 2008 box but db...

I'm guessing you are supporting 3rd pary apps which you can't access or modify the logging systems therein?

no you don't

With 90% certainty, no you cannot be garanteed that it'll work without retesting the whole thing (or getting approval letters from the vendors).

Another question here... why not go to sql...

I don't have any machine to test this out but it's quite easy to test.

Build a new empty db and put 1 mb in the log and 1 mb increment.

Add...

Make sure you can ping it from the "linking from" server. It's most likely a switch or firewall problem.

I've also foun one that using the ip adress was working...