| Thread subject | Author | Replies | Date |
| How to install a 'local' server on my workstation | jmdoe1@m... | | 31 May |
| and's and or's | "Greg Partin" <greg@c...> | 2 | 31 May |
| Help on security in SQL server... | Guerrino Di Minno <GDiMinno@h...> | 1 | 31 May |
| Request | sssankhla@a... | 1 | 31 May |
| Rookie SQL questions | "Joe Hannan" <jhannan@g...> | | 31 May |
| RE: Upsizing an mdb | "Mavin Specimen" <mspecimen@h...> | | 31 May |
| Tool for synchronizing database structures? | "Tom Kelleher" <kelleher@t...> | | 30 May |
| Identity field | "Keith S. Safford" <keith.safford@e...> | 5 | 30 May |
| Time | "Steve" <scalhoun@s...> | | 30 May |
| VB Date Variable Inserted as SQL DateTime Field | roydickson@b... | | 30 May |
| SQL Server 2000 | MSpruill <mspruill@m...> | 8 | 30 May |
| Inconsistent security behavior | "Imar Spaanjaars" <Imar@S...> | 3 | 29 May |
| Quick Expert | "Richard Hadfield" <RichardH@t...> | | 29 May |
| Accessing SQL 6.5 and 7 from Access 2000 with MSDE remotely | "Quita Ryder" <qryder1@m...> | | 29 May |
| Collation problem | Bukovansky@a... | | 29 May |
| openrowset | mel.finney@l... | | 29 May |
| RE: TimeStamp | =?iso-8859-1?Q?Nicolai_A=2E_K=F8llner?= <nk@b...> | 1 | 28 May |
| Re: [sql_server digest: May 27, 2001] | Indraneel Phadke <iphadke@u...> | | 28 May |
| Character equallity | "Mark Strangways" <strangconst@h...> | 6 | 28 May |
| Case sensitive | "Mark Strangways" <strangconst@h...> | 9 | 27 May |
| clustered vs nonclustered index | "Jake C" <jakeone@b...> | 2 | 26 May |
| Remote connection to SQL Server 2000 | "Stephen L Calhoun" <scalhoun@s...> | 4 | 26 May |
| Help with Triggers | MSpruill <mspruill@m...> | 3 | 26 May |
| Full Text error | "Erin Grooms" <egrooms@n...> | | 25 May |
| DTS running independently when running from VB | "Banu" <banuweb@h...> | 1 | 25 May |
| ODBC Error | "Richard Hadfield" <RichardH@t...> | 3 | 25 May |
| multiple join statement | "Ng Khoon Siah" <ahsiah@S...> | 2 | 25 May |
| Inserting pictures into sql | "Denny Smolinski" <smolinskid@j...> | 3 | 25 May |
| When to use UNICODE N before hard-coded strings | Michael Marsten <mmarsten@N...> | 1 | 24 May |
| Help with sp_addlinkedserver | "gabe green" <gabe.green@e...> | | 24 May |
| using sp_addlinkedserver to connect to DB2 | "gabe green" <gabe.green@e...> | | 24 May |
| Problem using SQL Profiler | "Arif Khan (GWL)" <GWLAIK@w...> | 2 | 24 May |
| Update statement HELP... | Guerrino Di Minno <GDiMinno@h...> | 4 | 24 May |
| DB Restore | "Greg Partin" <greg@c...> | 3 | 24 May |
| trigger does not work (do not seems to fire) | "jose maria hernandez" <jmh@i...> | 4 | 24 May |
| Index over a view in SQL 7.0 | "Gonzalo Solano C." <GSolano@o...> | 3 | 24 May |
| Autonumber | "Mark Strangways" <strangconst@h...> | 7 | 24 May |
| Licensing issues | "Mavin Specimen" <mspecimen@h...> | 1 | 23 May |
| writing data to text file | "Paul" <pong@t...> | 3 | 23 May |
| Sql Server won't start | "Steve Read" <Steve.Read8787@b...> | 1 | 23 May |
| RE: Connection between Local SQL server7.0 to remote SQL server | "pong-TC" <pong@t...> | | 23 May |
| Connection between Local SQL server7.0 to remote SQL server 7.0 | swamy80@l... | 2 | 23 May |
| Data Archiving in SQL Server 2000 | "Maslina Mahi" <maslina@m...> | 2 | 23 May |
| Full Text Searches | egrooms@n... | | 22 May |
| Triggers | "Dave Buckner" <Dave@c...> | 8 | 22 May |
| how to pass table name as param to procedures | Floyd Hunag <flloid@p...> | 4 | 22 May |
| SP search does not work | =?iso-8859-1?Q?Jonathan_Hjertstr=F6m?= <jonathan@n...> | 8 | 22 May |
| Reducing the size of the Transaction Log | kirsten@l... | 2 | 22 May |
| trigger for insert does not work | "jose maria hernandez" <jmh@i...> | 2 | 22 May |
| Re: Convertng Queries | "Mavin Specimen" <mspecimen@h...> | 3 | 22 May |
| connection timed out | "Rahul" <rahul_a_g@r...> | 2 | 22 May |
| how to decrypt stored procedure? | "surender" <surender@w...> | 2 | 22 May |
| The "true" meaning of "backup" | "bill salkin" <wsalkin@h...> | 1 | 22 May |
| how to reduce the size of allocated space for log file | "Tim Zhang" <tzhang@h...> | 1 | 21 May |
| SQL Job connecting to Linked Server | "Austin, Jay" <jay@b...> | 2 | 21 May |
| querying tables with large volume of data | "balachandar ganesan" <gbala@b...> | | 21 May |
| Date Calculation | "Paul Collins" <paulc@s...> | 2 | 21 May |
| sql | "manav" <manavragi@h...> | 1 | 21 May |
| RE: Stored Procedure with in a Stored Procedure | "Jeff Mason" <jeffm@u...> | | 21 May |
| record selection based on date | "balachandar ganesan" <gbala@b...> | 6 | 21 May |
| Strored Procedure with in a Stored Procedure | Scott Watermasysk <swatermasysk@C...> | 3 | 21 May |
| INSERT...SELECT into a table variable | "Aaron Fanetti" <afanetti@c...> | | 20 May |
| Variable | "Paul" <pong@t...> | 4 | 18 May |
| Help: No description in ADO error in SQL Server from a compiled DLL | "Carles Leon" <cleon@s...> | 1 | 18 May |
| Numbered records | "Greg Partin" <greg@c...> | 1 | 18 May |
| Re: Scheduling a DTS Package | "Darron Michael" <darron.michael@h...> | | 17 May |
| Odd problem with an Access front-end accessing a SQLS7 table. | "Chris Simmons" <cxs0npe@f...> | 2 | 17 May |
| DTS: date-formatted source data files | Richard.Skinner@c... | 2 | 17 May |
| DTS (ETL1) | "Coppitters Bart" <bart.coppitters@b...> | | 17 May |
| Apostophe | "Steve Read" <Steve.Read8787@b...> | 5 | 17 May |
| view | "Greg Partin" <greg@c...> | | 17 May |
| Unable to Upsixe Query | "Paul Collins" <PaulC@s...> | 1 | 17 May |
| Simple Trigger - behaving weird | "nilesh" <nilesh_ah@h...> | 4 | 17 May |
| Create Parameter Date fields (2nd note) | roydickson@b... | 1 | 17 May |
| Is DTS the right tool? | "Jay Meerdink" <jaym@w...> | | 16 May |
| CreateParameter DATE fields | roydickson@b... | 4 | 16 May |
| Query 2 Big Tables | "nilesh" <nilesh_ah@h...> | 3 | 16 May |
| Which is better Sp or View For a Select statement? | "Elaheh Najafi" <elahehny@y...> | 4 | 16 May |
| Help with Update | "Hugh McLaughlin" <hugh@k...> | 6 | 16 May |
| Storage/Access issues for large varchar fields | "Tom Kelleher" <kelleher@t...> | 4 | 16 May |
| Cannot push data from DTS to Access | "Nicholas Floyd" <cutter-@r...> | 1 | 16 May |
| ERROR IN RUNNING DTS PACKAGE | "Elmer Donavan" <elmer.donavan@u...> | 1 | 16 May |
| Deleting from 2 tables | "Greg Partin" <greg@c...> | 2 | 15 May |
| How to access same table more than once | Anita Gupta <axg68@p...> | 3 | 15 May |
| What Dose View For? | "Elaheh Najafi" <elahehny@y...> | 8 | 15 May |
| Standard Naming in Sql Server | "Elaheh Najafi" <elahehny@y...> | 1 | 15 May |
| Audit table | "Greg Partin" <greg@c...> | 2 | 14 May |
| RE: [sql_language] query for duplicated record | "Allred, Mark (CRTATL)" <Mark.Allred@c...> | 1 | 14 May |
| Store Procedure HELP... | Guerrino Di Minno <GDiMinno@h...> | 3 | 14 May |
| Problem with return value | "Rahul" <rahul_a_g@r...> | 3 | 14 May |
| Web wizard | "Edward H K Ng" <edwardhkng@c...> | 2 | 14 May |
| DTS - activeX - vbs examples | "Andrew Goodall" <amgccc@h...> | 3 | 14 May |
| Re: SQL 6.5 How do I | "Paige St. John" <pstjohn@t...> | 1 | 13 May |
| Alternative database storage | "Paige St. John" <pstjohn@t...> | 2 | 13 May |
| Frequency of trans log backup | "bill salkin" <wsalkin@h...> | 3 | 12 May |
| How to INSERT empty date field | roydickson@b... | 3 | 12 May |
| Error in scheduling DTS package | "Yitao yu" <yuy@n...> | | 12 May |
| SQL 6.5 How do I "attach" a DB? | "Xu Gary" <Gary.Xu@p...> | 3 | 12 May |
| Can I reboot SQL server if all connections are "sleeping" | "bill salkin" <wsalkin@h...> | 1 | 12 May |
| SQL Rights for developers/end-users | "bill salkin" <wsalkin@h...> | 2 | 12 May |
| Naming for stored procedures | "Lenny Liu" <lennyl@f...> | 4 | 11 May |
| Stored Procedure Not Returning Recordset | "Tony Pacetti" <a.pacetti@g...> | 2 | 11 May |
| Procedure for Datediff | Jithesh Kumar <jithu_kumar@y...> | 1 | 11 May |
| Where can I find SQL Server 2000 Personal Edition? | "bill salkin" <wsalkin@h...> | 2 | 11 May |
| SQL 7 Local problem with Query Analyzer/EM | "bill salkin" <wsalkin@h...> | | 11 May |
| getting error trying get rec count from select inside SP | "Bill Robinson" <Bill.Robinson@S...> | 5 | 11 May |
| Saving query results to file | "Karen Jackson" <kjackson@f...> | 2 | 11 May |
| Single Quotes in text passed to stored procedure | "Bill Robinson" <Bill.Robinson@S...> | 4 | 10 May |
| How can I integrate SQL Server with Visual Source Safe? | Clifton Dunaway <csdunaway@y...> | | 10 May |
| DTS SQL Task Problem | ZUBIN DHAMODIWALA <zubin@g...> | 1 | 10 May |
| Newbie Question | "R Barone" <rbarone@g...> | 1 | 10 May |
| Order By | "Prasad Magimay" <pmagimay@h...> | 1 | 10 May |
| Query Help | "Greg Partin" <greg@c...> | | 09 May |
| Help.. | Guerrino Di Minno <GDiMinno@h...> | 4 | 09 May |
| Date Calculation Spin Error in SQL Svr Agent | "Karen Jackson" <kjackson@f...> | | 09 May |
| Foreign Key | "Greg Partin" <greg@c...> | 3 | 09 May |
| Passising values to a Stored Procedure | "Antonello Corbo" <antonello65@i...> | 6 | 09 May |
| problem deleting records using ado | "Rahul" <rahul_a_g@r...> | 2 | 09 May |
| Backup Problem | "Zubin Dhamodiwala" <zubin@g...> | 4 | 09 May |
| Strange Index Objects _WA_Sys_* | "Michael Morisoli" <Michael@M...> | 2 | 08 May |
| Write data to Text file and FTP | "Paul" <pong@t...> | 2 | 08 May |
| How to use IIF function of access with SQL Server | priyaloke@y... | 5 | 08 May |
| Re: why doesn't this work in SQL: INSTR(description, | "Thomas Parker" <tp482@h...> | | 08 May |
| why doesn't this work in SQL: INSTR(description,".",1,1) ? | "Thomas Parker" <tp482@h...> | 2 | 08 May |
| Log In Problems | brose@u... | 3 | 08 May |
| Sql server Timeout expired | kuppuswamy vaidyanathan <kvngold@y...> | 4 | 08 May |
| System Stored Procedures | "Jay Lindsay" <jay.lindsay@h...> | 5 | 07 May |
| Updating fields in SQL Server | "Hugh McLaughlin" <hugh@k...> | 3 | 07 May |
| Select can't separate W and V | ulf.elfving@f... | 2 | 07 May |
| Considering Oracle8 to SQL Server migration - general questions | "Rich Gilmour" <reesh@p...> | 1 | 06 May |
| How do I read in ActiveX scripts into Transforms? | "David Harding" <David.Harding@s...> | | 06 May |
| How to Print Table Specs ? | roydickson@b... | 6 | 05 May |
| pulling return value our of executed sql string in stored procedure | "Bill Robinson" <Bill.Robinson@S...> | 1 | 05 May |
| Special Characters in column names | "Jonathan Pease" <jwp@n...> | 3 | 04 May |
| Stored Procedure Select | "Bill Robinson" <Bill.Robinson@S...> | 5 | 04 May |
| Last 'n' records | "David E" <registerukh@h...> | 2 | 04 May |
| Access ignoring SQL Server security | "elizabeth mohr" <elizabeth_mohr@f...> | 4 | 04 May |
| Sql 2000 Data Warehousing | "Zubin Dhamodiwala" <zubin@g...> | 1 | 04 May |
| DTS | "Andrew Goodall" <andrew.goodall@b...> | 4 | 04 May |
| RE: stored procedure - Thanks | "David E" <registerukh@h...> | | 03 May |
| Returning a float value with a stored procedure | "Eric Wackwitz" <eric_wackwitz@u...> | 6 | 03 May |
| BACKUP strategy needed | "bill salkin" <wsalkin@h...> | 1 | 03 May |
| stored procedure | "David E" <registerukh@h...> | 6 | 03 May |
| SQL Server Cross-tab / Pivot problems | "Tim Norton" <tttbsn@h...> | | 03 May |
| storing pdf in sql server database | "amir aboulhelm" <myProMail@y...> | 1 | 03 May |
| Replication | martin.hansen@x... | 2 | 03 May |
| ON INSERT HOW CAN I GET SQL TO EXECUTE AN EXTERNAL PROGRAM | "Craig Cheesman" <craig@s...> | 3 | 03 May |
| trigger for update | "jose maria hernandez" <jmh@i...> | 2 | 03 May |
| Problem Uploading DB to the production Server | "Mohd J. Alam" <alam@s...> | 3 | 03 May |
| Performance problems with SQL Server 2000 and large tables. | Stephen@V... | 4 | 03 May |
| Record Level Locking | "Cesar Henao" <sqlmillos@h...> | 1 | 03 May |
| Cursors, stored procedures and ASP | "David E" <registerukh@h...> | 3 | 03 May |
| Accessing a MySQL DB From outside your domain | Empier4552@a... | | 03 May |
| Need Help With SQL Server Enterprise Manager | "Michael Wong" <go2net@p...> | | 03 May |
| Re: Problems with NULL | "Wade Weal" <wadeweal@h...> | | 02 May |
| DTS Global Variables | "Edward Hunter" <edward.hunter@a...> | 1 | 02 May |
| Re: DTS Packages Export/Copy | "Ariel Comstock" <Ariel.Comstock@b...> | 2 | 02 May |
| I have a question regarding parameter's??? | Guerrino Di Minno <GDiMinno@h...> | 3 | 02 May |
| Tolerance (revisited) | "Charles Feduke" <webmaster@r...> | 2 | 02 May |
| how to write sp to retrieve records randomly | "surender" <sp_jain@r...> | 6 | 02 May |
| DTS Scripting | Clifton Dunaway <csdunaway@y...> | 3 | 02 May |
| problem with outer-join | Aftab Ahmad <aftab.ahmad@k...> | 3 | 02 May |
| How to Make stored procedure to copy one table to another table ? | "Kukuh TW" <milis@k...> | 1 | 02 May |
| 14,400 insert statements | "John Wislon" <that_chris_guy@e...> | 4 | 02 May |
| INSERT EXEC statement cannot be nested | Ankur Kalsi <ankurak@q...> | 3 | 02 May |
| SQL 2000 backup question | "bill salkin" <wsalkin@h...> | | 02 May |
| Remote Sql Server | "Rudy Cooper" <rudycoop@p...> | 1 | 01 May |
| RE: IIS5 and SQL Server 2000 | "Christopher Koniges And Lynn Horn" <chris@j...> | | 01 May |
| RE: How to insert image picture in SQL Server 7 table | "Christopher Koniges And Lynn Horn" <chris@j...> | | 01 May |
| Alternatives to SELECT INTO | "bill salkin" <wsalkin@h...> | 2 | 01 May |
| Platform compatible ?? | "Keith Lee" <kitleeky@m...> | 3 | 01 May |
| Search Tolerance | "Charles Feduke" <webmaster@r...> | | 01 May |
| sql server 7 distributed transaction | "D.K." <kruschek@y...> | 3 | 01 May |
| Max length of SQL 2000 variable\table\object types | "bill salkin" <wsalkin@h...> | | 01 May |
| Returning a recordset with a stored procedure. | "Eric Wackwitz" <eric_wackwitz@u...> | 2 | 01 May |
| Unsolved mystery | "Andre" <andrekl@m...> | | 01 May |
| RE: returning a new record immediately | "Sam Lewitan" <slewitan@e...> | | 01 May |
| Retrieving value of Identity column after insert on remote server | Kyle Burns <kburns@c...> | 9 | 01 May |
| 3rd Normal Form | "Greg Partin" <greg@c...> | 1 | 01 May |
| Transaction Log Truncate | Stanley Glass <SGlass@r...> | 4 | 01 May |
| RE: Can I call or execute a DTS from a stored proced- ure??? | "Huber, Mike" <MHuber@p...> | 1 | 01 May |
| Can anyone help ? | "Simon Garstin" <sgarstin@t...> | 7 | 01 May |
| Re: Problem With In Operator | "Geoff Higgins" <geoff@v...> | 2 | 01 May |
| Re: Problems opening tables in enterprise manager? | "Geoff Higgins" <geoff@v...> | 2 | 01 May |
| Re: Non-Duplicate results? | "Stuart Naylor" <indtec@e...> | | 01 May |
| EM SQL 2000 vs EM SQL 7 | "bill salkin" <wsalkin@h...> | 2 | 01 May |
| Database "stuck" in Loading mode. | "bill salkin" <wsalkin@h...> | 1 | 01 May |
| RE: Sortin of Rows in a sql View with out going back to the data Base | "Michael A. Michalski" <mmcihalski@n...> | | 01 May |
| RE: Installing windows 2000 prof & SQL server | Bernard Omiple <BernardO@a...> | 3 | 01 May |