Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

Encrypt And Decrypt Text Format Data

We have migrated a CRM Database from SQLServer 2000 to SQLServer 2005.


Database contains very sensitive data about customer in text format (Datatype varchar(20)) how can i encrypt the same without any change in the table design.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Encrypt/decrypt Data
We like to secure datas.
Only a few people are autorized to read this information, but today, these informations are readable with a simple query with a query analyzer for exemple.

I'd like to encrypt datas with reversible function in one field of a table

Is there a function able to do this kind of work in SQLServer V7 or 2000 ?

View Replies !   View Related
RC4 Encrypt And Decrypt
Hi Guys.

I am looking for TSQL code for RC4 encryption and decryption.

I found VBcode for RC4 encryption, it will take atleast 2 days for me to go thru that and rewrite the whole code in SQL.

If anyone has the code, please provide me.

(I know sql does accept extended ASCII characters)


View Replies !   View Related
Encrypt On CLR Decrypt In SQL?

Hi folks,
I'm trying to encrypt a small token of data on my client c# application and have it decrypted by SQL on the server side, the problem is i cannot find articles on the subject. I don;t really want to get involved with certificates but base the system on a simple symmetric key that is shared by both parties.
I'm attempting to use the TRIPLE_DES algorithm on both sides and thus far have used the decryptbypassphrase on the server side with the data encrypted on the client side by .Net with no initialization vector setup.
If anyone can recommend any articles or have example (client and server side) code for this situation it would be greatly appreciated.
Many thanks in advance

View Replies !   View Related
Encrypt In .net, Decrypt In Sql
Does anyone know what my .net app guys need to share with me if encryption was done in the .net app but decryption needs to occur in certain sql queries?  I read about master keys, certificates, symmeteric keys, algorithms etc but dont know how that stuff would carry over from the framework into sql.  All I know is that the algorithm is AES_256, they must be adding authentication to the encryption and i know the hash algorithm,  and symmetric keys are involved.   Will they be sharing certain kinds of files with me that need to be registered in the db?  Will I have to use CLR if I want the two worlds to come together? 

View Replies !   View Related
Encrypt/decrypt MS SQL 2005
hi guyz!! is it posible to ecnrypt data everytime i insert it to a table and decrypt it everytime I select it using the MS SQL 2005 alone?

like for example i have this query statement below

insert username,password users values ('daimous','my_password')

what i want is every time i insert a value to the password column that value should be encrypted first.

select username,password from users

everytime i select the value of the password column should decrypted.
Thanks in advance!!!

View Replies !   View Related
Encrypt -> Decrypt Into SQL Server
Please help!!!!!!!
Is there are ways to encrypt data in the table (SQL Server 7) and then retrieve (decrypt) this information?


View Replies !   View Related
How To Encrypt And Decrypt My Password
in my login form i have the password i am sending password to my database table but while sending password has to be encrypted and while returning it has to be decrypted,is it possible to do in database if means please show me some example please

View Replies !   View Related
Encrypt/ Decrypt Network Traffic.
I can sucessfully encrypt/ decrypt 1 column, but Im under the impression there is also a way to encrypt the data being sent over the network by using a certificate? I can find lots of info, but no starting point or clear cut instructions. Could someone please assist?

TIA, cfr

View Replies !   View Related
How To Encrypt And Decrypt Stored Procedures?
I encrypt my procedures using with encryption clause, but I do not how to decrypt again.   

Is there a command or utility for encrypt and decrypt in Sql 2000? How about Sql 2005?



View Replies !   View Related
Users For Encrypt And Decrypt Purposes Only
Hi there,

Using symmetric keys and certificates in SQL2005, can one assign users permission to only decrypt or encrypt data?

Reason would be say data capturer and data reader type roles. I tried to create some with the GRANT CONTROL and GRANT VIEW for certificates and definitions on Symmetric keys, but havent been to successfull.

Would be great if someone here can offer some advise on it, and if it's possible using SQL rights.


View Replies !   View Related
SQL Server Encrypt/Decrypt With Key Management With PCI Compliance
We are going to implement our new applications with .net on MS sql and we have to make sure that SQL Server satisfies PCI Compliance, we€™re concerned with the following items from the PCI Standards Guide.
Could you please guide me that SQL Server 2005 satisfy this kind of functionality?
I am new for SQL server 2005 and i would like to make sure before we move into Microsoft platform and as i am heavily oracle guy.

PCI Standards Guide lines

==>3.6.4 Periodic changing of keys

€¢ As deemed necessary and recommended by the associated application (for example,

re-keying); preferably automatically

€¢ At least annually.

3.6.5 Destruction of old keys

3.6.6 Split knowledge and establishment of dual control of keys (so that it requires two or three

people, each knowing only their part of the key, to reconstruct the whole key)

3.6.7 Prevention of unauthorized substitution of keys

Thanks for your help and guidelines!

View Replies !   View Related
Keeping Text Format After Stored In The Data Base.
I want the users of my site to be able to write a couple of paragraphs, save it to SQL Server and then have it read back and look the same. I don't want the users to be able to add any html to the text they submit. I just want them to be able to seperate or indent their paragraphs.

At one point, I had a textbox that saved text to the server and read it back the same way it was originally inputed. However, I can't figure our what I had done to make it work.

Any ideas?

View Replies !   View Related
Encrypt A Text Or Varchar(max) Field
I understood that sql 2005 has EncryptByCert(varchar) function to encrypt data field. but varchar is limit by 8,000 chars long.

View Replies !   View Related
Exporting Data To A Comma Delimited Text File, FORMAT Function
Hi. Im new to SQL and I need to export a SQL table as a comma delimited text file which is straight forward. However two of the fields are integers and I need these to be right justified with zero's.
In Access I would use something like format(columnname, "00000000") to get it to work, but SQL Server doesn't like this.
How can I do this?

View Replies !   View Related
Db_datareaders Can Decrypt Data?
Hi... I want to encrypt data using a symmetric key + certificate, but it appears anyone with simply "db_datareader" can view the decrypted data? Is this correct?

Recreation steps:

1. As a System Admin, log into a SQL 2005 Database Engine.
2. Create some login that you also have access to. Ensure it does not already exist, or inherit any permissions from some existing NT-group. (From here on out, I will refer to it as the "underpriveleged user".)
3. Create a new database of any name.
4. Run the following query against the database:

CREATE TABLE [dbo].[MyTable](
 [MyColumn] [varbinary](50) NULL
sp_addrolemember 'db_owner', 'DOMAINUserName'

5. Now open another SSMS and connect as that underpriveleged user.
6. Change the database to the name you provided in Step 3.
7. Run these commands as the underpriveleged user...



INSERT INTO MyTable(MyColumn)
  VALUES (EncryptByKey(Key_GUID('MyKeyName'), 'MyValue'))
SELECT Convert(varchar,DecryptByKey(MyColumn)) FROM MyTable

8. Now switch back to the System Admin session, and revoke most of the underpriveleged account's permissions...

sp_droprolemember 'db_owner', 'DOMAINUserName'

9. Switch once again to the underpriveleged session, and run the following:

SELECT *, Convert(varchar,DecryptByKey(MyColumn)) FROM MyTable

Why does this work? The user only has select access against the table, and no explicit permissions to the certificate or key.  I have even disconnected as this user, tried again, restarted SQL Server... it is still able to decrypt the text.

Or what should I be doing to ensure only those with access to the key/certificate can decrypt the cipher text?

View Replies !   View Related
Data Encrypt
I am using sql server 2005, I want to encrypt data. If any person open the table then encrypted data will show.
I am saw 3 techniques
1) Certificate
please suggest me which technique is helpful.It will be impact on performance please suggest.

View Replies !   View Related
Encrypt Data
Hi All,
In SQL 2000, i need to Export Data,so that datashould be encrypted.When i try to import that in any database it should authenticate the user and should get decrypted.IZAT Possible.

Can any one help?


View Replies !   View Related
Encrypt Data

In SQL2000 i need to Encryptdata when I export data using DTS.LikeWise I should when i import data I should authenticate that user and decrypt that.

Can any one help?





View Replies !   View Related
Encrypt Data In Database
Hi,I have a .net application and i added a code that encrypts data saved in database. However, there is already data in the fields that was entered before this change.I know need to check if the values in those fields are encrypted and if not i need to encrypt them.How can I perform such a check and update the relevant data?I use TrippleDES in .net to encrypt/decrypt the data.Thanks

View Replies !   View Related
Encrypt Data Issue
Does SQL Server 2000 provide any data encryption/decryption functionality so that certain fields (e.g. SSN, Age and Salary) will be encrypted before writing into the table and decrypted once loading out of the table?


View Replies !   View Related
Best Approach To Encrypt Data?

I want to encrypt certain data like password, ssn, credit card info etc before saving in database. Also, this encrypted data can be queried using standard SQL statements like:

select * from users where userid=454 and password = 'encrypted data'

The mechanism to encrypt data could be in a .net application. The code that does encryption/decryption should also be protected so that it doesnt work if it falls in wrong hands.

Can anyone suggest what would be the best way to accomplish above?


View Replies !   View Related
How To Md5 Encrypt Data Using TSQL
how can i encrypt using md5 for encrypt my data using TSQL and from Enterprise Manager?

View Replies !   View Related
Encrypt Data In A Stored Procedure
I am trying to insert data in a table using a stored procedure, but somehow I cannot store the values passed by the stored procedure in the table.

Table has two fields FIRST_NAME, LAST_NAME with varbinary data type(I need to encrypt the data)

My stored procedure is as follows. Please let me know what i am doing wrong!


ALTER PROCEDURE [dbo].[SP_InsertInfo]
 -- Add the parameters for the stored procedure here

            @FIRST_NAME varBINARY(100)
           ,@LAST_NAME varBINARY(100)  



    -- Insert statements for procedure here

 Insert into [dbo].[INFO] (FIRST_NAME, LAST_NAME)
Values ( encryptbykey( key_guid('key'),'@FIRST_NAME'),
             encryptbykey( key_guid('key'),'@LAST_NAME')


EXEC sp_InsertInfo 'larry', 'Smith'

when I run the SP, the data stored in the first_name, last_name fields are @FIRST_NAME', @LAST_NAME' instead of larry, smith respectively.


View Replies !   View Related
Hash/Encrypt CSV To Lookup Repeating Data?
Hopefully this makes sense, not sure what to even begin researching...

I'm trying to optimize all facets of this process, as it will take over the resources on my server if not done efficiently.

I have CSV files containing INTs that I need to upsert (match to an existing/earlier imported array or create a new record set) millions of times a day. To be clear, this data is a small subset of the actual import, this arrays contents are not the main data of the process, and the value of the entire array is meant to be related to higher level tables.

The contents of the CSV array are 99.9+% repeating, meaning they will very often share the exact same contents as a a previously imported array. A rough guess is there are 20k combinations existing, and less than 1k new per month, and will range from 6 cols x 15 rows to 6 cols x 50 rows.

So current plan is to use a MD5 hash during the (not SQL related) export process to identify the contents of this CSV file, and export only the md5 (32 digit hex) as a lookup to identify the contents. If the SQL import process finds a new (unknown) MD5 it will request the actual contents, otherwise it will simply use the MD5 as a key/id/code for the actual array contents that are already stored.

There's probably a certain terminology I'm not familiar with for this type of thing.. I've never heard of something like this. I realize collision is a threat, but I'm unsure how much I should be worried about it with this type of data (similar size/contents, but a relatively small amount of possibilities). I think up to even 0.1% collision would be acceptable which is probably way more than enough.

Does this sound like a bad idea to anyone? Are there certain hash functions I should use for this type of thing? Anyone have suggestions of where to look next?


View Replies !   View Related
Moving Data From AS/400 To SQL Server 2005 Encrypt
I want to build a SSIS-package to copy data from as/400 to a sql 2005 database.
While this transaction the data should be encrypted.
How can I do this?

My idea:
I built two tasks 'Execute SQL'.
The first reads the data form as/400.
The second encrypt it and write it to SQL Server 2005 database with a stored procedure.
Thats works only for a resultset of a line of the first task.

How can I use a full resultset in a stored procedure to move whole recordsets?

View Replies !   View Related
I Want Ot Convert Xml Data Format Into The General Data Format
hi siri have table hh .it has two columnsone is hhno is integer datatype another hhdoc is xml data type likehh tablehhno hhdoc---------------------------------------------------------------------------------------------100<suresh>sfjfjfjfjf</suresh>....................................101<ramesh>hhfhfhf</ramesh> to convert the xml data format into the general data format plshelp me with examples

View Replies !   View Related
How To Encrypt My Password Or Sensitive Data Before Storing Them In A Database , Using SQL Server 2005?[urgent Plz Help]
Hi there ,1. i have a database and i want to encrypt my passwords before storing my records in a database plus i will later on would require to  authenticate my user so again i have to encrypt the string provided by him to compare it with my encrypted password in database below is my code , i dont know how to do it , plz help 2. one thing more i am storing IP addresses of my users as a "varchar" is there a better method to do it , if yes plz help me    try        {            SqlConnection myConnection = new SqlConnection();            myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["projectConnectionString"].ConnectionString;            SqlDataAdapter myAdapter = new SqlDataAdapter("SELECT *From User_Info", myConnection);            SqlCommandBuilder builder = new SqlCommandBuilder(myAdapter);            DataSet myDataset = new DataSet();            myAdapter.Fill(myDataset, "User_Info");            //Adding New Row in User_Info Table               DataRow myRow = myDataset.Tables["User_Info"].NewRow();            myRow["user_name"] = this.user_name.Text;            myRow["password"] = this.password.Text; // shoule be encrypted             //not known till now how to do it                       myRow["name"] =;            myRow["ip_address"] = this.ip_address.Text;                        myDataset.Tables["User_Info"].Rows.Add(myRow);            myAdapter.Update(myDataset, "User_Info");            myConnection.Close();            myConnection.Dispose();        }        catch (Exception ex)        {            this.error.Text = "Error ocurred in Creating User : " + ex.Message;        }  

View Replies !   View Related
Is It Possible To Format (Text) In This Way


   i want to display something is this fashion


     Roth 401(k) Contribution

            jfkajfkdjfdjfkdj ldkfdlkfl;dkfldkfld;fkdl


in a table row, but i am not sure how to do it. can some one pls give me some ideas.




View Replies !   View Related
Store Xml Output In Text Format
I have the following Query which gives the output in XML format.
select * from <Table_Name> For XML auto
I wanted to store this output in a .Xml file at my local machine.
I would prefer to have a proc when called generates the xml and stores it on the local m/c. Any ideas ?

View Replies !   View Related
Convert Text File Format
How can I convert a text file (.txt) into SQL in 2.0 ?  The sample of the file format is like that ...
    09/03/2007 08:41 "Fung, Kitty" Granted Access D1 Main 2354 111
    09/03/2007 08:42 "Ng, Jaclyn" Granted Access D1 Main 21906 18
    09/03/2007 08:42 "Leung, Agnes" Granted Access D1 Main 21920 18

View Replies !   View Related
Dependency Tree In Text Format?

I have a database of over 200 tables. I want to delete data in about 100 tables. It's hard for me to delete because there are so many dependencies. I wind up tracing each table until I find the end and then deleting backwards. Is there a script I can run where I can get a textual view of which tables are related to which tables (foreign key constraints). I don't want to hit 'display dependencies' on each table. I know I can look at logical diagram but with a database of over 200 tables, it is hard to look at it.


View Replies !   View Related
Change-Format Text To Date
I have a column of text 010208 that is suppose to be a date. How can I changeformat this column to read 01/02/2008?

Lisa Jefferson

View Replies !   View Related
Multi Format Text File
Hello. I am in the process of migrating an old app to SQL Server. The old app reads hundreds of different flat file formats. One of the more complex ones is a multi-format delimited file. For example:

01^Bob Johnson^123 Main St^Anytown^St
03^Gift Cert^Happy Birthday^$100

This file is delimited with the ^ character. Note that the first 2 characters identify the row type. All 01 rows have data in the format: Name, Street Address, City, State. All 02 have data in the format: Book name, price. Etc.

Any clever ideas on how to parse this? I tried setting it up as a flat file source with the ^ delimiter. It doesn't work - in this example it wraps the third row to the end of the second row and keeps adding columns to fill out the row.

The only option that I can think of is to pull the entire row into one long column, and then use a script component to manually substring each column out.

Any help would be greatly appreciated.


View Replies !   View Related
Wired Text File Format

I have a text file contains data extracted from security logs from from different servers. The format of the data looks like this

Header row


Detail row

ServerName,Security,Audit Success,Security,540,540,DomainUserName,20061231,13:36,2,Logon/Logoff,4,Successful Network Logon:

 User Name: UserName

 Domain:  Domain

 Logon ID:  (0x0,0xD4118FE)

 Logon Type: 3

 Logon Process: Kerberos

 Authentication Package: Kerberos

 Workstation Name: 

 Logon GUID: {4bcdc9b4-4caa-ce31-b202-459f1865a477}

 Caller User Name: -

 Caller Domain: -

 Caller Logon ID: -

 Caller Process ID: -

 Transited Services: -

 Source Network Address: XX.XX.XXX.XX

 Source Port: 0

If I tries to extract data as Delimited the columns are not containing the same data for each row as there are some wired characters in the "Description" filed.

How can I extract this data as proper csv file? If not is there a way to extract only ther first line in detail row as shown below

Success,Security,540,540,DomainUserName,20061231,13:36,2,Logon/Logoff,4,Successful Network Logon:

If I tries to extract as Fixed Width, it still not work. Kindly suggest, How I can achive this.

View Replies !   View Related
How To Get Report In Text Format In SSRS?
Can aybody help me in the below requirement.
I have a report like below:

<<Name Of Compnay>>
<<Name Of Report>>
<<Todays Date>>
<<ReportPeriod>>  From Date - To date
The above is header and then the data in the report should come as the <<Data>> and # to be used as separator for columns.
 163   #GXXX #ABC Comp Ltd.                             #DTDC#PPPP ABC XYZ ETC #111

*End Of Report*
How can I get this exported as it is to the .txt file?
Currently I have acheived this with SSIS, where I have kept the header template, footer template in my folder. The SSIS generates the .txt file and then I use the execute process transformation to merge the files and data. I am getting the exact o/p as I want. But in this I am intorducing lot of IO in the package by every time creating a new header for the data to be replaced as todays date and the period to be replaced by the user selected Report Period.
How can this be achived using SSRS? Is any custome code required?
Thanks in advacne for your help.


View Replies !   View Related
Format Text Box With Parentheses If Negative
The users want to see negative values like this:




How do I format negative values that way without some major iif statement?

View Replies !   View Related
Writing Text Document In Unicode Format
Dear expert friends,
Im writing a stored procedure to write data in to a text file from SQLServer.
How do i ensure that the data is in Unicode format (UTF 8)

Your help is appreciated

Thanks in advance!


View Replies !   View Related
Query String Field Based On Text Format
I need to search a nvarchar field based on the format of the text.  This field holds values in two formats: 000 000 000 000 and 000000.   I only want to search through the records that are in the 000 000 000 000 format.  Can anyone give me direction on how to go about doing this or give me some key words to search for on Google?  Fixing this problem is not an option.  This is a county tax DB from a poor county with almost a million records in it. 
 Thanks for the help!

View Replies !   View Related
Load Text File In AMERICAN_AMERICA.WE8ISO8859P15 Format
Hi to all,
i've a problem, legacy system (unix) send via connectDirect weekly to my file system where is mounted ms sql server 2000 extraction data files. This files are stored in AMERICAN_AMERICA.WE8ISO8859P15 really iso8859-15 format (Latin 9). I want to load in DB staging area correctly because data arrived from Poland, Italy, Turkey and Brazil and content descriptions in different language.
I think to use DTS and set in source text file all files, but i can't set codepage textfile to read correctly description and save on DB in nvarchar, ntext, ecc... (UTF-8) :eek:
Exists a solution like convert in Latin1 or set a codepage and collation on SQL server. Another problem is this data will be presented on web application in UTF-8. :eek: :eek: :o :o

Waiting your news

View Replies !   View Related
BCP And Treatment Of NULLs When Export To Fixed Format Text File
We are using the bcp utility (via APIs) to export data from a SQL tablein a fixed format text file. BCP is inserting spaces for a field ifthe field contains a NULL. This is fine with us except at the end ofthe line, there are no spaces for that field just the end-of-rowterminator prematurely, so it looks like that field is not present andmesses up another piece of software we pump the text file into downstream.Example -- The last row illustrates the problem.123-49-890 Mary Smith Raleigh NC
999-88-123 Henry Ax Boston MA
456-99-123 Sue Kite WA
789-88-126 Andy Yates Philadelphia
We have thought about using a SQL query to convert the NULL dataexplicitly to spaces, but were wondering is there a switch or somethingin our format file to get around this.Thanks.

View Replies !   View Related
How To Align The Text In Justify Format With SQL Server Reporting Services?

        How to align the text in justify format In SQL server Reporting Services? Is there any code to do so?

View Replies !   View Related
The Report Server Cannot Decrypt The Symmetric Key Used To Access Sensitive Or Encrypted Data In A Report Server Database

Hi every one,


I'm very new new at this.  I'm try to deploy a report model and got this message.  I have no idea what its going on about.


Can anyone help me?





System.Web.Services.Protocols.SoapException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> Microsoft.ReportingServices.Diagnostics.Utilities.RPCException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: Bad Data. (Exception from HRESULT: 0x80090005)
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Diagnostics.DataProtection.ProtectData(Byte[] unprotectedData, String tag)
   at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
   at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
   at Microsoft.ReportingServices.Library.DBInterface.GetAllConfigurationInfo()
   at Microsoft.ReportingServices.Library.RSService.GetSystemProperties(Property[] requestedProperties)
   at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values)
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values) (System.Web.Services)



View Replies !   View Related
Replace Text/data In One Table With Corresponding Text/data From Another
Hi -

I've never used SQL for anything but simple copies and queries, and now I need to do something that's probably simple, as well, but I don't know how to start.  I need to update values in a text field with new values from another table.  I can do it individually with an update statement (Set [field1] = 'newvalue' where [field1] = 'oldvalue').  But I have 400 different values and a bunch of different tables that need to be updated, and can't imagine that's the only solution.  I can make up a simple table that will have all the old values in one column, and the new values in the next.  I need a statement that look at the old value, then fetch the new value from the table I made, and replace the old value with the new.

I've looked at various help files and tried to search for a solution elsewhere, but I'm not coming up with anything.  I guess I just don't know where to look.  Thanks in advance for any help you can give me.


View Replies !   View Related
Error: The Data Types Text And Text Are Incompatible In The Equal To Operator.
I get this error:
The data types text and text are incompatible in the equal to operator.
when trying to execute this query
SELECT id FROM users WHERE username=@userName
Any Ideas?

View Replies !   View Related
Managing Ntext, Text With A Long Text Data
Hi,I have a problem to insert(update) a long text (more than 64K) intoSQL 2000 (datatype - 'text'). It cuts the data and insert only 64K.MSDN says: "When the ntext, text, and image data values get larger,however, they must be handled on a block-by-block basis. BothTransact-SQL and the database APIs contain functions that allow applications towork with ntext, text, and image data block by block." Could somebodygive me an example how to do this, please.Thank you

View Replies !   View Related
Data Format Issue While Importing Data From Excel To SQL


when i m importing data from excel to Sql using DTS the column which has text content was not imported as same in excel sheet. whereas a special character is appearing in between the lines. the text field contains multiple lines but the conetent is imported in single line .



but i m getting imported

as :

How to Format a single column while importing?                                              




View Replies !   View Related
Truncated Text In Text Data Type
We have a text field which is being written to from a java app through JDBC-ODBC. But the data seems to be trucated in the DB. How do we store all the data in this field (the text being stored can be quite large) without it being truncated?

View Replies !   View Related
Text Is Getting Cut After 1.4k Letters In Text Data Type
Hello all,
started working on a website in ASP that use mssql, i am trying to store large ammount of text, for now its just 10kk letters, the data type is set to text in the mssql db, but when i read it back from the db, i only get 7.7k letters, i know its not an ASP problem cause i print the var holding the content before storing it in the db.

my question is, is there a way to change the text length limit in mssql, or use another data type?

Gilad Darshan

EDIT: forgot its saving the html source with the style and not only the words. fixed to the right amount of letters

View Replies !   View Related
Could Someone Decrypt This?
hi all,
i have this password column that i ve no idea how it's been encrypted... i need to come out with encrypt and decrypt function for this string :-

is it possible to decrypt this when i dont have the password string? if not possible then i will try to get the password string so that any experts here could help me to come out with the encryption and decryption function.

thanks guys

~~~Focus on problem, not solution ¯(º_o)/¯ ~~~

View Replies !   View Related
When I run the package it gives the following error warning.
Not sure how and where to fix this.
P.S. The package runs successfully and loads data but not sure why I get this error.
Error: 2007-08-29 06:00:13.70
   Code: 0xC0016016
   Description: Failed to decrypt protected XML node "DTSassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that
 the correct key is available.
End Error

View Replies !   View Related

Copyright © 2005-08, All rights reserved