TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
11551: Append/Update to table when view created
11552: Service Account Lockout
11553: Microsoft SQL Server DBA's required immediately in Toronto
11554: Tough problem: can this be done using parameterized stored procedures?
11555: removing duplicate rows - keeping the highest value row
11556: ALTER TABLE weird behaviour
11557: String Manipulation in 2005
11558: bulk insert rowterminator unix files - An unexpected end of file was encountered
11559: bulkinsert and creating columns on the fly?
11560: xp_sendmail with non-recognized recipient
11561: A question related to stored procedure
11562: New to SQL, where to start?
11563: Totals
11564: Would you like to have access video tutorials totally free?
11565: Checking for an Error
11566: Question on SQL Server SQL
11567: SMO: running a stored procedure in C#
11568: Tricky TSQL question
11569: SQL Query Help
11570: Search for text in a database
11571: index error? selet statement return nothing
11572: How to select every "n"th row
11573: Trying to make counts per period
11574: Zwei Cursurs zeitgleich verwenden
11575: Check if all row value are in a list
11576: finding job history
11577: Trigger execution plan takes up to 10 seconds to compile
11578: Convert String to rows in sql 2000
11579: help with db schema design
11580: Deadlock error in sql server
11581: Your secret dreams
11582: Using TransferData
11583: error on alter login
11584: ^*^*^ Britneys BACK AND TITS!!! GALORE! !^-
11585: Line Number Item
11586: Cursor Question
11587: temp table strategy
11588: Help importing large csv file into SQL
11589: simple Query to retrieve data from a linked table
11590: inlining function call on a exec sproc
11591: Temp Table
11592: Import vb.Net xml file to sql server 2000?
11593: please comfirm I am right/wrong on #TempTable
11594: Help needed handling single quotes
11595: Generate insert scripts from existing data
11596: How Should Records Be Inserted?
11597: Are cross-collation queries possible
11598: Indexes (Field1 & Field1 + Field2)
11599: Metadata for table variable?
11600: What is wrong with this query?
11601: SqlDependency OnChange only works for 2 minutes
11602: Large repeated inserts and datalayers.
11603: Parse Field into Multiple Records TSQL
11604: xp_fileexist with wild card does not return true
11605: Validate if first char in string is numeric
11606: Speed SQL
11607: Error 5701 and 5703
11608: Alternatives to TIMESTAMP.
11609: Ok to use LEFT OUTER JOIN even when FK will not be null?
11610: Need help on table structure ???
11611: SQL server not starting
11612: Visualize and Navigate DB Schema
11613: Identical Systems Returning Different Sorted Order
11614: Query Analyzer Returns Rows in Different Order
11615: Optimalization
11616: SSRS 2005 - user rights
11617: SPSS with SQL Server
11618: Should I use dynamic SQL to combine 2 procs into 1?
11619: Interesting problem with order by
11620: Update set increment value
11621: sql 2005
11622: max errors in DTS
11623: View of table and column names in a DB using 2005
11624: Select one or all in the same proc?
11625: Keeping databases in sync...
11626: Help needed (About SQL Server Topics)
11627: hi hi hi
11628: Why do I get different results using these two approaches
11629: Find First AlphNumeric Char in a Field value
11630: Changing data type on a column
11631: WITH [Table] versus temp table
11632: Return Field Name as data
11633: select rows from specific groups problem?
11634: 3 views becoming unweildy
11635: How to select column values with percentage mark %?
11636: Updating non-ASCII characters with '' in a string
11637: Best Fit
11638: Is a Conditional Join Possible?
11639: Finding a number in a string
11640: Hi Friends, JOB ID: SB 0501 >>> Urgent req for SQL/.NET
11641: Complex counting, summing and grouping
11642: stored procedures scripting
11643: Delete Remote Files With FTP
11644: Weekly Totals
11645: Help with SELECT FROM DAY(CURRENT_TIMESTAMP)
11646: Problem with JOIN
11647: datepart question
11648: Somebody used Keyword OBJECT_ID as a column name...
11649: Obtaining Stored Proc and Trigger text
11650: Failed BCP Process in SQL Server 2005
11651: History for 1 extract table.
11652: Query Help
11653: concatenation
11654: Stored procedure assist
11655: SQL Query Notifications stopped working
11656: Calculated Balance Value
11657: How to select the latest timestamped record?
11658: rewrite NOT EXISTS to LEFT OUTER JOIN
11659: Need help setting up Backup Maint Task
11660: osql and file sizes
11661: SQL Server Solutions BLOG
11662: XML Problem
11663: How to Fix Error 207 in SQL SERVER 2000 with out using Service Pack SP4.
11664: Stored procedure evaluating a query passed as param
11665: Index on View with Count
11666: ~!~ Britneys New BOOB job fails Silcone Valley everywhere!!
11667: How to count number of commas.
11668: File Access Denied
11669: ^? Britney Gets Boob Job ******
11670: How do you inner join two tables were one is based on the others top 1 id?
11671: Create Procedure question
11672: SQL Server 2k Query How to display seconds in time format
11673: How to create a job to poll my table
11674: Handling Errors of SQL Server in C++
11675: Best Identifier for a LOT of data
11676: one-many select clause
11677: 2005: "The updated row has cahnged or been deleted since data was last retrieved"
11678: Update Query
11679: VSS for SQL2000 / 2005
11680: Rolllup option on OleDbDataAdapter
11681: Replace value in a field based on a set criteria?
11682: Replace value in a field based on a set criteria?
11683: Big problem with case sensitivity
11684: Log shipping error
11685: some questions abount sql server
11686: xp_sendmail problems
11687: Query Syntax (SQL2000)
11688: FTP Connection Manager
11689: Table valued paging function
11690: Which Database is sql script run in?
11691: Select sum
11692: Add Column - table has 29+million rows...
11693: Primary Key being incremented by 1
11694: Tranlog space usage
11695: select query
11696: System.Data.SqlClient.SqlException: This statement has attempted to access data whose access is restricted by the assembly.
11697: using SS2K as a files repository
11698: Time datatype on SQL2005
11699: QUERY HELP!
11700: Column Headings
11701: Getting results for 2nd row of the group.
11702: len() returning weird result
11703: Dynamically changing database context ('USE [@dbnname]') from query analyzer
11704: Help on trigger
11705: Mel Gibson Spanking!
11706: How to delete a block of rows?
11707: Invalid column name
11708: Invalid Column Name
11709: Programmatically find out the INCLUDE columns on an index
11710: openrowset and opendatasource issue
11711: How to copy objects with SSIS
11712: Date Query Problem
11713: Error: String or binary data would be truncated.
11714: Urgent! Create Login Windows Authentication
11715: Problem with comparing casted fields
11716: Appending values in multiple columns
11717: Query Guru's Please
11718: What is wrong with this stored procedure?
11719: Advanced Query Help
11720: Execute SQL Statement
11721: Referencing a table that is not available in a Stored Procedure
11722: =// Homeland Security on High Alert
11723: Out of stack space error
11724: comma seperated id's
11725: "LIMIT" or "FETCH FIRST n ROWS ONLY" equivalent in T-SQL?
11726: SQL and use of apostrophes?
11727: MSDE and a SQL Server 2005 Standard Edition
11728: Update Query
11729: SELECT Statement
11730: database name
11731: Create Oracle 9i Linked Server
11732: Please help beginners
11733: Date
11734: Finding all the indexes on a server with AllowPageLocks set to FALSE?
11735: URGENT! How to flatten table in SqlServer2000?
11736: Property CurrentRunStatus cannot be used for filter
11737: Locking hints
11738: Embedding SqlServer policy for character comparison
11739: Find & Delete duplicate blobs
11740: Combine a SQL result set
11741: Insert into declared table
11742: Payment by Item && Help
11743: Connecting through proxy
11744: Isolation Levels for Non-Read Operations
11745: Search all columns in database for a number/currency
11746: 2005: rollback in trigger (newbie)
11747: Can't Truncate table
11748: Query Killing me
11749: Repeated City Name
11750: Yet another question about connection to SQLExpress
11751: Complex query question
11752: Help in query
11753: Complex sql query question
11754: GROUP BY
11755: Deadlocking on parallel create indexes?
11756: Service pack
11757: Cursors and locking
11758: SQL Query
11759: Fail an SSIS Job if No Records
11760: Difference between submit date and now
11761: datagridview - how to identify the Top Left Corner Select all cell
11762: convert nulls to 0
11763: get AD user class via SQL
11764: using wildcards [ ] in REPLACE or CHARINDEX functions
11765: For XML Explicit Help
11766: Find all appearances of the value
11767: Beautiful woman having SEX IN WEBCAM
11768: row with NULL value in column not being returned
11769: Restore File Name
11770: [Wierd News] Data Entry Operators and Input Validation
11771: Sybase SQL Anywhere Server v5.5 as a Linked Server.
11772: SQLParameter of type XML issue : size property has an invalid size of 0
11773: Collation of columns in table variables
11774: How to prevent accidently dropping a table
11775: Find all mention of a field in SPs
11776: How does UPDATE statement work?
11777: Update question
11778: many to many join
11779: Shaping a column in query
11780: Help with constraint
11781: Update statement error
11782: Finding UnMatched Using Left Join
11783: Cross-tab query for last 3 sales
11784: Inefficient Query with Temp Table; Can't EXEC() in UDF
11785: Collecting database status from linked servers
11786: Updating Certain Records
11787: Correct Way to Insert into Multiple Tables
11788: Performance of HAVING vs WHERE
11789: UPDATETEXT
11790: Join tables
11791: extract all characters to the left of character
11792: email details
11793: how to combine 2 databases from 2 servers
11794: Time comparison
11795: Big Select Union Query Compilation Time Problem
11796: Error while executing stored procedure (please help)
11797: Views
11798: OUTER JOIN not returning all rows of outer table
11799: Prior to bulk insert - in T-SQL, how to check for column headers?
11800: select * from tbl1 Join tbl -- VS Inner Join
11801: BULK INSERT and row order
11802: Proper cursor definitions for table updates/inserts?
11803: Grouping problem
11804: With keyword
11805: diff between OPENROWSET and OPENROWSOURCE
11806: Trigger is randomly disabled....
11807: updatetext
11808: Nested View Optimization
11809: ExecuteWithResultsAndMessages2 sql-dmo
11810: Database layout help. Users to add columns.
11811: How to implement "Firebird-events" into SQL Server 2005
11812: Updating a SQLServer table causes error 3146 odbc - call failed on datetime update
11813: Unable to upload 300MB file as image using sqljdbc1.0
11814: Simple parameterization still forced?
11815: can't recreate a uniquely named temporary table in stored procs
11816: Performance differences with record numbers in SQL Server 2005
11817: Parse xml Node value in xquery ?
11818: Parse XML node Value Using Xquery ?
11819: difficulty with SQL to get view
11820: Check Constraint
11821: SQL
11822: new stored procedure
11823: only works when volume of data is little !!
11824: assigining a user without a login to a role
11825: SELECTing only the first n records from a database
11826: Subquery, NOT IN and NULL's with returns unexpected results.
11827: Datetime Conversion Voodoo (Migrating from SQL Server 2000 to SQL Server 2005)
11828: STORED PROCEDURE HELP
11829: Autogenerated Table Records
11830: how to DELETE from HEADER table when no entries exist in a linked
11831: Writing to Exchange Public Calendat
11832: foreign key and peformance question
11833: using variable for db name
11834: Prevent Combination Duplicates
11835: creating stored procedures
11836: Refer to another server table in a view
11837: sql / database question
11838: How do you script to check Identity in all tables???
11839: Faster way to do this?
11840: Update Trigger
11841: How to convert from rows to columns format in the table
11842: Number of reads using Primary key
11843: INSTEAD OF TRIGGERS
11844: Foreign keys and nulls
11845: DataType alter
11846: Any way to remove the backup date/time stamp?
11847: OPENXML vs. XMLREADER in C# vs. XML Bulk Load
11848: time difference between rows in one column
11849: job activity monitor replica
11850: finding the longest string in a column
11851: Help with outer join
11852: create indexes on views
11853: Check Constraint
11854: Deploying a maintenance plan
11855: lost data on INSERT
11856: dubt: how to swap rows and cols
11857: New blog about SQL Server Programming
11858: Unique Value if not null
11859: Len/DataLenght for Text Datatype
11860: Openrowset -> Login failed for user '(null)'. Reason: Not associated
11861: First , Last in Group By
11862: SQL Query For Timestamp
11863: SQL Query For Timestamp
11864: concat query result rows to a string
11865: Update multiple Fields in a SQL database
11866: Why does the select statement trigger SQL Transaction Event?
11867: Alter Identity
11868: Extended Stored Procedure
11869: HELP IN THIS SPECIAL JOIN
11870: Trouble with format files
11871: Need help with results being returned
11872: sql statement question
11873: Calling a stored procedure from another stored procedure
11874: Use FQDN in ODBC string?
11875: initalizing column in Trigger?
11876: @@FETCH_STATUS not being reset
11877: Generate XML Schema
11878: Create database
11879: Question about the integrity of a view
11880: SP_VERIFY_JOBSTEP
11881: OSQL preload
11882: Table Design
11883: Need to create Array in Stored Procedure
11884: unexpected results with a query
11885: Setting a constant value to a destination field in DTS transformat
11886: Finding the last updated record
11887: Access to SQL Server Conversion
11888: single column to multiple
11889: Incorrect syntax near Create Sproc
11890: JPEGs into image column
11891: Schema bound views?
11892: Property IsPrimaryFile is not available for DataFile
11893: Application Name in connection string and logins...
11894: MSDE 2000, SqlConnection and Async=True
11895: Problem with custom reservation system, date querying
11896: Problem with "NOT EXISTS" query
11897: Pivot Query
11898: Adding assembly with references in SQL Server 2005
11899: Copy database diagrams from one database to other in SQL 2005
11900: Memory pressure issues when running CLR stored procedures.