comp.databases.ms-sqlserver

Date Index

LongestRunningQueries.vbs - Using a VB Script to show long-running queries, complete with query plans, Aaron West
- Re: LongestRunningQueries.vbs - Using a VB Script to show long-running queries, complete with query plans, Aaron West
2005: creating aggregate function from .NET assembly, R . A . M .
- Re: 2005: creating aggregate function from .NET assembly, Erland Sommarskog
Book recommendations?, blueghost73@xxxxxxxxx
- Re: Book recommendations?, Erland Sommarskog
  - Re: Book recommendations?, Alexander Kuznetsov
What do you mean 'clustered' index?, anonieko
- Re: What do you mean 'clustered' index?, Tony Rogerson
Server Components Can't Be Installed, Steve
- Re: Server Components Can't Be Installed, Stu
SQl Server 2005, shark
- Re: SQl Server 2005, omcuas
- Re: SQl Server 2005, omcuas
- Re: SQl Server 2005, omcuas
Red-Gate SQL Log Explorer, Jason_Williams
- Re: Red-Gate SQL Log Explorer, Erland Sommarskog
Free web based MS SQL management app, Brian D
need help regarding finding rows modifeid during certain time frame, abhi . 10dulkar
- Re: need help regarding finding rows modifeid during certain time frame, Erland Sommarskog
Column permission being ignored by Access Form Combo box, kellysc
Remving duplicate rows and NULLS, rai28pankaj
- Re: Remving duplicate rows and NULLS, markc600
Fill Factor, Praveen
- Re: Fill Factor, Erland Sommarskog
Automatic Import of Emails, leeroy881
- Re: Automatic Import of Emails, Helmut Woess
  - Re: Automatic Import of Emails, leeroy881
Size of Row, Praveen
- Re: Size of Row, Erland Sommarskog
  - Re: Size of Row, Paul S Randal [MS]
Multiple files import, jakub
Input string -> table -> output string?, adambossy
- Re: Input string -> table -> output string?, David Portas
- Re: Input string -> table -> output string?, Erland Sommarskog
Check if a Table is used in any sp or function, Q. John Chen
- Re: Check if a Table is used in any sp or function, Stu
- Re: Check if a Table is used in any sp or function, Erland Sommarskog
Query to find a missing number, Mahesh BS
- Re: Query to find a missing number, Ferrarista XXL
- Re: Query to find a missing number, Hugo Kornelis
- Re: Query to find a missing number, --CELKO--
  - Re: Query to find a missing number, Tony Rogerson
SQL 2000 Error: 1203, Severity: 20, State: 1 Error, wreed
- Re: SQL 2000 Error: 1203, Severity: 20, State: 1 Error, Erland Sommarskog
  - Re: SQL 2000 Error: 1203, Severity: 20, State: 1 Error, wreed
    - Re: SQL 2000 Error: 1203, Severity: 20, State: 1 Error, Erland Sommarskog
SQL Server 2005 Startup error - TDSSNIClient... error 0x5... code 0x51, TommyTheBurgerBoy
- Re: SQL Server 2005 Startup error - TDSSNIClient... error 0x5... code 0x51, Erland Sommarskog
De-normalizing query, jim_geissman
- Re: De-normalizing query, markc600
  - Re: De-normalizing query, jim_geissman
problems with query, M@
- Re: problems with query, Hugo Kornelis
Limits in SQL 2000, Robert P
- Re: Limits in SQL 2000, Erland Sommarskog
SQL Server 2005 JDBC 1.1 integrated security question, Marc Melancon
SQL Server 2005 SP1 install, rcamarda
- Re: SQL Server 2005 SP1 install, Erland Sommarskog
changing records in tables, Martin Lukasik
- Re: changing records in tables, Erland Sommarskog
- Re: changing records in tables, jsfromynr
Cursor loop, Chris Zopers
- Re: Cursor loop, Damien
- Re: Cursor loop, Erland Sommarskog
vba sql server connection, zuEgg
Re: BCP using ODBC - problem with unique identifier, tha_mihau
955585 - Limited Term Employee / Infrastructure...position at hewlett Packard, divya.govil@xxxxxx
Backup and Restore on different computer?, kai
- Re: Backup and Restore on different computer?, Roy Harvey
  - Re: Backup and Restore on different computer?, kai
Using Decimal as a Key, rottytooth
- Re: Using Decimal as a Key, Roy Harvey
  - Re: Using Decimal as a Key, rottytooth
- Re: Using Decimal as a Key, --CELKO--
Problem with INSERT Trigger, timothy . alvis
- Re: Problem with INSERT Trigger, Erland Sommarskog
How to get modified time of a table, Muthu
- Re: How to get modified time of a table, Erland Sommarskog
- Re: How to get modified time of a table, --CELKO--
Reporting Services 2000 & 2005 on same machine, rmk
- <Possible follow-ups>
- Reporting Services 2000 & 2005 on same machine, rmk
Transact-SQL SUM Help!, danielbair
- Re: Transact-SQL SUM Help!, Jack Vamvas
  - Re: Transact-SQL SUM Help!, danielbair
- Re: Transact-SQL SUM Help!, figital
- Re: Transact-SQL SUM Help!, --CELKO--
- Re: Transact-SQL SUM Help!, Hugo Kornelis
Get all table names with a given column name, Sashi
- Re: Get all table names with a given column name, Madhivanan
- Re: Get all table names with a given column name, Dan Guzman
Problem with stored procedure and retrieving inserted identity value, Susanne Klemm
- Re: Problem with stored procedure and retrieving inserted identity value, Erland Sommarskog
  - Re: Problem with stored procedure and retrieving inserted identity value, Suleon
- Re: Problem with stored procedure and retrieving inserted identity value, rmk
Problem with installing SQL Server, drshay
- Re: Problem with installing SQL Server, Jack Vamvas
- Re: Problem with installing SQL Server, Bryan
2005: using SMO, R . A . M .
- Re: 2005: using SMO, R . A . M .
  - Re: 2005: using SMO, Erland Sommarskog
2005: Business Intelligence Development Studio?, R . A . M .
- Re: Business Intelligence Development Studio?, Tony Rogerson
  - Re: Business Intelligence Development Studio?, R . A . M .
    - Re: Business Intelligence Development Studio?, R . A . M .
How to combine 2 records into 1 unique record, rdraider
- Re: How to combine 2 records into 1 unique record, Erland Sommarskog
Strange results from "not in" query, Branco Medeiros
- Re: Strange results from "not in" query, Hugo Kornelis
  - Re: Strange results from "not in" query, Branco Medeiros
    - Re: Strange results from "not in" query, --CELKO--
SQL2005 SSIS - won't allow text delimiters, jqq
Turn of logging on SQL maintenance plans, Justin
- Re: Turn of logging on SQL maintenance plans, Hugo Kornelis
- Re: Turn of logging on SQL maintenance plans, Erland Sommarskog
2005: calling .NET procedure, R . A . M .
- Re: 2005: calling .NET procedure, Hugo Kornelis
  - Re: 2005: calling .NET procedure, R . A . M .
  - Re: 2005: calling .NET procedure, R . A . M .
    - Re: 2005: calling .NET procedure, Hugo Kornelis
    - Re: 2005: calling .NET procedure, R . A . M .
    - I solved, R . A . M .
    - Re: 2005: calling .NET procedure - one more question, R . A . M .
    - Re: 2005: calling .NET procedure - one more question, Erland Sommarskog
Databse Link will not connect, traceable1
- Re: Databse Link will not connect, Stu
  - Re: Databse Link will not connect, traceable1
    - Re: Databse Link will not connect, Stu
    - Re: Databse Link will not connect, traceable1
Search Char in SQL query, jaawaad
- Re: Search Char in SQL query, Tony Rogerson
  - Re: Search Char in SQL query, jaawaad
  - Re: Search Char in SQL query, jaawaad
    - Re: Search Char in SQL query, Erland Sommarskog
    - Re: Search Char in SQL query, Madhivanan
- Re: Search Char in SQL query, Erland Sommarskog
  - Re: Search Char in SQL query, jaawaad
I HATE Management Studio, how about you?, jj
- Re: I HATE Management Studio, how about you?, Tony Rogerson
- Re: I HATE Management Studio, how about you?, Erland Sommarskog
- Re: I HATE Management Studio, how about you?, Radzi
Need help with denormalizing query, Thomas R. Hummel
- Re: Need help with denormalizing query, Erland Sommarskog
  - Re: Need help with denormalizing query, Thomas R. Hummel
    - Re: Need help with denormalizing query, Erland Sommarskog
    - Re: Need help with denormalizing query, Thomas R. Hummel
    - Re: Need help with denormalizing query, Thomas R. Hummel
    - Re: Need help with denormalizing query, Alexander Kuznetsov
    - Re: Need help with denormalizing query, Thomas R. Hummel
    - Re: Need help with denormalizing query, Alexander Kuznetsov
Smarter Table build - might split the table, rcamarda
- Re: Smarter Table build - might split the table, rcamarda
  - Re: Smarter Table build - might split the table, rcamarda
- Re: Smarter Table build - might split the table, Hugo Kornelis
Newby DTS Question, mike_kilby@xxxxxxxxxxx
- Re: Newby DTS Question, Thomas R. Hummel
  - Re: Newby DTS Question, mike_kilby@xxxxxxxxxxx
2005 EE: using full-text indexing, R . A . M .
- Re: 2005 EE: using full-text indexing, Hugo Kornelis
stored procedure question, Zvonko
- Re: stored procedure question, Erland Sommarskog
  - Re: stored procedure question, Zvonko
    - Re: stored procedure question, Erland Sommarskog
    - Re: stored procedure question, Zvonko
    - Re: stored procedure question, Erland Sommarskog
    - Re: stored procedure question, figital
Hierarchy, SQLNull
- Re: Hierarchy, Erland Sommarskog
  - Re: Hierarchy, SQLNull
- Re: Hierarchy, --CELKO--
Query: union on self, KoliPoki
- Re: Query: union on self, Erland Sommarskog
  - Re: Query: union on self, KoliPoki
    - Re: Query: union on self, Alexander Kuznetsov
    - Re: Query: union on self, Thomas R. Hummel
    - Re: Query: union on self, Alexander Kuznetsov
    - Re: Query: union on self, KoliPoki
    - Re: Query: union on self, Thomas R. Hummel
a newbie question on derived/computed column, lluum@xxxxxxxxx
- Re: a newbie question on derived/computed column, Erland Sommarskog
  - Re: a newbie question on derived/computed column, metaperl
    - Re: a newbie question on derived/computed column, Erland Sommarskog
User Defined Data Types Problem, royaldothighness@xxxxxxxxxxx
- Re: User Defined Data Types Problem, Erland Sommarskog
- Re: User Defined Data Types Problem, Alexander Kuznetsov
key column information is insufficient or incorrect, dinu
- Re: key column information is insufficient or incorrect, David Portas
Northwind database extra SQL needs, soalvajavab1
- Re: Northwind database extra SQL needs, Hugo Kornelis
- Re: Northwind database extra SQL needs, Erland Sommarskog
Make and save a blob on the fly in stored proc, natzol
- Re: Make and save a blob on the fly in stored proc, Erland Sommarskog
  - Re: Make and save a blob on the fly in stored proc, natzol
    - Re: Make and save a blob on the fly in stored proc, Erland Sommarskog
    - Re: Make and save a blob on the fly in stored proc, natzol
    - Re: Make and save a blob on the fly in stored proc, Erland Sommarskog
Need More SQL Query NewID Help, Paradyse
- Re: Need More SQL Query NewID Help, Erland Sommarskog
  - Re: Need More SQL Query NewID Help, Paradyse
    - Re: Need More SQL Query NewID Help, Erland Sommarskog
OUTER JOIN not working?, kamin
- Re: OUTER JOIN not working?, rhaazy
  - Re: OUTER JOIN not working?, kamin
    - Re: OUTER JOIN not working?, kamin
    - Re: OUTER JOIN not working?, Hugo Kornelis
Delete statement for a list of items with multiple columns identifying primary key, pb648174
- Re: Delete statement for a list of items with multiple columns identifying primary key, Query Builder
- Re: Delete statement for a list of items with multiple columns identifying primary key, Hugo Kornelis
Insert Function Help, riley . derrick
- Re: Insert Function Help, rhaazy
  - Re: Insert Function Help, Tiger
Re: Extremely Poor Query Performance - Identical DBs Different Performance, Henrik Fyhn
ADS user and sql 2005, rcamarda
- Re: ADS user and sql 2005, rcamarda
- Re: ADS user and sql 2005, Henrik Fyhn
- Re: ADS user and sql 2005, Erland Sommarskog
  - Re: ADS user and sql 2005, rcamarda
2005 Express: testing replication, R . A . M .
- Re: 2005 Express: testing replication, Helmut Woess
  - Re: 2005 Express: testing replication, R . A . M .
    - Re: 2005 Express: testing replication, Helmut Woess
    - Re: 2005 Express: testing replication, Greg D. Moore \(Strider\)
Hide SQL Server DB; 2005 version on Win 98, mal hit
- Re: Hide SQL Server DB; 2005 version on Win 98, Erland Sommarskog
  - Re: Hide SQL Server DB; 2005 version on Win 98, Cimode
pulling all dates within a date range, rugger81
- Re: pulling all dates within a date range, Hugo Kornelis
- Re: pulling all dates within a date range, Erland Sommarskog
  - Re: pulling all dates within a date range, rugger81
Insert Subqueries, pltaylor3
- Re: Insert Subqueries, Stu
  - Re: Insert Subqueries, pltaylor3
Odd SQL IN usage?, @sh
- Re: Odd SQL IN usage?, MGFoster
  - Re: Odd SQL IN usage?, @sh
- Re: Odd SQL IN usage?, Erland Sommarskog
  - Re: Odd SQL IN usage?, @sh
    - Re: Odd SQL IN usage?, Hugo Kornelis
    - Re: Odd SQL IN usage?, Erland Sommarskog
- Re: Odd SQL IN usage?, --CELKO--
exporting to CSV, Katie
- Re: exporting to CSV, Cimode
  - Re: exporting to CSV, Katie
    - Re: exporting to CSV, Brian Peasland
    - Re: exporting to CSV, Cimode
2005: forbidding INSERTs and DELETEs, R . A . M .
- Re: forbidding INSERTs and DELETEs, Dan Guzman
- Re: 2005: forbidding INSERTs and DELETEs, Erland Sommarskog
- Re: 2005: forbidding INSERTs and DELETEs, Hugo Kornelis
Please Help with SQL Query Problem, Darin L. Miller
- Re: Please Help with SQL Query Problem, MC
  - Re: Please Help with SQL Query Problem, Paradyse
    - Re: Please Help with SQL Query Problem, Hugo Kornelis
    - Re: Please Help with SQL Query Problem, Erland Sommarskog
    - Re: Please Help with SQL Query Problem, Paradyse
BEGINNER: simple Delete trigger, R . A . M .
- BEGINNER: one more question, R . A . M .
  - I solved, R . A . M .
    - Re: I solved, rcamarda
    - Re: I solved, R . A . M .
  - don't reply please; thanks, R . A . M .
- Re: BEGINNER: simple Delete trigger, Erland Sommarskog
  - Re: BEGINNER: simple Delete trigger, R . A . M .
    - Re: BEGINNER: simple Delete trigger, Roy Harvey
    - Re: BEGINNER: simple Delete trigger, Erland Sommarskog
- Re: BEGINNER: simple Delete trigger, --CELKO--
sequence of columns and preformance, R . A . M .
- Re: sequence of columns and preformance, Greg D. Moore \(Strider\)
- Re: sequence of columns and preformance, Erland Sommarskog
- Re: sequence of columns and preformance, --CELKO--
MS-SQL one .NDF file missing How to Recover/Rebuild DB??, Dhungu Dhumbak
- Re: MS-SQL one .NDF file missing How to Recover/Rebuild DB??, Cimode
Create trigger - do users need to be out?, rdraider
- Re: Create trigger - do users need to be out?, MGFoster
- Re: Create trigger - do users need to be out?, Erland Sommarskog
Bizarre Query, Xeth Waxman
- Re: Bizarre Query, Hugo Kornelis
Problem when changing Views, Jim Devenish
- Re: Problem when changing Views, Erland Sommarskog
  - Re: Problem when changing Views, Jim Devenish
    - Re: Problem when changing Views, Erland Sommarskog
  - Re: Problem when changing Views, Jim Devenish
    - Re: Problem when changing Views, Erland Sommarskog
- Re: Problem when changing Views, Stu
SQL 2005: keeping track of database changes, metaperl
- Re: SQL 2005: keeping track of database changes, Erland Sommarskog
  - Re: SQL 2005: keeping track of database changes, pb648174
Empty recordsets and artificial records, wgblackmon@xxxxxxxxx
- Re: Empty recordsets and artificial records, Erland Sommarskog
- Re: Empty recordsets and artificial records, Hugo Kornelis
  - Re: Empty recordsets and artificial records, Roy Harvey
need programmer to build a dts..., realmapper
Querying Windows Active Directory from Sql Server 2000, Lucky
- Re: Querying Windows Active Directory from Sql Server 2000, Stu
  - Re: Querying Windows Active Directory from Sql Server 2000, Lucky
    - Re: Querying Windows Active Directory from Sql Server 2000, Erland Sommarskog
- <Possible follow-ups>
- Querying Windows Active Directory from Sql Server 2000, Lucky
comma separated values to stored procedures, shark
- Re: comma separated values to stored procedures, Robert Klemme
- Re: comma separated values to stored procedures, Dan Guzman
  - Re: comma separated values to stored procedures, Madhivanan
Announcing Yellowfin Version 2.5 release for SQL server based users, Yellowfin Reporting
SQL server 2000 timeout, Brad
- Re: SQL server 2000 timeout, Erland Sommarskog
  - Re: SQL server 2000 timeout, Cimode
    - Re: SQL server 2000 timeout, Madhivanan
How to move transaction logs on-line?, nai
- Re: How to move transaction logs on-line?, Robert Klemme
- Re: How to move transaction logs on-line?, Cimode
- Re: How to move transaction logs on-line?, Erland Sommarskog
multiple rows and columns MAX, stassaf
- Re: multiple rows and columns MAX, Roy Harvey
  - Re: multiple rows and columns MAX, stassaf
    - Re: multiple rows and columns MAX, Roy Harvey
Getting Count(*) From Left side of Join using WHERE on right side of join, paulmac106
- Re: Getting Count(*) From Left side of Join using WHERE on right side of join, Roy Harvey
  - Re: Getting Count(*) From Left side of Join using WHERE on right side of join, paulmac106
Re: SPROC won't execute - insufficient permissions, teddysnips
- Re: SPROC won't execute - insufficient permissions, Erland Sommarskog
Re: Does anyone know of a tool that allows a SQL Server database to be, elian . chrebor
- Re: Does anyone know of a tool that allows a SQL Server database to be, m . bohse
Re: How to get rank?, Madhivanan
Re: SQL Server 2005 Express, Erland Sommarskog
Re: inserting into two tables and transaction problem, Erland Sommarskog
Re: memory usage/allocation/paging question, Erland Sommarskog
Re: Returning the newest rows, Erland Sommarskog
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
OR in the WHERE Clause?, Alex
- Re: OR in the WHERE Clause?, Erland Sommarskog
- Re: OR in the WHERE Clause?, Jack Vamvas
- Re: OR in the WHERE Clause?, Mike C#