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 Server, SQL Server 2005, Storage, Virtualization, Visual Basic, 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
Hello friends! I am new here in this forum. I have a simple question. I am using Visual Studio 2010. But the SQL Server 2008 that comes with it does not have Management Studio with it. So I have installed SQL Server 2008 again seperately in my machine. Now I want to know how to attach SQL Server...
can not backup a 2000 db, dbcc checkdb ok. see following: Errorlog: 2008-01-08 09:54:40.69 spid62 Starting up database 'CP2005'. 2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education] TO DISK = N'C:\fjs1\education_db_200801080954.BAK' WITH INIT , NOUNLOAD ,...
Hi all, We are looking into creating a SQL 2005 server (Windows 2003 R2 SP2 Enterprise Ed.) with 3 databases. Size of the db 's will be app. 50 GB, 15 GB and 7 GB. Amount of continuous logged on users is app 20. Can anyone recommend the amount of CPU + clockspeed of the CPU's, RAM memory and...
When i attempt to install it tells me that my operating system is not supported, rule "Operating system supported edition" failed. however when i check the list of valid operating system it is listed, anyone had this issue before or know why i wont recognize, thank you
I am trying to work with database mirroring on SQL Server 2005, and I keep receiving the error message, “One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.” I know that the syntax for a...
Can you explain to me the syntaxes of triggers used in SQL Server 2005? Could you also give me a simple example of a trigger?
How to create an application in VB6 that can retrive data from microsoft SQL Server2005.Is that possible.Thank you.
How can I save a picture to the SQL Server database and retrieve it using VB.Net 2005?
I need to export the result from a stored procedure into an XML file directly in SQL Server. How would I go about doing this?
Hi, is there a way to send an email reminder and mark user's calendar through Oracle Forms 10g? Any help is appreciated.
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?