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
One of my family members needs some help! He has a table in SQL Server 2008 with the attributes name and ID. The ID is a generated value like this: INSERT INTO table (name) VALUES('bob');Now, he's looking to get back the ID in the same step. How can he do this?
I am trying to connect a .net application to SQL Server 2008 using windows authentication. However, I can’t get it to work right because there are a lot of Active Directory users. I Know I could create separate login account for each of the Active Directory users in SQL Server instead of having...
I am creating an XML document using RPG and I need to output a timestamp in GMT format : YYYYMMDDThhmmssZ The date will need to end up looking like this: 20131003T210212.001Z. Can anyone tell me how to do that in an RPG program on the iSeries? Thank you.
How do you open a Gif file?
I'm unable to open an EXLS file through attached in Lotus Notes. After saving we are able to open the file.
What is STMF in AS/400?
Hello, I’m hoping someone out here can assist me. Currently the users in my domain have a link in their IE favorites that is populated using Group Policy. Senior management would like this particular link to be placed on all users desktops as a shortcut along with a specific icon. I’ve copied...
Many definitions available but nothing on the origin of the phrase "cap and trade". What is the linguistic basis for the phrase? Thanks, Hugh
How to connect Visual Basic 6.0 project to the MS Access ACCDB file for save the data?
I have a physical file PF1 with some key fields(K1,K2,K3). PF1 has say 5 logical files with different keys(K1,K2...K5) I am trying to update only a field of PF1(that field is not a key in PF1) using SQL(stored procedures) PF1 has unique keyword mentioned.But the update is not made on key fields....
Amigos, tengo el siguiente problema, cuando bajo los subsistemas con un ENDSBS o un ENDSYS y despues levanto los subsistemas con un STRSBS QCTL no me levantan las pantallas verdes, la solucion que encontre fue dar IPL pero necesito que me ayuden a saber como puedo solucionar este tema sin tener que...
I'm lagging with a clarity between Workstation Entries and Communication Entries. Can anybody explain me about which is meant for what ?to my understanding Workstation Entries are workstation devices for logging into the system for interactive work ?Communication Entries - ? this also do similar...
Now, I have an application in SQL Server 2008 that consists of a database and several services. One of the services adds information to the database (which is triggered by a user).Another service queries the databases for changes and uses the new data for processing.I used a configurable timer that...
can i get a basic defination of shared mail box ( simple)?
There must be a way to modify the dictionary in the server to add correctly spelled word for Outlook Web Access spell checker. Is the format of the dictionary file used by OWA available?
I have a table in SQL Server 2000 that has several null-able integer columns. These are not working for me so I'm trying to update all nulls to 0 and then set the columns as "NOT NULL" (But the data must be preserved). Is there a specific SQL Syntax that could set the columns this way?
I’m working with a large table (450,000+ rows). Many of the rows contain duplicate data and I’d like to be able to pull the dupes out. What is the best way to do this knowing that the rows are not fully duplicates due to the RowID identity field.MyTable ----------- RowID int not null...
I am trying to find the most efficient way to implement paging within SQL Server 2008, using ASP.NET MVC and LINQ. Should I use LINQ's Skip() and Take()or implement my own pagination with a SQL query?
We have one AS/400 printer of HP model, its printing first print and then stopping, every time we have to start the printer. Can you please suggest why this is happening, and how can we fix this.
I have a coexistence of 2007 and 2010. As we migrate people to 2010, we are planning to make them enroll their phones with us and we want to whitelist them. It looks to me like we need to set the organazation default to quarantine and then add them by allowing user to use certain device IDs. 1) If...