p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  View Archive  

Thread subjectAuthorRepliesDate
Sql2K License for web app?"Saul Kripke" <saulkripke@h...> 31 Aug
Trigger to select updated records onlyallenr@m... 31 Aug
Truncate table and change data for clientRita Bhatnagar <rita_63141@y...> 31 Aug
alter column fails because of statistics"Thomas McDonald" <tomandlis@h...> 31 Aug
database size"Jake C" <jakeone@b...> 31 Aug
Objects inside Stored Proceduremarcelo_velasque@h...331 Aug
Mirroring of two sites in different networks"Marco van Schaijk" <marco.vanSchaijk@e...> 31 Aug
AW: Compressing the Datetime fieldJosef.Koenigseder@g...131 Aug
Compressing the Datetime field"pong-TC" <pong@t...>330 Aug
Can't be used with other statements in the same batch? What?Steve Carter <Steve.Carter@t...> 30 Aug
AW: Re: Using Query Analyser to view/Edit Stored Pro- ceduresJosef.Koenigseder@g... 30 Aug
Using Query Analyser to view/Edit Stored Procedures"Alexander Bienz" <alex@v...>730 Aug
how to do "minus" in SQL Server"Tim Zhang" <tzhang@h...>329 Aug
Universal Data Model on SS2K Enterprise"Dave House" <chunga_@h...> 29 Aug
Re: Get a stored procedure to return a recordset"Enoch Chum" <chum.enoch@s...>229 Aug
Running the same database twice under a different name"Alexander Bienz" <alex@v...> 29 Aug
getting started - SQL 2000 Dev versionmichael robertson <mike@m...>529 Aug
RE: [sql_server]Memory Usage"Premchand P.L" <premchandpl@p...>129 Aug
SQL 2000, blobs and fileskotzefj@m... 29 Aug
Transfer Trigger to another Table"Nathanael Budianto Wiradi" <budianto@m...> 29 Aug
New transaction cannot enlist in the specified transaction- coordinator."Ming Siem Kong" <freeware@t...> 29 Aug
Re: Renaming database"Mavin Specimen" <mspecimen@h...>128 Aug
Turning off encryption"dirk neethling" <dirk.neethling@h...> 28 Aug
Visual SQL 7 Benchmarking"Adam Sitnick" <asitnick@i...> 28 Aug
Problem with sql server agent/ sql mail"Arif Khan (GWL)" <Arif.Khan@W...> 28 Aug
Truncate SQL Log files"Chris Hetrick" <Chetrick@H...>128 Aug
Re:Transaction Log"Mavin Specimen" <mspecimen@h...> 28 Aug
UDF at SQL2000Bukovansky@a... 28 Aug
AW: RE: Locking of RowsJosef.Koenigseder@g...128 Aug
Locking of Rowsjosef.koenigseder@g...128 Aug
Editing UDF with VID 6.0Bukovansky@a... 28 Aug
trouble truncatingGreg Partin <GPartin@c...>127 Aug
SQL Documentor Tool?"Larry Guayante" <larryg@p...> 27 Aug
SQL Update from a cdGreg Partin <GPartin@c...>527 Aug
Re: Log File"Mavin Specimen" <mspecimen@h...>127 Aug
ODBC Drivers"Steve Hindle" <Hindle@c...> 27 Aug
SQL Setup for two languagesJithesh Kumar <jithu_kumar@y...> 27 Aug
AW: Sorting SPROC results with a variable?Josef.Koenigseder@g...127 Aug
xml - adosp2000@h... 26 Aug
Sorting SPROC results with a variable?"Wolf Loescher" <wolf_loescher@c...>324 Aug
DTS package not running"Bhagwant" <bhagwant@i...>124 Aug
What's wrong with this stored procedure?"Andre Berkowitz" <obsessed@a...>324 Aug
Convert database"Baran, Greg" <gbara@a...>223 Aug
Newbie DBA questionSteve Carter <Steve.Carter@t...>223 Aug
Geting a complete row in a cursorjosef.koenigseder@g... 23 Aug
Front-end input tool for SQL Server 6.5Mark Eckeard <meckeard2000@y...>223 Aug
One To Many Relationship"Andrew Cooper" <aecooper@i...>223 Aug
ERROR no: 8651"Dheeraj Sharma" <Dheeraj.Sharma@p...> 23 Aug
Bulk Insert and Error Trapping"Jim Youmans" <jdyoumans@y...> 22 Aug
SQL Server2000 XML/XSL problemvisual_ben@h... 22 Aug
Software to BACKUP an open database? WHERE TO FIND????<rcristel@y...>1422 Aug
Visual SourceSafe<wburrough67@y...>222 Aug
Transfer databaseDavid Cameron <dcameron@i...>322 Aug
ODBC Drivers on Linux for conecting to MS SQL Server"Bad Ghost" <badghost@q...>121 Aug
performs action on different databases"Thomas McDonald" <tomandlis@h...> 21 Aug
Running .SQL Scripts using DMO"Solutions 2000" <provb@s...> 21 Aug
record count of each of all the user-tablesspeedguru@m...221 Aug
stored proc help required"Taher Moiyed" <taherm@f...>221 Aug
Update()"Alex Farbman" <lelic2222@h...>120 Aug
Rookie Stored Proc question.Steve Carter <Steve.Carter@t...>420 Aug
Typical Stored procdure problem.."Priyadarshini" <vnimesh@y...>420 Aug
Something that replace the 'first' function in access to SQL"Isar Shacham" <sisars@t...>120 Aug
Simple SQL-DMO Question"bill salkin" <wsalkin@h...> 20 Aug
Complex import problems with DTS"Oliver Stanke" <oliver.stanke@o...> 20 Aug
Regional settings independ datetime format in string variableBukovansky@a...320 Aug
SQL server fails to insert more than 256 chars into a TEXT field"Adam Metcalfe" <Adam.Metcalfe@c...>620 Aug
Log Shipping question"Peter Kaufman" <kaufman@l...> 18 Aug
Script to export tables data into text file based on table name"Igor Zorovik" <igor_sql2000@h...>117 Aug
Help! How do I use Count(*) in this stored procedure?"Andre Berkowitz" <obsessed@a...>117 Aug
Accessing database using Microsoft Remote Access Service"MOHANDAS AK" <mohandak@h...> 17 Aug
Copying sorted data"Alexander Bienz" <alex@v...>617 Aug
Connect to a remote SQL installation"Nick" <nikosdra@l...>117 Aug
Copy Logins to new server=?iso-8859-1?Q?Norbert_Mei=DF?= <Norbert.Meiss@I...>217 Aug
Re: Copying databases"Jeyakumar" <jeyakumar@h...> 17 Aug
what's the difference..."Anda" <gipanuhot@y...>217 Aug
DTS scheduling error"Karen Jackson" <kjackson@f...> 17 Aug
automation of stored procedures"Alexander Bienz" <alex@v...>117 Aug
DTS- load different dBase files dynamically?"Martin Pease" <funkyaintit@h...> 16 Aug
Commas in fieldsdparkins@m...216 Aug
DTS Send Mail problemalexander.facklis@a...216 Aug
Access Data Project to remote hosted SQL Server"Andrew Bagley" <andrew_bagley@e...>116 Aug
Full Text IndexingKrishna Roopa <roopa@t...> 16 Aug
Is It Legal ? Franchise ProgramOm John <milis@w...>116 Aug
How to construct a connection string with server in a different domain?"Dragan Juric" <dragan.juric@q...>215 Aug
Select Count Query"Richard Graves" <richgraves@m...>215 Aug
SQL Server on remote server"Dennis" <dgertgen@n...> 15 Aug
I need to call a view from a stored procedure or the opposite"Isar Shacham" <sisars@t...>115 Aug
Modify Tables StructureRita Bhatnagar <rita_63141@y...>415 Aug
Does MSDE support SQL Server 2000?Clifton Dunaway <csdunaway@y...>215 Aug
using sp_rename to rename tabel with specific tabel name"Nathanael Budianto Wiradi" <budianto@m...>115 Aug
how to add one column which is not null using DTS WizardZili Liu <liu@Q...>115 Aug
English Query with SQL Server 7.0 / 2000jtaylor@w... 15 Aug
Connect without sending cleartext password?"Tom Kelleher" <kelleher@t...>415 Aug
Database Replication"Glenn Brown" <glenn@r...> 15 Aug
Authentication Problem"philippe.fleur" <philippe.fleur@l...> 15 Aug
Transaction Log Backup Failing"Tony" <one_dev@h...> 14 Aug
Transactional Replication with Queue failover"Ryan A. Rinaldi" <rrinaldi@m...> 14 Aug
Help migrating from SQL Server 6.5 to 7.0"Denmark Weatherburne" <denmark_weatherburne@h...> 14 Aug
Can I distribute an .mdf file that is read only?"MAJ Pat Flanders" <flanders@m...>314 Aug
Migrating SQL Server 2000 to MySQL"ben david bennett" <bbennett@s...>214 Aug
Update a view throw a recordset?"Carlos Ramos Estrada" <carestra@e...> 14 Aug
BCP"Steve Read" <steve@r...>114 Aug
table permissions question (newbie)"Peter Kaufman" <kaufman@l...>414 Aug
a newbie dts package problem"Taher Moiyed" <taherm@f...>314 Aug
tempdb log file full"Thomas McDonald" <tomandlis@h...>513 Aug
Error Starting SQLServerAgent"Austin, Jay" <jay@b...>113 Aug
Table size"Giedrius" <fozis@c...> 13 Aug
Unable to configure my server to send mails thru SQL server"panchdev sharma" <panchdev@r...> 13 Aug
graphic names in databaseGreg Partin <GPartin@c...>211 Aug
Transaction Log ProblemTony Blaze <tonyb@a...> 11 Aug
retrieving DTSLookups result rows"victor anaya" <vicanfon@h...> 10 Aug
Re: sql_server digest: August 09, 2001Martin_Troyer@i... 10 Aug
Database Backup Problem"toto" <yanto@j...>210 Aug
SQL Server improvement"Mahesh G Patil" <maheshgp@b...> 10 Aug
transactional replication error"dhenz" <dhenz@i...>110 Aug
Columns defined as varchar(0)"Stephen Allen" <Stephen.Allen@S...> 10 Aug
insert just time on datetime type fielddparkins@m...509 Aug
VB Errorbawa hsu <hummingbird147@e...>109 Aug
Not yet a production Backup problem..."bill salkin" <wsalkin@h...> 09 Aug
Is this possible???"enz@u...209 Aug
Having Access as a Subsciber to SQL Server"Ryan Lockhart" <rlockhart@p...>1109 Aug
connecting to server failed during install"anthony della rosa" <anthony.dellarosa3@v...>109 Aug
Database question???Guerrino Di Minno <GDiMinno@h...>209 Aug
Replication of Data through Remote Db Servers"Muhammad Usman" <usman_mann@y...>109 Aug
Trying to pass value to sort results in a stored procedure"Wolf Loescher" <wolf_loescher@c...> 09 Aug
How to automatic creating Tables Once every month"Nathanael Budianto Wiradi" <budianto@m...>109 Aug
ALTERING TABLE"Paul" <pong@t...>1309 Aug
Deciphering "Database Maintenance Plan""bill salkin" <wsalkin@h...> 09 Aug
Getting random results in SQL"Andre Berkowitz" <obsessed@a...>109 Aug
An instance of a stored procedureMSpruill <mspruill@m...>308 Aug
Reducing the # of DPC's while running a SP"Nicholas Floyd" <cutter-@r...> 08 Aug
Re: Trigger question"Ronald Bastien" <rbastien@s...> 08 Aug
SQL Server, SMTP and CDONTS ...connection with out IIS..is it pos- sible!Tejo_Nemalikanti <Tejo_Nemalikanti@s...>408 Aug
SQL Server DTS package fails when scheduled as job"Bob Press" <rpress@e...>508 Aug
SQL Server Service Manager"zili liu" <liu@q...> 08 Aug
SQL 2000, InterDev with SP5 ASP's"Yanira Castaneda" <ycastaneda@d...> 08 Aug
Trigger"Antonello Corbo" <antonello65@i...>208 Aug
Help on query"Igor Zorovik" <igor_sql2000@h...> 08 Aug
SQL Server 2000 installation question"Igor Zorovik" <igor_sql2000@h...>308 Aug
Too many databases on a single server?"Michael Morisoli" <Michael@M...>508 Aug
Return Recordset From An Embedded EXEC Statement"Pat and Kelley Flanders" <flanders@m...>308 Aug
How to update database on client serverRita Bhatnagar <rita_63141@y...>308 Aug
Full Text Search Best Practices"Larry Guayante" <larryg@p...> 08 Aug
DTS and SQL Server 7.0"Keith S. Safford" <keith.safford@e...>107 Aug
NAS and Replication"Arif Khan (GWL)" <Arif.Khan@W...> 07 Aug
Decode or Switch or If for SQL Server 2000"John" <jdowell@c...>207 Aug
error in trigger"vikram" <vikram@s...>207 Aug
Data Transformation Services"Jason Martin" <jmartin@r...>107 Aug
How to create a primary key that increments by 1"Yanira Castaneda" <ycastaneda@d...>507 Aug
SQL DB Documentation"Faris Ahmed" <ffshamkhi@y...>107 Aug
SQL Guru?Richard Hadfield <richyrich@t...>107 Aug
Error message when connecting to SQL Server...Guerrino Di Minno <GDiMinno@h...>207 Aug
How to copy one table from one DB to another?"Giedrius" <fozis@c...>107 Aug
Re: sql_server digest: August 06, 2001geoff@v... 07 Aug
Load testing SQL"ian" <ian@i...> 07 Aug
dsnbawa hsu <hummingbird147@e...> 07 Aug
bulk insert and fixed width file"Thomas McDonald" <tomandlis@h...>406 Aug
UDF and linked Server"Ingo Bogemann" <ingo.bogemann@s...> 06 Aug
Changing Username"pong-TC" <pong@t...>106 Aug
Moving Sql Server"Ryan Lockhart" <rlockhart@p...>206 Aug
SQL query"Brandy" <bbb@e...>506 Aug
multi log database<asangary@y...>206 Aug
re:Installin SQL SERVER 2000"Dafna Levy" <dafnal@m...> 05 Aug
How to get a list of table names & number of records in each- table in a Database?QinW@n...203 Aug
hard drive spacedparkins@m...103 Aug
doubt in sql server (.BAK file)Rajani Makkapati <makk_rajani@y...>203 Aug
SQL Server Error"ian" <ian@d...>403 Aug
Testing for existance of a temporary tablegeo@n...103 Aug
Where Clause"arthurmaloney" <arthurmaloney@z...>103 Aug
Create a cursor using a stored proc<wburrough67@y...>103 Aug
Cascading a create from writing to a view?Steve Carter <Steve.Carter@t...>103 Aug
How I can store image in column of database???bikashpaul_2001@y...203 Aug
Import data from text file"pong-TC" <pong@t...>102 Aug
Determining previous step in Custom Taskalexander.facklis@a... 02 Aug
how to copy a table structure to another database"Tim Zhang" <tzhang@h...>402 Aug
openxml asp helpjerry.halasz@s... 02 Aug
Re: Using EXEC with table variable vs. temp tablegeo@n...202 Aug
Copy Table"Paul" <pong@t...>402 Aug
DTS ADO ERRORElmer Donavan <Elmer.Donavan@u...> 02 Aug
COM dll in stored procedures"D. Mayores" <dhenz@i...>202 Aug
RE: Database Documentation ToolRenante Milan <renantem@a...> 02 Aug
RE: Trigger, sp_who, spid"Darin Strait" <dstrait@e...> 02 Aug
Cursor returning first record only"Darren Mills" <darren_mills@e...> 01 Aug
FW: Help with connecting to SQLGuerrino Di Minno <GDiMinno@h...>101 Aug
Problem connecting to SQL ServerGuerrino Di Minno <GDiMinno@h...>101 Aug
Data Type Problem"Hugh McLaughlin" <hugh@k...>201 Aug
Re: Disabled triggersrnedel@b...101 Aug
RE: SQL Server 7 questionRene Lovino <renel@a...>101 Aug
Re: Sql Mail Config."Payal Jain" <payal_jain@h...>301 Aug
Re: Login failed in NetscapeJoey Brenn <jbrenn@f...> 01 Aug