TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
30801: Filtering Mass Records
30802: temp table
30803: Show the records that contain "special word" first in SQL query re
30804: Please help...can not connect to sql server 2005
30805: Sorting Text Dates
30806: SQL Server 2000: How to inject a COLUMN VALUE into an EMAIL???
30807: Aggregate Transpose Problem
30808: Sales Average Query
30809: smo disbale job
30810: Dynamic Criteria for a Stored Procedure
30811: bulk insert question? Another way?
30812: Torn Page Error
30813: Need help optimizing a stored procedure - SQL2k
30814: SQL Bug??
30815: Left Outer Join and Where Clause
30816: finding missing dates in a sequence
30817: 2 variables 2 sql server connections?
30818: DTS - SQL Database to Access Database
30819: Update Query question.
30820: trigger and INSERTED
30821: Customer specific price matrix design (Long)
30822: Comparing Queries via Graphical Query Execution Plan
30823: is recordset open?
30824: Using SubString With a Select Statement
30825: New version of Books Online and new/updated samples available for download
30826: select from mulitple databases and join
30827: How Do I connect to a Mobile SQL DB from VB2005 - Windows App
30828: Finding out if a table has changed?
30829: Removing "special characters" from VarChar
30830: Limiting the amount of data used between two tables
30831: How to configure the server notification in SQL 2005.
30832: Converting table date
30833: IF Statement Syntax
30834: Windows Authentication vs SA Password
30835: Error number table?
30836: Query Analyzer usage
30837: Pass a "Begin...End" Block from ASP
30838: appending a temporary table to another temporary table
30839: COUNT (DISTINCT (myfield)) PROBLEM
30840: Restore database error
30841: Replace List
30842: =?iso-8859-1?q?TRANSFORME_R$6,00_EMR$6.000.000_EM_POUQUISS=CDMO_TEMPO!!!!!?=
30843: SQL Server & MySQL from VB6
30844: Realtive query cost in the execution plan
30845: Multi-language support question
30846: Decimal data type
30847: smalldatetime,varchar and CASE
30848: Database Naming
30849: Parsing spaces
30850: Verfy file path from SQL 2k
30851: Finding and updating all rows with the same value in a column
30852: Another Way to Write this Query
30853: The command(s) completed successfully. - Can i turn this output off?
30854: preparing monthly report
30855: "Simple" query help
30856: A floating point exception occurred in the user process.
30857: Delete duplicate entry
30858: Reposted - Troubles setting variables
30859: Reposted - Troubles setting variables
30860: =?iso-8859-1?q?Parameter=FCbergabe?=
30861: How to increase no of level of Direct Recursive Triggers?
30862: Multilingual database design
30863: Deutsches Zahlenformat
30864: SELECT (left join)
30865: Passing entire SELECT and WHERE clause to a stored procedure
30866: need help - SP to move data
30867: Primary key without clustered index
30868: ERROR: "activex component can't create object: 'excel.application'"
30869: Same query much slow in function, any idea?
30870: Confusing question or should I address it some where else?
30871: Iterate through a list of files with bcp
30872: time stamp magicaly updated when ever update event occures on a row
30873: convert flat file to native file format for bcp
30874: cast inside check constraint???
30875: Return Status question....
30876: CONVERT Error Message
30877: DMO call GetImpersonateClient() fails on SQL Server 2005
30878: Create View in a Select statement ?
30879: Passing back more than 1 output parameter to VBA code
30880: condensing log files
30881: UNPIVOT two fields
30882: Query Help: Counts & Sums
30883: Why can't i use "AS" results in the WHERE clause?
30884: Using replimerg.exe from commandline
30885: Varchar limitation on 8000 problem in SQL Server 2000
30886: Instances list on remote IP
30887: Changing the Sender in XP_Sendmail
30888: Remote Connection Fails with Web Service
30889: Disappearing data (happens rarely)
30890: Order by Clause
30891: clustered vs non-clustered performance
30892: Searching For text in a self join
30893: Insert or Update Row if Primary key isn't pre-existing in table SQL 2000
30894: Year To Date?
30895: SQL Server - Lock timeouts performance problem
30896: Need a way to automate Grant permission
30897: trying to do some weird math in an update statement
30898: sql server bug?
30899: XOR and foreign key constraints
30900: Like operator returns unexpected records
30901: Why Can't I Paste in Access Frontend
30902: To get information about table
30903: Split
30904: duplicate check
30905: drop users connected to a database
30906: Syntax error.?
30907: searching tables
30908: Column default value
30909: default clustered index when selecting primary key
30910: How can I call a VB function from SQL Server SP?
30911: How to perform an update cube from a stored procedure ?
30912: SQL Server export to Oracle UTF8 problem
30913: unnecessary execution of trigger statements
30914: Update or Insert in my Trigger
30915: Looping through records
30916: Moving an Access Database to SQL Server.
30917: Variables Question - Wish to hide results.
30918: SQL-DMO Problem
30919: MCDBA Certification!
30920: Help finding record pairs
30921: Connect to SQL Server 2005 Express w/ Classic ASP
30922: SQL Pass-Through Query in Access
30923: Dynamic generating a SQL statement that includes "INTO #temp"?
30924: sql result set not matching the .net page
30925: Relesae Process Question
30926: sp_configure 'max_text_repl_size'
30927: Specialized output from two tables.
30928: Select Having?
30929: SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data ....
30930: DateAdd function in Stored Procedure
30931: When the job is complete?
30932: Connecting a stored procedure to another server
30933: Stored procedures to CREATE TABLE with n fields
30934: For each record in a table
30935: eliminate the Return charactor in a column
30936: Pass XML between SPROCs possible in SQL 2000? 2005?
30937: Stored procedure refer to another Stored Procedure ?
30938: Increment variable by each row in set
30939: The char '
30940: Reporting Services 2000 does not deliver attach documents by e-mail.
30941: truncate table
30942: import a text file into the database
30943: BULK INSERT
30944: Avoiding Temporary Tables
30945: between dates and times
30946: alter view question
30947: Query Designer???
30948: Help on Sybase Power Designeer
30949: Using Indexes for DATETIME datatype
30950: Query on XML column: fn:lower-case not working?
30951: Can't get MAX DISTINCT to work the way I want it to
30952: CASE and INSERT statements
30953: ALTER DATABASE dynamic SQL
30954: Sql Parse errors
30955: Conditional Where clause
30956: BUILTIN/ADMINISTRATORS
30957: Select query using SQL Helper functions
30958: Multi-Select in Query --- Possible?
30959: Joings between two table variables
30960: sp_who - sp_who2
30961: Index on Views ...
30962: Splitting a table (to speed things up)
30963: UPDATE using JOIN?
30964: IN clause bug
30965: Index Ratification
30966: Saving and Retrieving Binary Files in MSSQL 2005
30967: Querying an attributes table
30968: sql syntax string to execute
30969: explicit transaction in sql server 2000
30970: Dynamic SQL Problem
30971: Anyone Using 2005?
30972: Generating update statements
30973: User Privilege problem to Execute SQL Job from query
30974: How can I make SQL Server automatic generate scheme script for backup everyday?
30975: Function to return substring letters only
30976: osgl syntax problem
30977: import data properly from csv file.
30978: Table normalization to remove redundant data - Performance problem
30979: Error creating object SQL 7.0 using sp_oaCreate
30980: Force a round() when it's below a 5?
30981: Syntax to Restore a database renaming the original files
30982: index question
30983: Access - SQL 2005
30984: sql server alerts and sql server jobs
30985: SQL Search Query needed
30986: Assigning query output to a variable
30987: Sql 2005 maintaining Hierarchy problem
30988: Database locking issue
30989: help on select query
30990: Year comparison
30991: How do I handle time-zones?
30992: Formatting number in sql
30993: CLR Integration with Complex Types
30994: SQL Server command simular to Oracle's 'DESC'
30995: client deduping
30996: Join based on MIN DATEDIFF?
30997: Read data Page without using DBCC Page
30998: returning counts of all values in joined tables
30999: Getting the value of xp_cmdshell
31000: service manager equivalent in YUkon
31001: Force a round() when it's below a 5?
31002: ForignKeys and index
31003: Simple Erntr - Invalid Object
31004: code information for unused indexes in sql server
31005: which is most efficient? variables vs. nested select
31006: SQL Server Agent JOB failed while Query anlayzer success
31007: Problem With Case Function
31008: deploying CLR objects best practice
31009: Auto Commit
31010: Create Duplicate of table ?
31011: distinct query
31012: Number of lines of code in a SP
31013: How to pull query data from two databases?
31014: Query Result in Cache?
31015: Advice on Simple Structured Sql Query (Search)
31016: help Simple question
31017: [OT] User-Defined string Functions Transact-SQL
31018: Transactional Modification
31019: Transactional Modification
31020: @@ERROR per connection?
31021: Understand N'___'
31022: sp_send_cdosysmail with priority
31023: case statement TSQL
31024: joining 2 tables onto one
31025: Restore - Change Logical Name
31026: what is the best way to update data
31027: dumb sql mistake or SQL Server error?
31028: SSIS Packages
31029: How to refer to calculated field ?
31030: duplicate column data
31031: returning counts of different fields when only one has criteria
31032: Configuring SQL Mail
31033: question about dealing with deadlocks
31034: Multiple Step Stored Procedure
31035: size of the resultset
31036: from clause
31037: Relationship map using CTEs
31038: BCP copies only Integer data
31039: SQL Query help.
31040: Accessing Second Record Within Query
31041: maximum column_name length
31042: Loading 150k AD user objects into SQL2005
31043: CC and SSN encryption
31044: Getting the physical directory that the log file is located
31045: selecting from DBCC SHOWCONTIG
31046: Variable not passing parameters
31047: Need replacement for sybase list aggregate
31048: Is this an efficient way to return a comma string
31049: Filling in date records
31050: error processing
31051: Excel file import problem
31052: xp_smtp_sendmail weird behavior
31053: Passing Cursor as SP output parameter
31054: SQL Monitoring Tool
31055: multilingual asp.net calendar control
31056: Help on the last updated date
31057: FOR XML return as a Scalar
31058: BCP
31059: Debugging CLR Objects
31060: Are these two statements equivalent?
31061: Querying information_schema for check constraints
31062: Insert maximum integer value if it is exceeded
31063: Order By ignored in query participating in Union All
31064: Restore Database
31065: Call Stored Procedure within a SELECT statement
31066: SQL 2K, logging procedures execution
31067: How do you force the server to store only the text entered
31068: Determine Table's PK Columns
31069: SP to write to a Formatted Flat File
31070: Function to seperate comma delimited db field into new table
31071: suser_name()
31072: xp_cmdshell
31073: searching large fields
31074: speed Up
31075: Speed Up
31076: On delete cascade
31077: Query behaviour - (subquery results)
31078: I bet this is simple, -But see if you can help. Hard to come up with Title -Have a look
31079: Enable/Disable Triggers?
31080: adding column vlaues with one another
31081: Insert into (leaving certain) fields out
31082: Joining multiple tables in a view.
31083: INSERT - dynamically specifying DEFAULT for a column
31084: Problem with order by clause
31085: Visual Basic + SQLServer + CommandTimeout
31086: Update null records
31087: Use of AVG function to update records
31088: Newbie sqlserver question...
31089: how to save a rtf file into a field
31090: Run Dll In Stored Procedure
31091: dynamic sql string too long
31092: Trigger needs to join multiple tables to validate entry in table.
31093: Table Owners
31094: views based on parameter view
31095: How to protect data in table?
31096: Query Analyzer..
31097: Select a specific range of results
31098: Can truncate but not delete
31099: convert a datetime
31100: SP and Triggers: object permissions
31101: Help with SQL Function
31102: Any performance issues if we use BigInt
31103: queries filling up logfile
31104: Administrative Tasks
31105: Help..........
31106: unaccountable result for select
31107: SP clause - where (field = @Param or @param is null) is this fast?
31108: order of columns in composite index
31109: Delete invalid Details
31110: Delete Duplicate Record
31111: Recover the data
31112: SQL Server and Time Zome
31113: Free MCAD/MCSD ebooks online
31114: Find SQL solutions with free eBooks. Search the ebooks NOW.
31115: how to store a record before deleting it using triggers
31116: explanation needed - DECLARE CURSOR
31117: Hello, is there any intelligent life at M$?
31118: Excel file import to Sql Server problem
31119: Formatting numbers
31120: weekday or Weekend
31121: SQL Server index low cardinality columns
31122: Differences between DISTINCT and GROUP BY?
31123: running stored procedures from SQL Agent
31124: The weirdest SQL problem you'll ever see.
31125: Ole object to illustrate the Enterprise manager VIEW designer in a WORD document
31126: need output where same column has more than one pirce of data
31127: Transfer Table Relationships
31128: CopyFile in DTS ActiveX Script Task
31129: query help - "Most Helpful Review" idea
31130: SQL Agent Mess
31131: Endian problems with converting to varbinary
31132: IDENTITY and Backup/Restore
31133: Help developing this project.
31134: Finding the 2005 migration quite challenging
31135: Merging tables
31136: CLR Question (BASIC)
31137: Connection Problem with Remote Server
31138: Inserting dummy lines and padding
31139: Newbie: Timeout On IN statement
31140: How to get rowid of uncommitted record
31141: Size of a row
31142: DEADLOCKS
31143: global temporary tables
31144: ReCompileReferences using System SP?
31145: Determining Roles from Windows Authenticated Login
31146: Help with value
31147: Connection string for 1 server and 2 databases
31148: compatible ntwdblib.lib FOR ntwlib.dll in SQL Server 2000 SP4
31149: WHERE clause 'SET'
31150: Design: bit on or off?