Instead of trying to store the AD data in the table, why not just query that when you need it?

You can reset the keyboard shortcuts in the Tools, Customize window.

Alvin Ramard (1/28/2010)

---

Actually his comment may have been much nicer than we thought, thanks to his poor English.

He may have meant that he has "read the books" and that is...

Krasavita (1/28/2010)

---

When I go to sql jobs and trying to set notofications under email, there is no option to type email,looks like I have to enter somewehere else, where is...

You can end up with injection attacks via sp_executeSQL if you build an SQL string and then execute that, same as Exec.

For example, if you want to pass in a...

Number of databases per server only matters when it starts to cause maintenance problems.

For example, if you split up data between multiple databases, and then have to synch it for...

SQL Express has hard limits on how much RAM it can access, but that's probably not the actual problem. I would tend to suspect that Access is what's eating...

It might be difficult to block them from...

iamthemanx (1/27/2010)

---

Like an 1 hr or so.

Unfortunately , I can not post the code here (data privacy and all that stuff) and honestly, I do not want to dig...

Are you saying that if you clear the buffers, the proc takes seconds to run the first time, and then keeps going that way?

I've never seen that behavior. But...

Does this do what you need?

select top 1 *

from My_Table_History

where sName = 'BIGTABLE_A'

and dtAsOf between @dtStart and @dtEnd

order by hID

union

select top 1 *

from My_Table_History

where sName = 'BIGTABLE_A'

and dtAsOf between @dtStart...

In the options, there's a setting for the maximum string length to display. Check that.

I store them in the database, so they get backed up along with the jobs that call them, when I back up the system databases (msdb to be precise).

That is correct. 64-bit SQL does not support SQL Mail. It does support DBMail.

No, you don't need a separate SQL account.

The service account is the one that SQL is running under, as a Windows service. Do you know what a Windows service...