Home > Archive > Microsoft SQL Server forum > September 2005









Pages: [1] 2

Posts(4)September 30, 2005, 8:24 pmHowto set Access Recordsource onto a "select" sproc
Posts(10)September 30, 2005, 8:23 pmordering an int column
Posts(1)September 30, 2005, 8:23 pmRe: filter for DELETE
Posts(1)September 30, 2005, 1:23 pmRe: filter for DELETE
Posts(5)September 30, 2005, 11:23 amPerformance and second table
Posts(5)September 30, 2005, 11:23 amSQL Server Hanging
Posts(5)September 30, 2005, 11:23 amHow to check Backup of SQL Server Database
Posts(1)September 30, 2005, 7:23 amjacek@karczmarczyk.pl
Posts(3)September 29, 2005, 8:24 pmNeed help formulating a query
Posts(1)September 29, 2005, 8:24 pmRe: NAMED SET / PIVOT TABLE !! HELP ME
Posts(2)September 29, 2005, 8:24 pmHELP MDX , NAMED SET AND PIVOT TABLES !!
Posts(3)September 29, 2005, 8:23 pmControlling fields in a select statement by use of parameters
Posts(4)September 29, 2005, 8:23 pmASP.NET + SQL 2005
Posts(8)September 29, 2005, 11:23 amSA can not create users
Posts(3)September 29, 2005, 11:23 amHow to convert from CHAR to Numeric in the table
Posts(2)September 29, 2005, 3:23 amHOW TO PLACE NAMED SET INTO A PIVOT TABLE !!!!
Posts(2)September 29, 2005, 3:23 amSQL Server 2000 Backup + Restore question
Posts(18)September 29, 2005, 3:23 amConnecting Trace info to blocked users?
Posts(1)September 28, 2005, 8:24 pmNAMED SET / PIVOT TABLE !! HELP ME
Posts(4)September 28, 2005, 8:24 pmNewbie trigger question
Posts(4)September 28, 2005, 8:24 pmFast Date Ranges Without Loops In SQL Server 2000
Posts(6)September 28, 2005, 8:24 pmHow to remove MSDE manually?
Posts(2)September 28, 2005, 11:24 amProblem causing me to have to restore tlogs WITH MOVE
Posts(3)September 28, 2005, 11:24 amVB 6 & SQL Database: How can I create reports with charts ?
Posts(4)September 28, 2005, 11:23 amWhy dosn't IIF work here?
Posts(3)September 28, 2005, 11:23 amSQL Server bouncing connections
Posts(3)September 28, 2005, 11:23 amSQL 2000 installation on WinXP Pro problems
Posts(4)September 28, 2005, 11:23 amTools for design recovery (reengineering) of C# source code with embedded sql statements ?
Posts(5)September 28, 2005, 11:23 amIs there any way in a sproc to LOOP thru the records of a table ?
Posts(5)September 28, 2005, 11:23 amLinked server
Posts(6)September 28, 2005, 11:23 amHowto Format a string in a sproc ?
Posts(3)September 28, 2005, 11:23 amStopping Query Execution from PHP
Posts(2)September 28, 2005, 9:23 amSQL Mail setup
Posts(4)September 28, 2005, 7:24 amDatabase Replication
Posts(3)September 28, 2005, 7:24 amMultiple entries script...help
Posts(3)September 28, 2005, 7:23 amTransaction log ???
Posts(5)September 28, 2005, 7:23 amCan I speed up this script...help?
Posts(2)September 28, 2005, 3:24 amHowto setup my user in order to grant him the drop privilege
Posts(3)September 28, 2005, 3:24 amAccess Control List (structure) invalid - updating Virtual directory information
Posts(2)September 27, 2005, 8:24 pmRestoring a missing db
Posts(1)September 27, 2005, 8:24 pmJob invoked by Alert but Alert never occured
Posts(11)September 27, 2005, 11:24 amIDENT_CURRENT and empty table
Posts(7)September 27, 2005, 9:23 amConsolidating Records
Posts(4)September 26, 2005, 8:24 pmiSQL - Blank line at the end of the iSql output file
Posts(4)September 26, 2005, 8:24 pmFinding the most recient datetime
Posts(2)September 26, 2005, 8:24 pmSimple question
Posts(2)September 26, 2005, 8:24 pmDoes DBCC DBREINDEX update stats?
Posts(8)September 26, 2005, 8:24 pmDynamic data elements for a data collection application
Posts(3)September 26, 2005, 7:23 amdate format
Posts(1)September 25, 2005, 8:23 pmRe: Is there a way to find growth in log (ldf) and database(mdf) ?
Posts(1)September 25, 2005, 8:23 pmRe: SQL Mail - MAPI profiles on Windows Server 2003
Posts(1)September 25, 2005, 11:23 amRe: SQL Mail - MAPI profiles on Windows Server 2003
Posts(5)September 25, 2005, 3:23 amStumped by SQL challenge
Posts(10)September 24, 2005, 8:23 pmBlocking and Transactions OK?
Posts(3)September 24, 2005, 8:23 pmbit off topic: street name database US
Posts(5)September 24, 2005, 7:23 amThe SMTP Server in xp_smtp_sendmail
Posts(9)September 24, 2005, 3:23 amSyntax to add records if primary key = list
Posts(3)September 23, 2005, 8:23 pmError : Difference of two datetime columns caused overflow at runtime.
Posts(7)September 23, 2005, 8:23 pmsearching a list of tables, derived from another table
Posts(1)September 23, 2005, 8:23 pmError : Difference of two datetime columns caused overflow at runtime.
Posts(1)September 23, 2005, 8:23 pmRe: SQL Mail - MAPI profiles on Windows Server 2003
Posts(5)September 23, 2005, 9:23 amnewbie - empty result set for all queries?
Posts(2)September 23, 2005, 9:23 amI tried these .....
Posts(4)September 23, 2005, 9:23 amupdating multiple fields
Posts(7)September 22, 2005, 8:24 pmsearch on concatenated fields in sql server
Posts(2)September 22, 2005, 8:24 pmSQLColumns crash (Access violation)
Posts(2)September 22, 2005, 8:24 pmReport Services
Posts(2)September 22, 2005, 8:24 pmRe: Is there a way to find growth in log (ldf) and database(mdf) ?
Posts(3)September 22, 2005, 8:24 pmAny way to find out which SP is updating data in a specific table?
Posts(4)September 22, 2005, 8:24 pmmin(date) + 1
Posts(5)September 22, 2005, 8:24 pmdelete records
Posts(5)September 22, 2005, 1:23 pmHelp finding the top 3 zipcodes within the top 5 counties
Posts(1)September 22, 2005, 11:24 amRe: Is there a way to find growth in log (ldf) and database(mdf) ?
Posts(1)September 22, 2005, 7:23 amPASS User Group Austria looking for MS-SQL professionals to take part
Posts(1)September 22, 2005, 7:23 amRe: Is there a way to find growth in log (ldf) and database(mdf) ?
Posts(1)September 22, 2005, 3:23 amIs there a way to find growth in log (ldf) and database(mdf) ?
Posts(10)September 22, 2005, 3:23 amsqlmaint.exe failed
Posts(2)September 22, 2005, 3:23 amXP and Replication
Posts(1)September 22, 2005, 3:23 amRe: Is there a way to find growth in log (ldf) and database(mdf) ?
Posts(3)September 21, 2005, 8:23 pmRenaming a Server
Posts(8)September 21, 2005, 8:23 pmScheduling Database - Design Help!
Posts(3)September 21, 2005, 8:23 pmOriginal Data and Log size
Posts(3)September 21, 2005, 11:24 amRejoining replicating servers
Posts(2)September 21, 2005, 9:24 aminline if
Posts(3)September 21, 2005, 7:23 amMDF / LDF
Posts(5)September 21, 2005, 7:23 amInsert based on a select query
Posts(2)September 21, 2005, 3:24 amData Load Query
Posts(6)September 21, 2005, 3:24 amHow to update 1000s of items in 50 tables
Posts(2)September 20, 2005, 8:23 pmbcp header
Posts(3)September 20, 2005, 11:23 amDelete relationship?
Posts(1)September 20, 2005, 9:23 am[ANNOUNCE] DataDirect Technologies Releases DataDirect XQuery to Simplify XML and Relational Data I
Posts(9)September 20, 2005, 9:23 amSingle quote in NVARCHAR string?
Posts(1)September 20, 2005, 9:23 amDataDirect Technologies Releases DataDirect XQuery to Simplify XML and Relational Data Integration
Posts(1)September 20, 2005, 9:23 am[ANNOUNCE] DataDirect Technologies Releases DataDirect XQuery to Simplify XML and Relational Data I
Posts(1)September 20, 2005, 7:23 am[ANNOUNCE] DataDirect Technologies Releases DataDirect XQuery to Simplify XML and Relational Data I
Posts(9)September 20, 2005, 3:24 amReg Exp for digits
Posts(3)September 20, 2005, 3:24 amScheduling Database - Design Help!
Posts(3)September 19, 2005, 8:24 pmIdentity...I need to get the last (or highest number in Identity column)...
Posts(4)September 19, 2005, 8:24 pmSQL Server paged recordset problem
Posts(2)September 19, 2005, 7:23 amCan't connect
Posts(7)September 18, 2005, 8:23 pmNOLOCK and READPAST on same table?
Posts(2)September 18, 2005, 1:26 pmConverting Binary Image to Readable Text
Posts(29)September 18, 2005, 3:23 amoracle pl/sql -> sql server
Posts(5)September 17, 2005, 8:24 pmDetermine fastest query in Query Analyzer
Posts(4)September 17, 2005, 9:23 amQuery Syntax help
Posts(4)September 17, 2005, 9:23 amUsing IS NOT NULL on column result from subquery
Posts(2)September 17, 2005, 3:23 amAliased column in stored procedure not seen by datagrid
Posts(4)September 17, 2005, 3:23 amRemoving white spaces in a varchar column
Posts(3)September 16, 2005, 8:23 pmSQL Mail - MAPI profiles on Windows Server 2003
Posts(2)September 16, 2005, 8:23 pmBest way to tell if a SP is a query Programatically
Posts(6)September 16, 2005, 7:23 amExtremely Slow Table
Posts(8)September 16, 2005, 3:24 amdesinstall MS SQL
Posts(8)September 15, 2005, 8:24 pmCan someone help me with multiple "Left Outer Joins"?
Posts(2)September 15, 2005, 1:23 pmhow to do text replacements
Posts(4)September 15, 2005, 1:23 pmDont backup if Database hasnt changed
Posts(1)September 15, 2005, 10:03 amHow to change column to be non-identity ?
Posts(4)September 15, 2005, 9:23 amThe "right" way to distribute a database to end-user
Posts(4)September 15, 2005, 7:23 amsaving output from multiple queries
Posts(2)September 15, 2005, 7:23 amNeed Help with "Left Outer Join"...
Posts(1)September 15, 2005, 3:24 amCan someone help me with multiple "Left Outer Joins"?
Posts(14)September 14, 2005, 8:24 pmAbout adding a new column...
Posts(1)September 14, 2005, 8:24 pmRe: How Do I Prevent SQL 2000 From Posting This Message To The Event
Posts(15)September 14, 2005, 8:24 pmTotal Newbie - Maintainenance of SQL Database
Posts(5)September 14, 2005, 11:23 amHelp on a SQL query
Posts(5)September 14, 2005, 7:23 amSCOPE_INDENTITY() Not Returning
Posts(3)September 14, 2005, 7:23 amxp_sendmail problem - body message breaking onto new line..
Posts(6)September 14, 2005, 3:23 amImmediate Synchronization?
Posts(7)September 14, 2005, 3:23 amHow to override zero rows returned
Posts(5)September 14, 2005, 3:23 amOutput stored procedures as text problem
Posts(2)September 14, 2005, 3:23 amScript to search for a string in all varchar columns in all tables in a database?
Posts(3)September 13, 2005, 8:24 pmSaving query plan
Posts(2)September 13, 2005, 8:24 pmXML generation issues
Posts(3)September 13, 2005, 8:24 pmFind the Stored procedure
Posts(1)September 13, 2005, 8:23 pm[ANNOUNCE] Build Fabulous XML Schemas With Stlyus Studio
Posts(3)September 13, 2005, 11:23 amHow to count
Posts(2)September 13, 2005, 11:23 amMonitoring Software
Posts(5)September 13, 2005, 7:23 amsql datatype help
Posts(5)September 13, 2005, 7:23 amChanging From Windows To Mixed Authentication
Posts(4)September 13, 2005, 7:23 amHow do I write a query to get the path from ancestor to node in a tree?
Posts(11)September 13, 2005, 7:23 amReturn from store procedure.
Posts(2)September 13, 2005, 7:23 amImport Spreadsheet error
Posts(2)September 13, 2005, 7:23 amXML Tables generation
Posts(7)September 12, 2005, 8:24 pmAny SELECT Statement Gurus Out There?
Posts(3)September 12, 2005, 8:24 pmHelp with calling a job from Stored P and VBA......HELP
Posts(3)September 12, 2005, 8:24 pmSystematically determine DRI problem(s)
Posts(5)September 12, 2005, 8:24 pmsql query question....
Posts(1)September 12, 2005, 11:23 amdesinstall MS SQL
Posts(2)September 12, 2005, 9:25 amsp_xml_preparedocument
Posts(3)September 12, 2005, 7:23 amstored procedures using external applications
Posts(3)September 12, 2005, 3:27 amReporting Services - Crystal to SSRS
Posts(1)September 11, 2005, 7:23 ammp3dia online
Posts(4)September 11, 2005, 3:23 amExecute DTS package from .adp ?
Posts(2)September 10, 2005, 1:23 pmSQLMANGR.EXE optional parameters?
Posts(5)September 10, 2005, 1:23 pmData changes made late at night "dissapear"
Posts(3)September 10, 2005, 11:23 amconnection based temp tables
Posts(5)September 10, 2005, 11:23 aminner joins
Posts(4)September 9, 2005, 8:24 pmCreating Text File from Stored Procedure
Posts(3)September 9, 2005, 8:24 pmSQL script - sum total issue
Posts(10)September 9, 2005, 8:24 pmselect * from table where column = @AllValues?
Posts(2)September 9, 2005, 1:24 pmproblem - open recordset - ADO
Posts(3)September 9, 2005, 1:24 pmLocation of logging for temp tables
Posts(2)September 9, 2005, 1:24 pmVersion of Windows Server?
Posts(3)September 9, 2005, 11:23 amtable copy misses indexes
Posts(4)September 9, 2005, 3:23 amProblem with case statement
Posts(6)September 9, 2005, 3:23 amHow do I find the highest Unique Identifier?
Posts(4)September 8, 2005, 8:23 pmProblem with uncommited transactions in log-file
Posts(5)September 8, 2005, 8:23 pmInserting large amounts of data
Posts(3)September 8, 2005, 8:23 pmbcp utf8 file
Posts(2)September 8, 2005, 1:25 pmExtracting Time from the SQL DateTime field.
Posts(3)September 8, 2005, 1:25 pmHow to BCP IN to table with IDENTITY column
Posts(2)September 8, 2005, 1:25 pmReading an XML dataset into a SQL Server dynamically
Posts(7)September 8, 2005, 11:24 amMassive delete in DB
Posts(5)September 8, 2005, 7:23 amthe 'DEFAULT' filegroup is full
Posts(5)September 8, 2005, 7:23 amLogshipping
Posts(4)September 8, 2005, 7:23 amSQLDMO Object
Posts(3)September 8, 2005, 3:23 amwriting SQL data to XML files
Posts(7)September 7, 2005, 8:24 pmlist of clustered index in the database
Posts(2)September 7, 2005, 8:24 pmDTS- Add global varible's value to text file
Posts(3)September 7, 2005, 8:24 pmMulti-table UDF not returning all rows
Posts(1)September 7, 2005, 8:24 pm[ANNOUNCE] Caught on Tape: Bi-Directional EDI to XML Mapping!
Posts(10)September 7, 2005, 8:24 pmMemory usage in SQL Server
Posts(2)September 7, 2005, 1:24 pmSchedule a T-SQL Script
Posts(3)September 7, 2005, 1:24 pmbrain teaser - stagger the order of the results
Posts(3)September 7, 2005, 9:23 amjoining one table with itself
Posts(2)September 7, 2005, 7:23 amSlow stored procedures
Posts(2)September 7, 2005, 7:23 amCrosstab Query
Posts(6)September 7, 2005, 3:25 amRegular Expression?
Posts(4)September 7, 2005, 3:25 amProblem writing XML files.
Posts(5)September 6, 2005, 8:23 pmDouble quotes replacement
Posts(1)September 6, 2005, 8:23 pm[ANNOUNCEMENT] Learn XQuery in 10 Minutes!
Posts(3)September 6, 2005, 8:23 pmSyntax? - Searching combined columns
Posts(4)September 6, 2005, 1:25 pmReplacing SELECT with a value in an OUTER JOIN
Posts(2)September 6, 2005, 1:25 pmGetting count with multiple fields
Posts(2)September 6, 2005, 9:23 amJDBC deadlock on unrelated records
Posts(2)September 6, 2005, 3:23 amEscape characters
Posts(30)September 4, 2005, 8:23 pmAll records within x minutes of each other
Posts(3)September 4, 2005, 8:23 pmQuestion about Service Pack
Posts(4)September 4, 2005, 11:23 amSlow Query Through Cold Fusion
Posts(4)September 3, 2005, 8:23 pmProblem expanding a Db table (SQL Server 2000)
Posts(2)September 3, 2005, 7:23 amosql doesn't work - SOLVED

Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com