Henk Schreij (10/27/2009)

---

Sorry, the table is a "not owned by myself".

So I can't convert the NText column to a NVarchar(max).

And the 'large value types out of row' is set to...

ahh your right...you can change to varhcar(max), and make things bigger than 8000, but only in 8000 chunk bites.

here's my test code;

create table MyTable (

MyTableId int identity(1,1) not null primary...

works fine for me when i use a convert to varchar(max):

--pad my table with too much whitespace

update MyTable set myTextColumn = isnull(convert(varchar(max),myTextColumn),'') + replicate(' ',10000)

--use rtrim to get select without...

you can't, at least not directly. Javascript and HTML cannot run code on a server.

you can use asp/asp.net/php to receive information from the submit of a form, and the server...

there is this command:

Grant View Any Definition To MyUserGroup

but there is nothing granular, so if you wanted to do, say grant view definition of procs but not views and functions,...

AFAIK, since the local service account never logs into the network/domain, it could never get to a remote share; I thought that even if you open a shared folder ...

sounds kind of like a DNS error more than anything; from that server in question can you ping 174.21.10.12?

UT- (10/26/2009)

---

Hi,

My SQL Server Service & Agent Service are running as Local Service Account. I have a job that needs to get a file from a remote shared folder, but...

to expound on Adi's point, the defered name resolution is for objectnames..table/proc function/etc,.

if a table exists, but a COLUMN you reference does not exist, then it won't compile...

so if your...

here's an example I hope helps you visualize it:

you want to try to give users only the rights they need.

use [SandBox]

--grant select/insert/update, but Not Delete to a specific table

CREATE ROLE...

i've got this saved in my snippets, but it would add only two decimal places, not three...does that matter to you?

results

@test-2 formatted

7265342 ...

Ranga it doesn't matter which account YOU logged in with.

when SQL server tries to access anything outside of the SQL instance(xp_cmdshell, files/folders/, network shares, anything outside of it's own databases)

it...

tan110 (10/23/2009)

---

Scripting help - Need a query to find filenames and filepaths under a certain directory.

I need the results to be something like this:

filepath ...

i don't think this should be checked...that means use https: or whatever the equivilent is...

change your screen resolution;

I've had that happen to me in visual studio, where the find and replace comes up as an undocked window, and gets tossed to a point that...