Under SQL Server 7 there isn't anything like it. Under SQL Server 2000 there is the INSTEAD OF trigger. Here's a bit about them from Dr. Moreau:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01a17.asp

K. Brian...

This can be done using Dynamic SQL and EXECUTE or sp_executesql. Something along the lines of:

CREATE PROC usp_Dynamic

@dbName nvarchar(25),

@tableName nvarchar(25)

AS

DECLARE @SQLString nvarchar(500)

SET @SQLString = N'SELECT CustomerID, ContactName, ContactTitle FROM...

With Yukon supporting the .NET framework, it's not the applications with code in different languages talking to SQL Server that bothers me so much as it is the fact that...

If you're having to delete a range, the TRUNCATE TABLE is out, as it drops everything at once. Are you deleting in block, say:

DELETE FROM MyTable

WHERE MyID BETWEEN 2000000...

Login at the console to the SQL Server.

Go to a command prompt.

Execute the command: netstat -an

You may have to a | more if it scrolls off the screen (likely).

Can you...

Is SQL Server grinding to a halt or the server itself (OS, et. al,). If it's just the SQL Server, a temporary solution until you find out why Component...

If you use a three part naming convention within the structure of your stored procedure, it'll hit the right table. For instance:

CREATE PROC usp_GetCustomers

@City nvarchar(15)

AS

SELECT...

I'm assuming your SQL Server box is on a separate server from your IIS server. If that's the case, make sure that you've chosen a Net-Library other than Named...

If your active portion of the log is towards the end of the log, you aren't going to be able to shrink it very much. Here is a Q...

OK, let's start from the ground up. I apologize if you've already tried this.

Can you ping the database server from the application client system?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Yes, create a trigger that fires on INSERT. As long as the table doesn't have any text, ntext, or image columns, you can use the inserted temporary table to...

Have you tried creating an ODBC connection to the IP address (selecting TCP/IP as the NetLib) as opposed to the server name?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

I know you specified a database, but it almost sounds like it's not at the correct one. The sysobjects table is in every database. Try and execute the...

With SQL Server 2000, you have the option of putting certificates from a public certificate authority and connecting via SSL. For both SQL Server 7 and 2000, there is...

Are you receiving a server not found/access is denied error? Can you connect to the server through another client application such as Access using ODBC? Can you create...