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...
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...
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.
April 1, 2013 at 3:41 am
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
April 1, 2013 at 3:39 am
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...
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...
March 31, 2013 at 2:26 am
Related thread (for anyone answering)
http://www.sqlservercentral.com/Forums/Topic1437147-391-1.aspx
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/
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...
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...
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...
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...
March 29, 2013 at 6:02 pm
Without seeing the code you're trying to run, pretty much no idea.
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...
March 29, 2013 at 5:38 pm
Viewing 15 posts - 13,651 through 13,665 (of 49,552 total)