Search results for query: *

I can make this work in Query Analyzer by changing the @vPge_Text to 'text blob here' But when I pass the blob into the variable from a stored procedure I get an error

ignore this line This is if you want to store small text on the same row page. EXEC sp_tableoption 'PAGE', 'text in row', 'on'

Sorry Andy, I had to go onto another problem and forgot about my post. Not sure about "Script Object-Level Permisions" in script How do I set permissions for each object that is created. I thought by creating the login and running these stored procedures, it would set all the...

I keep getting this error when trying to update a large text field. I understand that you can not use the normal insert or update with larger blocks when using ntext, text, and image fields. Script: Error #-2147217887 [Microsoft][ODBC SQL Server Driver]String data, right truncation I found...

I have a script that creates database, tables, and stored procedures, populates tables, creates login/user. The script creates the database, tables, stored procedures, inserts data, and creates login/user. ok no errors. The login/user acts like it doesn't have permissions. So I drop the...