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

Hi all! Running the code below in SQL-analyzeer (or through dbExpress) results in NULL. As one might guess I would like the result to be 1. What is wrong? I.e, why wont the result of the SP come back to the caller? CREATE PROCEDURE test @val INTEGER OUT AS SELECT @val = 1 GO D...more >>

I have this sql statement: select A.field1, B.field2 from table1 A, table2 B where A.field1=B.field2 If there is no match, I still want to produce a line of output with field2 showing a blank. Ordinarily I could simply do an outer join. But because I have more than tw...more >>

For some reason a stored procedure which I have created is incorrectly saving the date to the table. It seems the day and month are being swapped around e.g. a date which should be the 12th April (12/04/2005) is saving as the 4th December (04/12/2005). The parameter used in the stored procedur...more >>

Excuse me for not putting a better name to this but I cannot think of a suitable subject title! anyway, here's what I am trying to do At work we have a fair amount of data that is to do with people and what jobs they have completed and at what date so for example Joe Bloggs did design wo...more >>

I have a case where a table has two candidate primary keys, but either (but not both) may be NULL. I don't want to store a copy of the concatenated ISNULL'ed fields as an additional column, though that would work if necessary. Instead, I tried the following (this is a related simplified example,...more >>

Hi, Am having trouble with an alter table command in SQL, it is the below command, and gives the error message shown below. alter table "Test" add "Test" numeric(10,0) with values NULL Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'with'. I realise it has...more >>

I have an sql script that I ran on my local system using osql. It created all the tables, views, and even inserted sample data into the tables. Now I need to create that same database on a shared hoster site. Only the hoster does not allow the running of osql. How can I create my sql server...more >>

Hi all, I've been assigned a task of refreshing data from the production env to development env. what i got is a backup file of a db in the prod env, i now need to make that into the development env. I can restore it to the dev env no problem, but the warnings i got are that the tables owne...more >>

Hi all, Would anyone know a way to convert a char(10) in format 'm/d/yyyy' to 'mm/dd/yyyy', so I can convert the column to datetime format. Thanks ...more >>

Imagine a table in Microsoft Sql Server 2000 named Pictures with three fields. A primary key ID(int), a Name(nvarchar) and a Picture(image) field. Lets put some records into the table. The first two fields as expected would take an int and a string. The third field is of type image. Instead o...more >>

We're running a simple network with a Windows XP Pro machine running SQL Server. I have a VB application that runs fine on machines within the workgroup. There are several computers outside the workgroup but physically reside on the network that generate OLEDB errors. I know with certainty it...more >>

Hi - I am getting perplexing, seemingly inconsistent results from two simple queries, and I was wondering if I'm doing something obviously brainless. The first query is: select colX, colY from (select distinct colX from tblX) x full outer join (select distinct colY from tblY) y on x.co...more >>

Hi, My company has a scenario where we would like to change the data type of an existing primary key from an integer to a char, but we are concerned about the performance implications of doing so. The script for the two tables that we need to modify is listed below. Table FR_Sessions contai...more >>

I have two problems I need some help with. First, I've just inherited a system and am delving into a few timeout problems that are causing problems for the users. Now, if I do a simple select * from the table (which looks to be the cause of the problem at this stage) in QA, I get the results...more >>

I have two production SQL Servers and a separate server as a distributor (merge replication). The two production servers are licensed by device cals. Does the distribution server require the same cal licenses as the production ones or can I save on cals by assuming that only the agents will co...more >>

Here's the deal. I've been working on an Intranet application for my clients, and today I went and installed the first prototype. It's a fairly standard thing - VS2003 ASP.NET/VB.NET on a SQL Server 2000 database. I restored the database onto their db server, and installed the application ...more >>

Hi I have just started at a new company and one of my first task is to tighten access to the SQL Servers. I have a group of Developer working on a test server. This server contains a number of databases that are used by other groups. So far I have gotten them away from SQL standard acc...more >>

What can be done if the shared web hoster I am using allows only 1 sql server database and a second web application I would like to install is configured to use its own database? can databases be nested, one within another? thanks, -Steve ...more >>

What does the "[dbo]." mean in the following sql script stmts? use [IBuyAdventure] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Accounts]') and OBJECTPROPERTY(id,N'IsUserTable') = 1) drop table [dbo].[Accounts] GO and if you please, what does the "N" in ...more >>

hello i am new to sql server and .net programing here is a problem i got while trying to register sql server over internet on sql server enterprise manager , i open register sql server wizard click next, gave ip address of the sql server( i want to register) in available servers and add it , ga...more >>

Hi, I'n in an environment where I cannot make stored procedures. Now I need to make a query with a subquery in the SELECT part which gives a comma separated list of results: SELECT p.id, listFunction(SELECT name FROM names WHERE name_parent=p.id) AS 'nameList' FROM projects AS p T...more >>

How can i mark a row with its last edit time? With access it was obvious, in sqlserver?...more >>

I am trying to install Sql Server on a Win 2000 Server...It keeps failing and I dont know why...I turned off my anti-virus for installation and am logged in as an admin..heres the output of the log... 21:40:32 Begin Setup 21:40:32 8.00.194 21:40:32 Mode = Normal 21:40:32 ModeType = NORMAL...more >>

VB.NET Web Programmer in New York $40/hr We are looking for someone to work as a VB.NET Web Developer. In this role, you will design and develop application software for a successful global corporation. You will also support and install software applications. Additional duties are to partic...more >>

hi i doing a project like "IMesh", whatever ,i will take a sentence from the user and want to retrieve all row from the table has similar words for example the user enter "programming with c#" so i retrieve all fields that contain "programming" or "c#" some thing like what a search engine do t...more >>

I'm trying to tweak our DB as much as I can. We have the full application database sitting on a RAID 10. Logs, tempdb, etc.. are on separate arrays. I read some articles about making separate filegroups. Of course, they all say to move them to different arrays, which because of budget is no...more >>

I want to restore a backup copy of a database from the command line. Can this be done? Thanks, Tom....more >>

I have an Access 97 database that I connect to a SQL Server 2000 through ODBC. I have to manually set up the ODBC connection on each user's machine if I want them to be able to use the application though. Is there a way to store the connection string within the Access DB so I don't have to t...more >>

This is a question concerning query optimisation. Sorry if it's a bit long, but thanks to anyone who has the patience to help - This is my first post here... If I have two tables: 'tblContact' and 'tblCategory' where categories are like: Code Name 010101 Short 010102 Fat 0...more >>

Hi, I seemed to me IsNull Evaluation within EXEC fails. Here's some more detail of the problem. -- goal: provide one parameter (of various value) to generate a -- report declare @col4 varchar(30) select @col4 = null -- pls note, the @col4 var is default to null but may likely -- have ...more >>

Hello everyone, I have created a database that I am storing customer information in. Everyday, I am downloading the new customer information using a simple asp script. What im having problems with is that I would like to "archive" all of the customer data that I have already downloaded for t...more >>

I have been looking for some documentation that would support or reject my opinion on Production -vs- Development naming conventions. I believe that each environment should be housed on separate servers with identical names, access, users, stored procs....... If you either agree or disagree wi...more >>

I am trying to add a simple case statement to a stored procedure or user defined function. However when I try and save the function/procedure I get 2 syntax errors. Running the query in query analyser works fine and a result is given with no syntax errors. I believe its something to do with the ...more >>

Is there a more elegant way to do the following?... declare @d1 datetime, @d2 datetime set @d1 = '2005-01-01' set @d2 = '2005-02-01' select case when datediff(dd,@d2,@d1)is null then coalesce(@d1, @d2) when (datediff(dd,@d2,@d1)> 0) then @d2 else @d1 end Cheers,.. N...more >>