Rock on!

Hi Steve,

Any updates? You can clearly see that the display name is the same for each user.

I think you need to not worry about matching the other databases. Your issue is with the current database and analyzing system tables between the 2 will not help....

the first thing is that you cannot update system tables manually without this:EXEC sp_configure 'allow updates', 1

reconfigure with override[/sql]

It will not let you. The other code is specific to your...

I still think he is a robot... Sent by the ISO.

SQL Kiwi (2/13/2012)

---

SELECT

ItemNum,

Category =

'Group' + CHAR(64 +

...

Your post does not give us enough information to understand your issue completely. Can you please provide DDL for the table which you are affecting and sample data. ...

If you cannot do this yourself, I would get an experienced consultant. There are so many variables that we cannot be of much help here.

Take a look at Pinal Dave's[/url] explanation of these types of locks. This is a quick reference, but other tuning books are available that different people here like to...

I would never start a username with a special character. I can't find anything off the bat either, but it just seems like a pointless convention. Why was...

GSquared (2/14/2012)

---

Is there no clustered index on this table? How about a primary key?

Heaps often behave "strangely" compared to tables with clustered indexes. Lack of a primary key...

Jeff Moden (2/13/2012)

---

That...

bitbucket-25253 (2/13/2012)

---

Go to this site

http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server

Or

•Using SQL Server Management Studio, expand Security then Schemas under a particular database.

•Double-click on the schema name Dbo and choose Properties.

In the next window click...

bitbucket-25253 (2/13/2012)

---

SQLKnowItAll (2/13/2012)

---

Hi Ron,

I don't see anything in that reference to dbo or specific to the EXECUTE permission. Can you elaborate on issues with granting the exec permission on the...

You are going to want to find out which queries are involved in this: http://msdn.microsoft.com/en-us/library/ms178104.aspx This is a good start. Once you know which queries (or query being...