Hi, I am getting the following error from the query below against SQL Server 8.00.2039 (SP4) Error: ==== Server: Msg 107, Level 16, State 2, Line 1 The column prefix 'd' does not match with a table name or alias name used in the query. Select Statement: ============= select .... fro...more >>

Hello, I have an ASP web app with an SQL back end. I am currently migrating to a new Windows 2003 Server machine and SQL Server 2005 Express. When I import the old database, I'm trying to grant the IUSR_MachineName account access to the database, but I can't seem to find that user account...more >>

Hi I use SqlServer 2000 I am doing a select and sending the results, which is a cast() into decimal (9,3), in an email to various other users of our system. Problem is that a number like 95.2 is display as 95.200. Is there any way I can trim it so that it will display 95.2 ? David ...more >>

Hi, I need to set up a generic table in Oracle that allows users to enter data that can later be retrieved in reports. I was thinking of a 3 column table in this structure: DATE,ITEM,VALUE figuring that you can store anything in this way because ITEM can be anything and you can have mu...more >>

Hi all! Is there any function in SQL that I can use to get current date from workstation? All functions which I tried (now(), getdate() etc.) returns current date from server but I need date from workstation. Regards, Mirnes Lemes ...more >>

The situation is that I have a query where a [thing] is supposed to end, in the sense that I don't want it to be pulled back in the query, at a certain time (end_date), but that is determined by the timezone that [thing] is located in (end_timezone). Basically, I want to say: 1) If the curren...more >>

Hi, I've created database in sql server 2000 but how to i link it to webpage for user to use as front end application ? Pls advise. Thanks Rgds Daniel ...more >>

Hi, I am using MS-SQL server to store my database. My problem is that I have around 150+ database files in DBF format. Each database file consists of fields ranging from 2 to 33 in number. Also, there are some fields which have just one entry and rest are NULL. This database will be accessed b...more >>

Hi, ms-sqlserver 2000 sp4 - entrerprise edition Can you help me on this issue. I would like to move some user tables(about 100 MB) to new file group. Can you tell me what I need to do? Thanks in advance ...more >>

Hi group, Using Oracle, and given that $date=30/01/2006, you can construct a query as follows: select * from table where date_field between to_date('$date', 'dd/mm/yyyy') and to_date('$date', 'dd/mm/yyyy')+1 What is the equivalent with MSSQL? Thanks, Edward ...more >>

If we have a column with a default value set, say GETDATE( ), how can we assure that value is reset on an UPDATE (not an INSERT) without changing the client code that does the updating? I'd rather stay away from triggers, etc if possible. Thanks, Mike Husler...more >>

Anybody noticed that SQL Server rounds up if the value is half way between two rounded values, but C#'s Decimal.Round(Decimal,Int32) rounds to nearest even number? >From MSDN: "When d is exactly halfway between two rounded values, the result is the rounded value that has an even digit in the f...more >>

I am developing an inventory database in SQL Server. I realize there are many commercial (as well as some non-commercial) inventory offerings, but my client has specific requirements that would necessitate significant customization of any off-the-shelf application. In the end, we decided it ...more >>

There are two datatypes for storing binary data type in the SQL Server: 1. binary - for fixed length binary data 2. varbinary - for variable length data My question is: how is data inserted into them? Do they have any delimiters that go into the insert statement like strings and datetimes h...more >>

Hi, How to find first not null value in column whitout chacking whole table (if there is a not null value then show me it and stop searching, the table is quite big)? thx, Martin *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi How network administartor can find , who has AQL server client tools on his system? Thanks ...more >>

Right now the database I am working with is storing time in an Integer data type and is storing the time value in seconds. The application does not allow entering seconds. It accepts minutes and hours. I have a report where it is doing: SELECT SUM(TIMEENTERED) and the SUM is *blowing* up...more >>

I have an Excel add-in that connects to a SQL Server Express 2005 database. I've decided to create a configuration piece for this add-in in Visual Studio 2005 Express. I added a data connection using the data connection wizard and all appeared to go well. Anyways when I attempt to open SQL Serve...more >>

I have a website which runs off a Access database which I am currently converting to sql server database. I would like to still use my access front end for reporting and queries.. I created an odbc connection on my computer to the remote sql server and created a link in access to my sql server t...more >>

Is there a way to audit the login on SQL Server 2000? I'm looking for a way to get a report login/logout events with the name of the database. Thanks in advance. ...more >>

In MS SQL you can create a database that is run in a seperate instance. Why and when should a database run on a seperate instance ? Benefits ? What is prefered and why? Two applications have it's own tables. Appplication A have a set of tables. Appplication B have a set of tables but also ...more >>

The purpose for my questions is accessing these technologies from applications. I develop both applications and databases. Working with Microsoft C#.NET and Microsoft SQL Server 2000 Production and 2005 Test Environments. What is the purpose of a view if I can just copy the vode from a view a...more >>

Pls advice me of a small download compiler SQL that I can test my program and exmples in it (select,insert,drop,...) ...more >>

Hi, I have three tables in the following structure (simplified): Table 1: Containing the customers ------------------------------------------------- create table Customers ( [cusID] int identity(1, 1) not null, [cusName] varchar(25) not null ) Table 2: Containing the customer data f...more >>

'message' Field Data: <xml> .... <test>ABC</test> .... </xml> How do I query out 'ABC' from this xml field data in a SQL Server? Assume message field is in table 'Persons' ...more >>

I am currently moving a table from a msSQL DB to a MySQL DB. I am trying to build the bones of an insert statement by adding strings to a select statement. SELECT '(' + job_referenceno + ', ''' + job_title + ''', ''' + job_category + ''', ''' + job_type + ''', ''' + job_location + ''', ''' ...more >>

Hi, I am trying to create a script that deletes transaction tables and leaves master data like customer, vendors, inventory items, etc. How can I use TRUNCATE TABLE with an Exists? My problem is I have 200+ tables, if I simply use a list like: truncate table01 truncate table02 truncate t...more >>

Hi My problem is as follows: I need to transmit data between two databases on the same server, but I have to use dynamic database names (they must be configurable). For example I need to achive sth like that: insert into [database1].[dbo].[table1] (select columns from [table2]) when...more >>

What is the correct syntax for querying the first 20 characters of a memo field? I'm trying to SELECT CAST (varchar(20) fieldname) as newfieldname and i get a bunch of errors Can someone please help me? MS Access DB used with ColdFusion Thanks...more >>

Hi, First I would like to apologize for cross posting in three groups as I did not know which one would be the appropriate group. If some one points me to the correct one I will use that in the future. I am trying to findout the scalabilty of an user written extended store procedure. I have...more >>

When i debug a trigger is it possible to add a WATCH on the INSERTED or DELETED? I think not, at least I couldn't figure out a way to do so. Does someone have a suggestion on how I can see the values? I did try to do something like INSERT INTO TABLE1(NAME) SELECT NAME FROM INSERTED bu...more >>

I have a results set that is sorted on LineNum. Not all items have a LineNum (some are null). I want my result set to return all items in ASC LineNum order and then list all items with NULL LineNum at the end of the results. Any Suggestions? Thanks. ...more >>

I've searched everywhere for this but can't find the answer I want to run a DTS package that simply executes a SQL statement to get a count of rows in a table, if the resulting number is greater than zero I want to execute another step in the same package, else just quit. I don't to pass gl...more >>

Hello, I am attempting to build a MS SQL query that will return data from "today"; today being current day 8:00AM-10:00PM today. My goal is to return the data from a table that is written to throughout the day, the query will provide the current grade of service in our call center. I am ha...more >>

I'm getting occasional instances of the error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied I get the error both in application code and from Enterprise Manager. The database is LOCAL. Microsoft SQL Server 2000 Developer Edition SP4 Windows XP Profess...more >>

I'm getting occasional instances of the error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied I get the error both in application code and from Enterprise Manager. The database is LOCAL. Microsoft SQL Server 2000 Developer Edition SP4 Windows XP Profess...more >>

Hello ! I habe 2 Tables Table1: Orders Fields: Ordernr, Opieces Table2: Calloffs Ordernr, Cpieces In Table1 ordernr is primary key. In Table2 the same ordernr can exist often My problem If the sum(Cpieces) < Opieces: I have to create a new virtual calloff with Cpieces = opieces ...more >>

I am a DB2 DBA that has been asked to become familiar enough with SQL Server in order to become actively involved in its installation, implementation, and to review database backup/recovery procedures. SQL Server will be used by a vendor packaged application. The problem is that we are awaitin...more >>

Hi On our SQl Server (2000) we can have queries that take at least 10-20mins (require full table scan fo billion row table). When one of these queries is running it substantailly slows down very quick queries (sub second queries take several seconds). I believe there is no way to set priori...more >>

I know this is not an Access group, but there doesn't seem to be one, and I'm guessing MS SQLs are all quite similar - at least in relatively simple cases like this one. I'm using this SQL statement, "SELECT [Cape Town 25/04].IDNUMBER, [Cape Town 25/04].SURNAME, [Cap...more >>

Hi All, I have been working with SQL Server for some time - but until now haven't tried to implement a trigger and am not sure if this is an appropriate use. Any advice would be greatly appreciated. I have this table: almis.dbo.aadata_x when almis.dbo.aadata_x is updated, I want to au...more >>

I have the view below and if I use vwRouteReference as the rowsource for a combo box in an MS Access form or run "SELECT * FROM vwRouteReference" in SQL Query Analyzer, the rows don't come through sorted by Numb. Everything I've read on the web suggests that including the TOP directive shou...more >>

Hi I'm working on an ASP project where the clients want to be able to effectively perform SELECT queries joining tables from two different databases (located on the same SQL-Server). Does this involve creating virtual tables that link to another database, or am I completely on the wrong tra...more >>

I am trying to import 6M records in a table from an Oracle 10g database into a SQL Server 2000 database. After importing 1.5M+ records I get the following error: Ora-01555: snapshot too old: rollback segment number 129 with name "_SYSSMU129$" too small How can I speed up the import proces...more >>

In my stored procedure I'm calling a buggy and flaky stored procedure that comes from a third party. When I run my stored proceure from QA, I'm getting a whole buch of errors raised inside the third party one. Is there any way I could just ignore them, so that if I run my SP from QA, only errors...more >>

I've re-written a stored procedure and when I post the following code into the existing SP in EM, is saves OK. However, when I re-edit the SP, the last line 'Commit Transaction' has been removed. I cannot save the remainder of the SP as it throws error 208 (Invalid Object name #Max) about two ...more >>

I am working on setting up our new SQL Server 2005 servers. One of them will eventually be our Replication Distributor. However when I attempt to set this up within the wizard, I get the following error: ------------------------------ TITLE: New Publication Wizard ------------------------...more >>

Hi, I find much regrettable that Database Engine Tuning Advisor be not part of MS-Express Edition ... A server without such help is not a server. Besides, you've got the tutorials, but not the tool to play with :-((( Regards, JM Blaise ...more >>

Hi! I'm wondering whether it's possible to set up the MS SQL function ISNULL() as a default value to avoid NULL entries when importing data into a table?! For example, I want the column1, to have a 0 (zero) as default value, when entering/importing data: isnull("column1",0) I remember th...more >>

I've been trying to work with Linked Servers for the first time, with mixed success. My problem right now is in trying to write a View using a linked server. The linked server is another SQL-Server, and it was set up using the 'Enterprise Manager' interface. When the server was created, the name...more >>