I have used SQLDMO extensively (SQL2000) in an app I have just finished developing. I am now trying to make an install for Win2000 and am having troubles. I have followed the guide in the redist.txt file on the SQL Server CD as follows: sqldmo.dll (reg. by extracting com info) sqldmo.rll (in app path folder) […]
2001-08-27
165 reads
I have table A with three fields. Emp_Code Char(3), Emp_Name varchar(15), Policy_Change_Date datetime GetDate() . If any one record changes in table A, i wish to get the system date into the Policy_Change_Date. How will i create this trigger?
2001-08-27
2 reads
Anybody getting inconsistent errors when running sp_sendmail through a DTS Job? I get a DR Watson on agent.exe which then closes.
2001-08-27
3 reads
Are there any major disadvantages in running SQL 2000 on Win NT 4.0 vs Win 2000? Will you still see a performance gain (for multiple CPUs) on Windows NT 4.0? Thanks Jay
2001-08-27
2 reads
I am attempting to import data from one SQL Server to another by linking both SQL Servers together and running a query using the 4 part SQL object name. The SQL Servers are situated over separated networks, this being 2 separated VLANS. For security reasons I wish only to connect over a single port (say […]
2001-08-27
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/products/sqlinsider
2001-08-27
5 reads
In most tables it is enough to have a stored procedure that performs Update Else Insert logic for data managment. However, in some cases we do not want to destroy the old data with an update statement. Instead we want to maintain history up to a certain number of versions. This article presents a method for doing so.
2001-08-27
3,218 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/bknight/review:rentageekbookwithiqreference.asp
2001-08-27
1 reads
Dear Forum, Does anybody have detailed, comprehensive documentation, or URL for configuring SQL Mail to communicate using Lotus Notes R5. Thanks In Advance. John
2001-08-26
4 reads
I just needed a help from you. The problem that I am facing is that I am not able to use the output variable of sp_A into sp_b. sp_A: output variable X, input variable Y sp_B: Line 1: exec sp_A, @x='',@y='anything' Line 2: insert into tab1(id) values (@x) i am not able to use @x […]
2001-08-26
2 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers