Rating Thread / Thread Starter	Last Post	Replies	Views
TimeOut with ms sql 2000 Hello, I have a program called Gestimum which question a MS SQL 2000 DataBase. I have 6 clients who connect to the database througth Gestimum. It... arnaud_brunet@hotmail.com	06-07-2005 05:29 PM Erland Sommarskog	3	70
Issue with msxisapi.dll Hi, I still have this issue...please help me... ELEMA.LO@terra.es	06-07-2005 05:25 PM ELEMA.LO@terra.es	0	80
SQL view / joins query Hi, I have a view(A) and I am trying to do a join on another table (B) to include only rows where date values in view A is greater than in table B.... brendan_gallagher_2001@yahoo.co.uk	06-07-2005 05:02 PM Erland Sommarskog	3	74
Need help with query I have two tables (classes and students). Right now, I'm generating a report in asp that shows a list of classes, the enrollment for each class, and... Robert	06-07-2005 10:27 AM Stu	1	59
INSERT failed because of incorrect SET options I am trying to insert a row into a table using a stored procedure and I get the following error if I try this from QA: INSERT failed because the... teddysnips@hotmail.com	06-07-2005 10:15 AM Simon Hayes	4	73
authentication issues, security groups Hi, Apologies for not knowing much around this subject, we currently run sql server 2000 for a database and have each user marked up on the... Not Me	06-07-2005 09:31 AM Simon Hayes	1	62
Scheduled jobs Hello people. I have an SQL 2000 Server which was handle to me today out of the blue and i was told that it has the following problem: The SQL... DMina@laiki.com	06-07-2005 03:01 AM DMina@laiki.com	4	88
How to repair sql table - Error in DTS I have schedule DTS to import every day few tables. It had been working great and had no problem. All of a sudden I started getting this... Mac	06-07-2005 03:00 AM Simon Hayes	2	67
Re: SSL Security Error I have no idea - you might get a better response in an ODBC or MDAC group. However, if you've already enabled SSL for all connections, I'm not sure... Simon Hayes	06-07-2005 01:41 AM Simon Hayes	0	72
RS - Multiple Development Environments on one machine We have multiple development environments on one machine for our Visual Studio .net projects. These are web applications so we have organized them by... BillKi	06-07-2005 01:26 AM Simon Hayes	1	59
general question of before image vs checkpoint I read recently that: "if a before-image was made before an interruption in database processing, you use the before-image dump & simply begin... jasonshohet@gmail.com	06-07-2005 01:25 AM Simon Hayes	1	64
Export view result using transferdatabase I am trying to export the results of a view from an .adp to an .mdb using TransferDatabase. The code I am using is DoCmd.TransferDatabase acExport,... Jer	06-06-2005 07:59 PM serge	2	64
top n percentage Hello! I have a need to create a function that will return a sublist of elements from a table based on an associated column value and its ranking... andrew	06-06-2005 06:17 PM Erland Sommarskog	3	70
Re: best backup software for MS SQL? "pigeon" <UseLinkToEmail (AT) dbForumz (DOT) com> wrote You could make say a weekly based full backup and then nightly transaction log... Greg D. Moore \(Strider\)	06-06-2005 06:13 PM Erland Sommarskog	2	60
Rows to Column Names I am struggling on this issue and was hoping if anyone out there can help me. Here is the setup: I have a table with the following data: TableName:... SQLJunkie	06-06-2005 06:09 PM Erland Sommarskog	7	72
Strange Backup Problem! Hello Faculties, Currently i'm working on a local machine that houses SQL Server databases. All the development work is done on this local machine.... debian mojo	06-06-2005 06:01 PM Erland Sommarskog	1	66
Licence Question Server setup: Server with 4 CPU's and 4G of Ram The server is used as a distributor between a separate publisher and a separate subscriber... aprinsloo@sagetelecom.net	06-06-2005 06:00 PM Erland Sommarskog	1	77
SQL UPDATE Database from Excel Table ( 1 2 ) I had previously posted this in an Access forum with negative results so will try here. Although this question specifies an Access database, I also... jimserac@yahoo.com	06-06-2005 04:45 PM jimserac@yahoo.com	12	122
Which has the best performance? This: SELECT MAX(TheDate) FROM MyTable or this: SELECT TOP 1 TheDate FROM MyTable ORDER BY TheDate DESC As a follow up question to save me... Robin Tucker	06-06-2005 11:04 AM Greg D. Moore \(Strider\)	2	59
Can someone tell me what's wrong with this code? Hi All I keep getting back VINET and not Lilas...can someone point me in the right direction? Thanks a lot DECLARE @idoc int DECLARE @doc... reezaali@gmail.com	06-06-2005 10:25 AM Erland Sommarskog	4	60
Network performance for simple select statement I've just inherited a system and have some concerns about the speed of connections to a remote server (SQL2000). If I do a simple select statement on... Ryan	06-06-2005 10:19 AM Erland Sommarskog	1	52
How to convert datetime to DATE '1936-04-13 07:00:00.000' Does anybody can help me to convert datetime value let's '1936-04-13 07:00:00.000' to DATE as '04/13/1936'. I need this value in the Excell as a... Jelena via SQLMonster.com	06-06-2005 09:00 AM SQLJunkie	2	89
SQL Server Performance and permissions Hello, I am running SQL Server 2000 standard in mixed mode security and have two problems. 1.) I created a database as sa and assigned a login as... ralphm1@mail.horacemann.com	06-06-2005 08:42 AM ralphm1@mail.horacemann.com	4	56
Help with a simple query please I have Two Tables, TableA and TableB, both containing a common field, Feild1. How do I find all records in TableA, where Field1 is not in... chudson007@hotmail.com	06-06-2005 05:51 AM Ryan	3	62
Problem faced in Join(T-SQL) Table1: RouteID RDate Direction RTime Employee_ID ArrTime R1 6/15/2005 Pick 6/15/2005 9:30:00 AM 1430 6/15/2005 8:12:00... mahesh j k	06-06-2005 03:43 AM Erland Sommarskog	1	53
Another Newbie Question (about queries) I'm moving things from Access to SQL Server. What do I do with queries? I'm using Access 2000 to access Sql Server, and there doesn't seem to... JA	06-05-2005 06:28 PM serge	1	54
Newbie Questions Hi, I'm pretty good with Access, but I know nothing about SQL Server. My front end is Access 2000. I need to move the database tables from several... JA	06-05-2005 06:05 PM JA	4	111
log shipping - synch I have to schedule the automatic restore the standby database for testing backups . The database was already in log shipping mode. Up to what point... tram	06-05-2005 02:27 PM John Bell	1	79
table/index and page mapping I've just found a blocking lock occuring in a SQL Server. wait_info: PAGEIOLATCH_EX wait_resource: 14:1:564312 And the blockee has the following... New MSSQL DBA	06-05-2005 05:06 AM John Bell	4	81
What is purpose of semi colon after procedure name I've seen some system sp's that have a semi colon and number after the the name such as create procedure sp_procedure_params_rowset;2 what does this... jw56578@gmail.com	06-05-2005 03:30 AM Gert E.R. Drapers	1	85
Cannot use TEXTIMAGE_ON when a table... I am wondering if someone can help solve this question I have a table in sql server 2000, I setup it using Enterprise manager. When I generate an... MrDom	06-04-2005 05:07 PM Erland Sommarskog	6	106
passing parameter I have a stored procedure named "processInventory" like the following. Depending on the passed in parameters, I would like to add a WHERE clause for... js	06-04-2005 05:00 PM Erland Sommarskog	4	94
Script for adding fields to table How can I create a script that updates a table with new fields without losing the data in the table (i.e., without dropping and recreating... Neil	06-04-2005 04:44 PM Erland Sommarskog	5	63
query in dataview.rowfilter In the dataview rowfilter property, how can I say that I just want Titles that start with 'A' to 'J' ?? ex: dv.rowfilter = " Country = ' France '... vbnetrookie	06-04-2005 04:01 PM Erland Sommarskog	2	77
Getting Data from a storeed procedure in a stored procedure What I am looking to do is use a complicated stored procedure to get data for me while in another stored procedure. Its like a view, but a view you... Chris Auer	06-04-2005 03:51 PM Erland Sommarskog	4	63
binary_checksum and validated software environments Hi, It appears that binary_checksum can give the same checksum for different strings, which is a bit worrying. (I guess the algorithm is the problem... Liam Caffrey	06-04-2005 03:41 PM Erland Sommarskog	5	68
Upgrade Wizard Hello All I have SQL Server versions 6.5 and 2000 installed on a Windows 2000 server. I installed 6.5 first, coppied a backup of a database to the... Matt	06-04-2005 03:17 PM Erland Sommarskog	2	91
problem returning rows from SPROC Heres my problem, the first part selects a row from the database, if there is no row with the criteria it inserts a row and then returns it, the... dkode8@gmail.com	06-04-2005 02:56 PM Erland Sommarskog	1	72
creating data for a histogram. ( 1 2 ) I have a table, TableA with amongst other fields, a field for Qty. Qty can range from 0 to 100. How do I count the number of rows with a qty between... chudson007@hotmail.com	06-04-2005 02:30 PM Erland Sommarskog	16	104
log shipping - synch I have to schedule the automatic restore the standby database for testing backups . The database was already in log shipping mode. Up to what point... tram	06-04-2005 05:08 AM tram	0	63
Missing Program group Guys and Girls I have a server that was running SQL Server 2000 (on Windows 2000 server). In preperation for an upgrade from an old SQL Server 6.5... john.bandettini@rbs.co.uk	06-04-2005 05:05 AM Simon Hayes	1	76
Restore latest backup and logs I am setting up a job to automatically restore the standby database. This is to test our tape backups. I need to passon the latest full backup and... tram	06-04-2005 04:40 AM tram	0	62
checksum_agg and row size error. Require explanation. Hi, I can see that by using the object ID rather that the object name, the following SQL query works. Has anybody got any idea what is causing... Liam Caffrey	06-04-2005 02:15 AM Razvan Socol	1	96
SQL Server only use one cpu We have an SQL server 2000 server with four Intel Xexon cpu's. The version of SQL Server is: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec... Rene	06-03-2005 08:38 PM Stu	1	70
Case Insensitivity I have a SQL 2000 database. I have a ASP.NET web app that I use to search this database. I need to make my data case insensitive, espcially my last... bjorgenson@charter.net	06-03-2005 08:33 PM Stu	5	76
Stored Procedure vs SQL huge difference in execution time I have a Stored Procedure (SP) that creates the data required for a report that I show on a web page. The SP does all the work and just returns back... mas	06-03-2005 05:48 PM Erland Sommarskog	5	64
Loading Flat File using DTS I want to use DTS to load from a flat file. But I can't be sure when the flat file will arrive. I would like the job to check every 10 minutes or... amorphous999	06-03-2005 05:23 PM amorphous999	3	74
How do your keep text formatting when you insert it into database Hi All, This may seem like a stupid question but is there a way to keep text formatting when you add it to a database? Such as Paragraphs and... Blaine76	06-03-2005 04:32 PM David Portas	2	87
SQL Connections with VB.NET ( 1 2 ) As most of you are aware, when you close a VB.NET connectrion to a SQL server, the connection doesn't actually drop right then and there. From my... Joe Cool	06-03-2005 01:11 PM Joe Cool	12	111
Printing query results from sp Is there any way to send the results of a query executed within a stored procedure to the default windows printer, or even to a text file? ... Par-breaker	06-03-2005 10:27 AM TLetsek	3	78

Page 139 of 283

139

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