Viewing 15 posts - 46 through 60 (of 645 total)
Perry Whittle (8/16/2010)
May 12, 2020 at 8:11 am
I actually tried a brand new installation of SQL 2008 SP1 Enterprise Ed. on the server with O/S Windows Server 2008 Standard SP2, and while attempting to set the...
May 12, 2020 at 12:16 am
Hi there. Regarding item # 12 in the article:
12) All the databases that had user defined assemblies should have 'trustworthy' set to true.
Please do not enable TRUSTWORTHY
on databases, especially...
May 8, 2020 at 6:43 am
Hi Frederico Fonseca,
Yes, that might change the collation of my database, but not that of TEMPDB. So any query using a #temp table would need to be checked...
April 24, 2020 at 7:54 pm
As the database is using a case-sensitive collation, I don't see why the 2nd option wouldn't work.
Hi Chris. For the question, the DB is actually using a case-insensitive collation:...
April 24, 2020 at 4:28 pm
Your solution does also find those FirstNames that does not really have a lowercase version, i.e. where FirstName starts with a digit or a dash or a dot...
I would...
April 23, 2020 at 4:13 pm
Hi there. Interesting question. Here are some notes:
Latin1_General_100_CI_AS_CS
collation. Those last two letters are transposed....April 23, 2020 at 7:30 am
Played with it a bit and found this returns the second answer and not exactly sure why. I am thinking there is an implicit conversion changing the collation but...
April 7, 2020 at 4:46 pm
Hi Miles. Given the timing of this question, it is possible that it's an April Fools joke. But, just in case it is serious, as well as for those that...
March 30, 2020 at 6:41 am
My favorite project of all time used all stored procedures. It was my favorite because the only privs the app needed was CONNECT and EXECUTE on certain stored procedures.
Exactly....
March 9, 2020 at 5:48 pm
wait until you get an application that wants to create sql agent jobs and then delete them after. not a hope in hell stopping that process running as SA
Mike,...
March 9, 2020 at 5:39 pm
I am willing to give them db_owner on their own database, if the code they provide kills that products database I know it isn't my problem, and I have...
March 9, 2020 at 5:28 pm
jarick 15608 wrote:...
I'd expect more for a commercial application but ...
I'd expect more from people buying commercial applications.
In almost every place I've worked, I've seen major applications purchased without...
March 8, 2020 at 8:54 pm
It seems so many vendor applications just demand dbo access to the database, if not SA rights to the instance.
Yes, this is exactly what I am talking about. SQL...
March 6, 2020 at 6:39 pm
Using embedded SQL / ORMs means that the DB login needs to be given all necessary rights to perform all operations.
How is that different than not using an...
March 6, 2020 at 6:17 pm
Viewing 15 posts - 46 through 60 (of 645 total)