Writing your own extended procedure?

What difference should that make?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Here is your first question and my reply

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

Frank

http://www.insidesql.de

http://www.familienzirkus.de

And hopefully one day I'll learn to post the correct link

http://support.microsoft.com:80/support/kb/articles/q186/1/33.asp&NoWebContent=1

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I like these 'easy' questions

Check this out http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q186/1/33.asp&NoWebContent=1

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Getting back to the original question I think http://www.lockwoodtech.com has a similar product.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

One reason might be that UDF are processed row by row which might be the reason that things are slowed down.

Have you compared the execution plan of both alternatives?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

It is always difficult to say what is the 'best' way.

For me the 'best' way is to use ADO and the ADO Stream object. SQL Server offers a tool...

quote:

---

There are SQL conventions. I have not been to one, but I do know they exist because they send me a...

Something like this?

http://www.sqlservercentral.com/scripts/contributions/593.asp

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Why does it need to be a new table?

Can't you just use an additional datetime column to store the information and query this.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Edited by - Frank kalis on 12/08/2003 ...

You mean extending the built-in SQL commands?

I don't think so, however you can always write your own function.

What do you want to do?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Hey, did you get promote by this post?

That's a rather pessimistical picture, I think.

I have heard of computer freaks who are still able to communicate with...

As for transactional backups look at

transaction logs->backing up->Transaction Log Backups

Basically it all boils down to

BACKUP LOG

RESTORE LOG

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Hit the button too early...

Sorry, for replying now. I lost track of this thread and missed your last reply.

Let me start by describing what I do here.

- Each night a...

That's what I first thought, too and that's where my lack of english leaves me insecure.

Let's wait and see.

Frank

http://www.insidesql.de

http://www.familienzirkus.de