| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hey Guys - I was just wondering - if you have started to use Linux
Servers along with SQL Server- and if so, which Distribution of Linux
and for what...
mark_smith
|
06-07-2007 01:40 AM
mark_smith  | 0 | 29 |
| | | Hi!
I already sent this to the ACCESS newsgroup. But since I do not know really
which side is really causing the problem, I have decided to send...
Ben
|
06-06-2007 04:27 PM
Erland Sommarskog | 8 | 33 |
| | | I saw the strangest thing when I imported some data into a column
today. One column contained musical notes instead of data. Has anyone
ever seen...
Danny
|
06-06-2007 03:15 PM
Danny | 2 | 33 |
| | | Hi
I would like to know if it's possible to make a basic SQL cluster with
windows 2003 server and SQL 2000 standard edtition. It has to be a
basic...
Nacho
|
06-06-2007 11:48 AM
Nacho | 2 | 37 |
| | | Hi.
I've read up on this, and have something that works, but I was wondering if
there is anything I'm overlooking with this.
Situation is:
I have...
Jeff Kish
|
06-06-2007 09:20 AM
Jeff Kish | 2 | 32 |
| | | Hi,
How we can detect deadlock from a database.
Rahul
Rahul
|
06-06-2007 05:56 AM
Robert Klemme | 1 | 39 |
| | | Im having an issue with DTS and I dont know if anyone else has
experienced this...In my transformation I have a sql statement that
executes against...
Jimbo
|
06-05-2007 04:38 PM
Jimbo | 3 | 32 |
| | | I'm trying to use ADO to restore a SQL 7 database using a backup file. The
database already exists on the target computer, and is named the same as...
Neil
|
06-05-2007 03:42 PM
Erland Sommarskog | 5 | 34 |
| | | I'm Importing data (Flat File) to a table using the DTS Import/Export
Wizard on regular basis
The Wizard does not let me save the fixed width data...
nofear
|
06-05-2007 01:32 PM
nofear | 0 | 29 |
| | | I have table with following structure:
Cust Amount Type
1 150.00 1
1 100.00 ...
Mirnes
|
06-05-2007 01:00 PM
--CELKO-- | 4 | 37 |
| | | Hi.
Like the title says - how do i do this?
I was given the following example:
INSERT INTO TABLE2 SELECT * FROM TABLE1 WHERE COL1 = 'A'
The above...
pbd22
|
06-05-2007 12:57 PM
--CELKO-- | 10 | 61 |
| | | I setup a maintenance plan. Every time I go to change/add databases
to a trans-backup sub-plan, it doesn't show any as selected.
Is there a fix for...
G-Diddy
|
06-05-2007 10:01 AM
G-Diddy | 0 | 37 |
| | | Hi All,
I have to update a column in Table A based on 3 other columns in Table A
itself. I have an excel matrix like so
Column2-Value1 ...
Ben
|
06-04-2007 07:33 PM
Ben | 2 | 28 |
| | | I am running into an issue when adding data from multiple columns into
one alias:
P.ADDR1 + ' - ' + P.CITY + ',' + ' ' + P.STATE AS LOCATION
If one...
Techhead
|
06-04-2007 04:36 PM
Erland Sommarskog | 4 | 34 |
| | | I have the follwoing stored procedure:
ALTER procedure .(
@ExecutionGUID int = null
) as
begin
set nocount on
declare @s varchar(500)
declare @i int
ansonee
|
06-04-2007 04:34 PM
Erland Sommarskog | 2 | 33 |
| | | Hi,
I want to have all-in-one trigger, defined like this:
CREATE TRIGGER MyInsertDeleteUpdateHandler
ON MyTable
FOR DELETE, INSERT,...
Hubert Trzewik
|
06-04-2007 04:15 PM
Erland Sommarskog | 5 | 133 |
 | | I have some code (C#) that runs an SQL update query that sets the
value of a column to what the user passes. So, this causes an error
when anything...
eggie5
|
06-04-2007 01:31 PM
eggie5 | 2 | 229 |
| | | I'm looking for evaluation criteria that will help in rationalizing
the total cost of ownnership of the following Database Infrastructure
Failover...
Umar Reyi
|
06-04-2007 12:31 PM
Umar Reyi | 0 | 29 |
| | | HCL hiring IT professionals -Chennai/Noida/Gurgaon/Bangalore
Helpdesk / Technical Helpdesk - Noida / Chennai
Application Packagers -...
dbaguru
|
06-03-2007 02:45 AM
dbaguru | 0 | 35 |
| | | Copies of my book "Analytics & OLAP in SQL" have pages 13-44 missing
and pages 61-92 printed twice. Please contact Morgan-Kaufmann or
your book...
--CELKO--
|
06-02-2007 09:45 PM
--CELKO-- | 2 | 36 |
| | | I'm a MS SQL newbie and am programming SQL using MS DS C++ 2003.
I'm writing sql code that will reside in a shared dll, used by many
processes and...
Bruce.
|
06-02-2007 11:38 AM
Bruce. | 4 | 34 |
| | | I have the following problem in a Win 2000 Server + SQL Server 2000
environment and I hope somewhat can help me to resolve it (after many
days of...
Tonio Tanzi
|
06-02-2007 10:09 AM
Tonio Tanzi | 4 | 43 |
| | | I'm a MS SQL newbie and am programming SQL using MS DS C++ 2003.
I'm writing sql code that will reside in a shared dll, used by many
processes and...
Bruce.
|
06-01-2007 05:28 PM
Bruce. | 0 | 28 |
| | | Hi guys,
in my db i have these three tables
1.Stores 2.Products 3.Parts
their structure is something like :
Stores ----> Products ----> Parts
Khafancoder
|
06-01-2007 04:58 PM
Khafancoder | 18 | 56 |
| | | Every time i try to back up a specific DB i get an error saying it can
not backup because the full text catalog is not permitted because it
is not...
Bryan
|
06-01-2007 04:04 PM
Erland Sommarskog | 1 | 39 |
| | | AltovaŽ is pleased to announce general availability of Release 3 of
its Version 2007 XML product line. Just a few of the many new
features...
announce@altova.com
|
06-01-2007 01:24 PM
announce@altova.com | 0 | 34 |
| | | Hi,
I don't know if I missed anything. I have 2 member tables and one
partition view in SQL 2000 defined as following
CREATE VIEW...
Sonny
|
06-01-2007 08:22 AM
Sonny | 8 | 32 |
| | | I like Chris' last idea:
COALESCE(Col1, 0) + COALESCE(Col2, 0) + COALESCE(Col3, 0) +
0*COALESCE(Col1, Col2, Col3)
This calculates the value in one...
info@vanoordt.nl
|
06-01-2007 06:52 AM
info@vanoordt.nl | 12 | 55 |
| | | Running into some odd behavior in SSIS with regards to logging.
If I turn on logging on an SSIS package, when the package executes it
will log all...
ansonee
|
05-31-2007 02:24 PM
ansonee | 0 | 39 |
| | | Hi,
I'd like advices about an idea I add to resolve a problem. thanks to
you in advance for yours answers.
I have a database with tables that I load...
Kurt
|
05-30-2007 04:57 PM
Erland Sommarskog | 3 | 43 |
| | | I'm just know basic SQL but not enough to write any complex queries.
The problem I'm facing right now keeps me thinking to use a Cursor but
I've seen...
kyle.fitzgerald@gmail.com
|
05-30-2007 12:26 PM
rshivaraman@gmail.com | 4 | 32 |
| | | Man do I struggle with Enterprise Manager as a graphical tool for
building views etc.
Its flaky and hangs frequenlty so i have to kill it with the...
grant@technologyworks.co.nz
|
05-30-2007 10:34 AM
Martijn Tonies | 2 | 36 |
| | | Hi Friends,
How can we insert records in sorted order
like consider a table
No Name Phone
1 test1 12345
1 test1 23455
2 test2 68638
Oonz
|
05-30-2007 08:33 AM
Jason Lepack | 9 | 129 |
| | | Greg R. Broderick (usenet200705 (AT) blackholio (DOT) dyndns.org) writes:
If the are in sequence, you could do:
convert(nvarchar,...
Erland Sommarskog
|
05-29-2007 04:23 PM
Erland Sommarskog | 1 | 27 |
| | | Hi,
I'm planning the structure of a SqlServer 2005 database for a new
application.
The requirement is that primary keys must be "natural"; i.e. in...
D.
|
05-29-2007 10:56 AM
--CELKO-- | 7 | 39 |
| | | Hi Friends,
How to transpose the columns into rows
i want to convert the table which looks like this
ID Name HomePhone WorkPhone Email
1 test1 ...
Oonz
|
05-29-2007 07:37 AM
Plamen Ratchev | 1 | 30 |
| | | SQL Monitor version 2.0 has just been released.
http://dbmonitor.tripod.com
SQL Monitor is an application that displays performance statistics...
DBMonitor
|
05-29-2007 05:39 AM
DBMonitor | 2 | 33 |
| | | Hi all,
I have recently changed IP addresses on my MS SQL cluster (the new IP
addresses belongs to a different network). Both physical node's...
aleu@vp.pl
|
05-29-2007 01:57 AM
John Bell | 5 | 34 |
| | | I am trying to write an application for a MSSQL database, using SQL Express,
and Visual Studio (Express edition)
I tried to connect to an existing...
Shane
|
05-28-2007 11:51 PM
Mandy | 3 | 43 |
| | | Hi All,
I wanted the expert opinion out there in the use of foreign keys as
primary keys in a table. I am not very good at explaining this
concept,...
KR
|
05-27-2007 08:17 AM
--CELKO-- | 4 | 34 |
| | | I have a strange problem that I think deals with security on SQL 2005.
I have a scheduled task that runs on a Windows 2000 machine. It calls
a vb...
Myster Edd
|
05-27-2007 03:56 AM
John Bell | 1 | 32 |
| | | I have a question about the "readCommitted" transaction isolation level.
I have a client that is updating a record on a table.
I suspend the...
D.
|
05-26-2007 05:29 AM
Robert Klemme | 3 | 30 |
| | | I have a directory of files that I would like to upload with some data
to a table so that I can store the files in the db. I'm not trying to
parse...
M@
|
05-25-2007 05:00 PM
Erland Sommarskog | 1 | 33 |
| | | I have about 14 tables that I am trying to tie together in a view to
see a user's status in our company.
Joe User:
Email - Active
ADP -...
M@
|
05-25-2007 10:48 AM
M@ | 2 | 49 |
| | | I'm trying to create a function that splits up a column by spaces, and
I thought creating a function that finds the spaces with CHARINDEX and
then...
jknaty
|
05-25-2007 08:42 AM
jknaty | 7 | 33 |
| | | Hi all!
We are a little group of databases developers, we use SQL Server and
we manage our source code with CVS.
Actually, with enterprise manager...
pipponec@libero.it
|
05-24-2007 04:54 PM
Erland Sommarskog | 1 | 28 |
| | | Welcome,
how can I alter following table in order to reduce neighbouring
duplicates (symbol, position, quantity, price).
Nr Symbol Position ...
mGracz
|
05-24-2007 04:50 PM
Erland Sommarskog | 2 | 42 |
| | | Hi all,
I've a query running under MS SQLServer2000 (Stored Procedures).
I'd like to send it's result via e-mail, formatting the output in txt...
Marco Garutti
|
05-24-2007 02:31 PM
Jennifer | 3 | 31 |
| | | Monte Tiernan wrote:
Ed Murphy
|
05-24-2007 11:06 AM
Ed Murphy | 0 | 32 |
| | | Hi all...
I've got a group of tables and I wanted to first see which tables
contained a fields containing the "Date/Time" data type. And I...
Mohd Al Junaibi
|
05-23-2007 05:10 PM
Erland Sommarskog | 1 | 135 |
