p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  View Archive  

Thread subjectAuthorRepliesDate
How to install a 'local' server on my workstationjmdoe1@m... 31 May
and's and or's"Greg Partin" <greg@c...>231 May
Help on security in SQL server...Guerrino Di Minno <GDiMinno@h...>131 May
Requestsssankhla@a...131 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...>530 May
Time"Steve" <scalhoun@s...> 30 May
VB Date Variable Inserted as SQL DateTime Fieldroydickson@b... 30 May
SQL Server 2000MSpruill <mspruill@m...>830 May
Inconsistent security behavior"Imar Spaanjaars" <Imar@S...>329 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 problemBukovansky@a... 29 May
openrowsetmel.finney@l... 29 May
RE: TimeStamp=?iso-8859-1?Q?Nicolai_A=2E_K=F8llner?= <nk@b...>128 May
Re: [sql_server digest: May 27, 2001]Indraneel Phadke <iphadke@u...> 28 May
Character equallity"Mark Strangways" <strangconst@h...>628 May
Case sensitive"Mark Strangways" <strangconst@h...>927 May
clustered vs nonclustered index"Jake C" <jakeone@b...>226 May
Remote connection to SQL Server 2000"Stephen L Calhoun" <scalhoun@s...>426 May
Help with TriggersMSpruill <mspruill@m...>326 May
Full Text error"Erin Grooms" <egrooms@n...> 25 May
DTS running independently when running from VB"Banu" <banuweb@h...>125 May
ODBC Error"Richard Hadfield" <RichardH@t...>325 May
multiple join statement"Ng Khoon Siah" <ahsiah@S...>225 May
Inserting pictures into sql"Denny Smolinski" <smolinskid@j...>325 May
When to use UNICODE N before hard-coded stringsMichael Marsten <mmarsten@N...>124 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...>224 May
Update statement HELP...Guerrino Di Minno <GDiMinno@h...>424 May
DB Restore"Greg Partin" <greg@c...>324 May
trigger does not work (do not seems to fire)"jose maria hernandez" <jmh@i...>424 May
Index over a view in SQL 7.0"Gonzalo Solano C." <GSolano@o...>324 May
Autonumber"Mark Strangways" <strangconst@h...>724 May
Licensing issues"Mavin Specimen" <mspecimen@h...>123 May
writing data to text file"Paul" <pong@t...>323 May
Sql Server won't start"Steve Read" <Steve.Read8787@b...>123 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.0swamy80@l...223 May
Data Archiving in SQL Server 2000"Maslina Mahi" <maslina@m...>223 May
Full Text Searchesegrooms@n... 22 May
Triggers"Dave Buckner" <Dave@c...>822 May
how to pass table name as param to proceduresFloyd Hunag <flloid@p...>422 May
SP search does not work=?iso-8859-1?Q?Jonathan_Hjertstr=F6m?= <jonathan@n...>822 May
Reducing the size of the Transaction Logkirsten@l...222 May
trigger for insert does not work"jose maria hernandez" <jmh@i...>222 May
Re: Convertng Queries"Mavin Specimen" <mspecimen@h...>322 May
connection timed out"Rahul" <rahul_a_g@r...>222 May
how to decrypt stored procedure?"surender" <surender@w...>222 May
The "true" meaning of "backup""bill salkin" <wsalkin@h...>122 May
how to reduce the size of allocated space for log file"Tim Zhang" <tzhang@h...>121 May
SQL Job connecting to Linked Server"Austin, Jay" <jay@b...>221 May
querying tables with large volume of data"balachandar ganesan" <gbala@b...> 21 May
Date Calculation"Paul Collins" <paulc@s...>221 May
sql"manav" <manavragi@h...>121 May
RE: Stored Procedure with in a Stored Procedure"Jeff Mason" <jeffm@u...> 21 May
record selection based on date"balachandar ganesan" <gbala@b...>621 May
Strored Procedure with in a Stored ProcedureScott Watermasysk <swatermasysk@C...>321 May
INSERT...SELECT into a table variable"Aaron Fanetti" <afanetti@c...> 20 May
Variable"Paul" <pong@t...>418 May
Help: No description in ADO error in SQL Server from a compiled DLL"Carles Leon" <cleon@s...>118 May
Numbered records"Greg Partin" <greg@c...>118 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...>217 May
DTS: date-formatted source data filesRichard.Skinner@c...217 May
DTS (ETL1)"Coppitters Bart" <bart.coppitters@b...> 17 May
Apostophe"Steve Read" <Steve.Read8787@b...>517 May
view"Greg Partin" <greg@c...> 17 May
Unable to Upsixe Query"Paul Collins" <PaulC@s...>117 May
Simple Trigger - behaving weird"nilesh" <nilesh_ah@h...>417 May
Create Parameter Date fields (2nd note)roydickson@b...117 May
Is DTS the right tool?"Jay Meerdink" <jaym@w...> 16 May
CreateParameter DATE fieldsroydickson@b...416 May
Query 2 Big Tables"nilesh" <nilesh_ah@h...>316 May
Which is better Sp or View For a Select statement?"Elaheh Najafi" <elahehny@y...>416 May
Help with Update"Hugh McLaughlin" <hugh@k...>616 May
Storage/Access issues for large varchar fields"Tom Kelleher" <kelleher@t...>416 May
Cannot push data from DTS to Access"Nicholas Floyd" <cutter-@r...>116 May
ERROR IN RUNNING DTS PACKAGE"Elmer Donavan" <elmer.donavan@u...>116 May
Deleting from 2 tables"Greg Partin" <greg@c...>215 May
How to access same table more than onceAnita Gupta <axg68@p...>315 May
What Dose View For?"Elaheh Najafi" <elahehny@y...>815 May
Standard Naming in Sql Server"Elaheh Najafi" <elahehny@y...>115 May
Audit table"Greg Partin" <greg@c...>214 May
RE: [sql_language] query for duplicated record"Allred, Mark (CRTATL)" <Mark.Allred@c...>114 May
Store Procedure HELP...Guerrino Di Minno <GDiMinno@h...>314 May
Problem with return value"Rahul" <rahul_a_g@r...>314 May
Web wizard"Edward H K Ng" <edwardhkng@c...>214 May
DTS - activeX - vbs examples"Andrew Goodall" <amgccc@h...>314 May
Re: SQL 6.5 How do I"Paige St. John" <pstjohn@t...>113 May
Alternative database storage"Paige St. John" <pstjohn@t...>213 May
Frequency of trans log backup"bill salkin" <wsalkin@h...>312 May
How to INSERT empty date fieldroydickson@b...312 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...>312 May
Can I reboot SQL server if all connections are "sleeping""bill salkin" <wsalkin@h...>112 May
SQL Rights for developers/end-users"bill salkin" <wsalkin@h...>212 May
Naming for stored procedures"Lenny Liu" <lennyl@f...>411 May
Stored Procedure Not Returning Recordset"Tony Pacetti" <a.pacetti@g...>211 May
Procedure for DatediffJithesh Kumar <jithu_kumar@y...>111 May
Where can I find SQL Server 2000 Personal Edition?"bill salkin" <wsalkin@h...>211 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...>511 May
Saving query results to file"Karen Jackson" <kjackson@f...>211 May
Single Quotes in text passed to stored procedure"Bill Robinson" <Bill.Robinson@S...>410 May
How can I integrate SQL Server with Visual Source Safe?Clifton Dunaway <csdunaway@y...> 10 May
DTS SQL Task ProblemZUBIN DHAMODIWALA <zubin@g...>110 May
Newbie Question"R Barone" <rbarone@g...>110 May
Order By"Prasad Magimay" <pmagimay@h...>110 May
Query Help"Greg Partin" <greg@c...> 09 May
Help..Guerrino Di Minno <GDiMinno@h...>409 May
Date Calculation Spin Error in SQL Svr Agent"Karen Jackson" <kjackson@f...> 09 May
Foreign Key"Greg Partin" <greg@c...>309 May
Passising values to a Stored Procedure"Antonello Corbo" <antonello65@i...>609 May
problem deleting records using ado"Rahul" <rahul_a_g@r...>209 May
Backup Problem"Zubin Dhamodiwala" <zubin@g...>409 May
Strange Index Objects _WA_Sys_*"Michael Morisoli" <Michael@M...>208 May
Write data to Text file and FTP"Paul" <pong@t...>208 May
How to use IIF function of access with SQL Serverpriyaloke@y...508 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...>208 May
Log In Problemsbrose@u...308 May
Sql server Timeout expiredkuppuswamy vaidyanathan <kvngold@y...>408 May
System Stored Procedures"Jay Lindsay" <jay.lindsay@h...>507 May
Updating fields in SQL Server"Hugh McLaughlin" <hugh@k...>307 May
Select can't separate W and Vulf.elfving@f...207 May
Considering Oracle8 to SQL Server migration - general questions"Rich Gilmour" <reesh@p...>106 May
How do I read in ActiveX scripts into Transforms?"David Harding" <David.Harding@s...> 06 May
How to Print Table Specs ?roydickson@b...605 May
pulling return value our of executed sql string in stored procedure"Bill Robinson" <Bill.Robinson@S...>105 May
Special Characters in column names"Jonathan Pease" <jwp@n...>304 May
Stored Procedure Select"Bill Robinson" <Bill.Robinson@S...>504 May
Last 'n' records"David E" <registerukh@h...>204 May
Access ignoring SQL Server security"elizabeth mohr" <elizabeth_mohr@f...>404 May
Sql 2000 Data Warehousing"Zubin Dhamodiwala" <zubin@g...>104 May
DTS"Andrew Goodall" <andrew.goodall@b...>404 May
RE: stored procedure - Thanks"David E" <registerukh@h...> 03 May
Returning a float value with a stored procedure"Eric Wackwitz" <eric_wackwitz@u...>603 May
BACKUP strategy needed"bill salkin" <wsalkin@h...>103 May
stored procedure"David E" <registerukh@h...>603 May
SQL Server Cross-tab / Pivot problems"Tim Norton" <tttbsn@h...> 03 May
storing pdf in sql server database"amir aboulhelm" <myProMail@y...>103 May
Replicationmartin.hansen@x...203 May
ON INSERT HOW CAN I GET SQL TO EXECUTE AN EXTERNAL PROGRAM"Craig Cheesman" <craig@s...>303 May
trigger for update"jose maria hernandez" <jmh@i...>203 May
Problem Uploading DB to the production Server"Mohd J. Alam" <alam@s...>303 May
Performance problems with SQL Server 2000 and large tables.Stephen@V...403 May
Record Level Locking"Cesar Henao" <sqlmillos@h...>103 May
Cursors, stored procedures and ASP"David E" <registerukh@h...>303 May
Accessing a MySQL DB From outside your domainEmpier4552@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...>102 May
Re: DTS Packages Export/Copy"Ariel Comstock" <Ariel.Comstock@b...>202 May
I have a question regarding parameter's???Guerrino Di Minno <GDiMinno@h...>302 May
Tolerance (revisited)"Charles Feduke" <webmaster@r...>202 May
how to write sp to retrieve records randomly"surender" <sp_jain@r...>602 May
DTS ScriptingClifton Dunaway <csdunaway@y...>302 May
problem with outer-joinAftab Ahmad <aftab.ahmad@k...>302 May
How to Make stored procedure to copy one table to another table ?"Kukuh TW" <milis@k...>102 May
14,400 insert statements"John Wislon" <that_chris_guy@e...>402 May
INSERT EXEC statement cannot be nestedAnkur Kalsi <ankurak@q...>302 May
SQL 2000 backup question"bill salkin" <wsalkin@h...> 02 May
Remote Sql Server"Rudy Cooper" <rudycoop@p...>101 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...>201 May
Platform compatible ??"Keith Lee" <kitleeky@m...>301 May
Search Tolerance"Charles Feduke" <webmaster@r...> 01 May
sql server 7 distributed transaction"D.K." <kruschek@y...>301 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...>201 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 serverKyle Burns <kburns@c...>901 May
3rd Normal Form"Greg Partin" <greg@c...>101 May
Transaction Log TruncateStanley Glass <SGlass@r...>401 May
RE: Can I call or execute a DTS from a stored proced- ure???"Huber, Mike" <MHuber@p...>101 May
Can anyone help ?"Simon Garstin" <sgarstin@t...>701 May
Re: Problem With In Operator"Geoff Higgins" <geoff@v...>201 May
Re: Problems opening tables in enterprise manager?"Geoff Higgins" <geoff@v...>201 May
Re: Non-Duplicate results?"Stuart Naylor" <indtec@e...> 01 May
EM SQL 2000 vs EM SQL 7"bill salkin" <wsalkin@h...>201 May
Database "stuck" in Loading mode."bill salkin" <wsalkin@h...>101 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 serverBernard Omiple <BernardO@a...>301 May