Hi, I have the following error that I have gotten when I try to use Crystal Reports within Visual Studio.Net 2003 and within a VB ASP.Net app that accesses a SQL Server 2000 Database CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed. Searching through Google it seems t...more >>

Hello all, i want to make a non-deterministic UDF... is this possible? Heres what i have... its an online catalog. The site has an option DAYS_LIST_AS_NEW, where the owner can specify a number of days for which a product is listed as new, so if the user puts a value of 30, products are listed ...more >>

Hi, I'm fairly new at SQL query language and am running an example program from a text in VisualBasic where I want to just insert a new row in an existing table, but I keep getting a syntax error in the INSERT INTO statement. Here's the program flow and below that, the error message caught i...more >>

Hi there, I have a table as defined below that contains some configuraton values. ConfigurationID CharacteristicID CharacteristicValue --------------- ---------------- ------------------- 1234567890 Lenght 2300 1234567890 Height 1900 12345678...more >>

hey all, can someone please help me design the following: 9/29/05 Cut Lawn $20 Date of Service Service Type Price Payment Due Trans Type Payment Amount Payment Date 9/29/05 Cut Lawn $20 10/29/05 Bill 9/29/05 Cut Lawn $20 10/29/05 Payment $10 10/1/2005 9/29/05 Cut Lawn $20 10/29...more >>

Thanx to those who have helped previously. You have been quite exceptional in your help!! I am learning so much!!! I have accidently posted this under an older thread so forgive the double post. I have the following query: //query above asigns @attempt_id SELECT Count(DISTINCT asm...more >>

I believe I should be able to link to a .dbf file as a Linked Server through SQL Server. For instance, in C# code, we can connect with a DBF file using either ODBC... --------------------------------------------------------- System.Data.Odbc.OdbcConnection odbcConnection = new System...more >>

Hi, I've a problem executing sp_changedbowner in my stored procedure which is saved in the master's stored procedures. The code fails after executing @proc1. The errors says that i could not find proc2. Here's the code: CREATE PROC usp_RestoreDB( @db_name varchar(10), @backup_locat...more >>

Hi all, I Apologize if I'm not clear, I'm going to try and explain what I need. This query works fine: On the table "k" there is a display_order column that I would like the k.sentence_name ordered by. If I add vk.display_order in the order by, I have to add it as well in the select but,...more >>

Could any one please recommend some good books on sql server 2000 ETL best practices ?? I am trying to learn some best practices regarding this subject so any white papers, articles, web sites, books would be greatly appreciated. TIA......more >>

Hello, I have a stored procedure which is traversing a tree. The table looks like this: Organization (OrganizationId, ParentOrganizationId, ect....). The stored procedure is looking like this: ALTER PROCEDURE dbo.ShowHierarchy ( @Root varchar(10) = NULL ) AS BEGIN SET NOCOUNT ON ...more >>

We have a dev server, HORSQL01 and a production server, HORSQL02 Each one is listed under the EM Linked Servers node of the other. But I am confused. When I open up the Linked Servers\HorSql01 node, I don't see a list of databases on HorSql01, I just see a tables node and a view node. Ca...more >>

In a multi-user environment, this proc is expected to return distinct values for concurrent users - but it doesn't, some duplicates are returned. I thought that the 'BEGIN TRAN/COMMIT' would provide the required locking - I'm guessing that's where I went wrong. How do I fix this proc? The DDL ...more >>

Hi, I'm having a tough time writing a sql stmt. Any kind of help is very much appreciated. The info is as follows: SalesOrder sono so-suffix solineno qtyord netamt 1495738 1 33 3 4779.45 1495738 0 33 3 0.00 1490...more >>

This seems like it should be simple... I have a simpel select query that is selecting customer records. SELECT CustomerNumber as [Cust #], ItemNumber as [Item #] WHERE CustomerNumber IN ('1', '2', '3') Sample result: Cust # Item# 1 100 1 ...more >>

My application retrieves records from a SQL Server 7.0 DB table for which I am using a stored procedure but while coding, I am not aware of the no. of columns existing in that DB table. Neither am I aware of the column names while coding. Also more columns can get added to the table in the futur...more >>

Hello all, how can I extract image strored in DB in to file? Will something like this work? DECLARE @cmd VARCHAR(2048) SET @cmd = 'bcp select history_image from recipient where recipient_id = 1 queryout c:\test\625954.jpg ' EXEC master..xp_cmdshell @cmd, NO_OUTPUT...more >>

Hi all. The following command don't work on ours SQL server anymore. Not sure why, but could it be that the command "Net Send" is removed for NT 2000? Any ideas. Thanks Geir DECLARE @Message varchar(255) Set @Message = 'net send USER Message to OLNY from SAM : . TEST, TEST, Price to ...more >>

Hello all! I'm having problems regarding executing stored procedures under differents users or different database. I have, let's say 100 tables with the same name, but different owners. Picture this scenario: User: dbo (login: sa) Table: MYTEST (FullName: [MyServer].[MyDatabase].[dbo].[MYTE...more >>

Hi all, The following query returns the following results. SELECT docCategories.docCat, docNames.docName, docVersions.docVersionDate FROM docCategories, docNames, docVersions WHERE docNames.deletedFlag = 0 AND docNames.docCatID=docCategories.docCatID AND docNames.doc...more >>

It seems by default the public role is granted very generous permissions. When I tried DENY ALL TO public is didn't seem to have any affect. I know it will work by listing the objects or going into enterprise manager and denying. I am tempted to pull all permissions from public and then onl...more >>

Hello I've a table of Users with an identity key Some records are inserted by a replication system which sends records with key like 2-4-6-8 ... and put them into the table with a INSERT sql Other records are inserted via web I need that the records inserted via web takes a key lik...more >>

I accidentally did something similar to this, and I can't figure out why it doesn't give an error. Use Pubs Select * From Authors Where Au_LName In (Select Au_LName From Publishers) Of course, "Select Au_LName From Publishers" by itself gives an error message since Publishers doesn't h...more >>

I have XML file with the same structure as table in SQL 2000. What is the fastest way to insert all data from xml file into table? Using data set, BLOB insert, XML insert,... regards, Simon ...more >>

For some reason I cannot connect to a SQL server with EM over a VPN connection, I keep getting a timeout error. What bugs me is that this "timeout" happens within a second or two - normally network timeouts are like 30 seconds. I've never had this problem connecting to other SQL servers over...more >>

Hi, I need an advice. I have a new project where I have to store employee salary values in order to keep historical representation of all changes done to the employee record. Below is the approximate model how I am going to proceed. My question is, how would I pull ee salary at certain da...more >>

I've got a program written that runs on one computer and performs bulk updates to a SQL Server 2000 table on a different computer. I also need transactional behavior, so I have to specify a value for TempFilePath on my SQLXMLBulkLoad3Class object. I do not have permissions to create folders, ...more >>

hello all, i have a table thats getting about 140,000 new records a day from a program reading data from a socket (about 300 every 3 minutes). in addition to the primary key it has an 8 byte date/time field thats indexed. there are also two full-text indexed columns with change tracking and up...more >>

Background: sql2k on windows 2k3 servers. I'm managing an remote offsite sql server for a company. I recently installed a second instance of sql server (server\dev) on the same box, but haven't been able to register the 2nd instance remotely from my laptop. I used mstsc to access server direct...more >>

Ok, I missed the boat somewhere. I prepared the query below to go though all the columns and tables in the database and return the count of distinct values for each column and label them with the table and column names When I run the query, I receive the following error from the part la...more >>

The 2 queries below return different values for b.cost. I don't understand why. The 2nd query returns 575.112, the correct value, where the first returns 580.00. declare @BeginDate Datetime declare @EndDate Datetime set @BeginDate = '20050928' set @EndDate = '20050928' DECLARE @FinalDate...more >>

Hi all, I am still learning my way around TSQL!! SELECT TOP 1 @attempt_id = asmt_v2_attempt_id FROM asmt_v2_attempts WHERE asmt_v2_employee_id = @eid AND asmt_v2_area_id = @aid ORDER BY asmt_v2_attempt_id DESC Using this print statement i can return the output t...more >>

Hi, Can anyone help me by telling the sql statement through which I should be able to locate the table which contains that ColumnName.... Thanks in Advance KD...more >>

Which system table is the currently defined size (hopefully the total size) of the data and log devices found? I'm assuming in master somewhere? sysobjects? I just can't find it... thanks ...more >>

O.k. the following query works, unless there is more that one value a column. It tells me, "Subquery returned mor than 1 value. This is not permitted when the subquery follows =, or when the subquery is used as an expression". How can I get this query to format each item in a column? d...more >>

First of all....sorry for writing in english. I'm trying to pass from access to msde. I have a query that returns some values to populate a listview. With access this query works in the right way, but in msde i have some problems . That's the query rs.Open "select * from anagp inner join ing...more >>

Hi, I need to make a query on a single table containing historical stock data, something like: ID, StockID, Date, Open, Close, Volume, ... The problem is that I need to get All records for the stock, for which at least one record matches some condition. An obvious solution is: select ...more >>

Hi all, Does any one know tsql syntax to open and close a file on network drive? Of course this command should execute in proper security context. TIA.....more >>

Hi, I need get value of IDENTITY column after a insert (of the inserted item), hava way to do this automatic, or same function that do this? Thanks ...more >>

Hi all, I have a question about triggers. I created a Update tigger on a table. When i do a update statement on the table on multiple rows, the trigger only fires ones. Can someone please help me with this problem..... Regards Ron ...more >>

Hi pls find time to throw some light on whether and where to use EXE/EXECUTE and SET/SELECT? What are the differences? Another thing..if we start a trigger and within the transaction statements we first truncate any table and then call rollback, will that table be rolled back or not? What...more >>

Hello, I use a SQL Server with ODBC driver and >NET C#. I want to convert a date field with adDBtimeStamp format to a DATETIME format, but no solution could be found till now. My query is as follows: SELECT received_at as EXPR1 FROM TTable WHERE datepart(week(datetime(r...more >>

How do I translate this statement from Access SQL to MS SQL: UPDATE Market INNER JOIN MarketSys ON Market.MarketID = MarketSys.CurrentmarketID SET Market.EndPeopleRegDt = '1/1/2006'...more >>

dat temp ani 2 fruit 3 ani 1 clothes 4 ani 3 i want to make below that from 1 table(name:tbl) upper aniCnt clothesCnt fruitCnt 3 1 1 how make query statement? *** Sent via Developersdex http://www.developersdex.com *...more >>

I am running the index tuning wizard to evaluate a query for optimization. I am applying additional non clustered indexes were I feel it should benefit the query. After running the Index Tuning Wizard - the recommendation is to remove the indexes that I have applied. Looking at the Statisti...more >>

Hi, I work as part of a testing team that does a lot of stress testing of database. At times we run SP's that goes into a loop millions of times and inserts test data. Once in a while these SP's terminate abruptly because of lack of space and I get a fatal error with severity 17. How do I g...more >>

hello, i need to read the value of a parameters for the loop from a local varchar variable example for the variable: '1,4,8,9,22' or '3,5' or '44,5,8,9' How can i get the information - how many comaseparated values are in that variable - result -> 5 - what are this values val(1) ...more >>

hi friends, whats the command used to bulk copy all the tables from the database? pls help me to solve this. thanks vanitha...more >>

Hallo, MSDB.dbo.BackupSet logs all backups is it possible find Status of Backup (Success / Failed)? Table "BackupSet" hasn't any information about it. I need log and notify all backups with status (It must be a windows service (c#) Thanks ...more >>

my databases are designed 5 years ago and users have creating tables on their own. so the design is bad it is facing performance problems and query timeout issues. it is taking time to retrieve the records deadlock issues are cropping up inserts are not working in replication what should i do...more >>

Dear all, I'm very puzzled by SQL Server 2000 sometimes ignoring IDENTITY columns in INSTEAD OF triggers on a VIEW. If I create a VIEW on a TABLE with an IDENTITY column but *witout* computed columns in the view, then I can insert into the view and omit the IDENTITY column. In this scen...more >>

Hi. i have users having access to different database stored on different servers I'd like to access all user details.I s there a way? please assist -- Eager to Learn...more >>

can i write a trigger which tells me when a deadlock occurs...more >>

Help! I must allow my users to specify the file name (but not the path) for an Excel generated CSV file so that I can put the data in their billing table. I have no control over the filename, but the path is 'e:\path\' I tried loading an intermediate table as: CREATE PROCEDURE [LoadTest]...more >>

Hi everyone, I am designing a Database but I don't have much database architecture experience. I have a kind of issue in the schema of the Database we deisgn that is repeated in a few places. As it seems to me something pretty basic, I think that this must be some kind of pattern that someo...more >>

Hi , Can you please tell me how to retrieve schema associated with a query? Here is the sample query for which i want to know DATATYPE, LENGTH of every column which i'm selecting in the query. SELECT Tbl2.Name, Tbl3.Age, Tbl1.ID, Ttb2.DOB FROM Table1 Tbl1, Table2 Tbl2 WHERE Tbl1.Key = Tb...more >>