- Performance problem while using Linked Servers
- Reporting Services
- Transposing?
- cannot add windows user, cannot delete sql user
- Database Administration Survey
- 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
- SQL 2000 log shipping question
- Default Stored Procedure Parameters
- 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
- DTS Package - Append Results to Text File
- Passing control flags to stored procedure
- 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
- Feasability of storing PDFs and WORD.DOC files in MSSQL?
- SQL Server execution plans
- DB and Log backup
- Wrapping query batches in a single transaction.
- Querying across databases on same server
- Search All Tables and Replace
- Migration Tools For 2005 Express
- Question about procedures to create procedures in a different database
- 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
- A VoIP usergroup
- Which collation name to use for a database that store Korean characters?
- 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
- ORIGINAL SIN IN SQL 2005!
- Maximum user connections?
- 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
- SQL server log file is not shrinked
- t-sql alter table udf help!
- 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
- MySQL vs SQL Server?
- Connecting to online database using local Enterprise Manager
- export data without trailing spaces
- Tricky Case Sensitive Query on SQL7
- Obtaining the version of ADO installed on XP
- Let your customer find fast and easy all text he searches !
- How do i replicate data from MySQL into SQL-Server
- 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?
- Slow Insert - Help?
- SQL Triggers: Transfer Data from SQL Server 2000 to Visual FoxPro DBase
- Slow Insert - Help?
- Help with Slow INSERT - MS SQL 2000 - Help?!?
- How to get SQL Server Info(Version/SP Version/Server Statistics) from a network.
- Cluster /AWE / 3GB Switch /Memory Usage
- 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
- migrate data from Bull GCOS7 to Windows
- create relationship with tables in a linked server
- Trigger performance
- Help with a Join - join only first or max?
- Need help with Avg and decimal
- Cannot connect to Server through Visual Studio .NET and Query Analyzer
- Calling sp_helptext from ASPNET
- Optimal configuration for report generator
- Solution to: Ad hoc access to OLE DB provider has been denied. You must access this provider through a linked server
- SP3a and strong password problem
- Need help with count
- Continuation of long SQL statement syntax
- Selecting records where multiple foreign keys are a certain value
- dtsrun to start a package - cannot find xp_cmdshell
- Update only one record
- Incorrect syntax near the keyword 'Declare'.
- LIKE N'@numericvarhere%'
- Exporting sql table into csv format retaining the column names
- returning string length
- Fatal System Error
- XML export
- Connecting sql 2000 sp3 with asp
- Restore SQL hanging
- specify a non-linear order by
- Marking a table as a System Table
- Upgrade Client connectiviity tools on client machines
- Textfields show up with NULL but are NOT empty
- Query Analyzer vs Isqlw different Format
- Recover A Database From Another Hard Disk With A Corrupted Windows 2000 Installation.
- Query to group sequential items
- Filtering duplicate ID's?
- Upgrade Client connectiviity tools on client machines
- sql performance monitoring
- staff ratios
- Query in bat file?
- Triggers Won't Script
- Connect to remote server
- SQL Server Agent overhead / sysperfinfo
- Primary Key / Referntial Integrity Question
- Repost : Using forms with Sql Server
- SQL Server Reporting Services
- Different execution plans - same data, same server
- Concurrency (recap and idea).....
- Error while performing a Distributed Transaction on Linked Server
- Simple way of telling if I'm using MSDE or full SQL Server?
- Consuming results sets in a calling SQL procedure
- Query dbowner
- Update clustered column in place?
- Replication Reporting
- NT, SQL 2000
- To name dbo or not?
- Using DTS to import data - no rows returned.
- Using DTS to import data - no rows returned.
- Backup & recovery history
- string to datetime
- Quick question about performance....
- Query Execution Speed
- Table Row Count + Index Row Count
- SQL Query
- Slow Query with Date
- Deleeing database
- Upgrade of SQL Server driver
- Problems with starting Personal server 2000
- SQL query
- Localization issue
- inserting xml data
- ADO connection pooling and pepared statements
- Hide subquery results in stored procedure
- Getting last (newest) one record (datetime column or id)
- Logging "On Delete Cascade"
- BUG? SQL 2k - IN () allows invalid syntax and fails silently
- Frontpage 2000 AND SQL Server 7
- timeout Expired when trying to do a 'where' or filter recordset
- All my databases are missing
- Problem with creating views
- Why is SQL Server using so much Virtual Memory?
- can't see server
- 2 ms sql server backup
- Using Forms with Sql server
- Exported queries to excel an spreadsheet file
- Exported queries to excel an spreadsheet file
- How to Deploy SQL server Database to another PC while creating SetUP package in .Net VB
- REMOVE DUPLICATE ROWS
- Fyracle: Oracle-mode Firebird
- sql alert percent log used
- Stored procedure and query plans different
- IN() operator problem
- Send a warning to current connections
- User-Defined functions in DTS
- beginner student PL/SQL to T-SQL
- Automate restore
- Avoiding compilation
- Alter column causing log to fill
- Calling sp_oa* in function
- Variable inside a nested loop
- Auto Number or Identity Seed on Oracle Database
- sp_who_3 : An Enhanced and Efficient Version of sp_who
- Using REPLACE with NCHAR in a stored procedure
- Is the MSSQL server on the local machine?
- easy table based update statement???
- Little puzzle on data selection
- not in
- Multiple values in one column
- Will this query be optimized for a partitioned view?
- Number of foreign keys
- Can you add an Index to a table variable?