- BCP fun and games
- foreing keys referencing same primay key
- getting time out errors in Session database in SQL 2005
- Freelance work
- Help with microsoft indexer w/ sql server 2005
- help on xml schema
- facing problem in changing the PATH of data/Log file
- names and alternate names
- ID management on Offline and online database
- Exception handling on linked server
- Query Cache is not working
- SSIS Script Task
- SQL Server Express - user authentication - cached profiles
- Help with SELECT and DISTINCT
- Insert Query Sql 2005
- CSV data file from SQL Server 2000 table - bcp in batch file
- Advice on Structing
- Help with Query
- DTS, SSIS a rose by any other name...
- Problem with VARCHAR(MAX) datatype when using {SQL Native Client} ODBC Driver
- Dynamic Cursor
- BCP and the XML datatype
- Long running transactions
- Update Query Problem.
- MS-SQL Performance issue
- Please Help On This Query
- Top 50 CPU intensive queries, what's wrong with this query?
- Cartesian Product
- How to filter on ObjectName in 2005?
- Sorting out Query and Database
- Equivalent in SQL server.
- problem with this query
- Grant Existing User Access to a new DB
- Put all data in one field but only limit to 2?
- difference in system views
- Conditional Execute
- FROM clause + TABLEs + VIEWs
- Counting data within each row
- 3 rows(Sysindexes) on 1 index - builds invalid commands
- users do not appear in sys.sysusers
- Is VIRUS attack possible on SQL-Data ?
- Owner of Stored Procedure
- Simple Order Balancer
- Trigger code
- Uncommittable transaction is detected at the end of the batch. Transaction Rollback
- Sql Data Recovery
- VB Function to SQL function help
- query
- Labor Report - $ per hour
- Duplicate Records
- SQL Server 2005 Very very slow compared to MS Access
- How To Extract Domain Name From An Email Address??
- NetLibs and TCP/IP Protocol
- AS/400 Linked Server
- Unable to connect to sql server on my laptop
- Multi-threaded queries, possible?
- What is SQLRun?
- Runtime Error 52; Bad File Name
- Need Help Creating User Defined Fields
- Web page or site on Report Services
- Ms Sql Server 2005
- trigger to send mail
- select first row per group
- how to Update One table from Multiple Tables?
- Where-clause on xml column
- SQL Server Cursor
- Restore Database
- Selecting a random row from a table
- Clustered index on a non-primary key
- Is There a Way to Calculate An Average Like This?
- SQL Server 2000 and Clustering
- migrating from sql 2000 to sql 2008
- database structure
- SELECT string truncation problem!
- import txt file with null value in the file
- HowTo Buisness Rule-MultiRow GroupTotal=Constant
- Totals not adding up
- Parent/Child relationship in the same table for multiple tables?
- How to call a stored procedure from a DTS package
- error - could not access network location during sql server 2005 Installation
- total rows with group by
- Change to sDSNDir or stay with dsndir ?
- select max question
- Exclude NULL values for "conditional" SELECT query
- Creating a database of audio files
- A question to a DATAFLEX guru..
- Temporary tables with Inserts
- A little query problem help
- Recover Deleted Records
- Alter Index (ReOrgs)
- mismatched fields in a view
- a trick for something special
- Adding length to varchar column fails
- Linked server of Sql Server to Oracle issue
- Why SQL server mgmt studio cannot keep username and password?
- Hide Other Databases
- Problems turning excel macro into activeX script
- Physical index fragmentation
- MS SQL 2000 Enterprise Manager - Can't create a local database
- Find all Views and SP that reference a column?
- Execute EXE from DTS package on Remote Server
- Help Required - "[Shared Memory]ConnectionOpen (Connect())" problem.
- InValid object name 'tableA'
- How to log procedure calls within procedure in SQL profiler -
- BOL is Wrong?
- PWDCOMAPRE issue with SQL Server 2005
- link server query issue
- [ASK] -What is different??
- Stored procedure to insert into different tables
- Authentication in Cross Domain
- Must declare the scalar variable "@MyDate".
- Merge Replication Job Fail
- Error trapping in MS SQL 2000 DTS package
- Using COUNT(DISTINCT.. inside SUM(CASE..
- Indexing on Insert Query
- Operating System Command (CmdExec) in SQL Server????
- SQL 2008 Script to Script Database
- Query Optimization
- How to get the scripts of Procedure
- Overwrite verses Append
- SQL Server Cluster Failing on One Node
- best way to delete rows
- Installation guide
- Help understanding MAXDOP Setting
- systypes gone nuts
- Not sure about the Query to get the right results
- MSDE: Backup file getting too long
- Retreival of data from sql server
- Normalized database
- Cast and convert to DATETIME type
- i could not find the create database options
- Finding duplicates
- get 2 year from the current datetime
- SQL Server Indexing again
- resetting @@Rowcount to zero after a sql statement
- How I Merge & Group This data
- Feedback on trigger.
- SSIS Package
- retrieve data from db with combobox selected value
- SQL Problem Please Help
- Sending Email from SQL Server 2000?
- Maintenance Plans will not run: Error loading task
- trying to graph Sales over 12 months
- Stored Procedure message to user.
- SQL error 566 shutting down SQL server
- SQL SERVER 2005 ( Piecemeal Restore Scenarios )
- Conditional join
- Research Project Opinion
- All sp not visible in SSMS 2008 project explorer
- The LSN (0:0:0) passed to log scan in database
- BULK INSERT error.
- Tail Log Backups
- Reporting Services Scheduling by the Hour
- Can I use 'CASE' in an aggregate query ?
- MSSQL 2005 - Slow INNER JOINs on VIEWs
- Database Role Migration
- Question regarding bulk insert with format file
- Multiple Select Statement in one stored procedures
- SQL Server 2005 Job schedule
- Help w/ sql query
- Suggestions for archiving data and decreasing db size
- stop restore
- stored procedure with linked server
- Share your ETL approach
- use of Enterprise ID's
- Stored Procedures -Mutiple customerids and Output File
- SQL deleting outside an entry
- Error 9003: The LSN passed to log scan in database is invalid
- replication from sql server 2005 to mysql
- RowLock blocking other rows
- Performance/Benchmark application other than Perfmon?
- Logs for table updates
- Looking for a statistic (report) 4 number of users hitting database? apart sp_who2
- Why it doesn't print result ?
- Rewriting an assertion using EXCEPT
- create database (was "I need help!!!")
- Object scripting 'SQLDMO invalid database-object type' error
- How can I change decimal length from 9 to (16,3)
- sql server with PCI compliance
- SQL Syntax Help
- synchronize mysql and ms sql
- MKS Toolkit anyone
- sql express 2008
- Looking for SQL light?
- Can You Setup Database Mail to Notify Multiple Users?
- Issue with Microsoft SQL Server Migration Assistant for Access
- bcp issue on 2005
- Can't open any tables
- update end date on based on next start date
- restore table
- Upgrade from 2000 to 2005 Express made my diagram inaccessible...
- Calculate max intersects between two fields in resultset?
- MS SQL 2005 Connection String
- Encrypting password column in T-SQL?
- SQL 2000 - AWE and "user application space"
- Where !=
- Vendors Remote Access to Sql
- Comma delimited string handling
- sql server indexing
- Transaction Log on a separate disk?
- Error while displaying a xml string
- Reporting Services from SSIS?
- split a column with commas between
- SQL server 2000 performance problem
- Access to all databases on a Server
- Converting String to Date Format
- Help on my SQL Query for school
- How to search date colomb by todays date
- What Join type?
- Parse words from string matching pattern
- Table Backup
- How to open a SSIS package stored on the Server
- Printing summarized numbers in Reporting Services
- Unable to re-install SQL 2005
- Looking for suggestions on multiple table import job.
- IIf Statement converted from Access to SQL Server
- cross tab query
- Insert/Select Statement - How to insert/select incrementing value (bulk insert)
- need sm guidance
- Dynamically Passing Date Value from SQL Server to Oracle Server
- simple case in where clause
- unicode, is it just me or is this weird?
- Table reindexing in sql server 2000
- Error handling in SQL insert statement
- How to 'Save As' an exisitng Job into a new job
- Mirating job from 2000 to 2005
- Analysis Services repository migration wizard
- Web App logins - Best practice
- Active Directory Script
- Error while uploading data through BCP
- Suspect Database
- Format Date Column to MMDDYYYY Format
- Query Based On System Date
- Concatenate two fields with - between the values.
- MSDB problems during verify
- restore db (SQL 2000)
- How to Extract a View into a Flat File
- Denying access to view SQL
- Insert into table problem...
- Ssis
- Automatically copy database from one server to another
- Strategic Plan for 2009
- Need help with sql query
- Help a noob fix his script.
- Purging Multiple Tables using a reference table
- How to update data?
- OLE/DB provider returned message: Deferred prepare could not be completed
- MS SQL 2000 - DTS Package (insert valid records and skip invalid records)
- Help Needed - DBMail
- Table contains trillion of data got stucked