• AS/400 MQ channels

    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...

    frmdeva365 pointsBadges:
  • While uploading attachment in Xpage getting java.io.FileNotFoundException

    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...

    srihoneysh15 pointsBadges:
  • Subnetting Question.

    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?

    reindolf5 pointsBadges:
  • Making a POS form for a pharmacy program

    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...

    josewan5 pointsBadges:
  • Keyboard

    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!

    Ginnyivor10 pointsBadges:
  • Upgrade SQL Server 2005 32-bit to SQL Server 2005 64 bit

    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...

    Jadi5 pointsBadges:
  • Retrieving and storing an image in SQL Server

    How can I retrieve and store an image in SQL Server using Visual Basic 2008?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating stored procedures to execute tables at runtime on a SQL Server

    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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Finding the total size of databases on SQL Server 2000 and SQL Server 2005

    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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Restoring a SQL Server 2005 database from a public share backup

    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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Virtualizing a SQL Server cluster in a production environment

    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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • What is the difference between RAM and Cache Memory in SQL Server 2005?

    What is the difference between RAM and Cache Memory?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL SERVER 2005-MAX FUNCTION

    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...

    Beginner in IT5 pointsBadges:
  • Access rights in SQL Server 2005 users

    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...

    DetayMan5 pointsBadges:
  • Issues rebuilding system database on SQL Server Express 2005

    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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Read Excel from Sql Server 2005/2008 SQLEXPRESS

    How to read the excel data's from Sql Server 2005/2008 SQLEXPRESS

    Sridhar12350 pointsBadges:
  • shredding xml in sql server 2005

    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>...

    Skidancer5 pointsBadges:
  • SQL Server restore job fails

    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...

    TuftsDBA0 pointsBadges:
  • Upgrading from SQL Server 2000 SP3 to SQL Server 2000 SP4

    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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Mainframe access to SQL server data

    How can I access SQL server data from a mainframe COBOL program?

    Artisan5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following