srimkumarp-720356 (7/22/2013)

---

Thanks for the information.

We are using only Server level audit trigger.

For example :- I created the login on one server and later drop the same login. Now I want...

srimkumarp-720356 (7/22/2013)

---

Hi ,

I want to capturethe Audit Server Security Events , like if any one doing Create / Alter / Drop logins on server level ,...

truncate is not granular like that; it's inherent in db_owner and db_ddladmin, i believe.

just make sure noone has those rights.

what difference is there if the user is allowed to delete...

Guras (7/19/2013)

---

I need to find the disk space estimation to create a new database with all the objects of the current databases ( without the data copied) ..for e.g. I...

fraggle i just tested this myself;

i was hoping i could alter a user and remove their mapping to the existing login, but i found i had to crop and recreate...

I'd say if you have 14 separate jobs, they should not be scheduled to execute at all. i'd actually remove them to avoid confusion.

instead,

shouldn't you create one single...

no, not the default trace; you'd need to use the dmvs instead.

the default trace only tracks DDL or database settings changes...create/drop, alter, stuff like that; nothing related to Data access...

users don't actually login at a...

an example of checkign the references HanShi mentioned:

--Objects:

SELECT objz.name,

fn.*

FROM sys.objects objz

CROSS APPLY sys.dm_sql_referenced_entities(schema_name(schema_id) + '.' + objz.name,'OBJECT')fn

WHERE referenced_entity_name ='all_data'

and just in case, you can check the...

just a a USE DatabaseName to the command, if...

ok ray, this looks like a business "fiscal year" question, right?

ie my biz year goes from july1 to jun30 of the next year?

substitue MyDate for GETDATE() in this query, and...

rayh 98086 (7/11/2013)

---

Hello,

I would like to create a SQL query that will make a decision based on date. For example, if the date is Jun 30,2013 or greater, then...

http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx

go to this page, and click on the red button that says "Download SQL Server 2012 Express"

a div will appear with various downloads, so just click the one that says...

erikd (7/10/2013)

---

Thanks, Lowell. Is your library at all portable? I find myself working from several computers, and several more term servers, so it's helpful for me to be able to...

yes it is, but that's what's so tricky! it's not obvious!

how much is 2147483647 MegaBytes?

2147483+ Gigabytes!

2147+ TeraBytes!