Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
diyagan
Starting Member
22 Posts |
 Posted - 2007-10-05 : 03:23:39
|
| hi,can any one suggest a data type that has length more than 8000.if i use text or ntext the database is showing error.eg:crete procedure fpcDeclare @var1 text,@var2 nvarchar(4000)error:The text, ntext, and image data types are invalid for local variables. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-05 : 03:58:52
|
| Why you want to do that? What exactly you are trying to achieve?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-05 : 04:09:07
|
| Are you trying to pass array of data to procedure?MadhivananFailing to plan is Planning to fail |
|
|
|
diyagan
Starting Member
22 Posts |
Posted - 2007-10-05 : 05:07:35
|
| i am not passing array to the procedure.i want to store the contents of one new procedure in a variable and i am processing it .the contents of the new procedure is long and so characters only upto 8000 is accepted .rest are truncated .i am not able to use text or ntext also plz help! |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-05 : 05:11:15
|
Why storing contents of proc in variable?  Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
diyagan
Starting Member
22 Posts |
Posted - 2007-10-05 : 05:17:02
|
| i am trying to decrypt a procedure which is encryptedthe code is here<stored procedure deleted by spirit1 since it violates site policy on hacking sql server> |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-05 : 10:43:25
|
| if you're working with sql server 2005 you can use varchar(max)so are you saying you cracked the encryption used by sql server?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-05 : 12:07:03
|
| ok i've seen you've changed your username to post the same question that we told you won't get help with since it violates the policy.i'm locking this thread and deleting the proc post._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
data type