Try granting it references permissions ...

GRANT REFERENCES ON testpriv(id) TO test

After that I did not have any issues updating the table as Test user.

Also have a look at this ...

http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express

http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express-2

I have not read the entire article yet but seems like an interesting idea :).

Mohit.

Hi Michael...

Hi Rich,

A virtual name is what your users will access it by; it you need to have a DNS entry registered with that name and virtual serer IP...

I have not had that happen; I am running multiple installs of SSRS. I'll check it out when I get to work again tomorrow ...

But I would check no...

You are not excluding HEAP, instead of excluding cluster indexes

Try this for disabling indexes ... just made few adjustments..

DECLARE @schemaname sysname

DECLARE @tablename sysname

DECLARE @objectid sysname

DECLARE @indexname sysname

DECLARE tables_cursor CURSOR...

Mike Levan (3/26/2009)

---

Could some one let me know the diffrence here.

1. Query Time out Expired

2. Execution terminated by the provider because a resource limit was reached.

3. Query Wait time -...

Markus (3/26/2009)

---

Two CPUs. One MDF and one LDF file.

The thing is that we did not have this issue on the old server hardware and this issue starts about...

Yaa our Disk guys tell us that too; I still do it!

I have always noticed performace improvement. Other thing how many CPU you have and how many Data files...

Right DBCC does put heavy load on the server; I would not be concerned in your system. Unless that starts happening in during business hours.

How is your tempdb setup?

Mohit.

I am performace tuning a SQL Server with this issue right now. This is caused by bottle neck in I/O as Microsoft said. Problem is it Disk guys...

Sorry I have never used ArcServe Agent, I like native SQL Server Backups more :).

I did a quick search on google and it seems alot of people are complaining...

2 Tim 3:16 (3/26/2009)

---

DBCC Memorystatus may help. It will at least show you how much AWE is currently being used. It's not unusual at all for the os...

Duplicate post, replies started here already.

Duplicate post, Replies here please.