TheMSsForum.com >> SQL Server Programming >> Archive Page 63 - The Microsoft Software Forum

view full version: back to formated view

21701: while doesn't display in Query Analyzer
21702: Displaying parameters in Reporting Services report
21703: Strange Error
21704: Required Tiff IFilter for indexing in Sql Server 2000
21705: Required Tiff IFilter for indexing in Sql Server 2000
21706: Run Local Package based on what day it is
21707: a Query performance real slow in 2005
21708: Count duplicate records
21709: convert S9(05) COMP-3 field to SQL Server datetime
21710: auto-complete Comboboxes in Reporting Services?
21711: Availability calendar
21712: Calling WebService from Trigger possible and advisable?
21713: Put a dynamic Boolean expression in an IF condition
21714: Synchronize to SQL Server via a GPRS
21715: Setting ANSI NULLS ON
21716: How to find SP line number
21717: how to get rid of 00:00:00 in date field
21718: Put a dynamic select result in a variable
21719: Query % "up-side-down"
21720: quick insert into help
21721: compare to NULL
21722: How to select multiple fields from a subquery?
21723: sp recompile problem
21724: remove leading , from varchar field
21725: sql question
21726: Query Lasts Years Sales
21727: Syntax Error in Inner Join
21728: Update Help
21729: Curious Conversion Failure During INSERT via SELECT
21730: Summarize data by date only
21731: 2005: Quickly Importing Data
21732: SQL Server table data validation
21733: Connection failure from ASP page after Upsizing to SQL server 200
21734: Query Question
21735: T-SQL COUNT() Question
21736: SQL2005: Replication - How to determine remote publisher instance?
21737: multiple calls to same stored procedure
21738: Storing XML
21739: saving sp output to variable
21740: Feedback on Red Gate tools
21741: How to specify INDEX when adding new column with ALTER statement
21742: How to return database role for all databases on the server...
21743: failure to use the update command with a cursor
21744: Help: don't understand this
21745: Debug Median calculation
21746: CLR equivalent of non existent xp_getfileDetails
21747: Multiple tables into one?
21748: group by month and show month with zero even when no data for it
21749: Database Design ROI
21750: IS numeric
21751: Date format
21752: SQLAGENT Logging - errorlogging_level
21753: sql statement problems
21754: query question
21755: Complex group by query
21756: Help with query
21757: process automation
21758: SQL Job
21759: Rows to Columns
21760: I don't want a distributed transaction!
21761: Executin plan selection
21762: Recommended DBA book(s), course(s), etc.
21763: Having problem with stored procedure and permissions
21764: UPDATE Trigger performance
21765: Can you fix this query : syscolumns and primarykey : SQL 2000
21766: Hashed passwords and secure data
21767: doing search using LIKE and ignore brackets
21768: SQL help!
21769: 2005: type defined in .NET
21770: Primary key column additionally in nonclustered indexes
21771: T-Script to create the "Create Table" Script
21772: kill transaction
21773: Assign a "record number" to each row through an UPDATE clause
21774: Find Sum of the fields in the table
21775: Copy data between two tables urgent help
21776: Determining a zero recordset
21777: Questions Concerning Nested SP
21778: There is a good photo website
21779: PIVOT Table Virgin - Why won't this work?
21780: High reads using .net application
21781: Command syntax
21782: BUG: PIVOT query causing Msg 8624 (9.00.2047.00)
21783: A Check on a trigger?
21784: Update/select?
21785: Using MAX on column already aggregated using COUNT
21786: Cast assistance required
21787: Pivot related query in SQL Server 2005
21788: Help with SQL statement
21789: Design: How to avoid violation of 2NF/splitting of compound primary key?
21790: kill command
21791: SP to save Image datatype to Disk
21792: Copying one record to another
21793: Access to the remote server is denied because no login-mapping exi
21794: Returning recordset with "empty" value
21795: Find bit fields with no default
21796: Denormalizing data, flattening data
21797: Checking null values in two tables
21798: EncryptByKey plain text character limit
21799: how do I write a command in SQL
21800: Creating a New Database using the Sql Server Management Studio
21801: Pick a substring
21802: Use of SELECT TOP 1
21803: Pass table name as parameter in stored procedure
21804: 2K5 Encrypted columns and resultant column length
21805: Insert into Select
21806: Pinpoint dead lock
21807: Insert into table or update record.
21808: similar data, same code, tables, stored procedure - production slower than development
21809: Database diagramming tools.
21810: Updating table on another server
21811: instead of trigger vs stored procedure
21812: derived columns in Parent - Child relation
21813: Counting hits in a text column
21814: Advise
21815: result set from Sp to a variable
21816: PLEASE HELP
21817: Determine date/time of last Windows Server reboot from a stored pr
21818: Returning table from function
21819: mail profile greyed out
21820: Having Clause Question
21821: Query / Report: Data not showing zero for null facility.
21822: How to find out SQL server is running or not
21823: Invalid column name
21824: Trying to serialize number of columns of table
21825: Track who changed a stored procedure
21826: Unknown error
21827: Rollback on error.
21828: How do you do nested ifs??
21829: How do I: Get columns referenced in Stored Procedure?
21830: DROP DEFAULT... how to?
21831: 2005: APPLY?
21832: Prevent The Cruelty
21833: memory not available
21834: LIKE restriction against multiple rows
21835: Select one record even if join table datas does not exists
21836: Synchronization
21837: Columnheaders from query analyser to excel - SQL 2005
21838: Automatic triggers
21839: HOW TO USE JOIN QUERIES
21840: SQL Server Memory Issue
21841: Cursor limitations
21842: Backup log dbname with truncate_only issue
21843: Extracting item detail from an invoice table...
21844: A Complicated problem
21845: Selecting Last, First Names query
21846: thanks
21847: Pattern Matching
21848: select all values that contain something in their group
21849: SQL to update values based on a grouping
21850: Sql Performance
21851: How to Access a remote sqlserver Through a Proxy Server?
21852: SQL Help
21853: if row exist update else insert value
21854: if row exist update else insert value
21855: how to set variable using CASE?
21856: ODBC driver for QuickBooks
21857: Size of column of datatype Image
21858: Get list of connected users on database?
21859: SQLCMD vs BCP
21860: Some Question about ADSL Conection
21861: Temporary Tables
21862: T-SQL Query Help
21863: XQuery and case sensitivity
21864: datetime filtering
21865: Is it possible to join the resultsets of two stored procedures?
21866: PRINT command in trigger
21867: query ???
21868: Unknown symbol: #
21869: Update to SQL Server 2005 Books Online is available
21870: OLE Automation Failure Executing DTS via stored procedure
21871: datetime index
21872: Which Version of BOL is Installed?
21873: Data warehousing primer?
21874: Global search and replace in SQL Server with data type ntext
21875: Combining 2 select statements
21876: Usefulness of SSMS Solutions and Projects
21877: Tuning
21878: Log not shrinking
21879: how to test operators in sql 2005 database mail?!
21880: SSIS Transfer Database Task fails between 2000 and 2005
21881: SQL Server 2005 throught OLEDB : Named parameter problem ?
21882: Only text pointers are allowed in work tables. never ... image col
21883: significance of COLLATE
21884: Changing resultset to 1 row and 1 column
21885: Ingnorant about encryption with symmetric key and certificates
21886: Tuning
21887: add a count column
21888: DateTime Formatting Question
21889: sql query testing
21890: Linked server to DbaseIII security problems
21891: Slow update on SQL Virtual Server 2000 on WIN2003 cluster
21892: Need help with windows service being "database aware"
21893: Stored Procedure Lock?
21894: Help wit a complicated query
21895: SSIS Package through SQL Agent Jobs
21896: Looping through Dimension Tables and Joining To Fact Table
21897: Developer Edition / Reporting Services
21898: Interesting Fundamental Questions about Tables
21899: grouping problem
21900: Database/ Table Property
21901: Code to generate "Create Table..." scripts
21902: Question on QUOTED_IDENTIFIER
21903: Is there a function can convert a comma delimited string to int se
21904: Case statement question
21905: Any function in SQL Server similar to decode function in oracle ?
21906: MS SQL - how to change header in mail
21907: SQL Server returning hierarchical records
21908: ++ IIS + SQL (Not enough storage is available to complete this operation)
21909: vb and c# in single project?
21910: insert multiple row copies for lookup without cursor
21911: column dataType
21912: strong performance problem with a parameterized query
21913: Applying a function to a subquery
21914: Query from a dynamic table
21915: how to set null value from vb to sql server
21916: Execution plan vs real life
21917: How to change binary data in buffer to string format
21918: Migrate SQLServer 2000's replication program to SQLServer 2005
21919: Output Parameter Problem
21920: Stored Procedure can not work perfectly for Big5 characters issue
21921: help on delete statement
21922: 2005: Script Each Object To Own File
21923: Need help connecting to SQL Server using Windows account
21924: Query performance
21925: which version of SSMS is for developers?
21926: Joining 2 select statement with like fields
21927: Time And Only Time
21928: Writing SQL: query builder or through the query analyzer?
21929: pure query question
21930: set datetime month from int
21931: * Question about SQL 2000 query
21932: TSQL to view a table's DDL
21933: Is there a way to use a function like Replace on a Text data type?
21934: Views and CTEs performance problem
21935: varchar(8000) data being truncated to 4096
21936: Calculaing # of days elapsed between each visit
21937: User's default schema
21938: SQL Server Job Notification
21939: Adding a space in a field
21940: Document management is SQL Server
21941: Another Instance of SQL Server
21942: SQL DMO Lists files severs too
21943: incrementing a counter in sql
21944: UPdating a table column with substring of another column
21945: Can't use Shared Memory protocol to connect
21946: scripts fails under ADO but no error returned.
21947: Easy question about combining queries
21948: merge two date ranges with overlap from two tables
21949: Default text case
21950: Query to values from two different tables with outer join
21951: Complex Query in SQL Server 2000
21952: Inner join of one table with two aliases
21953: Searching for Close Variations
21954: Sql Server 2005 Database mail error message.
21955: how to kick all users out of a database
21956: Dynamic SQL - Execute (@var1+@var2)
21957: Run Application Whit Parameter from Sp
21958: Run Application Whit Parameter From Sp
21959: SQLCMD / OSQL / ISQL - Having to hit enter and then type go again.
21960: FOR UPDATE
21961: SQL Parser
21962: how to: INSERT IGNORE INTO?
21963: show dependencies of a fact table
21964: URGENT !!! SELECT * returning different set of records
21965: SQL Server 2000 conversion of varchar to smallint
21966: TSQL bit manipulation up to 128 bits???
21967: dynamic sql in UDF
21968: Timeout sql+asp
21969: Installing a database
21970: Dictionary Sorting Weirdness
21971: Another Rounding question
21972: Returning only rows with highest version
21973: Displaying fixed value in columns in select query
21974: sql job @command param
21975: more complex many to many table query
21976: Backup of the database
21977: Arrays in stored procedures
21978: sp_detach_db Changes Security ERROR
21979: Date Query Problem
21980: access the active directory
21981: Restore database to default location on anohter server?
21982: sort a table with duplicate values
21983: SSMS05 : where are SS2K jobs ?
21984: Problem with xp_smtp_sendmail
21985: many to many table query
21986: How to design grouping of codes
21987: SP Metadata Help
21988: Display rowset
21989: Generate Script for TSQL Job Doesnt work
21990: File Import in SQL 2005
21991: Solution and question about indexes in SQL 7 vs. SQL 2000
21992: Question about Nested Sets
21993: Update linked server from local server
21994: self join problem
21995: Using carriage return with multiple tables
21996: HELP!!! - Problem with hints...
21997: Identity column based on other value
21998: Casing a name like McKinley
21999: ObjectSpaces?
22000: Importing Data from a File
22001: [BULK-OP-LOG]
22002: Joining the results of a select with a new select statement
22003: Table from varchar(max) field
22004: Date calculation and segmenting data by date interval
22005: Need help with intersection table query
22006: Problem with componentone component
22007: Best practice - parsing a comma-separated string
22008: Client-Side Database Mirroring Details
22009: selecting Max Date from 1 table
22010: Determine working days within a date range
22011: uploading file into SQL 2005 using .asp
22012: Problem with Stored procedure and execute_sql
22013: "0x80004005 Microsoft OLE DB Provider for ODBC Drivers" help!
22014: Questions Exam 70-431
22015: calculating a row's length
22016: Connection Pooling and Sql 2005
22017: Need help for transaction
22018: SQL Query Problem (Join)
22019: need good wayt to estimate a row size
22020: Cache
22021: Shot cut keys and free online tutorials in visualbasic6 and ms-sql server 2000
22022: Custered Index on Materialized View
22023: exclude row starting with int
22024: Last insert ID
22025: HELP! Why is SqlException being caught in this code if it can't connect to SQL Server?
22026: Design Difficulties
22027: Help with upating a column with joined tables that use aggragate functions.
22028: Updating With Aggregation?
22029: returning random/distinct rows?
22030: looping comma seperated in a SP
22031: String concatenation
22032: Add this instance of SQL to Active Directory.
22033: How to list table names and field values
22034: Pros/cons going from SQL 2000 to 2005?
22035: Fixing code that returns Error 306
22036: Query for filtering by a field
22037: Need help with Query for Report
22038: Nested cursor using different server?
22039: Distributed transaction
22040: Nested CASE WHEN?
22041: SQL query problem, help needed please
22042: Search Question
22043: Getting Count of a Certain Field null versus not null
22044: Enforcing data integrity
22045: GOTO and Variable [SQL2K]
22046: SELECT INTO Fails
22047: Concatenate with a twist
22048: COALESCE with LIKE '%'
22049: How to get rid of 1> 2> 3> in the log file?
22050: which type of replication is the best to use in SQL server