p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  View Archive  

Thread subjectAuthorRepliesDate
ON DELETE CASCADE NOT FOR REPLICATIONScott Watermasysk <swatermasysk@C...>230 Sep
Running total in stored procedure/query..."Jenifer Mundstock" <jenifer@s...>130 Sep
Performance oddity..."Iain Downs" <idowns@d...>529 Sep
How do you use parameter to determine flow-of-control"Kevin W" <mmuoneke@h...>329 Sep
Design Question + DTS code samples"Server Dave" <d2ba@x...>128 Sep
dtstrun problemGreg Partin <GPartin@c...> 28 Sep
Backing Up Database ...Guerrino Di Minno <GDiMinno@h...>128 Sep
Can I drop tables that previously participated in replicationThomas@m... 28 Sep
EMAIL TRIGGER"Pallone, Claudio [KMR-SPC]" <Claudio.Pallone@k...>228 Sep
Version's.70441.2227@c...328 Sep
Portability.70441.2227@c...228 Sep
transaction log full"E. Peter K. Chan" <heypeter@l...> 27 Sep
Re transaction log full"E. Peter K. Chan" <heypeter@l...> 27 Sep
Replacing Special Characters In A Text Field With A Spacerivey@v...627 Sep
Transaction problem"S. van Leeuwen" <s.van.leeuwen@k...>627 Sep
backups"Peter Kaufman" <kaufman@l...>427 Sep
Need help UrgentRita Bhatnagar <rita_63141@y...> 26 Sep
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'"Andrew Bagley" <andrew_bagley@e...>226 Sep
Strange Division Result"Michael Wong" <go2net@p...>526 Sep
concatination in SQL select statement"Zachary W. Barrett" <zwbarret@p...>426 Sep
spreadsheet output sql server 7.0chrota@h...226 Sep
Restore transaction log dumps"Lee, Al" <Al.Lee@F...> 26 Sep
change field type"Jusba Rocks" <jusbarocks@s...>126 Sep
Replication or similar"Antonello Corbo" <antonello65@i...>226 Sep
EM generated codeDavid Cameron <dcameron@i...>226 Sep
Re: DTS"Michael Summerville" <msummerville@o...>126 Sep
MDF move.Om John <milis@w...>125 Sep
Dts problems with SQL Server 7 and ActiveXscriptp.nzonlang@f...225 Sep
Cannot access a column within a 'TABLE' data type"Rebecca Poulose" <rebecca@n...>225 Sep
transactional replication error"Dennis Mayores" <dlmayores@i...> 25 Sep
DBO rightsRita Bhatnagar <rita_63141@y...>124 Sep
user-defined function like getdate()speedguru@m...224 Sep
script not working"Antonello Corbo" <antonello65@i...>324 Sep
Stored Procedure Selecting Data From Another Databaserivey@v...324 Sep
ANSI NULLS & ANSI WARNINGS and Stored Procedures"Faris Ahmed" <ffshamkhi@y...>124 Sep
How can we develop an OLAP application to transfer the data?irfan_yahaan@y... 24 Sep
need help optimizing database application perormance"Kevin W" <mmuoneke@h...>324 Sep
Restricting connection to an SQL Server 6.5 based on machines IP Address"Suresh Babu,D" <clarity@v...>123 Sep
Disabling toolbar buttons in SQL Server 6.5 Enterprise Manager for specific Login ID."Suresh Babu,D" <clarity@v...>123 Sep
Need help with search and replace string in table"Kevin W" <mmuoneke@h...> 23 Sep
Need help with search and replace"Kevin W" <mmuoneke@h...> 23 Sep
dtsrun problemsGreg Partin <GPartin@c...> 21 Sep
ANSI_NULLS & ANSI_WARNINGS"Faris Ahmed" <ffshamkhi@y...>721 Sep
problem in passing parameter to Store Procedure"pradeep niwate" <paradipn@h...>721 Sep
Numeric datetime value"Edward H K Ng" <EdwardHKNg@C...>221 Sep
Data and TimeHoang Than <hthan@r...> 20 Sep
Using bulk insert in stored procedure with filename as parameter"Arnold Angerer" <arnold@c...>120 Sep
Replication, how?a9603897@u...120 Sep
Sample DataOm John <milis@w...>120 Sep
Can I schedule backup of whole database annually without using replication?"Matt" <matt0655@s...>320 Sep
Help Needed ???Guerrino Di Minno <GDiMinno@h...>119 Sep
New to SQL - having several problems"Rick Kelley" <rick@p...> 19 Sep
How to clean transaction logs?"Jibu George" <jib_geo@y...>419 Sep
HELP - getting this message on all sql servers"Karen Jackson" <kjackson@f...> 19 Sep
New to SQL server"Frode" <fstroemm@o...>619 Sep
unable to activate sql server and windows authentification"kaab kaoutar" <kaab_k@h...> 19 Sep
Unexpected SQL errorMartyn8Bellamy@a...219 Sep
msg 18452 level 16 state1"kaab kaoutar" <kaab_k@h...> 19 Sep
OOT: why the data is double ?Om John <milis@w...>319 Sep
Problems with cursor output parameters.gidmanma@h...119 Sep
Quetion on logging ???Guerrino Di Minno <GDiMinno@h...>318 Sep
Re: Stored Procedure as a criteria"Mavin Specimen" <mspecimen@h...>118 Sep
How to write a store procedure to duplicate record?"sk_koh" <sk_koh@t...>118 Sep
Can you convert from char to real in T-SQL?"Kevin W" <mmuoneke@h...>418 Sep
blob imagekotzefj@m... 18 Sep
Standard or Enterprise EditionsIan Oates <Ian.Oates@U...> 18 Sep
Indentifier too longryagley@e...317 Sep
Enterprise Manager Freezing"Ryan Lockhart" <rlockhart@p...> 17 Sep
Question ?Guerrino Di Minno <GDiMinno@h...>417 Sep
Difference in values of a column in two rows"SM" <merajunk_merahai@y...>217 Sep
TSQL Debuggers"Huber, Mike" <MHuber@p...>117 Sep
problem with executeing Store procedure in Visual Basic"pradeep niwate" <paradipn@h...>117 Sep
problem in SQL SERVER 2000 Function"pradeep niwate" <paradipn@h...>217 Sep
problem in SQL SERVER 2000"pradeep niwate" <paradipn@h...>217 Sep
Can I schedule a replication after another replication end?"Matt" <matt0655@s...> 17 Sep
DateTime Problems"Hugh McLaughlin" <hugh@k...>416 Sep
Re: +AFs-sql+AF8-server+AF0- Sql Server +ACY- firewall"Mark Strangways" <strangconst@h...> 16 Sep
Where can I get Sql Server 7 Desktop edition?"Dodger" <grainscow@y...>616 Sep
Replication error: Cannot drop the table 'tableA' because it is published for replication."Matt" <matt0655@s...> 15 Sep
Sql Server & firewall"Rich Gilmour" <reesh@p...>215 Sep
create UNIQUE constraint using T-SQL"Raiju Mathew" <raijum@f...>114 Sep
Capturing @query from xp_readmail"Alastair Ramsay" <aramsay@h...> 14 Sep
SP TO DELETE"Pallone, Claudio [KMR-SPC]" <Claudio.Pallone@k...>514 Sep
Some Tables stops responding automatically"Premchand P.L" <premchandpl@p...>114 Sep
SQL Server User Roles"Armagan Ergon" <armagan@o...> 13 Sep
updating data using cursors"Andres" <Andres@v...> 13 Sep
Tables Locks w/ Multiple Text and Image fields"Austin, Jay" <jay@b...>213 Sep
Accessibility of user."Mike Yeap" <wkk1020@s...> 13 Sep
Re:default value"Darin Wray" <darin@r...>113 Sep
Hierarchical Generation of View Script"Solutions 2000" <sqlserver@s...> 13 Sep
Personalization and membership -- Restoration"madhu" <madhu_07@r...> 13 Sep
multiple deletes via joins"Andy L" <andy@v...>113 Sep
Encryption Fieldspaulo-fernando.gontijo@s...212 Sep
Sql Server agent wont start !!!!"Karen Jackson" <kjackson@f...>412 Sep
SQL in batch fileGreg Partin <GPartin@c...>412 Sep
this message is to repudiate the terrorism attack to the U.S.A"Beny Rey" <brey@i...>111 Sep
Clustered Index HelpGoEdge32@a...311 Sep
Transcation Log"Vikram Goyal" <vikram@s...>411 Sep
Restoring Databases manually"Alexander Bienz" <alex@v...>211 Sep
DTS doesn't work as a JOBpeter.clark@c... 11 Sep
SQL2000 -Which version for Windows NT4.0 workstation ? Im in a mess deciding!"Server Dave" <d2ba@x...>111 Sep
SQL Update questionmichael robertson <mike@m...>511 Sep
Alter a table being used for replicationjpoddoubsky@d...111 Sep
RE: An SQL 7 SELECT statement"Mavin Specimen" <mspecimen@h...> 10 Sep
TCP/IP for SQL 2000"Alex Farbman" <lelic2222@h...>110 Sep
Qry ProblemRita Bhatnagar <rita_63141@y...>110 Sep
updating a tableGreg Partin <GPartin@c...>210 Sep
How to set up a backup in SQL 2000"Yanira Castaneda" <ycastaneda@d...>310 Sep
Decimal PlacesRichard Hadfield <richyrich@t...>210 Sep
Enterprise ManagerIan Oates <Ian.Oates@U...>210 Sep
Simple question - restoring .BAK file"David Bosomworth" <david@s...>110 Sep
Connection to SQL Server is slow."Rebecca Poulose" <rebecca@n...> 10 Sep
query questionmichael robertson <mike@m...>209 Sep
Creating database backup dump in SQL 6.5"Suresh Babu,D" <clarity@v...> 09 Sep
Linking Daily and Weekly Jobs?alexander.facklis@a...108 Sep
Failed Remote SQL Server 7.0 Connection behind MS Proxy Server 2.0"Zig Wiedemann" <admin@h...> 07 Sep
Updating Records"pong-TC" <pong@t...>207 Sep
What is Unicode and Non-Unicode data types?"Armagan Ergon" <armagan@o...>107 Sep
Troubleshooting SQL Shutdown from backup"Timothy Case" <tcase@p...> 07 Sep
Upgrade problem"Wanschek, John J" <jjwansch@i...> 07 Sep
Secure data transfer methodtod_jebe@i... 07 Sep
connecting server"sumi" <rsumathy@e...>407 Sep
Dts - Execute SQL Task- Using parameters"Dafna Levy" <dafnal@m...> 07 Sep
Compare SQL 2000 Databases"Faris Ahmed" <ffshamkhi@y...>307 Sep
Recieving XML from Stored ProcedureBukovansky@a...107 Sep
How to restore from a physical DB dump to disk?"Denmark Weatherburne" <denmark_weatherburne@h...> 06 Sep
Re: Pro SQL server 2000 DTS Prog Custom Error handler Problem"Marc Thibodeau" <marc.thibodeau@r...>206 Sep
SQL and DTS"Pierre NZONLANG" <p.nzonlang@f...>106 Sep
Re: Sql2K License for web app?"Hoang Than" <hthan@r...>106 Sep
memo field in access"taherm@f...106 Sep
trigger problem"Raiju Mathew" <raijum@f...>206 Sep
How to set the default value for a column"Pradhan, Biswajit" <biswajit.pradhan@d...>406 Sep
Remote Access to SQL Serverinfo@e...106 Sep
protocol problem connecting SQL2000"Kong Ming Siem" <mskong@t...> 05 Sep
DTS and ASP package execution errorVYoung@s... 05 Sep
Referential integrity - cascade delete records"David Bosomworth" <david@s...>305 Sep
DTS and Execute Package Task"Monique Smith" <msmith@a...> 05 Sep
MSDTC on SQL 7 errors"Phred Gertch" <phred@q...> 05 Sep
cant access my sql server"Taher Moiyed" <taherm@f...>105 Sep
SQL Book"Mark Irvine" <markpirvine@b...>605 Sep
Add integer number of days to a date"David Bosomworth" <david@s...>105 Sep
SQL Server Yielding Controlrnedel@b... 05 Sep
Converting dates to simple 'yyyy-mm-dd' format"Tom Kelleher" <kelleher@t...>505 Sep
RE: [sql_server]Personal Version Of SQL server 7<wburrough67@y...>104 Sep
Scripting all rows of a table into equivalent sql Insert statemen- ts"Arif Khan (GWL)" <Arif.Khan@W...>204 Sep
Stopping Execution"Solutions 2000" <sqlserver@s...> 04 Sep
Updating DTS Package (SQL server7.0) connection Via Visual Basic"Dafna Levy" <dafnal@m...> 04 Sep
Personal Version Of SQL server 7"Mike Kerr" <MIKEZCG@Y...>404 Sep
Lifetime of a transaction?Steve Carter <Steve.Carter@t...>204 Sep
SQL Question"Balajewicz, Greg" <Greg.Balajewicz@A...> 04 Sep
Locking problems"Mark Powell" <mpowell@a...>404 Sep
Re: sql_server digest: September 03, 2001"Geoff Higgins" <Geoff@v...> 04 Sep
How do I get data out of an image data type?ben@s...204 Sep
Re: Newbie DBA question"Darin Strait" <dstrait@e...> 03 Sep
Re: Using Query Analyser to view/Edit Stored Procedures"Tony Healey" <THealey@Q...>103 Sep
Stored Procedure from ADO takes a long timerebecca@n...203 Sep
Executing Stored Procedures using ADO is slow!."Rebecca Poulose" <rebecca@n...>203 Sep
Re: SQL Query"Mark Irvine" <markpirvine@b...>303 Sep
Accessing data Across Server"Pradhan, Biswajit" <biswajit.pradhan@d...>403 Sep
Progress port to SQL2000 via DTS Wizardhodger@p... 02 Sep
Re: database size"Ming Kong" <freeware@t...>201 Sep
Re: Trigger to select updated records only"R Allen" <allenr@m...> 01 Sep
Re: alter column fails because of statistics"Thomas McDonald" <tomandlis@h...> 01 Sep
how do I pass parameters to a view"David Bosomworth" <david@s...>201 Sep
Re: Truncate SQL Log files"Ming Kong" <freeware@t...> 01 Sep
RE: Objects inside Stored ProcedureKrishna Roopa <roopa@t...>101 Sep
Message 446 executing a queryJaime_Perez@u... 01 Sep