Search results for query: *

Hi all, I have a problem at home. No, not that kind of problem - I have a problem sharing a printer. I have an old windows 2000 machine that I want to use as a print server for my HP 720 deskjet printer. I have shared the printer and everything appears good on the 2000 side. Now I want to...

Hello All, I have had Verifone Pinpad 1000 support for a long time now in my application and recently was sent a Pinpad 1000se. Even though it says it's backward compatible I get a "PACKET ERR B" when I prompt to receive the PIN. Any ideas what PACKET ERR B means? Thanks, Andy

Hello, After installing SQL 2005 Express I have to connect using the named instance it created (.\SQLEXPRESS) as part of the data source. If I try to connect without using the instance name it doesn't work. Is there any way to make this the "default" instance so I can use just the server name...

Here is an example of XML I need to produce: <?xml version="1.0"?> <MyMessage xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <MyAck/> </MyMessage> My question is how can I add the schema references (xmlns:xsd, xmlns:xsi) using only...

I'm new to using the XMLDOM parser. I can see if an element has child nodes by using the "hasChildNodes" method. Is there a similar easy way to determine whether an element has attributes? Andy

Hello All, Does anyone know how to install a font programmatically from VFP using the Win API? I can check for the existence of a font using AFONT(), but I'd like to intall it automatically from a TTF file if it is not there. Any ideas? Andy

Is there a performance difference by using an Integer key instead of say a Char(4), Smallint or Tinyint? I'm wondering if Integers have any other performance value other than the compressed 4 bytes of space they take up. For instance... will a join perform any better with an Integer key as...

Hello, How can I check to see if a default constraint exists on a column and what the name of the constraint is? I want to eventually drop the column, but need to check and drop the constraint first. Thanks, Andy

Hello, I normally install MSDE with my app and use SQL Authentication and do everything using the SA account. I had a situation recently where someone connected with Windows Authentication via MS Access and had full access to the database. How can I disable the BUILTIN/Administrators account...

Hello, Is there any way to change a column name in T-SQL using ALTER TABLE or something? I'd like to rename a column yet still keep it's same ordinal position. Thanks, Andy

Hello, Is there a way using the ALTER TABLE command that I can drop the IDENTITY property from a column? I'd like to drop just this setting rather than dropping the entire column and re-adding. Thanks, Andy

Anybody know how I can programmatically check the size of a DB? I want to see how close I am getting to the MSDE limit of 2 GB. Thanks, Andy

Hello, I want to be able to take some transactional data in my database and copy it off to another database as I near the 2 GB limit of MSDE. Once the first archive gets filled I'd like to automatically create a second archive database and copy transactions there. So eventually I would have...

Treeview Experts, I am using the treeview control and when I expand a node the control is not wide enough to show the full description of the children. In this case it brings up a tooltip that shows the full text description of the child when you hover the mouse over the item. I'd like to shut...

Hello All, In Query Analyzer I can run the command: DBCC CONCURRENCYVALIDATION and it will return a message with information on the number of concurrency violations in MSDE. My question is, since this command does not create a recordset how can I return the information from my stored...

Hello, I read in the FAQ that you can't use Stored Procedures in Select queries so maybe there is another obvious way to solve my problem. I'd like to call the SP_WHO stored procedure in my stored procedure only return certain columns and certain rows. IE: I'd like to return only that status...

Hello, I am searching for a connection string attribute that will shorten the default timeout when connecting to SQL Server. I am using Visual Foxpro as my client and I'm trying to connect to SQL over a DSN-less connection. The default timeout seems to be 15 seconds and I'd like to shorten it...