No error messages. All was done silently. But I installed only sample MDX application.

Now I have won this situation by using Terminal Services Client on Win98 instead of installing...

Thanks to davidf for a time he spared to learn me how to behave myself

It is not an answer. When you create new SQL Server registration in Enterprise Manager, it shows all SQL Servers, visible in LAN, without any login.

they say, that Yukon will allow such functions. Is it so?

Thank you. When I asked this question I suspected that I have no chances, and knowing a litle about writing DBMS, supposed, that only way is to update DBMS source...

quote:

---

Writing your own extended procedure?

What difference should that make?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

---

You ask questions...

quote:

---

I don't think you can create functions like SUM,Count with UDF.

---

It seems me so, but...

quote:

---

Yes

BOL

CREATE FUNCTION

Creates a user-defined function, which is a saved Transact-SQL routine that returns a value. User-defined functions cannot be used to...

I'm very grateful to all who answered

Thank You

I'm very grateful to DALEC and scrilla99

try this function:

CREATE FUNCTION dbo.k_LastOfMonth(@Year int, @Month int)

RETURNS datetime AS

BEGIN

declare @Year1 int, @Month1 int, @d datetime

declare @s-2 char(8), @Month2 char(2)

set @Year1=@Year

set @Month1=@Month+1

if @Month1>12 begin

set @Month1=1

set...

Take the 1st of next month and subtract 1

quote:

---

You may have to generate a script larger than intended and then extract the bit you want.

In EM, right click on DB...