TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
12951: WHERE IN @Variable?
12952: Horizontal, but only distinct columns?
12953: some kind of unique identifier for a transaction?
12954: Relationship
12955: SQL Connection Slow in DMZ
12956: Total Row Length
12957: where are other dates?
12958: Help! Size 315.91 MB Space Avail 8.89MB
12959: SELECT with or without parameter
12960: SELECT
12961: query with udf slow performance
12962: Referential Integrity
12963: SQL schema change scripting tool
12964: how to move tempDB - detach is grayed out in EM ?
12965: UDF in Trigger not working properly
12966: DateTime over 2 hours ago or NULL between 6am and 7pm?
12967: Output Parameter
12968: load random number
12969: How to ensure that ActiveX Script Task runs before Transform Data Task.
12970: SqlDependency and only one event raised
12971: ORDER BY CASE problem
12972: Strange query behavior
12973: Recommendations for a decent/user friendly reporting package please
12974: database design question
12975: database design question
12976: how to call a function in stored procedure
12977: create table primary key clustered Asc
12978: create table primary key clustered asc
12979: User vs Role Permissions
12980: Strange NULL value behaviour / RequiredFieldValidator
12981: Retrieving top row of multiple values
12982: Capture NT User ID
12983: Help for an SQL Server 2000 Beginner - DTS Question
12984: SQL 2005 vs. Express
12985: SQL Insert Into Statement
12986: Feedback request for new BOL search functionality on MSDN
12987: RESTORE Help
12988: Change to [JOBID] from 2000 to 2005
12989: How to find out what job is running...
12990: debugger
12991: Combining a multi-to-one in one table
12992: Create table from file
12993: Same Query - Different query plans
12994: Large number of exec sp_reset_connection calls to SQL Server 2005
12995: xp_cmdshell
12996: static fields in safe assemblies - help!
12997: trigger question
12998: error code -0911
12999: HELP!!! ANYONE!!!
13000: Processing Logic / Query Help
13001: Replacing Carriage Return With Space
13002: 2005 Developers Edition
13003: Problema con encoding en script de SqlServer
13004: Possible SourceSafe-SSIS integration bug
13005: SQL: how to convert time from GMT to EST
13006: stored procedure in sql 2000
13007: ODBC connections to a mainframe
13008: job history shows a failure even though the job succeeds
13009: Query takes too long to run
13010: Req: Update Trigger to cascade values from one table to another.
13011: Don't see the View alias
13012: Which are my risks if I use NOLOCK hint inside a transaction?
13013: Download Merlin Data Compass 2
13014: need help switching a boolean value
13015: CLR UDA median ?
13016: How to prevent accidently deleting or updating whole table
13017: use index in sql server 2005 with Oledb
13018: Is there any posibility to get the xml file's datas to insert into a table
13019: Login failed for user
13020: How do I insert rows to a table of Database from a XML file stored in somewhere in hard disk
13021: Partition View being used effectively?
13022: How to DENY DELETE PERMISSIONS FOR ALL OBJECTS ALL AT ONCE
13023: Load the Data in to flat file from SQL Server Table.
13024: Anyway to only count business days (mon-fri) between two dates?
13025: Cascading INSERT???
13026: Create Database at a User Level
13027: Setting Primary Key on Temp Tables
13028: 64 bit and AMD
13029: Unique login failure
13030: COUNT
13031: SQL GENERATION
13032: Memory Issue Caused by Program
13033: How to make sure mirroring is working without failover
13034: Tripwire
13035: getting network login ID from sql server trigger
13036: Parameters won't work
13037: (Sql Server 2000) Get new @@identity values after multiple row insert
13038: convert datatype
13039: Explicitly detecting if a parameter was passed to a stored procedure?
13040: Learn Stored Procedures
13041: SELECT
13042: Bulk Insert Failure on DTS 2005
13043: Need calculation to be column name...
13044: Error
13045: best way to get a GUID from a table on row insert
13046: Syntax question SQL server 2K-- SELECT ABS(diff) FROM (SELECT CAST( '-123' as decimal(28,2)) as diff)
13047: Alter column, set default - what's wrong?
13048: Need help on CONVERT function in SQL.
13049: Rows as columns (pivot?)
13050: Getting Old Value for Columns
13051: Pivot Comma List
13052: Grouping two UNIONed tables
13053: Query to select entries which contain all elements of a subset
13054: Exporting SQL Server Objects (not just tables) in SQL Server 2005
13055: Login failure issue
13056: loop / top record based on order
13057: How to exclude quickly?
13058: error message
13059: SQL2005Express
13060: XML data type and VS6 C++ OleDB Accessors
13061: query question
13062: Query question
13063: sql server 2005
13064: Query question
13065: Articles on Natural vs Artificial Primary Keys
13066: .ldf file is out of control.
13067: Drop table on another server
13068: searching for a range a values
13069: Drop records from a table without log entry
13070: create a sp from query output
13071: Combining tables in a view?
13072: Column alias based on a field
13073: How can I determine what function(s) are using tempdb?
13074: Alter Statement cant complete
13075: a newbie T-SQL question
13076: Table Intersection Using One Column
13077: populate second combobox based on the first combobox choice
13078: Trouble restoring Database over another DB
13079: string delimiters
13080: SQL question
13081: t-sql novice question
13082: Read Write Access to MS SQL 2005 DB
13083: Converting DBP project to ssmssqlproj project
13084: How Managed Aggregate function works in SQL 2005
13085: "row guid column"
13086: stored procedure validation -
13087: DROP TABLE failed
13088: SQL Server 2005: Errors in Stored Procedures
13089: How to use PIVOT for dynamic transform rows to columns
13090: Drop Table Dynamically
13091: Accessing data from a Select Openquery statement
13092: EXISTS queries in OSQL
13093: SQL2005 Express - Vista - Invalid object name '#spdbdesc'
13094: perform database operations directly or not?
13095: Help with t-sql statement
13096: UPDATE locks
13097: Create Trigger
13098: Job and mail notification
13099: detecting update from on sql server
13100: User defined regex function coded in C#
13101: Service Broker Question
13102: SQL 2005 Query Question
13103: Intelligent Product Search Query
13104: How group a column to show side-by-side?
13105: Separating words from non-space string
13106: Why this CTE error? What am I doing wrong?
13107: SQL Server and XML
13108: How have strings within a string variable?
13109: Query help
13110: How to retrieve column value into a variable?
13111: SQL 2005 Event Notification
13112: dataadapter and dataset
13113: How to avoid Redundant use of Costly View in Derived Tables
13114: BCPing Data into a table with more columns than are in the source data file
13115: Best way to search one table based on another table's data?
13116: Two single-quotes and null - aren't they the same?
13117: Update with Sub-Select
13118: Help on Nested views
13119: Need help finding most curr. yr. of acct. with most $
13120: Keep FoxPro Alive!
13121: Need help with SELECT
13122: Data Type conversion from MS Access to SQL Server, problems with significant figures
13123: Job Schedule Help with UPDATE
13124: Query run through SSMS vs. ADO.net
13125: DTS SQL JOB hangs even after the successful completion of the DTS
13126: Valid Social Security Number in T-SQL
13127: Question RE: Triggers & non-auto incrementing keys
13128: Finding Valid Social Security Numbers in T-SQL
13129: How to detect whether SMO is installed?
13130: a query question
13131: Replacing Coma during concatenation
13132: Creating a Manual Crosstab
13133: SQL query - table joined to itself
13134: Accessing database function within DTS
13135: Complex Query Help!
13136: Rounding: round(x,2) gives 25011.790000000001 for 25011.799999999999
13137: Cursor endless loop
13138: SQL server 2005 - Vista - invalid object name '#spdbdesc'
13139: How to convert emails into data
13140: Variables & Results: Where vs. Join
13141: Returning Data From One SP to another SP
13142: Export sql-server2k database to ms-acess using sql-dmo
13143: e_book
13144: Using arithmetic operators for conditions in queries
13145: split address field
13146: SELECT and UPDATE
13147: Dynamically create table name in TSQL
13148: Four table insert stored procedure SCOPE_IDENTITY
13149: Referring to comma separated values within a field
13150: Performance Difference using tinyint instead of bit
13151: Transaction issues
13152: get DB access for an account?
13153: Inner Join ... maybe?
13154: Trigger syntax question
13155: CLR Stored proc is timing out
13156: Primary key
13157: Import of .csv not working
13158: fill <null> in outer join?
13159: Basic DB Design Question
13160: temp role assign
13161: Delete row triggers drop table
13162: Trigger Question
13163: decrypt field
13164: Cannot start more transactions on this session
13165: Sql Encryption -- entire db?
13166: in cursor how to concatenate the result
13167: Insert Performance with CLR Table-Valued Function
13168: Sincronize values. Confusing
13169: DateTime Problem
13170: Count Column in View
13171: SQL Memory Usage
13172: Failover steps for Log shipping
13173: Find previous month's data
13174: COALESCEand Non Null Values
13175: Combine records to calculate
13176: stored procedure question
13177: How to get 4 max dates?
13178: Setting a field default questions
13179: Error - Could not locate entry in sysdatabases for database ...
13180: locking question
13181: Question about temp tables
13182: Is there an add-on for SSIS solution management?
13183: Characterset, accentuated characters and CSV file
13184: locking at the server
13185: Difference between the two forms of query
13186: "If" Condition
13187: How to use BCP utility with Functions having UNIQUEIDENTIFIER as input parameter
13188: Attach DB to remote server using SQL-DMO
13189: Configuring MSTSC
13190: SQL script to show dynamic header
13191: How to handle TimeOut Expired Error Message
13192: tables alias name
13193: Stored Procedures NOT appearing in SQL Server Management Studio
13194: Msg 7391 Unable to begin a distributed transaction
13195: How to return most recent row?
13196: Export to Excel
13197: Declaring size when concatenating fields in a view
13198: using template directory switch when calling ISQLW from cmd line
13199: Optimize an SP running against a table with 290 million rows.
13200: schema permission
13201: incrementing the record number
13202: Cleaning out non numbers from a field
13203: Insert Into..Select * from --- minus the Identity column -?
13204: InStr - Similar Syntax in Stored Procedure
13205: Stored Procedure
13206: validate username and password
13207: Query help
13208: Loop
13209: UNION and ORDER BY
13210: Multiple tables - Multiple Rows Maths Functions
13211: query help
13212: replace data in column from another column
13213: Creating a Table that can generate dynamic Variable Counters
13214: Replace question
13215: Delete with cursor not working
13216: Table Name Inside Trigger
13217: Import Data from a Custom ODBC Data Source.
13218: SQL Server 2005 Agent
13219: transfer data from sql mobile to sql server
13220: sample std dev versus actual std dev
13221: How to update varbinary field
13222: Poor Linked Server performance when running a query with a variable
13223: sql commands don't update tables
13224: compare features between SQL Server 2005 Vs SQL Server 2000
13225: SQL Server Express 2005 does not sort
13226: Crosstab Query
13227: Urgent:GROUPING Problem
13228: log shipping
13229: Collation Vs Unicode
13230: SQL Server 2000 VDI Backup fails in 64 Bit architecture
13231: WindowsAuthentication issues
13232: WindowsAuthentication issues
13233: How do I use a parameter to create a query heading in a stored pro
13234: SQL syntax for LEFT/SEARCH scenario
13235: Need Advice. Blog
13236: Calling SQL 2005 Soap Endpoint from PHP
13237: Unable to execute xp_sendmail
13238: MSSQL2k length more than ...
13239: log files merge
13240: connecting to analysis server
13241: loading data into a BIT column using bcp api
13242: Creative solution to relatively simply requirement
13243: PROBLEM IN A QUERY
13244: SQL Server 2005 Analysis Services Charts
13245: Thank you
13246: Dynamic SQL and sp_executesql
13247: More trusted jobs here
13248: Full DB backup
13249: Rounding Up
13250: Commit & Rollback Question
13251: Extendend procedure "srv_sendrow" very slow performance in SQL 2000
13252: Database Error 22285
13253: what's wrong with this too
13254: Prevent row change on system table
13255: Delete really slow
13256: Createb table from a query
13257: table related query
13258: get the first of the month
13259: status and indid from sysindexes table
13260: Select query in sql 2000
13261: 2 table update
13262: I can't Copy a database from Sql Server 2000 to 2005
13263: Difference in UPDATE between 2000 and 2005
13264: Nested Stored procedure issue
13265: JOIN Question...
13266: Setting up SQL Server Agent Mail
13267: Satellite assemblies - anyone got this working?
13268: maximum fragmentation to allow for table
13269: Update trigger
13270: Linked AD Server: Grab User Group(s)
13271: Not Exists Date
13272: Need a query...
13273: how do i meaure time
13274: calc start-of-week and end-of-week
13275: Display rows even when sum is 0.
13276: Internal Serer Error
13277: Referencing Multiple Tables MSSQL 2000
13278: User query hanging a critical application
13279: exporting mssql BD
13280: howto: I need trigger with parameter
13281: opendatasource excel
13282: String parsing
13283: String parsing
13284: Indexing strategy for a very large table?
13285: Finding values that don't exist in another table
13286: Service Broker connection
13287: Help optimizing a query-- its not using the indexes
13288: Output of sp_helprotect
13289: using table variable
13290: SQL help with Subtraction
13291: Multiple Return Parameters
13292: Removing unwanted characters in a field
13293: Oracle Linked Server problems, OpenQuery accepts no variables and fully qualified Linked Server syntax has datatype discrepencies
13294: Scope_identity()
13295: number function
13296: generate a unique ID
13297: Query Help!
13298: Find an ID and select it in another table
13299: formating data for excel
13300: Boolean field