John Mitchell-245523 (7/3/2012)

---

I don't know whether anything like this applies in your case, but I've had trouble with synonyms before. It happened when I restored a second copy of...

GilaMonster (5/6/2011)

---

The max memory setting only controls the max size of the buffer pool, the paged memory allocation.

SQL also used non-paged memory for things like thread stacks, backup buffers,...

Ok, well, it seems that no one here has ever seen this before! Surprising really...

I gathered some stats, and it seems that on our 16 processor box, all the values...

Im aware of how the procedure works. I do read the BOL too before posting here.

So how can the CPU busy seconds be more than the elapsed time? If its...

No ones ever heard anything about this issue?

Answers C and D appear to be identical...

Disable CHECK constraint at the Subscriber database

But I did just notice that under the Subclass value, we get the references that im after.

That should be ok!

Thanks for that!

Kinda, but theres no entries for anything like say:

Event_trace_id = 8278

This corresponds to a View

or Event_trace_id = 22601

Should be an Index.

So as far as I can still tell- that table...

Bleh! Heres me thinking 'well- you can move the resourceDB in 2005, so you can probably move it in 2008'

Heh. Wrong!

Good to know though!

What was the question?

Its gone away- I think hes edited it away or something...

Im just curious...

An example of the sort of code that I would like:

exec [Database].sys.sp_addlogreader_agent

@job_login = 'Replication_Service_Account'

,@job_password = DECRYPT('Encrypted Password...

Thanks for that, but that only returns Data Types. I want object types...

Well, that looks like it may have solved the problem! FTData was missing.

Adding the FTData folder back looks to have worked, the patch installed sucessfully.

We have a customised directory structure...

Attached:

SQL9_Hotfix_KB955706_sqlrun_sql.msp.log,

Summary.txt

HotFix.Log

select count(TABLE_NAME)

from INFORMATION_SCHEMA.Tables

Will return all tables and views.

To just return count of tables (no views), use:

select count(TABLE_NAME)

from INFORMATION_SCHEMA.Tables

where Table_Type = 'Base Table'