Deployment Process

Technical Article

RE: Question of the Day for 31 Mar 2004

  • Reply

I understand about callbacks.  I also understand that you will (likely) never have callbacks from SQL server, especially to a web application.  From a web application, all queries to SQL server will (likely) be synchronous, and SQL Server will never on its own ask to establish a connection to the web server.Let's say the web […]

2004-03-31

Technical Article

RE: sql server log

  • Reply

I am more for turning it off and, if there's a particular need for it, using a scheduled profiler trace to gather the required successful login info. A trace can be directed to a new trc file daily, can be filtered, can return more (not much more) info, and keeps the SQL logs to a […]

You rated this post out of 5. Change rating

2003-07-02

Technical Article

RE: SQL Server Agent fails to start - no error msg

  • Reply

Hi Csaba, quote: Frank: I think this is the only thing left that I will try. I will reinstall the server. The only problem that it's in Romania (I'm in Hungary) and lot of people are working on it. However I can't do anything else than completely reinstall it. reinstall should only be the last […]

You rated this post out of 5. Change rating

2003-06-20

1 reads

Technical Article

RE: UpDate using T-SQL

  • Reply

If I understand you here, you want to update a single row in a table, but you only want to change certain fields, and the fields that you want to change can be different each time? Here is a (inefficient and horrible) way to achieve this. Basically you pass in the ID of the row […]

You rated this post out of 5. Change rating

2003-06-20

Technical Article

RE: how to call stored procedures of SQLServer

  • Reply

You need to move your module code into a asp file. I've never seen a VB class module being used within asp. If you convert your module to a DLL you can instatiate it and pass values and call its methods. What you're trying to accomplish could be possible in a .NET framework. but I […]

You rated this post out of 5. Change rating

2003-06-10

Technical Article

RE: Workaround for DATEDIFF

  • Reply

SQLServer has Sunday as day 1 of the week, so if you want your week to start on Monday, it can be a pain. I had a similar problem a few years ago. I set up a simple two column, 7 record table, with the SQL Server numeric day of the week, and the numeric […]

You rated this post out of 5. Change rating

2003-05-07

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers