View Full Version : sql server answers
- Replication
- Executing a reboot command from SQL
- Upgrade to Sql 2000 with minimal downtime
- SQL Trigger for trimming String fields
- Should SQL concatenation return a null value if one field is null?
- Help for Trigger
- Problem: Stored Procedures not completing from Web Application
- Help: Purge Table Stored Procedure
- error with linked server
- SQL query fails
- SQL server reboots my windows 2000 machine
- regarding: Least expensive way to develop SQL 7 or 2000
- Creating database and table on MS MSQL server
- [QUERY] Help...
- Least expensive way to develop SQL 7 or 2000 Database on website?
- Sum query
- SQL daily
- Index is being rebuilt
- @ local variable makes query slower?
- Count records when RecordSource is a Stored Procedure
- Replace function and regular expressions
- Unique constraint index
- SQL Server Max Record, multiple table join problems
- BackUp Quastions
- License Requirements for MS-SQL 2000
- error in recordsource after converting to sql server 2000
- Invalid Udate SQL statement DOES NOT cause error... Does anyone know why??
- local system privildges
- Pre-installed databases?
- Help for best logic
- Sr. SQL DBA job open in Texas
- Updating statistics
- No of rows conflict in a table
- Enterprise manager
- use of variables - why doesnt htis work
- Problems with 'sp_helpdb' stored procedure
- Finding out what a user did - help needed
- What is faster? C++ vector sort or sort in database
- Help with Many-to-Many-to-Many Problem
- select * from a where (field1fromA, field2fromA) in (1,1)
- migrating rows between diferents schemas
- Access Front End and SQL Server 2000 Record Level Access Control
- MSDE & database moving.
- SQL server image data
- Replication
- Sql Scripts to Monitor another SQL Database.
- Executing a reboot command from SQL
- Upgrade to Sql 2000 with minimal downtime
- Help for Trigger
- How can I query a trusted domain (from MS SQL)?
- SQL Trigger for trimming String fields
- Help: Purge Table Stored Procedure
- error with linked server
- SQL query fails
- SQL server reboots my windows 2000 machine
- transaction id mismatch
- Creating database and table on MS MSQL server
- [QUERY] Help...
- Transferring from SQL 6.5 to SQL 2000
- SQL daily
- Replace function and regular expressions
- SQL Server Max Record, multiple table join problems
- License Requirements for MS-SQL 2000
- Invalid Udate SQL statement DOES NOT cause error... Does anyone know why??
- trigger
- How to Parse Sentences into Words
- tools for cleaning name and address data?
- Median query with Group by clause
- warning re ADO .UpdateBatch method
- No of rows conflict in a table
- RAM
- security with web-based access
- Finding out what a user did - help needed
- Primary and linking keys on SQL server tables
- View Problem
- Unallocated Space anomaly
- probably an easy one - 2 agregate functions
- Help with Many-to-Many-to-Many Problem
- [Q] complex output result again: the end of script was cutoff in the previous posting
- select * from a where (field1fromA, field2fromA) in (1,1)
- [Q] complex output result
- SQL Query- confused with nesting...
- Moving a SQL Server 2000 database that is in Standby Mode
- migrating rows between diferents schemas
- MSDE & database moving.
- SQL server image data
- Sql Scripts to Monitor another SQL Database.
- How can I show decimals after division update
- How can I query a trusted domain (from MS SQL)?
- Help in SQL Query - easy
- transaction id mismatch
- Help in SQL query
- Transferring from SQL 6.5 to SQL 2000
- Max () query problem
- BACKUP TABLE(historical)
- trigger
- How to Parse Sentences into Words
- Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
- tools for cleaning name and address data?
- Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
- Median query with Group by clause
- RAM
- warning re ADO .UpdateBatch method
- security with web-based access
- Cannot See a Newly Installed SQL Server 2000 (No Active Directory)
- Make a copy of parts of a ROW, but with a new Key.
- Image file, SQL Server, and web.
- Primary and linking keys on SQL server tables
- Member Property
- View Problem
- Unallocated Space anomaly
- It is not a real index but exists as statistics only
- EXEC Inside a cursor iteration problem
- domain user or local system account ?
- probably an easy one - 2 agregate functions
- Alter Table - Change Column Datatype
- Creating Tables and automatically inserting data-HELP!!
- [Q] complex output result again: the end of script was cutoff in the previous posting
- Output parameter from Sproc
- [Q] complex output result
- SQL Query- confused with nesting...
- XACT_E_REPLAYREQUEST
- Moving a SQL Server 2000 database that is in Standby Mode
- Calculated values and database design.
- huge logfile problem
- How can I show decimals after division update
- Retrieving Result Set from Dynamically called Stored Procedure or function in a Function
- sysindexes???
- Help in SQL Query - easy
- How do I set values to DBPROP_DATASOURCEINFO (from SQL)
- Job Failed
- Help in SQL query
- How do I store objectGuid (binary from AD) into SQL table?
- Change Collation Sequence
- DTS permissions and ownership
- Max () query problem
- Select and Update of records without being used by other users?
- BACKUP TABLE(historical)
- Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
- Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
- Repeatable error, with script, with code
- Cannot See a Newly Installed SQL Server 2000 (No Active Directory)
- Make a copy of parts of a ROW, but with a new Key.
- MSDE Install Problem
- Member Property
- Image file, SQL Server, and web.
- It is not a real index but exists as statistics only
- EXEC Inside a cursor iteration problem
- domain user or local system account ?
- Alter Table - Change Column Datatype
- Creating Tables and automatically inserting data-HELP!!
- Output parameter from Sproc
- XACT_E_REPLAYREQUEST
- Calculated values and database design.
- huge logfile problem
- SQL Query Quandry
- Retrieving Result Set from Dynamically called Stored Procedure or function in a Function
- a piece of theory
- Paging Advice Needed
- sysindexes???
- T-SQL ASP While not rs.EOF
- Locking Info
- How do I set values to DBPROP_DATASOURCEINFO (from SQL)
- Job Failed
- who i am in MSSQL
- How do I store objectGuid (binary from AD) into SQL table?
- Change Collation Sequence
- DTS permissions and ownership
- Select and Update of records without being used by other users?
- Generate SPs as text
- Syntax error converting the varchar value '10.136.20.20' to a column of data type int.
- Repeatable error, with script, with code
- Search contents of stored procedures?
- SQL + everyday
- MSDE Install Problem
- Connection Problems to SQL 6.5
- SQL Query Analyzer - Trace Tab
- SQL Query Quandry
- a piece of theory
- Paging Advice Needed
- T-SQL ASP While not rs.EOF
- Locking Info
- who i am in MSSQL
- Incorrect columns returned by view
- Generate SPs as text
- Syntax error converting the varchar value '10.136.20.20' to a column of data type int.
- How to convert int to decimal
- Search contents of stored procedures?
- SQL + everyday
- Cursor and row retrieval question
- Connection Problems to SQL 6.5
- SQL Query Analyzer - Trace Tab
- Can anyone give me a query for this ?
- Any Column Updated / Inserted Trigger
- Incorrect columns returned by view
- Stored Procedure Question
- Guid as primary key
- DTSrun in Stored Procedure
- Any Linux-based apps similar to MS SQL Enterprise w/ DTS ?
- Using a trigger on a view
- Clarification about newid() function
- How to convert int to decimal
- Storing Dynamic Table or View information
- Update Time Question
- Cursor and row retrieval question
- Can anyone give me a query for this ?
- update field with max from another table
- Data transfer from 6.5 to 2000
- 'Upgrade' from 2000 Standard to 2000 Development edition
- SQL Server text file continuous import problem
- Any Column Updated / Inserted Trigger
- Stored Procedure Question
- Data Restore on Elm Street!
- Guid as primary key
- Problems inserting rows using OLEDB and views
- DTSrun in Stored Procedure
- Any Linux-based apps similar to MS SQL Enterprise w/ DTS ?
- Using a trigger on a view
- Clarification about newid() function
- Storing Dynamic Table or View information
- creating Random Lists which do not have any unique records?
- SQL Server 7.0 installation
- Update Time Question
- update field with max from another table
- TimeStamp
- Data transfer from 6.5 to 2000
- 'Upgrade' from 2000 Standard to 2000 Development edition
- Loading text files using DTS
- SQL Server text file continuous import problem
- Could not run BEGIN TRANSACTION in database 'whatever' because the database is read-only.
- JOIN ON CONTAINS(Table1.Field1, Table2.Field2)
- Self Join Question
- Create Index via Stored Procedure?
- Data Restore on Elm Street!
- BCP in of hex data
- Problems inserting rows using OLEDB and views
- Insert rows from other server
- MS SQL vs PostgreSQL
- Checking obligated values in different rows
- Licensing
- Premission to create database!
- creating Random Lists which do not have any unique records?
- MSDE Question
- SQL Server 7.0 installation
- Checklist
- MS SQL Port
- Converting negative value
- TimeStamp
- Which SP3a for SQL 2000 Personal Edition?
- Loading text files using DTS
- Direct access to records via timestamp
- Could not run BEGIN TRANSACTION in database 'whatever' because the database is read-only.
- JOIN ON CONTAINS(Table1.Field1, Table2.Field2)
- Self Join Question
- Create Index via Stored Procedure?
- BCP in of hex data
- Insert rows from other server
- MS SQL vs PostgreSQL
- Checking obligated values in different rows
- Counting number of IO Accesses per DB
- Licensing
- Premission to create database!
- MSDE Question
- DTS and Transaction
- Checklist
- MS SQL Port
- Scripting data in tables
- Converting negative value
- Which SP3a for SQL 2000 Personal Edition?
- Direct access to records via timestamp
- Counting number of IO Accesses per DB
- DTS and Transaction
- Scripting data in tables
- 446: Impossibile risolvere il conflitto di regole di confronto per l'operazione
- SELECT issue
- Bypassing recovery for database
- Advice
- loosing Databases ??? Help
- Backup Text Report
- Howto work and manage Backup Logfiles?
- Changing Database within a stored procedure
- SQL Trigger for changed columns?
- SQL Server Analysis Series Cross Tab Crosstab Report
- SQL Server/ADO/XP problem "query cannot be executed"
- Geographically Diverse Data Deployment Doubletake, SRDF, Log Shipping
- Is tempdb big enough for what I'm doing, plus other questions.
- Weird select statement ?
- OLAP - Calculating Minimum Measure if NULL is present
- Looking for findcolumn script
- Can I create a 'Top n' statement within a stored procedure using a parameter?
- a heirarchical query
- UniqueIdentifier pros and cons ??
- Is there a macro (as in C lang) like facility in SQL server 2000.
- How do I do this is SQL Server? (from an Oracle background)
- Blocking and return parameters
- *** DTS Error Messages ***
- Matching Strings In Different Tables Of Same Database
- HostName Function with Access2K front end
- Sql server log File Full Error
- security question
- SELECT DISTINCT Problem
- DBCC commands stability
- SQL error 20029
- MSDE and Access 2000
- which file store startup parameters?
- Data/index locks in SQL Server
- DTS dilemma
- efficiency of query
- Indexing Results of Stored Proc (or new table created by one)
- multiple deletes with a stored procedure
- Database Diagram
- Surefire Method to Determine that SQL is running programmatically.
- How Do I use an ODBC database in Query Analyzer
- Linked Server Error Between SQL Server and Oracle
- alternative way
- Are text pages deleted when a column is converted to varchar
- FILE SIZE IN MODEL
- Dynamic Cursor versus Forward Only Cursor gives Poor Performance
- Return one row
- SQL Statement to generate customer list whose last payment date is jan 04
- recording query
- Problem with string
- Does anyone know the difference in the locking behaviour between sql 2000 and sql 7?
- How to copy cube to Excel?
- SQL backup job - failed
- Logging on SQL Server 2000
- Multiple docs open in Query Analyzer
- IF Condition in Join??
- inconsistent behaviour linked server?
- Linked Server Query Problem
- App server unable to connect to SQL Server 2000 developer edition on localhost.
- Transaction logs
- Full-text Indexing
- Stumped by a BCP problem
- this is driving me nuts - solicit help from the gurus
- DTS error
- FULL OUTER JOIN
- Book suggestions for studying for MCDBA
- Incremental output in QA and writing to files
- Can't upgrade to SP3 in Win Server 2003
- Load balancing and clustering
- Update statement performing table lock even though where condition on clustered primary index?
- MS SQL 2K server on windows 2K
- data synchronisation
- Auto created statistics and missing statistics
- trigger before delete in firebird or mssql
- Execution plan of UDF
- primary key autoincrement question.
- Helpdesk database statistics crosstab report
- SQL Statement for generating expired customer
- Advise on Multiple Column Updates
- 2 Qs
- ADO Recordset's object method Open
- "Tracking"
- Returning random records and NOT similar (random questions)
- Script, Save, Export SQL Database Diagrams
- Retrieving an Answer from Mulitple ResultSet statements
- Count of Columns <> 0
- Type 'adCmdStoredProc' is not declared
- Generate insert script
- Problem: must detect db changes
- SQL Server Agent confusion
- Sorry for dbl post but previous post was damaged somehow (WAS SQL Server agent weridness)
- SQL Server Agent
- Prepared Statement where value IS null or value = :x
- selecting x records from table n times according to variable criteria?
- Executing a DTS from another DTS...
- Using Image data type in a SQL Server 2000 table
- Trapping BCP error from SP
- newbiw SQL 2K DBA
- Common Table Expression?
- Problems using xp_smtp_sendmail
- Sending email from sql server
- About Store Produre
- Marrying SQL, XML, web services, grid computing (2 audio programs)
- Converting Number to Text
- Convert Punctuation to Spaces?
- SELECT MAX statement
- How to make self-backup log in msde?
- output parameter with text data type in stored procedure
- Best way to install a database at a remote site
- Anyone recently installed SQL Server 2000 Eval version???
- Inserting data into tables having triggers...
- Doubt in " HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual C# .NET"
- Delete record based on existence of another record in same table?
- When denormalizing is essential
- Communication link failure...
- Help - Recovering a deleted job
- SQL 2000 performance
- Help with this script!
- Update table row by row
- Transaction...
- How to extract data from one database to another.
- No log operation
- Select datatype of datetime
- What's your compensation for carrying a pager???
- stored procedure denies EXECUTE permission
- Access2K Connection to SQL Server2K
- Value of @@Error after performing update that finds no records?
- DECODE?
- Counting items and returning values
- Query performance with order by clause?
- Should I split this 175 Million record table?
- MS-SQL issue with server browsing
- Retrieving updates made within a transaction?
- web content database. Is there a limit?
- Select boolean values merged in a text statement
- Can't edit table design in Enterprise Manager without dialing in to internet! :(
- Microsoft SQL Server 2000 Standard w/ 5 CALs
- data loss
- Using CHARINDEX vs LIKE in WHERE?
- challenging sql queries
- DISTINCT QUERY
- Stripping non-numeric chars from a field string - SQL 2000
- Runtime build sql in stored procedures with output param Q?
- DTS for insert/update
- info on MAS90 / MAS200 for SQL server
- Design to accomodate entity based schema versioning
- Why Cluster a Primary Key?
- How To Do An Average Of A Count
- Assistance please using txt
- SQL Error in Application Log File
- Issues with LEFT join on four tables
- Unknown Token Received
- Problem movind a datbase from ACCESS to MS SQL
- MSDTC error on Windows 2003
- -"Access Denied (Error 5)
- Problem with simple Where Clause
- pk-fk problems
- Procedure Stopping
- bcp data to a txt file
- Rebuilding indexes
- search multipe fields, compounding fields, like, contains...?
- Translate sql statement into SQL-92 standards
- bcp_moretext & NULLs
- i need help please
- BCP output with header and trailer
- Selecting one greatest number from two columns?
- Attaching and Detaching a Database
- Help: How to detect inserts, updates, deleted on a table from within C++ application?
- outher joins formats
- debugging DTS custom task written in C#.NET
- Something wrong with "select max" in this query?
- select statement that returns the column names and keys
- Application roles
- i need help please
- ODBC Memory Leak
- DTS Select using record position
- My guess is stored procedures
- Avoiding time-outs
- Multiple conditions in "IF" statement in T-SQL?
- Point-in-time backup of database & filesystem
- expanding databases in SQL 6.5
- SQL between Problem with dates
- Problem is forming Query
- how to configure connection pooling
- BI tool users - message for u
- complex SELECT
- calling Stored Procedures from different DBs
- SQL Query - Find block of sequential numbers
- space used by a table?
- Finding affected tables
- DTS package
- SQL Server Backups
- I want to restrict the my clients to access database through EnterPrise Manger Or Quer analyser
- Calculated Member uisng a Member Property
- strange optimizer
- Looking for a reporting tool for sql views
- Handling # (temp) table
- March 15: Rick Cattell, Peter Coffee, Dana Florescu, Jim Gray, Jim Kleewein, Jim Melton discuss XML, services and grid
- Date problems between VB and SQL
- OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
- Help ! Dangerous user with SA permissions
- sql dinamic
- sql server tools
- Allowing a user access to only a few tables
- how data file and log file grow?
- creating / changing owner problem
- modifying user security
- use column names and not positions when inserting from one table into another
- select parameter order
- Event driven log backup?
- searching for encrypted fields in data columns
- System Schema & Documentation
- SQL Profiler Hanging
- REPLIKACJA SQL2000 BEZ DOMEN
- DB Questions
- CountrySelector control
- Problem selecting count, comparing 2 fields in same table
- Make two query in too one
- Reference SQL Parser
- Restore databases into a new installation of SQL Server
- How to write a function that will return true if user is in a certain role?
- create an incremental counter in the stored procedure
- Set operations (EXCEPT/EXCEPT ALL)
- Holidays in SQL Server
- linked tables
- Creating a Table
- auto recompile in sql server
- Calling an Oracle Procedure via a DTS
- stored procedure to create new database
- TempDB tran log growing slowly - yet we are in simple mode!
- Image datatype problem?
- SQL Agent question
- cluster sql server 2000
- Is installation secure ?
- setting the query time out....
- Haversine SQL trouble - Distance between zip codes
- Data disappear - SQL server 2000 / ASP interface
- Array in Store procedure
- Access File/Get Data can't attach to a SQL table.
- search the primary key given the table name
- MSDE & SQL 2000
- Two tables and count
- Deleting records in the logfile
- Getting Database Stats
- Converting Rows into Columns MS SQL 2K
- world atlas database
- Combining data from differnet Excel sheets
- How to fix SQL Server 2000 after machine name & domain change ?
- MS SQL Server XML Query Help
- SELECT problem...
- Tables in Linked Server
- Group dates by month
- Question : How SQL chooses an index for a process
- Correlated Subquery Efficiency
- recursive call in stored proc
- Filter data in sql reporting services
- database logic report
- Alter Column Type.
- sp_spaceused reports over 40 GB unused for a table
- Extra parameters being added onto SP call with ADO?
- back everything up in a single file?
- LAN SQL set up question
- Cristal Reports for OLAP CUBE
- test
- aba_lockinfo - new version available
- wmi access to sql server
- SQL Server Import Problem (UInt64 to Int32)
- using contains clause
- changing object owner syntax
- Dynamic Cross-Tab Query too long?
- Composite primary key on a table variable?
- Using OPENXML
- Server failure
- SQL Server Interview Questions
- ASP, SQL Server and double insert...
- Exporting MS SQL Server or Oracle Databases to MySQL
- how do I query this?
- BCP call to stored procedure - broke during upgrade from SQL 7.0 to 2000