Rating Thread / Thread Starter	Last Post	Replies	Views
relation & query Hello, I'm relative new to sql and databases and the last few weeks I learned myself a lot. I'm trying to make a hotel reservation application. I... djhugovic	04-09-2005 10:20 PM --CELKO--	1	84
help on query I need advice on how to approach this. To simplify with a sample, below is a list of various calculations based from ITEMS table: ITEM_NO ... B	04-09-2005 10:15 PM --CELKO--	4	70
naming column names Hi, I am learning Ms Sql and I found that a lot of the tables I am finding ( in different tutorials ) are using special names for their column names... John.Arthur@gmail.com	04-09-2005 10:12 PM --CELKO--	4	83
How to copy tables from local machine to remote SQL server We currently have a PPTP connection set up for our developers to access our development SQL server through a VPN tunnel. When they need to copy... oceanhai	04-09-2005 09:28 PM julian_muir	4	72
System DSN / Registry I need to make a system dsn connection on 50 pc. It's a system dsn connection with sql users I have though about to make a registry key, but I... Carsten	04-09-2005 06:19 PM John Bell	2	74
User input in SQL2000 Hello. I'm using SQL query analyzer to run some queries against an SQL2000 DB. Unfortunately, my previous SQL experience is some Oralce SQL I took... rgonzale6@bellsouth.net	04-09-2005 05:02 PM rgonzale6@bellsouth.net	8	79
trying to avoid using cursors! i'm trying to write a batch that will perform a complex task using set-based selects instead of a row-based cursor. let me know if you can help me... iaesun@yahoo.com	04-09-2005 03:28 PM Hugo Kornelis	9	68
SQL SERVER DBA/ ATLANTA TOM GUGGER ERP SOLUTIONS INC 560 BRONX DRIVE TOLEDO, OH 43609 (419) 380-8853 tgugger (AT) buckeye-express (DOT) com Tom Gugger	04-09-2005 02:27 PM Tom Gugger	0	68
remote stored procedure on MSDE 1.. EXEC sp_addlinkedserver ServerName1, N'SQL Server' EXEC sp_addlinkedserver ServerName2 EXEC sp_configure 'remote access', 1 RECONFIGURE GO 2..... Kolar	04-09-2005 08:57 AM Kolar	0	73
MSDE installation fails due to detection of previous installation Please help, I am trying to install MSDE 2000 so that Backup exec will run on this server. I have gotten so far as to find an entry in my SQLSTP.TXT... jdisco@gmail.com	04-09-2005 04:23 AM John Bell	1	70
bcp is inserting blank space for empty string I'm doing a bcp out of a table to a file. Some of the fields in a record may have an empty string. When I bcp out to the file and examine it, the... epaetz	04-08-2005 04:32 PM epaetz	4	87
Table size and Computed Columns In SQL Sever, do the size of computed columns gets added to the total size of the tables? Does SQL server stores the actual values in computed... GJK	04-08-2005 03:38 PM Hugo Kornelis	1	66
cursor vs. select buddies, situation: a processing must take place on every row of a table, and output results to another table, that can't be done via an... vuht2000	04-08-2005 03:37 PM Hugo Kornelis	4	74
Query Optimization Hello all, Please bear with the long explanation of my scenario. As I'm relatively new to the query world, I like to write my queries using the... Umar Farooq	04-08-2005 02:09 PM Simon Hayes	6	90
How to Go From a Database to A Calendar Format? Hello My department has a SQL server database that is used to all facets of production within our department. This includes key production... clemke@email.toast.net	04-08-2005 01:46 PM David Portas	1	75
Help with 1205 Not raised Hi, I have an application that causes a dead lock at random. The issue I am having is, when the deadlock occurs, my applications is not recieving any... gigijk@gmail.com	04-08-2005 01:35 PM GJK	3	72
ASP + SQL loads really slow over intranet Hi guys, I've created a web application using ASP together with SQL Server as our db source, running through IIS 6 on a Winows Server 2003... Shawn H	04-08-2005 12:54 PM Simon Hayes	3	71
Can stored procs run after handle is closed? I have written a stored proceedure for MSSQL that needs to run for hours at a time. I need to execute it from C++ code. The current code... Joseph V	04-08-2005 09:36 AM Joseph V	2	75
HELP - SQL Server 2000 Install Files needed urgently Hi! I have a large project that is due to complete this week. In order to complete it I need SQL Server 2000 installed on a remote server. My disk... TheFoot	04-08-2005 04:31 AM David Portas	6	69
problem making Oracle linked server work ( 1 2 ) Hi all, I set up our Oracle Financials as a linked server to one of my SQL Server boxes. On running a test query, I got the following... Ellen K	04-08-2005 12:05 AM Ellen K	11	120
Insert produces error Hi, Using SQL Server 2000 with Windows 2000 Adv Server & Microsoft Access linked table (running stored procedure using ADO... Todd	04-07-2005 09:49 PM Todd	1	66
Error on link Servere HI, I am getting below error on link server. And the performance between link server is really pathatic. Executed as user: NT AUTHORITY\SYSTEM. OLE... smileydip	04-07-2005 05:45 PM Greg	1	78
Crear una BBDD desde VB.NET Hola a todos, tengo un formulario en el que solicito el nombre de una base de datos que luego quiero crear en SQL Server. Lo hago a traves del... Gema	04-07-2005 10:53 AM Simon Hayes	3	99
Restore Log Fails Msg:3433 Server: Msg 3443, Level 20, State 1, Line 1 Database 'GAII_Build' (database ID 8) was marked for standby or read-only use, but has been modified. The... WangKhar	04-07-2005 10:28 AM WangKhar	0	68
Dev. Team - Keeping Three Tiers in Sync This may not be a MSSQL-specific question, but I wanted to ask it here first, in case there's a MSSQL and/or SourceSafe solution that will help. Our... swoozie	04-07-2005 08:45 AM Mork69	2	69
can't do that request Hi, I'm going to explain as clearly as possible: I have two tables: Relationships(relation_id, table1, table2) Relationfields(relation_id, field1,... Sam	04-07-2005 03:53 AM Sam	7	69
SQL 6.5 migrating to SQL 2000 Hi, I've got a database that needs to migrate from SQL 6.5 to SQL 2000. I'm having problems with Datetime data types. In SQL 6.5 the Date is shown... red1028	04-07-2005 02:50 AM Simon Hayes	1	69
MS ACCESS - ON DELETE CASCADE Problem I cannot execute my sql to create a table with ON DELETE CASCADE option. Here is my sql: CREATE TABLE Employees (Name Text(10) not null, Age... P.B. via SQLMonster.com	04-07-2005 01:56 AM Pimonpun B via SQLMonster.com	2	63
SQL Query Help I need to pull a random set of records with a query. I have a table on the one side called CUSTOMER with a primary key of CustomerID. I have another... Frank Bishop	04-06-2005 11:22 PM Frank Bishop	5	71
Re: How to add 2 columns together Hi, Feedback below.. SELECT MAX(DATALENGTH(mymemo)) FROM mytable -- If the above is < 8000 UPDATE MYTABLE SET MYMEMO =... Greg	04-06-2005 11:17 PM Greg	0	72
NTEXT vs NVARCHAR for large number of columns About 50 (half) of them are nullable. I'm storing mostly various contact info as well as some business-related data that needs to be searchable.... Oleg Ogurok	04-06-2005 10:51 PM Louis Davidson	6	155
Memory Mgt in SQL SERVER I have a performance and memory management issues with SQL SERVER. I feel SQL server does not releases the unused memory back to the OS. I have been... smileydip	04-06-2005 08:51 PM Greg D. Moore \(Strider\)	3	74
C#, SQL-DMO, Add FileGroup Issue. ( 1 2 ) Greetings All, I was hoping that someone might be able to shed some light on this issue. I am trying to add a FileGroup/Datafile to an existing SQL... LineVoltageHalogen	04-06-2005 07:30 PM LineVoltageHalogen	14	113
sp_send_cdosysmail - Parameter Inside Body of Email I currently have a web form posting back to a SQL table using a Stored Procedure. Part of this SP is that it pulls data from another table and... eczino@gmail.com	04-06-2005 05:39 PM eczino@gmail.com	2	105
Error processing cube with disabled lowest level of shared dimension Hi, This is probably a classic scenario with a shared dimension that we need to use in different cubes, where all fact tables do not offer the same... SRL	04-06-2005 04:28 PM Simon Hayes	1	69
Import XMS into SQL Server 2000 Hello, I am trying to import a data from a DB called Reference Manager. It was sent as an XML file. How do I import it? I only have the client... Tmuld	04-06-2005 04:27 PM Simon Hayes	1	72
My db grew 8.2GB in two weeks BUT only 4MB of data added I have a db that grew 8.2GB in one week and don't understand why. There are three tables added to the db daily. I calculated the spaceused by each... war_wheelan@yahoo.com	04-06-2005 03:58 PM Simon Hayes	4	81
Enterprise Manager Date format has changed I am not sure how this even changed but... Until just recently when I went into any database and listed stored procedures I could list by the date... Sandy	04-06-2005 03:41 PM Simon Hayes	1	72
Problem with query and date ranges I'm trying to create a query that will tell me which requests took longer than 10 days to move one from particular state to another state. The query... Myron	04-06-2005 12:32 PM --CELKO--	3	72
Dynamic Build SQL in store procedure based on select I have a department table like this: DeptID Department ParentID, Lineage 1 HR NULL ( 2 Temp1 1 (1, 3 Temp2 ... HL5138@gmail.com	04-06-2005 12:18 PM --CELKO--	3	75
loop through a datagrid Hi, No I don't want to loop through my dataset ;) I want to loop through my datagrid to retrieve the values in each cells, but I don't know how to do... Sam	04-06-2005 11:00 AM Simon Hayes	1	81
Copy a database Hi, I need to copy a database for example I have ABC I want to create ABC_Test How to do that? regards, Blue Porcupine	04-06-2005 10:18 AM Umar Farooq	2	106
SQL Like. Hi, I want to search Strings Like this. Say Column containing ... "A B" "A B" "A B" "A B" "A B" How can I search "A B" with ignoring spaces.... Dishan Fernando	04-06-2005 08:47 AM Madhivanan	8	126
isql error message Hi, I have created a database as pubs.qa and wrote a command utility to query a table. isql -S server -E -d pubs.qa -i qry.sql -b -n contents of... anuu	04-05-2005 08:15 PM anuu	3	70
Accomodating 'Dummy' Data? Hello, I am working with a vb6 Windows application that runs on Tablet PC's. There are about five SQL Server 2000 databases that tie into... CSDunn	04-05-2005 05:14 PM David Portas	1	73
owner of a temp table is there a way to query the system table in SQL Server to determine the owner of a temp table? I doubt this is possible because it seems as though... dlukac@gmail.com	04-05-2005 05:03 PM Simon Hayes	1	69
Database backups growing exponentially Hi All. I'm currently maintaining 4 servers - 1 for public/customers and 3 for backups, development, etc... I regularly backup the entire SQL... greggarpin@hotmail.com	04-05-2005 04:12 PM Byrocat	2	58
3 quick queries I want help with a couple of SQL queries. I have two Tables Table A and Table B. Both tables have the same two fields Name and Hobbies. One Name can... chudson007@hotmail.com	04-05-2005 10:23 AM chudson007@hotmail.com	8	98
SQL Server DBA job offer in france Hello all, I'm searching for a SQL Server DBA for a 6 month job in france (Paris). If you are interested you can send me a resume to zap5 (AT)... gopy	04-05-2005 06:20 AM gopy	0	68
SQL 6.5 - to - SQL 2000 replication Here is what we are trying to solve: -We have a SQL 6.5 server (version 6.50.258) we will call SQL65-A, on an NT 4.0 machine (version 4.00.1381), on... DBA723	04-05-2005 02:32 AM Simon Hayes	1	56

Page 151 of 282

151

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