Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Database, DataCenter, Desktops, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Excel, Microsoft Exchange, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP ...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
Hi, I'm trying to automate the PRTJOBRPT using CL. The printed report will be copy to PF and send email directly to audit team. I'm having problem with the member (*mgtcol). We all know that *mgtcol is created daily (auto-create), how can I get or retrieve the latest member of performance data? Is...
Hi, I have Microsoft SQL Server 2005 Express Edition with SP3, SP4, on Syperemicro Server, Intel Xeon E3-1220 v2 3.10GHz,8GB RAM and OS Microsoft Server 2008. We use Windows 7 desktop clients machine with enough CPU and RAM and arcgis software who is sync with MSSEE. But works very slowly. I am...
Hello I’m an interior design student and I use AutoCAD 2007 version.And I can’t open some AutoCAD project. Example, I download some cad files on this site http://www.dwgindir.com/ or http://www.bibliocad.com/ site ect. but I can’t open files. How can I change to dwg files versions ? ...
I want to do a project in RPG, here is my concept. I have a specific product which was containing some functionality and this product was used by some customers. I want to code a tool which will show the info like Full customer info (which functionality were used by customer). Functionality info...
Is there a way to name the column returned from a query that includes a for xml explicit? I get a column named XML_F52E2B61-18A1-11d1-B105-00805F49916B. I'd like to name it something more appropriate for ORM software The code I currently have is: Declare @RoleIDs table (RoleID int) insert into...
I am attempting to install SQL Server 2000 on Microsoft Windows XP, but I keep receiving this error message: “Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system." What steps can I take to get rid of this message?
Question: a) steps to backup the daily incremental in sql server 2005. b) steps to backup the daily incremental in sql server 2005 express.
Is it possible to call an Oracle stored procedure from SQL Server?
How can I find the related table's name from just a trigger name?
We have a very huge SQL Server database, with approximately 700GB of data. Due to this, queries are running very slow. Could you please suggest few tips to improve performance?
What are the benefits of upgrading to SQL Server 2005 from SQL Server 2000?
I have problem with exporting a table to a dbf format file in sql server 2005 Has anyone done it before? Thanks!
Hi everybody, Everyone knows that a table can be created using a subquery in oracle. How to do the same task in SQL Server. In Oracle I tried as "create table table1 as select * from table2" My requirement is to create dynamic tables in stored procedure based on existing tables. I'm so desperate, I...
How to get SQL server's login and password? Please: I know query for get it.
My company is implementing new features in our product line that will force customers to upgrade to SQL Server 2008. I can't make sense of MS's pricing for SQL Server upgrades any longer (i.e., it seems they've gone away from the notion of a SQL Server 'upgrade' license). Does anyone know a...
How can I get the AdventureWorks database for SQL Server 2005 SP1?
Based on the advice "Don't run the SQL Server Account as Local Administrator or member of the Administrator Group" Will this setup prevented you from using critical features? How did you get around this? The link below makes reference as to how a critical feature "Automatic Server Restart Feature"...
When I try to install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition, it is giving me an error message that says my operating system is not supported. How can I install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition?
How can i merge the MDF and NDF files of SQL Server databases?
Hello people, the situation is this: we have 2 computers, one is for local store (let's call it backend) and the other is a web server (let's call it frontend). Both are PCs running Windows Server 2003 SP2 and both have the SQL Server 2005 Enterprise Edition installed. The webserver is using IIS...