Viewing 15 posts - 16 through 30 (of 31 total)
1. The update should be in the trigger there is no need for an...
January 20, 2017 at 4:10 am
I have tried another way :
I have created a stored procedure [dbo].[sp_timedifference]
and in it :
[end_date])/60),':',
(DATEDIFF(Minute,start_date,[end_date])%60))
January 16, 2017 at 10:36 pm
January 16, 2017 at 10:11 pm
I am actually just updating the end_date field. So when it gets written (updated) I wanted the trigger to calculate the time difference.
So, yes...basically I want a result from...
January 16, 2017 at 1:40 pm
Thats what I did but it does not work.Its like Lowell said.
January 15, 2017 at 9:40 pm
Is there a way arround ?
I need ordinary users to see who belongs in their group.
January 15, 2017 at 8:58 pm
This, unfortunately,this works only if I run it on the server. If I run it from my program then I only get one entry and that is only the first...
January 15, 2017 at 8:24 pm
Joie Andrew - Sunday, January 15, 2017 7:15 PMEXEC sp_helprolemember '<rolename>';
everyone's telling me these builtin stored procedures are deprecated (?)...how can I write...
January 15, 2017 at 7:36 pm
I think adding a new role is very good idea.
How can I list users that are a members of my new created role so not to loose track ?
January 15, 2017 at 7:04 pm
actually, it seems a better option to make all new users database owners and only if you need to deny them something you do that on the object in question....
January 14, 2017 at 11:36 pm
January 14, 2017 at 11:20 am
To TheSQLGuru:
Inefficient ? Why ? The trigger only fires on the table you use it on.
You can always see what was changed and when and by who But, is...
December 25, 2016 at 4:45 am
simple trigger and an audit table...
CREATE TRIGGER tr_audit ON twitter FOR INSERT, UPDATE, DELETE
AS
DECLARE @bit INT ,
@field INT ,
...
December 19, 2016 at 1:12 am
Sue, I tried your suggestion...
I copied the sp_addlogin
and created a new one.
However, I got the error on :
--execute sp_hexadecimal @passwdbin, @hextext OUT
and
--execute sys.sp_hexadecimal @sid, @hextext OUT
No such stored...
December 15, 2016 at 4:29 am
There is no stored procedure for creating user under System Stored procedures
December 14, 2016 at 1:11 pm
Viewing 15 posts - 16 through 30 (of 31 total)