View Full Version : answers
- Data grouped by 20 minutes?
- About: An INSERT EXEC statement cannot be nested.
- CASE problem
- An INSERT EXEC statement cannot be nested error.
- Strange Performance question
- Can't send operator email in SQL Sever 2005
- sql 2000 64-bit
- Return pkID of last saved record - ASPUpload & @@Identity
- connection TCP/IP through the port 1433
- Microsoft SQL 2000 Documenter
- Using the copy database wizard
- Timeout Period in SQL Server 2005
- SQL View Performance
- Bulk delete on operational data
- Performance when using php and mysql
- Query Retrieval is slow
- Oracle licensing for dual core processors
- SQL backup - dun understand
- Prepared SQL Plan vs. Procedure Plan
- difficult summing query
- SQL Query Help
- Subquery headache with Count and GroupBy
- SQL server - script execution time
- query problem
- Combining INTO with UNION
- How to move two separate databases into one?
- 100 % CPU Usage
- Tuning API CURSORS
- How to drop one of the tempdb files
- Enterprise Manager - problem
- SQL Equivalent of MAX and IIF
- Need help with Count function and temporary tables
- batch replication
- Limit saving DTS package to SQL Server
- problem with Select query
- About bcp_init
- Active directory and SQL 2K
- Scheduled Job Hangs the server
- Scheduled job hangs the server
- Compressed folder & Query speed
- UBOUND
- Recordset
- Requirement : IBM Process Choreographer
- Hiding secret columns from users
- Splitting a filename out of a filepath
- SP 4 error
- verify if database exists
- BULK INSERT and APPLICATION ROLE
- About dtsrun
- Database Problem related Clusterd data
- need a DBA Suggestion.
- Make a Bunch of Rows from a Table Resemble a Column
- Simple SQL Query (To Neglect time from DateTime DataType)
- Alex
- Log Invalidated after truncate table
- HIT and MISS
- stored procedure with array of parameters
- SQL Server Msg 1105, Level 17, State 2, Line 1
- Query returning 1.7million records slow
- Best use of inner join
- Is this normal
- What looks like a basic SQL query still not resolved
- Inner join weirdness in DTS
- exam ms 70-228
- need help
- Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
- Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
- Optimizing Stored Procedure with Datetime parameter
- SQL statement to compute employee pay for a year at different pay rates
- adding identity column dynamically
- need information on SQL SERVER 2000 with multi-threading CPU
- sql query update
- There is a question when i work on Linkedserver~Pls kindly help me:)
- full text catalog on remote (shared) server
- Merge Replication - Adding a new table
- QUESTION: Connecting with SQL Admin across domains
- Indexes being improperly used when selecting data through a view
- SQL-Server DBA-Full Time, Permanent, National Institutes of Health
- Optimal search for the nearest date
- get the DB index SQL
- NEWID()
- SQL 2005 Developers Diagram question
- SQL 2005 Unhandled Exception Error
- flexible back-end data handling in .net + sql project
- Query Question
- Options to upgrade an SQL 6.5 DB to 2000
- DTS package design - Not allaowed link
- Is DTS source file's name parameterizable?
- Tracking Package Execution Status
- Install or not to install Launch Give away version?
- Room availability
- who knows reporting service
- Concatenating strings from different rows
- why the MS DTC always stop services automatically ?
- Star Join
- SQL Join with unknown tables - but it works!?!
- SQL server connection problem
- working with large numbers
- regarding BLOB
- How to delete data older than X days, without considering time
- Something Basic
- Something Basic
- Store data horizontally or vertically?
- Need security advice on xp_cmdshell, bcp, xml procedure
- Linking a table
- Simpleton question please
- migrating form standard to enterprise edition
- how to have the DB diagram
- Parse Return value of SYSTEM_USER
- DBGEN TPCH Compiling
- How to do a JOIN statement for a table with 2, one-to-many relationships.
- Bulk Delete
- Help with SQL query
- Terminal Service cause TimeOut Expired
- QUESTION: No Support for SQL 2K on W2K3??
- Database optymalization(??)
- Filegroup restore problems
- Where are the maintenance plans stored in SQL Server 2005?
- stored procedure update HUGE PROBLEM
- grouping select query
- Tables in Parent-Child order
- DTS question: 2 source tables, 1 target, 3 connections
- Question about Views and sp_refreshviews
- Interesting SQL query requirement for <SELECT> menu
- Insert
- update spends 1800 times more than select
- Sql Server 2000 causing TCP/IP to crash?
- optional parameter in sql query
- commit and rollback problem
- tree structure select problem
- OpenDataSource trouble with Advantage SQL
- newby - AUTOINCREMENT problem.
- is WITH ENCRYPTION now safe in SQL2005?
- Return Stored Procudure Values
- MDF File Still Exists After DROP TABLE
- stored procedure
- DELETING 100 million from a table weekly SQl SERVER 2000
- row level security across multiple columns
- BlackBerry Enterprise Server - SQL problem
- an unexpected error occured during this operation
- mirrored sql servers
- How can I tell if a sql server is MSDN or Standard or Enterprise version
- sysprocesses memusage sleeping
- access MS SQL/ACCESS from linux?
- aggregate question
- TCP/UDP ports used for Index server OpenQuery
- Looking for an opinion
- help
- Using Query Analyzer with Windows Auth across domains
- Whats wrong with my join statement?
- Approximate String Searches
- Pros / Cons to this approach
- learning Microsoft Query Analyzer
- Automatic SQL Queries to dump data to folder
- Updating a Chunk of data without crashing transaction log
- Tables are skipped or export failed error occurs when upsizing MS Access to MS SQL Server
- Default charset in sqlserver 2000? / jtds
- History of logins or Userids
- TPC -H creation script
- Torn Page
- Is there any REGEXP library for TSQL?
- Database design question...
- host_name
- SQL query question
- Unique Constraint on Multiple columns
- Stored Procs and db_owner
- Information Schema Query Question
- Passing authentication from PHP to reporting services
- Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
- Mira Laura, toma la direccion web,,, dime algo. MS58
- Rendering directory structures
- question about log file size when alter Huge table
- Use DEFAULT CONSTRAINTs or BOUND DEFAULTs?
- Problem with HOST_NAME Function with Linked View
- Creating Tables on the Fly
- have sql file and want to run it on an ftp connection
- unique constraint to a column from another table
- DTS Table Import Issue
- error message 18542 level 16 state 1
- Count(*) Locking up things ...
- Distinct Filter in SQL Reporting Services
- Multiserver Administration
- MSDE and two instances on the same server?
- Attaching MDF without LDF
- Statement for returning stored procedure params
- SQL Server 2000 and 8k limit
- advice needed on new server product
- Find the Data Bases which can not be Backed up are some resons
- Find the Data Bases which can not be Backed up are some resons
- String manipulation challenge in SQL
- Table Synchronization across databases on the same server
- How to take data out of table, restructure the table and then put the data back in
- DTSRun causes The Memory could not be "read" application error
- Server Listing for TCP connection
- Identical database w/ identical stored procedures?
- Record , Row number
- Record , Row number
- Deriving unique rows from historical data
- too many connections
- User Defined Functions, passing parameters from another udf's results (end result=Crosstab)
- Tool for clients
- Stripping Punctuation
- Create Procedure Output ntext
- need to replace replication server with main server
- DAO > SQL Server Processes
- How to select data
- Quarterly trending
- Quarterly trending
- excluding fields in SELECT statement
- mssql ide (front ide)
- SQL Server 2000 Error 17805 Invalid buffer received from client
- Many data entry tables - which ones hold records?
- CAST Command
- EnterpriseManager-->Process Info Screen
- How to create table names by using macro variable? Thanks!
- Sql Server 2005: Get a list of all configured Web Services in the "Object Explorer"
- historical data
- How do I concatenate text to a sql statement
- Table Documentor
- DTS vs triggers
- Synchronising access and sql server
- I wish upon a new server ....
- Problem with simple cursor
- Foreign and primary keys
- Adding an auto-increment column to existing table with a particular order
- Derived tables from multiple resultsets
- MOM blocking analysis
- sum of sums
- Identifying results sets when stored procedure called multiple times
- simple userdefined function question.
- Unable to update view in Sql Server 2000
- A way to recursively look up hierarchal data using a lookup table
- How is inheritence like data best done in SQL
- .dat
- Certification is not so easy job.
- Query help
- Moving Data for Audit - Best Practice
- Sequence of columns in primary key
- How to display just user defined objects?
- Creating Primary key with ODBC
- Form Slow, Then Fast
- SQL UPDATE - PLEASE HELP
- Database Access over Internet
- How to Interpret Merge Agent History and Session Detail
- determine tables that are Simple recovery
- Organization tree
- MS SQL Server 2000 - Search a table with 300,000+ records in less then a second or two
- Wrong default constraint shown from Object Browser in Query Analyser
- Tracking user activities
- Column By Column Comparison
- Relational Database Usage survey
- Unique Selections In Back End
- Using "SELECT * " is a bad practice even when using a VIEW instead of a table?
- Using "SELECT * " is a bad practice even when using a VIEW instead of a table?
- Type Mismatch Error On Bulk Insert
- Overflow error
- Defragment Heap Tables
- Bulk insert
- Bulk Insert Command
- Update One Based on ANother Table
- Help with Query
- Is logging the execution time of Stored Procedures with standard settings possible?
- registering SQL Server not in domain
- Problem with SUM
- Join statement
- Changing the 6th character of a string?
- Bulk Insert Data in Millions - Lock Issue
- AutoNumber vs. Key
- Any way to optimise this query?
- embedded control characters
- Errors with SP4 upgrade... Please Help
- One-One Relationship
- ...Contains more than the maximum number of prefixes. The maximum is 3.
- Template function
- Sql Server backup vs HP Data Protector (HPDP) -- Do *not* use SQL Server?
- LIKE and IN can I combine
- database in simple mode yet txn log file can be out of diskspace ?
- selecting only the last record in joined table
- Sooper Newb Ques: Starting with SQL Server 2000 DE
- Schema Diff Tool
- Dates in a date range
- Temp Table on Linked Server
- PK and Timestamp in same table?
- Backup for one new DB failing in regular maintenance job Error 3201
- SQL Import of LArge Amount of Data
- question about like
- OpenRowSet with Excel DENIED
- SQL Convert function!!
- changing indexes
- SQL for field names from a table
- Change Data Type
- seeing FMTONLY/NO_BROWSETABLE ON stuff in the profiler
- Import cell data from XLS into SQL table
- Please suggest backup software
- delete of mirrored rows
- Joins: strategy and how-to approach
- Unique ID added to a result set
- how to determine programatically what output of a sp will be?
- Display Money Type using + and -
- image data type
- Transaction Management
- resultset of proc in another proc
- new sql version control solution!
- Search Advice
- PostgreSQL Linked Server question
- OPENXML vs BCP
- my new function not found
- Error installing SQL Server2000: A previous program installation created pending file operations on the installation machine
- word xp
- Calling a Data Pump task from DTS?
- copying server objects
- Can't "SELECT" using CREATED_DATE column...help
- Multiple level nested Corelated query
- Problem with case expression
- jacek@karczmarczyk.pl
- Error handling when calling external sql-Files
- Trouble with SPROC
- Unit Testing
- Autogrow question
- Need help formulating a query
- ASP.NET + SQL 2005
- Query Help, thanks!
- How to save DTS package as an application
- How to convert from CHAR to Numeric in the table
- Horizotal to Vertical Display
- How to check Backup of SQL Server Database
- Controlling fields in a select statement by use of parameters
- NAMED SET / PIVOT TABLE !! HELP ME
- Howto set Access Recordsource onto a "select" sproc
- HELP MDX , NAMED SET AND PIVOT TABLES !!
- SQL Server 2000 Backup + Restore question
- SQL Mail setup
- SA can not create users
- Multiple entries script...help
- Database Replication
- Transaction log ???
- Problem causing me to have to restore tlogs WITH MOVE
- Restoring a missing db
- Job invoked by Alert but Alert never occured
- Fast Date Ranges Without Loops In SQL Server 2000
- Howto setup my user in order to grant him the drop privilege
- Performance and second table
- How to remove MSDE manually?
- Can I speed up this script...help?
- Stopping Query Execution from PHP
- Simple question
- Does DBCC DBREINDEX update stats?
- Consolidating Records
- Finding the most recient datetime
- ordering an int column
- SQL Server Hanging
- date format
- Access Control List (structure) invalid - updating Virtual directory information
- parsing varchar fields
- iSQL - Blank line at the end of the iSql output file
- Error : Difference of two datetime columns caused overflow at runtime.
- Error : Difference of two datetime columns caused overflow at runtime.
- The SMTP Server in xp_smtp_sendmail
- Blocking and Transactions OK?
- bit off topic: street name database US
- Report Services
- SQLColumns crash (Access violation)
- updating multiple fields
- Howto Format a string in a sproc ?
- Connecting Trace info to blocked users?
- PASS User Group Austria looking for MS-SQL professionals to take part
- Is there a way to find growth in log (ldf) and database(mdf) ?
- Any way to find out which SP is updating data in a specific table?
- min(date) + 1
- searching a list of tables, derived from another table
- XP and Replication
- Help finding the top 3 zipcodes within the top 5 counties
- Syntax to add records if primary key = list
- Renaming a Server
- Is there any way in a sproc to LOOP thru the records of a table ?
- inline if
- search on concatenated fields in sql server
- Original Data and Log size
- Rejoining replicating servers
- MDF / LDF
- Data Load Query
- Linked server
- Dynamic data elements for a data collection application
- Security Admin on a server with NO public permissions
- delete records
- bcp header
- Delete relationship?
- DataDirect Technologies Releases DataDirect XQuery to Simplify XML and Relational Data Integration
- Insert based on a select query
- Single quote in NVARCHAR string?
- How to update 1000s of items in 50 tables
- Identity...I need to get the last (or highest number in Identity column)...
- Stumped by SQL challenge
- SQL Server paged recordset problem
- SQL 2000 installation on WinXP Pro problems
- Can't connect
- Scheduling Database - Design Help!
- Scheduling Database - Design Help!
- Reg Exp for digits
- Converting Binary Image to Readable Text
- IDENT_CURRENT and empty table
- NOLOCK and READPAST on same table?
- Determine fastest query in Query Analyzer
- Using IS NOT NULL on column result from subquery
- Query Syntax help
- Aliased column in stored procedure not seen by datagrid
- SQL Mail - MAPI profiles on Windows Server 2003
- Best way to tell if a SP is a query Programatically
- Tools for design recovery (reengineering) of C# source code with embedded sql statements ?
- Extremely Slow Table
- how to do text replacements
- SQL Server bouncing connections
- Dont backup if Database hasnt changed
- The "right" way to distribute a database to end-user
- Why dosn't IIF work here?
- saving output from multiple queries
- Can someone help me with multiple "Left Outer Joins"?
- Need Help with "Left Outer Join"...
- Can someone help me with multiple "Left Outer Joins"?
- Removing white spaces in a varchar column
- Help on a SQL query
- oracle pl/sql -> sql server
- Index corruption on table without key: what could be the reasons ?
- SCOPE_INDENTITY() Not Returning
- Script to search for a string in all varchar columns in all tables in a database?
- VB 6 & SQL Database: How can I create reports with charts ?
- Saving query plan
- Output stored procedures as text problem
- XML generation issues
- How to count
- How to override zero rows returned
- Monitoring Software
- xp_sendmail problem - body message breaking onto new line..
- Find the Stored procedure
- Round problems in SQL 2000
- Changing From Windows To Mixed Authentication
- sql datatype help
- Systematically determine DRI problem(s)
- Any SELECT Statement Gurus Out There?
- Import Spreadsheet error
- How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log
- desinstall MS SQL
- XML Tables generation
- desinstall MS SQL
- Help with calling a job from Stored P and VBA......HELP
- About adding a new column...
- Return from store procedure.
- sp_xml_preparedocument
- How do I write a query to get the path from ancestor to node in a tree?
- stored procedures using external applications
- sql query question....
- sqlmaint.exe failed
- Execute DTS package from .adp ?
- SQLMANGR.EXE optional parameters?
- connection based temp tables
- Data changes made late at night "dissapear"
- SQL script - sum total issue
- table copy misses indexes
- Version of Windows Server?
- Location of logging for temp tables
- A connection could not be established LOGIN FAILURE
- problem - open recordset - ADO
- Creating Text File from Stored Procedure
- Extracting Time from the SQL DateTime field.
- Reading an XML dataset into a SQL Server dynamically
- How to BCP IN to table with IDENTITY column
- the 'DEFAULT' filegroup is full
- Immediate Synchronization?
- SQLDMO Object
- Inserting large amounts of data
- bcp utf8 file
- Multi-table UDF not returning all rows
- Schedule a T-SQL Script
- DTS- Add global varible's value to text file
- writing SQL data to XML files
- Problem with uncommited transactions in log-file
- inner joins
- joining one table with itself
- Crosstab Query
- Logshipping
- Problem writing XML files.
- Increasing performance by selecting one table
- Slow stored procedures
- Getting count with multiple fields
- JDBC deadlock on unrelated records
- Replacing SELECT with a value in an OUTER JOIN
- Massive delete in DB
- Escape characters
- Regular Expression?
- select * from table where column = @AllValues?
- Problem with case statement
- Reporting Services - Crystal to SSRS
- brain teaser - stagger the order of the results
- Double quotes replacement
- How do I find the highest Unique Identifier?
- Question about Service Pack
- Slow Query Through Cold Fusion
- osql doesn't work - SOLVED
- osql doesn't work
- Getting Avg to really ignore null values
- Problem expanding a Db table (SQL Server 2000)
- Counting Results in a field in SQL 2000
- Left Join Problem
- Update Table Column based on value from another table?
- Incorrect syntax in user-defined function
- 3rd party Backup Software and MSSQL 2000
- COUNT() Idiot
- ((cdate("1/1/2001")+30) as task_due_date (Not working)
- Joins in MSSQL
- View field content update when "real" table fields change
- Export Schema in SqlServer 2005
- Can I force printing?
- list of clustered index in the database
- Memory usage in SQL Server
- compond index and key faster/better?
- The select statement is in a field
- Syntax? - Searching combined columns
- SET ANSI_WARNINGS in Stored Procs - how to avoid recompilation bottleneck?
- SET ANSI_WARNINGS OFF in stored procs - how to avoid recompilation?
- convert ms access sql staement to oracle sql statement
- Assigning Foreign Key To New SQL Server Table
- restore problem about sql server
- Case Sensitive Pattern Match
- Can I access my private db through my web server?
- All records within x minutes of each other
- SMC violating Microsoft license agreements?
- Generating values as part of a compound key
- SQl server processors and threads
- Strange date/time anomaly, or am I just stoopid?
- How to "undo" a delete with cascades
- Why the performace differs?
- Installing SQLServer 2000 service packs on Clustered server
- Will SQL 2k 64bit ed dump files load on 32bit SQL2k?
- Can @@ROWCOUNT return NULL?
- Backup User - Server Role?
- Rewrite a WHERE clause
- SET IMPLICIT_TRANSACTIONS ON
- Memory usage\Performance problem
- MS SQL Server 7.0 SP4 on Windows 2003 Server.
- WTB:Visual Studio Tools for Office 2003
- Database file size question please
- need help with SQL Macro in MS Access
- Searching multiple entities at a time
- Convert float to char
- Datediff needs to deliver month AND days
- Indexes and UniqueIdentifier Fields
- Check Constraints or Triggers
- How to keep a running total
- Key and Index on Same Column?
- Query Analyzer Question