actually, using the content id (cid:) is the right way.

by leaving it out, you are just taking advantage of some email clients smart features of filling in missing tags, the...

dateadd is not deprecated.

glad i could help a little bit!

let us know how it goes or if oyu need another pair of eyes to look at the issue.

since you know the 53 tables, and you know the date, i think this is just a big UNION query:

SELECT 'Table1',count(*) FROM Table1 WHERE CreateDate > '2014-01-01' UNION ALL

SELECT 'Table2',count(*)...

edit: since you don't have access, you couldn't use execute as, sorry.

this solution might depend on whether your application maintains a dedicated connection or just connects and disconnects as needed...

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