Rating Thread / Thread Starter	Last Post	Replies	Views
Re-try count of Replication I have 2 machines running MS SQL 2000 SP3 on separate network, Machine A undergoes transactional replication to Machine B, recently the network is... Rex	08-28-2003 12:06 AM Rex	0	57
Re: Datetime column and blank entry Doug Baroter (qwert12345 (AT) boxfrog (DOT) com) writes: There is no such thing as a "blank" for a date column. What would a blank date mean? -... Erland Sommarskog	08-27-2003 10:11 PM Doug Baroter	3	46
Re: Joining three tables If you post your DDL you can get an exact answer, without it, here's best guess tbl - authors tbl - book tbl - junction select... Ray Higdon	08-27-2003 07:02 PM Ray Higdon	0	59
ALTER table command Hi, I'm trying to run the ALTER TABLE command using a dynamic string for the table, like so: DECLARE @TableName CHAR SET @TableName =... Paul Sampson	08-27-2003 06:03 PM Paul Sampson	3	50
Adding new columns to all tables using a script Hi, I'm trying to add a modified datetime and userid to all 72 tables in my SQL 2000 database. I have the script to do one table, and a cursor, but... Paul	08-27-2003 06:02 PM Paul Sampson	3	49
Multiple ids in a field I have a book cataloge where I have an author id linked up to the book. However, I'm finding that some books have mulitple authors, and I'm wondering... Bill	08-27-2003 05:31 PM Erland Sommarskog	6	52
Re: ODBC, C(++) and SQL Server pluton_ (pluton_onet (AT) poczta (DOT) onet.pl) writes: I have to admit that I have never used this option before, and I don't really understand the... Erland Sommarskog	08-27-2003 05:08 PM Erland Sommarskog	0	54
Restoring a database only from MDF and Log file Hello. Can anyone tell me if a SQL Server 2000 database can be recovered only from the MDF and log files ? I have no backups. Thanks in advance Dave Pylatuk	08-27-2003 04:52 PM John Bell	1	47
Using many to many tables I'm having a problem writing the correct sql to bind togeather three tables. Here's the problem: I have a table for detail information on books that... Bill	08-27-2003 04:38 PM John Bell	1	53
Updating records from db2 I have two tables one on SQLServer and one on DB2. I want to update SQLSERVER table with some information that is on the DB2 table. I have unique... Mike	08-27-2003 01:07 PM Mike	0	54
Triggers - It cannot be this difficult Hi I am trying to produce an update trigger. I understand the concept of delete and insert triggers without a problem. Unfortuantely, the update... Simon	08-27-2003 11:08 AM jmj	5	109
Re: Selecting the Latest Date for Each Record There are many ways you can construct your SELECT statement. Here is one: SELECT * FROM tbl WHERE address_date = (SELECT MAX(t1.address_date) FROM... Anith Sen	08-27-2003 09:26 AM Shepherd Moon	1	93
Re: Why is sp_delete_backuphistory so SLOW - any alternatives One of our msdb dbs had about 1.3 million rows for backupset.This was taking 4 mins to delete each row of backupset and related rows in other tables.... petescutt	08-27-2003 08:41 AM Ian Stocks	2	148
Restore database to a certain point of time. I will make it simpler to look... I have DB1 - as backup for day 1 LOg1 as backup of logs T1 T2 T3 T4 T5 ...some transaction on day 2 Now i... Rajesh Garg	08-27-2003 07:14 AM Ian Stocks	2	46
DTS - from table to xml file I have a query that generates xml: SELECT id, Name FROM Table ORDER BY 1 FOR XML RAW It returns a single row with one... Krzysiek M.	08-27-2003 07:07 AM Krzysiek M.	0	55
replication and log shipping Hi, Ive a few questions and would be grateful for any assistance/comments from experience as Ive not that much dba experience , we have 3 servers... Eric	08-27-2003 04:40 AM Eric	0	47
query differences Query analyzer vs php-file? hi, I'm having trouble with a query. running it in SQL Server 7's Query Analyzer gives me the correct output, but when I put that code inside my php... Obscurr	08-27-2003 04:05 AM Obscurr	0	39
How to backup/restore the server list in Enterprise Manager Hi, In case of a remastering of a client, I need to backup the Enterprise Manager configuration (the groups, the declared servers in the groups),... rjp	08-27-2003 03:24 AM rjp	2	51
Java variable for db not found My configuration is as follows. I have a Linux MySQL server database on one box and I want to connect to it from a local Windows XP laptop. My... Jerry	08-27-2003 02:42 AM John Bell	1	53
Use getdate function in a own Function Hi, I have written a stored proc with some temporary tables and also used a getdate() in my stored proc. When i try to call the sproc the error is... Rajesh Garg	08-26-2003 11:20 PM Rajesh Garg	5	63
Re: Query Output Formats? In QA -> Tools Menu -> Options Submenu -> Results Tab -> Default Results target - Results to file... Results Output format - CSV -- - Anith ( Please... Anith Sen	08-26-2003 06:37 PM Layne	2	49
ORDER BY columns in SELECT list? According to BOL, columns in an ORDER BY clause do not have to be in the SELECT column list unless the SELECT includes DISTINCT, or the UNION... Jeff Mason	08-26-2003 05:06 PM Anith Sen	1	55
Obtain contents of stored procedures Hi all, I need to be able to obtain the full contents, i.e. sql statements inside, of all procedures in SQl Server 2000. I am using MS type 4 JDBC... Vien Nguyen	08-26-2003 05:04 PM Anith Sen	1	47
SQL Statement help (GROUP BY) I need this to work: SELECT FROM WITH (NOLOCK) where ='a' GROUP BY , HAVING COUNT () > 1 The problem is that I get an error that needs to be in... Robby McGehee	08-26-2003 04:53 PM Gert-Jan Strik	3	40
Replace-type function for Text datatype I have a table that has a Text datatype column that has gotten some garbage characters in it somehow, probably from key entry. I need to remove the... Zack Sessions	08-26-2003 01:57 PM Zack Sessions	3	63
The following prints out "0" - SQL procedure and use of the "charindex" function. My code prints out 0 for the value of charindex ( 'Hello.', '.' ). Did I miss something? I think it should print out 6! Robin Tucker	08-26-2003 11:23 AM Robin Tucker	1	48
Re: query question inna (mednyk (AT) hotmail (DOT) com) writes: CREATE PROCEDURE getclientamounts @datefrom datetime, @dateto datetime, @clientid integer AS SELECT... Erland Sommarskog	08-26-2003 09:37 AM inna	1	47
Urgent Help Required - Recovery I have a scenario like this....... update esan set tes_address_city = 'TEST1' --at some time update esan set tes_address_city = 'TEST12' --at some... Rajesh Garg	08-26-2003 09:29 AM Rajesh Garg	1	43
Drop all table Hi everybody, I need some help in SQL Server. I am looking for a command that will "Drop all user table" in a user database. Can anyone help... Sabrina	08-26-2003 08:10 AM Dan Guzman	1	55
insert Into question - Newbie Hi I have 2 tables. The first one contains lots of records, the second one is a cut down version of the first. I need to filter the first table and... aaj	08-26-2003 06:22 AM aaj	0	42
column type I am putting together a SQL table which will hold a latitude and longitude for each record. An example of a latitude is: 47 05 36.5 Which column... Jeff Godfrey	08-25-2003 08:33 PM --CELKO--	3	72
Another database transfer question Hi all This is a super simple problem I am sure. I was playing with the DTS Import/Export tool to see if I could transfer and entire database... Ray Watson	08-25-2003 05:42 PM Ray Watson	1	45
Re: NULL as unassigned value? If a Module has not yet been assigned to an Item, then really because of the relationship, the Item has not been assigned a Module yet. And... Gert-Jan Strik	08-25-2003 04:10 PM Gert-Jan Strik	0	47
I am struggling through views Hi there, it's me again. I am having trouble with a view again. I am trying to do a calculation, but there are some checks that need to be taken... Rowan	08-25-2003 03:44 PM Rowan	4	62
Help with SQL Update Query -- Not sure how to approach this situation Hello, I have a rather large table in MS SQL 2000 that I'm writing reports in Crystal from, but I'm unsure how to get the various data files... Alex	08-25-2003 03:24 PM Steve Kass	2	47
Installation of SP3 on an instance of SQL Server 2000 Hi, I installed one more instance of my SQL Server 2000 on a Win2K server and then tried to install SP3 for the the instance which I installed. The... Subodh	08-25-2003 01:45 PM Subodh	0	47
Calling Executables from SQL Server and getting return value. Hi All, I have a requirement of calling a Executable from SQL Server. I know we can use - EXEC @result = Master..xp_cmdshell... Chandra Mohan	08-25-2003 08:29 AM Dan Guzman	1	47
Re: Problems installing MS-SQLserver 2k Hi, Which version of SQL Server are you trying to install. SFAIK the "Standard" Edition will only install Server components on a Server Operating... BillPJ	08-25-2003 07:22 AM Simon Hayes	1	40
Need help on Performance Monitoring I was wondering if the CPU is the bottleneck. Hence I used the Performance Monitor to look up some values. Here are the results. Counter ... Peter Ang	08-25-2003 03:17 AM Simon Hayes	1	50
Unique Index for two columns in a table Hi, I would like to add a unique index that consists of two fields in a table. e.g. tbl_A (field1,field2) -- field1 & field2 Indexed and... June Moore	08-25-2003 01:57 AM oj	3	42
University Of Washington News The University of Washington, Seattle, is offering two certificate programs, beginning in October, for those with significant background... Daniel Morgan	08-24-2003 12:53 PM Daniel Morgan	0	60
[ANN] FireStorm 1.1 Java code generator for MS SQL Server FireStorm is a powerful development tool that dramatically reduces the amount of coding required for a typical business application by automatically... Andy Grove	08-24-2003 12:24 PM Andy Grove	0	78
Re: Please help as soon as possible "Elham GH" <ElhamGh_TechMail (AT) yahoo (DOT) com> wrote Have a look at the two error Simon Hayes	08-24-2003 09:26 AM Simon Hayes	1	52
Re: Help!!! How to clustering SQL Server 2000 without Shared Disk? "wailaw" <chun_wail (AT) hotmail (DOT) com> wrote (Removed irrelevant newsgroups from the reply) SQL Server clustering depends on the Windows... Simon Hayes	08-24-2003 09:23 AM Simon Hayes	0	50
Re: DTS, threadings "Ahmed B. Zayan" <ahmed.b.zayan (AT) boeing (DOT) com> wrote It's not really clear what you're trying to achieve - something like multiple... Simon Hayes	08-24-2003 09:13 AM Simon Hayes	0	50
Scheduling a job containing a DTS package on Sql server 2000 I've tried several different possibilities but don't have enough basic understanding of the ownerships and permissions that are involved so I'm... ano1optimist	08-24-2003 09:06 AM Simon Hayes	2	43
DTS Package Schedule Hallo I have a DTS Package which reads data from a Access Database and imports it to SQL Server. This package runs without error when it is executed... HP Fuchs	08-24-2003 09:05 AM Simon Hayes	1	52
Row cannot be located for updating Hi, I am getting "Row cannot be located for updating. Some values may have been changed" error when I try to update from visual basic with ado. This... A M	08-24-2003 05:19 AM Erland Sommarskog	1	67
Looking for db replication tool I'd like to use log shipping to provide warm backup to some production MSFT SQL 2000 servers. I know that I can write something to ship logs but I'm... BobF	08-24-2003 01:32 AM John Bell	2	60
Re: A Somewhat Creative Way to Kill a Server Bob (bob.ward (AT) enron (DOT) com) writes: As far as I know, spt_values has always been listed as type = 'U' in SQL Server. This is probably SQL... Erland Sommarskog	08-23-2003 11:03 PM Dan Guzman	4	73

Page 269 of 283

269

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