i have this snippet saved from SQL 2000, which is supposed to add back Builtin\Administrators if it was removed;

i ran it on my SQL2008 without errors, but that doesn't technically...

ahh good point Ian; forgot about that one;

i just tested, and if anyone is connected, you need to kick them off with Ians command as well:

ALTER DATABASE [SandBox2000] SET OFFLINE...

here you go:

http://www.lmgtfy.com/?q=trigger+types+in+sql+server+2005

http://msdn.microsoft.com/en-us/library/ms189799.aspx

general, generic questions like this are probably best suited to a google query rather than asking a forum and waiting for an answer.

you don't really shut down a database, but you can kick everyone off so you have exclusive access; you might do that so you can restore the database, or detach...

I think packet size is a TCP/IP limitation; it's not really related to the program that sends the data(ie Word, SQL 2005, MYSQL,etc)

For Ethernet LAN/WAN, max packet size is 1500...

this was an order of magnitude faster: 8 minutes to create a text file to disk, then 20 seconds to bulk insert into a table

using the /b command, it was...

here's something to get you started. Assuming you've enabled xp_cmdshell, and the SQL service is using credentials that can see the program files folder, this command would give you a...

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...