- queries Vs Stored Procs (6 replies)
- Thinking about code or SP (15 replies)
- Second call: third edition of SQL FOR SMARTIES (0 replies)
- Versioning a database (5 replies)
- Was it too much to ask ? (1 replies)
- Flipping a boolean value (2 replies)
- Problem with View (10 replies)
- Help with a trigger (or procedure) (3 replies)
- trigger won't fire when update table (with commit) used within stored procedure (3 replies)
- Simple Bulk Insert Problem (7 replies)
- Parallelism algorithm (9 replies)
- Tsunami (1 replies)
- MS SQL Server 2000 and MS JDBC SQL Server driver problems. (Connection timed out, followed by Error establishing socket) (2 replies)
- processor doesn't leave the 100% (4 replies)
- TEXT data type blues (4 replies)
- ALTER IDENTITY setting... (5 replies)
- altering a column of a table (2 replies)
- Purging rows (3 replies)
- xp_sendmail in trigger from asp page -error (3 replies)
- Anyway to copy DTS's and Jobs? (5 replies)
- Server Memory (3 replies)
- How do I create a list of fields and data types in a table? (1 replies)
- Spaces in sqlmaint command? (1 replies)
- A lot of lockings and connections to SQL Server. Is it normal or bad? (5 replies)
- Sql Server Queue? (8 replies)
- FoxFro database (1 replies)
- How to send a message to the connected users with SQL-DMO? (4 replies)
- Storing Employee details (6 replies)
- Between (2 replies)
- Formatting XML Output (0 replies)
- SQL - Combine row values into one cell (1 replies)
- format sql output to suppress repeating value (12 replies)
- SQL server Memory question (6 replies)
- Date section (6 replies)
- Nested Transaction (10 replies)
- How to increase max memory in sp_configure ? (2 replies)
- DTS Conditional WorkFlow. (0 replies)
- Removing RTF formatting from Text field via TSQL (2 replies)
- help with ambiguous column name reference (4 replies)
- sysprocesses table in Master db (2 replies)
- Syntax to calculate hierarchy (ParentID) (10 replies)
- Cascading parameters work but no detail displays (3 replies)
- Return a decimal (2 replies)
- Executing SP freezes other clients (2 replies)
- Debugging w/Windows XP SP2 (0 replies)
- Programmatically building a database on SQL Server 2000? (7 replies)
- SQL Server and full text searching (1 replies)
- Filter records (2 replies)
- abour sql server 2005 news group (2 replies)
- Can I do such approach by using SP (1 replies)
- Copying a Database from SQL 7 to SQL 2000? (3 replies)
- SUM and MAX (2 replies)
- xp_sendmail how to get rid of this line ----------- in results (1 replies)
- connect to sql server (2 replies)
- Scalar Functions in Group By Clause returning invalid values (8 replies)
- Computed column in the result of a table-valued UDF (1 replies)
- Temporary results used by SP (7 replies)
- how to version check (5 replies)
- DayeAd Issue (1 replies)
- Dual usage of a openquery in a select statemnet (4 replies)
- How to get script my jobs description in T-SQL ? (2 replies)
- Table variable or subquery? (7 replies)
- check the SP syntax (2 replies)
- Queryable Partitioned View (6 replies)
- Copying rows into the same table (4 replies)
- Error Trigger (2 replies)
- Fixed and Floating Point types (2 replies)
- Database Paging ... (12 replies)
- How to syncronize two tables? (2 replies)
- how to catch a @@error from openquery linking to db2 table (9 replies)
- SQL Server Maintenance Plan problems (0 replies)
- Trigger to send mail (2 replies)
- Offsetting again (18 replies)
- Parsing a string into multiple lines (6 replies)
- need help on complex query (1 replies)
- Pros and Cons of SQL 2005 vs SQL 2000 (1 replies)
- Deadlock on delete records from partitioned view (3 replies)
- Related Records in CSV File Import (2 replies)
- UPDATE permission denied for db_owner (5 replies)
- Copy identity key in new record in related table. (6 replies)
- Using Oracle Ref Cursors in a DTS Package (1 replies)
- Last TSQL Command Batch view (2 replies)
- Table Storage Internals (1 replies)
- Syntax for renaming tables (3 replies)
- dbcc inputpuffer permision (4 replies)
- Puzzle: dateadd workdays only (8 replies)
- Licensing for the web? (4 replies)
- Query Help (3 replies)
- Relation between sysprocesses and syscacheobjects (7 replies)
- Creating a wrapper Stored Procedure to handle multiple recordsets (1 replies)
- REPLACE function doesn't work (14 replies)
- display row(s) affected (1 replies)
- Ok - so where to buy? (2 replies)
- Local Packages and Meta Data Services Packages - differences? (1 replies)
- analog to SQL 2005 recursive query (1 replies)
- Query question (6 replies)
- Unique Records (9 replies)
- find a record in several tables (4 replies)
- Backing up SQL Server (5 replies)
- Getting proper error message at compile time if a table doesn't ex (3 replies)
- How Would a Pro Do This? (6 replies)
- What wrong w/ SP (1 replies)
- Date Math Error (3 replies)
- Reporting services question (1 replies)
- DELETE Rows Ignoring Foreign Key Constraints? (5 replies)
- Problem in SP (1 replies)
- back up database (1 replies)
- xp_sendmail - my message doesn't appear if concatinated (3 replies)
- Query Timeout problem with ASP.Net and SQL server 2000 (0 replies)
- trigger for insert or update (3 replies)
- INT ? (2 replies)
- ' causing ADO error. (3 replies)
- Date's (3 replies)
- Select TOP with parameter (4 replies)
- Calling an SP recursively to generate a String (1 replies)
- Hits report WITH 0 value dates (5 replies)
- How to improve this.. (1 replies)
- How to catch that error? (4 replies)
- Trigger holding up insert (3 replies)
- Combing results from two queries into one line of a recordset (2 replies)
- Recreating database on production machine? (3 replies)
- Get Date from Datetime (15 replies)
- PROBLEM WITH TRANSACTIONS (7 replies)
- Stored Procedure for each element returned from SELECT (5 replies)
- MAXDOP server setting impact test results. (3 replies)
- Restoring User Rights? (1 replies)
- Trigger Problem (1 replies)
- Stored procedure dataset name change (2 replies)
- moving data from one field to another (2 replies)
- GetStoredProcedurePermissions(Username) (1 replies)
- Removing Leading Zeros (3 replies)
- Re: Database state (0 replies)
- Latest Record (5 replies)
- "Generate Script" using code (2 replies)
- Remove commas (8 replies)
- Help! Crosstab Query (6 replies)
- SUB-SELECT Nightmares! (3 replies)
- Where Clause Syntax Error (8 replies)
- SQL Server 2000 (64-bit) (2 replies)
- Looking to pad numbers with zeros such as 001, 049, etc. in SQL Se (2 replies)
- Using UNION (2 replies)
- Using a calculation in Order By (6 replies)
- EDI import (2 replies)
- Converting seconds to HHMMSS (5 replies)
- Violation of UNIQUE KEY (7 replies)
- vbscript inside a jobstep (1 replies)
- Insert row question (6 replies)
- Best way to keep track of SQL server modifications (3 replies)
- Isolation Level (4 replies)
- newbie, @@error does not seem to work (2 replies)
- Find a duplicated record in a table (5 replies)
- What is N? (3 replies)
- why is query sorted. (9 replies)
- SQL Setup and Firewall (3 replies)
- DatePart(week, date()) problem (2 replies)
- limiting IP numbers (4 replies)
- Stored procedure compile time(performance tuning) (7 replies)
- Is this possible by set operation only? (6 replies)
- Create PDF on Fly in SQL (1 replies)
- Creating PDF from SQL (3 replies)
- ROT13 (3 replies)
- SQL SERVER 2005 ASP 3.0 (1 replies)
- Re: How to create a Pivot table like the following (0 replies)
- SQL Server linked server connections (0 replies)
- ODBC error 7410 (42000) Remote access not allowed for Windows NT user activated by SETUSER. (0 replies)
- SQL job failed (general network error) (0 replies)
- Merging Multiple Related records into single return from select (2 replies)
- SQLDMO, sprocs and parameters (1 replies)
- xp_sendmail - should domain user name be same as mail User Id (2 replies)
- Stored procedure to return record set (6 replies)
- Question about delete query (4 replies)
- ARITHABORT OFF Not working in DTS (2 replies)
- Dynamic Server Reference in T-SQL (9 replies)
- Thoughts - Saving Word documents in SQL Server? (4 replies)
- Convert 2000 script to version 7 (1 replies)
- Using temp tables (4 replies)
- Re: How can I get the current project / application path? (2 replies)
- DTS Run - spaces in dts names (8 replies)
- Help with performance of sql construct (5 replies)
- Surrogate Key (16 replies)
- Copy complete tables - What is the best pattern? (9 replies)
- reduce physical memory usage by updating ntext field (5 replies)
- Aggregating strings (9 replies)
- alter tables add 365 columns (23 replies)
- Anyway to Make Query More Efficient? (4 replies)
- Procedures (6 replies)
- Problem with NULL-- (5 replies)
- Latest Record (again) (3 replies)
- Crosstab query (3 replies)
- Continuous varchar data (11 replies)
- Update question (6 replies)
- SP for list of table dependencies (3 replies)
- Update question (5 replies)
- Basic DTS Transformation Problem - Need Help (1 replies)
- Problem Transact-SQL Statement (3 replies)
- how to select month and year from a smalldatetime column (4 replies)
- not null sp params (5 replies)
- converting ntext to image datatype (4 replies)
- 8000 character datatype limit (3 replies)
- How to get the return code backf rom the stored procedure. (8 replies)
- SQLDMO.Application against remote computer (0 replies)
- Unique Index and Primary Key - bits - confused (4 replies)
- preferred syntax for aliases (8 replies)
- stored procedure vs its equivalent SQL statement (3 replies)
- updating data from different server. (1 replies)
- variable used as column name in select (7 replies)
- view w/ trigger and set operations (2 replies)
- How can I apply a stored procedure to each column in a table. (1 replies)
- Unexpected result on Between dates query (5 replies)
- Recommended Fill Factor (7 replies)
- weird symbol (4 replies)
- flag "duplicates" (4 replies)
- how to verify membership in db_owner group... (7 replies)
- lookup description (5 replies)
- Do You Still 'Mind'? (4 replies)
- Unique Index and Primary Key - bits - confused (0 replies)
- How to send to log file? (1 replies)
- sp_add_jobserver - Unable to specify Job Server (0 replies)
- truncate log file (6 replies)
- General XML SQLExppress Web question (0 replies)
- Cast varchar(8000) to text (2 replies)
- help me on this audit trail trigger (7 replies)
- SQL Server Query Analyzer faster than ADO.Net SQL Data Provider (5 replies)
- Tracking BLOB field changes (2 replies)
- odbc bcp api vs BCP utility (7 replies)
- BCP/Bulk Insert from Unix machine (4 replies)
- how to redirect the result from the query into the file (1 replies)
- Why truncate (4 replies)
- create text file from a stored procedure (1 replies)
- Stored Procedure/UDF help (1 replies)
- OLE DB Provider - how tell to not use cursor internally for join (2 replies)
- Unique Index and Primary Key - bits - confused (1 replies)
- Print? (6 replies)
- Crosstab queries and report queries (1 replies)
- Access mulitple databases in a single query (1 replies)
- SCOPE_IDENTITY vs Transaction scoped Select @@Identity (5 replies)
- Insert data into database (2 replies)
- User ID and Password in the Query (2 replies)
- Foreign Key Question (7 replies)
- Loss of performance (SQL Server ya pervs!) (1 replies)
- Is there an API for reading the Transaction Logs (1 replies)
- UTF-8 for SQL Server. (2 replies)
- MSDE and vb.net (1 replies)
- RAID advice (1 replies)
- DEFAULT doesn't work in COALESCE? (16 replies)
- How to check stored proc dependency (3 replies)
- ORDER by when aggregate grouping (3 replies)
- Acessing Multiple SQL servers (1 replies)
- DMO & Maintenance Plans (3 replies)
- Truncate SQL server log (1 replies)