and to recap, all users, since they are in the public role, have access to master and tempdb;

however what they see in the master database is limited by permissions, and...

Perry Whittle (1/15/2014)

---

What?

Identitfy the Live tables that require obfuscating (there's likely only a...

also, can you tell us if you are sysadmin in the connection that SSMS/ object explorer is using ?

there's a lot of code in SSMS that assumes that you are...

this is sort of similar to a question i asked the other day:

http://www.sqlservercentral.com/Forums/Topic1530825-363-1.aspx

i wanted to grab 1-N queries and use SSIS to send them to a multi sheet excel document;

because...

sqlserver.exe is the name of the executable that is running under the SQL service; it is the absolute core and is critical to SQL server...heck it IS sql server.

if you...

for a specific table, it's the ALTER permission; that obviously means they can add/drop columns as part of the table as well.

GRANT ALTER TABLE on dbo.TableName to MyUser

i belive if...

New Born DBA (1/14/2014)

---

I have been asked from users about SQLSERVR.EXE. What is SQLSERVR.EXE?

Someone emailed me about "why SQLSERVR.EXE process is limited to about 128MB of RAM and it...

can't really predict the output, since this poll has all incorrect answers.

kudos for the easily copy-and-pasteable code, it produces results that basically looks like a christmas tree, i guess.

but the...

probably the easiest way is to stick the query into a subquery, featuring row number, and then filter the results.

SELECT

*

FROM (SELECT

...

not really;

the actual SQL plan allows us to review deep details of the plan, and tell if stats are out of date, which columns were used, which indexes, and so...

for this query, i think we'd need to see the actual execution plan on this, as well as a list of all indexes on the fctAssetFulfillment and the FulfillmentPartnerInstall...

Luis pointed it out i think; the assignment must be a static value or constant;

a convert cannot be used, even if it was a static date, nore getdate,

and when you...

it's not possible for a foreign key to reference a different database.

foreign keys can only be created within the same database as the two tables exist in.

it's possible to...

well, if there is a view or stored procedure that references a different database or a linked server, you can query for that.

take a look at the view sys.sql_expression_dependencies,...

Thanks for looking Phil!

pretty sure the office is using vs2008 for ssis and ssrs, so that's probably 2008; i couldn't seem to find a 2008 SSIS forum.

Ironically, i had done...