Count character matches with DATALENGTH function

https://github.com/ktaranov/sqlserver-kit/blob/master/Scripts/Count%20character%20matches.sql

Wildcards II

Wildcards

Computed columns Data Types

XQuery string functions

RE: Login in via intranet application and audit user changes.

Thanks to all. I will try those solutions first. I think that solves the problem, but I need to test it and pass it along to the developer. Thank you very much and will come back if any question.!!

installation problem

I have a m/c with os-win'98. when installing Client Tools from the SQL server 2000 CD the following error poped up: Unable to install client tools as there are some pending files in your previous installation restart your m/c to resume installation How do I overcome this problem?

RE: Triggers to create String ID

I would suggest to use a extra identity column to handle this. Here is the output of 2 possible solutions you can find in my test script : (the sp__drop procedures are procs i wrote to drop existing tables/procedures/functions ... ) :drop table dbo.tst1 create table dbo.tst1 insert dbo.tst1(name) select * from dbo.tst1 _id ID name 1 A0001 a […]

RE: User does not exist????????

I ran into this exact situation a couple months ago.  Before you can add the user to any new access or change any existing acces you must completely remove her user ID from all databases then the server.  Then add her back in with new ID.  I ensured her continued access during the process by […]

RE: How to create an uneditable database ?

I don't think you can secure it completely but you can detect changes. A trigger as suggested will work except with outright sabotage where someone disables the trigger! To cover that, have an encrypted validation field (a hash total or something) which you gui compares with the actual data. Any discrepancy then generates an alert […]