TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
31501: Generating update statements
31502: User Privilege problem to Execute SQL Job from query
31503: How can I make SQL Server automatic generate scheme script for backup everyday?
31504: Function to return substring letters only
31505: osgl syntax problem
31506: import data properly from csv file.
31507: Table normalization to remove redundant data - Performance problem
31508: Error creating object SQL 7.0 using sp_oaCreate
31509: Force a round() when it's below a 5?
31510: Syntax to Restore a database renaming the original files
31511: index question
31512: Access - SQL 2005
31513: sql server alerts and sql server jobs
31514: SQL Search Query needed
31515: Assigning query output to a variable
31516: Sql 2005 maintaining Hierarchy problem
31517: Database locking issue
31518: help on select query
31519: Year comparison
31520: How do I handle time-zones?
31521: Formatting number in sql
31522: CLR Integration with Complex Types
31523: SQL Server command simular to Oracle's 'DESC'
31524: client deduping
31525: Join based on MIN DATEDIFF?
31526: Read data Page without using DBCC Page
31527: returning counts of all values in joined tables
31528: Getting the value of xp_cmdshell
31529: service manager equivalent in YUkon
31530: Force a round() when it's below a 5?
31531: ForignKeys and index
31532: Simple Erntr - Invalid Object
31533: code information for unused indexes in sql server
31534: which is most efficient? variables vs. nested select
31535: SQL Server Agent JOB failed while Query anlayzer success
31536: Problem With Case Function
31537: deploying CLR objects best practice
31538: Auto Commit
31539: Create Duplicate of table ?
31540: distinct query
31541: Number of lines of code in a SP
31542: How to pull query data from two databases?
31543: Query Result in Cache?
31544: Advice on Simple Structured Sql Query (Search)
31545: help Simple question
31546: [OT] User-Defined string Functions Transact-SQL
31547: Transactional Modification
31548: Transactional Modification
31549: @@ERROR per connection?
31550: Understand N'___'
31551: sp_send_cdosysmail with priority
31552: case statement TSQL
31553: joining 2 tables onto one
31554: Restore - Change Logical Name
31555: what is the best way to update data
31556: dumb sql mistake or SQL Server error?
31557: SSIS Packages
31558: How to refer to calculated field ?
31559: duplicate column data
31560: returning counts of different fields when only one has criteria
31561: Configuring SQL Mail
31562: question about dealing with deadlocks
31563: Multiple Step Stored Procedure
31564: size of the resultset
31565: from clause
31566: Relationship map using CTEs
31567: BCP copies only Integer data
31568: SQL Query help.
31569: Accessing Second Record Within Query
31570: maximum column_name length
31571: Loading 150k AD user objects into SQL2005
31572: CC and SSN encryption
31573: Getting the physical directory that the log file is located
31574: selecting from DBCC SHOWCONTIG
31575: Variable not passing parameters
31576: Need replacement for sybase list aggregate
31577: Is this an efficient way to return a comma string
31578: Filling in date records
31579: error processing
31580: Excel file import problem
31581: xp_smtp_sendmail weird behavior
31582: Passing Cursor as SP output parameter
31583: SQL Monitoring Tool
31584: multilingual asp.net calendar control
31585: Help on the last updated date
31586: FOR XML return as a Scalar
31587: BCP
31588: Debugging CLR Objects
31589: Are these two statements equivalent?
31590: Querying information_schema for check constraints
31591: Insert maximum integer value if it is exceeded
31592: Order By ignored in query participating in Union All
31593: Restore Database
31594: Call Stored Procedure within a SELECT statement
31595: SQL 2K, logging procedures execution
31596: How do you force the server to store only the text entered
31597: Determine Table's PK Columns
31598: SP to write to a Formatted Flat File
31599: Function to seperate comma delimited db field into new table
31600: suser_name()
31601: xp_cmdshell
31602: searching large fields
31603: speed Up
31604: Speed Up
31605: On delete cascade
31606: Query behaviour - (subquery results)
31607: I bet this is simple, -But see if you can help. Hard to come up with Title -Have a look
31608: Enable/Disable Triggers?
31609: adding column vlaues with one another
31610: Insert into (leaving certain) fields out
31611: Joining multiple tables in a view.
31612: INSERT - dynamically specifying DEFAULT for a column
31613: Problem with order by clause
31614: Visual Basic + SQLServer + CommandTimeout
31615: Update null records
31616: Use of AVG function to update records
31617: Newbie sqlserver question...
31618: how to save a rtf file into a field
31619: Run Dll In Stored Procedure
31620: dynamic sql string too long
31621: Trigger needs to join multiple tables to validate entry in table.
31622: Table Owners
31623: views based on parameter view
31624: How to protect data in table?
31625: Query Analyzer..
31626: Select a specific range of results
31627: Can truncate but not delete
31628: convert a datetime
31629: SP and Triggers: object permissions
31630: Help with SQL Function
31631: Any performance issues if we use BigInt
31632: queries filling up logfile
31633: Administrative Tasks
31634: Help..........
31635: unaccountable result for select
31636: SP clause - where (field = @Param or @param is null) is this fast?
31637: order of columns in composite index
31638: Delete invalid Details
31639: Delete Duplicate Record
31640: Recover the data
31641: SQL Server and Time Zome
31642: Free MCAD/MCSD ebooks online
31643: Find SQL solutions with free eBooks. Search the ebooks NOW.
31644: how to store a record before deleting it using triggers
31645: explanation needed - DECLARE CURSOR
31646: Hello, is there any intelligent life at M$?
31647: Excel file import to Sql Server problem
31648: Formatting numbers
31649: weekday or Weekend
31650: SQL Server index low cardinality columns
31651: Differences between DISTINCT and GROUP BY?
31652: running stored procedures from SQL Agent
31653: The weirdest SQL problem you'll ever see.
31654: Ole object to illustrate the Enterprise manager VIEW designer in a WORD document
31655: need output where same column has more than one pirce of data
31656: Transfer Table Relationships
31657: CopyFile in DTS ActiveX Script Task
31658: query help - "Most Helpful Review" idea
31659: SQL Agent Mess
31660: Endian problems with converting to varbinary
31661: IDENTITY and Backup/Restore
31662: Help developing this project.
31663: Finding the 2005 migration quite challenging
31664: Merging tables
31665: CLR Question (BASIC)
31666: Connection Problem with Remote Server
31667: Inserting dummy lines and padding
31668: Newbie: Timeout On IN statement
31669: How to get rowid of uncommitted record
31670: Size of a row
31671: DEADLOCKS
31672: global temporary tables
31673: ReCompileReferences using System SP?
31674: Determining Roles from Windows Authenticated Login
31675: Help with value
31676: Connection string for 1 server and 2 databases
31677: compatible ntwdblib.lib FOR ntwlib.dll in SQL Server 2000 SP4
31678: WHERE clause 'SET'
31679: Design: bit on or off?
31680: SQL Query Help
31681: I was wondering if....
31682: attach db with a deleted log
31683: Database files (VS 2005) - usage?
31684: Getting an unused number from a set of numbers?
31685: Design: multiple columns for primary key
31686: EXISTS with EXEC
31687: one column causing duplicate rows - wrong join used?
31688: SQL Execution Error: Cannot call methods on int
31689: Looping Query
31690: Date from datetime ...
31691: Status control of SQL Server Agent jobs
31692: CREATE VIEW w/ UNION
31693: Login Failure with Linked Server
31694: Syntax error converting datetime from character string.
31695: char vs. varchar
31696: Same process ID, multiple times
31697: Whats Wrong with the Query?
31698: CHARINDEX is not working
31699: Automated Table Updates - Strategy Assistance Requested
31700: multiple databases for multiple days
31701: TSQL Debugger Oddity
31702: Combining archive tables into a single table
31703: random numbers of param
31704: DTS Connection Properties
31705: still problem with image
31706: Subscription error: The report is using user defined parameter va
31707: Sql Query
31708: SELECT question - need help
31709: MS SQL 2000 Query Help
31710: sysdtssteplog not updated
31711: Newbie:UNION with SELECT TOP
31712: SQL query help
31713: Scripting foreign key relationship on a table
31714: historical lookup query
31715: Calculation in sql
31716: Help With Stored Procedure!
31717: Setting the database to"'use" dynamically...
31718: Simple select
31719: Preparing db for update of 200K records...
31720: Date Logic for a DTS package
31721: return a Scalar value...
31722: Append / Insert Into Question
31723: Update query
31724: Update questions
31725: Update a SQL table from an Access table?
31726: truncate table thru a link server
31727: Merge Replication
31728: Script to delete all objects
31729: Is it not possible to use UPDATE within a function?
31730: Criteria = Most Recent Date?
31731: store image
31732: SQL Server 2005 Standard Edition question
31733: Small Storage Solution For SQL Server
31734: sqldmo and SQLExpress ??
31735: DB design question.
31736: DTS to Access mdb - updates only
31737: SQL Server 7 and SQL Server 2000 SQL QUERY
31738: How to detect sql servers on the net
31739: SQL Server 2005 & Sharepoint Poral Server 2003.
31740: Dynamic SQL - Temp Tables
31741: How to delete Duplicate records from table
31742: Problems with a SP with a Temporary Table in .NET
31743: Building View Dynamically .. Need Help!
31744: Update Query Returns -1 Represents ?
31745: Updating a view ... (SQL Sever 2000)
31746: Using Replication
31747: XP_CMDSHELL
31748: Configuring SQL Server Express 2005 for Remote Access
31749: Help with strings
31750: Stored Proc
31751: SELECT statement question (LEFT JOIN)
31752: Query on SQL Server 2005
31753: how to update identity values
31754: help needed in writing a recursive function
31755: Multi Record Insert
31756: normalizing data warehouse
31757: Script for inserting incremental unique values ?
31758: Accessing output parameter in Stored Proc. using OBDC API...
31759: Sub Query faster than inner Join?
31760: server side cursor created by jdbc
31761: Can not update remote table???
31762: cancel update if no column has changed
31763: Scheduling A Stored Procedure?
31764: Trap error on Full text catalog search
31765: Creating a User Defined Aggregate Function
31766: Using SQL Server 2005 - SQL Native Client as DSN throws up error while inserting values into temporary tables in the application
31767: SQL Native Client as DSN not able to access temporary tables...
31768: Whats the wrong with this Query?
31769: Fast insert
31770: Combining Columns of Same Name
31771: temp table cannot be found
31772: Remove Duplication
31773: Script that Return the number of Rows for each Table on a DB
31774: Programatically running the SQL Server Agent
31775: RDA push method and triggers
31776: RDA push method and triggers
31777: xml update syntax
31778: subquery returning more than 1 value
31779: Replacing Nulls
31780: Finding Consecutive Values
31781: Privilege issue on SQL Server 2005 Temporary Tables
31782: Types of parameters
31783: Adding a DTS package
31784: Sql server 2000 - copying a diagram - How
31785: CHAOS
31786: Datediff
31787: SQL 2005 + Row_Number() question
31788: BCP import - remove quotes from CSV File
31789: Stored procedure and UDF
31790: custom functions and query optimization
31791: Soundex of each element of a string - plase help!
31792: Whats the wrong in this SQL?
31793: Pivot Query Example - does one exist with Datasource available?
31794: Display records in a particular order
31795: Problem connecting to SQL Server 2000
31796: By the Programmers - For the Programmers - Of the Programmers
31797: Like operator on subquery
31798: Select Distinct - URGENT
31799: How to speed up a trigger
31800: running scripts
31801: Soundex of column fields - please help!
31802: ORDER BY in views - difference in 2005 vs 2000?
31803: Joining tables
31804: BCP Import file - how to ignore top line
31805: Getting DISTINCT values
31806: Update Query for Updating Salaries
31807: CREATE script that filters out empty columns
31808: Running 2 queries inside third query
31809: debug a stored procedure in SQL Server 2005
31810: xp_deletemail errors out, can't delete SQL Mail
31811: Return value from SP without declaring a variable
31812: Pulling out table and column descriptions
31813: BCP Help - Going Crazy!!!!
31814: replication problems
31815: How could do I such thing?
31816: Problems In Connecting Using New Driver
31817: XMLHttp to Excel ...
31818: Design question (CELKO?)
31819: SELECT INTO
31820: I was asked for this in interview...??? how to solve this..
31821: GROUP BY alias...possible?
31822: SIMPLE but HOW? - Stored Procedure within Query
31823: Linked Server performance varies depending on user
31824: getting exclamation sign in message when sent using sql email
31825: GROUP BY and ORDER BY
31826: Stored Procedure will only update one row
31827: mapping two references from one table ??
31828: SQL....two phase commit protocol
31829: SQL...checkpoint frequency
31830: SQL...backward error recovery technique
31831: SQL...forward error recovery
31832: SQL...nested transactions
31833: SQL...update-in-place scheme
31834: SQL....backup recovery
31835: TARFU: Data Controls
31836: Where Claause for Unique Constraint?
31837: output param in stored proc is NULL
31838: SQL Agent Jobs
31839: Rows not being excluded by join
31840: Bizarre SQL statement
31841: Changing ownership on all objects in a DB
31842: SQL Server Developer Position
31843: Conversion from Access to SQL Server
31844: Referencing a composite foreign key
31845: question about system tables
31846: Query Notification question
31847: T-SQL to denormalize data
31848: Merge Replication SQL2005
31849: Shared procedure with variable field name + data pairs
31850: Blocking Threshold Exceeded