- help with query
- Numeric overflow . No errors. Insert the wrong number
- How to add a do loop in sql? Thanks a lot!
- IsLogin problem
- List of Logins
- bcpinit problem
- Full Text Search - Ranking Algorithms
- Reindex maintenance plan fails after adding secondary data file
- 16 gig of memory (AWE or WSRM)
- Fastest way to execute aggegate functions on a table?
- How to determine if stor proc parameter is output or input
- Query Analyzer. Align/indent stored procedure script
- Help Needed!!
- importing and archiving
- Need details on Query Profiler
- How do you improve SQL performance over large amount of data?
- Particularly Challenging SQL Problem.
- how do you know indexes have been fragmented?
- How do I write a point-in-time record to another table?
- Capture Returned Value From Exec(@Build) into another variable
- sql query syntax
- Executing a DTS Package using an ASP (VBScript)
- Indexes and File groups
- Need help figuring out SHOWPLAN_TEXT help
- assigning each record to one string
- From excel file into MS SQL server
- JDBC: calling a stored procedure with multiple return values.
- Query joins problem
- Evaluating Lumigent Entegra
- Querying data from multiple views
- Reporting Services security issues
- Table export removes primary key
- Stored procedures and Visual SourceSafe
- Microsoft Exchange to Microsoft SQL Server
- Multiple Deletions From Different Tables in SQL Server Trigger
- database prioritizing
- How to copy Database Structure from one db to another w/o affecting data
- Query timeout problems
- Any easy way to change column length like varchar 30 to varchar 100?
- Any easy way to change column length like varchar 30 to varchar 100?
- Any easy way to change column length like varchar 30 to varchar 100?
- Any easy way to change column length like varchar 30 to varchar 100?
- SQL Server 2000 cannot listen on TCP/IP!
- changing the default value for a column
- Update remote table from local table
- integration betwenn Analysis Manager and GIS applications
- Determine which user has locked a record
- website problem with mySQL data base
- Two questions about SQL Server 6.5
- Running Cognos from SQL
- Disabling Named Pipes
- group by clause query help
- SQL Server Network Utility - where is it?
- SQL instances ports
- CommandText issue - SQL Reporting Services
- Index creation causes error "The conversion of a char data type to a datetime data type resulted..."
- Connecting to Sql Server from Application
- Incrementing or updating a TIMESTAMP field.
- BCP Large Table.
- Slow performance of like operator
- SQL Database design question
- Update Query (Access vs. SQL Server)
- Reporting Services security
- schema extraction for multiple interdependent databases
- Using Visual SourceSafe with Sql Server
- ETL: OLTP -> DATA Store
- ignored words in full text indexing
- Implementing read-write locks
- Poor Performance on Dual Xeon Machine
- How do I reinstall the SQL Server ODBC drivers?
- need help
- How stopping and restarting full text indexing?
- Solved
- Avoid caching image datatype
- How to get the date part of Datetime
- Possible?: Count(*) returned by EXEC
- Connection string OLEDB - SqlServer
- Help with query plez
- Sql Server ODBC applet won't start can't configure problem
- Query problem
- Replication with Triggers
- How To Round With Negative Numbers?
- Third party reindexing utilities
- Create table with 15,000,000 default rows
- Making a Stored Procedure in MS-SQL 2000
- Time Function?
- Can we use details hard coded into exe directly in reports without storing in DB
- Sql Server does not exist or access denied issue again
- Replication issue
- insert double quotes into sql server table
- SQL Using LIKE Command with Subquery
- Triggers and Replication
- RS ASP.Net code
- "organize and view datasets using toad"
- Very small table incredibly slow
- 6GB 2 row table????
- Question about debugging
- organize and view datasets using toad
- Quick question: how do I get the name of the current database?
- Collation problem with SQL 2000
- But the documentation is NOT correct
- Need to change IP address of server
- EXCEPTION_ACCESS_VIOLATION: Odd Error in Event Viewer
- Keywords
- Storing result of EXEC into a variable
- Concatenate String and Pass to FORMSOF?
- Performance problem while using Linked Servers
- Reporting Services
- Transposing?
- Database Administration Survey
- cannot add windows user, cannot delete sql user
- More than one column FOREIGN KEY constraint specified for column
- Manipulating the result set of one stored procedure from another....
- SQL Server Client tools installation
- DTA package handling multiple file formats
- Controlling Data Modification at row level
- Chicken and egg problem: FOREIGN KEY reference to a table that doesn't exist yet
- How to Add a Missing Index to a Table in Merge Replication?
- MSDE Performance Governor - knowing when its kicked in
- Default Stored Procedure Parameters
- SQL 2000 log shipping question
- HELP with SQL Statement...urgent!
- [ monografia Administração [
- Enterprise Manager appears to slow my dial up connection
- Basic SQL Question
- Combine matching multiple rows into one row
- Showing record rows in group by SQL
- Showing record rows in group by SQL
- Query Analyzer. Error : Unable to connect to debugger
- Delete rows from one table using rows from another table
- selecting changed rows only
- Alter table alter column in MSACCESS. How can I do it for a decimal field?
- SQL Server to Generate XML instead of Redendant Query..file open during write problem or job not running...
- linked server from sql 7 to ms access 2000 ... some tables not available - solved
- Linked Server Limit in SQL Server 2000
- Access Data Projects
- Concurrency, have I got this more or less right?
- Simple sort on a table...
- Dependency Info
- SQL precision arithmetic overflow error for numeric and decimal datatypes
- best jdbc 1.0 centric driver for sql server
- XML and Searching
- count rows question
- find out active Sql statements
- Update multiple fields Accross a Join
- Ext. SPs
- SQL -2005
- Multiple Databases and multiple exe for a single solution
- Case Statement Within A Select Where 2 or More Instances Of The Record Exist.
- SQL Server 2005 Beta 2 Transact-SQL Enhancement
- Multiples Instance of SQL server 2000/SQL server 7.0 on Windows server 2003
- Replication - Single Publication versus Multiple Publications
- Help me rid my curse... please.
- optional parameters passed to stored procedure
- Join the Result of xp_logininfo with a table
- Filtered joins
- How do I search for the same criteria in three or more fields in one table?
- Linked Server: WHERE clause not being executed
- URGENT - SERVER CRASH
- How to automatically replicate remote database which is not permanently online
- Stored procedure where clause
- how to report the size of each table in a database?
- Convert Rows to Columns
- Execute a Stored Procedure
- Finding Stored Procs that Ref/Update a column
- Dynamic Sql: Truncate Table: Trap @@ERROR
- Stored Procedure does not appear in the sysobjects table.
- Update / Delete with Joins
- Generating Multi Level nodes in Stored Procedures
- extended character search
- unique key with optional field
- DTS 2005 and quoted table names
- EXCEPTION_ACCESS_VIOLATION
- Finding dashes/hyphens in a column.
- Configuring mail for SQL Server Agent - Problem with Exchange and Outlook on same machine?
- Creating a directory command question
- How To Get Covariance Matrix
- Bit Value
- Get with the program
- Thanks all
- Help with insert into query plz
- Problem using Access 2000 as a front-end to SQL Server 2000 tables
- Query help joining 2 tables
- Index= <th scope="col"> ?
- Export from MSDE
- Rows in a table
- How to stored a stored procedure's results into a table
- Multi processor OS restriction?
- SQL query builder
- Scripting ALTER TABLE
- How to load a Unicode file into the database in the same order as the file order
- revoke permissions TO stored procedure
- Asking the user a question
- Iterating updated fields within a Trigger
- Report Server Subscriptions - Job Owner
- Dynamic evaluation
- crystal reports and Sql Server 2k
- Order By Case Cast Convert Error
- Customize Prompt Message for Stored Procudure
- Assertion Errors:
- Concurrent Access - New Record, Primary Key problem....
- Correct access to TempDB?
- Correct access to TempDB?
- prob with SQL script that work with Date/Time abd boolean
- Enterprise Manager Cannot Display Table Records or Run Query
- performance and locking problems - urget
- Simple Query Question
- Editing table data in Query Analyzer
- char vs. varchar
- Correct access to TempDB?
- MS SQL Reporting Services Server - Activation errors
- Passing control flags to stored procedure
- DTS Package - Append Results to Text File
- Collation problem
- ODBC via Windows authentication
- Connectivity issue - SQLServer not listening on port 1433/ms-sql-s
- Openrowset and mdb -Files
- A query where two tables are linked to the same another table
- sqlserver page
- How do I change the SQL server for Access ADP?
- Tough Date Manipulation Issue.
- Grabbing characters from a string
- Performance of extended stored procedures in SQL Server 2000
- Error 0: Timeout Expired HYT00 when trying to backup DB's
- Error 0: Timeout Expired HYT00 when trying to backup DB's
- Search query between two tables
- Is SQL Server SQL99 Compliant
- Split a column into 2 columns
- Querying date
- Subscriptions not working
- SQL Transpose Table
- Dynamic formulas driven by table
- Transaction across 2 databases?
- Practice test for 70-228
- Computed Column calculations
- SQL Delete prob.
- inserting one query before another
- ReportParameter.ValidValues
- MS Access front end to SQL Server problem passing Form value to Report
- Indexing question
- workstation sees 2 instances of the SQL Server?
- Execute DTS Packages
- SQL Losing Data
- Correct Table Structure - Optional Values
- SQL Server execution plans
- Feasability of storing PDFs and WORD.DOC files in MSSQL?
- DB and Log backup
- Wrapping query batches in a single transaction.
- Querying across databases on same server
- Search All Tables and Replace
- Question about procedures to create procedures in a different database
- Migration Tools For 2005 Express
- Can't unlock records in SQL Server
- Script / Function ... to find difference b/w 2 similar tables
- CREATE INDEX on large table
- tsql Substring question
- SUBSTRING question
- UPDLOCK on a mult-table join
- tsql Substring question
- MSDE 2000A
- how to update a datetime field
- sql server 2000 Table Maintenance
- What is expert SQL knowledge?
- toad for mssql problem
- They're invading my node!
- Deciphering deadlock information..Please help!!
- update versus rebuild
- stored procedures synchronization
- Scary Results
- Local cube with Parent-child dimension
- sp_executesql
- Stored Procedure Reuse
- Join syntax help
- How to include variable in CURSOR SQL Filter clause?
- Data modelling question
- Best way to send email from a stored procedure (dynamically changing paramenters and attachment)
- Bitwise question -
- Troubleshooting SQL Buffer Cache Hit Ratio
- Log File Full Stored Procedure Error
- Mysterious query problem?
- Storing result of EXEC into a variable
- Which collation name to use for a database that store Korean characters?
- A VoIP usergroup
- Optimizator and indexes
- How to find my previous topic??
- Stored Procedure Sebquery as a Paramater
- SQL fails after SP3a has been applied. Slammer?
- Restore SQL master database from a file
- Any Fuzzy Software ( Other than SOUNDEX / NYSIIS )?
- Backing online database table data to local machine
- re-insert / templating records
- looping through results of a OSQL query
- Comparing a column list split to a table.
- Replication - Can not create Publication database
- Troubleshooting needed
- Bad Query?
- Working with MSDE
- Optimal SQL
- Securing local MSDE applications
- Restore of Backup problem
- how to fine a hole in a records?
- SQL NULL or Value
- LoadFromSQLServer won't work......
- querying by date on smalldatetime
- Connecting to SQL Server 2000
- How To Access Visual FoxPro Data from SQL Server ?
- Automatically run a stored procedure at 6am every day?
- Stored Procedures - Help
- enable a trigger
- Unusually High CPU on SQL Server the 2nd day after a reboot.
- An interesting holistic question for the groupmind...
- Sleeping processes take a long time to kill-
- English Query
- Strange datetime conversion error in stored procedure.
- Changing physical SQL Server
- Word Update
- Database Replication
- Database marked as suspect please HELP!
- Large amount of pages for few rows
- Data checking?
- Design Question
- SQL Server 2000 Service Pack 3a installation fails
- Replication(Publisher-Distributer Problem)
- New login cannot retrieve data from db
- Create a database login in the default domain
- New login cannot retreive data from db
- New login cannot retreive data
- Why no access to db table?
- Best way to keep track of SQL Server Changes
- XML output serialized for remote query
- Starting the SQL Service through Enterprise Manager
- Best practice for Data size/Log Size ratio
- Collecting Active Directory dates
- transaction question
- Does the client have to be running IIS??
- Question on generating SQL scripts using Enterprise Manager
- Can't trap sql errors using ADO (DTS ActiveX task)
- Backing up design changes
- Backing up design changes
- Maximum user connections?
- ORIGINAL SIN IN SQL 2005!
- Log Shipping - false alerts, real problem...
- Connection Problem with the Workstation
- Insert Trigger Help
- SQL Agent Job Fails Immediately after Invoked
- Potential issue with DTS and Log Shipping
- Transfer from 2000 to 7.0 - what can be done?
- Checking backup file questions
- How to query for records that have not been replicated
- still not clear
- What happens to Windows Authentication if domain failure occurs?
- Datepart query example help needed or something else??
- Connection Failed
- Is it possible to save and force a plan?
- MDF and LDF files size command
- SQL "Commandments"
- Sql View
- Database Design Question
- Can a stored proc swallow an error
- nocount on problem
- Intensively used function in view needs a minimum and maximum from a table PartII
- problem using ntext data type in OPENXML
- How can I get c# text and use as parameter?
- Any way to easily add this computed column (divide by zero problem)
- securing db access
- SQL Server: Backup/Restore
- ListAvailableSQLServers Problem
- Can't Get Decimal to Show Up!
- Why two different views?
- Why two different views?
- Backing up and restoring SQL Server
- PDF Bookmarks
- t-sql alter table udf help!
- SQL server log file is not shrinked
- Select on large table.
- Second call: third edition of SQL FOR SMARTIES
- executing DTS - DSN error...
- sql server & crystal reports
- ASP COM and database access
- Insert and Update Trigger on same Table
- Releasing resources on the server
- Can I integrate a "reporting services" report into c#.net app?
- HELP! Non-Replicated DB thinks its a Publisher
- Database authorisation problem
- help with error handling
- Getting my finished SQL Reporting Services report in my c# project to view it??
- connection problem - windows 2003 +sql2000
- Query to find what is not there
- why is execution of a storedprocedure in QueryAnalyzer faster thanexecuting this SP as scheduled job?
- Intensively used function in view needs a minimum and maximum from a table
- MSMerge_tombstone cleanup
- List of SQL Server Users
- List of SQL Server Users
- Resources used by UDF
- transactional replication - re-syncing publisher from subscriber after failure
- Help: Update Query with Linked Servers
- Data Recovery SOURCE CODE ( SOURCE CODES of Professional Data Recovery Software )
- not associated with trusted SQL Server problem - windows service
- converting queries from Access2k to MsSql2k
- GWUTIL.DLL
- Q: DTS and global variables
- Need Customer & Sales Database Designed /for Internet Sales Business
- Need Customer & Sales Database Designed /for Internet Sales Business
- Need Customer & Sales Database Designed /for Internet Sales Business
- Need Customer & Sales Database Designed /for Internet Sales Business
- Incorrect Date Conversion - Help Please
- SQL field sep question
- Connecting to MSDE w/read only file?
- Update Versus Append
- Blogs
- Design
- Creating a common table expression--temporary table--using TSQL???
- Q log shipping
- No buffers
- sql server job output file -passing it onto second step
- Reference for Security Nazi's
- move a database
- Database not Shown
- Creating Database in OSQL Error
- Hints
- View Diagram Pane - how save layout after I change it? 2000
- How to correctly propogate data back to the database
- sql server 2000 installation problem
- DB design question - survey system
- Create Database by using OSQL
- SA Password?
- Client/Server Connection
- Execute windows on client machine
- group by clause Query help
- Comparing two sets of data
- Log all connections to a SQL Server
- Classification crosstab query - 2000
- SQL Server 2000 and Windows 2003 SBS
- master db restore
- Convert 1084313300 (Ten Digit) value to Datetime
- osql timeout
- ODBC
- Securing Databases From Porting
- is there a quick way to get a list of roles a user is a member of?
- Modified Date For Stored Procedures
- SQL job and login
- Which one of these SQL Monitoring tool is the best?? Please advise..!
- Order of Joins and Performance
- tempdb and templog - moving
- tempdb and templog - moving
- Changing the day of week in SQL Server 2000
- Porting from oracle to SQL Server
- Running SQL Server 6.5 on Win2K Server??
- SQL Client & Licensing
- Help with Stored Procedure
- DTS data from MS SQL 2000 to DB2 7.1 on OS/390
- DTS data from MS SQL 2000 to DB2 7.1 on OS/390
- DTS data from MS SQL 2000 to DB2 7.1 on OS/390
- Fix: T-SQL Debugger in Query Analyzer and Visual Studio breaks when Windows XP Service Pack 2 is applied
- timeouts!!
- where to find comments property
- Merge Replication
- How does adding constraints affect performance?
- SQL Server Express setup snafu
- Truncate Database Statement help
- MSDE 2000 On Windows 98 SE Installation
- SQL Server 2000 Cannot Restore
- Some comments on DTS package
- alter column fails due to statistics
- SQL-DMO: SQL Server Agent properties - Mail session - Mail profile
- Help with SQL stored procedure
- Mutually exclusive counts on ordered queries
- sqlmaint.exe failed when backup db
- Install Enterprise manager without install sql server
- use function from asp file in stored procedure
- Altering table & trans. replication
- "Microsoft SQL Servers" not showing in Computer Management.
- DAO and SQL server
- DTS Text Import Question
- secret text messaging for a DBMS?
- How to use BETWEEN with custom-ordered values
- problems running memory intensive queries
- Lost sysadmin, but I still have it???
- SQL View/Table question
- Designing a database within a database... design question storing data...
- SQL Analyzer
- Identity columns
- UML and SQL
- ExecuteWithResultsAndMessage2 SQL-DMO and perl
- Can you filter SELECT results?
- DELETE problem
- I want to transfer ONLY new records AND update any modified records from Oracle into SQL Server using DTS
- How to customize view of SQL Server Enterprise Manager on startup?
- Execution of script at login
- Job failure notifications for non-administrative users
- WHERE
- import multiple accessfiles in dts
- Access migration to SQL Server
- Why xp_sendmail Doesn't Work With Hotmail?
- Constraint question
- Connecting to online database using local Enterprise Manager
- MySQL vs SQL Server?
- export data without trailing spaces
- Tricky Case Sensitive Query on SQL7
- Obtaining the version of ADO installed on XP
- How do i replicate data from MySQL into SQL-Server
- Let your customer find fast and easy all text he searches !
- How to Identify user defined data types
- insufficient memory to run this query
- sp_who2 displays funky CPU usage on pentium4 server
- Easy to Say but hard to implement
- Easy to Say but hard to implement
- Ascending and count help
- Query Analyzer locks up!
- Task/transaction token by logging
- Is there any third party s/w that lists SQL servers in a network and query more info about the server?
- Is there any third party s/w that lists SQL servers in a network and query more info about the server?
- SQL Triggers: Transfer Data from SQL Server 2000 to Visual FoxPro DBase
- Slow Insert - Help?
- Slow Insert - Help?
- Help with Slow INSERT - MS SQL 2000 - Help?!?
- Cluster /AWE / 3GB Switch /Memory Usage
- How to get SQL Server Info(Version/SP Version/Server Statistics) from a network.
- SQL Function to convert RTF to plain text
- could not open the file for reading. close any other application that may be locking the file.
- Data modeling question
- Replication
- Stored procedure performance mystery
- Select Into works, Create table does not
- Runtime Error: [Microsoft][ODBC SQL Server Driver]Invalid time format
- SQL Clusters and Analysis Services DSO
- Pratical size of a SQL Server database
- Adding DEFAULT columns
- password in a Table
- Distributed Transaction takes far too long
- database recovery
- SQL crosstab results in numbers on the 'diagonal'
- Query for percentage of a SUM
- sorting problem with linked server
- Running out of Sql Connections
- Instead of Delete in replication
- DTS file name to include System Date/Time
- Possible DTS File Import Bug
- Merge two rows in the same table
- Declare Variable Dynamically
- SQL Reporting Services hyperlink question
- Help with NOT EXISTS query
- Fastest method to copy a file across network?
- Include column Description with list of table properties
- Cursors and dynamic SQL
- SQL Server 2000 service not running in local machine
- Updating Column Data on the Fly?
- simple explanation please
- RETURNING APP CONTROL TO THE USER
- Remote server connection