Hm, why only does HOST_NAME() return my workstation name?

select host_name()

--------------------

WST3XXXXXX

(1 row(s) affected)

you insert the null value in datetime data field , it insert the 1900-01-01 00:00:000 value it not insert the null in this field.

This is not correct! However, SQL Server...

Thanks! There is more than one way to skin that cat. However, native T-SQL support for this is on my personal wishlist.

Doh, thanks for this -n 1 !!!

I would stay away from query hints and begin by examining execution plans, indexes...

See, if this helps:

set nocount on

declare @ip varchar(255), @cmd varchar(100)

set @cmd = 'ping ' + HOST_NAME()

create table #temptb (grabfield varchar(255))

insert into #temptb exec master.dbo.xp_cmdshell @cmd

select @ip...

You forgot to mention what front-end you use.

If you're doing this in ASP, something like this should work:

...

Response.ContentType = "application/msword"

Response.BinaryWrite oRecSet.Fields("img")

...

This will open up Word and Word is creating...

Well, at least Yoda is wiser than Smeagol, though I can't remember what Yoda usually eats. Think it might be better not to dive too deep into that topic anyway...

Hm, do you suspect that this place is infiltrated by those guys from Star Wars?

And now this "far too much" will increase exponentially with this and other language additions

Maybe, maybe not. Who knows in advance? I'm not the person to talk things bad, before I've...

"She who must be obeyed" (the wife - and yes I stole that from a British Lawyer show...) is better at finding these trips than I, but I gave her...

This should kick every user out of the db:

USE PUBS

--The friendly method:

ALTER DATABASE Pubs

SET SINGLE_USER WITH ROLLBACK AFTER 15 SECONDS

--The not so friendly method

ALTER DATABASE Pubs

SET SINGLE_USER WITH ROLLBACK IMMEDIATE

--After...

A dear friend of mine, once gave me this link. He likes to stay there regularly:

http://www.villalady.com/wflacasita.htm

Hey, my company has the slogan (amongst others)

"Leading by example" (hope I can say so)

Without DDL this is perhaps only a shot in the dark. However, take a look at BOL for GROUP BY and MAX. Should do the trick.