Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, CRM, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Exchange 2003, Microsoft Exchange 2007, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2007, Microsoft Windows, Microsoft Windows 7, Microsoft Windows Server 2003, Microsoft Windows XP, Mobile, Networking, Oracle, OS, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Virtualization, VoIP, VPN, Windows Server, Windows Server 2008 ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
We currently use a DTS package to extract data from the database and export it in either an XLS file or a TXT file. We now need to be able to export it as an XML file, and SQL Server 2000 DTS functions do not appear to support this directly. How do you recommend we proceed?
Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I...
http://search400.techtarget.com/tip/1,289483,sid3_gci855513_mem1,00.html to find out more. Above article has a savefile mentioned. Is there any way to retrieve this information? I am looking for the scansave savefile.
I have been trying for a while now to convince senior management that an IT security Audit would be a good thing. No we have never had one. I did get them to endorse an option that would let me explore the possibility. So my question is roughly how much would an IT security Audit cost?
Wher can I find tutorial instructions for using MR11, including the accounting entries that are created by using this T code?
How do I specify hardware that will support running Hyper-V? This question is from the Microsoft Virtualization Live Chat which took place on August 27th.
Is there a way for the Iseries to respond to an error message without user intervention?
What's the best way to write a query that can select 10 rows randomly from a total of 800,000.
Somebody was on my system and viewing pages they should not have been and now I have a virus. A window comes up that says Resident Shield Alert c:\windows\system32\phc5j4j0ee5l.bmp,it also says threat name is "trojan horse Generic_c.0YJ. I've tried doing a system restore, but that didn't work and...
Does anyone know of a way, in MySQL, to replicate a SQL Server function "ROW_NUMBER()?" Here's my example: SELECT col1, col2, ROW_NUMBER() OVER (PARTITION BY col1, col2 ORDER BY col3 DESC) AS intRow FROM Table1 With this, I would be able to add a condition to limit "intRow" to 1 to get a single...
I currently have a MySQL table that looks like this: company_name action pagecount ------------------------------- Company A PRINT 3 Company A PRINT 2 Company A PRINT 3 Company B EMAIL Company B PRINT 2 Company B PRINT 2 Company B PRINT 1 Company A PRINT 3 But now I need to run a SQL query to get...
"Ethernet doesn't have a valid IP configuration." This delays the connecting to the Internet. How can this be fixed?
I want to be able to use my computer as my phone. I want to use a bluetooth headset. I want to open a program, dial a number on the screen, and make a call. I also want to be able to use the automatic dialer in Outlook 2010. How do I do make this possible?
I have a windows 12 domain server running on an independent 500gb HD. I also have 3 additional HD that files were saved on. I moved the files and want to remove the 3, now blank, HD's. When I remove them, the system will not boot. If the OS is on an independent drive, why won't the system boot with...
How do I change the print settings for SAP as when I try to print reports the text is huge and only the top left corner of the report prints? I am using SAP via an external Citrix connection and printing to a local printer.
What is the difference between AL08 and SM04 and SM51?
I want to get into a Facebook account but I don't have the password to it, just the email. Can someone please help?
Does anyone know if there's a way to check if a table exists in MySQL (possibly through PHP) without throwing an exception? It's not beneficial for me to parse the results of "SHOW TABLES LIKE." There must be some sort of query I can use.
Respected sir, Unfortunately the hard disk of my system is damaged, now I recovered my database. but it cannot be attached again to SQL management studio 2005. The error is myfile.mdf is not a primary database file. (SQL server, error 5171) Please sir help me.
I have a formula that adds a field formatted as 1.00 to another field formatted the same 2.00 and then deducts a third field formatted the same 1.00 which has a result of 2.00. How do I format the result to be 2 I have tried rounding, truncate, totext, fix but the do not work. Working on Crystal...