Rating Thread / Thread Starter	Last Post	Replies	Views
Service Pack 3 to Service Pack 4 Hello!!! I want to switch to SQL SERVER 2000, Service Pack 4 from Service Pack 3. So please advice, what all points need to consider. Also please... tilak.negi@mind-infotech.com	05-18-2005 06:36 AM Erland Sommarskog	1	53
Re: [Fwd: Reverse pattern matching] On Tue, 17 May 2005 17:26:44 -0700, Gary Greenberg wrote: Hi Gary, Try this one: SELECT B FROM YourTable WHERE 'XYZ' LIKE A Hugo Kornelis	05-18-2005 05:01 AM Hugo Kornelis	0	43
Service Pack 3 to Service Pack 4 Hello!!! I want to switch to SQL SERVER 2000, Service Pack 4 from Service Pack 3. So please advice, what all points need to consider. Also please... tilak.negi@mind-infotech.com	05-18-2005 04:17 AM tilak.negi@mind-infotech.com	0	54
Company-calendars Dear All, How to store a separated company-calendar for each client-company (about 500). Company-calendar: workingdays, non-workingdays, meetings,... Filips Benoit	05-18-2005 02:52 AM The Gekkster via SQLMonster.com	1	57
Delete recordsets with same Date and Line Hi All! I need help with a Statement! I am working with an Access2000 DB. I have the following Problem. ChNr Linie Datum Code 39 ... Julia Härtfelder via SQLMonster.com	05-18-2005 01:07 AM Julia Härtfelder via SQLMonster.com	3	55
Negative values for RowModCtr col in sysobjects tbl Could anyone, please, explain to me why I have negative values in RowModCtr column in sysobjects table? I have tested that after I update statistics... luke	05-17-2005 08:52 PM Simon Hayes	1	68
Re: Reverse pattern matching] "Gary Greenberg" wrote: I don't know how well it will perform, but you can just reverse the operands to the LIKE operator... create table #T ( A... Craig Kelly	05-17-2005 08:51 PM Craig Kelly	0	57
Changing collation when installing SQL2000 Hi, I'm installing SQL2000 on a new cluster server. I selected a 'custom installation' and was presented with a 'Collation settings' screen. I need... polinaskulski@aol.com	05-17-2005 06:44 PM Erland Sommarskog	1	52
Building / Modifying an SQL Database remotely Hi Folks, I should begin by saying I'm fairly new to SQL Server. I'm an application developer who has built front ends atop Server, but have never... RWC	05-17-2005 06:35 PM Erland Sommarskog	1	58
complexity of nested self left joins? Hi, I'm curious about the computational complexity of a query I have. The query contains multiple nested self left joins, starting with a... jbm05	05-17-2005 06:22 PM jbm05	4	60
Bad executed Plan and wrong Result by SQL I have one query that executes many times in a week. I created one Maintenances plan that Rebuild all index in my Database that has been executed at... Krisnamourt Correia via SQLMonster.com	05-17-2005 05:52 PM Erland Sommarskog	5	56
ODBC connection to SQL server failing Hi, I have an access 2003 database which connect to sql server via a DSN that goes through a VPN. The database works fine and everyone can coonect... Dan	05-17-2005 05:18 PM Erland Sommarskog	3	70
dynamic SQL variable with Output ?? I know this has been dealt with a lot, but I would still really appreciate help. Thanks. I am trying to transform this... Patrik	05-17-2005 03:55 PM Patrik	6	66
web hoster only allows 1 sql server database What can be done if the shared web hoster I am using allows only 1 sql server database and a second web application I would like to install... Steve Richter	05-17-2005 03:08 PM Morgan Kane	4	58
Need hardware suggestions for SQL 2000 server I am running McAfee ePO and SQL Server 2000 on a dual Xeon 900Mhz box currently. It is slow. I am going to be ordering 2 new servers, 1 for ePO and... czidak	05-17-2005 11:52 AM czidak	3	63
Serverwide Rollback Hi Having a little issue... is it possible to have multiple connections all get rolled back to the same point? I have a small database that seems... Wangkhar@yahoo.com	05-17-2005 06:48 AM Wangkhar@yahoo.com	6	68
Problem finding values with aggregate functions Hi all! In a statement I want to find the IDENTITY-column value for a row that has the smallest value. I have tried this, but for the result i... Jon	05-17-2005 06:43 AM Erland Sommarskog	2	55
Moving all DTS packages from server to server Hi, Is there any way of copying ALL DTS Packages from server to server apart from direct copy of sysdtspackages table and saving them one... polinaskulski@aol.com	05-17-2005 05:57 AM Simon Hayes	1	51
NOT FOR REPLICATION, Enterprise manager Hi. How can i set NOT FOR REPLICATION option to column in the enteprise manager. SQL Server 2000 -- Message posted via http://www.sqlmonster.com figo via SQLMonster.com	05-17-2005 05:35 AM figo via SQLMonster.com	3	64
hash table (#) order by problem with more records We have one single hash (#) table, in which we insert data processing priority wise (after calculating priority). for. e.g. Company Product ... tilak.negi@mind-infotech.com	05-17-2005 05:26 AM David Portas	5	58
Excessive stored procedure [COMPILE] lock Hello! I am trying to investigate strange problem with particular stored procedure. It runs OK for several days and suddenly we start getting and... imarchenko	05-17-2005 02:37 AM Razvan Socol	1	54
Date poition comparison of a datetime field I have a datetime variable coming from my ASP.NET application that has a time portion. I give my users the option to perform an equals, greater than,... colinhumber	05-16-2005 04:35 PM Hugo Kornelis	1	47
How to deploy a report in Reporting Services without using VS 2005? When I try to put a new report in existing folder there's no problem, but now i have fresh installed Reporting Services and no Visual Studio 2005.... Joško Šugar	05-16-2005 08:54 AM Joško Šugar	0	59
Compare two databases and update objects? Is there a way to compare two databases one being an old database and the second being a new database, I will update the old database's objects to... serge	05-16-2005 05:29 AM Malcolm	2	51
Avoid index scan with LIKE and a variable Hi, Here's my problem: I want to write a stored procedure that returns all records from a table that have a certain column starting with given text.... gregbacchus	05-16-2005 03:23 AM Erland Sommarskog	1	61
help with exists Hi, I need some help doing a simple query. Here is what I have SELECT Category_Id, Category_name FROM AG_Category WHERE ... dmalhotr2001@yahoo.com	05-16-2005 02:24 AM David Portas	1	74
insert current date/time Hi all, I have a question about inserting records into sql server. I am brand new to sql server, always using oracle previously. Before today, I... ryan.mclean@gmail.com	05-15-2005 06:02 PM ryan.mclean@gmail.com	5	63
Which is more efficient, join or straight select Which way of retrieving a record is more effecient?: Select tbl1.field1, tbl2.field1 from table1 tbl1 inner join table2 tbl2 on tbl1.id =... jw56578@gmail.com	05-15-2005 05:16 PM Hugo Kornelis	3	54
Will it auto convert datatype??? When i do this statement: insert into table (cost) values ('2') cost column is a bigint datatype. will it auto convert the string 2 into integer... chuayongquan@hotmail.com	05-15-2005 11:10 AM John Bell	1	55
db_owner to all tables is there a command that can change a login role to db_owner in all the tables, or do i have to use { USE table_name EXEC sp_adduser 'login name' EXEC... liorhal@gmail.com	05-15-2005 11:08 AM John Bell	1	76
importing from .txt orange May 14, 5:16 pm show options Newsgroups: comp.databases.ms-access From: "orange" <orange... (AT) mail (DOT) ru> - Find messages by this... orangeKDS@mail.ru	05-15-2005 07:43 AM John Bell	1	88
SQL query - highest rated or least voted items Hello everyone, I'm trying to solve this problem but can't seem to figure out how to start. I would like to create a rating system where people can... andreas.muller@gmail.com	05-14-2005 07:56 PM andreas.muller@gmail.com	5	49
Memory leak in SQL Server ( 1 2 ) I have a stand alone Java application that uses MS SQL Server 2000 and Microsoft JDBC ODBC drivers to access it. Before I run the application, I open... Bardolator	05-14-2005 05:59 PM Erland Sommarskog	12	99
A query runs fast in Query analuser but slow in APplication I am able to run a query which runs FAst in QA but slow in the application.It takes about 16 m in QA but 1000 ms on the Application.What I wanted to... AG	05-14-2005 05:15 PM Erland Sommarskog	2	90
How to send data from a remote Client to my FTP site Every night i want to send the new records that are created from my remote client to my FTP site, using a application which sets up an internet... AG	05-14-2005 03:03 PM Simon Hayes	1	51
How to send data from a remote Client to my FTP site Every night i want to send the new records that are created from my remote client to my FTP site, using a application which sets up an internet... AG	05-14-2005 02:30 PM AG	0	51
How to send data from a remote Client to my FTP site Every night i want to send the new records that are created from my remote client to my FTP site, using a application which sets up an internet... AG	05-14-2005 02:30 PM AG	0	51
Storing pdfs in an image field I am using an image datatype to store multiple filetypes includeing plain text data. it works except for pdf Data. When I retrieve the the... Arlyn	05-14-2005 10:54 AM John Bell	3	61
How to Copy and Rename a Database: same server How does one make a copy of a database (with the data) on the same server. Would like to do this to use the copy in a test environment. I looked at... JJ_377@hotmail.com	05-14-2005 09:08 AM JJ_377@hotmail.com	2	55
Script for comma seperated values To get rid of redundant data in a table, my cleint will be providing something like this: IDtokeep Ids to delete 34 24,35,49 12 ... muzamil@hotmail.com	05-14-2005 04:34 AM Erland Sommarskog	3	52
Output Select results to a text file. I have a dynamic database that will be periodically queried to select the data from a blob field. This blob data field is text of a variable length.... raglin	05-14-2005 03:17 AM John Bell	1	51
Could not find the index entry for RID... Greetings. Today I was testing the sql backup/restore functions on our primary server. I was able to backup my database without any problems but... Richard Bailey	05-14-2005 03:10 AM John Bell	1	290
ntext and update/insert triggers SQL Server 2000 : I have a series of tables which all have the same structure. When any of these tables are modified I need to syncrhonise all of... Derek Erb	05-13-2005 07:17 PM Hugo Kornelis	1	54
Insert Trigger to Update table Hi, Does anyone know of a simple way to do this? I want to create an insert trigger for a table and if the record already exists based on some... takilroy@yahoo.com	05-13-2005 07:06 PM Hugo Kornelis	3	63
Split a field Whats the best way to do the following? Field1 in Table1 contains numbers and characters seperated by # Examples: aaa#01, kjhkjhjh#21 and... chudson007@hotmail.com	05-13-2005 07:00 PM Hugo Kornelis	3	94
FK on a column to a table where the column is not the PK but a Unique Index Hello everyone, I am new to ERWIN and I need helps from the experts out there. We are using ERWin 4.1.2771 and have reversed engineered some MS... gradeaaguy@aol.com	05-13-2005 06:34 PM David Portas	2	57
Global temp table permissions I have a pivot table implementation, part of which is posted below. It returns no errors in query analyzer, but when profiler is run, it shows that... pb648174	05-13-2005 06:11 PM pb648174	6	56
compare data I've created two tables. One table (Classes) stores data about classes that we offer. The Classes table stores the class id (classid) and the max... Robert	05-13-2005 05:37 PM --CELKO--	2	78
removing data I have a table that I need to delete some data from and put the deleted data into a different table. How do I script the following. If Field1 in... chudson007@hotmail.com	05-13-2005 12:42 PM andy.morin@gmail.com	5	111
Basic Syntax explanation In T sql for sql server, what is the technical difference between the comparisons "is" and "=" for example: set @test = null print @test is null ->... jw56578@gmail.com	05-13-2005 10:33 AM --CELKO--	3	51

Page 143 of 282

143

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