I was wondering if any body has used Internet as a WAN (Wide Area Network) to provide database access. I know about web services but I like to experiment with using Internet as a extended network (web server behind one router and database behind another). Any ideas on where to look for this? ...more >>

I need a sql statment to return a list of tables for a given database where the Recovery Model option is Simple. TIA Rob ...more >>

I have one table with 300,000 records and 30 columns. For example columns are ID, COMPANY, PhONE, NOTES ... ID - nvarchar lenth-9 COMPANY - nvarchar lenth-30 NOTES - nvarchar length-250 Select * from database where NOTES like '%something%' Is there a way to get results from this query in ...more >>

I have several default constraints defined on a table. When I use the Object Browser and expand the constraints for this table and right-click and then select "Script Object to New Window As Create", a create constraint statement for a different default constraint is displayed than the one I ju...more >>

I am using SQL 7 with an MS Access 2000 MDB front end, using bound forms with ODBC linked tables. In one form, the user needs to be able to check a box to select one or more records. This is accomplished with a local table containing two fields: the primary key value of the SQL table and a boo...more >>

Sybase and DB2 both have the capability of tracking user activities at a number of levels: invalid access attempts to databases, table, etc.; creation/deletion/modification of database objects/users/groups, grants/revokes. For MS SQLServer, the only setting that I've seen in the documentation ...more >>

SQL Server 2000 I will to compare a normal table with a replicated audit table having identical columns. I wish to report on the differences between the data. How can I loop though a "column list" in TSQL rather than explicitly naming each column to compare ? Thanks, Craig ...more >>

Dear friends I am conducting a survey on Relational Database usage and would like your help. The study is part of my MBA Dissertation. Could you kindly spare 5 minutes to take part in this survey? http://FreeOnlineSurveys.com/rendersurvey.asp?id=120816 Thanks Rajeev ...more >>

Any recomendations on how to store organization trees on a database with lots of paths and branches? Any white papers out there that explain this? Thanks ...more >>

Using "SELECT * " is a bad practice even when using a VIEW instead of a table? I have some stored procedures that are identical with the difference of one statement in the WHERE clause. If I create a single View and specify also in this View the WHERE clause that is common in these stored pr...more >>

I am getting a type mismatch error when I do a bulk insert. ---Begin Error Msg--- Server: Msg 4864, Level 16, State 1, Line 1 Bulk insert data conversion error (type mismatch) for row 1, column 14 (STDCOST). ---End Error Msg--- The STDCOST is set to decimal (28,14) and is a formatted in Ac...more >>

Hi I have a text file with this information -BEGIN----------------- tekst.txt------------- 10, "firstname", "lastname" 11, "Mette", "Larsen" --| |-- 6 000 000, "Michael", "Houmaark" -END-------------------- tekst.txt------------- I use this SQL-query -BEGIN------------------SQL---------...more >>

I am trying to use the bulk insert command but I am getting the following error: ---Begin Error Msg--- Server: Msg 4867, Level 16, State 1, Line 1 Bulk insert data conversion error (overflow) for row 1, column 3 (PRICE). ---End Error Msg--- The data is formatted as a number, single with 1...more >>

I am trying to use the 'Bulk Insert' command to load a data file into a MS-SQL db. The line I am using is: Bulk Insert SVC_Details From "C:\XFILE.TXT" With (FieldTerminator = ',') I have tried the file name with " around it and with ' around it and both the " and ', but every time the Quer...more >>

Here is my situation; I have two tables in a MS-SQL DB. One table with dollar amounts and service codes. I have a second table that I want to move some information into from the first table. The catch is I want to move one field as is from the first table to the second, but the rest of the ...more >>

Hi guru, I've been new company for only a month and started analysing Index Fragmentation. After I ran DBCC DBREINDEX and capture data into permanent table, I 've seen lots of tables with no indexes. These tables showed: Very low scan density, High extent fragmentation High Avg. Bytes F...more >>

Hi, I have the following table: Column 1 Column 2 A A A B A C B F B F C G C A I need a query to return the following: A null B F C null How can I do that? Thanks, ALex ...more >>

Dear group, is it possible in SQL-Server to see when a stored procedure was executed ? I would say it is only possible with some traces but not with the standard settings. For a short answer on that matter i'd be thankful. Regards Uli ...more >>

Hi all, We have standardized on Hyperion as our reporting tool. So far I have only set up a couple of Access databases as data sources for it. Now there is a request to report off our eOn (telephony management) SQL Server database using Hyperion. The eOn SQL Server box is in a workgroup th...more >>

SQL newbie alert... I have a table with the fields Location, MachineName ,Hours and Date. (The actual database is more complex but it will do for the purposes of this post) I want to return Location, MachineName and the sum of the hours between two dates. Here is an idea of what I need, al...more >>

Hi......... Its been awhile since I've touched SQL statements, so I need some help with writing a JOIN statement to query 3 tables. The dB has 3 tables with values Applications -Application_code(Primary key) -Application_name Applications_Installed -Computer_name(Pri key) -Application...more >>

Hi, I am always confused about what to use as the key for a table. Let's say I have a company-employee table. [company]---*[employee] My co-worker likes to use an AutoNumber or Counter as the key for the [employee] table (and everything). I personally use an actual key set for the [e...more >>

In a column I have some values for part names. The 6th character tells you where the part came from, and this is the same scheme for every single part in the database. If I want to do something like return the basic name of a given part, without the factory identifier character, I need to repl...more >>

Hi all, Hope there is a quick fix for this: I am inserting data from one table to another on the same DB. The insert is pretty simple as in: insert into datatable(field1, field2, field3) select a1, a2, a3 from temptable... This inserts about 4 millions rows in one go. And since...more >>

Hi guys Is there any way I can run this query faster? Should I take out the ORDER BY clause? This is supposed to return 17,000 rows and takes around 30 minutes or so. Is there no way at all to get this result faster? select r.AttorneyName, r.sitename, r.applicationid, r.clientsurname, r. cl...more >>

Beyond my control: I am finding control characters (likely tab) is making its way into address fields of our operational system. This is messing me up when I load the data into our warehouse w/ BCP (fields get shifted). Is the a nifty way to strip control characters from data? TIA Rob ...more >>

I am having problems accessing DTS after install SP4 and was wondering if someone could offer some advice. I installed SP4 and got the following error after it competed. Unable to write to response file 'U:\WINDOWS\setup.iss' during recording. Please ensure enough space is available on targ...more >>

SQL Server 2000 8.00.760 (SP3) I've been working on a test system and the following UDF worked fine. It runs in the "current" database, and references another database on the same server called 127-SuperQuote. CREATE FUNCTION fnGetFormattedAddress(@WorkID int) RETURNS varchar(130) AS ...more >>

Hi, Suppose I have a table something like: name (VARCHAR(64)) age (INT) quotation (TEXT) ================================================= Donald Trump 50 I am rich Bugs Bunny 26 What's up doc ... and a template string something like: SET...more >>

Our HP representatives are telling us that backing/restoring our MS SQL Servers with "HP Data Protector (HPDP)" is better and safer than using MS Sql's backup/restore process. I have strong hesitations, because MS Sql's processes gives us a great deal of flexability. Has anyone have any e...more >>

I can use the IN with the WHERE clause as example: SELECT * FROM NORTHWIND WHERE LASTNAME IN ('FULLER','KING') I want to use the IN and LIKE at the same time: SELECT * FROM NORTHWIND WHERE LASTNAME LIKE ('A%','B%') I know this is a simplistic example, but the members for the IN will be ma...more >>

Hello everyone, I have a query problem. I'll put it like this. There is a 'publishers' table, and there is a 'titles' table. Publishers publish titles (of course). Now I want to make a query (in MS SQL Server) that would return the last title published by every of the publishers. Quite clear s...more >>

Hi, Do you guys know what's wrong with a one-to-one relationship? The reason I want to make it like this is that at the very end of the chain, the set of keys is huge. I want to limit the number of columns to be the key. i.e. the [company] table has 1 column as the key. The [employee] ...more >>

Hi , I have set up my database to be using "Simple" mode. This will not log any txns ? I have got the err message saying the log file is full and i need to do a txn log backup i do not understand why , could anyone kindly advise ? tks & rdgs -- Message posted via SQLMonster.c...more >>