comp.databases.ms-sqlserver

• Thread Index

---

• Re: Syntax to access database on another server
  • From: compquest
• ANN: Beta release of SiSense Prism - Do-It-Yourself Dashboards, Reports, Guided Analytics and Business Presentations
  • From: Erins . Ghost
• Re: Use opendatasource or similar to access sage line 50 ODBC DSN
  • From: Tom van Stiphout
• Use opendatasource or similar to access sage line 50 ODBC DSN
  • From: Iain Sharp
• Re: Track changes made to SQL Server
  • From: Mork69
• Re: Track changes made to SQL Server
  • From: John Sheppard
• Re: Track changes made to SQL Server
  • From: John Sheppard
• Re: Track changes made to SQL Server
  • From: John Sheppard
• Re: Transfering data from SQL Server Standard to SQL Server Express
  • From: Erland Sommarskog
• Re: Using findstr on SQL 2005 ERRORLOG file
  • From: Erland Sommarskog
• Re: Why Same query results in two different # in SQL Server vs MS Access
  • From: dsdevonsomer
• Using findstr on SQL 2005 ERRORLOG file
  • From: Teresa Masino
• Transfering data from SQL Server Standard to SQL Server Express
  • From: tapsavirtanen
• Re: Query - select common data from one column and display in several columns
  • From: Plamen Ratchev
• Re: Track changes made to SQL Server
  • From: John Sheppard
• Re: Query - select common data from one column and display in several columns
  • From: Dan Guzman
• Re: Query - select common data from one column and display in several columns
  • From: rui dias
• Re: Query - select common data from one column and display in several columns
  • From: czytacz
• Re: Query - select common data from one column and display in several columns
  • From: Mark
• Query - select common data from one column and display in several columns
  • From: rui dias
• ado net
  • From: Analizer1
• Re: Problem with a lot of inserts in short time - SQL Server 2000
  • From: Erland Sommarskog
• Re: Error on Trigger Launch
  • From: Erland Sommarskog
• Re: Using a "match" table to store multiple columns for parent data
  • From: Erland Sommarskog
• Re: Error on Trigger Launch
  • From: Hugo Kornelis
• Re: reduce time for search query
  • From: Hugo Kornelis
• Using a "match" table to store multiple columns for parent data
  • From: wfsmith
• Re: Track changes made to SQL Server
  • From: xman
• Re: Error on Trigger Launch
  • From: pyrahna
• Re: reduce time for search query
  • From: jan . afzal
• How to reproduce Exchange Spill, Hash Warning and Execution Warning Events ?
  • From: Bakshi
• Re: Crosstabbing (or rotating) a sql table
  • From: mr . mcgoo
• Deleting a maintenance plan
  • From: Neil
• Re: sql query which has got 3 dynamic parameters
  • From: Vic
• Re: Error on Trigger Launch
  • From: Erland Sommarskog
• Re: Error on Trigger Launch
  • From: Hugo Kornelis
• Re: [SQL query] Generate a report from events?
  • From: Erland Sommarskog
• Re: reduce time for search query
  • From: Hugo Kornelis
• Re: sql query which has got 3 dynamic parameters
  • From: Erland Sommarskog
• Re: Syntax to access database on another server
  • From: Jack Vamvas
• Problem with a lot of inserts in short time - SQL Server 2000
  • From: edi
• Re: Help setting up stored procedure
  • From: JJ297
• Re: Help setting up stored procedure
  • From: Plamen Ratchev
• Help setting up stored procedure
  • From: JJ297
• Re: sql query which has got 3 dynamic parameters
  • From: Vic
• Syntax to access database on another server
  • From: compquest
• [SQL query] Generate a report from events?
  • From: Władysław Bodzek
• Re: Error on Trigger Launch
  • From: pyrahna
• Error on Trigger Launch
  • From: pyrahna
• Re: Error on Transaction log backup
  • From: Dan Guzman
• Error on Transaction log backup
  • From: David Greenberg
• Backup Exec and MS SQL Server 2005
  • From: Jens
• Re: Track changes made to SQL Server
  • From: Erland Sommarskog
• Track changes made to SQL Server
  • From: John Sheppard
• Re: sql query which has got 3 dynamic parameters
  • From: Vic
• Re: sql query which has got 3 dynamic parameters
  • From: Erland Sommarskog
• Re: DB size increase from SQL 2000 to 2005
  • From: Erland Sommarskog
• Re: sql query which has got 3 dynamic parameters
  • From: Vic
• Re: sql query which has got 3 dynamic parameters
  • From: Vic
• Re: DB size increase from SQL 2000 to 2005
  • From: Artie
• Re: help with update
  • From: Analizer1
• Re: change structure of a simple query
  • From: Ina
• Need help with SQL Server Cluster
  • From: Chris Gelhaus
• Re: DB size increase from SQL 2000 to 2005
  • From: aj
• Re: change structure of a simple query
  • From: Plamen Ratchev
• MAINFRAME Training with IBM Certification
  • From: sonu
• Urgent IT related openings with Corporate MNC companies all over India
  • From: jobsearch.india02@xxxxxxxxx
• change structure of a simple query
  • From: Ina
• SQL database hang
  • From: velu5
• Re: sql query which has got 3 dynamic parameters
  • From: Ed Murphy
• Re: help with update
  • From: Ed Murphy
• Re: help with update
  • From: --CELKO--
• Re: SQL question ( retrieving records based on a priority order )
  • From: myemail.an@xxxxxxxxxxxxxx
• Re: calling a stored procedure in a while loop
  • From: Plamen Ratchev
• Re: calling a stored procedure in a while loop
  • From: Vic
• Re: sql query which has got 3 dynamic parameters
  • From: Vic
• Re: sql query which has got 3 dynamic parameters
  • From: Vic
• Re: calling a stored procedure in a while loop
  • From: Hugo Kornelis
• Re: sql query which has got 3 dynamic parameters
  • From: Ed Murphy
• Re: sql query which has got 3 dynamic parameters
  • From: Erland Sommarskog
• Re: sql query which has got 3 dynamic parameters
  • From: Vic
• Re: sql query which has got 3 dynamic parameters
  • From: Ed Murphy
• Re: Query string encryption in T-SQL
  • From: Tom van Stiphout
• Re: sql query which has got 3 dynamic parameters
  • From: Vic
• Re: calling a stored procedure in a while loop
  • From: Vic
• Re: Want to learn SQL in California....any school, literature recommendations?
  • From: Jack Vamvas
• Query string encryption in T-SQL
  • From: mielnik . bartek
• Re: Adding conditions in the ON clause of a JOIN
  • From: Peter Deacon
• Re: DB size increase from SQL 2000 to 2005
  • From: Erland Sommarskog
• Re: sql query which has got 3 dynamic parameters
  • From: Erland Sommarskog
• Re: help with update
  • From: Ed Murphy
• Re: sql query which has got 3 dynamic parameters
  • From: Ed Murphy
• Re: calling a stored procedure in a while loop
  • From: Plamen Ratchev
• DB size increase from SQL 2000 to 2005
  • From: Artie
• calling a stored procedure in a while loop
  • From: Vic
• Re: sql query which has got 3 dynamic parameters
  • From: Vic
• Re: help with update
  • From: --CELKO--
• Re: sql query which has got 3 dynamic parameters
  • From: Erland Sommarskog
• Re: help with update
  • From: Erland Sommarskog
• Re: UPDATETEXT question
  • From: Erland Sommarskog
• Re: SQL question ( retrieving records based on a priority order )
  • From: Plamen Ratchev
• Re: SQL question ( retrieving records based on a priority order )
  • From: Roy Harvey (SQL Server MVP)
• Re: Use unique key for Sqlserver view for updates
  • From: Tom van Stiphout
• SQL question ( retrieving records based on a priority order )
  • From: myemail.an@xxxxxxxxxxxxxx
• Re: help with update
  • From: Iain Sharp
• Re: Help with SQL Query for Graph
  • From: Plamen Ratchev
• Re: Inventory SQL Server machines on your network
  • From: Tom van Stiphout
• Help with SQL Query for Graph
  • From: -cicada-
• Re: sql query which has got 3 dynamic parameters
  • From: Vic
• sql query which has got 3 dynamic parameters
  • From: Vic
• Re: UPDATETEXT question
  • From: Artie
• Re: help with update
  • From: Erland Sommarskog
• Re: Why Same query results in two different # in SQL Server vs MS Access
  • From: Hugo Kornelis
• Re: UPDATETEXT question
  • From: Erland Sommarskog
• Re: Why Same query results in two different # in SQL Server vs MS Access
  • From: Erland Sommarskog
• UPDATETEXT question
  • From: Artie
• Re: help with update
  • From: --CELKO--
• Re: Undocumented SP help
  • From: Thefunksomecat
• help with update
  • From: Analizer1
• Re: Why Same query results in two different # in SQL Server vs MS Access
  • From: dsdevonsomer
• Re: My brain hurts. ORDER BY ( SELECT ... )
  • From: Roy Harvey (SQL Server MVP)
• Re: Normalization Pitfalls
  • From: Anith Sen
• Inventory SQL Server machines on your network
  • From: mjlefevre
• Re: Normalization Pitfalls
  • From: --CELKO--
• Re: Undocumented SP help
  • From: funksome
• Undocumented SP help
  • From: funksome
• Re: Count from detail table
  • From: Cacho
• Re: Normalization Pitfalls
  • From: Ed Murphy
• Re: My brain hurts. ORDER BY ( SELECT ... )
  • From: Plamen Ratchev
• My brain hurts. ORDER BY ( SELECT ... )
  • From: joeNOSPAM@xxxxxxx
• Re: Table replication question
  • From: zgb
• Re: Why Same query results in two different # in SQL Server vs MS Access
  • From: Erland Sommarskog
• Re: database performance (ie stored procedures.
  • From: Erland Sommarskog
• Re: Table replication question
  • From: Erland Sommarskog
• Re: Why Same query results in two different # in SQL Server vs MS Access
  • From: Hugo Kornelis
• Re: Normalization Pitfalls
  • From: David Portas
• Re: Normalization Pitfalls
  • From: --CELKO--
• database performance (ie stored procedures.
  • From: quincy451
• Normalization Pitfalls
  • From: eric.nave@xxxxxxxxx
• Why Same query results in two different # in SQL Server vs MS Access
  • From: dsdevonsomer
• Re: Want to learn SQL in California....any school, literature recommendations?
  • From: Plamen Ratchev
• Re: Count from detail table
  • From: Plamen Ratchev
• Count from detail table
  • From: Cacho
• Re: Table replication question
  • From: zgb
• Re: need of SQL Dumps
  • From: Ed Murphy
• Want to learn SQL in California....any school, literature recommendations?
  • From: Juana
• Re: need of SQL Dumps
  • From: ajax
• Re: Slow performance in SQL2005
  • From: Erland Sommarskog
• Re: print or select limits
  • From: Erland Sommarskog
• Re: Table replication question
  • From: Erland Sommarskog
• Re: print or select limits
  • From: Anith Sen
• Freshers Recruitment & Walk-in For Freshers Feb 23-24
  • From: jobsearch.india02@xxxxxxxxx
• Re: need to make faster
  • From: Greg D. Moore \(Strider\)
• Re: SQL Server Performance Issue
  • From: Andres Rormoser
• Re: Transfer data to web page fields
  • From: graformix.com - professional design studio
• Re: syncing data between mssql and mysql
  • From: graformix.com - professional design studio
• Table replication question
  • From: zgb
• Re: Slow performance in SQL2005
  • From: Tawfiq
• print or select limits
  • From: Marc
• Re: Slow performance in SQL2005
  • From: Tom van Stiphout
• Slow performance in SQL2005
  • From: Tawfiq
• Re: SQL Server Performance Issue
  • From: Dan Guzman
• Re: SQL Server Performance Issue
  • From: Dan Guzman
• Re: Online Query Tool SQL Server 2005
  • From: Erland Sommarskog
• Re: SQL Server Performance Issue
  • From: Erland Sommarskog
• Re: need of SQL Dumps
  • From: Ed Murphy
• Re: SQL Server Performance Issue
  • From: Andres Rormoser
• Re: Online Query Tool SQL Server 2005
  • From: csgraham74
• Re: Parent/Child Query: return single row from child table
  • From: hharry
• Re: Parent/Child Query: return single row from child table
  • From: Plamen Ratchev
• Parent/Child Query: return single row from child table
  • From: hharry
• Re: Online Query Tool SQL Server 2005
  • From: Erland Sommarskog
• Online Query Tool SQL Server 2005
  • From: csgraham74
• Re: Upgrading old query 7 to 2005.
  • From: Erland Sommarskog
• Re: need of SQL Dumps
  • From: ajax
• Re: Upgrading old query 7 to 2005.
  • From: valigula
• Re: Problem With SQL UPDATE
  • From: Erland Sommarskog
• Re: Problem With SQL UPDATE
  • From: SAM
• CURRENT WEEK WALKIN UPDATES - VISIT www.walkincareers.com
  • From: jobsearch.india02@xxxxxxxxx
• Re: Log File Recovery.
  • From: Erland Sommarskog
• Re: Rowlock v. optimistic concurrency
  • From: Robert Klemme
• Re: Problem With SQL UPDATE
  • From: David Portas
• Log File Recovery.
  • From: Kissi Asiedu
• Re: Upgrading old query 7 to 2005.
  • From: Erland Sommarskog
• Re: SQL Server Performance Issue
  • From: Erland Sommarskog
• Re: Problem With SQL UPDATE
  • From: Erland Sommarskog
• Re: Problem With SQL UPDATE
  • From: SAM
• Re: Problem With SQL UPDATE
  • From: David Portas
• Problem With SQL UPDATE
  • From: SAM
• Re: SQL Server Performance Issue
  • From: Andres Rormoser
• Re: SQL Server Performance Issue
  • From: Andres Rormoser
• Re: SQL Server Performance Issue
  • From: Jack Vamvas
• Re: CharIndex, Left T-SQL question
  • From: jeremy
• SQL Server Performance Issue
  • From: Andres Rormoser
• Upgrading old query 7 to 2005.
  • From: valigula
• Re: Help Needed For writting a query (SQl Server 2005).
  • From: Plamen Ratchev
• Help Needed For writting a query (SQl Server 2005).
  • From: Dinesh
• Re: importing multiple excel files
  • From: Jack Vamvas
• Re: need of SQL Dumps
  • From: Jack Vamvas
• Re: CharIndex, Left T-SQL question
  • From: Plamen Ratchev
• Re: CharIndex, Left T-SQL question
  • From: Tom van Stiphout
• Re: importing multiple excel files
  • From: Plamen Ratchev
• CharIndex, Left T-SQL question
  • From: jeremy
• Re: Rowlock v. optimistic concurrency
  • From: Erland Sommarskog
• importing multiple excel files
  • From: ciaran . hudson
• Re: How to delete doubled records in one query?
  • From: jhofmeyr
• Re: How to delete doubled records in one query?
  • From: jhofmeyr
• Re: Rowlock v. optimistic concurrency
  • From: Roger . Noreply
• Re: Tips on working around Identity column for temp tables?
  • From: Tony Rogerson
• Re: Adding conditions in the ON clause of a JOIN
  • From: Tony Rogerson
• Re: How to delete doubled records in one query?
  • From: Tom van Stiphout
• Re: How to delete doubled records in one query?
  • From: Plamen Ratchev
• Re: How to delete doubled records in one query?
  • From: Dan Guzman
• How to delete doubled records in one query?
  • From: Macio
• Re: need of SQL Dumps
  • From: Tom van Stiphout
• need of SQL Dumps
  • From: ajax
• Re: How to check setting of CONCAT_NULL_YIELDS_NULL
  • From: Plamen Ratchev
• SQL 2005 OSQL qestion on Microsoft cluster
  • From: arichie
• Re: Tips on working around Identity column for temp tables?
  • From: Erland Sommarskog
• Re: Adding conditions in the ON clause of a JOIN
  • From: Erland Sommarskog
• Re: How to check setting of CONCAT_NULL_YIELDS_NULL
  • From: Erland Sommarskog
• Re: Rowlock v. optimistic concurrency
  • From: Erland Sommarskog
• Re: Tips on working around Identity column for temp tables?
  • From: --CELKO--
• Re: Adding conditions in the ON clause of a JOIN
  • From: --CELKO--
• Re: Problems character sets / special characters dot.Net <-> mssql-server
  • From: Klaus Herzberg
• Re: Adding conditions in the ON clause of a JOIN
  • From: Plamen Ratchev
• Re: Adding conditions in the ON clause of a JOIN
  • From: Madhivanan
• Re: Enum the running SQL instances using DMO
  • From: Plamen Ratchev
• Re: How to check setting of CONCAT_NULL_YIELDS_NULL
  • From: Plamen Ratchev
• Re: Rowlock v. optimistic concurrency
  • From: Roger . Noreply
• Re: How to check setting of CONCAT_NULL_YIELDS_NULL
  • From: Erland Sommarskog
• Adding conditions in the ON clause of a JOIN
  • From: jackal_on_work
• Enum the running SQL instances using DMO
  • From: velu5
• Interactive Sort on Matrix in RS
  • From: lee.richmond
• Re: How to check setting of CONCAT_NULL_YIELDS_NULL
  • From: Plamen Ratchev
• Re: How to check setting of CONCAT_NULL_YIELDS_NULL
  • From: metaperl
• How to check setting of CONCAT_NULL_YIELDS_NULL
  • From: metaperl
• Tips on working around Identity column for temp tables?
  • From: Mamba
• Re: Problems character sets / special characters dot.Net <-> mssql-server
  • From: Erland Sommarskog
• Re: Why does Error log show database restarting everytime a transaction log backup runs?
  • From: Erland Sommarskog
• Re: syncing data between mssql and mysql
  • From: Erland Sommarskog
• Re: need to make faster
  • From: remy
• Re: syncing data between mssql and mysql
  • From: Michael
• Re: syncing data between mssql and mysql
  • From: Michael
• syncing data between mssql and mysql
  • From: Michael
• Why does Error log show database restarting everytime a transaction log backup runs?
  • From: Sanctus
• Re: Problems character sets / special characters dot.Net <-> mssql-server
  • From: Plamen Ratchev
• Urgent walkin interviews from top rated companies
  • From: jobsearch.india02@xxxxxxxxx
• Problems character sets / special characters dot.Net <-> mssql-server
  • From: Klaus Herzberg
• Re: on line discuss
  • From: sreejith s
• on line discuss
  • From: sharma . shashikanta
• Re: slow stored procedure
  • From: Shigeaki Kobayashi
• Re: Simplest way to write a boolean expression in the SELECT clause?
  • From: Tom van Stiphout
• Re: Help setting up a view
  • From: JJ297
• Re: slow stored procedure
  • From: Erland Sommarskog
• Re: Primary Key fails to copy in db Export
  • From: Erland Sommarskog
• Re: Rowlock v. optimistic concurrency
  • From: Erland Sommarskog
• Re: Simplest way to write a boolean expression in the SELECT clause?
  • From: Robert Klemme
• Re: Primary Key fails to copy in db Export
  • From: ll
• Re: need to make faster
  • From: Plamen Ratchev
• Re: need to make faster
  • From: Ed Murphy
• slow stored procedure
  • From: remylawrence
• need to make faster
  • From: remylawrence
• Re: Why does numeric data type use storage inefficiently?
  • From: residual . interest
• Re: Rowlock v. optimistic concurrency
  • From: Roger . Noreply
• Re: Rowlock v. optimistic concurrency
  • From: Roger . Noreply
• Re: System DB backup Error
  • From: Erland Sommarskog
• Re: Primary Key fails to copy in db Export
  • From: Erland Sommarskog
• Re: Proper scripting of table with belongings
  • From: Erland Sommarskog
• Re: Help setting up a view
  • From: Erland Sommarskog
• Re: Primary Key fails to copy in db Export
  • From: ll
• Help setting up a view
  • From: JJ297
• Re: Primary Key fails to copy in db Export
  • From: --CELKO--
• Proper scripting of table with belongings
  • From: Matik
• Primary Key fails to copy in db Export
  • From: ll
• Re: Simplest way to write a boolean expression in the SELECT clause?
  • From: --CELKO--
• Re: Create a new table from csv file using SSIS
  • From: Jack Vamvas
• System DB backup Error
  • From: Praveen
• Re: Simplest way to write a boolean expression in the SELECT clause?
  • From: Tom van Stiphout
• Re: Why does numeric data type use storage inefficiently?
  • From: --CELKO--
• Re: Why does numeric data type use storage inefficiently?
  • From: Hugo Kornelis
• Re: Simplest way to write a boolean expression in the SELECT clause?
  • From: --CELKO--
• Re: Simplest way to write a boolean expression in the SELECT clause?
  • From: Robert Klemme
• Re: sql server migration issues
  • From: Erland Sommarskog
• Re: Sending xp_sendmail from sql 2000
  • From: Erland Sommarskog
• Sending xp_sendmail from sql 2000
  • From: JJ297
• Re: Simplest way to write a boolean expression in the SELECT clause?
  • From: Ed Murphy
• Why does numeric data type use storage inefficiently?
  • From: residual . interest
• Re: Simplest way to write a boolean expression in the SELECT clause?
  • From: Andy M
• Create a new table from csv file using SSIS
  • From: k4
• Distributed Transactions across Linked Servers
  • From: Tim - Milwaukee
• Re: Simplest way to write a boolean expression in the SELECT clause?
  • From: --CELKO--
• Re: Simplest way to write a boolean expression in the SELECT clause?
  • From: Plamen Ratchev
• Simplest way to write a boolean expression in the SELECT clause?
  • From: Tom van Stiphout
• Re: Rowlock v. optimistic concurrency
  • From: Erland Sommarskog
• Re: Crosstabbing (or rotating) a sql table
  • From: DA Morgan
• Rowlock v. optimistic concurrency
  • From: Roger . Noreply
• Re: Crosstabbing (or rotating) a sql table
  • From: Anith Sen
• Re: Refresh routine for single view contained in all company (client) databases
  • From: Erland Sommarskog
• Re: Crosstabbing (or rotating) a sql table
  • From: Erland Sommarskog
• Re: Refresh routine for single view contained in all company (client) databases
  • From: Chris H
• Crosstabbing (or rotating) a sql table
  • From: pompair
• Refresh routine for single view contained in all company (client) databases
  • From: Chris H
• Re: Need help writing a stored procedure
  • From: Jack Vamvas
• Re: Avg() not including 0's
  • From: Ed Murphy
• Re: SQL query for this purpose
  • From: Daniel Eyer
• Re: SQL query for this purpose
  • From: Plamen Ratchev
• www.mssql.sql.blogspot.com
  • From: abhilashsnair
• www.mssql.sql.blogspot.com
  • From: abhilashsnair
• www.mssql.sql.blogspot.com
  • From: abhilashsnair
• SQL query for this purpose
  • From: MadhavC
• Re: Avg() not including 0's
  • From: lee.richmond
• Re: Avg() not including 0's
  • From: Erland Sommarskog
• Re: Avg() not including 0's
  • From: lee.richmond
• Re: Need help writing a stored procedure
  • From: Plamen Ratchev
• Need help writing a stored procedure
  • From: JJ297
• Re: sql learning
  • From: --CELKO--
• Re: Join 4 tables - can it be done?
  • From: Plamen Ratchev
• Re: Join 4 tables - can it be done?
  • From: SirCodesALot
• Re: Join 4 tables - can it be done?
  • From: SirCodesALot
• Re: sql learning
  • From: Anith Sen
• Re: sql learning
  • From: Tony Rogerson
• Re: Transfer data to web page fields
  • From: jcnone@xxxxxxxx
• Re: autonumber
  • From: Tom van Stiphout
• Re: autonumber
  • From: Tom van Stiphout
• Re: Transfer data to web page fields
  • From: Tom van Stiphout
• Re: Inserting multiple records into two tables...with a twist
  • From: Ed Murphy
• Re: help with update
  • From: Ed Murphy
• Re: sql learning
  • From: --CELKO--
• Re: help with update
  • From: --CELKO--
• Re: autonumber
  • From: --CELKO--
• Re: Inserting multiple records into two tables...with a twist
  • From: --CELKO--
• sql learning
  • From: ian2572
• Re: autonumber
  • From: Erland Sommarskog
• Re: Create Table with Variable included in Table Name
  • From: Erland Sommarskog

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