p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  View Archive  

Thread subjectAuthorRepliesDate
help with query"Michael Robertson" <mike@m...>131 Jul
Normalization and calculations questions"Michael Metz" <mjmetz@q...>130 Jul
Trigger example in Prof SQL Server 2000 Programming"Paul Roman" <pdroman@b...> 31 Jul
Strange SP behaiviorPatrick Mair <pmair@e...>430 Jul
Optimum Server Configurationrstelma@d... 30 Jul
sqlsrv2k - Strange behaviour after MS02-034 hotfix installationmartin@b... 30 Jul
naming a resultset in a stored procedure"greg robinson" <gregarobinson@h...> 30 Jul
BCP command from Stored ProcedureJithesh Kumar <jithu_kumar@y...> 30 Jul
Default values and DTS with SQL Server 2000..."Subscriptions" <subscriptions@s...>430 Jul
Connection problems."Ougnou, Abdel" <aougn99@h...> 29 Jul
Current_UserRyan Smethurst <RyanS@p...> 29 Jul
DATABASE DESIGN"MIKE KERR" <MIKEZCG@Y...>129 Jul
Creation of database using Dos prompt"urmilla tikoo" <urmi_tikoo@h...>529 Jul
Import csv file with non-standard date header"Marc McAllister" <marc.mcallister@g...>129 Jul
sql server agent & NT Admin rights question"David Bulog" <d2ba@x...>129 Jul
Re: null insert into identity columnrstelma@d...430 Jul
Is there a way to replicate a table to file on a per transaction basis?"Adam Richards" <adamrich@a...> 29 Jul
Re: sql_server digest: July 22, 2002Ncolemaniii@a... 23 Jul
Re: Errors"Jeff Mason" <jeffm.ma.ultranet@r...>223 Jul
Tables with multiple parents"Iain Downs" <idowns@d...> 24 Jul
Data Transform creation delay using Sybase"Lepingwell, Christopher" <Christopher.Lepingwell@g...>122 Jul
RE: How To Solve This Without Using a CursorVishal Gandhi <GandhiV@m...>524 Jul
Re: sql server won't connectionroberto.souza@m...224 Jul
RE: Case Statement in Update Query - SQL Server 7"Jeff Mason" <jeffm.ma.ultranet@r...>224 Jul
RE: How to uninstall SQL Server 2k in a failover clu ster environment."Ougnou, Abdel" <aougn99@h...> 24 Jul
Re: adding 's to our favorite nameGloriaGalvez@a...125 Jul
Re: SQL Server registration failed because of the connection failure displayed below"Dick Baker" <dickbaker@t...>125 Jul
Re: Linked serverconnectivity problem"Phaneendra" <phaneendra@s...>225 Jul
Re: Indexing Views"Jeff Mason" <jeffm.ma.ultranet@r...>325 Jul
Re: DTS and Execute Package Task"Kenny Garrington" <K.Garrington@m...> 25 Jul
Re: SQL 7 Stored Procedures"Hassan Ali" <technofriend@i...> 25 Jul
Linked Servers"greg robinson" <gregarobinson@h...> 25 Jul
Re: Update Script problem"Dick Baker" <dickbaker@t...>125 Jul
Re: INSERT ERROR WITH IDENTY COL"Dick Baker" <dickbaker@t...>225 Jul
Re: F I X R E Q U I R E D !...."itsethu" <itsethu@i...>226 Jul
SV: Case Statement in Update Query - SQL Server 7"Ali Karimi" <a97alika@s...> 26 Jul
Undetected deadlocking?"Mark Powell" <mpowell@a...>126 Jul
Re: Tables with multiple parents - try 2"Iain Downs" <idowns@d...>326 Jul
Re: fix corrupt index?"Kamen Angelov" <k_angelov@h...>426 Jul
OLAP cube processing ODBC timeout"zak willis" <zak_willis@h...> 26 Jul
Truncate Data Error"Yehuda Rosenblum" <Yehuda@I...> 26 Jul
linked server under the covers"greg robinson" <gregarobinson@h...> 26 Jul
SQL Agent job fails, but keeps running before exits"Sean Witte" <switte@s...> 26 Jul
My computer doesn't allow me to install SQL 2000!"Hugo" <hugochiu@n...>226 Jul
Lumigent Log ExplorerJulia Poddoubsky <jpoddoubsky@d...> 26 Jul
Re: linked server to AS400"greg robinson" <gregarobinson@h...>126 Jul
SQL State 28000, Error 18456, Login Failed for user?"Ron Howerton" <ron.howerton@s...> 26 Jul
Re: ODBC Connection error with Pass Thru referencing NT Groups"Kamen Angelov" <k_angelov@h...>1126 Jul
Re: performance on view"Kamen Angelov" <k_angelov@h...>127 Jul
how to restore from .mdf file=?iso-8859-1?q?chinna=20thirummorthy?= <cthirumoorthy@y...>327 Jul
Is there any SQL Profiler equivalent in Oracle...?Mitesh_Shah <Mitesh_Shah@S...> 27 Jul
Creating a linked server"colin ure" <colin@s...> 16 Jul
SQL Mail question"Kalyan" <snkalyan@e...> 16 Jul
Return value from store procedureanguyen@f...115 Jul
Re: Inserting UniqueIdentifier valuesnaira@n...116 Jul
SQL Upgrade with changesRyan Smethurst <RyanS@p...> 15 Jul
Which is quicker?Richard Hadfield <Richard.Hadfield@t...> 15 Jul
RE: Copy Database Script?"Jeff Mason" <jeffm@u...>616 Jul
single user mode question"emmanuel mendoza" <mendoza@r...> 15 Jul
Virus. (No attachments)"G.R.Preethiviraj Kulasingham" <preethi@s...> 15 Jul
Re: Spool queries to flat files.Ravindranath Chittar <sql_group@y...>217 Jul
Re: return, output or select"Ken Schaefer" <ken@a...>317 Jul
Talking and formatting badly input dates in a database"Alex Bienz" <alex@v...> 17 Jul
html format using xp_sendmail"Kalyan" <snkalyan@e...>118 Jul
RE: 'N ???James Willock <james.willock@e...>317 Jul
Remote Stored procedure."Phaneendra" <phaneendra@s...> 17 Jul
RE: Unicode"Ray Jezek (TT)" <ray.jezek@t...>117 Jul
Re: Cant see SQL SERVER 7 /Machine name on Novel l Network; but SQL Server 2000 OK"Low, Travis" <Tlow@S...>317 Jul
RE: Trying too add two select statements together!!!"Denis Gobo" <dgobo@w...>117 Jul
RE: MS SQL Server 7 vs MS SQL Server 2000"Austin, Jay" <jay@b...>117 Jul
Re: update statementGreg Griffiths <greg.griffiths@g...>117 Jul
Re: SV: Re: Hopefully simple question!Mike Thompson <mikethompson@c...>118 Jul
Re: SProcs - SQL Server 2000 - NVarChar(4000) Limitiation"Stephen Woods" <SWoods@v...>318 Jul
RE: Database is not Openingbabujegan <babujegan@s...>118 Jul
RE: Enterprise Manager"Reyes, Pocholo" <preyes@w...>118 Jul
RE: DBCC Show ContigVishal Gandhi <GandhiV@m...>218 Jul
extended MAPI connection, CDO ,Outlook 2000 Client and SQL Server 2000."David Bulog" <d2ba@x...> 18 Jul
Import Text file using bulk insert"Michael Wright" <mrwaus@s...> 18 Jul
<long text>"Niall Hannon (ext. 772)" <Niall.Hannon@f...>319 Jul
RE: Set identity_insert ON in dynamic SQLJulia Poddoubsky <jpoddoubsky@d...>217 Jul
Limit datetime field to only date"SW" <sawoods4@h...>1214 Jul
Service packArthur Maloney <AM@s...>214 Jul
Re: sp_msforeachtable and dynamic SQL"sanchayan" <sanchayan@o...>119 Jul
RE: OT:Development Practices"Jeff Mason" <jeffm.ma.ultranet@r...>119 Jul
Install errorAdriaan Davel <AdriaanD@p...> 19 Jul
RE: data type for large text fieldrstelma@d...719 Jul
Appending 2 tables, structurally identical, with IDENTITY fields"John K. King" <johnking@o...>619 Jul
RE: Join 2 Diff Databases"Jack Dunstan" <jdunstan7@h...>619 Jul
RE: SELECT problem on Search procedureMike Thompson <mikethompson@c...>719 Jul
RE: neeravji"Peter Kaufman" <kaufman@l...>320 Jul
Re: DTS Activex Script Task Shell.Run command"David Bulog" <d2ba@x...>220 Jul
RE: help with tricky select statement"Jeff Mason" <jeffm.ma.ultranet@r...>320 Jul
RE: Ms data shapeJames Willock <james.willock@e...>109 Jul
SecurityRichard Hadfield <Richard.Hadfield@t...> 09 Jul
RE: DTS task or How to call a Stored ProdAllan Mitchell <AMMitchell@c...>109 Jul
CPU spinVince Johnston <Vince.Johnston@H...> 09 Jul
Re: Range of RecordsDavid Cameron <dcameron@i...>210 Jul
Re: sql_server digest: June 19, 2002Ncolemaniii@a... 10 Jul
Re: Different results from SP in Analyser and from application<JoeHughes@M...>210 Jul
DTS: Execute SQL task and Send Mail task"David Bulog" <d2ba@x...>210 Jul
SecureID"Lonnie W Phillips" <lwphillips@n...> 10 Jul
Transact-SQL WHILE exists"Sam Lewitan" <sat@e...>308 Jul
scheduling web pages"Alex Bienz" <alex@v...> 08 Jul
DTS and AS400"greg robinson" <gregarobinson@h...>908 Jul
RE: A string as a parameter for sprocJulia Poddoubsky <jpoddoubsky@d...>210 Jul
Login Process"Lonnie W Phillips" <lwphillips@n...> 10 Jul
RE: ODBC Error"Low, Travis" <Tlow@S...>210 Jul
SV: converting a number to the corresponding character"Ali Karimi" <a97alika@s...> 11 Jul
DTS active X task problem with wshShell.Run command"David Bulog" <David.Bulog@t...>111 Jul
Re: SV: RE: converting a number to the corresponding cha ract er"itsethu" <itsethu@i...>111 Jul
RE: converting a number to the corresponding character"itsethu" <itsethu@i...>711 Jul
Re: Assigning incrementing numbers to a table ordered randomly"Ken Schaefer" <ken@a...>111 Jul
Re: sql 7 to 2000 upgrade question"Ken Schaefer" <ken@a...>111 Jul
Performance problems with SQL7 SP3"Sean Sowden" <sean_sowden@h...>111 Jul
RE: Import / Export SP's!!"Jeff Mason" <jeffm@u...>311 Jul
Re: SSL Security Error on SQL Server 2000"Wagner, Joan M" <joan.m.wagner@b...>511 Jul
Variable Concaternation"Joe Ingle" <joe@k...>111 Jul
Re: Linked server problem"TJ Sylvester" <tsylvester@d...> 11 Jul
Re: Duplicated record"Joe Ingle" <joe@k...>211 Jul
RE: How to include null records in an Inner Join"Jeff Mason" <jeffm@u...>511 Jul
Re: Syntax error converting the varchar value 'UPDATE [02230] SET cas e_number = ' to a column of data type int.Lionel.Nzenze@x...411 Jul
Re: linked server AS400 stored procs"greg robinson" <gregarobinson@h...>112 Jul
Understanding strange behavior"Christophe Tricaud" <ctricaud@l...> 12 Jul
Good book on learning SQL Server basicsdougwood@a...407 Jul
RE: Sending emails with MAPI!"Pete Davis" <pdavis@q...>712 Jul
Re: Primary File needs deleting"Nick McNair" <nick.mcnair@a...>112 Jul
Re: Generating Report from MSQL"Nick McNair" <nick.mcnair@a...>112 Jul
Exporting data into an Excel file.Karen Martin <kmartin@A...>112 Jul
Re: Help With Bulk Insert"Nick McNair" <nick.mcnair@a...>212 Jul
SQL Performance"Christophe Tricaud" <ctricaud@l...> 12 Jul
sql server 7 desktop edition=?iso-8859-1?q?chinna=20thirummorthy?= <cthirumoorthy@y...> 13 Jul
Problem with SQL Server Starting up :("Jose" <mask9000@h...> 13 Jul
Re: extreme slowdown on MSSQL 7 and 2000"Stuart Naylor" <indtec@e...>513 Jul
RE: How I can increase the row size of table of my database??"Aaron Fleming" <aaronf@w...>727 Jul
RE: Importing error of a boolean column"Ougnou, Abdel" <aougn99@h...> 02 Jul
Stored Proc Question"Sidney Fuerte" <fuertsj1104@y...>401 Jul
Dynamic "UPDATE" is not possible in trigger INSTEAD OF UPDATE?"Karel Kreizel" <karel.kreizel@v...> 01 Jul
Re: DBA CHECKLIST"Rajesh Mehta" <rajwrox@h...> 02 Jul
RE: DTS to update SQL Server from Access"Joe Ingle" <joe@k...>801 Jul
QUESTION"Karel Kreizel" <karel.kreizel@v...> 01 Jul
Re: Bulk InsertAllan Mitchell <AMMitchell@c...>903 Jul
Re: using IN statement in a stored proc."Jeff Mason" <jeffm@u...>703 Jul
RE: SQL PORTDavid Cameron <dcameron@i...>101 Jul
Re: Upsizing to SQL 2000 from Access 97David Cameron <dcameron@i...>201 Jul
RE: hstmt Error MessageDavid Cameron <dcameron@i...> 01 Jul
MSSQL & DatafilesRavindranath C <crn_group@y...>104 Jul
RE: Searching a file!"K.Ravi" <ravi@e...>304 Jul
RE: ANSI NULLS & ANSI WARNINGS and Stored Proceduresjacob@s...104 Jul
RE: IDENTITY VALUESVishal Gandhi <GandhiV@m...>504 Jul
RE: Dynamic SQL - Quotes have thrown meRichard Hadfield <Richard.Hadfield@t...>204 Jul
Which is completed 1st? a transaction or a trigger?"Wango Wango" <mitikavuma@h...>105 Jul
Invalid Instance"Andy Milkovic" <a.milkovic@e...> 05 Jul
SQ7 Backup"Peter Rooney" <peter@w...>105 Jul
Most urgentraj <raj@i...>206 Jul
RE: sluggish server"Peter Kaufman" <kaufman@l...>506 Jul
RE: Running SQL without a log file"Peter Kaufman" <kaufman@l...>106 Jul
RE: dts designer newbie question(create new text fil e with a header )"David Bulog" <d2ba@x...>306 Jul
XP stored proceduresRyan Smethurst <RyanS@p...>202 Jul
Application role"mozhdeh ahmadi" <mozhdeh_ah@y...> 09 Jul
Re: error messages"Ken Schaefer" <ken@a...>419 Jul
INSERT Using Join and NOT EXISTS??"Joe Ingle" <joe@k...>405 Jul
Re: Hopefully simple question!"Joe Ingle" <joe@k...>1411 Jul
SQL Server ans Active Directory"Joe Ingle" <joe@k...>125 Jul
Re: SQL2000 & Terminal Server"Nick McNair" <nick.mcnair@a...>109 Jul
Re: Saving output from stored proc ran as a job"Nick McNair" <nick.mcnair@a...>109 Jul
Re: Client EM vs Server EM"Darron Michael" <darron.michael@h...>218 Jul
RE: Create table remotelyREdwards@c...310 Jul
RE: SQL SERVER 7 Deleting unmatched records"D Grant" <headshred@y...>403 Jul