Another nice clear QOD - Thanks Steve

Now, now be honest is it the chocolate or the Martinis or maybe a bite of chocolate...

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...

Brandie

go here

http://originalchocolatebar.com/newintro.html

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...

bitbucket-25253 (2/15/2012)

---

Suprised at the results

Thought many more would be correct, since BOL clearly states

If the target table has an...

Suprised at the results

Thought many more would be correct, since BOL clearly states

If the target table has an enabled...

bminch (2/14/2012)

---

While its certainly easier to use brackets/parenthesis around @sqlstring don't forget about sp_executesql.

declare @sqlstring nvarchar (255)

set @sqlstring = 'use ' + 'master' + ' dbcc showfilestats'

execute sp_executesql...

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...

John Mitchell-245523 (2/14/2012)

---

Appalled? I usually reserve that reaction for earthquakes, famines, wars and so on.

In any case, I don't agree that just because two statements are posted on the...

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...

Nice back to basics question -- no gimmicks .... nice very nice

SQLKnowItAll (2/13/2012)

---

Hi Ron,

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...

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/

Try...