p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  View Archive  

Thread subjectAuthorRepliesDate
data type!!milanshetty@h...629 Jun
Difficulty in connecting to Sql server"huma hamid" <shehuma@s...>129 Jun
Cluster SQL 2000 on Win 2000"Roy Cheung" <rcheung@b...> 29 Jun
Create function was RE: (No Subject)"rami sader" <sabbra@l...>229 Jun
Week-function in sql server 7"Håkan Arvidsson" <hakan.arvidsson@a...> 28 Jun
EventID 124"Kamran" <user_15@h...>128 Jun
trying to delete"Greg Partin" <greg@c...>228 Jun
passing datetime values with DTS"Jean Rynearson" <sqljean@h...> 28 Jun
Can't Copy In SQL 7 !?!?!?"Alex Read" <aread@b...>428 Jun
@@Identity & triggers."Tom Jones" <tm_jones@b...>928 Jun
DTS - importing Paradox files"Dafna Levy" <dafnal@m...>228 Jun
SQL Auto Update TimeStamp"Nathanael Budianto" <budianto@m...>528 Jun
How to Compare Dates in SQL Server"JIB_GEO" <jib_geo@y...>328 Jun
name person with aphrostopeYoga Anindita <yoga@s...>228 Jun
Re: ODBC Error"Sammy Msafiri" <sammy@s...>128 Jun
Connecting to remote server via TCP/IP?"Tom Kelleher" <kelleher@t...>228 Jun
Help with query and DTS"Karen Jackson" <kjackson@f...>227 Jun
RE:Date Problem"Premchand P.L" <premchandpl@p...>127 Jun
RE: LOOKUP tablesBernard Yung <BYung@h...> 27 Jun
Help with MSDTC multiple servers updates with SQL 7.0 Serverdlai@a... 27 Jun
REPLICATION"Solutions 2000" <sqlserver@s...> 27 Jun
help populate table"Butramenko, Angelika" <abutramenko@b...>327 Jun
(No Subject)"rami sader" <sabbra@l...>127 Jun
Pre-Reply To My Own Post -Client Network UtilityScott Watermasysk <swatermasysk@C...>327 Jun
Client Network UtilityScott Watermasysk <swatermasysk@C...> 27 Jun
Date DiffJithesh Kumar <jithu_kumar@y...>827 Jun
Re: SQL Server"Sammy Msafiri" <sammy@s...> 27 Jun
Showing First 100 record ???Yoga Anindita <yoga@s...>427 Jun
Help!!! Import TXT Data into SQL Server 2000info@e... 27 Jun
inexplicable 80040e14 errorDavid Cameron <dcameron@i...>127 Jun
Setting up Replication between 2 servers - SQL 7.0happygv@y...127 Jun
cascading update with triggers"drngo drngo" <drngo@h...>127 Jun
Parsing Multi part string"Ron Baxter" <rbaxter@c...>126 Jun
track it users orders"angelika butramenko" <abutramenko@b...> 26 Jun
Chinese Lang"Antonello Corbo" <antonello65@i...>126 Jun
XML Input ParameterClifton Dunaway <csdunaway@y...> 26 Jun
Volatile schema - job for XML? Your opinions please!"Saul Kripke" <saulkripke@h...> 25 Jun
Moving a SQL 2000 Database"R Barone" <rbarone@g...>225 Jun
Help Unable to update identity column!Sanjay Shinde <jay_sh2k1@y...>225 Jun
Dynamic SQL Stored Procedure Date Problemrivey@v...725 Jun
sending sql output to a file..."Denmark Weatherburne" <denmark_weatherburne@h...> 25 Jun
Re: Record with three fields"Mavin Specimen" <mspecimen@h...>125 Jun
Normalization"Pallone, Claudio [KMR-SPC]" <Claudio.Pallone@k...>125 Jun
Getting data from several msde db's"daniel O'Dorisio" <dodorisio@h...> 25 Jun
TRIGGERS"Pallone, Claudio [KMR-SPC]" <Claudio.Pallone@k...>225 Jun
BCP - Bulk Copy from SQL 6.5Richard Hadfield <richyrich@t...>125 Jun
NorthWind DBworkflow <workflow@s...> 25 Jun
Calling a Function"JIB_GEO" <jib_geo@y...>623 Jun
Help! SQL 6.5 table corrupted..."Denmark Weatherburne" <denmark_weatherburne@h...>122 Jun
Read Contacts/write Tasks from an Access/SQL Project?"Tom Abel" <tabel@u...>122 Jun
How do you move transaction logging to a new file?"Orlando Rodriguez" <orlando@i...> 22 Jun
Deleting data from a table"Mavin Specimen" <mspecimen@h...>722 Jun
CLUSTERED INDEX"Pallone, Claudio [KMR-SPC]" <Claudio.Pallone@k...>522 Jun
Full text Indexing....antonydeepak@y... 22 Jun
Data Transfer over telephone line"Srivathsan_Autopartsasia" <srivathsan@a...>822 Jun
View vs Stored Procedure"Steve Hindle" <Hindle@c...>822 Jun
Select inside selectDavid Cameron <dcameron@i...>422 Jun
How to change the default value of a column"Jenifer Mundstock" <jenifer@s...>122 Jun
tools or example for create local cube from analyses service"Fulvio Ritter DIUNO Lan" <fulvio@d...> 21 Jun
Dynamic Query in UpgradeJoey Brenn <jbrenn@f...>121 Jun
Causing deadlocks for testing"Saul Kripke" <saulkripke@h...>121 Jun
Assertion Failed"Michael B. Deck" <mdassignment@h...> 21 Jun
Client Configuration"Michael B. Deck" <mdassignment@h...>621 Jun
SQL Server 2000 Replication Problems"Khalid Hussain" <khalid@p...> 21 Jun
Calculate all tables and indexes size."Giedrius" <fozis@c...> 21 Jun
Return top recordDavid Cameron <dcameron@i...>221 Jun
MDAC v 1.5, HELP!!!"Chris Ogilvie" <cogilvie@r...>121 Jun
Cannot open..."Paul" <pong@t...> 20 Jun
Enabling transaction logging..."Denmark Weatherburne" <denmark_weatherburne@h...>220 Jun
How to specify database and table from SQL script..."Denmark Weatherburne" <denmark_weatherburne@h...>220 Jun
check for existence of a Table"Tony" <one_dev@h...>1020 Jun
opinion"Tony" <one_dev@h...>520 Jun
CASE in WHERE Clause?"Jeff Mason" <jeffm@u...>520 Jun
HELP! Migrating SQL Server 7 to SQL Server 2000Yoga Anindita <yoga@s...>420 Jun
Re: sql_server digest: June 19, 2001"Geoff Higgins" <geoff@v...> 20 Jun
Re: Remote connection to SQL Server 2000"MAJ Pat Flanders" <flanders@m...> 20 Jun
Re: Accessing SQL 6.5 and 7 from Access 2000 with MSDE remotely"MAJ Pat Flanders" <flanders@m...> 20 Jun
DTS Package using other Database with same structure but different name, possible? (without changing al the design flows)khlam2000@y... 20 Jun
sqlredis.exe"MAJ Pat Flanders" <flanders@m...> 20 Jun
Copy Table to another DB in Stored Procedure"Tony" <one_dev@h...>220 Jun
XML Schema to Tables and back again"Mathieu Wiepert" <wiepert.mathieu@m...> 19 Jun
SQL Search errorElmer Donavan <Elmer.Donavan@u...>219 Jun
How to change Database File namesClifton Dunaway <csdunaway@y...>219 Jun
Transferring Table Structures from SQL 7.0 Ent to SQL 7.0 Standar- dHal Levy <hal.levy@s...>219 Jun
Re: I need Help! Deleting data in SQL..."Mavin Specimen" <mspecimen@h...>519 Jun
Using a common user defined function in a Transformation VB- Script"Kelly McMillin" <kmcmilli@h...> 19 Jun
Rebuilding Indexes"Steve" <scalhoun@s...>119 Jun
data not showing in webpage...."Julien Dupont" <dupont@m...>2119 Jun
Re: Replication Problems..expired subscription"Ricardo Beck" <RicardoBeck@y...> 19 Jun
Using DTS & ASP to transfer a table from Access > SQL Server"Nick Donnelly" <wrox@o...>119 Jun
SQL Server Script ProblemElmer Donavan <Elmer.Donavan@u...> 18 Jun
BCP import to SQL Server 6.5Bernard Yung <BYung@h...>218 Jun
Data Pump - IMport NULLS instead of SPACES without changing- every single data transformation"Kelly McMillin" <kmcmilli@h...>118 Jun
How well does SQL Mail perform with NON-Exchange Servers"Bianca Riem" <Bianca.Riem@n...> 18 Jun
Anyone experience with client connections after renaming SQL7.0"Bianca Riem" <bianca.riem@n...>118 Jun
Re: Need Help With SQL Server Enterprise Manager"Steve" <sfinke@e...>218 Jun
Calculating last week date function"Samira" <sdavis@c...>418 Jun
Slow query"Steve" <scalhoun@s...>418 Jun
SQL language - case sensitivity"R Barone" <rbarone@g...>318 Jun
Avoid Phatoms in Disconnected Environment"Saul Kripke" <saulkripke@h...> 18 Jun
SQL Server with Active Directory<geekabyte@y...>118 Jun
MSSQL global variables?richnorgaard@s...117 Jun
NT PerfMon vs Master..SysPerfInfo"Xu Gary" <Gary.Xu@p...> 16 Jun
xp_sendmail questionKyle Burns <kburns@c...>315 Jun
SQL 2000 client accessing SQL 7 database"Tom Chabot" <chabott@m...> 15 Jun
purging the ssanalysis SQL database"Ray Watts" <raykwatts@h...>115 Jun
Re: Change case insensitive databaseramesh_bhanu@y...115 Jun
RE: How to retrieve the Image Data into Web Pages fr- om SQL Server 7.0?David Cameron <dcameron@i...>315 Jun
returning values from a stored procedure to a DTS package vbscri---ptElmer Donavan <Elmer.Donavan@u...>314 Jun
xp_cmdshell"Steve Read" <Steve.Read8787@b...>314 Jun
SQL Permission problems"Austin, Jay" <jay@b...> 14 Jun
Using SQL Server instead of Sql desktop for book examples..."Mike Edgewood" <mrlmz@e...>214 Jun
MDAC 2,6 Rollback"bill salkin" <wsalkin@h...> 14 Jun
Data Pump Transformation Problems - DATE and MONEY formats- blow up"Kelly McMillin" <kmcmilli@h...>114 Jun
Sample for Inserting & Retrieving"JIB_GEO" <jib_geo@y...> 14 Jun
How do I Build a Dymanic Query in a stored proc ?"Clifton Dunaway" <csdunaway@y...>214 Jun
Question on .NET's ASPState database"Saul Kripke" <saulkripke@h...>114 Jun
How to retrive the Image Data into Web Pages from SQL Server 7.0?workflow <workflow@s...>314 Jun
Archiving data for history"Saul Kripke" <saulkripke@h...>314 Jun
Re: Problems importing dates"Kelly McMillin" <kmcmilli@h...>213 Jun
ODBC and SQL 7 Timeout"bill salkin" <wsalkin@h...> 13 Jun
SQL-DMO Replication"David Jarmoluk" <djarmoluk@y...> 13 Jun
xp_cmdshell & bcp"Paul" <pong@t...>113 Jun
DTS QuestionMSpruill <mspruill@m...> 13 Jun
SQL Server 7 - disaster strikesBob Bailey <bob@f...>513 Jun
An INSERT EXEC statement cannot be nested.Ankur Kalsi <akalsi@q...>213 Jun
DTS and Finding Dup Primary keys"bill salkin" <wsalkin@h...>113 Jun
The service did not start due to a logon failure."Igor Zorovik" <igor_sql2000@h...>512 Jun
Running sproc."Paul" <pong@t...>212 Jun
SQL Float Data typetony.scott@n...312 Jun
Problem with date format with minutes and seconds"jose maria hernandez" <jmh@i...>212 Jun
tables lockedmarcelo_velasque@h... 12 Jun
Table/Server Efficiency"Larry Guayante" <larryg@p...>612 Jun
Re: Question about DELETE statementramesh_bhanu@y...212 Jun
SQL 7.0 Replication"David Jarmoluk" <djarmoluk@y...> 11 Jun
Oracle equivalent to "BULK INSERT""David E" <registerukh@h...>911 Jun
Using EXEC with table variable vs. temp table"Aaron Fanetti" <AFanetti@C...>311 Jun
Blank recipient in SQL mail"anurag" <anuragg@i...>111 Jun
DTS"Wei Qin" <qinw@n...> 11 Jun
Re: Query quandry -- finding largest valueramesh_bhanu@y...111 Jun
lookup table"yoga" <sahaj76@y...>111 Jun
Replication options<wburrough67@y...>211 Jun
select max(id) + 1"marcelo velasquez" <marcelo_velasque@h...>211 Jun
Performance hit for string concat"Saul Kripke" <saulkripke@h...>111 Jun
How to get a columns (fields) data type?"Mark E. Watkins" <wattem@h...>310 Jun
Security - transfer of data over the internet"E. Peter K. Chan" <heypeter@l...>409 Jun
moving data from one server to another server"rohith shetty" <rohith576@y...>1008 Jun
using textfile inside Stored Proceduremarcelo_velasque@h...308 Jun
dateformat in SQL server"Gerhard Wentink" <data@w...>208 Jun
database admin question: how can I view tables owned by others"Tim Zhang" <tzhang@h...>108 Jun
SQL query and stored procedure"Alberto.Bertazzoli" <Alberto.Bertazzoli@e...> 08 Jun
Reading all fields in stored procedures..."Mark E. Watkins" <wattem@h...>308 Jun
SELECT based on distinct column value"Aaron Fanetti" <AFanetti@C...>608 Jun
length of 2 single quotesDavid Cameron <dcameron@i...>408 Jun
Advanced DTS questionClifton Dunaway <csdunaway@y...>307 Jun
SPROC and @ sysmbol contained in data"martha j sayers" <marthaj@r...>207 Jun
Sprocs and text containing @"Martha J. Sayers, A.A.B." <marthaj@r...>307 Jun
ConnectionOpen(Connect()) error on register"Adam Sitnick" <asitnick@i...>407 Jun
Link to different database on same server??"Tom Abel" <tabel@u...>607 Jun
Error 3105 while writing"Jason Chen" <cmonkey103@h...> 07 Jun
Re: Rookie SQL questions"Bruce Brunette" <bruceworking@y...> 06 Jun
Select within an insert"Roy Cheung" <rcheung@b...>406 Jun
SQL Server Agent"Yitao yu" <yuy@n...>206 Jun
Using Waitfor"ANURAGG" <ANURAGG@i...>106 Jun
Re: Performance problems with SQL Server 2000 and large tables."Sammy Msafiri" <sammy@s...> 06 Jun
Planning for Disaster RecoveryHarry Jega Nathan <hjeganathan@y...> 05 Jun
Convert MS SQL Database to ORACLE"Torres, Edgardo" <E.TORRES@C...> 05 Jun
Restore / DTS Question"Arif Khan (GWL)" <GWLAIK@w...> 04 Jun
RE: title caseBernard Yung <BYung@h...> 04 Jun
Problem with store procedure???Guerrino Di Minno <GDiMinno@h...>204 Jun
Re: Using OPENQUERY in an INSERT statementlpetroczy@h...104 Jun
?CURSOR - WHILE @@FETCH_STATUS=0 loop"sdprague" <sdprague@h...>304 Jun
Error trapping in DTS"Pete Bradbury" <pete.bradbury@c...>404 Jun
Reviewers needed for SQL Server software"Tony Healey" <THealey@Q...> 04 Jun
Text Width in Query Analyzer"Kent Tegels" <ktegels@t...>103 Jun
Error While Deleting the Rows From the Table"vishal mishra" <vismis33@h...>302 Jun
query runs faster in the query analyser,but the application is slow"balachandar ganesan" <gbala@b...>102 Jun
Get All Users!"Elaheh Najafi" <elahehny@y...>102 Jun
restoring a database from a .mdf and .ldf fileleebro1@h...301 Jun
RE: Upsizing an mdb"Mavin Specimen" <mspecimen@h...> 01 Jun
Re: openrowset"Byron Thanopoulos" <byron_thanopoulos@h...> 01 Jun
openrowset problems"Byron Thanopoulos" <byron_thanopoulos@h...>201 Jun
AW: difference quantity & SQL Server time out"Sagmeister, Christian (Projektteam)"101 Jun
difference quantity & SQL Server time out"Sagmeister, Christian (Projektteam)" 01 Jun
MS Sql Server"interburn" <internaly@y...>301 Jun
Re: Tool for synchronizing database structures?"Darin Strait" <dstrait@e...> 01 Jun
RE: and's and or'sPeter Zahos <pzahos@s...> 01 Jun
RE: How to install a 'local' server on my workstation"Tomm Matthis" <matthis@b...>201 Jun