- INSERT-SELECT depending on the Select:ed order
- Finding duplicates - what on earth am I overlooking?
- export a view with double quote delimiter
- Not able to do insert and select clause with aggregate function
- How do I clear out available restore points for MSSQL db's?
- Network integration for fresh install of 2005
- DTS Package Help
- IIS & SQL Server on Same Server - Risks???
- Updating n rows at once - best practice (again)
- FileGroup
- HOW TO GET THE RESULTS IN THE SAME SEQUENCE IN ORACLE 9i AND SQL SERVER 2005?
- How to alter column length of the master table along with the slave table?
- Backup Plan
- Very slow query analyzer
- Unable to connect second computer to SQL Server database
- search-slow
- Dropped lines when NULL ascii value in text file
- Performance gains when INSERTing multiple rows
- Alert Not Being Triggered
- job execution Time
- Import Database
- Sudden DB problems/instability
- Mirroring confusion.
- how to view date dimenstion
- Need help Unable to execute a DTS with SA privilages
- aggregate in multiple table.
- mssql2000 and oracle 10g on same server
- MSSQL notification services to JBoss
- SQL Server entries missing from Start Menu
- Calculating the size of a table in a db
- Problem in Linked Server
- SQL Server 2005 XML Bulk Load Question
- Tracking who is changing what?
- MS exams 70-445 and 70-446.
- T-SQL way to reset Primary Key - need for DTS
- Reporting Services
- BETWEEN clause & <= operators
- EXEC a dynamic create view - quote issue
- sexstatevariable =3 error (was "SQLServer-2000")
- Sort numerically from an alphanumeric column
- double threading a procedure?
- Encrypt/ decrypt network traffic.
- Optimize Full Text Search
- Maint. Plan Help
- SQL Server - View timeout
- Returning an IN clause from a CASE statement
- Set vars in stored proc to first and last day of year
- will varchar automatic convert into datetime ?
- SQL 2005 Pivot operator?
- SQL Problem
- OSQL command - Execute all files in a folder;
- Mass SQL Inserts - performance :-(
- truncate table in linked server linked to (MS Access)
- Moving from Access to a web based approach
- SQL Server 2005 Newbie
- DBCC DBREINDEX fails for table
- perfmon
- DAC not supported.
- howto get avoid Bulk insert data conversion error?
- count characters
- Help with SQL 6.5
- howto pass variable into bulk insert in SP?
- Login failed for user NULL - not trusted...
- MSDE SQL Server Desktop Engine for non Admin
- Publishing Subscriber Model
- In place upgrade issue from 2000 to 2005
- Help with EncryptByKey
- I miss the old Query Analyzer.
- reportinng services datasource change programatically
- SSAS: Processing Cube hangs
- Transaction log backup while database backup is running
- get data
- Snapshot Agent Retried and Failed
- reporting services 2005 graphs
- Simple Date Problem
- Sql 2000 & 2005 ?
- Alter a column to be the table identity column
- Can't INSERT into database's table !
- xp_smtp_sendmail with 64-bit version? (was "DBA")
- Database Level trigger is possible in SQL 2000?
- Storing foreign mails in MSSQL
- SQL2000 Replication,modifying the width of a column
- Encrypt/decrypt MS SQL 2005
- data type conversion in stored procedure
- Number of entry query.
- Database Discussion to change perpective
- SQL Query ignoring null values in joins-- help
- debugging
- Listing procdure/trigger SQL code
- Newbie Questions on Enterprise Manager
- Strange fix
- SQL 2000 issues with windows server 2003
- Compare Two Columns with WildCard
- Any way to make this shorter?
- Change logins for multiple database user groups
- Debugging my sprock
- Seting a variable value from a select statment
- Procedure call between two different SQL SERVER
- Connection trouble after connection has been made??
- SQL2005 outperforms SQL2000? Its over 4 times slower...
- Database Crash
- Grant server role to a user for a particular job
- indexed view utilization
- Restore Database
- Create (U)SP in database on linked server
- Pageiolatch, my nightmare returns
- SQL Date Range Query
- SQLServer Driver: the statement has been terminated
- Urgent!: Upgade MSDE 2000 to Sql Server Express - Authentication issue
- What is sql_handle?
- Time
- Text export within a TEXT datatype
- Script
- DataBase Log error.
- Embedded Database or runtime solution
- dts dynamic query & automap columns question
- SQL 2k backend Access 2002 frontend - random 'object invalid or no longer set'
- find templates for global or system functions and sp in 05
- Changing SQL Server Logon Config.
- Get Privledge listing by ROLE
- excel to mssql
- Can query result be mailed with sp_send_cdosysmail?
- Column Count Percentage of Not Null fields
- Sequential Numbering problem
- Insert into?
- Problems formatting my table...
- Insert and Update a Table in Single Web Page
- HELP not trusted with PERMISSION_SET = EXTERNAL_ACCESS
- xp_cmdshell to delete files
- To DB/SQL teachers: A wrong query on Northwind DB discussion
- [How do I...?] append data without logging?
- Transpose Data Using SQL
- Possible to specifying a list as a parameter to a stored procedure ?
- Nightmare query upgrade from Access
- Finding the Expiration Date
- Server specification advice needed...
- 2 structural questions for picking field type
- I need to kick out .XLS files but do not want DTS
- DTS Problem
- String Concatenation using CURSORs
- Backups not deleted.
- Using a CASE Statement within a Select Query
- Find Consecutive Occurrences
- SQL Server 2000 - Proper Backup Procedures
- backup of SQL Server 2000 loading to 2005
- why SP return SQLException when no data return ?
- SP with list of tables and dependency depth...
- Running total in SQL
- Execute SP on linked server?
- Get Unique Values in a group statement
- Alternative for INSERT INTO # - EXEC construction?
- Find column name and datatype of a given table
- New install - replication test takes 14 seconds
- log file sizes for all databases
- Why is Enterprise Mgr so slow when...
- can we have temporary table in store procedure when using BCP ?
- Conflict in equal-to-operation
- Getting "DB_E_ERRORSINCOMMAND" even when execute is successful
- Reporting Services - Row Level Security
- Performance comparison between VARCHAR and CLOB?
- A simple group by query seems Impossible
- BCP problem
- Number of pages
- Arithmetic overflow error when doing outer joins
- using sql to output xml - generating error
- MSSQL Database Server Expired !
- HOWTO drop temporary table ?
- JOINing... but not with the multiple rows thing.
- Connection of SQL server 2000 with ASP in IIS6.0
- SELECT COUNT of DISTINCT
- allocating rows in a table to multiple users
- Merge replication - Best Pract.
- Linking a text file to SQL Server
- system runs slow
- is this call inner join as well ?
- 'last' is not a recognised function name
- why using One-to-One relationship
- Help me to understand this SQL sentence
- select from 3 tables
- scale of money data type in output file
- SQL Server Error 18456
- Multiple connection type query
- Scripting a maintenance plan
- how to change password
- Transfer Data to hostserver MSSQL-2000
- OLAP security
- Insert Statement Help
- Automatic Job Monitoring
- SELECT COUNT of MAX (GROUP BY)
- help me out for storing more data
- packagefromtheweb error
- insert from linked oracle server into mssql (was "Urgent requirement- HELP NEEDED!!")
- how to increase size of datatype...
- problem with a view
- Oracle LONG datatype and Reporting Services
- Most efficient FIFO logging.
- Msg 7399 - Out of memory
- Ghost records in SQL 2000
- Problem constructing query to weed out some results...
- Interesting long PAGEIOLATCH_SH wait from VB.NET 2003
- sql statement to get all users of a db, not of the server
- Errors: -2147467259 (80004005)
- Create a table with a field with only Time datatype
- datediff (today - date)
- return 7 col but DISTINCT on 3 col from 2 tables
- is there any open source db tools for MSSQL ?
- MSSQL 2000 Security Settings
- Write sproc recordset into a temp table
- how to output data into file ?
- SQL Server Remote/linked server verification
- Execute sql on multiple objects (DB's or tables)
- grouped by month
- Backing Up databases with Enterprise Manager
- 'Combining' fields
- Backup Job Fails
- Problem with sp and uniqueidentifier
- way to improve SQL skills
- Allowing users to edit database
- T-SQL Help
- SQL Server HELP!
- Dedicaced or shared connection ?
- SQL Server Connection Error
- Previous value retrieval
- Storing files in Image Columns in 2005
- Last Function
- Insert/ Update/ Delete slowness.
- Script to log/record the users who accessed my database
- Changing Careers - Software Developer to Database Developer
- Simplest way to crash a sql server
- DateDiff That Only Counts Working Days
- Transaction Tuning in SQLSserver 2005
- tools sqlserver (alerts) ?
- Record Lock - when is it started ?
- Invalid Handle in MS SQL
- Passing in variable number of parameters to a stored procedure
- to use a dataset or not...
- Access-like Automation in SQL Server 2005?
- Install which version of SQL server 2005?
- About Index And View
- Changing the size of a Varchar Field
- Need Help - UDF SQL 00 to Scalar SQL 05
- ignore errors in SqlServer 2000 (try/catch)
- Memory usage
- Calling SQL 2000 Server SP using JDBC
- DBA's with Certifications
- Problems creating format file.
- newbie question... How to remove NULLs in table
- How to create and retrieve a calculated column
- Account Locked out
- Index - which 1 to choose ?