Nested stored procedures in SQL 2000
How can I use results from one stored procedure (result is a record set not a single value) in another stored procedure and assign it to a temp table in the second procedure?

Answer Question   |  January 4, 2006  5:10 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Unable to install SQL 2005 Developer Edition
I have been trying to install the SQL 2005 Developer Edition from the MSDN subscription DVDs. The install process claims that there are remnants of the Beta edition of SQL 2005 on my computer. I did in fact have the SQL 2005 Beta, and uninstalled it using the uninstall tool that is provided as part [...]

Answer Question   |  January 1, 2006  8:55 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Educating database users
Database administrators must always be prepared to handle users’ database problems and concerns — even if those users are quick to blame for every small thing that goes wrong and rarely praise when big things go right. It may be a lack of education; users just don’t understand the work involved with managing and maintaining [...]

Answer Question   |  January 11, 2006  12:00 AM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

Active Directory custom fields
The company I work for is a mixed environment of AS400, AIX, and Windows 2000 systems. Recently we have finally started to look seriously at utilizing the Windows AD to store pertinent information about our users and computers. The question I have is what is the easiest way to make this information available for modification [...]

Answer Question   |  January 18, 2006  2:48 AM
Altiris, DataCenter, Desktop management applications, Desktops, Intel, LANDesk, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Out of office reply problem
Hi all, I’m not able to get out-of-office replies in public folder. Is this a default behaviour? or please tell me how to rectify it. The server ver is Exch 2003 in native mode. Regards, Vignesh

Answer Question   |  December 26, 2005  2:06 AM
Access, DataCenter, Desktops, Exchange, Management, Microsoft Office, Microsoft Windows, OS, Patch management, Security, Servers, SQL Server

Mandatory Roaming Profile Missing
I have a Win2k Server domain with a WinXP Pro SP2 notebook client that I am trying to get a mandatory roaming profile to work. When I log into the notebook with it connected or disconnected from the network with the NTUSER set to .DAT, I get the proper profile that is stored on the [...]

Answer Question   |  December 28, 2005  5:19 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Can’t Save or Open redirected “My Docs” after installing McAfee antivirus
I have a Windows 2003 Active Directory domain. All “My Documents” folders are redirected to the fileserver. After I installed McAfee Antivirus Enterprise, a problem developed. Users (all runiing Windows XP) cannot save or open documents from the “My Documents” folder using Microsoft Office programs, such as Outlook. For example, when they try to save [...]

Answer Question   |  December 21, 2005  4:45 PM
DataCenter, Desktops, Management, Microsoft Office, Microsoft Windows, OS, Security, Servers, SQL Server

Windows Server 2003 Terminal services
I am configuring a server to be used as a file server for a small office. The server will be housed off-site and will need to be accessed remotely by 3 users. Is terminal services the best remote access solution in this case? If so can the server also handle licensing or is that necessary? [...]

Answer Question   |  December 23, 2005  9:37 PM
Desktops, DHCP, DNS, Management, Microsoft Windows, Networking, Networking services, OS, Security, Servers, SQL Server

Loss of access to Administrator Account and Security class
I have two serious problem with my MD’s system and need help urgently! Firstly, a secretary configured a user account for herself without informing my first and logged out the administrative account that was setup for their use. After that time, although you can still see the Administrator’s folder under “Documents and Settings”, the folder [...]

Answer Question   |  December 20, 2005  10:57 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Patch management, Security, Servers, SQL Server

Print Numbers in words
By using a single SQL Query Is it possible to print numbers in words. Example : To print “5,550 Dollars” in words Expected Query result : “Five Thousand Five Hundred and Fifty Dollars Only” Is it Posssible by a single query

Answer Question   |  December 29, 2005  10:11 PM
Career development, Certifications, CRM, Database, DataManagement, DB2, Desktops, Development, Functional, Lifecycle development, Management, Microsoft Windows, Oracle, OS, Performance/Load, Security, Servers, Software, Software Quality Assurance, Software testing tools, SQL, SQL Server, Tech support, Windows

Windows 98 clients randomly locked out of DC.
Hey all, I have a mix of WinXP/2000/98SE clients on a Win2K3 domain. I recently upgraded from Win2K domain to Win2K3. Prior to upgrade, there were no Win98 client issues. Every day or so, the user account logged in on a 98 box gets locked out on the DC. This is after logging in just [...]

Answer Question   |  December 19, 2005  1:29 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Outlook Express Compacting
Hi All, I have a peculire problem here, I am using outlook express to access our emails, A while before one of my colleage complained that the emails for last three months are removed from deleted folder of outlook express after the system finished the compacting folders ??? I checked the maintinance tab, there isn’t [...]

Answer Question   |  February 8, 2006  7:49 AM
DataCenter, Desktops, Exchange, Exchange security, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Systems management software

Windows Server 2003 to Linux
Hello Everyone, I currently run a Windows Server 2003 with Exchange Server 2003. The server has two hard drives as follows: (1) 20GB containing the operating system and (2) 60GB containing all of my important data. Both drives are NTFS and there is no RAID. Here’s my question. Can I install a distribution of Linux [...]

Answer Question   |  December 20, 2005  8:21 AM
Desktops, Enterprise Desktop, Exchange, Linux, Management, Microsoft Windows, OS, Security, Servers, SQL Server

IIS driving me nuts
Dear All I hope you can help me because this is driving me mad. I have a server on the net running IIS, on it is a simple site which essentially is a list of tests and links to results. The files linked to are a combination of txt, pdf, xda and dat files. However [...]

Answer Question   |  December 19, 2005  6:28 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Windows 2003 Web Server & IIS 6: Using X509 certificate for XML Post
We have a Windows 2003 Web Edition server with IIS 6 running a small site that now has need to perform ServerXMLHTTP posts to a supppier site, via an ASP page with Javascript, that requires X509 certificate authentication. I have followed Microsoft’s guide “How to install client certificate on IIS Server for ServerXMLHTTP request object [...]

Answer Question   |  December 13, 2005  10:58 AM
ASP, Desktops, JavaScript, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Web development tools, Web services, Web site design & management, XML

Windows 2003 Server Installation for a small office
I am working in a small office that will soon exceed 10 network users and we are installing a WIN 2003 Server to accommodate up to 15 ?dumb? users. Can someone tell me (or refer me a resource that tells me) how to quickly configure the ?simplest? server environment for providing a file server for [...]

Answer Question   |  January 18, 2006  2:30 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

MS ISA server 2000 & Web publishing reverse caching
Background: ISA server 2000 setup as firewall/proxy and web publishing has been established. My problem is as follows: Changes are made to the “published web pages” but these changes don’t get published to the internet on a timely basis. Sometimes, it takes a couple of days before the changes are actually published. Question: Is there [...]

Answer Question   |  December 9, 2005  12:15 PM
Desktops, Firewalls, Forensics, Incident response, Intrusion management, Management, Microsoft Windows, Network security, OS, Security, Servers, SQL Server, VPN, Wireless

Optimizing printing and imaging environment
how can i Optimize printing and imaging environment

Answer Question   |  December 10, 2005  8:33 AM
Access, Availability, Bandwidth, Billing and customer care, Billing Support Systems, Budgeting, Data analysis, DataCenter, Desktops, Development, Ethernet, FDDI, Frame Relay, H.323, IPv4, IPv6, Management, Microsoft Office, Microsoft Windows, MPLS, NetBIOS, Network monitoring, Network protocols, Networking, Novell IPX/SPX, OS, Patch management, Performance management, Ping, Security, Servers, SIP, SQL Server, TCP

Win2K Term Service inop after migrating to new HW
I have been migrating some Win2K servers from one HW platform to another using Ghost and doing an upgrade install. Everything works afterwords but Terminal Services. All of TS in these systems are in application mode. No errors logged in the Event logs. The Remote Desktop client just says it cannot connect. Anyone have an [...]

Answer Question   |  December 8, 2005  11:35 AM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support

LAN connectivity problem
I have a Compaq EVO n1020v notebook. This works fine in our office LAN and soemtimes it does not at all. Office LAN is a workgroup with ICS enabled in win 2K server. If I check the IP of the notebook it shows the IP of the LAN but never connects to the internet, can’t [...]

Answer Question   |  December 9, 2005  1:35 AM
Business/IT alignment, Cabling, CRM, Data analysis, Data mining/analysis, Data warehousing applications, DataCenter, DataManagement, Desktop management applications, Desktops, DHCP, DNS, E-business, Ecommerce applications, Ethernet, Firewalls, Forensics, Hardware, Hubs, Incident response, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network management software, Network monitoring, Network protocols, Network security, Networking, Networking services, NIC, OS, Patch management, Routers, Security, Servers, Software, SQL Server, Switches, TCP, Tech support, Training, VPN, Wireless