Somewhat, there are user ids, but it doesn't seem to be the one that is appearing.

I just exported my listing, but it seems like it does not contain the user...

I think I found part of the problem...which is that the index defrag routine requires page level locking, while the app requires row lock (page lock off). I'm not...

I tried running the uninstaller on the server and it still seems to think that it's installed. I have renamed the lakeside tables in msdb with back in front...

Do I need to run the uninstaller on the server? It doesn't seem to work when I run it locally. Also, the tables are still there in msdb.

Grant Fritchey (3/7/2013)

---

I sure wouldn't turn on both. In fact, I'd suggest just using 1222, not 1204.

How about taking a look at the system_health extended event session. It automatically captures...

In the SQL Server logs.

IT seems to be...

No, I am trying to restore to a new database name while the existing one stays in place.

I ended up having him restore the database to another server with the...

For the new user, I'd it to generate a create user statement:

USE [dbname]

GO

CREATE USER [mynewuser] FOR LOGIN [domain\firstname.lastname]

GO

Where mynewuser is paramater 1 and domain\firstname.lastname is second parameter.

Seems like it's working better as I'm getting output now.

But this error is coming up:

Msg 4145, Level 15, State 1, Line 35

An expression of non-boolean type specified in a context...

Sorry, somehow I got the steps mixed up, first is actually

Page locks = ON

then the reindex

then Page locks = OFF

The application requires this setting, otherwise it generates errors during...

Here's the command:

alter index [UQ__ICMUT012__130D42861D913A15] on [wpsdbJcr].[jcr_Sch].[ICMUT01279001] reorganize

Here's the error:

Msg 2552, Level 16, State 1, Line 1

The index "UQ__ICMUT012__130D42861D913A15" (partition 1) on table "ICMUT01279001" cannot be reorganized because page level...

I turn it off because I receive an error that it cannot reindex them with page lock on.

I think I see the problem, somehow the column name has extra spaces, so I just added rtrim in the charindex.

I'm on SQL 2008:

When I exec I get:

Msg 102, Level 15, State 1, Line 35

Incorrect syntax near 'Schema_Name'.

Msg 102, Level 15, State 1, Line 37

Incorrect syntax near 'obje'.

I have changed

m.objectid to

cast( M.object_id as varchar)