Viewing 15 posts - 646 through 660 (of 3,221 total)
Brandie Tarvin (2/15/2012)
bitbucket-25253 (2/15/2012)
Brandiego here
HA! That's exactly what I need. Thanks. @=)
Now, now be honest is it the chocolate or the Martinis or maybe a bite of chocolate...
February 15, 2012 at 8:19 am
SathishK (2/15/2012)
Hugo Kornelis (2/15/2012)
I got it right, for all the wrong reasons.
The script will not run, regardless of triggers, for two reasons:
1. The MERGE statements must be terminated with a...
February 15, 2012 at 8:14 am
I agree with Steve ... try new tools .. learn what they can and can not do for you.
But I bump into the old adage.
"So little time, so much to...
February 15, 2012 at 7:21 am
bitbucket-25253 (2/15/2012)
Incorrect answers: 66% (155)
Total attempts: 236
Thought many more would be correct, since BOL clearly states
If the target table has an...
February 15, 2012 at 7:10 am
Suprised at the results
Incorrect answers: 66% (155)
Total attempts: 236
Thought many more would be correct, since BOL clearly states
If the target table has an enabled...
February 15, 2012 at 6:01 am
bminch (2/14/2012)
declare @sqlstring nvarchar (255)
set @sqlstring = 'use ' + 'master' + ' dbcc showfilestats'
execute sp_executesql...
February 14, 2012 at 7:39 am
If I understand your question correctly, see if something like this will work for you.
CREATE TABLE T2000(ID Int,Dated DATETIME,Amount DECIMAL(10,2))
INSERT INTO T2000
SELECT 1, '2012-02-03 00:00:00.000', 100.00 UNION ALL
SELECT 1, '2012-02-03...
February 14, 2012 at 7:23 am
John Mitchell-245523 (2/14/2012)
In any case, I don't agree that just because two statements are posted on the...
February 14, 2012 at 6:33 am
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 on...
February 13, 2012 at 9:33 pm
Nice back to basics question -- no gimmicks .... nice very nice
February 13, 2012 at 9:00 pm
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 dbo...
February 13, 2012 at 3:55 pm
You might want to read this about logon triggers ...
I think somewheres in that article you will find a logon trigger that will do just what you want.
http://www.simple-talk.com/sql/t-sql-programming/logon-triggers/
February 13, 2012 at 3:14 pm
Siva Ramasamy (2/13/2012)
Hi,I want to grant execute privilege of all the stored procs (200+) in a database to a user.
Does any of you have an automation script for this..?
Thanks!
Try...
February 13, 2012 at 2:54 pm
Viewing 15 posts - 646 through 660 (of 3,221 total)