from TSQL? you can't; what you'd have to do instead is to change the PRINT command to a SELECT; then you can put it in a variable or a table...

10.0.* is SQL 2008

10.5.* is SQL 2008R2. a next higher version of SQL; you'd have to either download an express version of R2, or buy , at a minimum, the...

that's not what you said before...

you said you added...

i don't believe the index was added.

this works fine for me, and orders the results as expected int eh second query:

CREATE TABLE TestTable(ID INT);

GO

INSERT INTO TestTable(ID)

SELECT 7 UNION ALL

SELECT 9...

debbas88 (5/10/2011)

---

I understand a Windows group will act as a login. So once a windows group is created, if I strip it from all server roles, will my application be...

oops i thought the issue might be how Oracle is less forgiving than SQL when it comes to conversions from string to DAteTime, but most of what you qare doing...

Integrated Security=True in the connection string.: that means that if myDomain\Karen uses your app, THAt is the username that will be used...NOT your test user.

you need to add a Windows...

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