comp.databases.ms-sqlserver

• Date Index

---

• MS SQL Server 2000 -, NJ
• problem with subselect, Bart op de grote markt
  • Re: problem with subselect, Shiju Samuel
• Problems with Sqlserver Replication, JonBosker
• Migrating Database changes to Production, RichardLamont
  • Re: Migrating Database changes to Production, xman
• Any limitations on EndPoint Creation par instance, SQLMan_25
  • Re: Any limitations on EndPoint Creation par instance, Najm
• Fulltime MS SQL DBA needed in Austin TX, jmccurley
• forming a string with dateparts, rgintexas
  • Re: forming a string with dateparts, Piero 'Giops' Giorgi
• Help Needed For Date field (Age) Calculation In SQl query, Dinesh
  • Re: Help Needed For Date field (Age) Calculation In SQl query, Roy Harvey
    • Re: Help Needed For Date field (Age) Calculation In SQl query, Dinesh
• SQL Error Logs - changes to DB states and detachements, snafu66
• SQL Turbo (Quest Software), Piero 'Giops' Giorgi
• sql server 2008, rcamarda
  • Re: sql server 2008, Erland Sommarskog
• DTS copying incorrect objects, RS200Phil
• copy users on server to another - SQL 2005 SP2, rcamarda
  • Re: copy users on server to another - SQL 2005 SP2, Shiju Samuel
    • Re: copy users on server to another - SQL 2005 SP2, rcamarda
• Problem Connect to Reporting Services via Mgmt Studio, Tech4Me
• restoring msdb from a network tape backup, Mr.Kane
• Subqueries and Aggregate Functions, Paul
  • Re: Subqueries and Aggregate Functions, Erland Sommarskog
    • Re: Subqueries and Aggregate Functions, Paul
• Trying to join three tables, JJ297
  • Re: Trying to join three tables, Erland Sommarskog
• Restore sql server express bak file as different db?, nano
  • Re: Restore sql server express bak file as different db?, Erland Sommarskog
• how can i send mail by using sql server, sachin shah
  • Re: how can i send mail by using sql server, stephen
    • Re: how can i send mail by using sql server, sachin shah
      • Re: how can i send mail by using sql server, Dan Guzman
      • Re: how can i send mail by using sql server, sachin shah
      • Re: how can i send mail by using sql server, Erland Sommarskog
• SQL Server Conversion, Jon Chase
  • <Possible follow-ups>
  • SQL Server Conversion, Jon Chase
• Convert INT YYYYMMDD to date mm/dd/yyyy, rdraider
  • Re: Convert INT YYYYMMDD to date mm/dd/yyyy, Cédric Del Nibbio
• Convert CHAR YYYYMMDD to mm/dd/yyyy, rdraider
  • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, rdraider
    • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, David Portas
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, rdraider
  • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, David Portas
    • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, --CELKO--
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, rdraider
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, --CELKO--
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, David Portas
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, Erland Sommarskog
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, Piero 'Giops' Giorgi
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, rdraider
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, Eric J. Holtman
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, Erland Sommarskog
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, Piero 'Giops' Giorgi
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, Tony Rogerson
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, --CELKO--
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, Erland Sommarskog
      • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy, Tony Rogerson
• SQL Server 2005 Reporting Services Problem, Michael Burgess
• help with while loops, lhiregoudar
  • Re: help with while loops, Erland Sommarskog
  • Re: help with while loops, David Portas
• Dynamic Columns, aCe
  • <Possible follow-ups>
  • Dynamic Columns, aCe
    • Re: Dynamic Columns, Erland Sommarskog
• SQL 2005 - Full Text Index question, Piero 'Giops' Giorgi
• Run all .sql files (scripts) in project (SQL Server 2005 SP2), downwitch
  • Re: Run all .sql files (scripts) in project (SQL Server 2005 SP2), Erland Sommarskog
    • Re: Run all .sql files (scripts) in project (SQL Server 2005 SP2), xman
• SQL sever 2005 express move windowns authentication choice to mixed authentication, Fonseca
  • Re: SQL sever 2005 express move windowns authentication choice to mixed authentication, Erland Sommarskog
• Restore LDF file after restoring backups in SQL Server 2005?, l0b0
  • Re: Restore LDF file after restoring backups in SQL Server 2005?, Erland Sommarskog
• Accessing one db by two sql server installations (eg. native vs vmware), HP
  • Re: Accessing one db by two sql server installations (eg. native vs vmware), Erland Sommarskog
• Need to find instances of duplicates within a column; joining 2 tables., aknoch
  • Re: Need to find instances of duplicates within a column; joining 2 tables., Roy Harvey
• Need help w/ a script, click37
  • Re: Need help w/ a script, Erland Sommarskog
• distributed transaction problem ?, Matik
• ssis EXEC command, gelangov
  • Re: ssis EXEC command, Erland Sommarskog
    • Re: ssis EXEC command, gelangov
      • Re: ssis EXEC command, Erland Sommarskog
      • Re: ssis EXEC command, gelangov
      • Re: ssis EXEC command, Erland Sommarskog
      • Re: ssis EXEC command, gelangov
      • Re: ssis EXEC command, Erland Sommarskog
      • Re: ssis EXEC command, gelangov
      • Re: ssis EXEC command, Erland Sommarskog
      • Re: ssis EXEC command, John Heimiller
      • Re: ssis EXEC command, John Heimiller
      • Re: ssis EXEC command, Erland Sommarskog
• Problem with DB_OWNER role.., monty
  • Re: Problem with DB_OWNER role.., Erland Sommarskog
    • Re: Problem with DB_OWNER role.., monty
      • Re: Problem with DB_OWNER role.., Erland Sommarskog
      • Re: Problem with DB_OWNER role.., monty
      • Re: Problem with DB_OWNER role.., Erland Sommarskog
      • Re: Problem with DB_OWNER role.., monty
      • Re: Problem with DB_OWNER role.., Erland Sommarskog
• MS SQL dealing with duplicate columns in rows?, Yas
  • Re: MS SQL dealing with duplicate columns in rows?, stephen
    • Re: MS SQL dealing with duplicate columns in rows?, Yas
      • Re: MS SQL dealing with duplicate columns in rows?, Luuk
      • Re: MS SQL dealing with duplicate columns in rows?, Martijn Tonies
      • Re: MS SQL dealing with duplicate columns in rows?, Luuk
      • Re: MS SQL dealing with duplicate columns in rows?, David Portas
• An expression of non-boolean type specified in a context where a condition is expected, near ')'., pbd22
  • Re: An expression of non-boolean type specified in a context where a condition is expected, near ')'., Roy Harvey
    • Re: An expression of non-boolean type specified in a context where a condition is expected, near ')'., pbd22
• A floating point exception occurred in the user process, Massa Batheli
  • Re: A floating point exception occurred in the user process, Erland Sommarskog
    • Re: A floating point exception occurred in the user process, Massa Batheli
      • Re: A floating point exception occurred in the user process, Erland Sommarskog
      • Re: A floating point exception occurred in the user process, Massa Batheli
      • Re: A floating point exception occurred in the user process, Massa Batheli
      • Re: A floating point exception occurred in the user process, Erland Sommarskog
• SQL Server error, Leisses Loud
  • Re: SQL Server error, Erland Sommarskog
• Dinamyc Function, aCe
  • Re: Dinamyc Function, Erland Sommarskog
  • Re: Dinamyc Function, Gert-Jan Strik
  • Re: Dinamyc Function, steve
• DOWNLOAD CRACKED 2007's SOFTWARE: ARCHICAD 11,UNIGRAPHICS NX5,SOLIDWORKS 2008,XSTEEL 13,AUTOCAD 2008, John Peterson
• Copy data from one table to another table with change in identity column values, satish
  • Re: Copy data from one table to another table with change in identity column values, Roy Harvey
    • Re: Copy data from one table to another table with change in identity column values, Erland Sommarskog
      • Re: Copy data from one table to another table with change in identity column values, Roy Harvey
• SQL Profiler - SPID, wesleym312
  • Re: SQL Profiler - SPID, Fritz Franz
  • Re: SQL Profiler - SPID, dba
  • Re: SQL Profiler - SPID, Erland Sommarskog
• Re: HELP! Need to find info on AccPac databases! (OT), john
• (WWW.CNCIRCLE.COM) cheape *** jordan shoes, af1,outlet shoes, hujin
• Excellent Resource, future.revelation@xxxxxxxxx
• How to check if a Table is <empty> ie doesnt contain any rows, Yas
  • Re: How to check if a Table is <empty> ie doesnt contain any rows, Yas
    • Re: How to check if a Table is <empty> ie doesnt contain any rows, Yas
  • Re: How to check if a Table is <empty> ie doesnt contain any rows, Erland Sommarskog
    • Re: How to check if a Table is <empty> ie doesnt contain any rows, Yas
      • Re: How to check if a Table is <empty> ie doesnt contain any rows, Erland Sommarskog
    • Re: How to check if a Table is <empty> ie doesnt contain any rows, Chris.Cheney
      • Re: How to check if a Table is <empty> ie doesnt contain any rows, Erland Sommarskog
      • Re: How to check if a Table is <empty> ie doesnt contain any rows, Erland Sommarskog
      • Re: How to check if a Table is <empty> ie doesnt contain any rows, Chris.Cheney
• Inconsistent identity values, Bill E.
  • Re: Inconsistent identity values, Gert-Jan Strik
    • Re: Inconsistent identity values, Bill E.
      • Re: Inconsistent identity values, Erland Sommarskog
      • Re: Inconsistent identity values, Bill E.
      • Re: Inconsistent identity values, Erland Sommarskog
• Combine record, dede
  • Re: Combine record, Erland Sommarskog
• TABLESAMPLE question, WhytheQ
  • Re: TABLESAMPLE question, Erland Sommarskog
    • Re: TABLESAMPLE question, WhytheQ
• Invoke Oracle procedure from SQL SERVER, ind_123
• Unaccountable jump in Identity column value, teddysnips
  • Re: Unaccountable jump in Identity column value, Erland Sommarskog
    • Re: Unaccountable jump in Identity column value, teddysnips
      • Re: Unaccountable jump in Identity column value, Erland Sommarskog
  • Re: Unaccountable jump in Identity column value, Alex Kuznetsov
    • Re: Unaccountable jump in Identity column value, teddysnips
      • Re: Unaccountable jump in Identity column value, Alex Kuznetsov
  • Re: Unaccountable jump in Identity column value, Gert-Jan Strik
    • Re: Unaccountable jump in Identity column value, teddysnips
• How to create an admin with some limitations?, bertainafederico
  • Re: How to create an admin with some limitations?, Erland Sommarskog
    • Re: How to create an admin with some limitations?, bertainafederico
      • Re: How to create an admin with some limitations?, bertainafederico
      • Re: How to create an admin with some limitations?, bertainafederico
• WHERE question, ceconix
  • Re: WHERE question, Erland Sommarskog
• Blindare utente SQL amministratore, bertainafederico
  • Re: Blindare utente SQL amministratore, Roy Harvey
  • Re: Blindare utente SQL amministratore, Erland Sommarskog
    • Re: Blindare utente SQL amministratore, bertainafederico
• Knowledgeable yet simple book for database modelling or database design, vicky
  • Re: Knowledgeable yet simple book for database modelling or database design, David Portas
  • Re: Knowledgeable yet simple book for database modelling or database design, Alex Kuznetsov
• MS SQL copy new and modified rows from TABLE1 to TABLE2, Yas
  • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Erland Sommarskog
    • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Yas
      • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Erland Sommarskog
      • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Yas
      • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Roy Harvey
      • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Yas
      • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Erland Sommarskog
      • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Yas
      • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Erland Sommarskog
      • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Yas
      • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Hugo Kornelis
      • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Yas
      • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, Roy Harvey
      • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2, stephen
• Problem performing remote queries, rhaazy
  • Message not available
    • Re: Problem performing remote queries, rhaazy
      • Message not available
      • Re: Problem performing remote queries, rhaazy
      • Re: Problem performing remote queries, Erland Sommarskog
• wants sql query, sachin shah
  • Re: wants sql query, PDreyer
• SELECT a random 10 records from table....easy newbie question, WhytheQ
  • Re: SELECT a random 10 records from table....easy newbie question, Hugo Kornelis
    • Re: SELECT a random 10 records from table....easy newbie question, Søren Reinke
      • Re: SELECT a random 10 records from table....easy newbie question, Erland Sommarskog
      • Re: SELECT a random 10 records from table....easy newbie question, Søren Reinke
      • Re: SELECT a random 10 records from table....easy newbie question, Hugo Kornelis
      • Re: SELECT a random 10 records from table....easy newbie question, Hugo Kornelis
      • Re: SELECT a random 10 records from table....easy newbie question, Søren Reinke
    • Re: SELECT a random 10 records from table....easy newbie question, WhytheQ
      • Re: SELECT a random 10 records from table....easy newbie question, Hugo Kornelis
• Creating database from stored proc with variable holding the database name, gancy26
  • Re: Creating database from stored proc with variable holding the database name, Erland Sommarskog
• month name from the sql query, sachin shah
  • Re: month name from the sql query, Erland Sommarskog
  • Re: month name from the sql query, stephen
• data transfer from .csv file to sql server 2000, sachin shah
  • Re: data transfer from .csv file to sql server 2000, stephen
    • Re: data transfer from .csv file to sql server 2000, sachin shah
• Re: Standard Schemas?, Arto V Viitanen
  • Re: Standard Schemas?, Rich
    • Re: Standard Schemas?, Arto V Viitanen
      • Re: Standard Schemas?, --CELKO--
• Create script to insert 200 rows into table, rhaazy
  • Re: Create script to insert 200 rows into table, rhaazy
    • Re: Create script to insert 200 rows into table, rhaazy
      • Re: Create script to insert 200 rows into table, rhaazy
      • Re: Create script to insert 200 rows into table, Roy Harvey
      • Re: Create script to insert 200 rows into table, rhaazy
  • Re: Create script to insert 200 rows into table, info
• Limit query execution time, rcamarda
  • Re: Limit query execution time, Erland Sommarskog
    • Re: Limit query execution time, rcamarda
      • Re: Limit query execution time, Erland Sommarskog
• Backup plan reccomendations for user with ZERO experience., scott s
  • Re: Backup plan reccomendations for user with ZERO experience., rcamarda
  • Re: Backup plan reccomendations for user with ZERO experience., Erland Sommarskog
• Microsoft OLE DB Provider for ODBC Drivers error '80040e14', Bhavna
  • Re: Microsoft OLE DB Provider for ODBC Drivers error '80040e14', Erland Sommarskog
• Find rows by date. Compare today's row with yesterdays etc, Yas
  • Re: Find rows by date. Compare today's row with yesterdays etc, Roy Harvey
  • Re: Find rows by date. Compare today's row with yesterdays etc, --CELKO--
    • Re: Find rows by date. Compare today's row with yesterdays etc, Erland Sommarskog
      • Re: Find rows by date. Compare today's row with yesterdays etc, --CELKO--
      • Re: Find rows by date. Compare today's row with yesterdays etc, Erland Sommarskog
• Replication SQL Server 2005 - PostgreSQL, Mr Pear
• Restore database with no log, Bill E.
  • Re: Restore database with no log, Bill E.
  • Re: Restore database with no log, Erland Sommarskog
    • Re: Restore database with no log, Bill E.
      • Re: Restore database with no log, Erland Sommarskog
      • Re: Restore database with no log, Bill E.
• query Oracle -> sqlserver, dario . 8282
  • Re: query Oracle -> sqlserver, Tony Rogerson
• Restoring from Backup without logs, GM
  • Re: Restoring from Backup without logs, Bill E.
• Temp Table vs. Union: Which Has Better Performance?, imani_technology_spam@xxxxxxxxx
  • Re: Temp Table vs. Union: Which Has Better Performance?, Erland Sommarskog
• urls/ free downloadbable tutorials, Rahul
• INNER JOIN - INSERT, Clive Swan
  • Re: INNER JOIN - INSERT, Erland Sommarskog
    • Re: INNER JOIN - INSERT, Clive Swan
      • Re: INNER JOIN - INSERT, Roy Harvey
      • Re: INNER JOIN - INSERT, Erland Sommarskog
      • Re: INNER JOIN - INSERT, Clive Swan
• Linked Server Headache (Access), BillCo
  • Re: Linked Server Headache (Access), BillCo
• One function for Squids, Automobiles, Britney Spears - a super function, steve
• FA - MS SQL Server Certification Trainers, CamerasRule
• xp_cmdshell access denied output, mcolson
• Saving data to SQL Data Base, Omar Abid
  • Re: Saving data to SQL Data Base, Dan Guzman
    • Re: Saving data to SQL Data Base, Omar Abid
      • Re: Saving data to SQL Data Base, Dan Guzman
      • Re: Saving data to SQL Data Base, Omar Abid
      • Re: Saving data to SQL Data Base, Erland Sommarskog
      • Re: Saving data to SQL Data Base, Omar Abid
• Excellent oppurnities in 'Bootstrap Technologies", bootstrap
  • <Possible follow-ups>
  • Excellent oppurnities in 'Bootstrap Technologies", bootstrap
• MS SQL Server 2005 - SQL Agent problems, sailorfej
• Using sql to execute a batch file, mcolson
  • Re: Using sql to execute a batch file, Roy Harvey
    • Re: Using sql to execute a batch file, xp_cmdshell, mcolson
      • Re: Using sql to execute a batch file, xp_cmdshell, Roy Harvey
      • Re: Using sql to execute a batch file, xp_cmdshell, mcolson
      • Re: Using sql to execute a batch file, xp_cmdshell, Roy Harvey
      • Re: Using sql to execute a batch file, xp_cmdshell, Erland Sommarskog
• Thesaurus Search - How to update the XML?, Piero 'Giops' Giorgi
• Needed: SQL DBA/ 12 Months / WA, ittkrish
• SQL Server 2000, Requesting database properties lock up enterprise manager, Skeptical
• Multi-column Index vs Single Column Indexes, Sonny
  • Re: Multi-column Index vs Single Column Indexes, Dan Guzman
  • Re: Multi-column Index vs Single Column Indexes, Alex Kuznetsov
• PolyServe DB Utility for SQL Server, rwyarger
• SQL Server 2000 Performance Issue, hiddenhippo
• Re: MS SQL return Min count homeMDB, Yas
• SQL 2000 performance issues, Fox1977
  • Re: SQL 2000 performance issues, Jack Vamvas
    • Re: SQL 2000 performance issues, hiddenhippo
  • Re: SQL 2000 performance issues, Hugo Kornelis
• Exchange Server - A Must Read!!!, robert.mofta@xxxxxxxxx
• Most common connection method to SQL 2005, Charlie
  • Re: Most common connection method to SQL 2005, Dan Guzman
• What version of SQL Server to buy?, Charlie
  • Re: What version of SQL Server to buy?, Hugo Kornelis
    • Re: What version of SQL Server to buy?, Charlie
    • Re: What version of SQL Server to buy?, Wes Groleau
  • Re: What version of SQL Server to buy?, Wes Groleau
    • Re: What version of SQL Server to buy?, Charlie
      • Re: What version of SQL Server to buy?, Wes Groleau
      • Re: What version of SQL Server to buy?, Charlie
      • Re: What version of SQL Server to buy?, Hugo Kornelis
      • Re: What version of SQL Server to buy?, Charlie
      • Re: What version of SQL Server to buy?, Hugo Kornelis
      • Re: What version of SQL Server to buy?, Charlie
      • Re: What version of SQL Server to buy?, Wes Groleau
      • Re: What version of SQL Server to buy?, Hugo Kornelis
  • Re: What version of SQL Server to buy?, Bucky
    • Re: What version of SQL Server to buy?, Charlie
• IF UPDATE(@column_name), ben
  • Re: IF UPDATE(@column_name), Hugo Kornelis
  • Re: IF UPDATE(@column_name), David Portas
• Re: Dynamic Cursor Generation.., Ed Murphy
• Examination 070-229 Resource, deny.morison@xxxxxxxxx
• Use of large field definitions for small values, David Greenberg
  • Re: Use of large field definitions for small values, shiju
  • Re: Use of large field definitions for small values, --CELKO--
  • Re: Use of large field definitions for small values, Tony Rogerson
• DTS Package (Dynamic Properties Task)., Rahul
  • <Possible follow-ups>
  • DTS Package (Dynamic Properties Task)., Rahul
  • DTS Package (Dynamic Properties Task)., Rahul
• Numeric value only for a character field, David Greenberg
  • Re: Numeric value only for a character field, Hugo Kornelis
• ISA Server with Exchange Server, patricia . parker02
• To have SQL Server 2000 + 2005 working on a single windows 2003 server, fhernandezve
  • Re: To have SQL Server 2000 + 2005 working on a single windows 2003 server, Helmut Woess
• Re: general question, --CELKO--
  • <Possible follow-ups>
  • Re: general question, Alex Kuznetsov
    • Re: general question, MikeJ
• help with sql select, Joanne M.
  • Re: help with sql select, Roy Harvey
• Re: Why XML Output is Truncated, Hugo Kornelis
• Re: transactions, shiju
  • <Possible follow-ups>
  • Re: transactions, dba
    • Re: transactions, Erland Sommarskog
  • Re: transactions, Alex Kuznetsov
• Re: FK Assignment on Surrogate Key Table Throws Error, --CELKO--
• output parameters from row with max id, mcolson
  • Re: output parameters from row with max id, --CELKO--
  • Re: output parameters from row with max id, shiju
    • Re: output parameters from row with max id, mcolson
• Re: Pass Table as a parameter to a function, --CELKO--
  • <Possible follow-ups>
  • Re: Pass Table as a parameter to a function, Shuurai
    • Re: Pass Table as a parameter to a function, Ed Murphy
  • Re: Pass Table as a parameter to a function, --CELKO--
    • Re: Pass Table as a parameter to a function, Tony Rogerson
  • Re: Pass Table as a parameter to a function, steve

• Security
• UNIX
• Linux
• Coding
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint

newsgroups.derkeiler.com  > Archive  > Comp  > comp.databases.ms-sqlserver  > 2007-08