Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
T-SQL doesn't support arrays (groups of objects that have the same attributes and that you can use techniques such as subscripting to address individually). But you can use local or global temporary tables, which the main article describes...
Looking for a last-minute holiday gift for that special SQL Server professional in your life? Perhaps SQL Server 2000 Service Pack 2 (SP2) is just the thing. Microsoft released SP2 on November 30; the service pack includes several fixes that might...
I've been riding the PC industry surf since 1976. In that time, I've seen corporations rise and fall with the ebb and flow of the market and the competition's technical innovations. Given the trend over the past 25 years, it's easy to predict what...
I was browsing connection information in master..sysprocesses on my SQL Server 2000 server and noticed some connections in the net_library column that have the value LPC. I've installed named pipes and TCP/IP as valid Net-Libraries. What is LPC...
I'm working on a SQL Server 2000 merge replication configuration for a publication that contains about 60 tables. At least 1000 subscribers (all running SQL Server 2000) will have access to that publication and will synchronize their data daily...