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!

i thought it was pretty straight forward from there;

you would simply modify my example with a WHERE statement...

WHERE filz.[name]='XXX_2012'

if you need a fulls cript, i'm pretty sure if you search...

newbieuser (7/10/2013)

---

Thanks. I'm confused with this one.. I set the maximum server memory(in MB): 2147483647 on the database server. But i the task manager sqlservr.exe is using 3349316K memory. So...

i'll throw my two cents in;

I use a combination of saved scripts in a specific folder(lazily using C:\Users\<username>\Documents\SQL Server Management Studio\Projects, and that folder has subfolders and hundreds, probably thousands...

most likely permissions, because the startup account of SQL server doesn't have access to the network share.

When you touch anything outside of a database, SQL server does not use...

well, i've got this saved in my snippets to find tables by filegroup:

SELECT

objz.[name] As TableName,

objz.[type],

idxz.[name] As IndexName,

...