We are upgrading our SQL Server hardware because we need more CPU power. The current server is a P4 3.2 GHz with HT. The system we have been looking at is a dual Opteron, and the questions is: will two Opteron 244 (1.8GHz) give considerably more CPU power than a single P4 3.2 GHz? Or would we ...more >>

I am using sybase aSE12.5. I have a table with only one column with datatype char(2). when i query this table to select all the records, i should get these records in the ascending order and they should be numbered , i.e, the o/p should look something like this column_name ------ -...more >>

I have an MS Access form that users use to filter aproximately 30 criteria from a table of clients with all sorts of joins. I'm hoping someone can tell me a better way to do this: I use a stored procedure that looks like this: @emailSearch nvarchar(50) = Null, @nameSearch nvarchar(50) = Nul...more >>

Is there a way to filter a string field (nvarchar) for only the numerics. Example, I have a column that users use to enter phone numbers. Sometimes they enter 555-1212, sometimes 5551212, sometimes 555 1212, sometimes (001)555-1212. (Unfortunately that was the client's requirement to be able to...more >>

I have a 500-MB full installation CD for SQL Server 2000. All I need is to install "Client Connectivity" component (about 272K) on a bunch of workstations for users across the nation. How do I reduce the installation file size, by eliminating most of the unwanted files? Thanks. ...more >>

Hi, Is there a way to make a database write only, like in SQL server you can make a DB read only? There is sensitive data which we want dont want to read. What other alternatives can anyone think? Thanks. ...more >>

what users have the rights to execute sp_helpuser? ...more >>

It's a Windows 2000 Server box with SQL 2000 on it. MSSQLSERVER & SQLSERVERAGENT services are logged in as valid domain user. I set up a mail profile for that user, and can send email via Outlook 2003. However, when I go to the SQL Agent Properties in Enterprise Manager, Mail Profile is disabl...more >>

Hi, Say I have a stored procedure which does two INSERT operation. How can I check if the first INSERT succeeded in order to know if I should carry on and do the second one ? Regards ...more >>

Hi Can anyone help me with Session Management in ASP.NET. I have a web application with a login page and i need to retain the username after he logs in. This is what I have in Config Files Global.asax <OBJECT RUNAT="SERVER" SCOPE="SESSION" ID="MyInfo" PROGID="Scripting.Dictionary"> </...more >>

Hi, In the query analyser if I type the following: DECLARE @SortOrder integer exec pr_Admin_SetFieldSortOrder @SortOrder print @SortOrder @SortOrder is never printed. I just get the message saying that the Query Batch Completed. Why ? Regards ...more >>

hi, I have a database in sql 2000 and its size is 30 gb. problem faced by me is when From my front end application when my user updates a record for a category,900 records are suppose to be updated. Updation uses only 3 tables from my database, but in between only user gets a error of...more >>

I am looking to automate monitoring space used for each file in each database on a SQL Server 2000. Does anybody have any SQL Scripts to do this or to find the space used? ...more >>

hi I am new to SQL.I have database of 30GB.I have just heard about spliting Databases which helps in Performance.So please can any one guide me in what are the steps involved in it. Anxious to know How does it work if i split my database in two different location. We are using SQl 2000. Opera...more >>

I've got a java application that connects to a sql server 2000 database. The application must access with total permissions to database but I don't want that anybody can insert or delete data with the corporative administrator of sql server 2000. How can I lock the corporative administrator in ...more >>

Taking a course on SQL. They are saying you can get better performance by having multiple files for a group. They then graphically show an example of "Primary" with multiple data files. I have tried altering PRIMARY to have multiple data files and I get and error. I have tried creating a n...more >>

Hi Consider two tables id1 code1 ----------- ----- 1 a 2 b 3 c id2 code2 value ----------- ----- ----------- 1 a 0 2 a 1 3 b 1 They are joined on the code field. For each code, I wa...more >>

Hi, I have: (WinXP+SP2+MSSQL2k+Postgres 8.0.2) I'm trying to link the PostgreSQL 8.0.2 server in Enterprise Manager Tree and don't know some of the parameters. Has someone of you a Postgres server linked to MSSQL? Could you tell me, what data you have, please? Security / Linked Servers / ...more >>

Is there a way I can perform an update on a table, but ignore the trigger (or disable the trigger) each time I run a particular update script from a DTS package? I would like subsequent DTS steps to use the trigger except for my last update statement. Is this possible? Thanks, Frank ...more >>

Hi, I am quite new to frontpage and SQL but I have a Stock Control access database / frontpage to set up. My last problem deals with the automatic updating of the total quantity of stock with parts move in or out of the warehouse. The following shows my page layout (i posted this on the frontp...more >>

Hi All, I have set up a snapshot replication, and schedule it to run every night. The snapshot run successfully, and data get replicated to the subscribed server. However, data do not get transfer as the second day and there after. I check the job history, the job (distribution) run successfu...more >>

Hi, I wonder if you could shed some light into this. I have the following table. Id, ContentId, VersionDate, ContentXml There are several ContentIds in the table. SELECT * FROM tblVersions WHERE (VersionDate = (SELECT MAX(tblVersions2.Vers...more >>

I'm trying to create a trace file with the file as part of it's name. For example, I'd like to create a file called FailedLogins-20050428. So far I haven't been able to figure out how to get the name of the file and the date together (I'm sill very new to SQL Server and tracing). What I've don...more >>

Can an individual computer be configured contain both a SQL Server instance & an MSDE instance? Our software we charge separate costs depending if they are running on a MSDE or SQL Server edition, and if they already have SQL Server running (which they may have installed for some other applica...more >>

Two SQL Servers 1) "Test" Payroll DB Transaction Table pr_SubmitTransaction in Payroll DB ******************************************** 2) "Production" Payroll DB Transaction Table Pr_SubmitTransaction in Payroll DB Accounts DB Pr_VerifyAccounts (@AcctNumber) *****************************...more >>

I have a test environment that we rebuild servers on a regular basis. To streamline the process we use ghost. We will be installing SQL on the servers and want to build a ghost image with that build. We have tested it by doing the build, loading the data, and then stopping all the services and...more >>

Hello I have a stand alone Java application that uses SQL Server 2000 on the same machine. Sometimes, when we run the applications and follow a certain steps, the SQL server locks some of the table. At that point of time, if we try to query Select * on those table, in Query Analyzer, it just ...more >>

Hi, I was wondering if it was possible to build a query that will include a column that will provide a count related records from another table. Although there is a way to achieve this through programming in the front end, I would like to know if it possible to achieve the same thing through ...more >>

On a Windows 2000 Server in MYDomain I can do the following successfully: Net Send JoeUser "test" However on a Windows Server 2003 (Standard Edition) in MyDomain I get: An error occurred while sending a message to JoeUser. The message alias could not be found on the network. More help ...more >>

In general, What is the best approach in creating a dynamic update stored procedure, that can handle recieving varying input paramters and update the approporiate columns. ...more >>

Positions: Scientific Programmers Location: Department of Radiation Oncology, Division of Bioinformatics and Outcomes Research, Washington University School of Medicine, St. Louis, Missouri Our newly created Division of Bioinformatics and Outcomes Research has immediate openings for scien...more >>

Greetings, Are there any tools freely available to modify or edit a .mdf database file? As far as seeing the actual tables? Regards, cd ...more >>

I have a .txt file that I need to add to an existing table, which is made up of Varchar, Char, numeric and int fields. What is the best way to do it. The first thing I tried was importing the .txt file, and then going into the design and changing the field type, but I hit problems on the Nume...more >>

Hi, I have just installed MS SQL 2005 Express for testing purpose but a unabe t gn.. what user id and passwrd should use? Many Thanks, Jassim Rahma *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hello, I am experiencing some performance issues with the dbo.sysindexkeys. I wonder if anyone can help me create an index on it? Thanx! SQL script: set nocount on set ansi_warnings off --############################################################################################ -...more >>

Can anyone recommend backup procedures for a SQL Server/MSDE product? We have upgraded our program from Access to SQL & before we could just tell our customers what .mdb files to include on their backup script. Now with SQL, the BACKUP/RESTORE SQL commands work as backups, but would involve a ...more >>

I'm wondering how/why this query works. Trying to get my head wrapped around SQL. Basically the Query deletes from the Import table all records that are already in FooStrings so that when I do an insert from the FooStringsImport table into the FooStrings table, then I won't get primary key vio...more >>

I am beggining to learn stored procedures and I am trying to concatenate the where clause below but I keep getting an error: declare @sqlwhere varchar(15) set @sqlwhere = 'parentid=2' select * from categories where @sqlwhere This is the error I am getting Server: Msg 170, Level 15, S...more >>

My company needs to move a 30 Gig SQL Server across the country as soon as possble on July 1. Turns out moving the full db across the network takes a few hours. I'd like to move a full copy of db a week ahead of time, and then just move either a differential backup(s) or transaction log with w...more >>

I am trying to insert records via ASP, with a user that has only write access to the table (db_datawriter, db_denydatareader). That way, if the server is ever compromised, the access information stored in the source code's connection string will not allow anybody to actually read the database. ...more >>

Hi, I need to delete rows from my user tables dependant upon there non existence from another table: delete student where student_id not in (select student_id from tblStudent) The reasons is convoluted, simplest explanation is that our operational system allows the change of business keys....more >>

I am seeing a problem with an ASP application, where I have 2 tables. In the first table, the ASP inserts just 1 row and retrieves the primary key of the new row using SCOPE_IDENTITY. It then uses that primary key in the column of a second table (foreign key) to insert many rows. What I'm se...more >>

I've never been the most articulate person in the world, so i though the best way to illustrate the script I am looking for help with, is to provide you with two tables and the results I require. Table 1 ProductName1 ProductName2 Qty AA AA-1 2 BB BB-1 3 CC CC-1 4 Table2 ProductName Qt...more >>

I attempted to install MSDE on a WinXP machine(server) today. I installed from the command prompt as follows:- >setup INSTANCENAME="NetSDK" SECURITYMODE=SQL BLANKSAPWD=1 Before I get 'blasted', I know that I 'really shouldn't' use a blank sa pswd but.......I did :-) I then detached (sp_...more >>

Having a brainfart.... I need a query that returns a record count, based on two distinct fields. For example: Order Revision Customer 001 1 Bob 001 2 Bob 002 1 John 003 ...more >>

Hi- I've been trying to install SS2K Hot Fix # 818095 for one of my clients and it keeps terminating - the Log for the install contains an error message that reads "...dbmslpcn.dll is WRITE LOCKED". I stopped all but a few of the services on the box, but still can't seem to get it installed. ...more >>

Is there a setting for enterprise manager, to prevent two instances from having the same stored procedure or any other object open and overwritting one another? ...more >>

I am runnnig Microsoft SQL Server 2000 and have a database that gets downloaded everymorning from an ftp site. This download contains the new records and any changes to existing records. However I am running into a problem in that I am forced to recreate the views over everytime we replace the...more >>

Hello all, I have been working with several databases here that are basically data marts. A lot of the entities have an attribute that is a particular year and month. For example, a financial transaction may be posted for a particular month, regardless of the actual date on which it occurred. ...more >>

Hello all, I have been working with several databases here that are basically data marts. A lot of the entities have an attribute that is a particular year and month. For example, a financial transaction may be posted for a particular month, regardless of the actual date on which it occurred. ...more >>