bagofbirds-767347 (4/20/2010)

---

thanks. i do indeed use central functions for things like string/date operations. But my problem is getting the procs to work with data in the correct db....

for encryption, i really like this article; lots of example,s and easy to follow along:

http://www.databasejournal.com/features/mssql/article.php/3483931/SQL-Server-2005-Security---Part-3-Encryption.htm

you know you have to encrypt the entire string, and not just part of it right?

so...

tomas i learned something with this, thanks; i never get to use xml/xquery at work, so all my experience comes from testing ehre; your code gave me what i needed.

this...

rik there must be more to joining the families of parts;

if it was just that SVD matches XVD, then if i have ten rows in PartSubFamilyA, and only one row...

the TOp command is working for me to limit this example;

I couldn't use what you had posted, soemthing about the schema...

try this example with and without the TOP;

i get 3...

datetimes are not stored in that format, it just happens to be the default way your regional settings are presenting the datetime. they are actually stored in numeric formats behind...

use the row_number() function in an inner query, and have an outer query have the alias'ed columname for rownumber e the specific value:

select * from

(

SELECT row_number() over (order...

jeremy you'll want to left outer join the two tables;

by checking a third column in the table, you can find which items in tableb do not exist in tablea

this example...

well, you could infer it is fname.lname by counting the number of periods left of the @ symbol:

declare @email varchar(1000)

set @email = 'firstname.lastname@freehills.com'

select SUBSTRING(@email,1,CHARINDEX('@',@email)),

REPLACE(SUBSTRING(@email,1,CHARINDEX('@',@email)),'.',''),

LEN(SUBSTRING(@email,1,CHARINDEX('@',@email))) - len(REPLACE(SUBSTRING(@email,1,CHARINDEX('@',@email)),'.',''))

firstname.lastname@ ...

also another thread looking for the same issue, and everyone agreeing it's not possible withought jumping to poweshell or wmi, but with a better explanation than mine:

http://www.sqlservercentral.com/Forums/Topic905937-146-2.aspx

you need to do IP\Instance, or IP,port for the servername: you need to know which port the express is using;

192.168.1.100\SQLEXPRESS

192.168.1.150,1744

i think this script will help find the listening port:

CREATE TABLE...

no way to get the logged in user than i can think of so far;

xp_cmdshell gave me this as a result of whoami:

create table #Results (

LinesFromCmd varchar(1000))

insert into #Results (LinesFromCmd)

exec...

ahh i see what you are after;

if you login to SQL with SQL authentication, your windows login information is not used, and would not be available i think;

if you login...

changing the model won't make any difference in the growth, i think; millions of rows of logging to undo the operation just in case it fails will occur regardless....

do your updates in batches; after each batch, the simple recovery model will checkpoint, and will prevent the log from growing out of control;

the key piece is you need a...