| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Nope
"Mystery Man" <PromisedOyster (AT) hotmail (DOT) com> wrote
a.tavares
|
06-28-2003 04:18 AM
Simon Hayes  | 1 | 79 |
| | | I have MSDE installed on my sistem, and I need to add a new user.
How do I go about doing this?
Kyle
|
06-28-2003 03:12 AM
AMIT | 1 | 136 |
| | | Hi there,
Could somebody post some simple example how one can refer to
a column in the 'deleted' temporary table within a trigger definition...
Eddy Fontaine
|
06-27-2003 05:53 PM
Erland Sommarskog | 2 | 127 |
| | | When i choose Windows Authentication during intstalling SQL
Server2000,i can't register my Server in MMC with SA login anymore!
I miss SA login?
if...
Elham GH
|
06-27-2003 05:48 PM
Erland Sommarskog | 2 | 140 |
| | | Float is an approximation, it is not an exact data type. This means that
the order in which the SUM is performed can affect the outcome. Since
you...
Gert-Jan Strik
|
06-27-2003 05:30 PM
Stefan Gustafsson | 2 | 149 |
| | | Thanks Anith, but that's what I orignally had. Unfortunately, it will
only match from maintable to errortable when there is a match, which
omits...
Paulie
|
06-27-2003 04:53 PM
DIEGO BUENDIA | 1 | 110 |
| | | "Jesse O" <dontspamme (AT) hotmail (DOT) com> wrote
UPDATE T
SET hour = DATEADD(HOUR, -1, hour)
Regards,
jag
John Gilson
|
06-27-2003 04:49 PM
John Gilson | 0 | 125 |
| | | how can i merge MS Sql Server 2000 esktop engine deployment with my
application setup program.
Karen Yerissian
|
06-27-2003 02:44 PM
Karen Yerissian | 0 | 132 |
| | | Let's shoot with a canon at a fly...
ORDER BY CAST('0'
+CASE WHEN SUBSTRING(Col,1,1) BETWEEN '0' AND '9' THEN
SUBSTRING(Col,1,1) ELSE '' END
+CASE...
Gert-Jan Strik
|
06-27-2003 09:54 AM
Mystery Man | 3 | 141 |
| | | Hi All
I need to aggregate a query to produce the following:
Workplace Avg
M100 4.7
M120 3.45
Which would be a normal...
Bevan Ward
|
06-27-2003 09:44 AM
John Gilson | 2 | 145 |
| | | Hello,
I just installed MS SQL 2000 Enterprise on a Windows 2000 Server machine
with 2 CPU's. After starting the MS SQL takes 2 x 100% of all CPU...
P Verbakel
|
06-27-2003 09:34 AM
Mystery Man | 3 | 142 |
| | | I am creating a document management systems using asp. I have been
researching the different ways of handling the documents such as using the
file...
switter
|
06-27-2003 09:28 AM
Mystery Man | 1 | 135 |
 | | Hi,
We have setup a publisher and a distributor in SQL 2000 running SP3.
Alongwith this we have setup a merge replication agent and its...
Karthik
|
06-27-2003 03:52 AM
Karthik | 0 | 155 |
| | | I have two date fields, start_date and end_date.
I'd like to subtract the two dates, and come up with a number (the
number of difference between the...
Jesse O
|
06-26-2003 05:32 PM
Steve Kass | 1 | 160 |
| | | "Ted Greek" <tgreek (AT) msn (DOT) com> wrote
INSERT INTO T (id, field1, fname, lname)
SELECT @id, 'fffff', fname, lname
FROM Names
WHERE id =...
John Gilson
|
06-26-2003 05:32 PM
Erland Sommarskog | 2 | 148 |
| | | I have a table in mssql7 that has 7000000 record and I want to take
100000 records out of it and place them into the new machine with
mssql2000. The...
royal344
|
06-26-2003 05:22 PM
Erland Sommarskog | 1 | 158 |
| | | My computer (connected to a domain) is having trouble connecting to the
local MSDE when using 'local' or '(local)' as server name. The only way I
can...
karim
|
06-26-2003 12:30 PM
karim | 0 | 145 |
| | | I have a column named "LIST" in a table with strings like the...
Sugapablo
|
06-26-2003 09:47 AM
Anith Sen | 1 | 156 |
| | | Someone has scheduled the backups - MSSQL does not make automatic backups
itself. You can look in some or all of the following places for...
Simon Hayes
|
06-26-2003 02:36 AM
Simon Hayes | 4 | 381 |
| | | I can't figue out whats wrong. I am a newbie to sql, however i'm totally
lost. i get this error.
"Microsoft OLE DB Provider for ODBC Drivers error...
ron@k-me.com
|
06-25-2003 08:44 PM
Dan Guzman | 3 | 143 |
| | | How do I get two values for two different fields in an insert statement
values clause using one select?
For instance:
declare @test int
@test gets...
Ted Greek
|
06-25-2003 08:20 PM
Ted Greek | 0 | 135 |
| | | Does anyone know the maximum number of CPU's that any version of SQL 7
(i.e. Std or Enterprise) can use on any version of Win 2K (i.e.
Server, Adv...
Jeff Roughgarden
|
06-25-2003 06:07 PM
Jeff Roughgarden | 2 | 118 |
| | | Hi,
The company I work for often develops databases for clients. Those
databases always need to do similar tasks. One company might need a
database...
Maellic
|
06-25-2003 05:35 PM
Erland Sommarskog | 2 | 167 |
| | | Hi All,
While in the process of building my table (40 or so Insert statments)
can I then query ("select * from @Table_variable") and use the...
Stephen Patten
|
06-25-2003 05:02 PM
Erland Sommarskog | 1 | 130 |
| | | I have a stored procedure that takes 18 hours to complete. Sometimes
I get the below error message when I run the stored procedure.
'Server : Msg...
Anjula
|
06-25-2003 04:49 PM
Erland Sommarskog | 2 | 205 |
| | | I have access to a Microsoft SQL server, but can only access it from the
same local webserver. I need ideally to be able to access it, for...
David Walker
|
06-25-2003 04:11 PM
David Walker | 0 | 158 |
| | | I have a client that requires me to back up his sql7 db to my server
and restore it in sql200, then restore it so they can run from my
server if...
Dave
|
06-25-2003 03:08 PM
Dave | 0 | 154 |
| | | More of an FYI in case anyone has run into this problem...
We were running into the infamous "timeout on buffer latch type 3" error and
was caused...
Doug
|
06-25-2003 01:10 PM
Doug | 0 | 197 |
| | | Hello All:
Have a problem that I have never seen before and have not found anything
on
technet on how to resolve it. I have a SQL Server 2000 server...
Katuil Katuil
|
06-25-2003 12:27 PM
Katuil Katuil | 0 | 170 |
| | | I know how to detect errors if a stored procedure
is used, by adding a ReturnValue parameter to the command object
and then in the stored procedure...
Larry
|
06-25-2003 12:27 PM
Larry | 0 | 153 |
| | | You can get a similar list using the query below. Note that the row
count is only an estimate and may not accurately reflect the actual
number of...
Dan Guzman
|
06-25-2003 10:44 AM
Anith Sen | 1 | 162 |
| | | Hi!
My first server is linked to an application (inserts, updates and
delete). My second server is a read-only server that will be used...
David
|
06-25-2003 10:43 AM
David | 0 | 165 |
| | | 1) Can one find the location of the 'Transaction Log' at: <Hard
Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf?
2) Is it safe to...
TZoner
|
06-25-2003 09:34 AM
John Bell | 9 | 188 |
| | | Hi,
Can you suggest a way to query an OLAP database maintained in Microsoft
Analysis Services using a Java servlet? I particularly want to fire...
Manthan Kamat
|
06-25-2003 08:06 AM
Manthan Kamat | 0 | 170 |
| | | We had a similar situation recently. I couldn't find any explanation for it
so I failed the SQL Server over to our passive node (we have...
Jason Sauer
|
06-25-2003 07:26 AM
Jackie Brophy | 1 | 168 |
| | | In the first case you only request companyname and orderid - the
optimal way to retreive this information is to use the indexes on
CompanyName and...
Stefan Gustafsson
|
06-25-2003 06:54 AM
Stefan Gustafsson | 0 | 167 |
| | | Erland Sommarskog <sommar (AT) algonet (DOT) se> wrote
Hi Erland,
I am not sure that I can do this in DTS. I know how to create parallel
tasks but...
Edward Nicholas
|
06-25-2003 05:21 AM
Erland Sommarskog | 1 | 150 |
| | | thank you for your reply
"Simon Hayes" <sql (AT) hayes (DOT) ch> wrote
TZoner
|
06-25-2003 03:17 AM
John Bandettini | 3 | 199 |
| | | Hi to all,
i've a "problem" with log shipping in sql server 2000 sp3.
My log shipping works fine, but the task does not update
log_shipping_primaries...
^CrAsH^
|
06-25-2003 01:54 AM
^CrAsH^ | 0 | 178 |
| | | Hi,
On SQLServer 2000, I have a table with a following structure:
MYTABLE
col1 char,
col2 date,
col3 number
My Objective:
Ricky Cruz
|
06-25-2003 12:29 AM
AMIT | 1 | 161 |
| | | What I am trying to do is get all of the records in a table that are out of
sequence so I know which account numbers I can reuse. I have a range
of...
Jason
|
06-24-2003 07:51 PM
John Gilson | 1 | 155 |
| | | When importing data into MS SQL Server 2000 from a MyODBC (v3.51) data
source using Data Transformation Services, special characters like öäüéàè
are...
Matthias HALDIMANN
|
06-24-2003 05:31 PM
Erland Sommarskog | 1 | 202 |
| | | Hi All
can some one please tell me the transact sql code that can list all tables
in a db.
thanks
Todd
Todd
|
06-24-2003 05:28 PM
Anith Sen | 1 | 202 |
| | | Simon & Erland, Thanks.
Yes, there is a practical implementation. Imagine a database which services
multiple customers. Many of those tables carry...
Scott
|
06-24-2003 04:27 PM
Erland Sommarskog | 1 | 227 |
| | | CrystalQuery (CrystalQuery (AT) hotmail (DOT) com) writes:
DMO is Data Management Objects, a suite of OLE components that is
used by Enterprise...
Erland Sommarskog
|
06-24-2003 04:18 PM
Erland Sommarskog | 2 | 229 |
| | | We are quickly moving from a small comapny to enterprise.
As it happens we want to watch SQL server (our bread and butter is data)...
Deep Structure Mosey
|
06-24-2003 03:55 PM
Simon Hayes | 1 | 243 |
| | | Hi,
Could anyone tell me the backup strategy for a 1000GB database?
Thank you!
Peter Wang
*** Sent via Developersdex http://www.developersdex.com...
peter wang
|
06-24-2003 03:47 PM
Simon Hayes | 1 | 205 |
| | | We're using SQL2000 on Windows 2000 Server, but this is a problem
we've had on one particular database since SQL7 on NT4.
The database in question...
LizP
|
06-24-2003 03:22 PM
Simon Hayes | 1 | 305 |
| | | This may be a simple question to answer, but I don't have a clue since I'm
not a dba.
I am using sql server 2000, while a client of ours is using...
Maze
|
06-24-2003 02:22 PM
Maze | 2 | 295 |
| | | Something like this?
select * from leads where leadDateTime < dateadd(dd, -1, getdate())
Simon
"Cindi" <cindiv30 (AT) hotmail (DOT) com> wrote
Simon Hayes
|
06-24-2003 02:17 PM
Cindi Vinette | 1 | 316 |
