Here's a stored procedure I use. I removed the actual trace definition to keep it a bit smaller.

CREATE PROCEDURE PerfTrace

@duration int = 60 -- default run the trace for...

As far as I know CE can only function as a subscriber. I think you need to have at least workgroup edition to create publications. But I'm no expert on...

Some counters in sysperfinfo are monotonically increasing values. So they are no reset.

See http://support.microsoft.com/kb/555064

You can also downlad a script from SQL Magazine which helps intepreting sysperfinfo

http://www.sqlmag.com/Articles/ArticleID/26950/26950.html?Ad=1

Could it be replication jobs? I've also seen some monitoring tools creating jobs which will run continously.

If you're question is if you can have multiple pulications on one database when the answer is yes.

A publishers would be the server there a publication is located and...

Matt,

I think you still don't fully understand.

The rownumbers should be ordered by the listprice or any other column I select. So when ordering desc by ListPrice I want the product...

obnetadmin (5/19/2008)

---

Markus-

See below from Maintenance Plan log file (Error -1073548784)

Executing the query "EXECUTE master.dbo.xp_delete_file 0,N'',N'',N'2008-04-21T00:00:05'

" failed with the following error: "Error executing extended stored procedure: Invalid Parameter". Possible failure reasons:...

Matt,

the inner order is actually the important one.

Anyway I just a look at MS Connect and there is a report about this issue and the answer from MS...

Matt,

adding another order by in the outer select will only the sort the 10 orders returned and the result will look like this:

2879All-Purpose Bike StandST-1401NULL159,00

8843Cable LockLO-C100NULL25,00

9952ChainCH-0234Silver20,24

3712AWC Logo CapCA-1098Multi8,99

6877Bike Wash...

I wonder if you're looking at the correct logfile.

Do you have logging enabled in your maintenance plan?

You should look at the maintenance plan logfile not the SQL error log....

In the real procedure there would be 3 columns plus the rownumber. The idea is that the user can select on which column the results should be sorted and page...

Notification Services has nothing to do with publications and I don't think it is included in Compact Edition.

Publications are part of replication.

Sorry, no ideas. I've never seen something like that unless I had no admin rights.

You have to check the version/build number

9.00.1399 is RTM

9.00.2047 is SP1

9.00.3042 is SP2

See also http://www.sqlservercentral.com/articles/Administration/2960/

If you are a sysadmin in SQL Server you should be able to change this settings.

Did you try using sp_configure.

Exec sp_configure 'max server memory (MB)', 1024

reconfigure