comp.databases.ms-sqlserver

• Date Index

---

• memory usage/allocation/paging question, tlyczko
• Returning the newest rows, pltaylor3
  • Re: Returning the newest rows, Erland Sommarskog
• SPROC won't execute - insufficient permissions, teddysnips
  • Re: SPROC won't execute - insufficient permissions, Dan Guzman
• Does anyone know of a tool that allows a SQL Server database to be, kesarr
• inserting into two tables and transaction problem, Habib
  • Re: inserting into two tables and transaction problem, Joe Weinstein
• Sending email (recipients), B
  • Re: Sending email (recipients), Dan Guzman
• SQL Server 2005 Express, Birdman
• Export Image Data Types to Local PC from SQL Database, manmit . walia
  • Re: Export Image Data Types to Local PC from SQL Database, Erland Sommarskog
• Update statement, then insert what wasn't available to be updated., rhaazy
  • Re: Update statement, then insert what wasn't available to be updated., Erland Sommarskog
    • Re: Update statement, then insert what wasn't available to be updated., rhaazy
      • Re: Update statement, then insert what wasn't available to be updated., rhaazy
      • Re: Update statement, then insert what wasn't available to be updated., rhaazy
      • Re: Update statement, then insert what wasn't available to be updated., rhaazy
      • Re: Update statement, then insert what wasn't available to be updated., rhaazy
  • Re: Update statement, then insert what wasn't available to be updated., Alexander Kuznetsov
• left() and right() function in MS SQL vs MS ACCESS, sql guy123
  • Re: left() and right() function in MS SQL vs MS ACCESS, Roy Harvey
    • Re: left() and right() function in MS SQL vs MS ACCESS, sql guy123
      • Re: left() and right() function in MS SQL vs MS ACCESS, SQL Menace
      • Re: left() and right() function in MS SQL vs MS ACCESS, Roy Harvey
  • Re: left() and right() function in MS SQL vs MS ACCESS, Roy Harvey
    • Re: left() and right() function in MS SQL vs MS ACCESS, sql guy123
      • Re: left() and right() function in MS SQL vs MS ACCESS, Roy Harvey
• Calling a SP inside a cursor loop.., satishchandra999
  • Re: Calling a SP inside a cursor loop.., Erland Sommarskog
  • Re: Calling a SP inside a cursor loop.., --CELKO--
  • <Possible follow-ups>
  • Calling a SP inside a cursor loop.., satishchandra999
• Differences between SQL2000 Dev. Edition & SQL2005 Dev. Edition, x-rays
  • Re: Differences between SQL2000 Dev. Edition & SQL2005 Dev. Edition, David Portas
    • Re: Differences between SQL2000 Dev. Edition & SQL2005 Dev. Edition, x-rays
• mysql database session management with cj tracking, Nospam
  • Re: mysql database session management with cj tracking, Dan Guzman
• Insert trigger, jazpar
  • Re: Insert trigger, Erland Sommarskog
    • Re: Insert trigger, jazpar
      • Re: Insert trigger, Erland Sommarskog
• Need help with this select statement, rhaazy
  • Re: Need help with this select statement, Erland Sommarskog
    • Re: Need help with this select statement, rhaazy
• How to get rank?, jim_geissman
  • Re: How to get rank?, SQL Menace
  • Re: How to get rank?, Alexander Kuznetsov
• SQLserver on SBS2003 returns old data, Poul Petersen
  • Re: SQLserver on SBS2003 returns old data, Erland Sommarskog
• constraint expression for unique keys, HandersonVA
  • Re: constraint expression for unique keys, Alexander Kuznetsov
    • Re: constraint expression for unique keys, HandersonVA
      • Re: constraint expression for unique keys, Alexander Kuznetsov
  • Re: constraint expression for unique keys, Erland Sommarskog
  • Re: constraint expression for unique keys, --CELKO--
• how/what should be the query for this result, choudharymv
  • Re: how/what should be the query for this result, Erland Sommarskog
  • Re: how/what should be the query for this result, Alexander Kuznetsov
    • Re: how/what should be the query for this result, choudharymv
    • Re: how/what should be the query for this result, choudharymv
• Datareader concepts to access SQL Server data using datareader., pedaammulu
• Scheduling of snapshot agent, perhiyar
• right padding equivalent, lossed
  • Re: right padding equivalent, Bucky
    • Re: right padding equivalent, lossed
  • Re: right padding equivalent, Mike C#
    • Re: right padding equivalent, lossed
      • Re: right padding equivalent, SQL Menace
      • Re: right padding equivalent, lossed
      • Re: right padding equivalent, Mike C#
      • Re: right padding equivalent, lossed
      • Re: right padding equivalent, Mike C#
      • Re: right padding equivalent, lossed
  • Re: right padding equivalent, Erland Sommarskog
    • Re: right padding equivalent, lossed
      • Re: right padding equivalent, Erland Sommarskog
• Help With Syntax, PeterA
  • Re: Help With Syntax, Jason
    • Re: Help With Syntax, SQL Menace
      • Re: Help With Syntax, Erland Sommarskog
    • Re: Help With Syntax, PeterA
  • Re: Help With Syntax, --CELKO--
• sorting twice?!, Tim
  • Re: sorting twice?!, Jack Vamvas
  • Re: sorting twice?!, Erland Sommarskog
    • Re: sorting twice?!, Tim
• Combining 2 tables with date ranges, Frank
  • Re: Combining 2 tables with date ranges, Jack Vamvas
  • Re: Combining 2 tables with date ranges, markc600
  • Re: Combining 2 tables with date ranges, Jason
  • Re: Combining 2 tables with date ranges, Erland Sommarskog
    • Re: Combining 2 tables with date ranges, Frank
      • Re: Combining 2 tables with date ranges, Erland Sommarskog
  • Re: Combining 2 tables with date ranges, --CELKO--
• dbcc reindex issue - - I don't understand!!, Raziq Shekha
  • Re: dbcc reindex issue - - I don't understand!!, Stu
  • Re: dbcc reindex issue - - I don't understand!!, Erland Sommarskog
  • Re: dbcc reindex issue - - I don't understand!!, Raziq Shekha
• Have Insert statement, need equivalent Update., rhaazy
  • Re: Have Insert statement, need equivalent Update., Erland Sommarskog
    • Re: Have Insert statement, need equivalent Update., rhaazy
      • Re: Have Insert statement, need equivalent Update., rhaazy
• SELECT statement help, schoultzy
  • Re: SELECT statement help, Erland Sommarskog
  • Re: SELECT statement help, Mike C#
    • Re: SELECT statement help, Greg D. Moore \(Strider\)
• Developer Edition having issues connecting to server via TCP/IP, Chris
  • Re: Developer Edition having issues connecting to server via TCP/IP, Erland Sommarskog
    • Re: Developer Edition having issues connecting to server via TCP/IP, Chris
      • Re: Developer Edition having issues connecting to server via TCP/IP, Erland Sommarskog
• "Sql Server 2005 Developer", moon77
• pulling progress data, mattcushing
  • Re: pulling progress data, M@
• Enumerate databases, ab
  • Re: Enumerate databases, Dan Guzman
    • Re: Enumerate databases, ab
    • Re: Enumerate databases, DickChristoph
• trigger question, Zvonko
  • Re: trigger question, Razvan Socol
    • Re: trigger question, Zvonko
      • Re: trigger question, Razvan Socol
      • Re: trigger question, Razvan Socol
  • Re: trigger question, Erland Sommarskog
    • Re: trigger question, Zvonko
      • Re: trigger question, Erland Sommarskog
      • Re: trigger question, Erland Sommarskog
      • Re: trigger question, Razvan Socol
      • Re: trigger question, Razvan Socol
      • Re: trigger question, Erland Sommarskog
      • Re: trigger question, jim_geissman
• "Ghost" primary key column, chrisek
  • Re: "Ghost" primary key column, --CELKO--
    • Re: "Ghost" primary key column, Mike C#
    • Re: "Ghost" primary key column, Greg D. Moore \(Strider\)
  • Re: "Ghost" primary key column, Erland Sommarskog
• I have a question With Related to performence, bhushanvinay
  • Re: I have a question With Related to performence, Erland Sommarskog
    • Re: I have a question With Related to performence, bhushanvinay
      • Re: I have a question With Related to performence, Erland Sommarskog
  • Re: I have a question With Related to performence, Jack Vamvas
• The single OS nature of MS SQL, metaperl
  • Re: The single OS nature of MS SQL, Greg D. Moore \(Strider\)
    • Re: The single OS nature of MS SQL, Zvonko
      • Re: The single OS nature of MS SQL, Dan Guzman
      • Re: The single OS nature of MS SQL, Greg D. Moore \(Strider\)
      • Re: The single OS nature of MS SQL, Zvonko
  • Re: The single OS nature of MS SQL, Stu
    • Re: The single OS nature of MS SQL, Zvonko
      • Re: The single OS nature of MS SQL, J. Clarke
      • Re: The single OS nature of MS SQL, Stu
      • Re: The single OS nature of MS SQL, Tony Rogerson
• EXcel sheet into database with stored procedure, A.M. de Jong
  • Re: EXcel sheet into database with stored procedure, Erland Sommarskog
• Network error IOException: Could not create socket (SQLState: 08S01), Nasir
• Insertion and Updates on 20.000.000 tuples table., Andrix
  • Re: Insertion and Updates on 20.000.000 tuples table., Erland Sommarskog
    • Re: Insertion and Updates on 20.000.000 tuples table., Andrix
      • Re: Insertion and Updates on 20.000.000 tuples table., --CELKO--
      • Re: Insertion and Updates on 20.000.000 tuples table., Erland Sommarskog
• Deleted "old" transaction logs = (no items) in EM. How to recover?, optimistck
  • Re: Deleted "old" transaction logs = (no items) in EM. How to recover?, Erland Sommarskog
• Help.... This doesn't make sense..., Anns via SQLMonster.com
  • Re: Help.... This doesn't make sense..., Anns via SQLMonster.com
  • Re: Help.... This doesn't make sense..., Anns via SQLMonster.com
    • Re: Help.... This doesn't make sense..., Erland Sommarskog
    • Re: Help.... This doesn't make sense..., Mike C#
• Access Query against SQL Server works only without criteria, ShastriX
  • Re: Access Query against SQL Server works only without criteria, Erland Sommarskog
    • Re: Access Query against SQL Server works only without criteria, ShastriX
  • Re: Access Query against SQL Server works only without criteria, Razvan Socol
    • Re: Access Query against SQL Server works only without criteria, ShastriX
• The identifier that starts with...is too long. Maximum length is 128, Pedro
  • Re: The identifier that starts with...is too long. Maximum length is 128, Dan Guzman
• 2 foreign keys to the same table - multitable selection query problem, chrisek
  • Re: 2 foreign keys to the same table - multitable selection query problem, Erland Sommarskog
    • Re: 2 foreign keys to the same table - multitable selection query problem, chrisek
• SQL Server Error "Missing end comment mark", Maricel Espejo
  • Re: SQL Server Error "Missing end comment mark", Erland Sommarskog
• SuperSocket Info: Bind failed on TCP port 1433, rodrado
• Help sending email, B
  • Re: Help sending email, DickChristoph
  • Re: Help sending email - additional question, B
    • Re: Help sending email - additional question, DickChristoph
• free comparison and synchronization tool, googlegroups
• Separate databases for high/low transaction volumes?, peterc
  • Re: Separate databases for high/low transaction volumes?, mmarovic
  • Re: Separate databases for high/low transaction volumes?, Erland Sommarskog
    • Re: Separate databases for high/low transaction volumes?, peterc
• Speed up UDF, ujjc001
  • Re: Speed up UDF, Mike C#
    • Re: Speed up UDF, ujjc001
      • Re: Speed up UDF, Erland Sommarskog
      • Re: Speed up UDF, Mike C#
  • Re: Speed up UDF, mmarovic
  • Re: Speed up UDF, Erland Sommarskog
  • Re: Speed up UDF, Stu
    • Re: Speed up UDF, ujjc001
      • Re: Speed up UDF, Stu
• SQL to Oracle update trigger fails due to distributed transaction error 7391, gshawn3
• What is Your Strategy for Upgrade an Access db to SQL Server 2000?, NickName
  • Re: What is Your Strategy for Upgrade an Access db to SQL Server 2000?, MGFoster
    • Re: What is Your Strategy for Upgrade an Access db to SQL Server 2000?, NickName
    • Re: What is Your Strategy for Upgrade an Access db to SQL Server 2000?, Erland Sommarskog
      • Re: What is Your Strategy for Upgrade an Access db to SQL Server 2000?, NickName
      • Re: What is Your Strategy for Upgrade an Access db to SQL Server 2000?, Erland Sommarskog
      • Re: What is Your Strategy for Upgrade an Access db to SQL Server 2000?, NickName
• Very Poor Performance - Identical DBs but Different Performance, BTabios
  • Re: Very Poor Performance - Identical DBs but Different Performance, Erland Sommarskog
    • Re: Very Poor Performance - Identical DBs but Different Performance, Stu
• Query with Joins problem, wilhelm . kleu
  • Re: Query with Joins problem, Erland Sommarskog
• Extremely Poor Query Performance - Identical DBs Different Performance, Brian Tabios
  • Re: Extremely Poor Query Performance - Identical DBs Different Performance, simonjw83
• Comparison operator in Select list, Jim Devenish
  • Re: Comparison operator in Select list, Jim Devenish
    • Re: Comparison operator in Select list, Jim Devenish
      • Re: Comparison operator in Select list, Erland Sommarskog
  • Re: Comparison operator in Select list, Razvan Socol
    • Re: Comparison operator in Select list, Jim Devenish
• SQL Server 2005 and Cursors, mrcraze
  • Re: SQL Server 2005 and Cursors, Erland Sommarskog
• setup multiple SQL server listeners on one machine, Ben K
• Help with SQL Statement to find first and last populated field in string of fields, Alex
  • Re: Help with SQL Statement to find first and last populated field in string of fields, Erland Sommarskog
    • Re: Help with SQL Statement to find first and last populated field in string of fields, Alex
• Sql Server 2005 questions regarding editing views, CK
  • Re: Sql Server 2005 questions regarding editing views, SQL Menace
    • Re: Sql Server 2005 questions regarding editing views, CK
• Ambiguous Column Names in Multi-Table Join, Mike S
  • Re: Ambiguous Column Names in Multi-Table Join, Jack Vamvas
    • Re: Ambiguous Column Names in Multi-Table Join, Mike S
      • Re: Ambiguous Column Names in Multi-Table Join, Stu
      • Re: Ambiguous Column Names in Multi-Table Join, Erland Sommarskog
  • Re: Ambiguous Column Names in Multi-Table Join, SQL
  • Re: Ambiguous Column Names in Multi-Table Join, --CELKO--
• Problem joining child data (JOIN, subquery, or something else?), Beowulf
  • Re: Problem joining child data (JOIN, subquery, or something else?), Erland Sommarskog
    • Re: Problem joining child data (JOIN, subquery, or something else?), Beowulf
• Unable to reinstall Enterprise Manager from original disk: service pack rejected, Prem
  • Re: Unable to reinstall Enterprise Manager from original disk: service pack rejected, Erland Sommarskog
    • Re: Unable to reinstall Enterprise Manager from original disk: service pack rejected, Prem
      • Re: Unable to reinstall Enterprise Manager from original disk: service pack rejected, Erland Sommarskog
      • Re: Unable to reinstall Enterprise Manager from original disk: service pack rejected, Prem
• Ms Access to SQL, Anns via SQLMonster.com
  • Re: Ms Access to SQL, francois . bourdages
• Database name with point in it (mail.archive.mdf) not recognised in query analyser of SQL 2000, Prem
  • Re: Database name with point in it (mail.archive.mdf) not recognised in query analyser of SQL 2000, SQL
  • Re: Database name with point in it (mail.archive.mdf) not recognised in query analyser of SQL 2000, Erland Sommarskog
• Full Text search database FTDATA folder full of copies of my documents!!!?, Prem
• Ms Access upload to SQL Server 2005 BE & Sharepoint FE, Anns via SQLMonster.com
  • Re: Ms Access upload to SQL Server 2005 BE & Sharepoint FE, Anns via SQLMonster.com
    • Re: Ms Access upload to SQL Server 2005 BE & Sharepoint FE, Anns via SQLMonster.com
• One Database vs. Multiple Databases, TC
  • Re: One Database vs. Multiple Databases, David Portas
  • Re: One Database vs. Multiple Databases, francois . bourdages
    • Re: One Database vs. Multiple Databases, Q. John Chen
  • Re: One Database vs. Multiple Databases, Erland Sommarskog
  • Re: One Database vs. Multiple Databases, Greg D. Moore \(Strider\)
  • Re: One Database vs. Multiple Databases, DA Morgan
  • Re: One Database vs. Multiple Databases, Jason Kester
    • Re: One Database vs. Multiple Databases, james.igoe@xxxxxxxxx
  • Re: One Database vs. Multiple Databases, TC
• Web FE & SQL BE, Anns via SQLMonster.com
• T-SQL Problem - should I use the "ALL" clause?, google
  • Re: T-SQL Problem - should I use the "ALL" clause?, David Portas
    • Re: T-SQL Problem - should I use the "ALL" clause?, google
      • Re: T-SQL Problem - should I use the "ALL" clause?, Hugo Kornelis
  • Re: T-SQL Problem - should I use the "ALL" clause?, --CELKO--
• SQL 2005: creating "correct" and "incorrect" versions of a database, metaperl
  • Re: SQL 2005: creating "correct" and "incorrect" versions of a database, Erland Sommarskog
    • Re: SQL 2005: creating "correct" and "incorrect" versions of a database, metaperl
      • Re: SQL 2005: creating "correct" and "incorrect" versions of a database, Erland Sommarskog
  • Re: SQL 2005: creating "correct" and "incorrect" versions of a database, Jason Kester
• encryption in sql server 2005, shark
  • Re: encryption in sql server 2005, Erland Sommarskog
  • Re: encryption in sql server 2005, rcamarda
    • Re: encryption in sql server 2005, pb648174
• Datatype-convertion in TSQL, Filips Benoit
  • Re: Datatype-convertion in TSQL, Erland Sommarskog
    • Re: Datatype-convertion in TSQL, Filips Benoit
      • Re: Datatype-convertion in TSQL, Madhivanan
      • Re: Datatype-convertion in TSQL, Erland Sommarskog
      • Re: Datatype-convertion in TSQL, Filips Benoit
      • Re: Datatype-convertion in TSQL, Erland Sommarskog
• Error: 16954, Severity: 10, State: 1 and Timeout problem, Matik
  • Re: Error: 16954, Severity: 10, State: 1 and Timeout problem, Erland Sommarskog
    • Re: Error: 16954, Severity: 10, State: 1 and Timeout problem, Matik
• SQLDMO - Getting 'Local' Server name, Alex
  • Re: SQLDMO - Getting 'Local' Server name, Chris Cheney
    • Re: SQLDMO - Getting 'Local' Server name, Alex
• Creating Cursor from Stored Procedure, Lucky
  • Re: Creating Cursor from Stored Procedure, Stu
    • Re: Creating Cursor from Stored Procedure, Jason Kester
  • Re: Creating Cursor from Stored Procedure, Madhivanan
    • Re: Creating Cursor from Stored Procedure, Lucky
      • Re: Creating Cursor from Stored Procedure, Erland Sommarskog
      • Re: Creating Cursor from Stored Procedure, Lucky
      • Re: Creating Cursor from Stored Procedure, Erland Sommarskog
      • Re: Creating Cursor from Stored Procedure, Lucky
      • Re: Creating Cursor from Stored Procedure, Erland Sommarskog
      • Re: Creating Cursor from Stored Procedure, Lucky
      • Re: Creating Cursor from Stored Procedure, Erland Sommarskog
      • Re: Creating Cursor from Stored Procedure, Lucky
• SQL 2005 - Disappearing Relationships in DB Diagram, mark . szretter
  • Re: SQL 2005 - Disappearing Relationships in DB Diagram, David Portas
  • Re: SQL 2005 - Disappearing Relationships in DB Diagram, Erland Sommarskog
• help for shrinking database, Zvonko
  • Re: help for shrinking database, Jack Vamvas
    • Re: help for shrinking database, Cimode
  • Re: help for shrinking database, Erland Sommarskog
• Re: Hanging during READ_COMMITTED_SNAPSHOT ON, sharma_vivek_us
  • Re: Hanging during READ_COMMITTED_SNAPSHOT ON, Erland Sommarskog
  • Re: Hanging during READ_COMMITTED_SNAPSHOT ON, Cimode
  • <Possible follow-ups>
  • Re: Hanging during READ_COMMITTED_SNAPSHOT ON, Cimode
• Sequence generator, newtophp2000
  • Re: Sequence generator, Erland Sommarskog
    • Re: Sequence generator, newtophp2000
  • Re: Sequence generator, Alexander Kuznetsov
    • Re: Sequence generator, newtophp2000
      • Re: Sequence generator, Madhivanan
  • Re: Sequence generator, Mike C#
• DTS copies from SQL Server to MySQL on Windows., Mike Husler
• group by, Jeff Kish
  • Re: group by, jim_geissman
  • Re: group by, Erland Sommarskog
    • Re: group by, Jeff Kish
      • Re: group by, Erland Sommarskog
      • Re: group by, Jeff Kish
      • Re: group by, Erland Sommarskog
      • Re: group by, Jeff Kish
• SQL Server 2005 Hash Partitioning?, Robert Klemme
• Left Join variable not valid, Sfj
  • Re: Left Join variable not valid, Dan Guzman
  • Re: Left Join variable not valid, Hugo Kornelis
    • Re: Left Join variable not valid, shermanfj
• SQL Join, germanshorthairpointer@xxxxxxxxx
  • Re: SQL Join, David Portas
    • Re: SQL Join, germanshorthairpointer@xxxxxxxxx
      • Re: SQL Join, Erland Sommarskog
      • Re: SQL Join, germanshorthairpointer@xxxxxxxxx
      • Re: SQL Join, Erland Sommarskog
  • Re: SQL Join, --CELKO--
    • Re: SQL Join, --CELKO--
• ISP Driver Error?Line: 131 of /ips_kernel/class_db_mysql.php, Thaqalainnaqvi
  • Re: ISP Driver Error?Line: 131 of /ips_kernel/class_db_mysql.php, Erland Sommarskog
• Cannot remove dbo rights from a user, MK
  • Re: Cannot remove dbo rights from a user, Erland Sommarskog
    • Re: Cannot remove dbo rights from a user, MK
      • Re: Cannot remove dbo rights from a user, Erland Sommarskog
• knowing which jobs/dts/SSIS affect which tables, metaperl
  • Re: knowing which jobs/dts/SSIS affect which tables, Stu
• Rebuild index issue - - strange, Raziq Shekha
  • Re: Rebuild index issue - - strange, GlennThomas5
• Connecting Sql Server 2005 from ASP?, MVChauhan
  • Re: Connecting Sql Server 2005 from ASP?, Erland Sommarskog
    • Re: Connecting Sql Server 2005 from ASP?, MVChauhan@xxxxxxxxxxxxxx
      • Re: Connecting Sql Server 2005 from ASP?, pb648174
      • Re: Connecting Sql Server 2005 from ASP?, MVChauhan@xxxxxxxxxxxxxx
      • Re: Connecting Sql Server 2005 from ASP?, Erland Sommarskog
      • Re: Connecting Sql Server 2005 from ASP?, MVChauhan@xxxxxxxxxxxxxx
      • Re: Connecting Sql Server 2005 from ASP?, Erland Sommarskog
      • Re: Connecting Sql Server 2005 from ASP?, MVChauhan@xxxxxxxxxxxxxx
      • Re: Connecting Sql Server 2005 from ASP?, Erland Sommarskog
      • Re: Connecting Sql Server 2005 from ASP?, MVChauhan@xxxxxxxxxxxxxx
• How to FAST and EASY ENCRYPTION ALL Stored Procedure in my MS-SQL Database ?, mickyang
  • Re: How to FAST and EASY ENCRYPTION ALL Stored Procedure in my MS-SQL Database ?, Erland Sommarskog
• NEW IT JOBS, gmail_girl
• Sybase driver and MSSQL 2k, Martin Lukasik
  • Re: Sybase driver and MSSQL 2k, Erland Sommarskog
    • Re: Sybase driver and MSSQL 2k, Mark T. Kennedy
• How can I get all records for both tables with the latest begin date if exists?, TGEAR
  • Re: How can I get all records for both tables with the latest begin date if exists?, ZeldorBlat
    • Re: How can I get all records for both tables with the latest begin date if exists?, TGEAR
      • Re: How can I get all records for both tables with the latest begin date if exists?, ZeldorBlat
  • Re: How can I get all records for both tables with the latest begin date if exists?, Hugo Kornelis
• Stored Proc Question : Why If Exisits...Drop...Create Proc?, CK
  • Re: Stored Proc Question : Why If Exisits...Drop...Create Proc?, Cimode
    • Re: Stored Proc Question : Why If Exisits...Drop...Create Proc?, KJAmbrose
  • Re: Stored Proc Question : Why If Exisits...Drop...Create Proc?, Erland Sommarskog
• Copy text columns to nvarchar, Marc Filthaut
  • Re: Copy text columns to nvarchar, Erland Sommarskog
    • Re: Copy text columns to nvarchar, Marc Filthaut
• Assistance building a query..., mazzarin
  • Re: Assistance building a query..., mazzarin
    • Re: Assistance building a query..., mazzarin
  • Re: Assistance building a query..., Erland Sommarskog
    • Re: Assistance building a query..., mazzarin
• Calling another record into this record, pltaylor3
  • Re: Calling another record into this record, Hugo Kornelis
  • Re: Calling another record into this record, Erland Sommarskog
• how to conver number to string, oviam packirisamy
  • Re: how to conver number to string, Erland Sommarskog
• Debugging in Query Analyser, Trevor Best
• Are we going right?, perhiyar
• out of order identity field - sql2000, bevanward
  • Re: out of order identity field - sql2000, Mike C#
    • Re: out of order identity field - sql2000, bevanward
      • Re: out of order identity field - sql2000, Mike C#
      • Re: out of order identity field - sql2000, bevanward
      • Re: out of order identity field - sql2000, Mike C#
      • Re: out of order identity field - sql2000, bevanward
  • Re: out of order identity field - sql2000, Erland Sommarskog
    • Re: out of order identity field - sql2000, Mike C#
      • Re: out of order identity field - sql2000, Tony Rogerson
      • Re: out of order identity field - sql2000, Mike C#
      • Re: out of order identity field - sql2000, Erland Sommarskog
      • Re: out of order identity field - sql2000, Mike C#
  • Re: out of order identity field - sql2000, --CELKO--
• output the latest date for each foreign key, TGEAR
  • <Possible follow-ups>
  • output the latest date for each foreign key, TGEAR
    • Re: output the latest date for each foreign key, TGEAR
    • Re: output the latest date for each foreign key, Erland Sommarskog
      • Re: output the latest date for each foreign key, TGEAR
      • Re: output the latest date for each foreign key, TGEAR
      • Re: output the latest date for each foreign key, TGEAR
      • Re: output the latest date for each foreign key, Hugo Kornelis
      • Re: output the latest date for each foreign key, Erland Sommarskog
      • Re: output the latest date for each foreign key, TGEAR
• getting the most latest date, TGEAR
  • Re: getting the most latest date, rudianus
• Authentication, Eng . Rana
  • Re: Authentication, Erland Sommarskog
    • Re: Authentication, Eng . Rana
      • Re: Authentication, Erland Sommarskog
      • Re: Authentication, Eng . Rana
      • Re: Authentication, Erland Sommarskog
      • Re: Authentication, Hugo Kornelis
• ANN: Multi DBMS tool "Database Workbench" version 2.8.7 released, Martijn Tonies
• Stored Procedure Issue - Problem with temporary tables, pinney.colton@xxxxxxxxx
  • Re: Stored Procedure Issue - Problem with temporary tables, DickChristoph
    • Re: Stored Procedure Issue - Problem with temporary tables, pinney.colton@xxxxxxxxx
  • Re: Stored Procedure Issue - Problem with temporary tables, Erland Sommarskog
• Performance issue, Cray
  • Re: Performance issue, Asarum
  • Re: Performance issue, Jack Vamvas
    • Re: Performance issue, Cray
  • Re: Performance issue, Erland Sommarskog
• enterprise manager (or other software) to document tables and columns for Server2k?, metaperl
  • Re: enterprise manager (or other software) to document tables and columns for Server2k?, Erland Sommarskog
• 2 different foreign keys in one table, HandersonVA
  • Re: 2 different foreign keys in one table, David Portas
• How to create SQL Server Express server (INSTANCENAME) programmatically?, ianicbass
  • Re: How to create SQL Server Express server (INSTANCENAME) programmatically?, Erland Sommarskog
• backup of transaction log, alwinkotiya
  • Re: backup of transaction log, Jack Vamvas
  • Re: backup of transaction log, DickChristoph
• Perfomance Question, Laurence Breeze
  • Re: Perfomance Question, Jack Vamvas
    • Re: Perfomance Question, Laurence Breeze
• [ANNOUNCE] Stylus Studio 2006 Release 3 Now Available, Stylus Studio
• SQL server backup and truncate log file, alwinkotiya
  • Re: SQL server backup and truncate log file, Robert Klemme
    • Re: SQL server backup and truncate log file, alwinkotiya
  • Re: SQL server backup and truncate log file, Erland Sommarskog
• how to specify the column name, gobiparthi
  • Re: how to specify the column name, Jack Vamvas
  • Re: how to specify the column name, DickChristoph
  • Re: how to specify the column name, Madhivanan
• 2005: Database cannot be opened, R . A . M .
  • Re: 2005: Database cannot be opened, Erland Sommarskog
    • Re: 2005: Database cannot be opened, R . A . M .
      • Re: 2005: Database cannot be opened, Erland Sommarskog
• Re: Timeout errors, pb648174
  • Re: Timeout errors, Erland Sommarskog
• Indexing strategy, Ryan
  • Re: Indexing strategy, Stu
    • Re: Indexing strategy, Ryan
      • Re: Indexing strategy, Erland Sommarskog
  • Re: Indexing strategy, Erland Sommarskog
  • Re: Indexing strategy, francois . bourdages
  • Re: Indexing strategy, DickChristoph
  • Re: Indexing strategy, Mike C#
• use result set returned by sp as derived table, Baihao Yuan
  • Re: use result set returned by sp as derived table, David Portas
    • Re: use result set returned by sp as derived table, Baihao Yuan
• A basic question: Removing duplicate results from Max function, aamircheema
  • Re: A basic question: Removing duplicate results from Max function, Erland Sommarskog
  • Re: A basic question: Removing duplicate results from Max function, David Portas
  • Re: A basic question: Removing duplicate results from Max function, Hugo Kornelis
    • Re: A basic question: Removing duplicate results from Max function, aamircheema
• Project Management Interview Questions June 5th, 2006, Jobs
• Most efficient way to run update query, rdraider
  • Re: Most efficient way to run update query, Erland Sommarskog
    • Re: Most efficient way to run update query, rdraider
  • Re: Most efficient way to run update query, --CELKO--
• if-then in select stmnt, anderma8
  • Re: if-then in select stmnt, MGFoster
    • Re: if-then in select stmnt, Erland Sommarskog
      • Re: if-then in select stmnt, MGFoster
      • Re: if-then in select stmnt, Hugo Kornelis
      • Re: if-then in select stmnt, Erland Sommarskog
• Importing data into MS SQL 2000 from XML file, Sam Alexander
  • Importing data into MS SQL 2000 from XML file, Sam Alexander
    • Re: Importing data into MS SQL 2000 from XML file, markc600
      • Re: Importing data into MS SQL 2000 from XML file, Sam Alexander
• SQL2005 Rebuild Index Not Working, wackyphill
  • Re: SQL2005 Rebuild Index Not Working, smithabreddy
    • Re: SQL2005 Rebuild Index Not Working, wackyphill
      • Re: SQL2005 Rebuild Index Not Working, smithabreddy
      • Re: SQL2005 Rebuild Index Not Working, wackyphill
      • Re: SQL2005 Rebuild Index Not Working, Jackie Brophy
      • Re: SQL2005 Rebuild Index Not Working, wackyphill
      • Re: SQL2005 Rebuild Index Not Working, Erland Sommarskog
      • Re: SQL2005 Rebuild Index Not Working, wackyphill
      • Re: SQL2005 Rebuild Index Not Working, Erland Sommarskog
      • Re: SQL2005 Rebuild Index Not Working, wackyphill
• i want ot convert xml data format into the general data format, surya
  • Re: i want ot convert xml data format into the general data format, Dan Guzman
• Backup log - will it truncate?, Trevor Best
  • Re: Backup log - will it truncate?, johnbandettini
    • Re: Backup log - will it truncate?, Trevor Best
  • Re: Backup log - will it truncate?, Hugo Kornelis
    • Re: Backup log - will it truncate?, Greg D. Moore \(Strider\)
      • Re: Backup log - will it truncate?, Erland Sommarskog
      • Re: Backup log - will it truncate?, Hugo Kornelis
      • Re: Backup log - will it truncate?, Greg D. Moore \(Strider\)
• peraphs thi spost go here..., sal21
• Times in SQL Server, trevorjhughes
  • Re: Times in SQL Server, ZeldorBlat
• composite index and column order, Baihao Yuan
  • Re: composite index and column order, ZeldorBlat
    • Re: composite index and column order, Baihao Yuan
  • Re: composite index and column order, Alexander Kuznetsov
    • Re: composite index and column order, ZeldorBlat
      • Re: composite index and column order, smithabreddy
      • Re: composite index and column order, Alexander Kuznetsov
      • Re: composite index and column order, Alexander Kuznetsov
      • Re: composite index and column order, Alexander Kuznetsov
      • Re: composite index and column order, ZeldorBlat
      • Re: composite index and column order, Alexander Kuznetsov
      • Re: composite index and column order, Erland Sommarskog
      • Re: composite index and column order, ZeldorBlat
      • Re: composite index and column order, Alexander Kuznetsov
• Help with 2 datetime fields-1 stores date, the other time, rdraider
  • Re: Help with 2 datetime fields-1 stores date, the other time, ZeldorBlat
    • Re: Help with 2 datetime fields-1 stores date, the other time, rdraider
• exporting data into tables from excel file, nitin
• SQLXML, Nikolami
  • Re: SQLXML, Nikolami
• Store program EXE in table?, HC
  • Re: Store program EXE in table?, David Portas
  • Re: Store program EXE in table?, Erland Sommarskog
• Disabling the AUTOCOMMIT option in MSSQLServer, Uncle Sam
  • Re: Disabling the AUTOCOMMIT option in MSSQLServer, Eugene
  • Re: Disabling the AUTOCOMMIT option in MSSQLServer, Hugo Kornelis
• noob sql learn! web interface and sql express!, Morne . vHuyssteen
• Log Explorer vs. ApexSQL Log vs. SQL Log-Rescue, Martin
  • Re: Log Explorer vs. ApexSQL Log vs. SQL Log-Rescue, Erland Sommarskog
• Dump of databasse, Jerry
  • Re: Dump of databasse, Q. John Chen
  • Re: Dump of databasse, Erland Sommarskog
• Scripting Databases, Ryan
  • Re: Scripting Databases, Eugene
  • Re: Scripting Databases, Erland Sommarskog
    • Re: Scripting Databases, Ryan
• need information for "Before Select" Trigger, Lucky
  • Re: need information for "Before Select" Trigger, Erland Sommarskog
    • Re: need information for "Before Select" Trigger, Lucky
      • Re: need information for "Before Select" Trigger, David Portas
      • Re: need information for "Before Select" Trigger, Erland Sommarskog
• Cannot Alter Table being Published for Replication, Brian Wotherspoon
  • Re: Cannot Alter Table being Published for Replication, Eugene
    • Re: Cannot Alter Table being Published for Replication, Greg D. Moore \(Strider\)
  • Re: Cannot Alter Table being Published for Replication, Greg D. Moore \(Strider\)
• SQL Server + Oracle Data linked in one query, Chris
  • Re: SQL Server + Oracle Data linked in one query, Saiko Consulting
    • Re: SQL Server + Oracle Data linked in one query, Chris
      • Re: SQL Server + Oracle Data linked in one query, Chris
• Format a datetime columns output?, CK
  • Re: Format a datetime columns output?, David Portas
  • Re: Format a datetime columns output?, Erland Sommarskog
    • Re: Format a datetime columns output?, CK
      • Re: Format a datetime columns output?, Erland Sommarskog
    • Re: Format a datetime columns output?, David Portas
      • Re: Format a datetime columns output?, Erland Sommarskog
• update, cemal
  • Re: update, Erland Sommarskog
• Get results from VB SQLCRL Stored Procedure, Chris
  • Re: Get results from VB SQLCRL Stored Procedure, Erland Sommarskog
• SQL Server 2005 stored procedures decryptor, Max
• Create project/stored procedure for SQLCRL, Chris
  • Re: Create project/stored procedure for SQLCRL, Hugo Kornelis
    • Re: Create project/stored procedure for SQLCRL, Chris
• Calling Stored Procedure from an ActiveX task, Karthik
  • Re: Calling Stored Procedure from an ActiveX task, Erland Sommarskog
• Challenge: Can you optimize this?, octangle
  • Re: Challenge: Can you optimize this?, Alexander Kuznetsov
    • Re: Challenge: Can you optimize this?, octangle
      • Re: Challenge: Can you optimize this?, octangle
      • Re: Challenge: Can you optimize this?, octangle
      • Re: Challenge: Can you optimize this?, Alexander Kuznetsov
      • Re: Challenge: Can you optimize this?, Erland Sommarskog
      • Re: Challenge: Can you optimize this?, Alexander Kuznetsov
      • Re: Challenge: Can you optimize this?, Hugo Kornelis
  • Re: Challenge: Can you optimize this?, Hugo Kornelis
  • Message not available
    • Re: Challenge: Can you optimize this? (summary), Alexander Kuznetsov
      • Re: Challenge: Can you optimize this? (summary), octangle
  • Message not available
    • Re: Challenge: Can you optimize this? (summary), octangle
      • Re: Challenge: Can you optimize this? (summary), Erland Sommarskog
  • Message not available
    • Re: Challenge: Can you optimize this? (summary), Erland Sommarskog
      • Re: Challenge: Can you optimize this? (summary), octangle
      • Re: Challenge: Can you optimize this? (summary), Erland Sommarskog
  • Message not available
    • Re: Challenge: Can you optimize this? (summary), Hugo Kornelis
  • Re: Challenge: Can you optimize this?, jsfromynr
• Transactional Replication - Adding New Articles, Eugene
• Record size more than 8060B, RamaKrishna Narla
  • Re: Record size more than 8060B, Jens
  • Re: Record size more than 8060B, Helmut Woess
  • Re: Record size more than 8060B, Hugo Kornelis
• SQLServer 2000 SP4 Enterprise Manager crashes immediately..., powersof2
  • Re: SQLServer 2000 SP4 Enterprise Manager crashes immediately..., Stu
• SQL Union Problems When Trying to Retrieve Random Records, Jeremy
  • Re: SQL Union Problems When Trying to Retrieve Random Records, Alexander Kuznetsov
    • Re: SQL Union Problems When Trying to Retrieve Random Records, JMoore2026@xxxxxxxxx
      • Re: SQL Union Problems When Trying to Retrieve Random Records, Erland Sommarskog
      • Re: SQL Union Problems When Trying to Retrieve Random Records, Alexander Kuznetsov
      • Re: SQL Union Problems When Trying to Retrieve Random Records, Erland Sommarskog
      • Re: SQL Union Problems When Trying to Retrieve Random Records, Greg D. Moore \(Strider\)
      • Re: SQL Union Problems When Trying to Retrieve Random Records, JMoore2026@xxxxxxxxx
      • Re: SQL Union Problems When Trying to Retrieve Random Records, Greg D. Moore \(Strider\)
  • Re: SQL Union Problems When Trying to Retrieve Random Records, Helmut Woess
• McAfee Recruits Database Engineers, deepapinto@xxxxxxxxx
• Line 1: Incorrect syntax near, Sandesh
  • Re: Line 1: Incorrect syntax near, Erland Sommarskog
• Divide by zero error!!! Help!, zod91@xxxxxxxxx
  • Re: Divide by zero error!!! Help!, Erland Sommarskog
• How to Insert date in sql server database, SSG
  • Re: How to Insert date in sql server database, Erland Sommarskog
• Parameterized SP in WHERE Clause of Another SP, jeremygetsmail@xxxxxxxxx
  • Re: Parameterized SP in WHERE Clause of Another SP, Erland Sommarskog
• Question about returning a smalldatetime from a Function, SQL Server
  • Re: Question about returning a smalldatetime from a Function, Erland Sommarskog
  • Re: Question about returning a smalldatetime from a Function, Hugo Kornelis
    • Re: Question about returning a smalldatetime from a Function, SQL Server
      • Re: Question about returning a smalldatetime from a Function, Erland Sommarskog
      • Re: Question about returning a smalldatetime from a Function, SQL Server
      • Re: Question about returning a smalldatetime from a Function, Erland Sommarskog
• ANN: Advanced Data Generator 1.6.2 released, Martijn Tonies
• Dummy Question, ajocius
  • Re: Dummy Question, Stu
• Re: Insert a record in a particular place, Peter
• SERVER BUSY, roninkaiser
• deadlock problem, shark
  • Re: deadlock problem, Dan Guzman
    • Re: deadlock problem, shark
      • Re: deadlock problem, Erland Sommarskog
• Reporting Services Report Viewer versus Report Server Problem, Gary Anniss
• Referential Integrity problem, Jeff North
  • Re: Referential Integrity problem, Erland Sommarskog
    • Re: Referential Integrity problem, Jeff North
      • Re: Referential Integrity problem, Erland Sommarskog
      • Re: Referential Integrity problem, Jeff North
  • Re: Referential Integrity problem, --CELKO--
    • Re: Referential Integrity problem, Jeff North
• Trigger to populate table or database, Jchick
  • Re: Trigger to populate table or database, Helmut Woess
  • Re: Trigger to populate table or database, Erland Sommarskog
    • Re: Trigger to populate table or database, Jchick
      • Re: Trigger to populate table or database, Erland Sommarskog
      • Re: Trigger to populate table or database, Jchick
      • Re: Trigger to populate table or database, Erland Sommarskog
• SQL_Latin1_General_CP1_CS_AS, Nasir
  • Re: SQL_Latin1_General_CP1_CS_AS, Erland Sommarskog
• register hasn't been updated, AKS
  • Re: register hasn't been updated, Erland Sommarskog
• Finding prepared statement sql, birju
  • Re: Finding prepared statement sql, Erland Sommarskog
    • Re: Finding prepared statement sql, birju
      • Re: Finding prepared statement sql, Erland Sommarskog
• HAVING prob !, daoud97@xxxxxxxxx
  • Re: HAVING prob !, Tom Moreau
  • Re: HAVING prob !, markc600
    • Re: HAVING prob !, daoud97@xxxxxxxxx
      • Re: HAVING prob !, markc600
      • Re: HAVING prob !, daoud97@xxxxxxxxx
      • Re: HAVING prob !, markc600
      • Re: HAVING prob !, daoud97@xxxxxxxxx
      • Re: HAVING prob !, daoud97@xxxxxxxxx
      • Re: HAVING prob !, daoud97@xxxxxxxxx
      • Re: HAVING prob !, Tom Moreau
      • Re: HAVING prob !, markc600
      • Re: HAVING prob !, daoud97@xxxxxxxxx
      • Re: HAVING prob !, markc600
      • Re: HAVING prob !, daoud97@xxxxxxxxx
• Re: DBA Interview Questions, Madhivanan
• Interface for SQL Server database, Petteri
  • Re: Interface for SQL Server database, Madhivanan
    • Re: Interface for SQL Server database, Petteri
  • Re: Interface for SQL Server database, Erland Sommarskog
• this sql command make me sick, enzo
  • Re: this sql command make me sick, David Portas
  • Re: this sql command make me sick, Hugo Kornelis
  • Re: this sql command make me sick, enzo
• Question about using AND in WHERE..., JDeats
  • Re: Question about using AND in WHERE..., markc600
  • Re: Question about using AND in WHERE..., Madhivanan
• money data type, HandersonVA
  • Re: money data type, Anith Sen
  • Re: money data type, MGFoster
  • Re: money data type, SQL
• Re: T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures no other procedure with the same name, mednyk
  • <Possible follow-ups>
  • Re: T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures no other procedure with the same name, mednyk
    • Re: T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures no other procedure with the same name, Erland Sommarskog
• listing all SQL SErver and fill a sheet, sal21 sal21
• Re: sp_fkeys stored procedue is very slow, keyvez
• default value on quantity and price field, HandersonVA
  • Re: default value on quantity and price field, francois . bourdages
    • Re: default value on quantity and price field, francois . bourdages
  • Re: default value on quantity and price field, Erland Sommarskog
  • Re: default value on quantity and price field, Hugo Kornelis
    • Re: default value on quantity and price field, Erland Sommarskog
• Re: How can I conserve the initial zero when convert numeric to string using STR(), --CELKO--
  • Re: How can I conserve the initial zero when convert numeric to string using STR(), Erland Sommarskog
  • <Possible follow-ups>
  • Re: How can I conserve the initial zero when convert numeric to string using STR(), --CELKO--
    • Re: How can I conserve the initial zero when convert numeric to string using STR(), Damien
    • Re: How can I conserve the initial zero when convert numeric to string using STR(), Tony Rogerson
      • Re: How can I conserve the initial zero when convert numeric to string using STR(), Anith Sen
      • Re: How can I conserve the initial zero when convert numeric to string using STR(), Erland Sommarskog
      • Re: How can I conserve the initial zero when convert numeric to string using STR(), Tony Rogerson
  • Re: How can I conserve the initial zero when convert numeric to string using STR(), Stu
• Re: Very chalanging question - Explanation, --CELKO--
  • <Possible follow-ups>
  • Re: VERY chalanging question - Explanation, Madhivanan
    • Re: VERY chalanging question - Explanation, groupy
• Re: Complex Query, Erland Sommarskog
• Re: XML issue., Erland Sommarskog
  • Re: XML issue., rhaazy
    • Re: XML issue., Erland Sommarskog
      • Re: XML issue., rhaazy
      • Re: XML issue., Erland Sommarskog
      • Re: XML issue., rhaazy
• Re: Question on Transaction Log Backups, Erland Sommarskog
  • Re: Question on Transaction Log Backups, DataPro
    • Re: Question on Transaction Log Backups, rcamarda
      • Re: Question on Transaction Log Backups, Erland Sommarskog

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