p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  View Archive  

Thread subjectAuthorRepliesDate
finding and setting size of database through java program"Rapally Ramana" <ramanurs@h...> 31 Mar
image data type"Tim Zhang" <tzhang@h...>131 Mar
SQLDDL references"John H. Crimmins" <johnc@s...> 31 Mar
DTS errormartin.hansen@v...131 Mar
Update Statement Help"Littleton, Reggie, ISD (x)" <RLittleton484@w...>331 Mar
RE: sql_server digest: March 29, 2001"Merten, Joe" <Joe.Merten@b...> 30 Mar
Re: Full text index population error"Brad" <brad@i...> 30 Mar
SQL Server"Rapally Ramana" <ramanurs@h...>329 Mar
moving a column of data from a table within SQL Server 7 Database"Andrew Goodall" <amgccc@h...>129 Mar
Tricky SQL questionRyan Finley <RyanF@S...>829 Mar
Persisting information accross multiple invoacations of an Extended Stored Procedure"Meredith Shaebanyan" <merediths@p...>129 Mar
Re: About error handling on DTS on SQL server 2000"Patricia Gilson" <pgilson1@t...> 29 Mar
How do I use @@identitymarcelo_velasque@h...229 Mar
problem is FTP task in DTS PackageMS sar <pon_007@u...> 29 Mar
Using a variable in a from statement"Ron Baxter" <rbaxter@c...>429 Mar
Problem in FTP task in sql server"SARAVANANE" <pon_007@u...> 29 Mar
Question on BULK command???Guerrino Di Minno <GDiMinno@h...>229 Mar
A Question on SQL Server v7 Transaction Log"Arif Khan (GWL)" <GWLAIK@w...>129 Mar
Problem using DTSAftab Ahmad <aftab.ahmad@k...>129 Mar
How to assign a value to a variable from a dinamically build stat- ement once it executed...?Danie Opperman <oppermand@M...> 29 Mar
How do I return rows from multiple select statements in a stored procedure"shilpy" <guptashilpy@r...>228 Mar
help bringing back correct data from 2 tables"Bryan Cotter" <bryan@s...>128 Mar
Kind Attn.- String Function Gurusspeedguru@m...328 Mar
Data Editing problem"Steve Hindle" <Hindle@c...>127 Mar
if else"Sam Lewitan" <slewitan@e...>227 Mar
Syntax of database. Executeimmediate methood for calling transact sql file"JATIN HALDANKAR" <jatinh@r...> 27 Mar
SQL Server 2000 Security Problem"shirley hsieh" <hsieh_shirley@s...> 24 Mar
Optional Parameters for Stored Procedures"Bill Robinson" <Bill.Robinson@S...>323 Mar
Granting Execute access to a table?KevinJRiley@Y... 23 Mar
Error Performing Replication with Anonymous Subscription"JATIN HALDANKAR" <jatinh@r...> 23 Mar
Re: SQL Server BLOB data types"Bleddyn Davies" <bbd75800@g...> 23 Mar
how to get script for scheduled jobs"saurabh kothari" <saurabh.kothari@p...>123 Mar
change precision for datatypes"saurabh kothari" <saurabh.kothari@p...> 23 Mar
diff.in configuration of sql7.0 edition and advantage"saurabh kothari" <saurabh.kothari@p...>123 Mar
Query Designer Errors.."Dave Green" <daveg@p...>222 Mar
Re: OLAP services problem w/Pivot Tables on web"Ron Borden" <rborden@b...> 22 Mar
Updating Joined Tables (SQL 2000)"iGGy Pops" <ggokhman@h...> 22 Mar
SQL Server development from the client"Bill Robinson" <Bill.Robinson@S...>222 Mar
Transferring data from SQL 6.5 ro SQL 7"bill salkin" <wsalkin@h...>122 Mar
Emercency Transaction!!"Antonello Corbo" <antonello65@i...> 22 Mar
Timeout Expired"Steve" <scalhoun@s...>322 Mar
Multi-statement Table-valued Functionsstephen@v...122 Mar
Error with IIf Function using SQL Server 2000stephen@v...322 Mar
Using begintrans inside VB for Storeds Proceduresmarcelo_velasque@h...322 Mar
Access combo box and T-SQL stored procedures w/ param"John Williams" <progcon@m...> 22 Mar
RE: sql_server digest: March 15, 2001"Tom Kelleher" <kelleher@t...> 21 Mar
Using DTS to import an access table"CORRIGAN, Mairead" <CORRIGAM@B...> 21 Mar
passing several data for stored proceduremarcelo_velasque@h... 21 Mar
IFF Function in SQL Server 2000stephen@v...521 Mar
updated in trigger"saurabh kothari" <saurabh.kothari@p...> 21 Mar
Importing text data to SQL Server via an intranet pageKen Gould <birchwoodstudio@y...> 21 Mar
SQL Mail (On SQL Server 7, SP - 3) Problem"Arif Khan (GWL)" <GWLAIK@w...> 20 Mar
Should we use "varchar" or "nvarchar?"bill salkin" <wsalkin@h...>120 Mar
IN( ) statement with SP"Paul Tillotson" <paultillotson@q...>220 Mar
Composite Keys in Table Structure<bikedude67@y...>120 Mar
Replication Problems..expired subscription"alex williams" <alex_williams@b...> 20 Mar
dbSeeChanges WHAT in the world!!?"Jimenez, Sonny" <Sonny.Jimenez@s...> 20 Mar
One question???Guerrino Di Minno <GDiMinno@h...> 20 Mar
ALTER VIEW in SP?"Brian Jones" <brianj@m...> 20 Mar
Maximum row size for the table."Banu" <banuweb@h...> 20 Mar
User Defined Functions in SQL Server 2000 (UDF's)stephen@v...120 Mar
Nesting Stored Proceduresstephen@v...420 Mar
TEXT Columns and ASP"Banu" <banuweb@h...>220 Mar
How I pass data of the msflexgrid to stored procedure ?marcelo_velasque@h... 19 Mar
TimeStamp"Rudy Cooper" <rudycoop@p...>1019 Mar
When was my SQL Server Insatlled?"bill salkin" <wsalkin@h...> 19 Mar
error connecting to sql server"Rui" <ruiricardo@2...> 19 Mar
i want clarification"sankar tumuluru" <shan_tumuluru@r...> 19 Mar
Using EM to insert an identity column"Timothy Spackman" <spackman@r...> 19 Mar
How to make multi-step job start at step 1?"bill salkin" <wsalkin@h...> 19 Mar
find rank/rowid from a ordered tablespeedguru@m...219 Mar
Tables and sprocs set up under dbo"Don Colabella" <don@c...> 18 Mar
Renaming a SQL Server 6.5"carlos correa" <ccorre@c...> 16 Mar
connection failure to sql server login"Jimenez, Sonny" <Sonny.Jimenez@s...> 16 Mar
DTS & multiple source files"Kavita Patel" <kavita@n...> 16 Mar
Trying to use DTS to import a flat file to normalized db"David Harding" <David.Harding@s...> 16 Mar
RE: Programming DTS"David Harding" <David.Harding@s...>116 Mar
connectin to a remote database through procedure, using job scheduling"Heljeeve" <lgsql@r...>116 Mar
LINKED TABLE"Antonello Corbo" <antonello65@i...> 16 Mar
Selecting the minimum value across a row"Amitabh Premraj" <amitabh@k...>216 Mar
How notify multiple users when a backup job fails?"bill salkin" <wsalkin@h...>115 Mar
Scheduled Job ErrorsStanley Glass <SGlass@r...>115 Mar
Efficient backups of VLDB"Lee, Al" <Al.Lee@F...> 15 Mar
TEXT columns"Brian Jones" <brianj@m...>415 Mar
Source of SQL Server 7 security information"Jim Ryan" <portrdh@c...>115 Mar
Upgrading SQL 7 to SQL 2000Bukovansky@a... 15 Mar
Record counts"Ged Read" <ged.read@i...>415 Mar
Performance cost for cross-database queries"Tom Kelleher" <kelleher@t...>315 Mar
Mysterious trans log backup failure..."bill salkin" <wsalkin@h...>315 Mar
Increment problems"Yehuda Rosenblum" <Yehuda@I...>814 Mar
I have a question about Store Procedure???Guerrino Di Minno <GDiMinno@h...>114 Mar
Import!"Payal Jain" <payal_jain@h...>114 Mar
SQL server fault tolerancezzz8611@y... 13 Mar
DTSLookups Type Mismatchsilk_s@y... 13 Mar
html page via SQL database"Darren Durgha" <darren@v...>313 Mar
RE: Code for selecting a substring consisting of 5 numbers [sql_- server] Re: Changing caseBernard Yung <BYung@h...> 13 Mar
General question!!!Guerrino Di Minno <GDiMinno@h...>313 Mar
Transaction Log"Antonello Corbo" <antonello65@i...>213 Mar
Parameter problem in stored procedures"Håkan Arvidsson" <hakan.arvidsson@a...>513 Mar
Autoincrement in SQL-Server2000"arnold angerer" <arnold.angerer@p...>213 Mar
how to create a trigger that will automatically call an asp page?Floyd Hunag <flloid@p...>113 Mar
Is possible to create SQL Database when Install package VB ?"Yutthasak Wongdama" <yutthasak@h...>213 Mar
Sql Server Enterprise Manager"Nathan McGuiness" <mcguiness74@h...>312 Mar
run time error 3091 sending query to sql thru excel vba using dao"Jimenez, Sonny" <Sonny.Jimenez@s...>212 Mar
cursor problem"saurabh kothari" <saurabh.kothari@p...>212 Mar
store image filesspeedguru@m... 12 Mar
Timeout error VB -> SQL Server"Graham Henderson" <graham@t...>210 Mar
Search that returns only the first record"Antine de Contance" <bira_dayok@y...>109 Mar
SQL 2K And Column Descriptions"Michael Morisoli" <Michael@M...> 09 Mar
Pulling Field DescriptionStanley Glass <SGlass@r...> 09 Mar
Changing casejoe@k...309 Mar
Update Trigger Questionkent@t...309 Mar
Refreshing a database with locked copy"carlos correa" <ccorre@c...> 08 Mar
importing different character setsBrett Hardman <b_hardman@y...> 08 Mar
OLAP - Irregular HierarchiesJGriffith@M... 08 Mar
Memo Fields in SQL Server?"Bleddyn Davies" <bbd75800@g...>408 Mar
about the Dts package"igneous" <chitse@m...> 08 Mar
how to retrieve the image"lakshmana Rao" <glrao_3@y...> 08 Mar
The error about saving DTS package"Xuanchen Jiang" <neo@b...> 08 Mar
Multiple-step OLE DB operation generated errors."aruna" <aruna.koya@d...> 07 Mar
converting Access queries to SQL stored procs"Gary" <ggokhman@h...> 07 Mar
ESQL/C support for Multi Threading"Payal Jain" <payal_jain@h...>107 Mar
tempdb performance"Pornthip Duggan" <duggan@r...>607 Mar
Disconnected Recordsets"Solutions 2000" <sqlserver@s...>107 Mar
Column countspeedguru@m...307 Mar
Stumped using @@error as return value frm stored procedure"Jim Ryan" <portrdh@c...>106 Mar
questionmatthew.baker@m... 06 Mar
How to read a bunch of xml files into SQL Server 2000 without man- ually type in the xml DOM"Mu, Bin" <bmu@a...> 06 Mar
MERGE REPLICATION:PROCESS COULD NOT READ FILE"JATIN HALDANKAR" <jatinh@r...> 06 Mar
"SQL Server does not Exist" message"bill salkin" <wsalkin@h...>106 Mar
Nested Stored Proceduresstephen@v...206 Mar
how many .ldf log files?zzz8611@y...305 Mar
a question about trigger"amir aboulhelm" <myProMail@y...>205 Mar
Re: Help with very large databasessml.lewis@v...105 Mar
Problem with EXEC command...Guerrino Di Minno <GDiMinno@h...>205 Mar
Timeout on SQL Server 7 - when called from VB"Graham Henderson" <graham@t...>105 Mar
Exporting data to a excel file"Alvin Anita" <anita@s...>205 Mar
Database Connections"Solutions 2000" <sqlserver@s...>105 Mar
Re: Sql Server Help!?"Sammy Msafiri" <sammy@s...> 05 Mar
Re: varchar export limitations II"Daniel Morphett" <danmorph@z...> 04 Mar
Re: Hi its me again!!!"Daniel Morphett" <danmorph@z...> 04 Mar
Stored Procedures"martha j sayers" <marthaj@r...>703 Mar
SQL7 and error 208 - invalid object"Jim Laney" <jimlaney@m...>303 Mar
Can anyone help me?Guerrino Di Minno <GDiMinno@h...>102 Mar
Help wanted FAST !!! PLEASEGuerrino Di Minno <GDiMinno@h...> 02 Mar
SQL server 2000 down to 7.0"Sam Lewitan" <SLewitan@E...>602 Mar
SQL exam: 7.0 or 2000?zzz8611@y...202 Mar
SQL backup restore"Deon Fourie" <df@o...>102 Mar
Using CDONTS in SQL server"Walter Burrough" <lists@c...>102 Mar
Does SQL Server 7.0 support Keyset Cursors ?"Vikas Sethi" <emailtovikas@r...> 02 Mar
Re: Is 2Gb sufficient in the SQL Server bundled with SBS 2000?alanhawkins.home@d... 02 Mar
SQL 2K debugger"bill salkin" <wsalkin@h...> 02 Mar
Check list for move, dts...dont worry <aspmailbox@y...>102 Mar
Parsing T-SQL in VB middle-tier object?"bill salkin" <wsalkin@h...>401 Mar
Re: Select Records from different Server Databasezzz8611@y...101 Mar
DTS, identity column insert import problemdont worry <aspmailbox@y...>301 Mar
NT Authentication Connectionhenryjud@n...201 Mar
Isolation Levels"vishalgandhi" <vishalgandhi@m...>901 Mar
RE: SQL Sever 2000 - Nullable Foreign key"Ian Cox" <ian_cox2000@h...>601 Mar
Instantiate a com object within a stored procedure"Pascal Mestdach" <pascal@t...>301 Mar
RE: Automatic send Mail with sp s"siva" <sivakumar_s_k@y...> 01 Mar