Has anyone tried the ASP.NET Enterprise Manager ? I've installed it but after starting up it produces errors, I've started it by using http://localhost/ASP-ent-man/ and also by using http://localhost/ASP-ent-man/app/ but they both throw an exception. I've even copied the bin directory into the a...more >>

Hi, I have a problem counting the occurence of a number within 3 spefic columns for one table. What I want to do is to count the number of occurence of a number (60 for example) for each of the three columns starting by row*. I'm able to count it seperatly but can't find the correct way to ...more >>

Hi, Anyone have a table of Countries, with their respective international dialing codes? Or, a link to such a table would be great. Thanks, Scott ...more >>

Lets say I have a privilege structure organized by number: 1 - Administrator 2 - Office 3 - Supervisor 4 - Field Operator 5 - Assistant Operator Levels 1, 2, and 3 have the ability to add new employees to the system. However, when adding these new employees, I don't want them to have the ...more >>

Hello what is the difference? Which one should I use? a) CREATE UNIQUE INDEX [uniqueKey] ON [dbo].[companies] ([co_loginname], [groupid]) WITH DROP_EXISTING ON [PRIMARY] b) CREATE UNIQUE INDEX [uniqueKey] ON [dbo].[companies] ([co_loginname], [groupid]) WITH DROP_EXISTI...more >>

Hi , How can I break up all sql connections? I need this in order to restore a database after that. Thanks. ...more >>

Hello all, I want to be able to not update a row in a table if an existing flag has been set in one of the columns. What would be the most efficient/elegant way to perform this? 1. Check for column value in stored proc and only if not set then do update. 2. Write a trigger which checks column ...more >>

Hello, if I do an INSERT INTO based on a SELECT with an ORDER BY can I be 100% sure that the records entered will have an incremental key on the identity column if I set one up correctly? It looks like this is going to work but something about it gives me a bad feeling! Thanks, Kevin. ...more >>

Thanks for the help guys. CELKO, sorry if all that was elementary. I'm new to this. Like I mentioned this was imported from Access so I didn't bother changing the table and field names from the Leysinski scheme. Sorry, I'm new to SQL Server (and to db design for that matter), but I will read ISO-...more >>

I have the following simple Select statement which produces an error when I attempt to save it as part of a stored proc. Select dbo.Customer_CalculateAgedBalance as AgedBalance From Invoices Where AgedBalance > 1000 Note: dbo.Customer_CalculateAgedBalance is a UDF. It produces an error b...more >>

Hello, I'm receiving the following error. This error occurs only when the stored procedure is executed from a remote server, but runs fine when executed on the source server. The error message occurs after a ten minute duration and fails on the BCP OUT. I have checked the linked server proper...more >>

A pretty simple question. We are using SQL7 and 2000 in a LARGE mixed server environment, so I am pretty much stuck using "standard" SQL7. I created a new table from three exsiting tables that contained "basicly" the same information, the main difference being each table was specific to a ...more >>

Hi, ERROR (at execution): "Disallowed implicit conversion from data type datetime to data type tinyint, table "xyz.dbo.tmpTrenddata', column 'xyz'. Use the CONVERT function to run this query." PURPOSE: To get one table (current batch) to copy its contents (only some rows with a specific b...more >>

Anyone have any ideas why this doesn't return any values? This is an SP that was constructed from a Query in an Access database that was imported into SQL2000. I re-created the query in a stored proc, and this is the first time I have used the LIKE keyword in SQL server and it doesn't seem to wor...more >>

Hi all, There is a table called SALES with a single field called PRODID. An entry is made into this everytime there is a sale. Doing a SELECT TOP 5 COUNT(*) C, PRODID FROM SALES GROUP BY PRODID ORDER BY C DESC gives me the list of top 5 selling products. In another table PRODUCTS, there a...more >>

When new data come in, it may be a brand new record, or an update of old record. So, I have to check the data, and choose either INSERT or UPDATE. Is there any SQL command that is similar to MERGE in Oracle 9i, so that only one statement can do both? Thanks, Guogang ...more >>

I am running SQL Server 2000 Will trigger happen on each insert when doing a select into? From what I am finding out it doesn't. I just tried this and in a trigger on the destination table get a record count > 1 in the inserted table when doing a select into and the select into has mo...more >>

I have a partitioned view on Orders data...there are twelve orders tables...one for each month of the year...the partitioning is done on the order date column. Everything works fine when my query contains an order date...the performance is excellent. If I try to run a query using only the Order ...more >>

Personal, necessary to do a select that contains for NAME, if the name has more than a connection I want to catch the total time of those connections in the format hh:mm:ss, the format of the field is DATETIME and I have a field with the beginning and the end of the connection. I am getting ...more >>

Lets say we have two tables (1) VIPCustomers and (2) Invoices with the usual data. I have the following valid statement: SELECT A.* FROM Invoices A INNER JOIN VIPCustomers B ON A.FirstName = B.FirstName AND A.LastName = B.LastName Q. How would I do the same using the "IN" clause ...more >>

Hi Freinds, I need to copy a file from: \\serverone\folder\myfile.txt to \\servertwo\folder\myfile.txt where \\servertwo is my sql server and running DTS package. How can I do it? Any script? Thanks in advance, Pat ...more >>

How do I convert a value that contains date and time values to the date alone? In Access, I'd just use the DateValue() function. -- HTH Dale Fye ...more >>

I'm trying to fix the fax numbers in our contact table to have a "1-" in front of the number from: 800-555-1212 to: 1-800-555-1212 Here's the code I'm trying to exit in the SQL Query Analyzer: update contact set businessfax = '1-' + businessfax where left(businessfax,1) <> '1' and ...more >>

Hello everyone, I need to load a comma-delimited text file to a SQL Server 2000 table every day. I have no problem loading the data, provided the data is 'clean.' However, the load fails on little things, like a quotation mark embedded within a string, or a non-date value in a date fi...more >>

Hi, Here's what I'm trying to do : select * from tableA + select * from tableB where tableB.field1 = tableA.field1 + select top1 from tableC where tableC.field1 = tableA.field1 Is it possible ? how ? Thanks a lot. Sam ...more >>

Hi , I am quite new in MS SQL and does not know about trace facility available with MS SQL SERVER. I am using MS SQL SERVER as resource manager which is in turn used by our transaction manager and I am using ODBC as programming language I had turned up connection attribute SQL_COPT_SS_ENLIST_I...more >>

Hi! Newbie question here. In access, you could use the Mid() function in a SELECT statement to return only a substring. How can I achieve the same result when building a view in SQL Server? I used something in the likes of: SELECT MID(table.Code, 1, 2) & " " & MID(table.Code, 3, 2) AS Fo...more >>

Anybody ever use Data Junction or other third party tools for moving data between different database formats? My reason for asking is that in the next 12 months we are presumably integrating our application into an corporate scale enterprise version. Our current customers tend to be less than 20 ...more >>

Hi! I'm trying to retrieve a 'text' data column from a table, and return it in a text data type OUTPUT parameter in my stored procedure. However, no matter how I try, I cannot get T-Sql to assign the text value to the parameter. I've also come across a couple of postings on the web stating tha...more >>

I have a VB app that used Access locally and a Sybase server to "archive" the local records. I am now converting it to using SQL Server/Desktop Engine locally and SQL Server for the archive. The local database contains a field for storing the rec_id (identity) field from the archive data...more >>

I have a problem with people logging on as one user, but sql server keeps changing the owner to dbo. Sometimes the owner name will be their loggin account and sometimes it will be dbo. Is there anyway to stop dbo from becoming the owner, it is really fouling things up. There are only two u...more >>

Is it possible to access a database on one SQL server from a stored proc on another SQL server? I'm sure there must be a way, but I've never needed to do it before and I can't seem to find a reference to it in books online. Thanks!...more >>

I want to get the user login name and host name for any user who is accesing the databases thru enterprise manager. I found out I can execute sp_who with @@spid as parameter and I get back result as a select statement result. I want to know how can I concatenate loginname and hostname ...more >>

I did the following: 1. create table amit (name varchar(10) not null Primary key) 2. insert into amit values ('a') 3. select * from amit 4. insert into amit values ('A') When I fired the insert statement as in 4th step, i got 'Violation of primary key constraint.' Can anyone tell me...more >>

Hi, I have a remote Web server from which I want to retrieve data - from inside a SQL 2K stored procedure. I can do it with: sp_OACreate 'MSXML2.ServerXMLHTTP', @objHTTP OUTPUT sp_OAMethod @objHTTP, 'open', NULL, 'GET', @URL sp_OAMethod @objHTTP, 'send', NULL etc. However, I'm not ...more >>

Hello, I have created a recordset in ADO and would like to perform two different operations dependant on if the recordset contains one or greater than one record. However I seem only to receive the .Recordset value of -1, disregardless of how many records are contained in the cursor. How ca...more >>

Hi I just need to pull up a query which will bring up orders between a specified date range say jan 2003/ july 2002 and from this I have to pull up values that customers have not purchased say Tvs or radios how would I go about it thankyou...more >>

I've got a CONTACTS table that is used to store different types of contacts and therefore relates to many different tables (CUSTOMERS, SITES,etc). I can EITHER keep a relationship with each of this tables, creating columns at the CONTACTS table to store each foreign key, OR I can keep two ...more >>

Hi all, We are trying to insert rows from one table on an application db server into a destination table on a linked server. First we do a delete of matching rows, then an insert. But we get this error: Could not open table '"navoutboundcis"."dbo"."archivenav"' from OLE DB provider '...more >>