comp.databases.ms-sqlserver

Date Index

replication, aleu@xxxxx
- Re: replication, Roy Harvey (SQL Server MVP)
  - Re: replication, aleu@xxxxx
    - Re: replication, Roy Harvey (SQL Server MVP)
dumb question, news
- Re: dumb question, --CELKO--
- Re: dumb question, Tony Rogerson
I want to parse @ArrayOfDays into @d1 through @d5, bobc
- Re: I want to parse @ArrayOfDays into @d1 through @d5, Erland Sommarskog
- Re: I want to parse @ArrayOfDays into @d1 through @d5, --CELKO--
  - Re: I want to parse @ArrayOfDays into @d1 through @d5, bobc
    - Re: I want to parse @ArrayOfDays into @d1 through @d5, --CELKO--
    - Re: I want to parse @ArrayOfDays into @d1 through @d5, Erland Sommarskog
  - Re: I want to parse @ArrayOfDays into @d1 through @d5, Tony Rogerson
- Re: I want to parse @ArrayOfDays into @d1 through @d5, Tony Rogerson
Users Logged In, RogueIT
- Re: Users Logged In, Jason Lepack
- Re: Users Logged In, Roy Harvey (SQL Server MVP)
  - Re: Users Logged In, RogueIT
nt authority\system?, louis
Comparing two tables, JJ297
- Re: Comparing two tables, Martijn Tonies
- Re: Comparing two tables, Jack Vamvas
  - Re: Comparing two tables, JJ297
strategies for paging, Nick Chan
- Re: strategies for paging, Hugo Kornelis
- Re: strategies for paging, --CELKO--
  - Re: strategies for paging, Tony Rogerson
I want to return a string to a wrapper from a subordinate stored procedure, bobc
- Re: I want to return a string to a wrapper from a subordinate stored procedure, bobc
- Re: I want to return a string to a wrapper from a subordinate stored procedure, Erland Sommarskog
  - Re: I want to return a string to a wrapper from a subordinate stored procedure, bobc
The best way to use the Database Engine Tuning Advisor, Tommy Hayes
Network Packet Size, kmounkhaty
- Re: Network Packet Size, Erland Sommarskog
Select Into across Linked Servers, Jennifer
- Re: Select Into across Linked Servers, Erland Sommarskog
Set default schema in code - possible?, aj
- Re: Set default schema in code - possible?, Erland Sommarskog
isqlw won't start, Andre Ma@ss
- Re: isqlw won't start, Andre Ma@ss
- Re: isqlw won't start, Erland Sommarskog
a small SQL Puzzle, Fiori
- Re: a small SQL Puzzle, Roy Harvey (SQL Server MVP)
  - Re: a small SQL Puzzle, Fiori
Clustered index on the identity column or a datetime column, Tommy Hayes
- Re: Clustered index on the identity column or a datetime column, Roy Harvey (SQL Server MVP)
  - Re: Clustered index on the identity column or a datetime column, Tommy Hayes
  - Re: Clustered index on the identity column or a datetime column, Gert-Jan Strik
autoincrement question sql 2005 server, info
- Re: autoincrement question sql 2005 server, Piero 'Giops' Giorgi
- Re: autoincrement question sql 2005 server, Erland Sommarskog
BIRT + Yellowfin + ANN mashup make Advanced Business Intelligence, YellowFin Announcements
Is it worth partitioning?, Tommy Hayes
- Re: Is it worth partitioning?, Roy Harvey (SQL Server MVP)
  - Re: Is it worth partitioning?, Tommy Hayes
  - Re: Is it worth partitioning?, Piero 'Giops' Giorgi
SQL Query from Access to SQL Server, rune
- Re: SQL Query from Access to SQL Server, Erland Sommarskog
Moving DB from one drive to another, Piero 'Giops' Giorgi
- Re: Moving DB from one drive to another, Dan Guzman
- Re: Moving DB from one drive to another, Erland Sommarskog
  - Re: Moving DB from one drive to another, Piero 'Giops' Giorgi
  - Re: Moving DB from one drive to another, Piero 'Giops' Giorgi
    - Re: Moving DB from one drive to another, Erland Sommarskog
    - Re: Moving DB from one drive to another, Piero 'Giops' Giorgi
    - Re: Moving DB from one drive to another, Erland Sommarskog
    - Re: Moving DB from one drive to another, Piero 'Giops' Giorgi
    - Re: Moving DB from one drive to another, Piero 'Giops' Giorgi
Would you like to have access contents about .net totally free?, Jeff
subtraction of different precision values, ibcarolek
- Re: subtraction of different precision values, Hugo Kornelis
- Re: subtraction of different precision values, Roy Harvey (SQL Server MVP)
ANN: Database Workbench 3.0 released, Martijn Tonies
Merge Replication nested view replication problem, ho.horace@xxxxxxxxx
SQL Mail setup, Finn Stampe Mikkelsen
Conn. Prob. contd: 'logon restricted' [Mngm. Studio], Daniel Loose
- Re: Conn. Prob. contd: 'logon restricted' [Mngm. Studio], Erland Sommarskog
find unique identifier through multiple tables, hugues . morel
- Re: find unique identifier through multiple tables, Dan Guzman
  - Re: find unique identifier through multiple tables, hugues . morel
- Re: find unique identifier through multiple tables, --CELKO--
  - Re: find unique identifier through multiple tables, Ed Murphy
    - Re: find unique identifier through multiple tables, --CELKO--
    - Re: find unique identifier through multiple tables, Ed Murphy
    - Re: find unique identifier through multiple tables, --CELKO--
PHP code to Stored Procedure, aCe
- Re: PHP code to Stored Procedure, Dan Guzman
  - Re: PHP code to Stored Procedure, aCe
    - Re: PHP code to Stored Procedure, Ed Murphy
    - Re: PHP code to Stored Procedure, Dan Guzman
Strange Connect Problem, Daniel Loose
- Re: Strange Connect Problem, Jack Vamvas
connect string problem, Daniel Loose
- Re: connect string problem, Daniel Loose
- Re: connect string problem, Erland Sommarskog
  - Re: connect string problem, Daniel Loose
    - Re: connect string problem, Erland Sommarskog
    - Re: connect string problem, Daniel Loose
    - Re: connect string problem, Erland Sommarskog
Do foreign keys generate implicit indexes?, bobdurie@xxxxxxxxx
- Re: Do foreign keys generate implicit indexes?, Erland Sommarskog
- Re: Do foreign keys generate implicit indexes?, --CELKO--
- Re: Do foreign keys generate implicit indexes?, Tom van Stiphout
  - Re: Do foreign keys generate implicit indexes?, Dan Guzman
- Re: Do foreign keys generate implicit indexes?, Jack Vamvas
  - Re: Do foreign keys generate implicit indexes?, bobdurie@xxxxxxxxx
Audit table, finding first change for each item, rdraider
- Re: Audit table, finding first change for each item, Erland Sommarskog
Altova Software v2008 (with MS SQL Server support) is now available, announce
running status for jobs, Andy . H . Kwok
- Re: running status for jobs, Jack Vamvas
Create Function permission..., Matthew Wells
- Re: Create Function permission..., Erland Sommarskog
number of databases in sql server 2005, sledge
- Re: number of databases in sql server 2005, Erland Sommarskog
Delete or detach a Suspect database, rdraider
- Re: Delete or detach a Suspect database, Erland Sommarskog
  - Re: Delete or detach a Suspect database, rdraider
    - Re: Delete or detach a Suspect database, Erland Sommarskog
CREATE Table permission, Sharif Islam
- Re: CREATE Table permission, Erland Sommarskog
Select statement help, krusz10
- Re: Select statement help, Erland Sommarskog
  - Re: Select statement help, krusz10
    - Re: Select statement help, Erland Sommarskog
How Do I give EXECUTE Permissions on Stored Procedures?, alvinstraight38@xxxxxxxxxxx
- Re: How Do I give EXECUTE Permissions on Stored Procedures?, Sharif Islam
- Re: How Do I give EXECUTE Permissions on Stored Procedures?, Erland Sommarskog
  - Re: How Do I give EXECUTE Permissions on Stored Procedures?, alvinstraight38@xxxxxxxxxxx
    - Re: How Do I give EXECUTE Permissions on Stored Procedures?, Erland Sommarskog
Super Function II, steve
- Re: Super Function II, Ed Murphy
  - Re: Super Function II, steve
    - Re: Super Function II, Ed Murphy
    - Re: Super Function II, --CELKO--
How to select count records that "contain" data?, Terry Olsen
- Re: How to select count records that "contain" data?, Spook
  - Re: How to select count records that "contain" data?, Terry Olsen
    - Re: How to select count records that "contain" data?, Ed Murphy
    - Re: How to select count records that "contain" data?, Arto V Viitanen
    - Re: How to select count records that "contain" data?, Ed Murphy
Re: SELECT * vs SELECT col1, col2, Serge Rielau
- Re: SELECT * vs SELECT col1, col2, Erland Sommarskog
Creating a View from a Stored procedure, apothecary
- Re: Creating a View from a Stored procedure, Roy Harvey (MVP)
Nightly Refresh, rohini . srigiriraju
- Re: Nightly Refresh, Erland Sommarskog
Market News. QSC partners with Yellowfin Business Intelligence, YellowFin Announcements
How do I view table information such as constraints?, ben_cameron00
- Re: How do I view table information such as constraints?, Roy Harvey (MVP)
  - Re: How do I view table information such as constraints?, Sems
Problems with URL's, Brian Vind
Using ASP.NET to login to SQL Server 2005 Database, AMD_GAMER
- Re: Using ASP.NET to login to SQL Server 2005 Database, Erland Sommarskog
  - Re: Using ASP.NET to login to SQL Server 2005 Database, AMD_GAMER
Using Scalar functions in views, mcleana
- Re: Using Scalar functions in views, Erland Sommarskog
- Re: Using Scalar functions in views, Gert-Jan Strik
How to work with time in format 'hhh:mm:ss' (more than 24 hours), brazil.mg.marcus.vinicius.lima
- Re: How to work with time in format 'hhh:mm:ss' (more than 24 hours), Roy Harvey (MVP)
  - Re: How to work with time in format 'hhh:mm:ss' (more than 24 hours), brazil.mg.marcus.vinicius.lima
  - Re: How to work with time in format 'hhh:mm:ss' (more than 24 hours), brazil.mg.marcus.vinicius.lima
    - Re: How to work with time in format 'hhh:mm:ss' (more than 24 hours), Roy Harvey (MVP)
win2k3 sp2 and sql server 2k, mmark751969
- Re: win2k3 sp2 and sql server 2k, Erland Sommarskog
Comparing databases, ByB
- Re: Comparing databases, David Portas
  - Re: Comparing databases, dvdtknsn
- Re: Comparing databases, mcleana
- Re: Comparing databases, Mork69
Design Table; Columns/Description get with SP???, vesta
- Re: Design Table; Columns/Description get with SP???, Roy Harvey (MVP)
  - Re: Design Table; Columns/Description get with SP???, vesta
    - Re: Design Table; Columns/Description get with SP???, Erland Sommarskog
    - Re: Design Table; Columns/Description get with SP???, Roy Harvey (MVP)
- <Possible follow-ups>
- Design Table; Columns/Description get with SP???, vesta
Re: time conversion hiccup, Pall Bjornsson
- Re: time conversion hiccup, DonLi2006
  - Re: time conversion hiccup, DonLi2006
    - Re: time conversion hiccup, Ed Murphy
    - Re: time conversion hiccup, DonLi2006
ODBC & Remote SQL Server, pradeep
- Re: ODBC & Remote SQL Server, vijay
Retrieve ONLY first/max, Mark
- Re: Retrieve ONLY first/max, Nick Chan
- Re: Retrieve ONLY first/max, David Portas
  - Re: Retrieve ONLY first/max, Ed Murphy
    - Re: Retrieve ONLY first/max, David Portas
    - Re: Retrieve ONLY first/max, Mark
    - Re: Retrieve ONLY first/max, Erland Sommarskog
    - Re: Retrieve ONLY first/max, --CELKO--
    - Re: Retrieve ONLY first/max, Mark
MS SQL compare columns to generate display name, Yas
- Re: MS SQL compare columns to generate display name, Yas
  - Re: MS SQL compare columns to generate display name, Roy Harvey
- Re: MS SQL compare columns to generate display name, Erland Sommarskog
  - Re: MS SQL compare columns to generate display name, Yas
    - Re: MS SQL compare columns to generate display name, Erland Sommarskog
Making money from google is hard, rock1
Monitoring MSSQL server 2005 from Linux, aleu@xxxxx
Require Solution for this SQL problem, Nick
- <Possible follow-ups>
- Re: Require Solution for this SQL problem, David Portas
- Re: Require Solution for this SQL problem, Erland Sommarskog
variables in constraints, scripting partition sliding, bobdurie@xxxxxxxxx
- Re: variables in constraints, scripting partition sliding, Erland Sommarskog
  - Re: variables in constraints, scripting partition sliding, bobdurie@xxxxxxxxx
    - Re: variables in constraints, scripting partition sliding, Erland Sommarskog
    - Re: variables in constraints, scripting partition sliding, bobdurie@xxxxxxxxx
Select Records and Insert into Text File?, junkmail115
- Re: Select Records and Insert into Text File?, Jack Vamvas
- Re: Select Records and Insert into Text File?, Erland Sommarskog
Reducing many-to-many to one-to-one, nick
- Re: Reducing many-to-many to one-to-one, Hugo Kornelis
  - Re: Reducing many-to-many to one-to-one, nick
Search for specific length string in column, mike
- Re: Search for specific length string in column, Jack Vamvas
- Re: Search for specific length string in column, Hugo Kornelis
  - Re: Search for specific length string in column, Erland Sommarskog
    - Re: Search for specific length string in column, Hugo Kornelis
- Re: Search for specific length string in column, --CELKO--
HTTP POST in SQL Server 2005, Nick Chan
- Re: HTTP POST in SQL Server 2005, Erland Sommarskog
  - Re: HTTP POST in SQL Server 2005, Nick Chan
Opzn Forum 4 ALL, highspamer
indexes, DaveP
- Re: indexes, Erland Sommarskog
  - Re: indexes, DaveP
HELP ME! Error occurred during creation or modify of a DTS Package, dreamsurf
Partition Optimization, traceable1
- Re: Partition Optimization, Erland Sommarskog
  - Re: Partition Optimization, traceable1
    - Re: Partition Optimization, Erland Sommarskog
    - Re: Partition Optimization, traceable1
    - Re: Partition Optimization, Erland Sommarskog
Re: SQL Slow from MSDE 2000 to SQL Express, Beowulf
Track which condition was true in a stored procedure, Nate
- Re: Track which condition was true in a stored procedure, ZeldorBlat
  - Re: Track which condition was true in a stored procedure, Nate
- Re: Track which condition was true in a stored procedure, --CELKO--
Storing pictures in database, Zeljko Bilandzija
- Re: Storing pictures in database, Greg D. Moore \(Strider\)
- Re: Storing pictures in database, Erland Sommarskog
  - Re: Storing pictures in database, Zeljko Bilandzija
    - Re: Storing pictures in database, Erland Sommarskog
strange error: ran out of internal resources, Emin
- Re: strange error: ran out of internal resources, Erland Sommarskog
  - Re: strange error: ran out of internal resources, Emin
    - Re: strange error: ran out of internal resources, Erland Sommarskog
Deadlock in SQL Server 2005 sp2 running queries using temp tables or table variables, Sputnik
- Re: Deadlock in SQL Server 2005 sp2 running queries using temp tables or table variables, Erland Sommarskog
import database to another server - howto, info
- Re: import database to another server - howto, Greg D. Moore \(Strider\)
Trying to create a linked server from an SQL Server to another SQL Server on another machine., gdev
- Re: Trying to create a linked server from an SQL Server to another SQL Server on another machine., Erland Sommarskog
How would you... (binary info in a table), James Fraser
- Re: How would you... (binary info in a table), Erland Sommarskog
  - Re: How would you... (binary info in a table), James Fraser
    - Re: How would you... (binary info in a table), Erland Sommarskog
    - Re: How would you... (binary info in a table), James Fraser
    - Re: How would you... (binary info in a table), Steve Kass
    - Re: How would you... (binary info in a table), James Fraser
integratedSecurity login from Linux -> SQL Server 2005?, aj
Query Help using SQL Server, amj1020
- Re: Query Help using SQL Server, Erland Sommarskog
Re: SQL Server error, Leisses Loud
- Re: SQL Server error, Erland Sommarskog
  - Re: SQL Server error, Leisses Loud
simple OUTER JOIN (I thought), tescodiscolondon
- Re: simple OUTER JOIN (I thought), tescodiscolondon
  - Re: simple OUTER JOIN (I thought), Ed Murphy
Can't log in as sa, Bill E.
- Re: Can't log in as sa, Greg D. Moore \(Strider\)
  - Re: Can't log in as sa, Bill E.
    - Re: Can't log in as sa, Greg D. Moore \(Strider\)
- Re: Can't log in as sa, Roy Harvey
  - Re: Can't log in as sa, Bill E.
Re: Dinamyc Function, Ed Murphy
Re: INNER JOIN - INSERT, Ed Murphy
CREATE TABLE syntax error..., bodyboarder20
- Re: CREATE TABLE syntax error..., bodyboarder20
Identity Column in INFORMATION_SCHEMA or the sys tables, Wing9897
Understanding tables as variables, steve
Compare based on table values., Rex
- Re: Compare based on table values., Ed Murphy
- Re: Compare based on table values., Erland Sommarskog
Can anyone help with Oracle 9i Database and Biztalk Adapters? ASAP, danielbjennings
Space Required to store a file in database, apondu
- Re: Space Required to store a file in database, Erland Sommarskog
Multiple records in one row, Ray
- Re: Multiple records in one row, Ed Murphy
  - Re: Multiple records in one row, Ray
    - Re: Multiple records in one row, Erland Sommarskog
Live updates?, Enter The
Streaming database updates?, webmaster
Add records in a table, Hamilton sucks
- Re: Add records in a table, David Portas
  - Re: Add records in a table, Erland Sommarskog
    - Re: Add records in a table, David Portas
    - Re: Add records in a table, Hamilton sucks
    - Re: Add records in a table, David Portas
  - Re: Add records in a table, Hamilton sucks
Updating a row in a recordset, Charlie
- Re: Updating a row in a recordset, Erland Sommarskog
- Re: Updating a row in a recordset, Dan Guzman
Re: Knowledgeable yet simple book for database modelling or database design, vicky
char vs varchar and indexes, Nick Chan
- Re: char vs varchar and indexes, Nick Chan
- Re: char vs varchar and indexes, Erland Sommarskog
- Re: char vs varchar and indexes, Gert-Jan Strik
  - Re: char vs varchar and indexes, Nick Chan
SSIS - how to fail the package when the for each loop container finds no files, KR
Complicated query, Nick
- <Possible follow-ups>
- Complicated query, Nick
  - Re: Complicated query, Roy Harvey
    - Re: Complicated query, Nick
FTP DOWNLOAD! CRACKED SOFTWARE/SOFTWARE CRACKS/DONGLE CRACKS/WAREZ CD/DONGLE EMULATORS/CODES/SERIALS, John Peterson
JDBC connections w/ AD login?, aj
sql rules and udt, Nick Chan
- Re: sql rules and udt, Dan Guzman
- Message not available
  - Re: sql rules and udt, Nick Chan
    - Re: sql rules and udt, --CELKO--
    - Re: sql rules and udt, Nick Chan
    - Re: sql rules and udt, --CELKO--
    - Re: sql rules and udt, Nick Chan
Re: Dynamic Columns, Ed Murphy
Help needed: Granting Create table permisions on specific Schema Options, gdev
- Re: Help needed: Granting Create table permisions on specific Schema Options, Erland Sommarskog
Re: Need help w/ a script, click37
- Re: Need help w/ a script, Erland Sommarskog
  - Re: Need help w/ a script, click37
Grouping similar rows, jan_soderman
- Re: Grouping similar rows, Hugo Kornelis
Data Mining Training gives No Results, ist
Importing images to SQL Server 2005 Express Edition database, pompair
- Re: Importing images to SQL Server 2005 Express Edition database, Dan Guzman
Changing data-types, Danny
- Re: Changing data-types, Greg D. Moore \(Strider\)
- Re: Changing data-types, Gert-Jan Strik
- Re: Changing data-types, Erland Sommarskog
  - Re: Changing data-types, Danny
String/Date Concatenation causes conversion error - streamline fix suggestions, Chris H
- Re: String/Date Concatenation causes conversion error - streamline fix suggestions, Shiju Samuel
  - Re: String/Date Concatenation causes conversion error - streamline fix suggestions, Chris H
Re: Restore LDF file after restoring backups in SQL Server 2005?, l0b0
Re: Run all .sql files (scripts) in project (SQL Server 2005 SP2), xman
Format for six character date, robboll
- Re: Format for six character date, Shiju Samuel
Is ROLLUP really better than doing a nested query when rank is involved?, csimam
- Re: Is ROLLUP really better than doing a nested query when rank is involved?, Jason Lepack
  - Re: Is ROLLUP really better than doing a nested query when rank is involved?, csimam
Different collations in a database, urquell
- Re: Different collations in a database, Erland Sommarskog
Advanta releases ATLAS BI using Yellowfin Business Intelligence, YellowFin Announcements
Re: forming a string with dateparts, Dan Guzman
Snapshot query, jrpfinch
- Re: Snapshot query, Shiju Samuel
SQL Logshipping 2005 - Load Delay Period Problem, pramodbura
Increasingly greater amounts of redundant aggregate data in queries?, csimam
- Re: Increasingly greater amounts of redundant aggregate data in queries?, csimam
- Re: Increasingly greater amounts of redundant aggregate data in queries?, Erland Sommarskog
  - Re: Increasingly greater amounts of redundant aggregate data in queries?, csimam
    - Re: Increasingly greater amounts of redundant aggregate data in queries?, csimam
    - Re: Increasingly greater amounts of redundant aggregate data in queries?, Erland Sommarskog
    - Re: Increasingly greater amounts of redundant aggregate data in queries?, Steve Kass
    - Message not available
    - Re: Increasingly greater amounts of redundant aggregate data in queries?, Erland Sommarskog
Apparent DB engine bug in SQL Server 2005, Dimitri Furman
- Re: Apparent DB engine bug in SQL Server 2005, Erland Sommarskog
  - Re: Apparent DB engine bug in SQL Server 2005, Dimitri Furman
    - Re: Apparent DB engine bug in SQL Server 2005, Erland Sommarskog
    - Re: Apparent DB engine bug in SQL Server 2005, Dimitri Furman
    - Re: Apparent DB engine bug in SQL Server 2005, Dimitri Furman
    - Re: Apparent DB engine bug in SQL Server 2005, Erland Sommarskog
    - Re: Apparent DB engine bug in SQL Server 2005, Dimitri Furman
    - Re: Apparent DB engine bug in SQL Server 2005, Erland Sommarskog
    - Re: Apparent DB engine bug in SQL Server 2005, Dimitri Furman
    - Re: Apparent DB engine bug in SQL Server 2005, Erland Sommarskog
    - Re: Apparent DB engine bug in SQL Server 2005, Dimitri Furman
    - Re: Apparent DB engine bug in SQL Server 2005, Erland Sommarskog
- Re: Apparent DB engine bug in SQL Server 2005, Dan Guzman
Re: Migrating Database changes to Production, Erland Sommarskog
- <Possible follow-ups>
- Re: Migrating Database changes to Production, Mork69
Re: problem with subselect, Erland Sommarskog
- Re: problem with subselect, Bart op de grote markt
  - Re: problem with subselect, Erland Sommarskog
    - Re: problem with subselect, Chris.Cheney
    - Re: problem with subselect, Bart op de grote markt
- <Possible follow-ups>
- Re: problem with subselect, Bart op de grote markt