p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  View Archive  

Thread subjectAuthorRepliesDate
Trigger, sp_who, spid"Jerry Diegel" <jerryd@h...>231 Jul
Re: About error handling on DTS on SQL server 2000bindur@h... 31 Jul
trigger message when the time expiredmarcelo_velasque@h... 31 Jul
Disabled triggersJeff King <JKing@W...> 31 Jul
ON DELETE CASCADE NOT FOR REPLICATIONScott Watermasysk <swatermasysk@C...>131 Jul
Snapshot Replication Error"Arif Khan (GWL)" <Arif.Khan@W...> 31 Jul
Re: Login failed in Netscape"Kien Vinh Duong" <kienvinh.duong@u...>830 Jul
Variable declarations : syntax question"Aaron Fanetti" <AFanetti@C...> 30 Jul
HELP - Login failed in Netscape"Kien Vinh Duong" <kienvinh.duong@u...>230 Jul
SQL Server 7 questionJonGrman21@a...129 Jul
How to determine if column is an IDENTITY?"Aaron Fanetti" <AFanetti@C...>129 Jul
System table for key columns?"Aaron Fanetti" <AFanetti@C...>228 Jul
Create database name dynamically"J House" <jesse@s...>228 Jul
Sharing data between 2 databases"Jason Grunstra" <jason@r...>127 Jul
My problem!!"Saumya Bhardwaj" <sayuluvmeagain@h...> 27 Jul
Run SQL without Server?Greg Partin <GPartin@c...>527 Jul
RES: Database Documentation ToolJuliano Moraes Rodrigues <JRodrigues@s...> 27 Jul
Database Documentation Tool"Faris Ahmed" <ffshamkhi@y...>227 Jul
HELP - transfering information"Kien Vinh Duong" <kienvinh.duong@u...>127 Jul
DTS: Multiphase data pumpJGriffith@M... 27 Jul
Photo in SQL_Server"Saumya Bhardwaj" <sayuluvmeagain@h...>726 Jul
Data Link Error - Please help!"Michael Simmons" <msimmons@u...>226 Jul
MS SQL SERVER 2000 - Stored Procedure ERROR on asp ODBC Request"GaBeS" <GaBeS@g...>926 Jul
DTS VS MTS?"Frank basti" <butabi_916@y...>326 Jul
Help! Upsizing wizard Access 2000 > SQL 2000"Kien Vinh Duong" <kienvinh.duong@u...>125 Jul
column data formatGreg Partin <GPartin@c...>625 Jul
DTS Import Wizard and Triggers"Jeff Coon" <osujeff@h...> 25 Jul
executing from trigger"Khalid Hussain" <khalid@p...> 25 Jul
column numbering"kevin" <kevin@f...>125 Jul
How can I import data from MsAccess to Sqlserver??bikashpaul_2001@y...625 Jul
Arrays in SQL Strd ProcKushal Kaleshwari <kushalkaleshwari@c...>825 Jul
OLAP Cube in a Job"Banu" <banuweb@h...>125 Jul
How can I create Blob or Clob column in sqlserver7.0 for storing xml data??bikashpaul_2001@y...125 Jul
SQL backup fileGreg Partin <GPartin@c...>325 Jul
Cache Hit Ratio"Xu Gary" <Gary.Xu@p...>125 Jul
timeout expired"Mike Makarowski" <makarows@h...>124 Jul
ATTACHING DATABASESjmartin@r...124 Jul
Web Task Backup"Gary Justus" <gary.c.justus@s...> 24 Jul
Beginning E-commerce by: Matthew Reynolds"Rick Brugger" <jzzvibes@h...> 24 Jul
Date configuration in SQL Server 7.0rik@w... 24 Jul
MSDE 2000 Installation failure..."Ged Read" <ged.read@i...> 24 Jul
Alternative for functions"Payal Jain" <payal_jain@h...>424 Jul
Any harm running DBCC DBREINDEX?"Hendra" <hendra@i...> 24 Jul
Attachments???"Yehuda Rosenblum" <Yehuda@I...>723 Jul
Stored procedure!"Butramenko, Angelika" <abutramenko@b...>523 Jul
an insert with an unknown identityGreg Partin <GPartin@c...>323 Jul
SQL-Server login with ASP"Brian McElhany" <bmcelhany@h...>623 Jul
SQL Mail !"Butramenko, Angelika" <abutramenko@b...>423 Jul
Database Backups"Kyle West" <west1kl@m...> 23 Jul
large text field as OUTPUT parameter?"Kamran" <user_15@h...> 23 Jul
Help!"Butramenko, Angelika" <abutramenko@b...>223 Jul
Expired record!"Butramenko, Angelika" <abutramenko@b...> 23 Jul
MVS to SQL Server Accesspgreiner@h...123 Jul
DTS Stopped Working"Hugh McLaughlin" <hugh@k...>322 Jul
multi tierRita Bhatnagar <rita_63141@y...> 20 Jul
DTS Package when actived by Job Scheduler"Mark A. Laughlin" <mlaughlin@e...>620 Jul
Changing SQL codepage/sort order..."Mauricio Guimaraes" <mandrade@o...> 20 Jul
Copy Database Wizard Connection Timeout Problem"Yenchiun Kuo" <symposium@k...>420 Jul
Trigger question - Round 2"Seth Watt" <swatt@t...>519 Jul
Generate a non-sequential GUID for a uniqueidentifier columnflegare@s...719 Jul
RE: input variableBernard Yung <BYung@h...> 19 Jul
Problem with delete cascade trigger in self-reference table"Tamas Ruff" <tamas_ruff@h...>119 Jul
Please help mebikashpaul_2001@y...119 Jul
How to store Http url and Ftp url in databasebikashpaul_2001@y...319 Jul
Re: Need Help With SQL Server Enterprise Manager"Steve Bettey" <steve.bettey@b...> 19 Jul
Sharing SQL ServerOm John <milis@w...>119 Jul
DTS Export to Excel spreadsheetpeter.clark@c...119 Jul
Different languages"Robert Martin" <rlmartin67@h...>219 Jul
Trigger question"Seth Watt" <swatt@t...>319 Jul
How to store a file(.xml or .doc) in columns of tablebikashpaul_2001@y...119 Jul
SQL Server and Proxy"JIB_GEO" <jib_geo@y...>119 Jul
SQL Server Memory Leakage through ACCESS ODBC Connections"Kelly McMillin" <kmcmilli@h...>318 Jul
sp_fulltext_catalog"Luis Perez" <lperez@t...>118 Jul
Local DTS Package Not Found - MS SQL 7<sean?robert?fitzgerald@y...> 18 Jul
Event Viewer Error Message"Hobbs, Jeff" <Jeff.Hobbs@c...> 18 Jul
Inserting files into fieldsharinders@i...218 Jul
Collation Settings.. any idea"rajeev" <rajeev_venkatraman@s...>118 Jul
Alter table"rajeev" <rajeev_venkatraman@s...> 18 Jul
Not In Sub Queries"Stuart Naylor" <indtec@e...>218 Jul
make one of the conditions result of stored procedure"Mavin Specimen" <mspecimen@h...>118 Jul
Linked Serversjgee@e... 18 Jul
How do I execute a sproc for each index in a select statement?"David Taylor" <Dptaylor25@b...> 18 Jul
Can I use something else then Intersect?a9603897@u... 18 Jul
ADP problem referencing views and stored proc"Peter Kaufman" <kaufman@l...> 18 Jul
Access Data Project temp table problem"Peter Kaufman" <kaufman@l...> 18 Jul
EXEC(@vchCommand) and return variables"Faris Ahmed" <ffshamkhi@y...>318 Jul
SP3 considerations"Parasu Raman" <parasu78@y...> 18 Jul
Search problem bet PB6 and SQL 2000<Grace.Ajunan@q...>318 Jul
script"Greg Partin" <greg@c...>317 Jul
DTS-global variables - SQL SERVER 7.0"Dafna Levy" <dafnal@m...>217 Jul
Table name as a variable in DELETE, UPDATE and SELECT"Faris Ahmed" <ffshamkhi@y...>117 Jul
Backup Process QuestionJoey Brenn <jbrenn@f...>117 Jul
multi threading in SQL stored procedure or from application"vikalp Mohan" <alp_waj@y...> 17 Jul
Loading data from Access 97 to SQL 2K"Johnson, Shawn" <Shawn.Johnson@K...> 17 Jul
Clustered or Nonclustered?QinW@n... 16 Jul
foreign key deletion"Greg Partin" <greg@c...>216 Jul
What are the DB protections to allow user to see tables in EM?"Roger Gillim" <rgillim@v...>116 Jul
Log File full"Mavin Specimen" <mspecimen@h...> 14 Jul
Re: SQL 2000"Mavin Specimen" <mspecimen@h...> 14 Jul
DTS designer error - invalid class string"Harry Smith" <harry.smith@b...> 13 Jul
Checking network connection to linked server"Hendra" <hendra@i...> 13 Jul
How could we calculate Search Relevance?himanj@i...113 Jul
Is there something wrong with this Stored Procedure?"Andre Berkowitz" <obsessed@a...>213 Jul
Home and Away!"Andy L" <andy@v...>813 Jul
convert varchar to int?"Sukhi Samra" <sukhdeepsamra@h...>113 Jul
Stored Procedure (SQL 7)bgmst5@y...412 Jul
SQL Server does not exist"MarianoG" <gagliarm@f...>512 Jul
Remote Connections and ProxyMSpruill <mspruill@m...>312 Jul
Re: DTS"R. Michael Lacy" <mike.lacy@c...> 12 Jul
Query Designer problem"Parasu Raman" <parasu78@y...> 12 Jul
Single Join or multiple selects - which is better?"Saul Kripke" <saulkripke@h...>112 Jul
One table or many, with frequent Nulls?"Tom Kelleher" <kelleher@t...>212 Jul
Complicated ORDER BY clauseDavid Cameron <dcameron@i...>412 Jul
Need help with FOR XML EXPLICIT queriesjohn.b.bonifas@b... 11 Jul
How to delete just one of the colum data?"Sukhi Samra" <sukhdeepsamra@h...>611 Jul
Optional parameters"Alan Grobert" <alangrobert@h...>311 Jul
Views & UDFs"David R. Olson" <david.olson@u...> 11 Jul
How do i create index on a view with 2000"Arif Khan (GWL)" <GWLAIK@w...>211 Jul
Purging data"Steve" <scalhoun@s...>111 Jul
Query lag on Server"Giedrius" <fozis@c...> 11 Jul
Input date format for a DTS packagephilw@l... 11 Jul
Urgent - Communications link failure"Alastair Ramsay" <aramsay@h...> 11 Jul
Distributed querys doesn't work on JOBsPedro Andrade <pandrade@n...>211 Jul
Is it possible to backup database from SQL directly to Cd Rom?"Andre" <andrekl@m...>311 Jul
Time out on stored procedure when run through ADODB connoz@o...411 Jul
Query Analyzer"JIB_GEO" <jib_geo@y...> 11 Jul
Fault-tolerant DTS processesrmurnick@f... 10 Jul
Creating database columns with an SPROC"Andre Berkowitz" <obsessed@a...>210 Jul
Managing SQL Server Desktop Engine Remotely"Iain Downs" <idowns@d...>410 Jul
Full text Searchhimanj@i... 10 Jul
Searching the text file from Sql server"J" <j_natarajan@h...>110 Jul
TempDb is full"Premchand P.L" <premchandpl@p...>110 Jul
copy tables from different database/server in T-sql"ann win" <awin@a...>110 Jul
table conversionRaiford Allen <allenr@m...>110 Jul
MasterKyle Burns <kburns@c...> 09 Jul
SP Cursor problemTejo_Nemalikanti <Tejo_Nemalikanti@s...> 09 Jul
help with DTS & global variablesJdonoghue@s...309 Jul
[access] An access table to a SQL one.Empier4552@a... 07 Jul
'Invalid Object Name - Registration Problem' --Please Help"Michael Kent Simmons" <msimmons@u...> 07 Jul
looping over dts task"Daniel Morphett" <danmorph@z...> 07 Jul
Service Pack 3 MS SQL Server 7roxtsl@y...107 Jul
Partitioned Views and a Clustered Index"Brad Anderson" <bsa@s...> 07 Jul
Help for insert statement!"Butramenko, Angelika" <abutramenko@b...>106 Jul
Re: Access Query/SQL Stored Procedure"Mavin Specimen" <mspecimen@h...>306 Jul
Job Failed StatusJoey Brenn <jbrenn@f...>306 Jul
stored procedures"Paul Broomfield" <paul.broomfield@t...>206 Jul
SQLMail with out MS ExchangeTejo_Nemalikanti <Tejo_Nemalikanti@s...>106 Jul
How store xml file in sqlserver7.0bikashpaul_2001@y...106 Jul
RE: INSERT EXEC statement cannot be nestedtomandlis@h... 06 Jul
How to use Windows authentication as query to retrieving data"Tony Lam" <lamyuho@h...>105 Jul
getting started - database dummy question"Michael Robertson" <mike@m...>105 Jul
Images in SQL Server 2000 (Urgent)"Naveen" <bobbyhj@h...>105 Jul
return value not recordset"Neethling, Dirk HT/DE/ESS" <Dirk.Neethling@h...>105 Jul
AW: RE: AW: Re: using sp parameters for column & tab- le n ame"Neethling, Dirk HT/DE/ESS" <Dirk.Neethling@h...> 05 Jul
AW: Re: using sp parameters for column & table name"Neethling, Dirk HT/DE/ESS" <Dirk.Neethling@h...>205 Jul
Moving a DTS Package"David Jarmoluk" <djarmoluk@y...>205 Jul
T-SQLbgmst5@y...805 Jul
Hints"Steve" <scalhoun@s...> 05 Jul
Pro SQL server 2000 DTS Prog---- Custom Error handler Problem"Jack Sorros" <sorros@c...>105 Jul
Importing datefields from textfile into sqltablea9603897@u...105 Jul
AW: Deleting Rows"Neethling, Dirk HT/DE/ESS" <Dirk.Neethling@h...>105 Jul
using sp parameters for column & table name"Neethling, Dirk HT/DE/ESS" <Dirk.Neethling@h...>405 Jul
Deleting Rows"Steve" <scalhoun@s...>205 Jul
Top Urgent Help Needed Regarding Attaching Database"Michael Wong" <go2net@p...>104 Jul
RE: I have a question regarding parameter's???raymondmurphy@c... 04 Jul
Which users have which records"Michael B. Deck" <mdassignment@h...> 03 Jul
SQL 7 Stored Proceduresbgmst5@y...203 Jul
Using SQL Server 2000 client tools against SQL Server 7 engine"Chris Ogilvie" <cogilvie@r...>103 Jul
Record Paging for ASP pages"Manuj Aggarwal" <manuj@h...>303 Jul
2000 vs. SQL 7"Greg Partin" <greg@c...>102 Jul
Re: Difficulty in connecting to Sql serverjmarks@l...102 Jul
Need Suggested SQL 2000 Adv Server Best Practice Backupjmarks@l...202 Jul
Returning StoredProc Error values to DTSchristopher.lepingwell@g...102 Jul
RES: How to add new primary key=?iso-8859-1?Q?Maur=EDcio_Guimar=E3es?= <mandrade@o...>102 Jul
Using UTC DateTimes"Aaron Fanetti" <AFanetti@C...> 02 Jul
I want to know about SQL Server's Capacityhimanj@i... 02 Jul
RE: Create function was RE: (No Subject)"rami sader" <sabbra@l...> 01 Jul
How to add new primary key"Premchand P.L" <premchandpl@p...> 01 Jul
SQL Server connection (network) problem"Sam Gordon" <timofey@e...>201 Jul
problem with primary key"Premchand P.L" <premchandpl@p...>101 Jul
RE: inexplicable 80040e14 errorDavid Cameron <dcameron@i...> 01 Jul