creating a custom role encompasing the specific requirements is a best practice.

permissions should be assigned to custom roles, and users assigned to the custom roles.

This makes migrating users from one...

here's my suggestion:

create this role in each of the ten databases in question.

add the logins of the developers as users to each of the ten databases.

add the users to this...

i scripted out your trace, and ran it on my dev server(changing the path to the trace file only)

i certainly see trace data, but i'm confused about what you say...

DBA328 (8/2/2012)

---

Oracle has a SYSOPER privilege allows opration such as:

instance startup,mount & database open;

alter database backup archive log and restore

This privilege allows the user to perform basic operational tasks without...

I googled "SQL server linked server to "Oracle Internet Directory" " with no luck at all;

how often does the data change in the "Oracle Internet Directory"? is it something...

SQLKnowItAll (8/2/2012)

---

Imagine telling someone that they are responsible for guarding what is in a room, but the room is locked and they don't have the key. When someone...

i would definitely recommend going to 2012, and not recommend 2008, or even 2008R2. just because YOU might not have experience in 2012 does not mean you should not recommend...

so close...we have a table now, and some expected results....but you provided screenshots of data.

i cannot copy paste those screenshots into SSMS to get the sample data.

I'm looking for commands...

a quick google search of "FDIC insured banks" gives me a starting point like Gail suggested:

http://www2.fdic.gov/idasp/

7200+ institutions on the search page , all part of a downloadable csv file.

you'd...

mostly because a function can only...

i think it's simply like this:

...ORDER BY ISNULL(SortOrder,2)

if you think the variables popup might be showing up outside of the desktop space(like when you switch from dual monitor to single, and stuff is outside of scope)

a lot...

well , answering my own question as to why performance sux:

the plan has nested loop for the inner join, i think based on the Estimated # of rows being =...

OK the examples so far are kind of specific to the data at hand, and not as generic as I was thinking a Joiner function would be.

i was playing...

the jet driver would already be on a normal server, but only works from 32 bit installations, ie SQL 2005;

if you are on a 64 bit SQL server, you need...