Viewing 15 posts - 13,651 through 13,665 (of 49,552 total)
Though, do note that even with those permissions such a user could, if they had the appropriate execute permissions, execute a stored procedure that deletes data. Ownership chaining (feature, not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2013 at 6:26 am
chvenkataraman (4/1/2013)
Assign role 'read_only' to the user on that databse
Except there is no such role...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2013 at 3:41 am
Add the user to the roles db_datareader and db_denydatawriter. Bear in mind that you cannot deny permissions to a sysadmin though.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2013 at 3:41 am
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2013 at 3:39 am
Please note: 4 year old thread
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 31, 2013 at 3:33 pm
You'll need to rebuild all the indexes that are on that filegroup ON PRIMARY. That will move them to the primary filegroup. Once empty, you can use ALTER DATABASE to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 31, 2013 at 2:31 am
santhosh_ms3 (3/31/2013)
But Is there any way to manipulate the records through case statements. I still believe that there could be a way to control it.
To obtain the insert order without...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 31, 2013 at 2:26 am
Related thread (for anyone answering)
http://www.sqlservercentral.com/Forums/Topic1437147-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2013 at 4:09 am
I discussed that and other problems in this article
http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2013 at 3:53 am
Answering here rather than privately, because then more people can benefit...
You're not going to find a list of what material uses what question types. It's not even consistent, that can...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2013 at 3:43 am
santhosh_ms3 (3/29/2013)
my requirment is to get top 3 the records in a order which they got inserted and rest all in a sorted order.
The *only* way you can do that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2013 at 3:39 am
Sure it's possible. You'd do it pretty much like this (based on the portion of code that you posted)
DECLARE @CreateViewSQL NVARCHAR(MAX)=''
DECLARE @DropViewSql NVARCHAR(MAX)=''
IF EXISTS (SELECT 1 FROM sys.views v INNER...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 29, 2013 at 6:37 pm
Because GO is not a T-SQL statement. It's a client tool command. SQL Server has no idea what it means.
Split that into two pieces of dynamic SQL, one that drops...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 29, 2013 at 6:02 pm
Without seeing the code you're trying to run, pretty much no idea.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 29, 2013 at 5:48 pm
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?
Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third section, "Changes to Table Variables are not logged" and the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 29, 2013 at 5:38 pm
Viewing 15 posts - 13,651 through 13,665 (of 49,552 total)