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
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...
Is there a quick way to find the total size of each database on SQL Server 2000 and SQL Server 2005? I have tried running “sp_spaceused”, but I do not want to run it manually for each database. Do you have any ideas?
Is it true that even in SQL Server 2005 you cannot restore a database from a backup on a public share, but ONLY from a local storage (DASD)drive?
What is Microsoft's official position in using virtualization (Virtual servers such as VMWare, etc.) for a SQL Server cluster (two node Active Passive) in a production environment? What are the best practices?
What is the difference between RAM and Cache Memory?
I have a stored proc1 which returns a list of dates for one particular job number.I execute this proc in an other proc2 ,to get the list of all dates. Then in my proc2 we can get the MAX of this list of dates. In the WHERE clause of my SELECT statement, i need to filter the result set by dates less...
Hello, I'm using Ms SQL Server 2005. I'm connecting server via ADO. I have a question about access rights. Let me tell this with an example. Let's say I have a database named as DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL user which will have all righst on TBL_1 and...
I am having some trouble rebuilding the system databases on my SQL Server Express 2005 instance. While I have had a total system failure, the backups have been good. I have restored the operating system but obviously there are no SQL system databases present (they were open at the time of the...
How to read the excel data's from Sql Server 2005/2008 SQLEXPRESS
In SQL Server 2005 one shreds XML via the nodes() method. When inserting into a table using this it preforms extremely slowly. If the "into #x" is removed the shredding is very fast. declare @x xml -- there are 1000 rows in the xml document set @xml = ' <rows> <row>...
I've created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013, Sev...
We have SQL Server 2000 SP3 running on Windows 2003 Server. Every week, after running our optimization and integrity checks on Sunday, we get this error: Time out occurred while waiting for buffer latch type 2... This happens several hours into the day every Monday. Would upgrading to SQL Server...