you still need to create a USER, even for windows logins.

for example, here's the script to add a windows user, and then tie him to the role we described:

--do i...

debbas88 (5/10/2011)

---

Hello again

I cant use the login created from the above written procedures to access the database unless i make it sysadmin. If I make it sysadmin the login will...

thank you for the more detailed explanation Brian; I'm better informed now. I had assumed something else, and I'm glad you posted this!

Howard I think either of these two examples might get you where you want to go:

see if these get you closer to your goal:

SELECT

instz.applicationid,

instz.instanceid,

appz.Name

FROM application_instance instz

LEFT OUTER JOIN [Application]...

it's actually a very common security setup to have a group with ONLY execute permissions; some applications are designed so that all data is accessed via stored procs, so the...

performance can be a big question;

At least for a start, grab the query portion of the view, and run it in SSMS.

Look at the execution plan; see if any additional...

I'd also add than if a WHERE statement is included in the command, that is used by the optimizer to decide which index will be used to retrieve the data.

If...

you'll want to use the DATEADD and DATEDIFF functions;

here's an example using quarters: this is returning the START, of each of 4 quarters: this quarter, next, two quarters from now,...

c.reusch (5/10/2011)

---

Hello,

I have a table:

AccountNo, Period, Amount

100, 11/02, 100

100, 11/03, 110

100, 11/04, 120

110, 11/02, 50

110, 11/05, 70

Now I want to have the latest datasets (No. 3 and No. 5). The...

the only way i think it's going to work is if you know each element is fixed width, then you can use a substring function to pull out each element.

I've...

I've heard the same as tyson price, that for SQL server, the order of the joins don't matter, because the optimizer will change the order based in the execution plan...

something like this should work:

SELECT distinct TOP (100) PERCENT

FUTURA.dbo.V_ANSCHRIF.ANS_NUMMER AS STORE,

FUTURA.dbo.V_ANSCHRIF.ANS_NAME1 AS STORE_NAME,

FUTURA.dbo.V_ANSCHRIF.ANS_PLZ_ZUSATZ AS NUMBER_OF_POS_IN_STORE,

POLLING.NUMBER_OF_POS_POLLED,

POLLING.LAST_DATE_OF_SALES,...

Personally, my favorite resource of all time!

sounds like they have already beein imported; maybe you ran the script twice accidentally.

there's no need to restore master on another server if you are migrating logins.

you would only restore master on the same server if you were doing disaster recovery.

simply...