Tag Archives: sql server

Granting Permission to Grant Permissions

I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a view and you wanted to allow a user to grant permissions to this view to other users. It’s not a … Continue reading

Posted in Blog | Tagged , , | Comments Off on Granting Permission to Grant Permissions

Still 32

I was listening to a presentation recently and the presenter talked about some of the restrictions in working with 32 bit SQL Server on 64 bit Windows hosts. Another person joked that any companies still running 32 bit software were … Continue reading

Posted in Editorial | Tagged | 2 Comments

If You Need To Fix Database Filename Extensions

In a recent post I showed how the file extension for a database doesn’t matter. It can be confusing, however, and you might wish to “fix” the filenames to conform to the proper extension. How can you do this? Well, … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Full-Text Search – Thesaurus

I would hope that most of us have used a thesaurus at some point in our careers. These allow us to substitute words for one another, providing for richer and more interesting communication. Full-text search in SQL Server includes a … Continue reading

Posted in Blog | Tagged , , | Comments Off on Full-Text Search – Thesaurus