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