dbTalk Databases Forums  

Sponsored Links


comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss in the comp.databases.ms-sqlserver forum.



Post New Thread
Threads in Forum : comp.databases.ms-sqlserver Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
2 32
Hi, How we can detect deadlock from a database. Rahul
Rahul
06-06-2007 05:56 AM
Robert Klemme Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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-- Go to last post
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-- Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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-- Go to last post
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. Go to last post
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 Go to last post
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. Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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-- Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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-- Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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@ Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
3 31
Monte Tiernan wrote:
Ed Murphy
05-24-2007 11:06 AM
Ed Murphy Go to last post
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 Go to last post
1 135
Post New Thread

Display Options
Showing threads 2201 to 2250 of 13715
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.