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 Guys, we have common user profile to log in to iSeries. Now, I have a requirement where I need to retrieve the Windows IP Address, User profile, Login & Logout Time through which system Common User profile is logged in. Will it be possible to get Windows IP Address & User Profile from...
Recieving an error for database creation permission for sql 2005. Please advise
Is it wise to store files such as .doc's or .pdf's as binary objects in a SQL Server database? If there can be issues down the line, is there a way to design the SQL database to make it easier to work with?
Books Online tells me ... make sure you have administrator permissions on the computer where SQL Server will be installed. Based on the principle of using the lowest possible user rights is it possible to safely install SQL Server 2005 using an account or group that has the required level of...
how can i retrieve the data from sql-server 2005 from multiple tables in two combo-boxes in vb6.0 using programming code
I am a SQL Server DBA and in the process of upgrading our SQL Server 2000 to SQL Server 2005. I’ll be using database mirroring for the disaster recovery in SQL Server. One question I have is once I failover to the mirror server and use it as a principal for a couple of days, how do I make sure...
How can one get the information about the object type of synonym that is whether the synonym belongs to function, stored procedure, table or view using a query. Sys.synonyms table contains information about synonyms present in a particular database but it does not tell for which object the synonym...
Hi all, have you an idea how can i export the list of users and there access rights of an SQL SERVER 2005; THANK YOU
how can we take a db2 backup tape and dump to a sql server 2005 database?
Is there a way to create a dialog between SQL Server Service Broker and Oracle Streams Advanced Queuing?
I'm quite new to SQL Server and I’m struggling to design a trigger. I need this trigger to execute daily and calculate averages of columns and return them to another table.
When I try to start my virtual machine, I get an error message saying that the hypervisor is not running. I'm able to open Hyper-V Manager fine, and have not had a problem running a VM on this physical machine before. Has anyone run into this issue?
Hi all, can you please help to get the last sequence number of MQ channels in a programmatic way. There is command WRKMQMCHST which will tell us the last sequence number but this command is not producing any spool report. So please help to get the sequence number of MQ channel. I want to get the...
I am using Domino Server 9. And the server is running proper. At some stage it reaches a state where an upload to an XPage upload control fails with a FileNotFound error (it can't find a temp file created for the file being uploaded, more details about this later). In some cases the server reaches...
You have an IP address of 172.16.3.57 with an 11-bit subnet mask. What is the network D, range of subnet address and broadcast address for the subnet?
I need to make a POS frame for a pharmacy automation program am working on. >need to add data from a field in access in which it searches while I type. >when I select the name, the data from the access corresponding the name selected should be added in my flexgrid list and should be asked to...
Hi - I have three characters missing from my 2 year old Toshiba laptop keyboard. Is there any way I can retrieve them, please. One of them is the question mark!
Hi, We have one development server which is running on sql 2005 32 bit contains Databases ( including Tables, SPs, views, assemblies..etc) Applications ( .net 2.0 web application, crystal reports..etc) Note: now this databases & application is under development stage. But our plan is in future we...
How can I retrieve and store an image in SQL Server using Visual Basic 2008?
I’d like to execute different tables at runtime on my SQL Server by creating stored procedures. This is the syntax I am attempting to use: create procedure sp1(colname varchar(400), tab_name IN varchar2) AS BEGIN select * from '@TABLENAME' where CompanyName='@COLUMNNAME' end Is this syntax...