TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
27651: parse xml and load into DB
27652: view index disappears
27653: Need help with stored procedure
27654: @@FETCH_STATUS
27655: How to perform this unique contraint?
27656: Removing Identity property SQL2K5
27657: indexed view
27658: Bulk Insert
27659: vb.net calling SQL server does not return all rows under Windows XP
27660: Fill factor
27661: global vars in script files ?
27662: Help with datetime
27663: Calculating Yield
27664: weird TSQL question
27665: Alias a column that has 3 values into 3 columns
27666: Move Data from Schema to schema
27667: Track Database Size
27668: Data Integrity Question
27669: osql output file has leading whitespace
27670: SQL Error - substituting ?
27671: Problems with stored procedure
27672: Determine if a trigger exists.
27673: identity set to off for now
27674: count occurrence of character in a field using SQL
27675: Bulk Insert
27676: Count (Distinct ??
27677: How to check whether in distributed transaction or not?
27678: Using Sql 2005 Management Studio for SPs
27679: Is it possible to merge date from 2 or 3 tables into a View?
27680: raise message from Update Trigger from External App
27681: Importing Data
27682: BCP help, or alternative
27683: Q: on "uniqueidentifier"
27684: Linking to FoxPro files from SQL Server
27685: Problem with XQuery Syntax
27686: Need Help to create insert procedure
27687: Arabic and Far East text saving as ???
27688: Problem with SQL Statement and JOIN
27689: Need help with T-SQL in Sql Server 2005 to build a WHERE clause
27690: Time/Calendar best practices
27691: Can I release temp SQL Tables?
27692: Copy a table
27693: How to add message to sql server log?
27694: sql 2k insert into error
27695: Microsoft.SqlServer.* assemblies: are they redistributable?
27696: Determin start and end date of a month
27697: Insert more then one records at a time.
27698: BCP into image columns
27699: Datetime and Indexes
27700: DTS execute package task
27701: DTS execute package task
27702: I cannot explain the difference in execution plans.
27703: SQL Server 2000 Stored Procedures Handbook Read it for Free!
27704: Microsoft SQL Server 2000 High Availability Free Preview eBook5.co
27705: INNER JOIN key words
27706: Syntax error converting the varchar to a column of data type int.
27707: how to improve the Performance
27708: Syntax error when SELECT in parenthesis
27709: Match dates in two tables, combining historical events
27710: Create a new table from 2 diffrent tables
27711: Parsing data from strings
27712: Foreign key integrity when combining two SQL Server databases
27713: can we increment the column --autimatically---is there any possiblity with tiggers
27714: Database design
27715: why is a cursor faster than insert @table_name?
27716: create a Maintenance plan
27717: Where is the execution plan
27718: Scheduling a DTS package without admin privileges.
27719: Testing For File Existence in Transact-SQL
27720: Passing paramater as type date to stored procedue
27721: Order on Second Select of Using Statement
27722: DateTime Calculation
27723: OPENXML Invalid column name error on update
27724: Reporting the space used of an individual logfile from a single DB.
27725: Can I do this without a cursor?
27726: Looping vs. Set operation - question
27727: Changing the datatype of a column which is part of a PK
27728: Create table as I need it, how to reference in query?
27729: help with a query
27730: SQL 2005 login
27731: GROUP BY Question
27732: Problem running SSIS package from sp
27733: How to check whether I am in distributed transaction or not
27734: Prelogin Packet structurally invalid
27735: help with index
27736: Replacement for SETUSER
27737: Transaction log
27738: Simple join
27739: Limit query results
27740: error handling
27741: Profiler Question
27742: Help with Stored Procedure, Taking too long to run...
27743: do process
27744: Calulated Fields vs UDF's
27745: Automating a time-sensitive query
27746: Oracle vs. SQL Server schema compare
27747: Determining single-column candidate keys
27748: How to create an Worldwide Opened Webservice by SQL2005?
27749: Exec a StoredProc from in a Select statement that returns mult. ro
27750: Generate Scripts without the Collate statement
27751: Summing a column
27752: Data from previous quarter
27753: can you invoke com and dotnet components from psql
27754: Formatting Data
27755: Visual Basic
27756: How to detect an EndPoint is existed or not?
27757: joins
27758: sql server localhost installation
27759: How to do this
27760: send and return value from storedprocedure
27761: Access denied on ScriptTransfer call
27762: Script : Clear connections on a database
27763: Problems connecting to SQL 2005 DB on server
27764: Log space utilization information
27765: Buying a car without a driver's seat
27766: Bulk insert
27767: problem in fulltext search in MS SQL Server
27768: How to change QUOTED_IDENTIFIER for table?
27769: How to design this?
27770: Converting Access database to SQL Server w/ flat files
27771: How to move a table to different schema in SQL 2005
27772: Delete formatting from strings
27773: FTP help
27774: Copying column into another
27775: Connection - MSSQL - HOST_ID
27776: ABS () and dates
27777: Materials Needed
27778: SQL Syntax Check
27779: DMO Enumerating SProc Parameters
27780: How to get ID for new record
27781: Proper use of Inner Join with nested select?
27782: How to include total in query?
27783: slick query question
27784: PIVOT problems
27785: Get Missing Dates
27786: Possibly simple query but I'm not good enough to fathom it!
27787: SQL Query Analyzer and Column Names
27788: display FLOAT datatype with commas?
27789: Linked server to Oracle - error on NVARCHAR2()
27790: sp_recompile on a table - are sprocs truly recompiled?
27791: Beginners SQL Query i cant suse out
27792: CHECK constraint
27793: Cycles or multiple cascade paths
27794: sql express - get the data out of here!
27795: Date Conversion
27796: Query Evaluvation and tempdb
27797: Service Broker service
27798: Query Help, PLZ
27799: Load Data from Flat File to Oracle with SQL Loader
27800: Plan not using Index
27801: SQL Query Help
27802: Is ISO/IEC 9075 bad?
27803: INNER JOIN on 3 Tables need distinct rows
27804: SQL 2K5 Query Builder
27805: =?Utf-8?Q?Store_Procedure_return_error_wit?=
27806: simple query help
27807: Problems converting Access UNION query to SQL
27808: update from join slow
27809: Divide by Zero
27810: compare 2 strings
27811: bcp Question
27812: Unable to access perfmon counters remotely
27813: Problem with BULK INSERT in SQL Server 2005 Express
27814: SQL2000 Performance question
27815: problem in fulltext search in MS SQL Server
27816: Complex Query!
27817: SqlServer 2000 - Identity problem
27818: sargable vs non-sargable queries
27819: About Sql Server 2005
27820: inserting UTF-8 values into SQL Server 2005 tables
27821: Cannot return results of temporary table
27822: Financial Query Help
27823: What is .NDF file?
27824: DTS Sproc REturn Value
27825: SPs vs Dynamic SQL
27826: How to lock a particular Row in a sql server
27827: trigger status
27828: disable all triggers
27829: Search value thru SP
27830: Two Questions, please help
27831: Help with time
27832: Syntax Highlighting Printing in Colour
27833: TRIGGER Question
27834: Rename Files
27835: Need Your Thoughts
27836: ORDER BY with SELECT DISTINCT
27837: Getting a count of items
27838: Loading new data - "raw formats"
27839: Help with Trigger
27840: Problem with ALTER TABLE in stored procedure
27841: Distributed Queries require access to administrator temp folder
27842: Problem With the SQL Statement
27843: Closing open sessions
27844: SQL physical stats
27845: Does SQL 2005 Support Chinese??
27846: TSQL For updating IDENTITY Column
27847: Web service hangs on ExecuteNonQuery
27848: SQL Server driver information
27849: Discrepancy between MS Whitepaper and BOL on updating stats and recompiles
27850: Discrepancy between MS Whitepaper and BOL in cache
27851: error: CoCreate of DSO for BULKIMPORTSTREAM
27852: IF Statement in WHERE clause
27853: BEGIN......COMMIT TRANSACTION
27854: Any way to make a stored procedure process asynchronously?
27855: Full Text Help!
27856: Nested Stored Procs w/Transactions
27857: New project - thinking of using Visual studio 2005
27858: Find a date that occurs every 2 days from a fixed date
27859: condense this working SQL into an algorithm
27860: Linked SQL Server Question
27861: Misleading SQL Exception?
27862: Draw many to many relationship diagram
27863: Taking out (CR) (LF) in a ntext data type
27864: Query help - employees and managers
27865: Assigning group number for millions of data
27866: How to get the whole DDL command from EVENT_INSTANCE
27867: Assigning group number for millions of data
27868: Transaction log question
27869: bind storedprocedure's parameters
27870: group Number for millions of records.
27871: with clause in 2000
27872: How can I do amalgamate 3 select queries and then get unique entries from the result
27873: SELECT a FROM x ORDER BY b
27874: xp_cmdshell
27875: List all the tables on a SQL Server
27876: function within view
27877: Coalescing data from more than 2 tables
27878: ingnore error for "Insert Into" query..
27879: ORDBY BY difference between two numbers
27880: calling stored using CDatabase
27881: drastic change in speed
27882: Inserting/updating rows from a delimited text file.
27883: Hierarchy
27884: Using automation on tables
27885: Can I access...................
27886: Missing results from stored proc
27887: One-To-Many return the many in a single row
27888: Does DATEADD change the datatype?
27889: SQL 2005 and Backups
27890: trouble with SSIS CPackage::LoadFromXML fails.
27891: using SQL-DMO to create maintenance plan
27892: If IN is an OR .. what would be the equivalent AND
27893: itzik ben-gan
27894: Need help with assumed fairly simple query
27895: Generate a GUID in MS SQL (t/SQL)
27896: how to save entity relationship diagram to a file
27897: month end date...
27898: SSIS - check for duplicate file in Script task?
27899: How ro append characetrs to auto-incrementing number
27900: Case conditional action
27901: Calculation
27902: Is not = to query
27903: How to check the existence of table in a specific file or in fileg
27904: How can i reprogram this? It's taking forever to run.
27905: problem retrieving correct max(date) row from this dataset
27906: how to UNIQUE my dataset results
27907: SPSS with SQL Server 2000
27908: Check if DB Constraints exist on a table
27909: pre-SQL 2005 XML workaround
27910: SQLCLR Assembly using SMO
27911: Server: Msg 208, Level 16, State 0
27912: Need to show zero's (0) when using coalesce.
27913: how do i authenticate into a Web Service through sqlclr?
27914: how do i authenticate into a Web Service through sqlclr?
27915: IDENTITY_INSERT
27916: Trying to accomplish using Self Join
27917: one control loop with Substring to correct first normal column violation
27918: Unique Distinct Records
27919: Get Last day of month.
27920: how to replace part of the value of a variable?
27921: Trim function
27922: Declaring default value for a variable
27923: DAO TableDef and SQL Server
27924: Constraints and Foreign Keys....
27925: creating a query sql
27926: Detecting Circular References.
27927: Copying Data to a File
27928: UDF and parameters
27929: Query by Time-Slices
27930: PLEASE PLEASE PLEASE HELP...[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation.
27931: Help converting procedural VB code to SQL
27932: Calculate Time Off
27933: NEED HELP with sql server express and Windows Service !!
27934: procedures attribute in xquery
27935: Are declared primary keys necessary in SQL Server?
27936: Read DESCRIPTION from a backuped DB file in .Net
27937: SQL Syntax
27938: need spurce code for asp project
27939: Inner join of 2 in-line UDFs - why is it so slow?
27940: Removal of punctuation from fields
27941: SQL Job - Errors?
27942: adding two sum() 'ed values
27943: Workable limit on number of indices
27944: BCP
27945: fifo-syntax SQL
27946: Question about Insert/Update/Delete to return fail/success
27947: newbie question on indices
27948: Is it a bug of SQL Server 2000 SP4?
27949: Yet another (dead)locking question - is this possible???
27950: Newbie - Help required with Query (sample tables/data included)
27951: CHECK constraint
27952: Large value types out of row - objectproperties
27953: SQL CASE Check and Select
27954: Easy Transact SQL Question
27955: Return multiple dependent tables to a dataset
27956: Backup a database
27957: Selecet with Pading
27958: Cannot Connect
27959: BCP issue
27960: Question: Datalogger->Tables
27961: DBNULL is giving me a headach!
27962: [OT] How to know when it's time to goto sleep.
27963: Help with stored procedure or Trigger.
27964: Why I hate SQL Management Studio
27965: Sending Mail Programmatically
27966: How to send mail programmatically from SQL2000
27967: cleaning up duplicates
27968: Temporary Table Issue with Multiple Users
27969: How to populate a varbinary column of a DataTable object from a file stream?
27970: Grant Execute!
27971: Compare Dates
27972: Getdate() in UDF column workaround
27973: Unique Values in View
27974: help with tsql
27975: Data Warehouse Load Hints?
27976: Passing an array to sql
27977: [Venting]
27978: Please help with update in this scenario
27979: SQL View into Active Directory
27980: Cache problem in Report Services
27981: Product qty in a given branch
27982: Deleting duplicate rows from a table without using temporary table
27983: http://www.eznom.net Free and Paid Hosting with cPanel or FTP Account
27984: To avoid redundancy in name
27985: must I upgrade asp.net to 2.0 to access SQL 2005?
27986: convert of code from access to sql server
27987: probelm of converting Dlookup in Sql Server
27988: Help with CASE T-SQL
27989: TRIGGER DATA
27990: Using IN
27991: Basic modeling question
27992: Multi-statement UDF vs. temp table
27993: BOM
27994: Update a part of a varchar field
27995: Rates
27996: Need help with ASP.NET website administration tool! - Can't connect to the database when clicked on (AspSqlProvider) test link
27997: PLEASE HELP... ERROR: "[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error.
27998: help selecting
27999: Error 8152
28000: single table query