TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
26251: Enterprise Manager 2/ Me 0
26252: ROLAP Vs MOLAP
26253: Data driven query - update only CERTAIN fields?
26254: Avoid duplicate index while creating temp table
26255: SQL Server Maximum rows in a table
26256: How can I combine 2 SELECT statements into 1 ?
26257: what tables referenced in a diagram
26258: Newbie Locking question
26259: sending email alerts from Sql Server
26260: How do I get the UserID column value of the User that just has been created from aspnet_Users table in aspnetdb?
26261: problem with a stored procedure
26262: problem with a stored procedure
26263: Error connectiong to database
26264: Best practice
26265: Case sensitive query
26266: Sending Temp table to csv
26267: Is this Correct database design
26268: SYSTEMUSER in green, SYSTEM_USER in pink
26269: Row numbering unpredictable
26270: Sending a IMAGE to a xp_proc
26271: Problem in sql function declare variables
26272: Update datetime field bug??
26273: Some basic questions
26274: Clearing all the data from a database
26275: Need help with a max query
26276: Audit trail - Sql Server 2000
26277: Need a function for banker's round
26278: selecting multiple rows from remote sp call
26279: insert record for 1 to 100000
26280: Bulk Insert XML?
26281: Help with cascading SELECT
26282: Creating random numbers
26283: DTS Package to VB
26284: Re: many small queries vs one large query
26285: Does full text indexing works on unicode field?
26286: newb: join on the server or the client?
26287: Trimming data field
26288: Trim functions SQL statement.
26289: SQL Select Puzzle
26290: Mother Celko's Monday SQL Puzlzle -2006-04-10
26291: Modify UDF hangs SQL Server
26292: Compare Triggers Values
26293: Select Where NOT IN not working?
26294: SQL Profiler question.
26295: Convert field
26296: Triggers
26297: Display leading zeros
26298: rkMail resulting with Column1/0
26299: Connecting to a remove SQL Server 2005 machine
26300: EnumAvailableSqlServers
26301: Calling a .net program from a stored procedure
26302: pass parameter to nested procedure?
26303: Create stored procs in new DB from within a stored proc?
26304: Retrieve Data from same table from different tables
26305: Aggregate returns null - sub value
26306: System to
26307: Query Optimizer
26308: Help with a Join/ Update Statement.
26309: Select statements with column indexes instead of column names
26310: email alert on job failure
26311: Normalizing help and naming conventions
26312: Why not varchar(MAX) all the time?
26313: select * from (select ...)
26314: Interpreting an Interop error code using SQL-DMO
26315: Re: Compairing Date Ranges with time
26316: instead of trigger for null insert - problem
26317: Need some practice
26318: set up a period?
26319: CREATE TRIGGER Only on Update of Current Record
26320: Why NOT to buy SQL 2005...
26321: replacement of *= in 2005
26322: What is Parallelism
26323: What is a full-text index?
26324: Urgent Date Problem
26325: Send Mail Task issue
26326: How to filter our system objects from the list
26327: Problems with string value "one space"
26328: SQL Row Comparison
26329: index tepmorary table
26330: rollback event procedure
26331: Triggers for tables on different DBs
26332: "Object is required" (DMO) ?
26333: using many database with one stored procedure
26334: Get files out of SQL 2000 Server?
26335: Insert statement help
26336: SQL list max value per month
26337: Urgent: ASP.NET Role Management problem
26338: SqlCommandBuilder.DeriveParameters returns invalid parameters type
26339: or vs union
26340: how to know time of insertion of a row
26341: create / alter a store procedure
26342: How do I: Create UNSAFE Assembly in SQL 2005
26343: Urgent - Subquery select statement
26344: How to retrieve data from query and link the data???
26345: How to write a monitor to records the users access the special database?
26346: Table collation changing
26347: Changing a database collation
26348: Membership Timeline Spanning
26349: Using SQLDMO with SQL 2005?
26350: calculate SUM of count /SQL query help.
26351: Complicated Update query based on existing data
26352: using the results of SUM
26353: few topics to refer back
26354: How to retrieve the text of UDF in SQL Server 2005
26355: datepart
26356: >> Help with Stored Procedure
26357: Get Windows NT/XP Logon ID in SQL Server
26358: Where is Bookmark Lookup?!
26359: Inserting Specific Value in Query Result
26360: temp table in external stored proc
26361: SELECT top 1 for each ID
26362: How can i update my dataSet to SQL Server Databse in c# ???
26363: Multiple Join Query Problem
26364: PATINDEX and CHARINDEX
26365: File size is growing fast
26366: getdate() format problem
26367: Compairing Date Ranges with time
26368: Query to display a field based on a parameter
26369: Updating new column with part of another
26370: Max Value in Column Other than Return Value Column
26371: User Define Database
26372: Full Text Setup
26373: PLS HELP! Problem with column width
26374: Archiving data to a seperate database.
26375: use variable in where statement
26376: Insert / Update Statement
26377: SSIS -- Copy object from SQL 2000 to SQL 2005
26378: Selecting Fields not to include in SELECT statement
26379: Convert Date to String
26380: Trigger logic question - using If with AND and OR
26381: SSIS Required for Programming?
26382: appending data to a text column
26383: Performance question
26384: Selecting min from duplicate records
26385: The database name component of the object qualifier must be the name of the current database
26386: How to restore tables dropped from logs in sql server?
26387: sp_executesql and datetime
26388: Trigger question
26389: SQL/CLR books
26390: HELP WITH TRIGGER
26391: Vbscript in a stored procedure
26392: SQL eating all memory
26393: Invalid Column Names?
26394: how to back up and restore Integration Services stuff?
26395: Why am I missing rows in my result set?
26396: Unexpected NOT IN results
26397: importing data from Oracle - Is there a limitations on the datatypes that can be retrieved?
26398: Advanced T-SQL Question: Produce Backup Window Gantt Chart
26399: [OT] There should be a law...
26400: how to get back image from table?
26401: SQL Performance difference
26402: Prioritise the execution of a specific Stored Procedure
26403: Stored Procedure Name
26404: XLS from DTS
26405: Registering by massive way sql servers
26406: sql gathering data from Internet?
26407: ROLLUP and summarazing values
26408: assign a table to a path and filename?
26409: What are new featuture of vs 2005
26410: Storing text files in a column
26411: xp_sendmail error
26412: database diagrams in SQL 2000 + VS.NET 2005
26413: BOL BCP example
26414: query?
26415: query timeout expired
26416: CREATE ASSEMBLY failed because it could not open the physical file
26417: Graphics
26418: System catalog - defaults
26419: nested queries
26420: View to show lowest value only
26421: sequential file and Parent ID's
26422: Help with a SQL Join statement
26423: Stored Procedure call using MSSQL::DBLIB
26424: Network I/O error in SQL 2000 with SP4 ?
26425: can't seem to get my GROUP BY ordering right
26426: What is the build number of SQL Server 2005 Express
26427: selecting records based on details in related tables
26428: Smart, multiple rows based query
26429: What T-SQL statement am I looking for?
26430: Convert Char data type to number
26431: Check Constraint
26432: Calling External Program from SQL Server 2000
26433: How to do ...?
26434: Passing multiple record sets from one procedure to another
26435: Event Notification question
26436: More on querying remote server
26437: help with case
26438: 3 months after the layoff...
26439: "Colescing" values in a field?
26440: Distributed transaction
26441: many small queries vs one large query
26442: Plz help me! I want to use SQL Server2000 DTS Import/Export Wizard functionality from C# application
26443: @@ROWCOUNT
26444: exporting data excel
26445: Table/Querry
26446: Partition switching
26447: business process logic in stored procedures
26448: Any help would be welcomed!!
26449: Regarding filegroups
26450: Default Values for a Column
26451: Problem saving text to DB
26452: No Rows returned in Enterprise Manager
26453: select specific child tables based on parent record
26454: Export Stored procedure to Access Error
26455: How to see is other process running?
26456: <<< I couldnt backup my SQL Databases >>> !!!!!!!!!!!!!!!!
26457: CSV From SELECT query
26458: Best Practices for Design of Views
26459: Jobs steps order all wrong
26460: Blocking processes
26461: Changes to order by in sql 2005
26462: status field in sysdatabases
26463: Help w/sum pls
26464: Looking for a method
26465: Data type for storing MS Word documents/large data type?
26466: Time out
26467: updating Servers BCP?
26468: Dynamic Date/Calendar
26469: Need fast Bill of Material query, procedure, whatever
26470: Memory usage keep growing....
26471: Table Design question
26472: transaction rollback : preferred technique
26473: Import TXT files via sql
26474: case expression in where clause and null's
26475: Lock on SELECT?
26476: Send to Email
26477: auto number
26478: SSIS Data Conversions
26479: Left Padding with Zeros on Count(*)
26480: T-SQL problem.
26481: Numbers of rows returned from mquery
26482: Q: on EXEC a sp
26483: Performance of EM
26484: SQL 2000 vs SQL 2005
26485: output of SP into a variable
26486: Using YEN sign in MONEY field
26487: Performance of EM
26488: remove all double quotes from column values using t-sql
26489: A.D. objectGUID - SQL Uniqueidentifier - Character String 2 UniqueIdentifier error
26490: nonclustered index fields
26491: view joined to subquery of random record
26492: Replication from SQL 2005 into SQL Express 2005???
26493: display values depending on a rule
26494: comparing two records field by field
26495: How to generate sequence?
26496: problems with installing SQL2005 standard.
26497: Triiger information to a different Database
26498: Incorrect Date Format
26499: Date Comparison Question
26500: HOW CAN I CREATE A LOOPING STORED PROC
26501: creating a blank verion of the database
26502: Looking for a method
26503: Create temp table with unknown # of columns ahead of time - how ???
26504: ::FN_DBLOG - Retreiving [row data]
26505: CONVERT with char string... again ! :)
26506: Builtin alternatives to UDF?
26507: How to get NTEXT data via SP to vb.net app?
26508: create table => system table
26509: Full text search in image BLOB
26510: Importing Excel file using DTS use of VB package
26511: help
26512: Insert dataset content into a local database table
26513: object_id function returns null
26514: XQuery vs OpenRowset
26515: Send email from SQL Express SP
26516: Manage SQL Server 2000 database from new workstation?
26517: Transport Level Error has occured
26518: stored_procedure_name;1
26519: using IIF or similar function in query
26520: Determining if a column is always a number
26521: Stored procedure - Lock problem
26522: Crystal and Excel - One to Many Relationship
26523: Year only data from daily dates
26524: output to email
26525: Scripting Jobs
26526: Update Lock (Preventing deadlock)
26527: Delete Exists Problem
26528: Recomendations on developing queries?
26529: Finding most recent date?
26530: Update Lock (Preventing deadlock)
26531: How to get a subquery to execute only once?
26532: Is there a good book for MSSQL 2005?
26533: Backup SQL to both TAPE AND DISK
26534: HELP WITH QUERY - I THINK I need a JOIN, not sure
26535: LEFT OUTER JOIN with OR creating strange query plans
26536: Complex Query With MetaTable
26537: Calculating timespans between access log entries
26538: the sequel to changing date to MMDDYYYY
26539: All procedure in a stored procedure not being exec
26540: Row Counts for every user table in a database?
26541: Populating Management Studio's Registered server list
26542: triggers on view.
26543: Help with Self Join
26544: documentation tools
26545: Design Question - Tables/Foreign Keys with Potential Arrays of Dat
26546: making a date field read as MMDDYYYY
26547: xp_sendmail Q:
26548: Can't beat the dynamic sql
26549: How to construct a cell value
26550: Short date format
26551: Indexes and Statistics
26552: EXEC WITH RECOMPILE
26553: SQL2005 Import
26554: Using UNION ALL view worse than just doing it yourself?
26555: T-SQL Question
26556: USE statement don't take a variable
26557: Month-Wise Report.
26558: UPDATE fails
26559: I am querying 4 views using a LEFT OUTER JOIN but my data is not complete.
26560: Distributed transaction
26561: sql statement to sum values in time intervals
26562: What kind of database it is?
26563: Select Specific row?
26564: disable datagrid resize
26565: SQL DYNAMIC
26566: convert string into date
26567: Importing from a text file
26568: Table data transfer from SQL Server to Oracle is very slow
26569: SQL SERVER 7.0 overflow error
26570: How to change collation on a server?
26571: SQL SERVER 2000 Table Description
26572: Restore Remote Server Transaction Log
26573: CLR stored procedure
26574: SQL Help
26575: why is top n faster in this case? (when result<n)
26576: Question about undocumented extended procedures in SQL server 2005
26577: RESTORE holds onto the files
26578: SQL Interview Questions And Answers
26579: Deploying SSIS Package
26580: questions about sql 2005 installation and database mirroring...
26581: Using Stored Procedure in select statement
26582: add column to a existing table.
26583: Case Statement Using Table Alias, Not Possible ...?
26584: How to get Top 1 in Join on Calendar table...?
26585: Reset date to first of month
26586: How to run an insert without returning anything
26587: Need a Suggestion for creating Tables ?
26588: Join two same tables
26589: pass the parameters with more then one insert into statement
26590: <<< Connection Problem with SQL Server + C#.Net on Local Area Network >>>
26591: space at end of WHERE expression
26592: Recursion without a cursor?
26593: EXEC WITH RECOMPILE
26594: Stored Procedure with a Parameter
26595: How to capture changes in a table
26596: Export to CSV/Excel
26597: Using BINARY_CHECKSUM() to conditionaly update in stored procedure
26598: HELP!---Stored Procedure in ASP
26599: Using view
26600: Cross Tab Query