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

view full version: back to formated view

19601: Union All Sort Problems
19602: Loging stored procedure calls
19603: Logs
19604: query performance question
19605: Does cast to float no longer work in SQLServer 2005?
19606: modify database Error
19607: MSDTC...is unavailable.
19608: SQL query resultset taking too long to execute.
19609: Stored Procedure and Transaction question
19610: Modify Procedure to accept two fields
19611: How to read values in datagrid via a panel
19612: Query syntax problem
19613: Help with Calculating percentage column in SQL
19614: Please help me to design supertype-subtype ..
19615: Problem with a trigger
19616: Query Question
19617: [OT] Free 512MB USB Key
19618: Help with DATEDIFF.
19619: exporting data
19620: Access Error
19621: SQL Server 2005 T-SQL sp_addlinkedserver
19622: Date Set question Follow Up Performance problem
19623: www.Benchfolks.com----A friendly Job site for US IT professionals
19624: Help with stored procedure concurrency and performance
19625: Help with DATEPART.
19626: SQL Serevr Bit Field Change
19627: Optional parameters?
19628: Hosting - Today's best sellers with discounts
19629: Could not continue scan with NOLOCK due to data movement.
19630: "blinked" complex id - is that the problem?
19631: find strings
19632: How to find a field
19633: SQL Server 2005 Vs SQL Server 2000 Performance Comparison
19634: Simple SQL transaction using ASP
19635: backup of mssql server databases using snapshot technique
19636: install sp via tds / odbc
19637: Select all items that don't have hours assigned
19638: Copy Stored Procedures from one server to another
19639: Select Into Text File???
19640: Log Size
19641: Windows 2003 IIS6 Connection Issues
19642: FN_GET_TABLE.OBJECTTYPE SQL 2000 AND 2005 Corresponding values
19643: tempdb tuning
19644: Master Detail: Transactions & Stored Procedures : Can you Help?
19645: Running multiple sql files at once
19646: Help with Subquery and "Group By"
19647: Rounding off
19648: Parameterized Insert Statement Question
19649: trying to run an update over 2 different tables
19650: SQL 2000 SP4
19651: Error restoring from backup file
19652: sending sms text message using SQL procedure
19653: What lock or isolation level should I use in multi-user environment?
19654: Query help
19655: Query performance issue tracing
19656: A little TSQL help with dates
19657: Managing status via procs
19658: IF ELSE help!
19659: Change Object Owner
19660: ALTER TABLE error message 4929...
19661: 'For Each' equivilent in SQL stored procedure?
19662: Concatenating column values
19663: ODBC API Question
19664: Trigger to MSMQ or an external program
19665: Stored Proc exiting
19666: Warning: The join order has been enforced because a local join hint is used
19667: Getting all login/users including sa/dbo (type 'U' 'WINDOWS_USER)
19668: get max items in list
19669: Copy Database Wizard question
19670: SSIS - converting to smalldatetime
19671: turning caps lock off in VB.NET
19672: ADO.Net thread safety question
19673: Cannot Update Identity Column while doing Select statement
19674: Urgent:SQL Server locking
19675: snapshot isolation - sql2k5
19676: Select Query Right/But wrong.
19677: Calculation question
19678: CAST or CONVERT during UPDATE
19679: Suitable Hardware
19680: Setting DTS 2000 global variables with a SSIS expression
19681: DateTime BETWEEN two dates
19682: book recommendation - sql 2005
19683: Replicate rows.
19684: How to create a table in a schema other than [dbo]? (SQL Server 2000)
19685: SQL instance
19686: getting strange error
19687: SSMS
19688: Question about adding extended database file and transaction file
19689: sharing a databse
19690: From 2000 to 2005
19691: Need help getting this .sql file into my SQL Server
19692: Code Clean-up / Formatting
19693: SQL search returning duplicate values
19694: Saving RSS to SQL Server 2005
19695: limit recurring values in rows to max of x times?
19696: Sum Columns on the Fly
19697: Suppress Column Headers
19698: Execute sp_addlinkedserver to add the server to sysservers
19699: Caveats of Linking SQL 2000 to Exchange 2003
19700: How to find a table's database
19701: Stored Procedure with IN Clause
19702: sqlcmd -v
19703: QUERY TO FIND ORDERS SHIPPED, NOT SHIPPED, AMOUNT OF ORDERS BY SUPPLIER
19704: stored procedures running slow
19705: null to blank for a datetime column
19706: Insert in another table
19707: VS2005 and Reports for SQL2000
19708: Get SQL 2005 Server Licence Info
19709: Date Set question
19710: The use of Indexes
19711: can I convert an access db to sql server express?
19712: Line 25: Incorrect syntax near '27'. [SQLSTATE 42000] (Error 170).
19713: Odd Performance in Query
19714: Help with cursor
19715: Listing User Rights to Objects
19716: Performance question
19717: ALgorithm Question
19718: PRINT statement producing output immediately
19719: (SELECT *) in view
19720: SELECT * in view
19721: declare inside case
19722: Help with FORMAT_STRING
19723: 2005 CLR types - default values and nulls
19724: Why system stored procedures do not have Set Nocount Off
19725: SQL 2005: How to remove an identity(1,1) from a table with a select?
19726: User-defined function that operates on all columns
19727: Bulk Load - Transaction Log Fillup
19728: Looking for C++ example to detect deadlock with OLE DB
19729: Using index for bitwise operations
19730: Can you edit the result set from Studio Manager Sql Server 2005 like you could in EnterpriseManager sql server 2000?
19731: a group by query to find percents
19732: 2005 grows
19733: Warning: Null value is eliminated by an aggregate or other SET operation.
19734: Looking for software to read in old SQL reformat it and make improvements to generated SQL output
19735: Count number of record in two columns
19736: ArrayList.Contains with User Defined Type (UDT)
19737: Automate backup and restore from Live to Test environment
19738: Executing an sql script on a remote database from Visual Studio .NET 2005
19739: Query help to view line returns, etc.
19740: Oracle DECODE to T-SQL (used within GROUP BY clause)
19741: SQL advice
19742: Combining select result sets
19743: Column default values
19744: Updating tables
19745: Cluster
19746: Full self join problem
19747: callign web service from sql 2000 through extended stored proc
19748: SQL Query assistance
19749: Format date as single digit month
19750: Re: Formatting as Money with comma - NEVER MIND
19751: Formatting as Money with comma
19752: SQL 2000 Database Performance
19753: Correlated subquery with group by restriction?
19754: Full table join problem
19755: How to "UNION" horizontally?
19756: XP_INSTANCE_REGWRITE: Undocumented XP generated by Management Studio script utility
19757: SQL Query Question
19758: Unable to sum correctly in SQL function
19759: Full table join problem
19760: sp_fkeys in reverse?
19761: System stored proc - foreign keys
19762: Remove first character in Where
19763: Creating Duplicate Records based on a Quantity
19764: System stored proc - foreign keys
19765: DTSRUN option accept UNC path?
19766: Reference .NET assemblies from SQL Server Project
19767: Lock Monitoring
19768: Index question/Optimization
19769: If @variable =''
19770: COLLATION question
19771: Import data from multiple databases
19772: Multiple select
19773: combine two columns in one new table
19774: Verifying replication
19775: How to "UNION" horizontally?
19776: inserting SP resultset in SP
19777: Replication Identity out of range
19778: How to "UNION" horizontally?
19779: How to "UNION" horizontally?
19780: Lock Monitoring
19781: sp_OACreate Failure
19782: Return single value from a group by total
19783: combine two columns in one new table
19784: help for update query
19785: problem with an update query
19786: looping recordset
19787: Query / Stored Proc Question
19788: Enumerate built-in SQL Server 2005 functions
19789: Automatic alias names for the tables in a design mode view MS SQL 2000
19790: Drop and Add Indexes
19791: Output parameter vs return value in simple integer case
19792: using HttpWebRequest for viewing Reporting Services reports
19793: automaticaly sending the results of a query to Excel
19794: Substring T-SQL
19795: Finding the next AutoID without actually inserting a new record !
19796: DB Design Question.
19797: Understanding deadlock trace -T1204
19798: Merge Replication Identity Column Constraint
19799: index and performance
19800: concatenate and format the text data in insert/update trigger
19801: How to error trap SP within trigger ?
19802: Reg DTS Package..
19803: Select rows based on occurance of other records
19804: How to make a random search in SQL 2005
19805: SqlDependency message timeouts
19806: Clustering Q's
19807: Excluding Weekends from SQL Query
19808: Excluding Weekends from SQL Query
19809: Rounding with DECIMAL data type
19810: How to select an image in 2005?
19811: problem with row(s) affected
19812: Date in stored procedure for VB 6 code
19813: confused about OUTER JOIN
19814: VBS to SQL Connection (Alternate Connection Method)
19815: Delimited Seperators
19816: Very poor query performance
19817: Create object failure
19818: error 904 Database %ld cannot be autostarted during server shutdown or startup.
19819: Question as to why dates have two quotes as ''2006-09-26 17:05:30:730'' in Profiler
19820: Looking for tutor in SQL for MS Sql Server
19821: Adding Field With Hardcoded Value In SELECT...INTO Query
19822: Need help with setting variables; DDL included
19823: How to avoid use cursor in this situation
19824: Transaction and result code
19825: select count from Except query
19826: Questions on PASS 2006 Community Summit in Seattle
19827: Service Brokers
19828: access to database using stored procedures only for security making sense?
19829: Dead Lock problem with same sequence of commands
19830: Is this a Valid Date Time
19831: Cannot perform an aggregate function on an expression containing..
19832: SS2005: database growing very quickly
19833: Is there a better way?
19834: Non English Characters
19835: Best ERD design apps ?
19836: @@Error problem, execution terminated
19837: surrogate key in master detail tables
19838: SP performance problem
19839: Group by clause on date value
19840: Simple query, same database, same plan - difference in io - 2473 t
19841: Date Problem in VB
19842: Replace
19843: Accessing parent record from child table's DELETE trigger
19844: Questions about MSDE and SQL 2005 Server Express
19845: Joining 2 tables, pulling MAX field value from second
19846: Using the SMALLMONEY datatype
19847: Advice on how to tackle this
19848: Multiple Aggregate Columns In One Query
19849: Delete Primary Key using SMO
19850: SQL 2005 - SQL Agent Job/DTS Error - Invalid class string
19851: convert statement
19852: one-to-one relationship
19853: Should I use TRAN in stored procedure?
19854: The multi-part identifier could not be bound.
19855: How to use variable in USE method?
19856: How to avoid Deadlocks
19857: Performance issues because of recursive call.
19858: SQL Query
19859: how to alias (Select * from tbl1) to represent a table in bigger
19860: sp_who
19861: Different results based on sql version
19862: odd or even number!!??
19863: Syntax error converting the varchar value
19864: breaking changes from sql2000 sp4 to sql2005 sp1
19865: Logical read confusion
19866: Determining if database is Trustworthy
19867: Query Formulation against a "Transaction" Table
19868: Performance for Views, indexes and Group By
19869: Invalid Object Name
19870: PRINT 'Stupid Programmer Error'
19871: Best method to copy database items that are recursive?
19872: SQL Query Optimized Statements?
19873: Best Practices
19874: OSQL Return value
19875: 80040E14 - Incorrect syntax near 'BATCHSIZE'
19876: Struggling with a many to many relationship
19877: Create table permissions within a SP SQL2005
19878: how to give password to database of sql server
19879: Drop unique
19880: DTS error on 'KEY' field when trying to import data from one SQL server to another?
19881: Securing Data Through Views
19882: Bit Question
19883: Instr ??
19884: Null plus string thing
19885: GROUP...BY clause
19886: Sql Server 2000 Meta Data Access
19887: Whats the right approach for getting a job
19888: need query
19889: creating triggers (when columns updated or deleting too many rows)
19890: Security - SOX Audit
19891: Shrinking Logs
19892: Most Recent Numbers
19893: Outlook Express Spell Checker
19894: SQL INSERT problem with AS returns unknown field name
19895: CASE Statement (SQL 2005)
19896: what permissions needed for managing jobs and intergration sevices packages?
19897: Edit - Validation function
19898: Returning Rows as Columns from a Query
19899: HelP: SQL-DMO and SQL Server 2005 SP1
19900: SQL Query Question
19901: SS2005: Truncating the log file
19902: how to add auto row count column to a Select statement on the fly?
19903: SELECT Triggers
19904: Convert to DateTime format
19905: Help with get record with Max date or null
19906: problem connecting to SQL Server 2000
19907: Create a temporary table within a view
19908: SQL Server 2005 bug re: Temporary tables in insert trigger?
19909: Help with a query that turns columns to rows
19910: Alter Table - Adding column to large table
19911: Create Table + OSQL Return Value
19912: SQL Server Locking in Busy Periods
19913: Custom Active X script for Transform Data Task
19914: help writing query
19915: UpdLock false Deadlock - please help
19916: End of Month function
19917: pass database name as parameter in stored procedure
19918: Turning query results into a numeric value?
19919: Generate SQL Script
19920: Transaction deadlocked
19921: Performance Tips Needed Please
19922: Question regarding sp_executeSQL.
19923: INSERT INTO from a text file
19924: Replication and IO question
19925: Create Table - return value
19926: %Rowtype in SQL server
19927: retriev employee information with the help of password encryption
19928: retrieving employee name against the encrypted password
19929: retrieving information against the encrypted password
19930: selecting and locking a record from distributed DB
19931: cumulative problem
19932: Simple syntax question
19933: SqlContext does not contain a definition for GetCommand()
19934: Calculating Percent
19935: find connection killer
19936: join order question
19937: Sql Server 2000 - ADO adLockOptimistic adLockReadOnly
19938: IF EXISTS?
19939: Sql Server Professional Magazine
19940: When to use scripting tools and when to manually code the script
19941: prevent concurrent reads of a table...
19942: how to get this resultset...
19943: sql editor for 2005
19944: Looking for an optimum way to get 2 result sets
19945: What Service account to use in this situation?
19946: Setting Windows Service "Local System Account" on Setup
19947: help me with this Stored Proc
19948: wat are temporary tables
19949: how can the output from a stored proc be used in a calling stored
19950: Can't Drop a Primary Index using SMO