Right-click on the database name, Tasks, Generate Scripts. If you look at the scripting options, you can set it to script out the permissions.

Ahmed Yarub Hani (7/21/2009)

---

Well, your answer made me look like a complete (grasshopper)!!

The code that he gave to me thankfully will not do the job

The following steps should take place,...

gage.trader (7/20/2009)

---

Jack Corbett (7/20/2009)

---

I understood you to mean that you could have several different ways the manager wants to look at the data. If it is only those 2...

Lynn Pettis (7/20/2009)

---

I was "on vacation" last week having taken the week off to work the PPI. What I joke this year. I worked 3 games on Thursday...

GilaMonster (7/20/2009)

---

Gianluca Sartori (7/20/2009)

---

I received all email notifications during the weekend, but there's been very few posts.

I don't think this means something like "Are the posted questions getting BETTER?"

Should I...

Try this on as the guts for your proc:

SELECT @wk = DATEPART(WEEK,MIN(TD)) FROM EDS_TD GROUP BY strEmpID

SET @bIsEven = CASE WHEN (@WK % 2)=0 THEN 1 ELSE 0 END...

You're not going to be able to use a function for this.

Functions:

- cannot run EXEC statements

- cannot run stored procedures unless they're system extended stored procs...

Honestly - if you are not sure what this might hit, making an assumption might be dangerous.

Start easy. Use something like the freely downloadable SQL Health and History utility,...

Grant Fritchey (7/14/2009)

---

If we are coming up on the number of the beast & the end times & all that because of the Thread, then the four horseman & the...

Jeff Moden (7/14/2009)

---

Matt Miller (7/13/2009)

---

Jeff Moden (7/13/2009)

---

Heh... well... you can if you don't mind getting...

Steve Jones - Editor (7/11/2009)

---

If the databases have the need to share data, then it makes sense to consider one large database. I've seen separate applications that need to share...

Your CASE can only return only data type. So - your ELSE statement is likely screwing things up, since it's the only one that definitely gives a type (numeric...

You need to define an output parameter to pass the identifier back out. Something like:

CREATE PROCEDURE [insert_Bejovok_1]

(@BejovoTipus_1 [int],

@BejovoSorSzam_2 [varchar](50),

@BejovoDatum_3 [datetime],

@BejovoSzallito_4 [int],

@BejovoFizmod_5 [varchar](50),

@BejovoFizHat_6 [datetime],

@BejovoKiegyenlites_7 [datetime],

@BejovoDeviza_8 [int],

@BejovoBelsoSorszam_9 [varchar](50),

@ReturnID integer OUTPUT)

AS

BEGIN

INSERT...

David Brusowankin (7/13/2009)

---

Barry,

Thanks for your informative post. I saddens me that 10 years after Informix bought Illustra and merged their solution into that database platform, Microsoft still hasn't caught up....

Did "the Thread" just eat itself? It disappeared from the recent posts query....