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
Showing posts with label ascii. Show all posts
Showing posts with label ascii. Show all posts
Thursday, March 29, 2012
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
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
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
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
Subscribe to:
Posts (Atom)