Not in standard edition. Backup encryption is a side effect of using TDE (transparent database encryption) and that's Enterprise only

You create a second table, you give it a composite primary key that includes the column from the parent table, then you define a foreign key relationship.

Tables don't contain tables,...

Not continuing the debate, just to show another perspective:

http://www.hsrc.ac.za/HSRC_Review_Article-47.phtml (from 2006)

The surveys asked citizens whether they agree that ‘my household is able to get enough food for its needs’. A...

In that case...

FROM

@Employee E LEFT OUTER JOIN @AbsenceHistory AH ON E.ID = AH.EmployeeID AND (AH.StartDate >= '2011-01-01' AND AH.EndDate <= '2011-04-28')

WHERE

E.ID IN ('1','2','3')

That way the result set from AbsenceHistory...

If you're talking about the 5 files of the default trace, there will only ever be 5. When SQL creates a new one, it deletes the oldest, so there's no...

SQLRNNR (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article. This one is all about the...

As I said, you'll probably find that the windows user is part of a windows group that has access to SQL and db_datareader permissions.

SELECT

TMP.Name,

SUM(CASE WHEN AT.Descrip='Vacation' THEN Hours ELSE 0 END) AS 'Vacation',

SUM(CASE WHEN AT.DESCRIP='Flex' THEN Hours ELSE 0 END) AS 'Flex'

FROM

TEMP TMP LEFT OUTER JOIN @AbsenceType AT ON TMP.AbsType = AT.ID

GROUP BY

TMP.Name

Stop...

DDL_Admin does not grant any select permissions at all. It just grants permission to create, modify and drop objects. If you want select permission as well, you'll need to add...

Another request:

I'm bunking tonight and starting the rewrite of my rather old (and second-ever) article Managing Transaction Logs[/url]. Other than when and when not to shrink (which definitely has to...

Well, not setting max yes. Min can be left at 0 on a dedicated SQL box.

...

FROM

@Employee E LEFT OUTER JOIN @AbsenceHistory AH ON E.ID = AH.EmployeeID

WHERE

E.ID IN ('1','2','3') AND

(((AH.StartDate >= '2011-01-01' AND AH.EndDate <= '2011-10-31') AND AH.AbsType IN (1,2)) OR AH.ID IS NULL)

...

Don't lie, don't exaggerate. A good interviewer will see through that and if they do you have lost your...

Grant Fritchey (9/14/2011)

---

I'm tasked with writing another article. This one is all about the scary, crazy stuff that the uninformed can do because of how SQL Server is setup and...

That's not a SQL Server error. Hence it must have been coming from the app for some reason or other.

SELECT * FROM sys.messages AS m WHERE text LIKE 'General SQL...