Viewing 15 posts - 1,711 through 1,725 (of 2,647 total)
Hi Steve,
Any updates? You can clearly see that the display name is the same for each user.
February 14, 2012 at 10:56 am
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....
February 14, 2012 at 10:47 am
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...
February 14, 2012 at 9:32 am
I still think he is a robot... Sent by the ISO.
February 14, 2012 at 9:15 am
SQL Kiwi (2/13/2012)
SELECT
ItemNum,
Category =
'Group' + CHAR(64 +
...
February 14, 2012 at 9:06 am
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. ...
February 14, 2012 at 8:49 am
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.
February 14, 2012 at 8:45 am
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...
February 14, 2012 at 8:43 am
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...
February 14, 2012 at 8:17 am
GSquared (2/14/2012)
Heaps often behave "strangely" compared to tables with clustered indexes. Lack of a primary key...
February 14, 2012 at 7:35 am
Jeff Moden (2/13/2012)
SQLKnowItAll (2/13/2012)
USE databaseNameGRANT EXEC ON SCHEMA::dbo TO userName
That should do the trick, assuming the schema for these objects is dbo! Else, replace dbo with the schema you need.
That...
February 14, 2012 at 7:27 am
bitbucket-25253 (2/13/2012)
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...
February 14, 2012 at 7:25 am
bitbucket-25253 (2/13/2012)
SQLKnowItAll (2/13/2012)
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...
February 13, 2012 at 7:25 pm
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...
February 13, 2012 at 3:32 pm
Viewing 15 posts - 1,711 through 1,725 (of 2,647 total)