Rating Thread / Thread Starter	Last Post	Replies	Views
unique keys Hello, I plan to create a table with 3 unique keys. Combination of three fields has to be unique for each row in a table that are vendor ID (char... reneeccwest	08-07-2003 06:24 PM Erland Sommarskog	2	84
Need to create case sensitive Uniqiue Indexes Hi, How Can I create a case sensitive unique index so that A1 and a1 are treated as different ? I dont mind if I have to make a global DB... Steve Thorpe	08-07-2003 06:16 PM Erland Sommarskog	1	74
Re: GROUP BY question - Take II Forgot a couple of little things!! SELECT T1., SUM(T1.) AS TotalUnits, MAX(P.Prices) AS PricesMaxDate FROM MyTable T1 INNER JOIN ( SELECT T2.,... Yannick Turgeon	08-07-2003 05:17 PM Yannick Turgeon	0	68
MSDE login problem Hi all, I have bought Visual C# .NET 2003 Standard and downloaded the MSDE to use with it. I did install it with it's default options and now i'd... Lorenzo Bolognini	08-07-2003 02:34 PM Lorenzo Bolognini	2	67
how to group/list top 3 of each category w/o using Union? Hello, So my table contains say 100,000 records, and I need to group the categories in fld1 by the highest count of subcategories. Say... Rich Protzel	08-07-2003 02:32 PM Rich Protzel	3	78
Access2K front end to SQL SVR 2K -- users cannot see forms??? Hello: We've just switched to using Access 2K as the front end to our SQL Server 2K db. Great. Love it. However, one small problem. The users... Richard Hollingsworth	08-07-2003 01:13 PM Richard Hollingsworth	0	69
Help on Oracle RDB Migration to SQL Server. Hi, We need help on following things, 1. Inputs on creating comments on the columns & Tables of a SQL Database & generating the sql script of... Chandra Mohan	08-07-2003 01:11 PM Hal Berenson	1	77
Database design question I'm in the process of designing a database and would like some suggestion on how to architect it. I have 3 'objects', frequency, task, skill. For... Stephan Ranocchia	08-07-2003 12:26 PM Anith Sen	1	70
Free exam simulation software for sql server exams test your sql server knowledge -- See exams as it happens , absolutely free http://www.harisoftwares.com 1) Cytrix 2) Hacking and Cyber Laws 3) Visual Basic 6 4) VB.net 5) SQL... shiv	08-07-2003 08:55 AM shiv	0	66
client database is it possible to set a database to the client computers? i am trying to configure how this will work on my client computer but it returns an error... bher2	08-07-2003 08:53 AM bher2	0	73
Change collation in tempdb Hi, I'm using MSSQL2000. Is there any way to change the collation of tempdb database? I just realized that my devel and production tempdb have... Rolando	08-07-2003 08:51 AM Rolando	0	80
Question!!! Greetings! We have P4-2.4/1024Mb/37Gb(4 SCSI) platform with installation of MS SQL Server 2000 Developer Edition, 6 databases at all: 2 are... Aleksander	08-07-2003 06:00 AM WangKhar	1	98
Errore su transazione con trigger?? Ciao a tutti, devo eseguire una INSERT su un db in remoto...visto che non lo uso frequentemente utilizzo la funzione OPENDATASOURCE invece di linkare... Andrea Canegrati	08-07-2003 04:23 AM Andrea Canegrati	1	73
Inner join to lookup values twice? Folks, My secnario involves two tables - ObservationRegister, and Person. ObservationRegister contains most of the "useful" fields, including the... Steve Hall	08-07-2003 03:01 AM Steve Hall	4	61
Newbie Question Hello, A very simple question: What happens when two people work at the same time in the same record? The Last win or the first? Razor	08-07-2003 02:25 AM Razor	1	84
test papers on SQL DB HI... i need test papers on SQL DB. multiple choice with 3 levels of difficulty: beginner, intermediate and advanced. can anyone tell me where i can... Rohit Nim	08-06-2003 10:03 PM Ray Higdon	1	70
database comparison I am looking for some papers/information that compare relational databases such as oracle, mysql, sql server etc. I am particularly interested in... Susan Lam	08-06-2003 07:22 PM Daniel Morgan	3	73
Re: Inconsistent delay posting record Ryan (ryanofford (AT) hotmail (DOT) com) writes: The most likely reason would be blocking. You can examine this by running sp_who or sp_who2 when... Erland Sommarskog	08-06-2003 06:25 PM Erland Sommarskog	0	67
schedule problem Hi I have problem with scheduling tasks. I have one SP, where I decide to fire or not another SP and I prepare parameters for this new SP. The... Maciej	08-06-2003 06:01 PM Erland Sommarskog	1	89
finding active users from sysprocesses I am trying to find a select on sysprocesses that would list all the active logins. An active login is a login that has a TSQL statment being... kr	08-06-2003 05:38 PM Erland Sommarskog	2	74
Re: select ... from sysprocesses Take a peek at the system function fn_get_sql (SQL 2000, sp3) in SQL Server Books Online. -- - Anith ( Please reply to newsgroups only ) Anith Sen	08-06-2003 05:35 PM Erland Sommarskog	1	83
SQL Debugging My colleagues and I have not been able to successfully set up SQL debugging on a SQL 2000 instance running on Windows 2000. Is there a checklist... Jonathan Ryan	08-06-2003 05:30 PM Erland Sommarskog	1	86
Why isn't table updatable???? Hello: I've just converted my Access 2K db to SQL Server 2K and the conversion went smoothly. I created users, roles, views and forms and gave the... Richard Hollingsworth	08-06-2003 05:25 PM Erland Sommarskog	1	76
OT: Does it make sense to create re-usable component for data update? I think I fully understand the old saying of "no single leave is the same", different database would have different structure / schema for different... Doug Baroter	08-06-2003 04:34 PM Doug Baroter	0	82
Help with a query Greetings, I have the follow table structure: CREATE TABLE . ( (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , NOT NULL , (50) COLLATE... Tom Nunamaker	08-06-2003 04:20 PM DHatheway	4	91
Update order Hello, I'm using SS2000 on NT4. If I run the following query, is it garanteed that the field "OldField1Value" will hold the value Field1 had before... Yannick Turgeon	08-06-2003 02:42 PM Yannick Turgeon	2	82
Newbie question - do I need to SQL Server client? This is very much a newbie question as I have not worked with MSSQL Server before. I may be hosting a MS SQL Server database for a web site soon... Stevio	08-06-2003 10:28 AM Stevio	0	66
Converting Rows to Columns in SQL7 I do a: SELECT * FROM xxx And Get: Date Place Sum A M 1 A O 3 A P 2 B O 5 B M 4 Brad Joss	08-06-2003 07:29 AM Rajesh Garg	2	68
Database level change I have many tables and in those i require to change some data. Say from ARCA to ARCAEX. I am sure that the string is unique in the sense there will... Rajesh Garg	08-06-2003 06:42 AM Rajesh Garg	2	75
How to move data files hello, my problem is how to move data files drom drive c: to drive d: ?? -- MarcinS MarcinS	08-06-2003 05:43 AM Ray Higdon	1	74
The TIMESTAMP data type Hi I'm interested in using the timestamp data type & I have some questions. As far as I can understand the contant of a timestamp column is a... David Greenberg	08-06-2003 05:29 AM Simon Hayes	1	81
Is it possible to "disable" all restrictions on a Ms sql DB? In meen. primary keys, NOT NULL, IDENTETIES...et.c I have to do a maunally, one time, building of a database. Sometables has to stay an some are to... Flare	08-06-2003 05:22 AM Simon Hayes	1	83
Re: Online magazines SQL Server "EtN" <napel25 (AT) hotmail (DOT) com> wrote Have a look at SQLServer Magazine www.sqlmag.com Ronnie Chee	08-05-2003 10:13 PM Ray Higdon	1	72
Need answer to SQL question I would really appreciate it if someone could give me the answers or direct me to a place that would have the answers to the following 5... Troy	08-05-2003 06:52 PM Bas	3	78
How can I debug Stored Procedure? Hi there How can I debug Stored Procedure? Thanks Elham GH	08-05-2003 06:06 PM Erland Sommarskog	1	63
SQL server 2000 installation problem on Windows 2000 Professional Hello, I received the error message below when i'm trying to install SQL Server 2000 standard edition into a Windows 2000... Thomas	08-05-2003 06:03 PM Erland Sommarskog	1	75
Re: View Performance "bharilal" <bharilal (AT) hotmail (DOT) com> wrote Assuming it's not an indexed view, there shouldn't be any real difference, since SQL Server... Simon Hayes	08-05-2003 05:56 PM Erland Sommarskog	3	111
SQL UPDATE Conditionally This is probably a stupid question, but here goes: I am trying to update a table differently based on what is in one of the columns within the... Orwell	08-05-2003 03:30 PM John Gilson	1	75
"Order by" error running DBCC DBREINDEX I'm running a simple DBCC DBREINDEX ('myTable') and I receive the following error: "Server: Msg 169, Level 15, State 2, Line 2 A column has been... John Morris	08-05-2003 03:17 PM Arun Marathe [MSFT]	2	79
One Command Keeps Causing "'tempdb' is full" Error ( 1 2 ) I keep getting the following error message when I run a serie of SQL commands: Server: Msg 9002, Level 17, State 6, Line 15 The log file for... Jay Chan	08-05-2003 12:24 PM Jay Chan	10	116
retrieve records affected count from ADO? Hello, If I run an action SP from MS Access using ADO: ... cmd.execute where the SP is something like Create... Update tbl1 set fld1 = 'something'... Rich Protzel	08-05-2003 11:33 AM Rich Protzel	6	74
Change Object Owner to dbo Using SQL Server 7.0 Trying to change an objects ownership to dbo with EXEC sp_changeobjectowner 'AssignInvoiceNumbers', 'dbo' which gives the... Nath Wilson	08-05-2003 10:07 AM Simon Hayes	1	71
Re: Editing tables in Query Analyzer mjm (AT) barwonwater (DOT) vic.gov.au (Michael McGarrigle) wrote in message news:<9d0cafdc.0308042222.762a1f2a (AT) posting (DOT)... Simon Hayes	08-05-2003 05:11 AM Simon Hayes	0	54
Optional parameter on joined field which could be null?! I have two tables: eg. a person-table (no nulls allowed), with an id and so on, and a person_course table (an intermediate table in a many-to many... Ole S. Pedersen	08-05-2003 04:52 AM Simon Hayes	1	56
Re: I must login as SqlServerAdmin before agent emails can be sent. Check the KB article 281293 at http://support.microsoft.com/default.aspx?scid=kb;EN-US;281293. If this won't help, check the articles... Dejan Sarka	08-05-2003 02:46 AM Dejan Sarka	0	67
running script Is it possible to run SQL certain script from the client application ? thanx srdjan	08-05-2003 01:48 AM Srdan	3	84
MSDN's Estimating the Size of a Table I was hoping I can get some help regarding subject mater located... TZone	08-05-2003 01:24 AM TZone	2	74
SQL Server 2000 & Active Directory: Problems querying Hello -- I'm trying to get SQL Server 2000 on a Windows 2000 Server to be able to query an Active Directory. We've got two domain servers one... James Allan	08-04-2003 10:23 PM Ray Higdon	2	63
Replication problems I have set up a server with a publication of a very large database. A backup server needs to retrieve the data and do some massive calculations... Simon B. Nielsen	08-04-2003 08:41 PM Greg D. Moore \(Strider\)	2	69
Standby Server Hi: Anyone has a detailed procedure description about how to setup a standby server? Microsoft makes it sounds very easy which are more... Xiaodong Han	08-04-2003 08:30 PM Greg D. Moore \(Strider\)	1	89

Page 273 of 282

273

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off