sounds like the login that is tied to the user has sysadmin priviledges by mistake;

take a look here and make sure that the login only has the public role; if...

how about this?

SELECT MerchantID from #tempSort

ORDER BY CASE

WHEN LEFT(MerchantID,1) LIKE '%[A-Z]%'

...

there's a number of threads here on SSC where the requirement is to remove public permissions in order to comply and lock down a SQL server to DoD standards (google...

you'll need to grab one of the many split(0 functions that are in the scripts section here on SSC;

there is a big difference between a varchar that happens to contain...

kazim.raza (10/11/2011)

---

Good day all;

How can I make inserts into all of them while having them within one or more transactions so in case of an exception I can roll...

AK1516 (10/11/2011)

---

A time-out occurred while waiting for buffer latch -- type 4, bp 0000000087FD1780, page 1:6792, stat 0x1fc0010b, database id: 4, allocation unit Id: 72057594041860096, task 0x0000000005A3C508 : 0, waittime...

this might be tough...if the update fails, i'm not sure you can even capture something in the trigger....if the update executes but touches zero rows, that's a different issue.

for example,...

Lee you've got at least one custom trace, possibly two...

i built this proc and contributed an article about it to help Reverse Engineer a Server Side Trace.

this creates a procedure,...

before i discovered CLR functionalities,

i've done this by doing a normal old BCP that pipe delimits mydata like this:

EXECUTE master.dbo.xp_cmdshell

'bcp "SELECT object_name(object_id) As TbLName,name as ColName FROM SandBox.sys.columns...

?

With mySampleData (id,book_code,price)

AS

(

SELECT 1,30100,0 UNION ALL

SELECT 2,30200,0 UNION ALL

SELECT 3,40100,0 UNION ALL

SELECT 4,40100,100 UNION ALL

SELECT 5,1000100,85 UNION ALL

SELECT 6,1000200,180 UNION ALL

SELECT 7,2000100,45 UNION ALL

SELECT 8,2000200,85

)

SELECT c1.book_code,

...

i think you want to enhance the join so items in the self join don't find themselves;

this is just slightly modified from yours:

SELECT c1.book_code,

...

haven't done this myself, but i know you have to use impersonation;

this should help, straight from Microsoft:

http://msdn.microsoft.com/en-us/library/89211k9b%28v=vs.80%29.aspx

Winston i think it's a scripting option that is turned off by default;

if you change these settings, do you get the script you are expecting?

i remember that SQL 2000, via enterprise manager, it is possible to use the GUI to change the text of the procedure, but without executing that new definition ,...

take a look in the script library here on SSC, there are a lot of contributions that do what you are asking;

I've been using this from http://vyaskn.tripod.com/code.htm for quite a...