Re: SQL password complexity

In Transact-SQL, a semicolon is an optional *statement* delimiter. This
shouldn't cause problems as long as the value is properly enclosed in
quotes:

EXEC sp_password NULL, 'new;password', 'DevLogin'

You are right that a semicolon can prematurely terminate the statement when
the value isn't properly enclosed in single quotes:

EXEC sp_password NULL, new;password, 'DevLogin'

However, the OP indicated that the password change was successful so the
problem is likely due to confusion in the connection string.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<m.bohse@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1144834023.511273.294970@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
A semicolon in SQL functions as batch separator just like the word GO.
I assume that's what causing the problem for your developers. SQL
server will probably see the password as part of two separate commands.

Markus



.

Relevant Pages

  • Re: Windows 2000 and XP and exec and double quotes
    ... arguments to exec. ... exec wish test1.tcl $cmd ... > quotes and escaping quotes in parameters with backslashes is a method ...
    (comp.lang.tcl)
  • Re: Windows 2000 and XP and exec and double quotes
    ... On the Tcl level the literal constants ... These two are indeed where you hit the problem in Windows [exec]. ... Note that, as I said before, quotes can not occur in Windows filenames ... Does ntbackup explicitly want quotes? ...
    (comp.lang.tcl)
  • Re: Long file name problem
    ... Jerold Schulman wrote: ... We cannot execute programs with long file names unless we wrap them in quotes. ... This is starting to cause some problem with programs on the system, as they don't wrap their commands in quotes by default. ... I had to do the same thing when install Back-up Exec. ...
    (microsoft.public.win2000.file_system)
  • Re: Windows 2000 and XP and exec and double quotes
    ... "cmd /c echo" just outputs it's commandline, so it's not very typical, ... mode of operation is not to try to escape the [exec] parameters. ... quotes and escaping quotes in parameters with backslashes is a method ...
    (comp.lang.tcl)
  • Re: Negative value and zero
    ... > as long as the part after the semicolon is a zero between quotes ...
    (microsoft.public.excel)