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

view full version: back to formated view

27301: What version of SQL Server
27302: truncate and insert stored procedure performance vs. T-SQL
27303: Cannot sort a row of size 8095, which is greater than the allowable maximum of 8094
27304: Join columns - Key Field
27305: Outer table inside stored procedure
27306: returning a table from a function error
27307: Soundex function - please help
27308: Date formats in SQL
27309: difference
27310: How to refer from a stored procedure to a table in another databas
27311: Changing file grouth automaticly
27312: CASE WHEN PROBLEM
27313: Extracting Integer
27314: Queuing Files
27315: Question
27316: Setting file growth of file
27317: Find UNICODE Data
27318: Max Date for multiple columns
27319: Why are Parallel INSERTs slower than non-parallel when you have a
27320: How to generate procedure with all table data
27321: Does anyone have any explanation for that?
27322: jobs and @freq_subday_interval = 9
27323: Database diagram 2005
27324: Date Manipulation
27325: 2005 Database Diagram
27326: 2005 Database diagrams
27327: Updating a column with a total
27328: Controlling the cursor position
27329: Database diagram 2005
27330: Silly substring question
27331: Updating all Records in a Table
27332: Most efficient wasy to execute a Stored Procedure with one to many relationship
27333: distributed Queries .......problem on linked server
27334: Like on join
27335: TRANSACTION ISOLATION LEVEL
27336: Use Multiple Databases from Parameters.
27337: Ink
27338: recursive query help !
27339: sql 2005 - access denied all of a suden
27340: implementing notification service of SQL Server 2000
27341: Limitayion of indexes
27342: Executing Stored Procedure with result set
27343: Exporting a table to a file -reg
27344: function problem, referring to another function
27345: how to remove cursor ?`
27346: resotre the user in the database
27347: Query Analyzer
27348: Inverse -- Reverse
27349: faily to update record
27350: error with trigger
27351: Ink
27352: select from two tables
27353: Any query to return the execution time for another query?
27354: Stored Procedure to return multiple rows in one field
27355: rename file using cmdexec in SQL Server Agent job.
27356: Update rows as they are inserted.
27357: Stored procedure not executing in the order of the TSQL
27358: transactions and error handling
27359: SQL Server Stored Procedure & Nested Query Syntax
27360: Cannot delete rows that contain same data
27361: =?Utf-8?Q?It=E2=80=99s_the_little_things!?=
27362: udpate field by using matching
27363: Design problem
27364: char to integer ?
27365: Analysys Services 2005
27366: error handling
27367: Display estimated execution plan bug
27368: **changing the logical name**
27369: clustered index
27370: can this be done?
27371: conditional update within value
27372: Backup and Restore with STOPAT
27373: Log Shipping Question
27374: optimized indexing 1
27375: Re: import txt file wizard
27376: optimized indexing
27377: Hebrew Sql 2000 to 2005 Collation Problem ?
27378: UNABLE TO SEE SYSTEM TABLE IM NY ENTERPRIsE MANAGER
27379: Delete and insert data in same transaction!
27380: Change Field Name
27381: MOVING FROM ACCESS TO SQL
27382: About images and audio waves
27383: **fetch the related tables of a particular table**
27384: Query question
27385: Question AGAIN!!
27386: Multiple Joins Showing Wrong # Records
27387: Creating a view with multiple join criteria
27388: SQL Jobs Fail but give no error
27389: getdate()
27390: Please Help: SSIS Package execution issue
27391: design question
27392: import txt file wizard
27393: An Insert Trigger with CDOSYS generated email
27394: Change Column Names
27395: Vb.NET
27396: Huge amounts of unused space...why?
27397: Update Trigger Question
27398: Articles or Blogs
27399: For XML Explicit in a stored proc
27400: Solution needed Urgent...
27401: An alternative for Dynamic SQL required
27402: How to get varchar parameter in Extended stored procedure
27403: Get return value of stored procedure in Query Analyzer
27404: simulate infinite loop
27405: obtaining the names of triggers within T-SQL
27406: text to varchar conversion woes
27407: How to save an HTML doc in SQL 2005
27408: Compare subsets
27409: Search for newline chr
27410: Indexed view
27411: how to debug the stored procedure in sql server
27412: moving from Access to SQL 7.0
27413: executing a trigger
27414: transpose
27415: updateable and non updatable rows
27416: Maximum Rowsize screw up by MSSQL 2000
27417: Alternative to OpenXML
27418: Dates Help Needed
27419: Optimal storage of a lot of text records
27420: Need help with the SELECT statement please.
27421: DB Collation
27422: predicate [ ] using xml in sql server 2005
27423: Problem with Date logic
27424: PID in VHDL code
27425: T Sql Help
27426: TSQL Complicated query
27427: Solution Required Immediately
27428: Double Quotes and Print
27429: Culture in MSSQL 2005 express edition
27430: Using Temp DB vs a standard db for work area
27431: Application for "Replaying" a Table
27432: aggregate query reporting different results
27433: Return a Field from a User Function ??
27434: The best way to connect to SQL Server from C++
27435: database diagrams
27436: bcp right truncation: how to ignore
27437: Top N worst groups SQL problem
27438: How to insert resultset from SP into a table? or use Select * From
27439: table name as variable
27440: Audit Table - Design Question
27441: SQl Profiler
27442: SQL Server 2000 Automatic Setup Script.
27443: SSIS and ragged rows (variable number of columns)
27444: Replacing specific text characters in a TEXT field with CRLF characters
27445: SQql 2000 Nested Loop
27446: Which primary key
27447: list of tables and views in a database
27448: Aggregating bit data types
27449: Table variable and statitics on it
27450: Estimating time for creation of clustered index
27451: Question about LIKE and wildcard operator (%)
27452: Running the same SQL on several servers
27453: Linked Servers
27454: SSIS Package not executing as SQL Agent Job
27455: Convert date to year
27456: Primary Key fields require index?
27457: How to Copy the User
27458: Where are Default Values stored
27459: Validate the text field in the sql server
27460: NEED HELP W. QUERY USING DISTINCT AND SUM AND CASE
27461: Update trigger during large updates
27462: migrate a 600GB of DB from State to State.
27463: Best way to create next sequence number
27464: To Query or not to Query
27465: Query question: Getting the employees wich are working on the same projects...
27466: Trigger Or Constraint
27467: Update Trigger
27468: Timeout
27469: Is there any methods or tools to generate impact analysis if I will change a field type and length?
27470: Splitting field contents into several columns (newbie)
27471: SqlCacheDependency issues with the SqlCommand
27472: Create my own profiler
27473: change of value at the time of insertion
27474: Need help on aspnet_Users table in 'aspnetdb' database.
27475: How do I mimic autoNumber for non-identity columns?
27476: "query notification" problem
27477: Strange Performance Issue
27478: ORDER BY Aggregate and Grouping
27479: Not returning @@Identity
27480: Contraints
27481: Missing data from restore
27482: select and update statements in a while loop is not working proper
27483: Between date problem
27484: requesting query optimization help
27485: Types of SPROCs
27486: script error checking
27487: Is there a way to escape a single quote?
27488: Need help with a Stored Proc. - using BEGIN TRANSACTION and END
27489: Physical File Access
27490: bulk insert which check if record exists
27491: Invalid connection string to MSDE 2000 database
27492: Determining Cascading Delete
27493: About transaction involving table variable
27494: Nested Transactions
27495: Debugger question
27496: Web services question
27497: Transfering MS SQL database to MySQL
27498: Best way to generate next sequence number of a table.
27499: arithmetic operations with money and real
27500: Reverse engineering a database in visio
27501: Wisdom behind using fully qualified table name in field name
27502: Transaction model
27503: 24 Hour
27504: SQLOLEDB with Server=(local) on SQL Server 2005
27505: UPDATE not working
27506: Table information
27507: Results of stored procedure into a table variable.
27508: Very basic question
27509: Browser time out: when executing a DTS package
27510: Query with union no longer updatable in SQL 2005
27511: Do we still have SQLXML in SQL 2005?
27512: SELECT with COMPUTE?
27513: SQL Server 2000 bug ? INDEXKEY_PROPERTY
27514: c# 2005 express edition install difficulty
27515: Creating Dynamic Data Flow Task
27516: group by and sum
27517: select question
27518: SQLXMLBULKLOAD don't fire trigger
27519: Urgent - Calculating Percentage Input fields per record !
27520: Check if record has dependencies
27521: Trying to understand transaction model
27522: Creating table with Identity property
27523: Problem in between clause
27524: Efficiency problems using PRINT in CURSORs
27525: Match timed events
27526: SQL2005 joins and wrong execution plan
27527: DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
27528: how to check whether the sql server is up
27529: Composite index design question
27530: database design:dnamically build where clause
27531: How to simplify my storeprocedure
27532: Group by weekends
27533: Help with trigger
27534: Join table with a UDF?
27535: can't update table owned by dbo with impersonation account
27536: Interface
27537: Question about error handler
27538: SQL Server 2000 xml solution
27539: Call a Dll from Stored Procedure
27540: How to make argument/parameter optional in UDF/Trigger?
27541: how to create function which eval expression
27542: sp_OAMethod Returns Empty String
27543: Pick TOP 1 row per GROUP BY group
27544: How can I consume webservices from MS SQL 2005
27545: Can I build WHERE clause dynamically in a Stored Procedure in SQL Server 2005?
27546: combine data in one row?
27547: How to copy a table including all constraints,... to same database
27548: Newbie Select Problem
27549: Dynamic Where clause
27550: Stored prodedure OUTPUT parameter
27551: How can I use stored procedure's recordset output into simple SELECT statement?
27552: Static variable in SQL procedure ?
27553: SQL-DMO broken!
27554: Rowcount reporting incorrectly...
27555: Synchronizing data between sql 2000 and sql 2005
27556: looping with SQL
27557: Bulk Insert
27558: creating xml and passing it on.
27559: problem with datepart ....
27560: What is the cost Sql Server incurs by using the SqlDependency class?
27561: Isolation Levels
27562: ex stored proc and COM objects
27563: Creating a table from a view
27564: Having problems getting stored procedure to work.
27565: Select this and last years data to show side by side
27566: Challanging task, for fun - answer two questions from given data!
27567: Looking for a generic list
27568: Turkish characters are not displayed correctly on production server
27569: Any way to avoid using a cursor for this?
27570: Error (8626) while inserting record into table with text field and which is the base for indexed view
27571: How to set sql server setting let to set null value when a empty string (zero length) set to column?
27572: ALTER TABLE ... IDENTITY question....
27573: Migrating to SQL Server!
27574: Truncating vs. Rounding
27575: snapshots on sql25k
27576: HELP ME!
27577: HELP ME!
27578: A question of design
27579: PID in VHDL code
27580: Maintanance job fails
27581: Maintanence job fails
27582: SQL Server Agent
27583: values of Columns in two different table ---presentation
27584: values of Columns in two different table ---presentation
27585: Values of two columns in two different tables--presentation using select
27586: Values of two columns in two different tables--presentation using select
27587: Need help with stored procedure
27588: Creating a Backup Server software
27589: SQL 2005 Books Online and synchronize feature
27590: Can SQL Server 2005 using C# make a SOAP call do set operations?
27591: DTS Parsing Delimited Record
27592: Database Backup And Transaction Log - SQL Server 2000
27593: about MSSQLSERVER run as LocalSystem
27594: To find the number of occurrences
27595: query
27596: Calling a Stored Procedure inside mysql.
27597: New One Here - Dont Laugh
27598: User Defined Functions and 4-part names
27599: DTS and "SQL Server does not exist or access denied"
27600: -2147217887 Error when sending to SQL 2005
27601: Extract data from 350 seperate Excel Files
27602: Is this a permissions issue?
27603: Import & Delete Rows
27604: WHERE NOT EXISTS STATEMENT
27605: SQL Query Help
27606: Help with a loop.
27607: Strange Maths
27608: Advice
27609: Connecting to DB2 / AS 400 from SQL Server
27610: Suggestion Sought
27611: How to determine when the last successful full backup occurred?
27612: serial number in result of select statement
27613: ISQL & strange charcters
27614: Searching and replacing substrings
27615: Extended Stored Procedure <-> CLR
27616: Compare Permissions Between Databases
27617: Resubmit: "Trouble connecting to remote db using .net data provider for Sql Server"
27618: Inserting via a view
27619: DBCC CheckDB
27620: Insert into Problem
27621: Extended Store Procedure Query
27622: How to create a column names using results of query?
27623: Evaluating @@error
27624: Is it Possible to Concatenate a Text Column of a Table
27625: Using @ within column name of a table
27626: lop deleted row
27627: Best practice - triggers and SP
27628: How to order??
27629: Creating SQL triggers thru managed code
27630: how to enable auditing in SQL (or how to maintain session state variables)
27631: List out duplicate names only
27632: ; in T-SQL
27633: Query Notifications
27634: PIVOTing
27635: DTS Problem in stored proc
27636: Primary keys lost after DTS
27637: Calculation including previous record value
27638: Community Question: Fastest update path for experienced SQL Server 2000 developers.
27639: trimming question
27640: Please help! Database won't update
27641: Log not needed
27642: Performance difference over "not exists" and left join?
27643: Why is this view not indexable ?
27644: change database collation
27645: Table Names in 2005
27646: Flat File Prob in SSIS
27647: Last name, first name issue
27648: Trouble connecting to remote db using .net data provider for Sql Server
27649: parse xml and load into DB
27650: view index disappears