- Key fields
- to give a table lock
- How to remove the commented notes in stored procedure?
- Update Trigger - old value
- Anyone heard of product for sqls called MyDTS?
- Setting up and linking a DSN
- Transact SQL - Does it have the equivalent of FINDONEOF function?
- Error 3219 - Operation is not allowed in this context
- Help with calculating duration time
- What are best option available in market?
- Newbie Question
- no case statement in views + sql 7
- Please help.......Sql problem
- Sql .....Select
- Database Diagrams Problem....
- Referencing other databases in SQL Statements
- How to get Primary key....plz help!!!!
- Multiple Language Database
- Help with "start job" error
- I lost full backup on tape only diff available ?? :(
- MS SQL 6.5 -> 2000
- top 10 query
- Quick Question... How to use Default Values (after allowing NULL)
- import .dat file to SQL 2000
- Logging output in a transaction
- Migrating database
- Delete Duplicate Rows
- Automated Restore
- Near exact matches, help needed
- Load text file in AMERICAN_AMERICA.WE8ISO8859P15 format
- How can I install SS2K with domain account?
- Changing guest password?!!!
- Instanciate SQLXMLBulkLoad object in C#
- How to Populate table from Dropdown List?
- IDENTITY values in a stored procedure
- Differences between 6.5 and 2000 inserts
- Web Page Issue
- T-SQL question
- Has anyone used the ADO Classes written by Carlos Antollini with MSSQL succesfully?
- CASE statement within join
- SQLExecutive fails to start
- Point in Polygon with TSQL
- Please Help Beginners
- Help in SQL procedure
- Error while updating INDEXES
- Replace function not working
- conflict between (cascade) DELETE Trigger and Foreign Key Constrain
- Is it possible to replicate between two *Default instances* ?
- User/Owner issue - MSSQL2000
- Error with SQLOLEDB provider in ms sql distributed transactions.
- Counting Rows
- SQL Server 2000 spids blocking themselves
- Question about DIFFERENTIAL backups
- Time spent returning recordset
- Should my where clause be confusing or NOT???
- HyperThreading with SQL Server 2000
- sp_addlinkedserver Priviledge
- Connect from VB6.0 via ODBCDirect to SQL Server
- Script to Add 'WITH ENCRYPTION' to all SP's, V's and Fn's
- select from table
- "requested conversion is not supported" error in DTS data copy.
- Index Problem?
- SQL view using the CASE try to find the @
- User Roles
- SQL2000 DBA needed for contract in PA
- Resources Usage
- Dynamic file name for Bulk Insert
- Counting Rows that refence another table
- Spread database on more than one file
- High CPU Usage
- How-To Copy SQL Agent Jobs between servers
- SELECT DISTINCT DATE with different time
- SQL Query Syntax to format date fields
- How can i output result to a log file?
- transaction log backup/event 208 from job
- Error in executing a DTS Package from Visual Basic
- Problem restoring a database
- SQL server connectivity issues
- ADP/ADE Permissions Issue
- Querys and duplicated fields
- sp results to text file
- Registering a Custom Conflict Resolver
- Internal SQL Server error.
- set select + variable
- Getting today date in sp?
- Invalid operator for data type.
- setting default value (concatenated string) of column using UDF
- Convert Smalldatetime
- Opendatasource
- Sproc not Executing as expected
- delete w/ foreign key question
- Optimizing/Improving WHERE
- Issues copying data to linked server
- Procedure for Retrieving data from SQL Tables with VBA
- Exec @string
- Cast/Convert value to VB variable
- Copyind data from one database table to other
- Reseed The Identity Column
- Lottery / Allocate Number
- Date ranges overlapping
- Transactional Replication and Deadlock + Suspect Agent Errors for over 80 Databases
- Clients in different domains
- Migration Tools
- Customize ODBC Error Output
- How to run script?
- MySQL limit with start, offset
- Connect to Analysis Manager over HTTPS and non domain account
- Collation Errors
- Insufficient Memory Error
- Cannot connect with ODBC using TCP/IP??
- Copy info from one table two another with conditions
- Converting sql statement to oracle
- Query Would Run For Ever - No Clue
- Pointing my new .ADP file to my new SQL Server DB
- run sql script at a specific time
- SQL server not listening for TCP/IP client connections
- T_sql
- Data missing at subscriber
- Packages related with its jobs...
- date replacing in SELECT statement
- SQLServer declare new variable based on another variables value
- Working with Trees and XML...
- Windows Server configuration for 300 GB DB
- Updating to ADO Recordset
- Import specific XLS cells from dynamic filename
- How to tell SQL Server to use the default constraint name when adding one?
- help
- Loop through all tables and columns
- Use a vriable into a FROM Clause in SQL.
- Rtrim
- Error -2147217887 - Data Provider could not be initialized
- Reseed the identity Column with Trigger.
- SQL server problem...
- SQL Server Data Synchronization
- Strange Fatal in Restoring database please help
- SQL 6.5 Collation Sequence Display
- sql server 2000 point in time rollback?
- Scheduled Job permissions question
- Capturing Data Type Mismatch
- DR Server using replication
- Old & New values for my Activity Log ??
- function performance question
- ANSI Questions
- ASP + reporting services
- Merge Replication Questions
- Cursor problem
- SQL Cluster
- How To Execute An Excel File Within DTS?
- real easy newby Q: SQL server
- SQLServer 7 x SP4 x Cluster issues
- Kicking off replication agents with Script
- password encryption
- OSQL Performance Problem
- how to migrate Oracle Applications 11.03/Oracle 8.05 to navision 4.0/ms sqlserver
- Newbie backup question
- annoying SQL Error msg - "INTRA-QUERY"
- How to extract only 1 record for each staff?
- Column Alias in views
- Generating script for existing sql jobs
- SCC Subversion Addon
- Master Server MSX/TSX Setup...
- ouput of difference in two Strings
- Model DB problem..
- Import data from text to MS SQL Server. !!! Need Help!!!
- DML against remote tables (MSSQL to DB2)
- Jobs are here
- Attempt to delete member that is in use
- stored procedure?
- Simplifying characters for comparison
- NOLOCK on views
- Collation Errors
- return text to chosen character
- Execute Multiple SQL statements in Stored Proc
- dba interview tech question
- Connecting to MSDE
- return multiple rows into one single string
- Export Database Users
- Sum with Case
- get top 2
- memory configuration on cluster
- Open Encrypted Stored Procedure
- deadfully slow cursor?
- shrink + remove datafile
- BCP template using quoted text qualifiers
- Problem Creating One-To-Many Relationship
- Identity column question
- distributed transaction error - help urgent
- remove and replace accents function
- Database Tables
- need help creating outer join on multiple tables
- Flush query cache
- stmt text from Profiler
- SQL Server SP4
- SQL Code control
- Left join not returning rows
- DB Maintenance Job not running
- Sync Active Directory
- What is quickest way to copy a table...
- INSERT into TEXT is Truncating
- Monitoring the db size
- want to rename the displayed field name
- Not Unique
- T-sql
- Automate "Week Ending" Date
- unallowed on 2 columns
- MySQL to SQL Server - query migration
- SQL Server slow
- Triggers and .NET application
- create table permission
- Did anyone get this error on a backup job?!
- Running SQL Server 2000 and 2005 on the same computer
- Data Type and Length in SQL Server
- Migrating MySQL to SQL server
- Fetching UTF8 characters from SQL Server 2k
- Store Multiple Values in a Single Value
- Version handling of procedures?
- Creating Duplicate Databases Daily
- Distinct Query
- Copy the table structure
- Structure changes to replicated databases.
- Invalid parameter binding
- job schedule information
- DTS package and nested OPENQUERY's??
- SQL Server 2000 EM hangs when accessing specific db
- how to set the default value
- Script samples for SQL Server 2000??
- Monitoring SQL Server
- Login failed for user '(null)'
- How to create a linked server to MySQL from MsSQL?
- Duplicates
- Linked Table to Access
- Emergency in Bulk Insert
- Analysis Services - MAX Function
- Unexpected error when open DTS
- Subscription data are deleted...
- alter table without data type
- Query in memory
- chart problems
- Maintaing a connection across pages (Persistent)
- Can I split a field based on a character?
- Link SQL Server to MS Access frontend
- Function or SP for date conversion
- HELP ADODB.Command error '800a0d5d'
- Stopping a stored procedure
- how to write set-based SQL instead of cursor
- Trim to space
- how to copy file from server to pc
- frappr
- Visual Web Developer Edition Express 2005
- Need DTS/VBScript guru