Questions & Answers
Active Directory, AS/400, Backup, Business Intelligence, Career Development, CIO, CRM, Data Management, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, 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, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Virtualization, Visual Basic, VoIP, VPN, Windows 10, 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
I have installed SQL Server 2005 but I want to know how to open SQL Server and connect the DB.
I have a SQL that runs against several databases on our server that helps diagnose issues. Here's what it is: select so.name, so.type, MAX(case when sc.text like '%remote%' then '' ELSE 'N' END) AS Relevant, @@ServerName as Server, DB_Name() as DBName from sysobjects so with (nolock) join...
EMC NetWorker 8.2 is using the same pools for different groups. I need to change it so Daily uses Daily Pool and Weekly uses Weekly pool.
I'm using PostgreSQL and I need to figure out how to list all schemas using SQL. Can anyone help me? I tried using the below code but it didn't work. SELECT something FROM pg_blah; Thanks!
I need to be able to count an id and the ids duplicates when the createdate is >= 3 months or 90 days (whatever is easier) for the ids createdate. I'm using temp tables and any help would be appreciated as I'm farily new to SQL id CreateDate Counts_id 1 01/01/2015 2 1 04/01/2015 2 2 01/01/2015 1...
How to use SCADA for Modeling Distributed Renewable Generator at load in Main grid?
What is the applications area of Visual Basic 6.0?
A session is in KILL/ROLLBACK state for some time. I do not want the database to become inconsistent and would like some help on the steps on how to solve this. kill 85 with statusonly; SPID 85: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0...
Haw I can connect my own code with the fingerprint machine, my fingerprint machine is (andy) and I add sdk to my code in C#. Please help me.
In my remote SQL Server 2008 table, I accidentally deleted over a million records. Now, the server won't let me back in and access to the backup files on the server side. How can I get some of these records back?
I am end user of SAP I want to export data from SAP to Excel. But by mistake, I have selected always export in selected format so now whenever I tried to export data, it will directly export to selected format and not asking me to which format I want to export data. Can any one help me to deselect...
Can I place Windows on an external hard disk?
I'd like to set up a PHP-based Q&A module that doesn't require any kind of database. For example, a user would fill out a form asking a question, and then click on a submit button to send it to a moderator. The moderator would then instantly receive the question and have the ability to modify...
We have several production servers that have IBDATA files. These files are increasing daily. Actually, it's almost taken up 300 GB in space. The tables in the servers are InnoDB (most are read and write requests). Also, log file size is going up too. So basically, data continues to rise. Is there a...
In his latest blog post on IT Compliance Advisor, independent security consultant Kevin Beaver talked about five ways your company can help prevent a data breach. His list included: 1. Having the right people on board 2. Really understand the risk 3. Approach management and corporate compliance...
How do I open a BUP file?
I deleted a profile in HKLM_Software_Microsoft_WindowsNT_CurrentVersion_ProfileList in Windows 10. Now all of the user's files are gone. Any ideas why and how to get the files back? Restore tools don't seem to find them under the user directory. The user happens to be my wife!
VS 2014 - I do I get the keypress event to ignore the space bar? Everything I've tried won't work. Every time I use keys.space to identify the space bar, or " " as an input so I can work around it it throws an exception. I need the program to ignore a space bar input should the user hit it by...
How do I utilize Oracle in mechanical engineering?