Or have a third party tool like Lumigent LogExplorer.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

SELECT @@version is just fine.

See http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=18417

You can compare your result with this here http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yes, there is only a datetime data type in SQL Server.

However, you've already figured out that you can use two controls to separate this information.

Will this information be...

DECLARE @top NVARCHAR(4) --or more if needed

DECLARE @stmt NVARCHAR(200)



SET @top = '10'

SET @stmt ='SELECT TOP '+ @top +'drug_name, Count(drug_name) From Orders Group 

by drug_name Order by...

Why do you want to reinvent the wheel?

When you search this site, you'll find several threads, and I guess also scripts on your topic. However, I think, you should leave...

Ok, got me.

Should have tried the search first

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

See, I did change the title!

---

Yes, I see, but didn't post, because I don't want...

Did anyone ever tried this?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

AFAIK, from within SQL Server you're pretty much out of luck.

Server IP you should get with

declare @ip varchar(255)

create table #temptb (grabfield varchar(255))

insert into #temptb exec...

Something like

SELECT suser_sname(), host_name()

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Von Hilden nach Köln ist es ja auch keine Entfernung.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Take a look at DBCC PINTABLE in BOL

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Actually we do also have an SLA with an external Asset Management Company that does most of the plain vanilla trading for us. Leaving the interesting stuff with us.

We...

Hm...not sure if this is what you want, but a look at BOL for LSN might be helpful.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Two ways for this:

1. If you have your own webspace, place it there and place this link in the picture URL.

2. In http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=14402 Andy said, you could submit it to...