it depends on the encryption algorythm;

many encrypt to varbinary, but some others can encrypt to varchar/nvarchar for the encrypted values (AES =varchar, for example),

SQL's built in...

what does not working mean?

you are showing something from excel that you pasted...that doesn't have anything to do with SQL errors or not working as expected or anything., though...

help us...

TOP 1 isn't useful without an ORDER BY.

if you run this:

SELECT * FROM table

where psp_item_no = 'DRR07DFAB0034'

AND psp_ps_no = 16

how many rows show up? if there is more...

nested replaces is the way to do it...same as you started:

replace(replace (xxx,"'","^") ,"""","^")

if you have physical access to the server(laptop?), the first thing to do is right click SSMS...run as...administrator and see if that gets you in.

after that, you might need to...

a trigger runs with every update of course, but the action that it does inside might be limited based on some logic.

also you've got to consider multiple rows in a...

try like this:

insert into ##tmp (ColumnListMatchingsp_dependsOutput)

EXEC (@sql)

if you identify the specific columns, you can have more columns in the table than the proc would insert.

SQL 2005? is this 64 bit or 32 bit?

there is no default order by.

without an ORDER BY , ther eis no guarantee the data is returned in any order.

sometimes, by coincidence, the data is returned in the...

it kind of sounds like some dynamic sql and using sp_sendmail would do the trick, just as Welsh Corgi suggested; i'd like to see a little more detail, like a...

here's my quick take.

1. Rebuild Indexes - good.

2. Update Statistics - only for those columns NOT participating in an index, since the Rebuild of the Index takes care of the...

i cannot think of another way to do it easily; row_number makes the join simpler, but you could join two copies of the tables together based on the name ...

no way to do types, views , procs or functions automatically...you have to edit them and make their definitions find-and-replace ready for editing.

the originals typically may reference items in the...

the list is a list of all ODBC drivers installed and registered on the server .

the ace driver gets installed when you install this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d

it might also be installed if you...

looks like you are missing another function: dbo.weeknumber