Showing posts with label ascii. Show all posts
Showing posts with label ascii. Show all posts

Thursday, March 29, 2012

How output all Stored Procedures to a table or file

I wish to ultimately have the content of all stored procedures related to a database in a single ASCII file for review. Is that doable? If so, how?
Thanks,
PeterRight-click your database in Enterprise Manager, select All tasks, Generate Sql script, there you can choose All stored procedures and other objects/options. mojza|||Fantastic Mojza - thanks for the help!

Peter|||Along this same line, this is what we do in order to generate script files that we then place into SourceSafe for version control. I am just learning that end of the department's process, but it seems to me I see stored procs at the system level for version control stuff, but need to look farther into that to see what other stuff we might use.

The script-to-VSS solution seems cheesy to me, but without taking this to be a "How do I do it" question, I'd just like to ask, is there an easier way? I can go look in BOL, but just saw the thread and was reminded of our local cheese factory, so thought I'd ask for quick-n-dirty impressions.|||Use VBA with SQL-DMO (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_con01_2yi7.asp), possibly within DTS (http://msdn.microsoft.com/library/en-us/dtssql/dts_basic_5zg3.asp)?

-PatP

Friday, March 23, 2012

How Many VarBinary for each Ascii Char Aes Encrypted KeySize=256,BlockSize=256

Hi. I'm wanting to encrypt customer name, address, etc. information using
Aes with a KeySize of 256 and a BlockSize of 256. Either for each ascii
character or say for a maximum length 50 characters for a field, how many
bytes will this generate and how do I translate
this into the number of VarBinary ?items that I allocate in my Sql Server
2000 table?
Phil
Boston, MA
It is character by character; so, a byte is a byte is a byte. VARBINARY is
byte by byte; so, VARCHAR(2) is VARBINARY(2). So, is your AES algorythm
fixed-length or variable?
Sincerely,
Anthony Thomas

"Phil C." <charlestek@.rcn.com> wrote in message
news:uPzGjKuGFHA.2360@.TK2MSFTNGP12.phx.gbl...
Hi. I'm wanting to encrypt customer name, address, etc. information using
Aes with a KeySize of 256 and a BlockSize of 256. Either for each ascii
character or say for a maximum length 50 characters for a field, how many
bytes will this generate and how do I translate
this into the number of VarBinary ?items that I allocate in my Sql Server
2000 table?
Phil
Boston, MA

How Many VarBinary for each Ascii Char Aes Encrypted KeySize=256,BlockSize=256

Hi. I'm wanting to encrypt customer name, address, etc. information using
Aes with a KeySize of 256 and a BlockSize of 256. Either for each ascii
character or say for a maximum length 50 characters for a field, how many
bytes will this generate and how do I translate
this into the number of VarBinary ?items that I allocate in my Sql Server
2000 table'
Phil
Boston, MAIt is character by character; so, a byte is a byte is a byte. VARBINARY is
byte by byte; so, VARCHAR(2) is VARBINARY(2). So, is your AES algorythm
fixed-length or variable?
Sincerely,
Anthony Thomas
"Phil C." <charlestek@.rcn.com> wrote in message
news:uPzGjKuGFHA.2360@.TK2MSFTNGP12.phx.gbl...
Hi. I'm wanting to encrypt customer name, address, etc. information using
Aes with a KeySize of 256 and a BlockSize of 256. Either for each ascii
character or say for a maximum length 50 characters for a field, how many
bytes will this generate and how do I translate
this into the number of VarBinary ?items that I allocate in my Sql Server
2000 table'
Phil
Boston, MA

How Many VarBinary for each Ascii Char Aes Encrypted KeySize=256,BlockSize=256

Hi. I'm wanting to encrypt customer name, address, etc. information using
Aes with a KeySize of 256 and a BlockSize of 256. Either for each ascii
character or say for a maximum length 50 characters for a field, how many
bytes will this generate and how do I translate
this into the number of VarBinary ?items that I allocate in my Sql Server
2000 table'
Phil
Boston, MAIt is character by character; so, a byte is a byte is a byte. VARBINARY is
byte by byte; so, VARCHAR(2) is VARBINARY(2). So, is your AES algorythm
fixed-length or variable?
Sincerely,
Anthony Thomas
"Phil C." <charlestek@.rcn.com> wrote in message
news:uPzGjKuGFHA.2360@.TK2MSFTNGP12.phx.gbl...
Hi. I'm wanting to encrypt customer name, address, etc. information using
Aes with a KeySize of 256 and a BlockSize of 256. Either for each ascii
character or say for a maximum length 50 characters for a field, how many
bytes will this generate and how do I translate
this into the number of VarBinary ?items that I allocate in my Sql Server
2000 table'
Phil
Boston, MA