comp.databases.ms-sqlserver

• Thread Index

---

• Re: ERROR_STATE() Always = 0?
  • From: wackyphill
• Re: Math functions
  • From: Jens
• Re: ERROR_STATE() Always = 0?
  • From: Jack Vamvas
• [ANNOUNCE] Invoking Web Services from XQuery
  • From: Stylus Studio
• Re: Need a So-Called SSN Encryption
  • From: --CELKO--
• Math functions
  • From: kai
• Re: Down and dirty database infrastructure
  • From: Beeker
• Re: Problem with a join due to multiple Nulls
  • From: chudson007
• Re: Problem with a join due to multiple Nulls
  • From: David Portas
• JDBC Driver NOT throwing Exception
  • From: JSParker1
• Re: Problem with a join due to multiple Nulls
  • From: chudson007
• error when trying to do datamining
  • From: Giff
• The transaction has exceeded the allotted time
  • From: AJA
• Re: database design for fast client updates
  • From: T . H . N .
• Re: Stored procedure with unknown numer of paramters, how?
  • From: Tony Rogerson
• FYI: Free server 2005 E-Learning courses available
  • From: Vincent Wehren
• ERROR_STATE() Always = 0?
  • From: wackyphill
• Re: Can this be optimized? Newbie question
  • From: Alexander Kuznetsov
• Re: Cursor looping versus set-based queries
  • From: --CELKO--
• Re: French characters are not imported properly with bcp
  • From: Wael
• Re: Cursor looping versus set-based queries
  • From: Hugo Kornelis
• Re: Need a So-Called SSN Encryption
  • From: figital
• Re: Can this be optimized? Newbie question
  • From: Gert-Jan Strik
• Re: Update SQL 2000 Query (converting an Old Access 2k query to SQL)
  • From: David Portas
• Re: Bind Variable in CURSOR
  • From: traceable1
• Re: Need a So-Called SSN Encryption
  • From: David Portas
• SQL Server 2005 Client Tools
  • From: Dave
• Re: Row Numbers for a View
  • From: Andrew Lias
• Re: Select first n rows of table
  • From: Andrew Lias
• Bind Variable in CURSOR
  • From: traceable1
• Re: Error in Query
  • From: DickChristoph
• Re: Optimizing SQL - Union
  • From: das
• Re: Problem with a join due to multiple Nulls
  • From: --CELKO--
• Re: Stored procedure with unknown numer of paramters, how?
  • From: --CELKO--
• Re: Sql server report
  • From: Daniel
• Timeout fixed by recompile
  • From: justin . mayes
• Re: database design for fast client updates
  • From: T . H . N .
• Re: Down and dirty database infrastructure
  • From: Greg D. Moore \(Strider\)
• http://www.sql-ex.ru answers
  • From: Daniel
• Re: Down and dirty database infrastructure
  • From: Beeker
• Re: Error in Query
  • From: Daniel
• Re: I'm sure this is an easy one...Error trap to skip over a "bad" object.
  • From: rod . weir
• Re: I'm sure this is an easy one...Error trap to skip over a "bad" object.
  • From: Erland Sommarskog
• Re: Automatic statistics update
  • From: Erland Sommarskog
• Re: Sqlserver Login and user
  • From: Jens
• Automatic statistics update
  • From: Chris Weston
• Re: Transpose Rows to Columns ?
  • From: Serge Rielau
• Re: Transpose Rows to Columns ?
  • From: jim_geissman
• I'm sure this is an easy one...Error trap to skip over a "bad" object.
  • From: rod . weir
• Sqlserver Login and user
  • From: waqarkust
• Re: Hiding NULL
  • From: jim_geissman
• Re: Transpose Rows to Columns ?
  • From: Serge Rielau
• Re: Can this be optimized? Newbie question
  • From: wgblackmon@xxxxxxxxx
• Re: Can this be optimized? Newbie question
  • From: Joe Weinstein
• Can this be optimized? Newbie question
  • From: wgblackmon@xxxxxxxxx
• Transpose Rows to Columns ?
  • From: bogtom
• Re: Optimizing SQL - Union
  • From: Hugo Kornelis
• Re: Stored procedure with unknown numer of paramters, how?
  • From: Erland Sommarskog
• Re: database design for fast client updates
  • From: Erland Sommarskog
• Re: speeding up inserts
  • From: zelnaga
• Re: 2005:how to find installed assemblies
  • From: Erland Sommarskog
• Re: Down and dirty database infrastructure
  • From: Erland Sommarskog
• Re: speeding up inserts
  • From: Erland Sommarskog
• Re: Hiding NULL
  • From: Erland Sommarskog
• Re: Sql server report
  • From: Erland Sommarskog
• Re: French characters are not imported properly with bcp
  • From: Erland Sommarskog
• Re: Optimizing SQL - Union
  • From: das
• Re: French characters are not imported properly with bcp
  • From: Wael
• Re: Odd query plan for view
  • From: JayCallas
• Hiding NULL
  • From: jim_geissman
• Re: speeding up inserts
  • From: Robert Klemme
• Re: Optimizing SQL - Union
  • From: Tom Moreau
• Optimizing SQL - Union
  • From: das
• Re: database design for fast client updates
  • From: T . H . N .
• speeding up inserts
  • From: zelnaga
• Re: Order by in a INSERT INTO..SELECT
  • From: pb648174
• Re: Sql server report
  • From: Daniel
• Re: Row Numbers for a View
  • From: Madhivanan
• Down and dirty database infrastructure
  • From: Beeker
• Re: Database poster
  • From: Beeker
• 2005:how to find installed assemblies
  • From: LLik
• Re: database design for fast client updates
  • From: David Portas
• database design for fast client updates
  • From: T . H . N .
• Re: Cursor looping versus set-based queries
  • From: David Portas
• Re: Stored procedure with unknown numer of paramters, how?
  • From: Igor
• Re: Stored procedure with unknown numer of paramters, how?
  • From: Tom Moreau
• Re: Problem with a join due to multiple Nulls
  • From: chudson007
• Re: Problem with a join due to multiple Nulls
  • From: David Portas
• Stored procedure with unknown numer of paramters, how?
  • From: Igor
• Re: Problem with a join due to multiple Nulls
  • From: Erland Sommarskog
• Re: Problem with a join due to multiple Nulls
  • From: chudson007
• Re: Problem with a join due to multiple Nulls
  • From: David Portas
• Problem with a join due to multiple Nulls
  • From: chudson007
• Re: Cursor looping versus set-based queries
  • From: Robert Klemme
• Re: Cursor looping versus set-based queries
  • From: Erland Sommarskog
• Re: Odd query plan for view
  • From: Erland Sommarskog
• Re: Cursor looping versus set-based queries
  • From: Robert Klemme
• how to setup the permission of share fold in log shipping ?
  • From: lovexueer
• Re: Odd query plan for view
  • From: JayCallas
• Re: Stripping input mask from phone numbers
  • From: Erland Sommarskog
• Re: Cursor looping versus set-based queries
  • From: Erland Sommarskog
• Re: Row Numbers for a View
  • From: Erland Sommarskog
• Re: Sql server report
  • From: Erland Sommarskog
• Re: Updating Linked Records Across DB's
  • From: Erland Sommarskog
• Re: Odd query plan for view
  • From: Erland Sommarskog
• Re: Cursor looping versus set-based queries
  • From: Erland Sommarskog
• Re: Cursor looping versus set-based queries
  • From: JayCallas
• SQL Consultant Required
  • From: AJ1000
• Re: Assigning group numbers for millions of data
  • From: Erland Sommarskog
• Re: Cursor looping versus set-based queries
  • From: David Portas
• Re: Cursor looping versus set-based queries
  • From: Hugo Kornelis
• Re: Cursor looping versus set-based queries
  • From: Robert Klemme
• Cursor looping versus set-based queries
  • From: JayCallas
• Re: Update Table
  • From: Hugo Kornelis
• Re: Row Numbers for a View
  • From: Hugo Kornelis
• Re: Where to write XQuery statements?
  • From: Hugo Kornelis
• Odd query plan for view
  • From: JayCallas
• Re: Database poster
  • From: SQL
• Re: Select first n rows of table
  • From: SQL
• Updating Linked Records Across DB's
  • From: johnrou
• Select first n rows of table
  • From: Andrew Lias
• Sql server report
  • From: Daniel
• Re: Query/View: The 2 newest periods for each indicator
  • From: Ryan Dahl
• Re: Row Numbers for a View
  • From: Andrew Lias
• Re: Row Numbers for a View
  • From: Andrew Lias
• Update Table
  • From: Nothing
• Re: Row Numbers for a View
  • From: Madhivanan
• Re: How to fire a trigger without changing table data
  • From: Madhivanan
• Re: Management Studio Express
  • From: Maury
• Database poster
  • From: Beeker
• Management Studio Express
  • From: Maury
• Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties
  • From: Peter Nurse
• Re: How to fire a trigger without changing table data
  • From: John Smith
• Re: Where to write XQuery statements?
  • From: Shilpa
• Re: How to fire a trigger without changing table data
  • From: Dan Guzman
• Re: How to fire a trigger without changing table data
  • From: John Smith
• Re: Row Numbers for a View
  • From: Anith Sen
• Re: How to fire a trigger without changing table data
  • From: Tom Moreau
• How to fire a trigger without changing table data
  • From: John Smith
• Re: LDAP authentication for Yellowfin on SQLserver
  • From: Peter
• Re: Order by in a INSERT INTO..SELECT
  • From: figital
• Row Numbers for a View
  • From: Andrew Lias
• Re: ranged datetime predicates & cardinality estimates
  • From: scott . swank
• Re: Assigning group numbers for millions of data
  • From: jacob . dba
• Re: ranged datetime predicates & cardinality estimates
  • From: Erland Sommarskog
• [ANNOUNCE] Release 2 of Stylus Studio® 2006 Now Available
  • From: Stylus Studio
• ranged datetime predicates & cardinality estimates
  • From: scott . swank
• Re: Assigning group numbers for millions of data
  • From: Erland Sommarskog
• Re: Order by in a INSERT INTO..SELECT
  • From: --CELKO--
• Re: Query/View: The 2 newest periods for each indicator
  • From: Hugo Kornelis
• Re: Assigning group numbers for millions of data
  • From: jacob . dba
• Re: Order by in a INSERT INTO..SELECT
  • From: Erland Sommarskog
• Re: Multiple Foreign Keys on Same Table
  • From: --CELKO--
• Re: Order by in a INSERT INTO..SELECT
  • From: David Portas
• Order by in a INSERT INTO..SELECT
  • From: pb648174
• Re: Multiple Foreign Keys on Same Table
  • From: pb648174
• Re: French characters are not imported properly with bcp
  • From: Erland Sommarskog
• Re: Multiple Foreign Keys on Same Table
  • From: --CELKO--
• Assigning group numbers for millions of data
  • From: jacob . dba
• Re: itzik ben-gan
  • From: jacob . dba
• Re: itzik ben-gan
  • From: jacob . dba
• Re: Dell Raid 0+1
  • From: Dave
• Re: I need help, please
  • From: das
• Re: Accessing Oracle Tables From Within SQL Server 2000
  • From: DM Unseen
• Re: LDAP authentication for Yellowfin on SQLserver
  • From: pb648174
• Re: Where to write XQuery statements?
  • From: Jens
• Re: Multiple Foreign Keys on Same Table
  • From: pb648174
• Re: Help selecting an alias
  • From: Pumkin
• Where to write XQuery statements?
  • From: Shilpa
• ANN: Database Workbench 2.8.5 released
  • From: Martijn Tonies
• Re: I need help, please
  • From: Jens
• I need help, please
  • From: Newsgroup
• Re: French characters are not imported properly with bcp
  • From: Wael
• Re: Accessing Oracle Tables From Within SQL Server 2000
  • From: Mark D Powell
• Re: Multiple Foreign Keys on Same Table
  • From: Erland Sommarskog
• Re: Multiple Foreign Keys on Same Table
  • From: pb648174
• LDAP authentication for Yellowfin on SQLserver
  • From: duncan beaumont
• Re: French characters are not imported properly with bcp
  • From: Erland Sommarskog
• Re: French characters are not imported properly with bcp
  • From: Wael
• Re: Multiple Foreign Keys on Same Table
  • From: Tom Moreau
• Re: Multiple Foreign Keys on Same Table
  • From: Erland Sommarskog
• Re: Multiple Foreign Keys on Same Table
  • From: FreeToGolfAndSki
• Re: Multiple Foreign Keys on Same Table
  • From: Jens
• Re: Multiple Foreign Keys on Same Table
  • From: Doug
• Re: Query/View: The 2 newest periods for each indicator
  • From: Doug
• Re: Multiple Foreign Keys on Same Table
  • From: Tom Moreau
• Multiple Foreign Keys on Same Table
  • From: FreeToGolfAndSki
• Multiple Foreign Keys on Same Table
  • From: FreeToGolfAndSki
• Multiple Foreign Keys on Same Table
  • From: FreeToGolfAndSki
• Re: Query/View: The 2 newest periods for each indicator
  • From: --CELKO--
• Re: Update n rows
  • From: Erland Sommarskog
• Re: Performance Enhancements with Service Pack 4?
  • From: John Bell
• Re: SQL Server 2005 install - no Management Server
  • From: John Bell
• Re: Update n rows
  • From: David Portas
• Re: Query/View: The 2 newest periods for each indicator
  • From: Ryan Dahl
• Re: Update n rows
  • From: Khan
• SQL Server 2000 for sale
  • From: davidc@xxxxxxxxxxxxxx
• Re: ORDER BY in VIEW not working
  • From: --CELKO--
• Re: ORDER BY in VIEW not working
  • From: --CELKO--
• Re: Dell Raid 0+1
  • From: John Bell
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: ORDER BY in VIEW not working
  • From: Erland Sommarskog
• Re: Website navigation hierarchy with SQL Server 2005
  • From: Erland Sommarskog
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Re: Help selecting an alias
  • From: Erland Sommarskog
• Re: ORDER BY in VIEW not working
  • From: Herb Caudill
• Re: Query/View: The 2 newest periods for each indicator
  • From: Hugo Kornelis
• Re: Grant Win Acct Permission
  • From: Erland Sommarskog
• Re: ORDER BY in VIEW not working
  • From: Herb Caudill
• Re: Copying encrypted stored procedures.
  • From: Erland Sommarskog
• Re: French characters are not imported properly with bcp
  • From: Erland Sommarskog
• Re: Using OSQL and DTSRUN
  • From: Erland Sommarskog
• Re: Help selecting an alias
  • From: Hugo Kornelis
• Query/View: The 2 newest periods for each indicator
  • From: Ryan Dahl
• Re: ORDER BY in VIEW not working
  • From: Erland Sommarskog
• Re: Help selecting an alias
  • From: DickChristoph
• Re: generation of sql for an alter column etc
  • From: Erland Sommarskog
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Copying encrypted stored procedures.
  • From: nickwilson . nick
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: Hugo Kornelis
• Re: ORDER BY in VIEW not working
  • From: Herb Caudill
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Re: ORDER BY in VIEW not working
  • From: Herb Caudill
• Re: Accessing Oracle Tables From Within SQL Server 2000
  • From: DickChristoph
• French characters are not imported properly with bcp
  • From: Wael
• Re: Accessing Oracle Tables From Within SQL Server 2000
  • From: Martijn Tonies
• Re: Licensing Question
  • From: David Portas
• Accessing Oracle Tables From Within SQL Server 2000
  • From: Mark D Powell
• Re: Optimising queries
  • From: Doug
• Re: Optimising queries
  • From: Doug
• Licensing Question
  • From: jaustin
• SQL Server 2005 install - no Management Server
  • From: traceable1
• Re: generation of sql for an alter column etc
  • From: Jeff Kish
• Re: generation of sql for an alter column etc
  • From: Erland Sommarskog
• Re: generation of sql for an alter column etc
  • From: Robert Klemme
• generation of sql for an alter column etc
  • From: Jeff Kish
• Grant Win Acct Permission
  • From: wackyphill
• Help selecting an alias
  • From: Pumkin
• Re: Optimising queries
  • From: Erland Sommarskog
• Re: Optimising queries
  • From: Chris Weston
• Re: ORDER BY in VIEW not working
  • From: --CELKO--
• Re: Using OSQL and DTSRUN
  • From: mike
• Re: ORDER BY in VIEW not working
  • From: --CELKO--
• Re: Update the salary of each manager to be double the average salary of the employees he/she manages
  • From: Eric J. Holtman
• Re: help with group by statement
  • From: Erland Sommarskog
• Re: ORDER BY in VIEW not working
  • From: Erland Sommarskog
• Re: help with group by statement
  • From: DickChristoph
• Re: Using OSQL and DTSRUN
  • From: Erland Sommarskog
• help with group by statement
  • From: jerball
• Re: ORDER BY in VIEW not working
  • From: RickW
• Re: Optimising queries
  • From: Erland Sommarskog
• Website navigation hierarchy with SQL Server 2005
  • From: Brian
• Re: Help selecting the proper child record
  • From: CK
• Re: Help selecting the proper child record
  • From: DickChristoph
• Re: Help selecting the proper child record
  • From: CK
• Re: connecting in a script to another db
  • From: Jeff Kish
• Re: Help selecting the proper child record
  • From: DickChristoph
• Re: connecting in a script to another db
  • From: sdyckes
• Re: Using OSQL and DTSRUN
  • From: mike
• Optimising queries
  • From: Chris Weston
• connecting in a script to another db
  • From: Jeff Kish
• Help selecting the proper child record
  • From: CK
• Re: Select 'Current LSN' and 'Transaction ID' from ::fn_dblog
  • From: Doug
• Performance Enhancements with Service Pack 4?
  • From: imani_technology_spam@xxxxxxxxx
• Re: Select 'Current LSN' and 'Transaction ID' from ::fn_dblog
  • From: sdyckes
• Select 'Current LSN' and 'Transaction ID' from ::fn_dblog
  • From: Doug
• NEWBIE (Start/End for ::fn_dblog)
  • From: Doug
• Re: Connecting to another SQL Server
  • From: Jack Vamvas
• Re: Join returns more than one row, Post code regular expressions
  • From: cheesey_toastie
• Re: Join returns more than one row, Post code regular expressions
  • From: Damien
• Connecting to another SQL Server
  • From: Sun G
• Join returns more than one row, Post code regular expressions
  • From: cheesey_toastie
• Re: How do I change the default collation string of an installation
  • From: Erland Sommarskog
• Re: Update the salary of each manager to be double the average salary of the employees he/she manages
  • From: satish
• Re: Update the salary of each manager to be double the average salary of the employees he/she manages
  • From: markc600
• Re: How do I change the default collation string of an installation
  • From: David Greenberg
• Update the salary of each manager to be double the average salary of the employees he/she manages
  • From: satish
• Re: ORDER BY in VIEW not working
  • From: Erland Sommarskog
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Re: ORDER BY in VIEW not working
  • From: RickW
• Re: Job succeeds manually but fails if scheduled
  • From: Gerry Sinkiewicz
• Re: How do I change the default collation string of an installation
  • From: Erland Sommarskog
• Re: Monitoring SQL Server transactions
  • From: Erland Sommarskog
• Re: Update n rows
  • From: Erland Sommarskog
• Re: SQL Server 2005: TRIGGER AFTER INSERT
  • From: Erland Sommarskog
• Re: ORDER BY in VIEW not working
  • From: Erland Sommarskog
• Re: SQL Server 2005: TRIGGER AFTER INSERT
  • From: ZeldorBlat
• SQL Server 2005: TRIGGER AFTER INSERT
  • From: R . A . M .
• Re: Delete Many Rows
  • From: Doug
• Re: Unwanted Sort
  • From: Doug
• Re: ORDER BY in VIEW not working
  • From: Doug
• [Announce] XQuery Webinar: Freeing XML and Relational Data for the Web
  • From: Stylus Studio
• Re: open MDF file without MSDE
  • From: David Portas
• Re: Update n rows
  • From: Anith Sen
• Re: SQL Server License Control and Management
  • From: David Portas
• Re: Update n rows
  • From: David Portas
• Re: Update n rows
  • From: Jens
• Re: Maximum number of databases used for each query in 2005?
  • From: figital
• Maximum number of databases used for each query in 2005?
  • From: Michael . Suarez
• Update n rows
  • From: Khan
• Monitoring SQL Server transactions
  • From: progrAMMAR
• Re: Job succeeds manually but fails if scheduled
  • From: Erland Sommarskog
• Re: SQL Server License Control and Management
  • From: mleal
• Transactional replication without synchronizing snapshot initially.
  • From: prashant
• Re: SQL Server License Control and Management
  • From: Luukkanen Tapio
• Re: SQL Server License Control and Management
  • From: Luukkanen Tapio
• Re: Job succeeds manually but fails if scheduled
  • From: Bryan
• Re: ORDER BY in VIEW not working
  • From: Erland Sommarskog
• Re: SQL Server License Control and Management
  • From: David Portas
• Re: SQL Server License Control and Management
  • From: mleal
• Re: SQL Server License Control and Management
  • From: David Portas
• Re: SQL Server License Control and Management
  • From: mleal
• Re: Job succeeds manually but fails if scheduled
  • From: teddysnips
• open MDF file without MSDE
  • From: Pietro
• Re: IDENT_CURRENT problem
  • From: Robert Klemme
• Re: ORDER BY in VIEW not working
  • From: David Portas
• How do I change the default collation string of an installation
  • From: David Greenberg
• Re: Delete Many Rows
  • From: Greg D. Moore \(Strider\)
• Re: SQL Server License Control and Management
  • From: Dan Guzman
• Re: ORDER BY in VIEW not working
  • From: Herb Caudill
• Re: Query Problem
  • From: Doug
• Re: Many to one Select
  • From: Doug
• SQL Server License Control and Management
  • From: mleal
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Re: ORDER BY in VIEW not working
  • From: Herb Caudill
• Re: Using OSQL and DTSRUN
  • From: Erland Sommarskog
• Re: Many to one Select
  • From: Erland Sommarskog
• Re: ORDER BY in VIEW not working
  • From: Erland Sommarskog
• Re: Reporting a table with two columns from another table
  • From: Erland Sommarskog
• Re: Unwanted Sort
  • From: Erland Sommarskog
• Re: waittype=WRITELOG
  • From: Erland Sommarskog
• Re: Unwanted Sort
  • From: hallpa1@xxxxxxxxx
• Re: Delete Many Rows
  • From: Erland Sommarskog
• Re: Delete Many Rows
  • From: Erland Sommarskog
• Re: add a column specified location in Table..
  • From: Erland Sommarskog
• Many to one Select
  • From: jeffvh
• Re: Delete Many Rows
  • From: hallpa1@xxxxxxxxx
• Re: Unwanted Sort
  • From: David Portas
• Re: Delete Many Rows
  • From: Stu
• Unwanted Sort
  • From: hallpa1@xxxxxxxxx
• Re: Delete Many Rows
  • From: hallpa1@xxxxxxxxx
• Using OSQL and DTSRUN
  • From: mike
• Re: can you launch a crystal report from a sql trigger
  • From: David Portas
• can you launch a crystal report from a sql trigger
  • From: eighthman11
• Re: add a column specified location in Table..
  • From: David Portas
• Re: T-SQL Problem
  • From: Jose
• NEWBIE NEEDS HELP
  • From: mg@xxxxxxxxxxxxxxxxx
• Re: IDENT_CURRENT problem
  • From: john
• Re: IDENT_CURRENT problem
  • From: figital
• Re: IDENT_CURRENT problem
  • From: Tom Moreau
• Re: bigpubs2000
  • From: genuine
• Re: IDENT_CURRENT problem
  • From: Robert Klemme
• Re: IDENT_CURRENT problem
  • From: Tom Moreau
• IDENT_CURRENT problem
  • From: john
• Re: add a column specified location in Table..
  • From: Erland Sommarskog
• Re: easy way to make money
  • From: Madhivanan
• Re: add a column specified location in Table..
  • From: Erland Sommarskog
• Re: Job succeeds manually but fails if scheduled
  • From: teddysnips
• Re: charindex question
  • From: Madhivanan
• Re: Joing tables using more than one field
  • From: markc600
• charindex question
  • From: chudson007
• Re: Joing tables using more than one field
  • From: Tom Moreau
• Joing tables using more than one field
  • From: chudson007
• Re: Help with a substring query
  • From: chudson007
• SQL script for changing all identical columns
  • From: prashant
• Re: add a column specified location in Table..
  • From: David Portas
• Re: T-SQL Problem
  • From: Tom Moreau
• Re: Job succeeds manually but fails if scheduled
  • From: Bryan
• Resource for developing your own accounting software using MS technologies
  • From: pedaammulu
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Re: waittype=WRITELOG
  • From: Marek Wierzbicki
• Job succeeds manually but fails if scheduled
  • From: teddysnips
• Re: Reporting a table with two columns from another table
  • From: Robert Klemme
• Re: T-SQL Problem
  • From: Jose
• Re: add a column specified location in Table..
  • From: Jens
• Re: add a column specified location in Table..
  • From: Erland Sommarskog
• Re: Query Problem
  • From: avode
• Re: SQL--- GROUP BY Clause
  • From: clare at snyder . on . ca
• Re: Reporting a table with two columns from another table
  • From: Stu
• SQL--- GROUP BY Clause
  • From: jim
• Re: Reporting a table with two columns from another table
  • From: John Bokma
• Re: T-SQL Problem
  • From: Tom Moreau
• T-SQL Problem
  • From: Jose
• Re: add a column specified location in Table..
  • From: Anith Sen
• Re: ORDER BY in VIEW not working
  • From: Herb Caudill
• Re: Possible to disable welll-formedness checking when inserting XML data.
  • From: Erland Sommarskog
• Re: Check constraint does not work (compare with null)
  • From: Erland Sommarskog
• Re: Help with a substring query
  • From: Erland Sommarskog
• Re: waittype=WRITELOG
  • From: Erland Sommarskog
• Re: Reporting a table with two columns from another table
  • From: Stu
• Reporting a table with two columns from another table
  • From: John Bokma
• Re: Dell Raid 0+1
  • From: Dave
• Re: Help with a substring query
  • From: figital
• Re: Help with INSERT TRIGGER - fails with error.
  • From: teddysnips
• Re: Help with a substring query
  • From: chudson007
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: UPDATE Statement Involving Tables in Different Databases
  • From: Altemir
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: Help with a substring query
  • From: chudson007
• Re: Query Problem
  • From: --CELKO--
• Re: Help with a substring query
  • From: figital
• Re: Check constraint does not work (compare with null)
  • From: Susanne Klemm
• Re: Help with a substring query
  • From: Sergey
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: figital
• Re: Help with a substring query
  • From: Robert Klemme
• Help with a substring query
  • From: chudson007
• Re: Check constraint does not work (compare with null)
  • From: Tom Moreau
• Re: Check constraint does not work (compare with null)
  • From: David Portas
• Re: Check constraint does not work (compare with null)
  • From: markc600
• Re: Check constraint does not work (compare with null)
  • From: Tom Moreau
• Re: waittype=WRITELOG
  • From: Marek Wierzbicki
• Check constraint does not work (compare with null)
  • From: Susanne Klemm
• Re: add a column specified location in Table..
  • From: Erland Sommarskog
• Possible to disable welll-formedness checking when inserting XML data.
  • From: DSmith1974
• Re: Row to Column
  • From: markc600
• Row to Column
  • From: D i s h a n
• Re: add a column specified location in Table..
  • From: Jens
• Re: add a column specified location in Table..
  • From: Razvan Socol
• add a column specified location in Table..
  • From: surya
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: Design problem
  • From: Erland Sommarskog
• Design problem
  • From: Grabi
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: Hugo Kornelis
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: Erland Sommarskog
• Re: Query Problem
  • From: Tom Moreau
• Re: Query Problem
  • From: Tom Moreau
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Query Problem
  • From: 肥權
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: Erland Sommarskog
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: mysterious corruption of stored procedures
  • From: Sergey
• Re: mysterious corruption of stored procedures
  • From: Sergey
• Re: Getting list of recently added IDENTITY items
  • From: Hugo Kornelis
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: Browser Time Out: when executing a DTS package
  • From: John Bell
• Re: Dell Raid 0+1
  • From: John Bell
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: Erland Sommarskog
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: Erland Sommarskog
• Re: mysterious corruption of stored procedures
  • From: Erland Sommarskog
• Re: 2000 vs 2005 -- AnsiNullsStatus
  • From: Erland Sommarskog
• Re: Stored Procedure Help
  • From: --CELKO--
• Re: mysterious corruption of stored procedures
  • From: Sergey
• Re: Getting list of recently added IDENTITY items
  • From: pb648174
• Re: Finding the natural key
  • From: pb648174
• Re: mysterious corruption of stored procedures
  • From: Erland Sommarskog
• Re: bigpubs2000
  • From: David Portas
• bigpubs2000
  • From: genuine
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• mysterious corruption of stored procedures
  • From: Sergey
• Re: Deploy .MDF to a web host
  • From: Erland Sommarskog
• Re: Help with INSERT TRIGGER - fails with error.
  • From: Erland Sommarskog
• Re: Delete Many Rows
  • From: Erland Sommarskog
• Re: waittype=WRITELOG
  • From: Erland Sommarskog
• Re: outer join column
  • From: Erland Sommarskog
• Re: Help with INSERT TRIGGER - fails with error.
  • From: Hugo Kornelis
• Re: outer join column
  • From: Sergey
• SQL Server Maintenance Routines/Procedures
  • From: Mark D Powell
• Re: SQL query - duplicate records - different dates - how to get only latest information?
  • From: figital
• Re: outer join column
  • From: Michael . Suarez
• Re: outer join column
  • From: Michael . Suarez
• Re: Stored Procedure Help
  • From: CK
• Re: outer join column
  • From: David Portas
• Re: query...
  • From: Beowulf
• Re: outer join column
  • From: alex
• Re: Stored Procedure Help
  • From: DickChristoph
• Re: Deploy .MDF to a web host
  • From: lbolognini@xxxxxxxxx
• Re: Stored Procedure Help
  • From: CK
• Dell Raid 0+1
  • From: Dave
• Re: Delete Many Rows
  • From: hallpa1@xxxxxxxxx
• Re: Stored Procedure Help
  • From: Doug Lawry
• Re: outer join column
  • From: Doug Lawry
• Stored Procedure Help
  • From: CK
• Re: outer join column
  • From: David Portas
• Re: waittype=WRITELOG
  • From: Jack Vamvas
• outer join column
  • From: alex
• waittype=WRITELOG
  • From: Marek Wierzbicki
• Re: 2000 vs 2005 -- AnsiNullsStatus
  • From: jim_geissman
• Re: Delete Many Rows
  • From: Jack Vamvas
• Re: Delete Many Rows
  • From: hallpa1@xxxxxxxxx
• Re: To retrive a table from one database to and another database(same table)
  • From: DickChristoph
• Re: Delete Many Rows
  • From: Jack Vamvas
• Delete Many Rows
  • From: hallpa1
• Help with INSERT TRIGGER - fails with error.
  • From: teddysnips
• Re: Deploy .MDF to a web host
  • From: Jens
• Re: Alternative to OpenXML
  • From: Stu
• Deploy .MDF to a web host
  • From: lbolognini@xxxxxxxxx
• Re: 2000 vs 2005 -- AnsiNullsStatus
  • From: Razvan Socol
• Re: Alternative to OpenXML
  • From: Erland Sommarskog
• Re: To retrive a table from one database to and another database(same table)
  • From: Jens
• To retrive a table from one database to and another database(same table)
  • From: surya
• Re: 2000 vs 2005 -- AnsiNullsStatus
  • From: Erland Sommarskog
• Alternative to OpenXML
  • From: Shilpa
• Re: Sql Server Performance
  • From: Doug
• SQL query - duplicate records - different dates - how to get only latest information?
  • From: clare at snyder . on . ca
• Re: 2000 vs 2005 -- AnsiNullsStatus
  • From: jim_geissman
• Re: Getting list of recently added IDENTITY items
  • From: Hugo Kornelis
• Re: Performance
  • From: Erland Sommarskog
• Re: Sql Server Performance
  • From: Erland Sommarskog
• Re: 2000 vs 2005 -- AnsiNullsStatus
  • From: Erland Sommarskog
• Re: Compare given period in current year / previous year
  • From: Erland Sommarskog
• Re: Finding the natural key
  • From: Erland Sommarskog
• Re: Querying a column with brackets in its name
  • From: Erland Sommarskog
• Re: Sql Server Performance
  • From: Frank Villasenor
• 2000 vs 2005 -- AnsiNullsStatus
  • From: jim_geissman
• [ANNOUNCE] Edit and Validate XML
  • From: Stylus Studio
• Re: Sql Server Performance
  • From: Stu
• Re: change of value at the time of insertion
  • From: DickChristoph
• Sql Server Performance
  • From: Frank Villasenor
• Re: Can't fit results of tsql query in excel
  • From: RA
• Full text index on a view
  • From: Raziq Shekha
• Re: query...
  • From: rj
• Re: query...
  • From: Madhivanan
• Re: query...
  • From: Anith Sen
• Re: Finding the natural key
  • From: Anith Sen
• Re: views dependent on other views
  • From: lukster
• Re: Getting previous values of a field
  • From: Anith Sen
• Re: Greatest value
  • From: Marv Arnold
• Performance
  • From: avinashraj
• Re: Compare given period in current year / previous year
  • From: jannoergaard
• Re: Querying a column with brackets in its name
  • From: Stu
• query...
  • From: rj
• query...
  • From: rj
• Re: Querying a column with brackets in its name
  • From: Erland Sommarskog
• Re: Getting previous values of a field
  • From: Erland Sommarskog
• Re: change of value at the time of insertion
  • From: lucky
• Re: change of value at the time of insertion
  • From: Doug
• Re: views dependent on other views
  • From: Doug
• Re: Getting list of recently added IDENTITY items
  • From: Doug
• Re: Finding the natural key
  • From: Doug
• Re: Finding the natural key
  • From: Doug
• change of value at the time of insertion
  • From: lucky
• Re: Querying a column with brackets in its name
  • From: Stu
• Querying a column with brackets in its name
  • From: Usulnet
• Re: Finding the natural key
  • From: pb648174
• Re: Finding the natural key
  • From: pb648174
• Re: Getting previous values of a field
  • From: devi
• Re: Different query plans for view and view definition statement
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: Erland Sommarskog
• Re: Finding the natural key
  • From: Erland Sommarskog
• Re: Getting previous values of a field
  • From: Erland Sommarskog
• Re: Finding the natural key
  • From: pb648174
• Re: Compare given period in current year / previous year
  • From: Erland Sommarskog
• Re: Timeout expired
  • From: pb648174
• Re: Timeout expired
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: pb648174
• Compare given period in current year / previous year
  • From: jannoergaard
• Re: Getting list of recently added IDENTITY items
  • From: David Portas
• Re: Getting list of recently added IDENTITY items
  • From: Hugo Kornelis
• Re: Finding the natural key
  • From: pb648174
• Re: Finding the natural key
  • From: pb648174
• Re: Getting list of recently added IDENTITY items
  • From: pb648174
• Re: Getting list of recently added IDENTITY items
  • From: David Portas
• Re: Timeout expired
  • From: pb648174
• Re: Not grasping outer joins for ms-sqlserver :: 3 tables to join
  • From: Brian Parker
• Re: Getting list of recently added IDENTITY items
  • From: pb648174
• Re: views dependent on other views
  • From: --CELKO--
• Re: Data Warehouse Nulls
  • From: sheltielover1
• Re: Not grasping outer joins for ms-sqlserver :: 3 tables to join
  • From: Hugo Kornelis
• Re: Selecting records by date - need a little help
  • From: CK
• Re: Communication betwee two tables
  • From: Doug
• Re: Not grasping outer joins for ms-sqlserver :: 3 tables to join
  • From: Brian Parker
• Re: Finding the natural key
  • From: Doug
• Re: Selecting records by date - need a little help
  • From: Doug
• Re: Error in Query
  • From: Doug
• Re: Not grasping outer joins for ms-sqlserver :: 3 tables to join
  • From: Doug
• Re: Data Warehouse Nulls
  • From: Doug
• Re: Help!! Query takes too long
  • From: The RelentlessOne
• Re: Getting list of recently added IDENTITY items
  • From: Hugo Kornelis
• Data Warehouse Nulls
  • From: sheltielover1
• Re: Error in Query
  • From: DickChristoph
• Selecting records by date - need a little help
  • From: CK
• Getting previous values of a field
  • From: devi
• Re: Finding the natural key
  • From: Anith Sen
• Not grasping outer joins for ms-sqlserver :: 3 tables to join
  • From: Brian Parker
• Re: 2005 Database Mirroring & Witness
  • From: John P. Marshall
• Re: Identifying "filler"
  • From: Anith Sen
• Finding the natural key
  • From: pb648174
• Re: Getting list of recently added IDENTITY items
  • From: pb648174
• Browser Time Out: when executing a DTS package
  • From: Al-Pacino
• Re: 2005 Database Mirroring & Witness
  • From: Tom Moreau
• Re: DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
  • From: Erland Sommarskog
• Re: General Question about doing calculations in SQL
  • From: chudson007
• Re: 2005 Database Mirroring & Witness
  • From: Ryan
• Error in Query
  • From: Miks
• Re: DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
  • From: Prince
• Re: DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
  • From: Erland Sommarskog
• Re: Communication betwee two tables
  • From: Erland Sommarskog
• Communication betwee two tables
  • From: lucky
• DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
  • From: Prince
• Communication betwee two tables
  • From: lucky
• Re: 2005 Database Mirroring & Witness
  • From: Greg D. Moore \(Strider\)
• Re: ORDER BY in VIEW not working
  • From: Bart
• Re: Values of two columns in two different tables--presentation using select
  • From: Erland Sommarskog
• Re: Error (8626) while inserting record into table with text field and which is the base for indexed view
  • From: Erland Sommarskog
• Re: convert a datatype
  • From: Erland Sommarskog
• Re: Timeout expired
  • From: Erland Sommarskog
• Re: Plz Help!!
  • From: Erland Sommarskog
• Re: views dependent on other views
  • From: Erland Sommarskog
• Re: views dependent on other views
  • From: Hugo Kornelis
• Re: Identifying "filler"
  • From: Hugo Kornelis
• One of two subscribers not in sync - Replication
  • From: KR
• views dependent on other views
  • From: lukster
• Re: Different query plans for view and view definition statement
  • From: ysfinks
• Re: 2005 Database Mirroring & Witness
  • From: John P. Marshall
• Plz Help!!
  • From: MrNovice
• Re: Greatest value
  • From: markc600
• Greatest value
  • From: Marv Arnold
• Re: SQL Server 2005 vs Ascential
  • From: David Portas
• Re: General Question about doing calculations in SQL
  • From: jim_geissman
• SQL Server 2005 vs Ascential
  • From: jim_geissman
• General Question about doing calculations in SQL
  • From: chudson007
• Identifying "filler"
  • From: jim_geissman
• Timeout expired
  • From: pb648174
• 2005 Database Mirroring & Witness
  • From: Ryan
• Re: convert a datatype
  • From: Anith Sen
• Re: convert a datatype
  • From: Jens
• convert a datatype
  • From: surya
• Re: looking to collect distinct date part out of datetime field
  • From: Madhivanan
• Re: Values of two columns in two different tables--presentation using select
  • From: Madhivanan
• Re: Getting list of recently added IDENTITY items
  • From: pb648174
• Error (8626) while inserting record into table with text field and which is the base for indexed view
  • From: ing42
• Integrated Services
  • From: Traveller
• Re: Send 2 SQL statements using Integrated services
  • From: Traveller
• Re: Values of two columns in two different tables--presentation using select
  • From: satish
• Re: Values of two columns in two different tables--presentation using select
  • From: David Portas
• Values of two columns in two different tables--presentation using select
  • From: satish
• Re: Execution Plan Hinting
  • From: Dan Guzman
• Re: Getting list of recently added IDENTITY items
  • From: David Portas
• Re: Problems with SQL 2000 and 2005 on same machine - Can't connect on 2000
  • From: Erland Sommarskog
• Re: Execution Plan Hinting
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: Anith Sen
• Re: Getting list of recently added IDENTITY items
  • From: Erland Sommarskog
• Re: Pipe delimiter problem
  • From: Erland Sommarskog
• Re: Naming syntax in 2005
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: David Portas
• Re: Different query plans for view and view definition statement
  • From: Doug
• Re: Naming syntax in 2005
  • From: newtophp2000
• Re: Getting list of recently added IDENTITY items
  • From: Doug
• Re: Getting list of recently added IDENTITY items
  • From: Doug
• Re: Getting list of recently added IDENTITY items
  • From: pb648174
• Re: New XML Schema Video Tutorial
  • From: Stylus Studio
• [ANNOUCE] New XML Schema Video Tutorial
  • From: Stylus Studio
• Re: Execution Plan Hinting
  • From: Ryan
• Re: Execution Plan Hinting
  • From: Ryan
• Re: Getting list of recently added IDENTITY items
  • From: David Portas
• Re: Execution Plan Hinting
  • From: Dan Guzman
• Problems with SQL 2000 and 2005 on same machine - Can't connect on 2000
  • From: lourivalsjr
• Re: Pipe delimiter problem
  • From: chudson007
• Re: Getting list of recently added IDENTITY items
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: David Portas
• Re: Execution Plan Hinting
  • From: Ryan
• Re: Getting list of recently added IDENTITY items
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: David Portas
• Re: Naming syntax in 2005
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: Erland Sommarskog
• Re: UPDATE Statement Involving Tables in Different Databases
  • From: Erland Sommarskog
• Re: Different query plans for view and view definition statement
  • From: --CELKO--
• Re: Naming syntax in 2005
  • From: Hugo Kornelis
• Re: Getting list of recently added IDENTITY items
  • From: --CELKO--
• Re: Naming syntax in 2005
  • From: MGFoster
• Naming syntax in 2005
  • From: newtophp2000
• Re: UPDATE Statement Involving Tables in Different Databases
  • From: Doug
• Re: Different query plans for view and view definition statement
  • From: Doug
• Re: Getting list of recently added IDENTITY items
  • From: Doug
• Re: UPDATE Statement Involving Tables in Different Databases
  • From: Altemir
• Re: freeTDS ODBC
  • From: Fabrizio Magni
• Re: Identifying Duplicates in a table
  • From: Miks
• Re: Getting list of recently added IDENTITY items
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: David Portas
• Re: SQL Server Scanning Tables
  • From: Dan Guzman
• Re: looking to collect distinct date part out of datetime field
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: David Portas
• Re: looking to collect distinct date part out of datetime field
  • From: sdowney717@xxxxxxx
• Re: Getting list of recently added IDENTITY items
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: David Portas
• Re: Changing Machine Names MSDE
  • From: Erland Sommarskog
• Re: Execution Plan Hinting
  • From: Dan Guzman
• Re: dbcc shrinkfile - SQL Server 2000 - invalidate log?
  • From: Erland Sommarskog
• Re: Linked Server via ODBC and stored procedure
  • From: Erland Sommarskog
• Re: Different query plans for view and view definition statement
  • From: Erland Sommarskog
• Re: Execution Plan Hinting
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: Erland Sommarskog
• Re: Pipe delimiter problem
  • From: Erland Sommarskog
• Re: looking to collect distinct date part out of datetime field
  • From: Erland Sommarskog
• Re: Identifying Duplicates in a table
  • From: Miks
• Re: Execution Plan Hinting
  • From: Dan Guzman
• Re: Execution Plan Hinting
  • From: Dan Guzman
• Re: looking to collect distinct date part out of datetime field
  • From: sdowney717@xxxxxxx
• looking to collect distinct date part out of datetime field
  • From: sdowney717@xxxxxxx
• Identifying Duplicates in a table
  • From: chudson007
• Pipe delimiter problem
  • From: chudson007
• Re: Getting list of recently added IDENTITY items
  • From: David Portas
• Re: Getting list of recently added IDENTITY items
  • From: David Portas
• Re: Getting list of recently added IDENTITY items
  • From: pb648174
• Re: Too Many SET Options
  • From: Erland Sommarskog
• Re: Optimization jobs - transaction deadlock victim
  • From: Erland Sommarskog
• Re: Syntax of updating table variables?
  • From: sean . gilbertson
• Re: Syntax of updating table variables?
  • From: David Portas
• Re: Different query plans for view and view definition statement
  • From: ysfinks
• Syntax of updating table variables?
  • From: sean . gilbertson
• Re: User-defined function and temporary tables
  • From: sean . gilbertson
• User-defined function and temporary tables
  • From: sean . gilbertson
• Linked Server via ODBC and stored procedure
  • From: chloe . crowder
• Re: Too Many SET Options
  • From: ZeldorBlat
• Re: dbcc shrinkfile - SQL Server 2000 - invalidate log?
  • From: deebeeay@xxxxxxxxx
• Re: Optimization jobs - transaction deadlock victim
  • From: traceable1
• SQL Server Scanning Tables
  • From: Miks
• Too Many SET Options
  • From: Dil
• freeTDS ODBC
  • From: Ajay
• Re: dbcc shrinkfile - SQL Server 2000 - invalidate log?
  • From: David Portas
• Re: dbcc shrinkfile - SQL Server 2000 - invalidate log?
  • From: deebeeay@xxxxxxxxx
• Transactional Replication with Immediate updation DBNETLIB problem.
  • From: prashant
• Re: dbcc shrinkfile - SQL Server 2000 - invalidate log?
  • From: David Portas
• Re: dbcc shrinkfile - SQL Server 2000 - invalidate log?
  • From: deebeeay@xxxxxxxxx
• Re: dbcc shrinkfile - SQL Server 2000 - invalidate log?
  • From: David Portas
• dbcc shrinkfile - SQL Server 2000 - invalidate log?
  • From: deebeeay@xxxxxxxxx
• Re: Memory limitations, 2005 Standard
  • From: IM
• Re: Appending tables
  • From: Erland Sommarskog
• Re: can i increment the column (c1+2) ---by creating the trigger
  • From: Jack Vamvas
• Re: Appending tables
  • From: Shwetabh
• can i increment the column (c1+2) ---by creating the trigger
  • From: satish
• Re: sql query in vb
  • From: Erland Sommarskog
• Re: how to install 64-bit version?
  • From: sql_server_user
• Re: Memory limitations, 2005 Standard
  • From: Erland Sommarskog
• Re: how to install 64-bit version?
  • From: Erland Sommarskog
• Re: Optimization jobs - transaction deadlock victim
  • From: Erland Sommarskog
• Re: Different query plans for view and view definition statement
  • From: Erland Sommarskog
• Re: Execution Plan Hinting
  • From: Erland Sommarskog
• Re: Appending tables
  • From: Erland Sommarskog
• Re: Different query plans for view and view definition statement
  • From: ysfinks
• Re: Optimization jobs - transaction deadlock victim
  • From: DickChristoph
• Re: Different query plans for view and view definition statement
  • From: Alexander Kuznetsov
• Different query plans for view and view definition statement
  • From: ysfinks
• Re: Optimization jobs - transaction deadlock victim
  • From: traceable1
• Re: Optimization jobs - transaction deadlock victim
  • From: Joe Weinstein
• Optimization jobs - transaction deadlock victim
  • From: traceable1
• how to install 64-bit version?
  • From: sql_server_user
• Re: Help optmizing a stored proc
  • From: CK
• Re: Help optmizing a stored proc
  • From: figital
• Re: Update a uniqueidentifier from a string!!!
  • From: Mike R
• Help optmizing a stored proc
  • From: CK
• Re: Execution Plan Hinting
  • From: Alexander Kuznetsov
• Re: Can't fit results of tsql query in excel
  • From: David Portas
• Re: Update a uniqueidentifier from a string!!!
  • From: Jack Vamvas
• Update a uniqueidentifier from a string!!!
  • From: Mike R
• Re: Speed up Bulk Update
  • From: Ben
• Re: SQLInjection with OpenXML
  • From: Erland Sommarskog
• Memory limitations, 2005 Standard
  • From: IM
• SQLInjection with OpenXML
  • From: figital
• Re: Execution Plan Hinting
  • From: Ryan
• Problem connecting AS400/DB2 with SSIS
  • From: mortenol
• Re: Can't fit results of tsql query in excel
  • From: RA
• Re: Execution Plan Hinting
  • From: Dan Guzman
• Re: Speed up Bulk Update
  • From: Greg D. Moore \(Strider\)
• Re: Can a stored procedure parameter be optional
  • From: SQL
• Re: sql query in vb
  • From: Jens
• sql query in vb
  • From: GANESH NAIDU
• Execution Plan Hinting
  • From: Ryan
• Re: Possibly simple query but I'm not good enough to fathom it!
  • From: Astra
• Re: Possibly simple query but I'm not good enough to fathom it!
  • From: Astra
• Re: sum with increment
  • From: cahyadi
• Re: sum with increment
  • From: MC
• Re: Divide by Zero
  • From: MC
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Re: Appending tables
  • From: Shwetabh
• Re: Appending tables
  • From: Shwetabh
• Re: ORDER BY in VIEW not working
  • From: --CELKO--
• Re: Query Brain Teaser - Revenue Projections
  • From: datagal
• Re: ORDER BY in VIEW not working
  • From: Doug
• Re: Getting list of recently added IDENTITY items
  • From: Doug
• Re: sum with increment
  • From: cahyadi
• Re: PK
  • From: Mark D Powell
• Re: need help to take the variables associated with the 1st occurrence of a date variable
  • From: Erland Sommarskog
• Re: Speed up Bulk Update
  • From: Erland Sommarskog
• Re: bcp with format file
  • From: KR
• Re: Possibly simple query but I'm not good enough to fathom it!
  • From: Erland Sommarskog
• Re: Getting list of recently added IDENTITY items
  • From: Erland Sommarskog
• Re: Query Brain Teaser - Revenue Projections
  • From: datagal
• Re: need help to take the variables associated with the 1st occurrence of a date variable
  • From: Alexander Kuznetsov
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Re: bcp with format file
  • From: Erland Sommarskog
• Re: need help to take the variables associated with the 1st occurrence of a date variable
  • From: Doug
• Re: ORDER BY in VIEW not working
  • From: RickW
• Re: Can a stored procedure parameter be optional
  • From: Erland Sommarskog
• Re: Appending tables
  • From: Erland Sommarskog
• Re: sum with increment
  • From: Doug
• Re: Appending tables
  • From: Doug
• Re: how to write one stored procedure for a (same column )present in 20 tables
  • From: Doug
• Re: Can a stored procedure parameter be optional
  • From: Doug
• Re: ORDER BY in VIEW not working
  • From: Alexander Kuznetsov
• Re: Can't fit results of tsql query in excel
  • From: Doug
• Re: Query Brain Teaser - Revenue Projections
  • From: Doug
• Getting list of recently added IDENTITY items
  • From: pb648174
• Re: ORDER BY in VIEW not working
  • From: Doug
• Re: Query assistance
  • From: datagal
• Possibly simple query but I'm not good enough to fathom it!
  • From: Laphan
• Re: ORDER BY in VIEW not working
  • From: RickW
• Re: Query assistance
  • From: cory . craig
• Query assistance
  • From: cory . craig
• Speed up Bulk Update
  • From: Ben
• bcp with format file
  • From: KR
• Re: ORDER BY in VIEW not working
  • From: Serge Rielau
• need help to take the variables associated with the 1st occurrence of a date variable
  • From: menglin . cao
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Query Brain Teaser - Revenue Projections
  • From: datagal
• Re: ORDER BY in VIEW not working
  • From: RickW
• Re: PK
  • From: David Portas
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Re: PK
  • From: yangyang
• Re: Divide by Zero
  • From: yangyang
• Re: ORDER BY in VIEW not working
  • From: Serge Rielau
• Can't fit results of tsql query in excel
  • From: roman . ali
• Re: Divide by Zero
  • From: SQL
• Divide by Zero
  • From: Joriveek
• PK
  • From: J
• Re: Special characters in MSSQL.
  • From: kenneth . osenbroch
• Re: Can a stored procedure parameter be optional
  • From: --CELKO--
• Re: Use MS SQL Server 2005 Developer version to open MDF file?
  • From: Tim
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Sybase tool to manage database
  • From: PaulR
• Re: ORDER BY in VIEW not working
  • From: Serge Rielau
• Re: Appending tables
  • From: Shwetabh
• Re: how to write one stored procedure for a (same column )present in 20 tables
  • From: MC
• Re: Appending tables
  • From: Shwetabh
• how to write one stored procedure for a (same column )present in 20 tables
  • From: satish
• Re: Appending tables
  • From: David Portas
• MSDE 2000 changing disablenetworkprotocols after installation
  • From: Astra
• Re: sum with increment
  • From: David Portas
• Re: Appending tables
  • From: Shwetabh
• Re: Convert VARCHAR into Money Value
  • From: Erland Sommarskog
• Re: Appending tables
  • From: Erland Sommarskog
• Re: Appending tables
  • From: David Portas
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Appending tables
  • From: Shwetabh
• Re: ORDER BY in VIEW not working
  • From: RickW
• Convert VARCHAR into Money Value
  • From: Woodies_46
• Changing Machine Names MSDE
  • From: Frank Bishop
• sum with increment
  • From: cahyadi
• Re: Stored Procedure
  • From: Shwetabh
• Re: ORDER BY in VIEW not working
  • From: Serge Rielau
• Re: ORDER BY in VIEW not working
  • From: --CELKO--
• Re: beginner: "Login failed for user 'sa'."
  • From: Erland Sommarskog
• Re: Problem with database filegroup restructuring in SQL Server?
  • From: Erland Sommarskog
• Re: How to check if DB Constraints are enabled in a database?
  • From: Erland Sommarskog
• Re: Out of range datetime value error when inserting using select...union
  • From: Erland Sommarskog
• Re: itzik ben-gan
  • From: Erland Sommarskog
• Re: slecting multiple distinct columns..
  • From: Erland Sommarskog
• Re: Special characters in MSSQL.
  • From: Erland Sommarskog
• Re: inserted the image in a column----how can i view the image
  • From: Erland Sommarskog
• Re: Can a stored procedure parameter be optional
  • From: Erland Sommarskog
• Re: How does one set read-uncommitted on the entire DB?
  • From: Erland Sommarskog
• Re: ORDER BY in VIEW not working
  • From: Serge Rielau
• Re: Can a stored procedure parameter be optional
  • From: SQL
• Re: Can a stored procedure parameter be optional
  • From: Tom Moreau
• Re: ORDER BY in VIEW not working
  • From: RickW
• Can a stored procedure parameter be optional
  • From: CK
• Re: slecting multiple distinct columns..
  • From: jennifer1970
• Re: ORDER BY in VIEW not working
  • From: Alexander Kuznetsov
• Re: Fast look up of long (n)varchar
  • From: John Bokma
• Re: ORDER BY in VIEW not working
  • From: RickW
• Changing subnets help?
  • From: sjoshi
• Re: troubleshooting data updates
  • From: KR
• Re: ORDER BY in VIEW not working
  • From: Serge Rielau
• Re: itzik ben-gan
  • From: SQL
• Re: itzik ben-gan
  • From: Doug
• Re: beginner: "Login failed for user 'sa'."
  • From: SQL
• beginner: "Login failed for user 'sa'."
  • From: Andrzej Magdziarz
• Re: How can I do amalgamate 3 select queries and then get unique entries from the result
  • From: markc600
• How can I do amalgamate 3 select queries and then get unique entries from the result
  • From: Astra
• Re: troubleshooting data updates
  • From: Jack Vamvas
• Re: inserted the image in a column----how can i view the image
  • From: Jack Vamvas
• Re: Newbie - Help required with Query (sample tables/data included)
  • From: Greg D. Moore \(Strider\)
• Re: Stored Procedure
  • From: Dan Guzman
• Stored Procedure
  • From: Shwetabh
• inserted the image in a column----how can i view the image
  • From: satish
• Re: Special characters in MSSQL.
  • From: kenneth . osenbroch
• Re: Special characters in MSSQL.
  • From: m . bohse
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Special characters in MSSQL.
  • From: kenneth . osenbroch
• Re: ORDER BY in VIEW not working
  • From: RickW
• Re: ORDER BY in VIEW not working
  • From: Serge Rielau
• slecting multiple distinct columns..
  • From: vvyshak
• Re: Fast look up of long (n)varchar
  • From: Doug
• Re: Newbie - Help required with Query (sample tables/data included)
  • From: Doug
• Re: ORDER BY in VIEW not working
  • From: RickW
• Re: itzik ben-gan
  • From: --CELKO--
• Re: ORDER BY in VIEW not working
  • From: --CELKO--
• Re: Newbie - Help required with Query (sample tables/data included)
  • From: --CELKO--
• Re: ORDER BY in VIEW not working
  • From: RickW
• itzik ben-gan
  • From: jacob . dba
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Re: ORDER BY in VIEW not working
  • From: RickW
• Re: How does one set read-uncommitted on the entire DB?
  • From: pb648174
• troubleshooting data updates
  • From: KR
• Re: Newbie - Help required with Query (sample tables/data included)
  • From: Dave
• Does anyone know what the "Option value changed" error message is?
  • From: Erich93063
• Re: How to check if DB Constraints are enabled in a database?
  • From: sarada7
• Re: ORDER BY in VIEW not working
  • From: David Portas
• Re: Fast look up of long (n)varchar
  • From: Alexander Kuznetsov
• Fast look up of long (n)varchar
  • From: John Bokma
• Re: ORDER BY in VIEW not working
  • From: RickW
• Out of range datetime value error when inserting using select...union
  • From: suslikovich
• Re: How to check if DB Constraints are enabled in a database?
  • From: sarada7
• Re: How to check if DB Constraints are enabled in a database?
  • From: ZeldorBlat
• Re: How to check if DB Constraints are enabled in a database?
  • From: sarada7
• Re: How to check if DB Constraints are enabled in a database?
  • From: ZeldorBlat
• Re: Newbie - Help required with Query (sample tables/data included)
  • From: --CELKO--
• How to check if DB Constraints are enabled in a database?
  • From: sarada7
• Problem with database filegroup restructuring in SQL Server?
  • From: jkv10_2005
• Re: Newbie - Help required with Query (sample tables/data included)
  • From: Dave
• Re: Newbie - Help required with Query (sample tables/data included)
  • From: Razvan Socol
• Re: Problem with variable of type money?
  • From: Doug
• Re: what are cursors in sql???
  • From: Doug
• Newbie - Help required with Query (sample tables/data included)
  • From: Dave
• Re: Help with Query
  • From: Hugo Kornelis
• Re: Help with Query
  • From: Tom Moreau
• Help with Query
  • From: Crumb
• Re: Statistics IO logical reads sometimes 15 million and other times down to 90 thousand?
  • From: serge
• Re: SQL Server: beginner: "Login failed for user 'sa'."
  • From: Jens
• SQL Server: beginner: "Login failed for user 'sa'."
  • From: R . A . M .
• Re: Statistics IO logical reads sometimes 15 million and other times down to 90 thousand?
  • From: serge
• Re: Statistics IO logical reads sometimes 15 million and other times down to 90 thousand?
  • From: Erland Sommarskog
• Re: Space Available Within A Filegroup
  • From: Erland Sommarskog
• Re: Problem with variable of type money?
  • From: Erland Sommarskog
• Re: Problem with variable of type money?
  • From: figital
• Space Available Within A Filegroup
  • From: Greg . Harabedian
• Re: what are cursors in sql???
  • From: --CELKO--
• Re: what are cursors in sql???
  • From: HS_Ted
• Re: MSSQL Query Memory when using long fields
  • From: Doug
• Re: Statistics IO logical reads sometimes 15 million and other times down to 90 thousand?
  • From: serge
• Statistics IO logical reads sometimes 15 million and other times down to 90 thousand?
  • From: serge
• Re: Insert first n columns from select
  • From: Doug
• Re: Optimizing a JOIN
  • From: Doug
• Re: MSSQL Query Memory when using long fields
  • From: Erland Sommarskog
• Re: Problem with variable of type money?
  • From: Doug
• Re: Referential Integrity - linking multiple tables to transaction table
  • From: Doug
• Re: Referential Integrity - linking multiple tables to transaction table
  • From: Erland Sommarskog
• Re: what are cursors in sql???
  • From: Doug
• Re: what are cursors in sql???
  • From: Doug
• Re: Insert first n columns from select
  • From: David Portas
• Re: Insert first n columns from select
  • From: carlospedr
• Re: Query Memory?
  • From: MB
• Query Memory?
  • From: MB
• Re: Referential Integrity - linking multiple tables to transaction table
  • From: heyvinay
• Re: Referential Integrity - linking multiple tables to transaction table
  • From: Erland Sommarskog
• Re: Referential Integrity - linking multiple tables to transaction table
  • From: heyvinay
• Re: Referential Integrity - linking multiple tables to transaction table
  • From: markc600
• Referential Integrity - linking multiple tables to transaction table
  • From: heyvinay
• 1 day left: 75% discount on SQL Server/Oracle/MySQL/Firebird/InterBase developer tool!
  • From: Martijn Tonies
• Re: Problem with variable of type money?
  • From: Erland Sommarskog
• Re: Preventing SQL Injection attacks
  • From: Erland Sommarskog
• Re: what are cursors in sql???
  • From: --CELKO--
• Re: Insert first n columns from select
  • From: --CELKO--
• Re: How does one set read-uncommitted on the entire DB?
  • From: Erland Sommarskog
• Re: How to have strings automatically truncated?
  • From: Erland Sommarskog
• Re: what are cursors in sql???
  • From: David Portas
• Re: Preventing SQL Injection attacks
  • From: Kevin Audleman
• Re: Problem with variable of type money?
  • From: figital
• Re: Preventing SQL Injection attacks
  • From: jennifer1970
• Re: Preventing SQL Injection attacks
  • From: jennifer1970
• Preventing SQL Injection attacks
  • From: Kevin Audleman
• Re: Optimizing a JOIN
  • From: rkershberg@xxxxxxxxx
• Re: what are cursors in sql???
  • From: Doug
• Re: Insert first n columns from select
  • From: Doug
• Re: Optimizing a JOIN
  • From: rkershberg@xxxxxxxxx
• Re: Convert Sting to Date
  • From: Erland Sommarskog
• Re: Problem with variable of type money?
  • From: helmut woess
• Re: Insert first n columns from select
  • From: --CELKO--
• Re: what are cursors in sql???
  • From: --CELKO--
• Re: Select row with only ONE occurence
  • From: das
• MSSQL Query Memory when using long fields
  • From: wildfyre53207
• Problem with variable of type money?
  • From: bartvanhemelen
• Re: what are cursors in sql???
  • From: Stu
• Re: Convert Sting to Date
  • From: Madhivanan
• Re: Can I do this in SQL Analyzer or with a dts package?
  • From: figital
• Re: Select row with only ONE occurence
  • From: figital
• Re: Convert Sting to Date
  • From: lightning-dave
• Re: what are cursors in sql???
  • From: David Portas
• Logshipping Corruption Problem
  • From: lightning-dave
• Re: Convert Sting to Date
  • From: Crumb
• Re: How to have strings automatically truncated?
  • From: John Bokma
• Re: Convert Sting to Date
  • From: Erland Sommarskog
• Re: How to have strings automatically truncated?
  • From: Erland Sommarskog
• how to import image jpeg file to table in oracle
  • From: leecholim
• Re: How to avoid cursors
  • From: Doug
• Re: what are cursors in sql???
  • From: Doug
• Re: Optimizing a JOIN
  • From: Doug
• Re: Automating record selection parameters
  • From: Doug
• Re: comma deliminited coloumn
  • From: --CELKO--
• Re: How to have strings automatically truncated?
  • From: John Bokma
• Re: restore sql 7db to sql2000
  • From: DickChristoph
• Re: Use MS SQL Server 2005 Developer version to open MDF file?
  • From: DickChristoph
• Re: How does one set read-uncommitted on the entire DB?
  • From: Robert
• Re: Can I do this in SQL Analyzer or with a dts package?
  • From: DickChristoph
• Re: getting the matching columns from two tables
  • From: Hugo Kornelis
• Re: Convert Sting to Date
  • From: Crumb
• Re: How to have strings automatically truncated?
  • From: Erland Sommarskog
• Re: Difference Between NULL and Blank in SQL
  • From: Erland Sommarskog
• Re: Use MS SQL Server 2005 Developer version to open MDF file?
  • From: Erland Sommarskog
• Re: How does one set read-uncommitted on the entire DB?
  • From: Erland Sommarskog
• Re: comma deliminited coloumn
  • From: Erland Sommarskog
• Re: Convert Sting to Date
  • From: Erland Sommarskog
• Re: Executing a Views from a Trigger
  • From: Erland Sommarskog
• Re: Automating record selection parameters
  • From: Erland Sommarskog
• Re: Select row with only ONE occurence
  • From: Alexander Kuznetsov
• Select row with only ONE occurence
  • From: das
• Re: comma deliminited coloumn
  • From: cholmqui
• Re: more date problems...
  • From: MGFoster
• Re: comma deliminited coloumn
  • From: MGFoster
• Re: Reasonable to assemble FullName W/ A UDF
  • From: pb648174
• Convert Sting to Date
  • From: Crumb
• Re: Difference Between NULL and Blank in SQL
  • From: Gert-Jan Strik
• Re: Optimizing a JOIN
  • From: Gert-Jan Strik
• comma deliminited coloumn
  • From: cholmqui
• Can I do this in SQL Analyzer or with a dts package?
  • From: mike
• Re: getting the matching columns from two tables
  • From: carlospedr
• How does one set read-uncommitted on the entire DB?
  • From: Robert
• Use MS SQL Server 2005 Developer version to open MDF file?
  • From: Tim
• Re: Executing a Views from a Trigger
  • From: solidsna2
• Re: Executing a Views from a Trigger
  • From: DickChristoph
• more date problems...
  • From: zerbie45
• Re: Executing a Views from a Trigger
  • From: solidsna2
• Re: Executing a Views from a Trigger
  • From: DickChristoph
• Re: Executing a Views from a Trigger
  • From: Martijn Tonies
• Re: tools for analysis relations
  • From: DickChristoph
• Re: Difference Between NULL and Blank in SQL
  • From: figital
• Re: tools for analysis relations
  • From: figital
• http://sqlserver.startpagina.nl/
  • From: waanders
• Re: Executing a Views from a Trigger
  • From: solidsna2
• Executing a Views from a Trigger
  • From: solidsna2
• Re: Insert first n columns from select
  • From: carlospedr
• Re: Converting Traceid issue
  • From: michael via SQLMonster.com
• Re: Insert first n columns from select
  • From: Jack Vamvas
• Re: Reasonable to assemble FullName W/ A UDF
  • From: figital
• Re: restore sql 7db to sql2000
  • From: figital
• Re: Checking for existing column
  • From: Jack Vamvas
• Re: Converting Traceid issue
  • From: michaelgangeri via SQLMonster.com
• Re: Cannot connect to a new installed SQL Server 2000
  • From: helmut woess
• Cannot connect to a new installed SQL Server 2000
  • From: bitchanger
• SQL cache so GREEDY?
  • From: Marek Wierzbicki
• Re: Difference Between NULL and Blank in SQL
  • From: helmut woess
• Insert first n columns from select
  • From: carlospedr
• Re: Create New Table advice
  • From: Jack Vamvas
• getting the matching columns from two tables
  • From: vvyshak
• Re: what are cursors in sql???
  • From: David Portas
• Re: torn page detection and auto shrink: performance?
  • From: Matik
• Difference Between NULL and Blank in SQL
  • From: Shwetabh
• Re: torn page detection and auto shrink: performance?
  • From: Matik
• Checking for existing column
  • From: Shwetabh
• Re: tools for analysis relations
  • From: stemon79
• ANN: 75% off on Database Workbench, only 3 days left!
  • From: Martijn Tonies
• Re: How to avoid cursors
  • From: sjoshi
• Optimizing a JOIN
  • From: rkershberg@xxxxxxxxx
• Re: How to have strings automatically truncated?
  • From: ZeldorBlat
• Re: what are cursors in sql???
  • From: Doug
• Re: Create New Table advice
  • From: Greg D. Moore \(Strider\)
• Re: Automating record selection parameters
  • From: Doug
• Re: How to avoid cursors
  • From: Doug
• How to have strings automatically truncated?
  • From: John Bokma
• Re: SQL Server 2K Linked Access 97 Server not working
  • From: David Kirkman
• Re: How to avoid cursors
  • From: Erland Sommarskog
• Reasonable to assemble FullName W/ A UDF
  • From: wackyphill
• Re: restore sql 7db to sql2000
  • From: Erland Sommarskog
• Re: Converting Traceid issue
  • From: Erland Sommarskog
• Re: Group By Query Help
  • From: wackyphill
• Re: restore sql 7db to sql2000
  • From: sarahlin
• Re: Group By Query Help
  • From: Erland Sommarskog
• Re: restore sql 7db to sql2000
  • From: Erland Sommarskog
• Re: torn page detection and auto shrink: performance?
  • From: Erland Sommarskog

We are proud to have Web Hosting and Rack Housing from 9 Net Avenue Deutschland.
(16)