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...
01-03-2005 08: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 04: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...
01-03-2005 03: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 02: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...
01-03-2005 02: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 02: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 10:25 PM
Max Go to last post
19 85
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 09: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...
01-02-2005 09:14 PM
Max Go to last post
10 105
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 07: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 06: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 05: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 05: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 04: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 10: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...
01-01-2005 09: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...
01-01-2005 08: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...
01-01-2005 06:03 PM
Erland Sommarskog Go to last post
2 48
In case you haven't noticed:)
01-01-2005 05: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...
01-01-2005 11:53 AM
--CELKO-- Go to last post
10 98
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...
01-01-2005 08: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?...
01-01-2005 08: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 08: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 05: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 03:07 AM
mark baekdal Go to last post
3 56
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...
12-31-2004 06:52 PM
Gert-Jan Strik Go to last post
3 63
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 05: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 04: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...
12-31-2004 03: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...
12-31-2004 11:54 AM
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 11:35 AM
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...
12-31-2004 11:23 AM
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 09: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...
12-31-2004 08: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 08: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...
12-31-2004 07: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 07:29 AM
Tom Moreau Go to last post
6 60
need help resolving this concatenation error Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) Syntax error converting the varchar value...
12-31-2004 04:32 AM
Hugo Kornelis Go to last post
1 61
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...
12-31-2004 04: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...
12-31-2004 03:36 AM
Hugo Kornelis Go to last post
3 56
Hi! Is it possible to create an database in SQL Server generated in VBScript?? Kind Regards Mehran
12-30-2004 08: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...
12-30-2004 07: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 05: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 05:40 PM
Hugo Kornelis Go to last post
14 115
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 04: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...
12-30-2004 03:49 PM
Bob Barrows [MVP] Go to last post
3 68
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 03:25 PM
Lam Nguyen Go to last post
3 55
Here is my query and it is taking forver to run. Is it in an infinate loop or no? Thanks for an answers. Use...
12-30-2004 03:19 PM
Armando Prato Go to last post
1 194
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 02:52 PM
John A Grandy Go to last post
2 90
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...
12-30-2004 02: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 - 2015, Jelsoft Enterprises Ltd.