Steve Jones - Editor (1/2/2008)

---

It's actually easy. Inside a company, you buy CALs. If the people are authenticated users, Windows Auth, or just AD accounts, they should use CALs. Per...

I just wished that there was only one license type. When you work for a large company and everyone is buying licenses, its hard to match up what type...

The problem was that the SID was the same for the accounts. I ended up changing the database ownership to SA, dropping and recreating the account with the new...

Cat (10/5/2007)

---

Any idea how to move this data to text files easily. I see I can use the DTS export wizard, but it seems to do this for only...

Any idea how to move this data to text files easily. I see I can use the DTS export wizard, but it seems to do this for only one...

Thanks for the article. I will check it out now. I think that it must be drilling through to Oracle - that is the only data source setup...

Thanks for the replies. My inital thoughts were back up the database and export it to access - but text is better! We have a system for storing...

Thanks, exactly what I was looking for!  Question answered!

We did this about a year ago, but we used some tool to do it.  Make sure you change the owners too.  I'm not sure what the outcome would be...

GREAT! Thanks!

I agree that there are many possiblities.  It lookes like it would be difficult to capture them all.

I will add 12.  In my preliminary testing, 12 didn't come up.

Thank you both for your help.  This is what I came up with

 

SELECT  name,status,

CASE status

when (4) then  'Bulk-Logged'

when (8) then  'Simple'

when (24) then  'Simple'

when (28) then  'Bulk-Logged'

when (1073741848) then 'Simple'

when...

Thanks for the info on how to parse the @@version global variable!  Big improvement!

• I...

Mine was along the same lines of the muppet question.  I was in high school applying for a help desk position at a theme park and they asked - If...