Am using Powerbuilder 8.0.4 and SQL Server 2000. Have just installed Windows XP SP2, and can no longer connect to my SQL Server db. Someone suggested that I need to reset the port for the db at 1033. Is this the correct port number, and how do I change the port? ...more >>

I am migrating a web application I wrote from ASP to ASP.Net, and from Access to MS SQL server. In the Access version, I did not use the auto number for creating invoices and other documents, because I heard somewhere (perhaps incorrectly) that if the db was ever compacted or otherwise changed...more >>

I have two SQL Server 2000 machines. The same file is sent nightly to each server and a stored proc uses BULK INSERT to load it into a staging table for processing. Once I've bcp'ed it in, I put it into a temp table with an IDENTITY column appended to it. (I need this identity column to group ...more >>

Hi I a am executing a stored procedure from C code using SQLExecute . It takes some time to Execute the procedure. However when I see the processor usage during that time it shows 100% cpu usage. Can anyone tell me why SQLExecute uses 100% CPU when running the stored proceudre. Thanks vishal...more >>

Hi all, I have an asp page that writes to an ntext field in SQL Server 2000. All was going well until I had to put in a section of text greater than 8000 bytes. Then I got a timeout error and the update wouldn't go through. After reading that 2000 only accepts chunks of 8000 bytes or under at...more >>

I dropped a login from securities list. and when i try to re add that login and give the user access to a particular database the error message "Error 15023: User or role "user" already exists in the current database" . upon enquiry i found out that the PUBLIC role in the databse still contain...more >>

How would I set up secure replication between 2 servers that are in different cities? Would I need to define linked servers first? Would I use SSL? Help appreciated. Thanks. Steve *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get r...more >>

Hi I'll have probably to use sql server soon but prior to that I have a question concerning priviledges and security. Is it possible for someone to do like in access, ie creating a db/table that is locked with a password? My guess is that it will be yes but in cas of... Now is it possible fo...more >>

Hello, I am pretty much a newbie with SQL server. I have what is probably a pretty stupid question. In SQL Enterprise manager, is there a way to easily see all triggers, or, even better, all tables and there associated triggers? I suppose at the least in a way similar to viewing all saved ...more >>

Questo Statement in SQL Server funziona. In Oracle PL/SQL se lo lancio funziona Quando lo devo far funzionare da Vb.net mi si pianta e non va avanti . Sta lì a pensare. Come mai ? UPDATE proc_azienda SET cod_fase_sign = (SELECT MAX(pfa.COD_FASE) FROM PROC_FASE_RIGA pfa WHERE (COD_GRUPPO = ...more >>

I have installed msde 7.0 on a pc with win98. Someone has changed sa password How can I reset sa password? I'm unable to logon with trusted connection because the pc is not nt. Thanks ...more >>

We have set up Oracle database as a linked server in SQL Server. We are able to access Oracle tables fine. I am trying to call a Oracle stored procedure in SQL Server as follows: declare @p1 varchar(1000) set @p1 = 'HHH' exec GENRET..OPS$GENRET.BOB_TEST_PROC @p1 This is the message: ...more >>

Hi everyone, I am using an SQL extended stored procedure to send emails in a DTS package using a cursor that goes through each row in a table. Email sending code below ====================== exec master.dbo.xp_smtp_sendmail @FROM = @sFrom, @FROM_NAME = @sFrom, @TO = ...more >>

Hi, Can you recommend the best way (fast and most productive) to search an employees table? Let's say I have a table that has this kind of structure: firstname, lastname, state, city, street, phonenumber, socialsecuritynumber, dateofbirth, etc. I'd like to provide a search window with one ...more >>

Hi, The company's database has multiple schema. If I want to modify a stored procedure, which is saved as a script (something like abc.sql), I opened that script in Query Analyser, made the changes, tested in Development Schema and saved it. After that, if I want to make those changes to othe...more >>

hi all(happy raksha bandhan day) we have one of Automation software for sales running for a customer.He was cool for the first month of product, but later popped with adding some extra fields.no problems i added in database , put a seperate code in my application for that field.but later ever...more >>

Hi, I'm using DB2 UDB 7.2. Also I'm doing some tests on SQL Server 2000 for some statements to use efectively. I didn't find any solution on Sql Server about WITH ... SELECT structure of DB2. Is there any basic structure on Sql Server like WITH ... SELECT structure? A Sample statement fo...more >>

I've had my SQL server database running for two years now without a problem. However, just today one of the main tables started returning an error. The table is contained within a database called engineering. I back it up once a week and the file size is up to about 40 MB. The error retu...more >>