Sponsored Links

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

Page 52 of 282

Threads in Forum : comp.databases.ms-sqlserver

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Duplicate table On 11 juin, 18:54, "Chris.Cheney" <Chris.CheneyXXNOSPA... (AT) tesco (DOT) net> wrote: Hi Thx for your reply I'll try your code and submit the... Omar Abid	06-11-2007 04:09 PM Omar Abid	1	83
Can't Edit Maintenance Plan I have a clustered installation of SQL Server 2005 running on Windows 2003 with SSIS installed on the cluster. I'm running SQL Server Management... Neff	06-11-2007 10:59 AM Neff	0	65
Can't connect to SSIS I have a clustered installation of SQL Server 2005 with SSIS installed on the cluster. I'm running SQL Server Management Server on one of the... Neff	06-11-2007 10:42 AM Neff	0	46
parentheses in a check constraint Chris.Cheney wrote: So they are. The constraint is working as expected, it just doesn't look quite the way I'm used to reading it. Thanks. Helen Wheels	06-10-2007 02:11 PM Erland Sommarskog	2	41
Linux Servers(Usage) Hey Guys - I was just wondering - if at work you have started to use Linux Servers - and if so, which Distribution of Linux and for what purpose. ... mark_smith	06-09-2007 01:01 PM Jimbo	2	32
Turn off "Documentation Feedback" section of BO for printing? I wonder is there any way I can turn off the "Documentation Feedback" section of the Books Online at the bottom of the pages... I'm printing some... pedestrian via SQLMonster.com	06-08-2007 09:53 PM pedestrian via SQLMonster.com	2	38
[ANN] SQLeonardo.2007.05 :: java database frontend SQLeonardo a powerful and easy-to-use tool that lets you query databases. Download the latest release at http://sqleonardo.altervista.org nickyb	06-08-2007 05:29 PM nickyb	0	49
WHAT HAPPENED? Hi! Weird thing today! I opened Visual Studio 2005 and I can only see the master model msdb tempdb Piero 'Giops' Giorgi	06-08-2007 02:05 PM Piero 'Giops' Giorgi	2	46
SQLServer Table Partitioning ( 1 2 ) Hi! I have a question: I already have a DB that uses partitions to divide data in US Counties, partitioned by state. Can I use TWO levels of... Piero 'Giops' Giorgi	06-08-2007 12:31 PM Piero 'Giops' Giorgi	15	70
hierarchical selection within a select statment CREATE TABLE RS_A(ColA char(1), ColB varchar(10)) INSERT INTO RS_A VALUES ('S', 'shakespeare') INSERT INTO RS_A VALUES ('B', 'shakespeare') INSERT... rshivaraman@gmail.com	06-08-2007 06:54 AM rshivaraman@gmail.com	2	38
SQL Server and Net Apps I have SQL Server 2000 with databases on the NetApps filer CIFS share. For example, the datafiles are located at \\network... Raziq Shekha	06-07-2007 05:43 PM Erland Sommarskog	1	42
SQL 2005 : AFTER INSERT - Trigger Is it possible to create a trigger in one database, that after an insert, will update a database on a different server? If so, how would I do... Stout	06-07-2007 05:25 PM Erland Sommarskog	1	271
How To Script I need to update a value in IMA_GLInvAcctNbr from 11283 to 11500. the table name is dbo.item. What would my script look like to do this in SQL... Brian	06-07-2007 11:03 AM Jason Lepack	3	49
how to quit an sproc Hi I am doing a check and on failing, i have a raiseerror command. I was assuming, once proc reaches raiseerror, it would stop the proc, but i see... rshivaraman@gmail.com	06-07-2007 09:59 AM Erland Sommarskog	1	37
HELP NEEDED Hi Friends, I would be highly grateful if anyone can provide a solution for the following : There is a MS-SQL server hosted on a machine which is... Phoenix	06-07-2007 07:39 AM Phoenix	0	48
Linux Server(Verified) 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 02:40 AM mark_smith	0	38
ADODB Command (Stored Procedure) 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 05:27 PM Erland Sommarskog	8	44
Strange character in column 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 04:15 PM Danny	2	43
Clustering SQL 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 12:48 PM Nacho	2	53
best way to add column not null 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 10:20 AM Jeff Kish	2	41
Deadlock Hi, How we can detect deadlock from a database. Rahul Rahul	06-06-2007 06:56 AM Robert Klemme	1	59
DTS w/ Oracle Issue 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 05:38 PM Jimbo	3	42
Restore Database Fails 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 04:42 PM Erland Sommarskog	5	46
Data import definition 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 02:32 PM nofear	0	45
How to? I have table with following structure: Cust Amount Type 1 150.00 1 1 100.00 ... Mirnes	06-05-2007 02:00 PM --CELKO--	4	75
Copy Row Of Data From Table to Table In Same DB ( 1 2 ) 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 01:57 PM --CELKO--	10	75
Maintenance Plan Database Selection 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 11:01 AM G-Diddy	0	50
Db Design for Matrix Lookup 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 08:33 PM Ben	2	38
Nulls in columns additions when 1 or more column values is blank 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 05:36 PM Erland Sommarskog	4	44
INVALID LENGTH PARAMETER PASSED.... 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 05:34 PM Erland Sommarskog	2	42
How to distinguish operation type in trigger? 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 05:15 PM Erland Sommarskog	5	278
escaping data for update query 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 02:31 PM eggie5	2	509
Database Infrastructure Failover Capability 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 01:31 PM Umar Reyi	0	37
HCL hiring IT professionals -Chennai/Noida/Gurgaon/Bangalore HCL hiring IT professionals -Chennai/Noida/Gurgaon/Bangalore Helpdesk / Technical Helpdesk - Noida / Chennai Application Packagers -... dbaguru	06-03-2007 03:45 AM dbaguru	0	50
Book recall 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 10:45 PM --CELKO--	2	51
dbinit(), dblogin(), how often? 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 12:38 PM Bruce.	4	43
SQL Server error '80040e31': please help me! 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 11:09 AM Tonio Tanzi	4	50
dbinit(), dblogin(), how often? 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 06:28 PM Bruce.	0	40
Synchronous Bulk-Copy into two table ( 1 2 ) 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 05:58 PM Khafancoder	18	73
Problems backing up SQL DB. 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 05:04 PM Erland Sommarskog	1	46
ANNOUNCE: Release 3 of Altova v2007 XML software available 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 02:24 PM announce@altova.com	0	44
Help on Partitioning column was not found. 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 09:22 AM Sonny	8	41
needed: 1 + null = 1 ( 1 2 ) 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 07:52 AM info@vanoordt.nl	12	77
PACKAGESTART / PACKAGEEND In SSIS 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 03:24 PM ansonee	0	50
What do you think about the checksum function ? 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 05:57 PM Erland Sommarskog	3	54
Need Help with a SQL Statement - Trying not to use a Cursor 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 01:26 PM rshivaraman@gmail.com	4	42
SQL Enterprise Manager - Not very usefull tool for building views 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 11:34 AM Martijn Tonies	2	49
sorting table while inserting 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 09:33 AM Jason Lepack	9	270
Re: Escaping international (unicode) characters in string 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 05:23 PM Erland Sommarskog	1	37
Char or varchar for a primary key? 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 11:56 AM --CELKO--	7	51

Page 52 of 282

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