dbTalk Databases Forums  

Sponsored Links


microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming


Discuss in the microsoft.public.sqlserver.programming forum.



Post New Thread
Threads in Forum : microsoft.public.sqlserver.programming Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hi, Is there a way to create a list of fields and their data types in a table other than using generate script? We'll be working with a call center...
Sam
01-03-2005 09:21 AM
Bob Barrows [MVP] Go to last post
1 64
Hi NG, I've to purge out old data from a logging table. E.g. I've to keep at least the last 1'000 rows of a table regardless of its date. Can I use...
Re Fo
01-03-2005 05:00 AM
Re Fo Go to last post
3 64
Hello, I have an internet site, that supports ms-sql server 2000. The hosting company for some reason have problems on there wizard of creating...
Eitan
01-03-2005 04:19 AM
avnrao Go to last post
2 73
Hi (I apologize for the length of this post.) We have a client action database that tracts open tickets between cases for a given client. CREATE...
J. M. De Moor
01-03-2005 03:46 AM
J. M. De Moor Go to last post
3 76
I am looking for opinions on the best way to version a database. I have a Winform application that will be using an MSDE 2000(A) database. From time...
TheNortonZ
01-03-2005 03:43 AM
Benny Tordrup Go to last post
5 81
Hi all and happy new year, I have an architectural question regarding SQL Server's parallelism algorithm: Let's say I have a quad CPU machine and...
Ami Levin
01-03-2005 03:12 AM
Ami Levin Go to last post
9 85
In a traditional parent-child table which is self-joined, like a manager and employee, we would have a table such as this tableName:...
Au Ru
01-02-2005 11:25 PM
Max Go to last post
19 84
I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and the MS SQL 2000 Server JDBC driver. I have installed and configured the...
Stuart Leonard
01-02-2005 10:27 PM
Stuart Leonard Go to last post
2 89
Im trying to create an Index on a view and getting: Server: Msg 1936, Level 16, State 1, Line 1 Cannot index the view 'Northwind.dbo.tmpSpeed'. It...
ChrisR
01-02-2005 10:14 PM
Max Go to last post
10 104
create table tbl ( a numeric( 11, 0 ) not null, b int not null, c binary( 10 ) null ) Column a is a clustered primary key. Columns b and c each have...
Richard G
01-02-2005 08:14 PM
Ken Go to last post
7 72
Hello, We have a query that works fine on SQL7 but not SQL2000. It has to do with Degree of Parallelism between the two boxes. Here is the scenario...
paul reed
01-02-2005 07:59 PM
Ken Go to last post
8 89
I have a trigger 'TriggerChangeHistoryLicense' setup on the 'License' table (all DDL code included below) which populates the...
John A Grandy
01-02-2005 06:30 PM
Erland Sommarskog Go to last post
3 71
Hello, Suppose the following: DECLARE test CURSOR FOR SELECT nameID, firstName FROM testing DECLARE @array TABLE ( nameID INT NOT NULL, firstName...
Andrew Clark
01-02-2005 06:15 PM
Hugo Kornelis Go to last post
5 47
Hello All, I have a Table named DVDVideo in the Stage database (StageDB) as well as in the Production DB (VideoMediaDB). On a weekly basis, the data...
Gopinath R
01-02-2005 05:03 AM
Nigel Rivett Go to last post
2 41
given the field checked as a bit field, I want to flip the state of checked I would think set checked = not checked would work, but it...
Mac Davis
01-01-2005 11:17 PM
Mac Davis Go to last post
2 69
OK here goes... managed to restore a db to MSDE without the SQL Server client tools, used OSQL and all works well... thanks ! Now using OSQL I...
Murphy
01-01-2005 10:15 PM
Andrew J. Kelly Go to last post
1 81
I often use a chain of queries to produce a final output. Eg to prepare aggregate data, or to set up generic queries which are then used in...
Nickl
01-01-2005 09:55 PM
Nickl Go to last post
6 56
Hi, I have a very strange problem. I have one sql 7.0 box, and one sql 2000 sp3 box. An ASP app that we've been running off of the 7.0 is now...
Rob
01-01-2005 07:03 PM
Erland Sommarskog Go to last post
2 48
In case you haven't noticed:)
Pike
01-01-2005 06:02 PM
Steve Kass Go to last post
5 47
Could somebody point me towards some example cursor code that takes a list of numbers: 1, 2, 3, 5, 7, 8, 9 and formats it into a range of...
sg
01-01-2005 12:53 PM
--CELKO-- Go to last post
10 96
I need a CSV output file with the columns themselves surrounded by quotes. I've tried -c -t"," which gives me the commas, but have not yet found...
Eric
01-01-2005 09:44 AM
Erland Sommarskog Go to last post
2 57
I get this message when executing SELECT statement in SQL 2000: Location: recbase.cpp:1374 Expression: m_nVars>0 S PID: 51 Process ID: 2480 Why?...
Dzemo
01-01-2005 09:38 AM
Erland Sommarskog Go to last post
3 49
If I have a table of customer products (let's say product A is a trial and Product B is a full version), how would I write a query that would...
Willie Bodger
01-01-2005 09:19 AM
--CELKO-- Go to last post
4 60
I was hoping for a more streamlined error handling now that we get try-catch but I seem to be running into a few problems. One very important idiom...
Alexander Jerusalem
01-01-2005 06:07 AM
Alexander Jerusalem Go to last post
3 55
Hi all, I've been having problems with an over night job since the 20/21st December, basically the import had been failing because of a problem with...
Rob Meade
01-01-2005 04:07 AM
mark baekdal Go to last post
3 55
I have a clean up project to delete a hundred million rows (from a table of 300 million) that are stale. These rows are children of about 500 parent...
Rex
12-31-2004 07:52 PM
Gert-Jan Strik Go to last post
3 62
sql2k. i've read it some where that transaction logs and the TempDb should be place on a RAID 1 (mirror) drive. I have two questions about the...
=== Steve L ===
12-31-2004 06:34 PM
=== Steve L === Go to last post
4 39
I have a table of student incidents, including absences from school, listing the student ID, the date of an incident, and whether it was an...
Nevyn Twyll
12-31-2004 05:33 PM
Nevyn Twyll Go to last post
3 48
I'd like SQL Server to email me on job failures. I've setup a profile through the mail icon in control panel and tested it successfully. When I go...
Brett
12-31-2004 04:40 PM
Chau Nguyen Go to last post
7 72
I have a partioned view called members. Partined based on status of the members. Tables : members_11 ( check status=1) members_22 (check...
Abraham
12-31-2004 12:54 PM
Robert Harmon Go to last post
8 64
We have VB program who queries data (using stored procedure) from a SQL Server 2000 db. The database can grow as much as 10 million records. When...
Paul fpvt2
12-31-2004 12:35 PM
Paul fpvt2 Go to last post
16 105
Hi, I have a suspicion about using Bulk Insert/update on indexes tables whether they bogged down performance or not. Or dropping indexes and/or...
Siz
12-31-2004 12:23 PM
David Gugick Go to last post
4 47
Hello, On a users table I have a field which indicates if the user is authorized or not. Is there a Boolean type in SQL database 2000 or should I...
Miguel Dias Moura
12-31-2004 10:34 AM
Hugo Kornelis Go to last post
2 51
The first time the following script runs, it successfully updates permissions. Even if I change the database, the script fails the second and each...
Garibaldi
12-31-2004 09:21 AM
garibaldi Go to last post
3 56
Hi all, I have experienced a problem over the last few days with an import job failing - this is being investigated, but I thought it best to setup...
Rob Meade
12-31-2004 09:17 AM
Rob Meade Go to last post
8 40
Hi, I Have the following bit of SQL in a stored procedure: SELECT DISTINCT ref FROM U_NFADHOC WHERE CONVERT(DATETIME,DATE) BETWEEN...
Robert
12-31-2004 08:31 AM
Tom Moreau Go to last post
1 58
Every time I startup Query Analyzer and connect a session to the database server, it always by default connects to a certain database. I would...
Mike Labosh
12-31-2004 08:29 AM
Tom Moreau Go to last post
6 59
need help resolving this concatenation error Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) Syntax error converting the varchar value...
TJS
12-31-2004 05:32 AM
Hugo Kornelis Go to last post
1 60
Hi Would it be possible for someone to check my code for the stored procedure shown below. I'm passing a date parameter into it, and then checking...
Robert
12-31-2004 05:27 AM
Hugo Kornelis Go to last post
1 42
Hi all, I have a problem with a conversion from some functions in Oracle to SQL Server (T-SQL). The functions are: to_char(time, 'dd-mm-yyyy...
Gigio
12-31-2004 04:36 AM
Hugo Kornelis Go to last post
3 55
Hi! Is it possible to create an database in SQL Server generated in VBScript?? Kind Regards Mehran
merre
12-30-2004 09:45 PM
Tom Moreau Go to last post
3 61
Thanks for the reply. I was able to find http://www.databasejournal.com/features/mssql/article.php/3339681 which looks promising. I got this to...
DavidM
12-30-2004 08:10 PM
Aaron [SQL Server MVP] Go to last post
6 48
did someone move the thread "to bit or not to bit" to another newsgroup ?
John A Grandy
12-30-2004 06:44 PM
David Gugick Go to last post
1 57
Hello I have 3 tables CREATE TABLE #Players ( Player char(1) ) CREATE TABLE #Scores ( Score smallint NOT NULL,
Lasse Edsvik
12-30-2004 06:40 PM
Hugo Kornelis Go to last post
14 112
Hi all, Does anybody know of a way to perform UTF-8 conversion as part of returned SQL statement from an nText field? I'm dealing with a...
Rick Strahl [MVP]
12-30-2004 05:50 PM
Erland Sommarskog Go to last post
3 59
Hello! Error Message: "Operation is not allowed when the object is closed." What I have is a stored procedure on SQL server that goes and checks...
Conax
12-30-2004 04:49 PM
Bob Barrows [MVP] Go to last post
3 67
How can I get the result show below. The rules also showing below. Any help would greatly appreciate. Thank you in advance. IF...
Lam Nguyen
12-30-2004 04:25 PM
Lam Nguyen Go to last post
3 54
Here is my query and it is taking forver to run. Is it in an infinate loop or no? Thanks for an answers. Use...
tarheels4025
12-30-2004 04:19 PM
Armando Prato Go to last post
1 184
when utilizing ADO.NET in vb.net or c# ....... is SQLDataReader.GetBoolean() the best way to retrieve a SQL-Server database column of datatype bit...
John A Grandy
12-30-2004 03:52 PM
John A Grandy Go to last post
2 89
Is there any way to get around the prohibition of 'create database' statements in triggers? What I'd like to do, ideally, is have an insert trigger...
Preston
12-30-2004 03:44 PM
Anith Sen Go to last post
6 51
Post New Thread

Display Options
Showing threads 47301 to 47350 of 69256
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 - 2014, Jelsoft Enterprises Ltd.