Apologies. The view used to be a simple reference to the base table. It has been changed since I last looked at it. Seems I was making it more...

Hi Gail, thanks for posting.

Because those tables were not in the query. Why on Earth would other tables need to...

You can apply logic to what you think the execution plan will look like, but in my experience trying to second guess the Optimizer is notoriously difficult, as my next...

Extra info.

I granted CREATE ANY DATABASE & ALTER ANY DATABASE permissions to a user but that did not allow him to restore databases.

However, adding him to dbcreator did.

System stored proc...

We had this error too.

Basically all users should be able to access these views as SELECT rights are granted to public. There must be a specific DENY for this...

Title was full of promise, but we need more.

Ideally, we want to be able to determine what statements caused the log to grow so suddenly (and who issued the statements)...

Well done Scott. This has been doing my head-in.

We have a user with his own domain account & granted the db_ddladmin role in a database. He can alter objects in...

This should do it I think ;

select distinct object_name(object_id) from sys.partitions

group by object_id, index_id

having COUNT(*) > 1

Basically a table and its indexes are represented in sys.partitions. For...

Me too.

Getting this error running an INSERT statement with (TABLOCK). Resulting in a Stack dump. The table is NOT compressed/replicated, CHECKDB does not reveal any errors. Using SQL Server 2008...

In SQL Server's Logs (Management node)

@shifty1981

You wrote ; "Total Memory means how much memory SQL is using"

Just saw this on msdn ;

Target Server Memory (KB)- Total amount of dynamic memory the server can...

Hi Alejandro

What is the purpose of

[font="Courier New"]select id, xtype from master.sys.sysobjects[/font]

is sys.objects not sufficient ?

Also would it better to change the join order i.e. if we are after...

tbanks-1094621 (12/4/2009)

---

Right you are. It works when you don't specify a login, but to specify a login, you'll need this:

Alter Proc spLogin_OwnedObjects ( @login as SYSNAME )...

The server log should tell you if you have memory pressure.

We have ;

"AppDomain 9 (mssqlsystemresource.sys[runtime].8) is marked for unload due to memory pressure."

and

Total = Target

So I have...

Word of warning : if the history has been purged/deleted then sysjobhistory will not display the same data as "Job Activity Monitor" i.e. "Job Activity Monitor" will display a...