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

here's the scenario.. I am running a DTS to collect the summarized info from Oracle database into SQL server. I then have a update job which updates my transactional table from the summarized table. The update takes a very long time (~ 3 minutes)even though it has around 1500 rows which cau...more >>

I have a column [id] in a table [products] The first 1, 2 or 3 alphabetic characters of [id] gives the category of the [id] example: ms123 --> category MS f-2345 --> category F rs2-123454 --> category RS erv-2345 --> category ERV Can someone help me with a sql-statement that gives the di...more >>

Not sure if this is the right group to post this to but. This is the current query that I have. select tableA.id,tableB.artist,tableB.image,from tableA,tableB where tableA.image = tableB.image AND tableB.price >0 AND tableB.price < 20 order by tableB.price DESC' What I need is, for each...more >>

Hi All, We have SQL Server 2000 (sp3), running on Win2k Server. Yesterday, mid morning, during normal processing (selecting data .. loading data .. etc) the sql server service suddenly shut down and would not start again. We received several messages but the 2 most consistent messages were ...more >>

Hi, Where can I learn more about new Microsoft SQL Server? Is there any free e-book or some pdf file? Thanks ...more >>

This seems so easy....change the join to show all records, but the zero records still do not show I want to join 2 tables....basically Customers and Orders....get the total number of orders for each Customer within a date range...but I can't seem to show records where the total for a particula...more >>

I want to run and 'Alter Database' statement from within a batch file. The batch file is to be run from an external automation program, (don't ask why).. I know the syntax for the alter db statement but not sure how to do it in a batch file and also If I have 2 instances how do I run it against ...more >>

A newby question: I've got a .dmp from from an Oracle database that I need to import into SQL Server. I have no idea how to do this. If anyone know how to do this, I'd very, very much appreciate the help. Thanks, CC...more >>

If I detach a database on a server, then attach the database with a single file only using the data file...will I lose any transactions that were in the original log file? There is a debate going on here at work where some people think that during the detach, transactions in the log file are sav...more >>

I am running on Win2k, SQL Server 2000 (sp3), MDAC 2.8 and using a TCP/IP client connection. I get this error when attempting to restore a database. [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead()). [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network ...more >>

Hi All I'm trying to find a math function (if it exists) in SQL Server. If it doesnt exist, then maybe someone can tell me what its called so I can do a bit more reading on it Basically I want to do this: Parameter Components 1 1 2 2 3 1, 2 4 4 5 ...more >>

Hi, I have a table with about 70k rows. When I use open table --> return all rows and then edit a field Enterprise Manager then says it has to return the entire result set for the update to take place. This can take a long time and makes editing data a slow process. Is there any way to get ...more >>

Hi, A long time ago I set up a database with *very* descriptive and therefore long table names. :( I did the same with the column names. :(( The column names even repeat the table name. :((( This was done in a period in which I was still using a lot of dynamic sql :(((( and sql in the code o...more >>

Hiya, I want to populate a list view (in a variety of ways), but I would rather not execute my function once for every record I want to show in the list. What I want to do is pass an array of "keys" into a stored procedure and have that procedure return one recordset with all of the recor...more >>

Hi All, I am new to Sql and I want to know if a given value lets say its 225 is within ranges defined in the table. I have a table TblControl. Data type of both field is int. StartRange End Range 0 100 200 300 500 600 900 950 (Sql server 2000 ...more >>

I am about to buy some database hardware, and am considering buying a dual 64-bit opteron server. In the past, we have run been running the 32-bit version of SQL Server 2000. Has anybody tried the new 64-bit version of Sql Server 2000? Can we assume that something that works in the 32-bit wo...more >>

I'm trying to create a temp table in the stored procedure. the syntex is the following: create st_proc variables declared if something >0 create temp table #Table1 if something <0 create temp table #Table1 SQL Compiler complains about the second create. thanks...more >>

Hi, We have a heavily used production server and a table which logs every hit on a web site. This table has grown large over time and we want to clear it down as efficiently as possible. We would like to issue a truncate table statement, but with millions of rows we are a bit wary of how this w...more >>

Hello I'm desperate for help with the following dynamic SQL. It used to work for ages but suddenly stopped working today! I can't recall changing anything of importance.. So I say. Anyway, I'm getting this error: "Cannot use empty object or column names. Use a single space if necessary." I'v...more >>

i am a beginner of database design, could anyone please help me to figure out how to make these two tables work. 1) a "players" table, with columns "name", "age" 2) a "teams" table, which can have one OR two player(s) a team also has a column "level", which may have values "A", "B", or "C"...more >>

Hi, Here is my original query: select rosterid, lastname, firstname from table order by lastname I would like to use column aliasing to display lastname, firstname in a column entitled name. I tried the following syntax, but it's not working: select rosterid, lastname+', '+fir...more >>

Hello, A utility I was running caused our database's log file to run out of hard drive. So, I detached the database, deleted the log file, and tried to reattach. SQL server fails to reattach because it cant find the log file. (Why it cant just create a new default one is beyond me...bu...more >>

Hi! I have an select on a view that takes too much time. The view include joins. I tried index-analysis and explain-plan, but this don't help. But it helped when making a real table (select * into realtable from bigview) and afterwards making my select on realtable...? Suggestions? Where t...more >>

I have a query below that returns a table with some client information along with the last project manager that met with them and the date they met. Nothing is included in the table if there are no meetings for that client. Is there a way that I can still have the client information included e...more >>

Hi all: I have a clustering SQL Server on Node1 and Node2, the Node1 has named Instance1 and Node2 has named Instance2, no default instance. We tested it that everthing is OK, then we decide to move to DR location. The relocation kept the same virtual and phusical server name, and we did no...more >>

Hello, On our corporate website, we will be using email notifications for various things. I would like for our marketing guy to be able to edit the email templates over the web so that I don't have to keep updating them myself for every little change. I want to store the templates within the da...more >>

Hi, Everytime a job starts it puts logging into the system (application) logging files. (Messages) How can I prevent SQL from doing that. Arno de Jong, The Netherlands. ...more >>

What does the CIO need to know about Sequel Server administration?...more >>

Is there a way to sort records the following way. Original Table: KeyField Column 1 1 0 2 500 3 200 4 300 5 0 To this sorted table KeyField Column 1 ...more >>

Is there ANY data type other than varchar that is valid for local variables and allows more than 8000 characters?...more >>

Does anyone have any good references they could recommend on Cursor based SQL writing? I have to create SQL that can loop though records simular to VB loops and I have been told that this is the way to go. Any recommendations would be helpful....more >>

I have two avenues to access my primary SQL Server. (I work remotely using a VPN connection.) Usually, I hit the server from my local machine but I also login to a desktop machine inside the main building using a terminal ap and hit the server from that desktop. Anyway, when I import files ...more >>