TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
30451: SQL server 2005 won't allow *= or =* syntax.
30452: insert 0 in select statement
30453: replacing [XFO=BM] in a column
30454: SSIS vs Scripting
30455: Find time interval between dates
30456: Calling a sp from a UDF
30457: How can I find records of a table which inserted today(for example)
30458: Finding records of a table which have been inserted from a time ago
30459: Index for primary keys
30460: SQL 2005 error
30461: Hide passwords from the trace using execute ('create login
30462: Trigger and OnDelete Cascade
30463: Data between two sql registrations
30464: Server does not exist Problem
30465: getting a date in the past
30466: INSERT QUERY!!
30467: Query returning inconsistent results - please help
30468: Using Cursor
30469: Bcp data with quotes
30470: Group data by time slot
30471: pass a value other than a recordset from a stored proc
30472: Inserting Records from Table type to Temp table
30473: using a result of one query to select the next query in a stored p
30474: Full Text Search
30475: Is VS2003 usable with SQL2005 or not?
30476: SELECT COL_NAME(@TableId, @ColumnId) FROM Departments DOES NOT WO
30477: Delete SQL Query - Brain Hurty
30478: SQL Server vs. Access
30479: Optional AND!!
30480: SQL count problem
30481: Cascade delete relationship slower?
30482: Generate row number in query
30483: Get column name and value
30484: JOINS and WHERE clause
30485: Ignore Some Errors
30486: Query help
30487: How to change server name in SQL2K ?
30488: possible to select top 5 * of 2 or more individual criteria?
30489: Returning values from a stored procedure - Help needed!
30490: Change how command runs
30491: insert into longvar
30492: Control jobs using SQL code?
30493: purge process from large table
30494: Complex Query to Create View
30495: How to change server name in SQL2K ?
30496: simple select
30497: optimistic locking
30498: Query In-between Dates
30499: Calling VB dll method: sp_OAMethod Error
30500: help me with Paging problem sql server 2000
30501: Computing a Grand Total
30502: Left Outer Join Question When One "ON" Value Empty
30503: Creating Summary Table - from multiple tables
30504: sa password rules
30505: Encryption by Password
30506: Developing for 2000 (SQL8) on 2005 (SQL9)
30507: How do I do this query
30508: Hierarchical data with any DataReader
30509: [SQL2005] Binding defaults without using sp_bindefault
30510: Complex SQL Query
30511: Dynamic Data
30512: Is Agent installed?
30513: Could not execute query against OLE DB provider 'MSIDXS' Error
30514: Failover and detecting cluster switch
30515: How to treat Database Snapshots as if they were one database?
30516: XML Data Type
30517: SQL server becomes case sensitive if I choose collation as : Chinese_PRC_BIN
30518: Restore MDF file
30519: deadlock
30520: need help to write query
30521: generate update statements for existing data
30522: Import MDF SQL 2000 file into SQL 2005 Express
30523: Update Query Help!
30524: Design Question
30525: Why the correct index is not selected
30526: Error 3716 - security settings
30527: Divide Integers
30528: Conditional Join
30529: Question on Settings in Connection
30530: visual basic transformation script
30531: slow accross subnets
30532: query with a column per row of a linked table
30533: Problem during MSDE to SQL Express migration
30534: Subreports to separate books in excel
30535: Substitute the Null fields in the results of a sql statement
30536: Multiple Contain Statements
30537: Tracking updated columns
30538: SQL Express and DTS
30539: Coalesce Question
30540: A trigger that backups data from several tables...??
30541: Transaction log file size?
30542: Data lost during converting int to smallint
30543: Calculating Quarters for a Forcasting Report
30544: Calculating Quarters for a Forcasting Report
30545: Table growth
30546: OBJECTPROPERTY question
30547: Creating a Stored Procedure to collect DB information and then run another Stored Procedure using that information
30548: Linking Excel and SQL
30549: Date range with only an 'EffectiveFrom' column
30550: Using aliases with COMPUTE
30551: Datetime convert problem
30552: Cursors within stored procedures
30553: BCP path problem
30554: xp_sendmail task
30555: Intra Query Error
30556: comparing dates
30557: using datetime in where clause
30558: Job Status Suspended
30559: Passing Parameters
30560: Database backup?
30561: Setting database options in a view
30562: Query/table tweaking Help
30563: Saving results from query in Web Data Adminstrator...
30564: Foreign key to multiple tables
30565: DTS completion time jump
30566: Store attachment into table
30567: Domain name from URL
30568: Group by datetime
30569: Changing between Identity type and Int type
30570: query - which came last?
30571: Datetime comparsion
30572: SQL SERVER PARSE ERRORS
30573: Use ACCESS driver on Win NT4.0
30574: Bulk Insert Problem
30575: Fast updates in SQL Server
30576: I want to set this error into a variable
30577: How to specify another Server
30578: Logic for picking values from columns
30579: Optimizing insert performance
30580: Execute stored proc dynamically (stored a variable)
30581: 2 highest marks of each group
30582: Delete Duplication
30583: Assign multiple variables from select in stored Procedure
30584: Suppressing SQL Errors
30585: Jet OLDB Error on 1/2 of A/A Cluster
30586: why sql server 2000 full text search doesn't work ?
30587: Need guidence on notifing when a new users is added
30588: Conditional column NAME on insert/update
30589: TimeSpan
30590: Which one is faster?
30591: Relational Design Question
30592: datediff2
30593: What is the best way to transfer databases from one server to anot
30594: datediff
30595: Derived Query
30596: HELP! Problem with data selection.
30597: Bulk repopulation of a table
30598: convert datetime
30599: XMLDOC
30600: OPENQUERY from ASP.NET Page Problem?
30601: help me
30602: Help with a complex Join
30603: Changing the database from MSAccess to MSSQLServer.
30604: continuous dates
30605: VIEW will not UPDATE with INSTEAD OF TRIGGER
30606: Maximum Size for UDT
30607: Null and UDTs
30608: Name property of SqlUserDefinedType
30609: Update Help
30610: Whare are temp table names padded with underscores?
30611: Can CONTAINSTABLE be made to match unconditionally?
30612: Confusing CONTAINS behavior
30613: append single character at specific position in string
30614: Making a term found in a string the subject
30615: Inserting Records from Table type to Temp table
30616: Problem with too many queries.
30617: String Manilpulation
30618: Time format hh:mm:ss pm
30619: Order By Primary Key
30620: [ot] VBA workgroup / domain name
30621: Use of TABLOCKX
30622: stored proc help
30623: Text file import
30624: Yukon and intellisense?
30625: Select where result are by the best match
30626: Verify if a Table Exists
30627: Need the Guru HELP. Ðåáÿòà, ïîìîãèòå!
30628: tnx
30629: getting today's data in '2006-01-20' format
30630: Table to comma delimited
30631: Data Compare
30632: Changing NULL to zero
30633: remotely start/stop sql server service in a workgroup
30634: union ?
30635: Can I write query like this
30636: is there a way to get listing of table relationships
30637: where current of cursorName
30638: Changing the Table Type
30639: ASP.NET * Cannot find file
30640: TRIGGER UPDATE QUESTION
30641: How to add sproc to multiple databases
30642: Clean out (Reinitialize) SQL Server Database?
30643: Identity Values
30644: instead of trigger on view
30645: sending results of query into a table
30646: Throwing Errors In VB Script From SQL Job
30647: How to remotely start SQL Server instance?
30648: Really really slow cursor
30649: Problem copying data from column in same table
30650: Not like operator seems to be being ignored in Trigger
30651: TreeView Populating problem
30652: Inline table function help
30653: Creating a table
30654: Have Svr name, need DBs
30655: variable for DateAdd datapart constant
30656: xp_readmail
30657: Hyperlink
30658: How can we CREATE a VIEW with variable which stores a select stat?
30659: finding the difference from one row to another
30660: Update one table from another table
30661: reverse like?
30662: Case Within Where Clause
30663: Stored Procedure to Delete Rows
30664: Can't we use variables in OPENQUERY, FREETEXT("@searchstring")?
30665: sa password
30666: Calling webservice from CLR Stored Procedure
30667: Program Logic
30668: Problems Enumerating Role Permissions with SMO
30669: Varbinary columns...
30670: Is it possible to use a Function directly as a Input Parameter for a Inline UDF
30671: Job LastRunOutCome??
30672: Joining Tables
30673: SQL Server Express 2005 and VS.Net 2003
30674: Biztalk 2004 & SQL
30675: inserting single precision data into sql server float column
30676: Funny! More offers to select a search engine! (PP)
30677: SQL Help - dynamically change where condition
30678: DateTime Bugs??
30679: SQL dilema
30680: Funny! More offers to select a search engine!
30681: on insert trigger and a linked server?
30682: GetDate inside a Function
30683: performance on the join
30684: Cant It be Done?? Backup mdf and ldf only
30685: User Instances and Scripts
30686: CTE vs. Table Variable (Paging)
30687: generate three rows out of one row from a table
30688: can't insert into ...because of nulls problme!
30689: Consoldate columns in a SELECT
30690: Programatic replication
30691: Backup Contains .mdf .ldf and .ndf dont want .ndf
30692: Encrypting Stored Procedure Code
30693: how to read a 1204 and 1206 trace log entry
30694: Stored procedure problem - update help needed
30695: SMO-license
30696: How to get the name of the column that is an Identity Column
30697: Job issue
30698: Query Timeouts--Indexing Questions
30699: Advice required on database structure
30700: sql division
30701: Network Packet Size
30702: statistics io question
30703: VS.NET 2003 and Stored Procedure Debug
30704: Object search feature
30705: big log file
30706: 3 tables ...
30707: Returning Duplicate Records
30708: Parse w3c Date and Time in SQL Server 2000(sp4)
30709: Indexed Views, Space Used.
30710: Stored procedure; add row to ouput result set
30711: Return random number from trigger
30712: nolock
30713: Problem of Permissions for Linked Servers in .net page
30714: Which sp is causing the blockings...?
30715: Queries for Back up and restore the databases
30716: SQL Statements or Table Redesign
30717: SQL 2005
30718: Another Temporary Table Q
30719: Help on "splitting up" data in a field
30720: SQL Server Browser service?
30721: Temporary Tables
30722: Stored procedure in asp timeout
30723: Usage of RaiseError
30724: Job/DTS Scheduled Execution
30725: Scheduling DtsBackup2000?
30726: TDS buffer length too large
30727: Help on passing param to store procedure ???
30728: Can You SQL Inject this code?
30729: Unicode encoding problem ?
30730: SQL-DMO scripts or something like that
30731: Help obtain a window of rows from a table
30732: local ip address
30733: Using output parameters in SQL Functions
30734: !!Famous Software ftp download 2006!!
30735: Another Slow Execution Plan with sp_prepare
30736: Is there a better way to write this?
30737: Exporting data using ONLY the WebAdmin interface...
30738: Automation scripts??????????????
30739: SQLExpress - User Instance OSQL
30740: replace spaces in a quotation
30741: Query to do chart
30742: profiler
30743: nvarchar(max) question
30744: Wrong Execution Plan
30745: info..._schema.routines no Triggers listed - how to find scripts?
30746: Filegroup Question
30747: Help with an SQL query
30748: Upgrade Script
30749: SSIS and SQL Proc
30750: Retrieve the error description
30751: Retrieving error messages
30752: Retrieving the error message
30753: Extending SQL Server Management Studio
30754: Query Analyzer Anomoly or not?
30755: Slow Query with sp_prepare and sp_execute
30756: Conditional inserts in trigger
30757: Replace data portion of a column
30758: custom datatype SQL server 2000
30759: Determine the type of trigger
30760: Inside Common Table Expressions (CTE)
30761: ActiveX Scritping was not able to initialize the script execution
30762: Bulk Insert Import Question
30763: multiple large table scans
30764: Creating SQL Triggers
30765: Stored procedure problem
30766: Indexed Views & Constraints
30767: very slow queries after restore database
30768: Can .BCP file open in text editor?
30769: Select Max(somecolumn) + 1 problem??
30770: Returning A Scalar Value
30771: Copying Records into a different table using triggers
30772: create rule
30773: How to prevent from deleting record?
30774: Update problem.
30775: sql syntax calculated field in view
30776: exec stored proc and use udf or select in it
30777: DB Redesign - use junction/xref table?
30778: Possible self-join question
30779: SQL Jobs/Tasks priorities
30780: Urgent help needed!
30781: Selected Data Deletion
30782: Problem with comparing a Table View Column with the Table Column?
30783: SQL 2005 Mirroring Databases
30784: PRB: INSTEAD OF UPDATE trigger fails when UPDATE is done from an stored procedure
30785: Connect SQL Server 2005 through SQL-DMO
30786: Search through dts
30787: Convert to Julian Date
30788: Error during Removing the DB access to BUILTIN\Administrators
30789: Hooking up multiple databases in order to be able to key into the data more easily
30790: Is there any advantages of using views in the same DB instead of tables in a different DB?
30791: Transaction question
30792: Remote SP debugging from VS 2003: error
30793: Are there any issues with installing SQL 05 on dual boot system - D drive?
30794: SQL Parser
30795: select & update data with special characters
30796: About CASE and WHERE
30797: Instead Of Trigger Question
30798: LIKE % % statement
30799: INSERT Help Required
30800: trigger and stored procedure