View Full Version : sql server answers
- SQL Running process
- replication
- Whitepaper: "Yellowfin Reporting" enables Embedded Business Intelligence
- Max Row Date
- How do I get a count of each set of results?
- Changing DSN to DSN-Less
- Logging information about items of the Data Flow Task?
- adding unique keys
- SSIS Packages Dashboard
- Incorrect syntax near the keyword 'THEN'
- SQL 2000 dies on JOIN query
- 6.5 master database syslogs full
- data transfer
- columns as rows and rows as columns
- Viewing transactions in SQL server 2005 express
- what is informatio_schema.<something>
- sum problem please help
- USING 'CASE' TO GROUP DATA
- SQL query dilemma
- mp3 songs in SQLSERVER
- Trigger on a table in TempDB
- User authentication
- SQL DTS to DB2
- Collation problem - urgent help
- okay, I'm frustrated....how do I
- Problem with SELECT
- SQL Server 2005 - FILE manipulation hanging....
- Difference between 2 tables
- flat file connection string
- nee stored procedure please help
- Using SQL Server 7.0, Backup maintenance plan not working
- Summarize Unique changes of registration
- sqlserver 2005: indexes on raid-0?
- Creating rows based on date range from another table
- SQL Insert Help
- transaction log
- Move Databases on SQL 2000 Machines
- Changing stored procedure Freezes Crystal
- Recommendation for tools converting access databases to SQL
- Log Shipping Snyc Problem
- Using aba_lockinfo in a loop
- Help with query - anyone??
- Absolute Newbie Question
- Alter a SQL table
- do SS transaction logs have to be backed up for recovery to POF?
- Access to SQL Server Query Translation
- Best way to move datafile from C drive to D
- Hourly Average
- OLAP Specialist vs OLTP one?
- SQL Server 2005 Opening Script File Problem
- how to add primary key in existing table
- Does truncate and API Load invalidate statistics
- Slow Insert in SQL Server
- SQL select statement needed
- I can't create a temp table
- SQL access problem (SP2 pre-installed)
- Array / Table As return Type
- union all and order by problem
- Weird situation - Stored procedure executed twice
- installation problem for SQL 2000 Development Edition
- Trying to do REALLY simple procedure and loop in SQL Server
- SIMPLE command to convert string to number? Not CAST or CONVERT.
- SQL 2000 only using 8GB of 16 GB available
- Only update changed columns
- suggestions for books
- Views, UDFs
- Stored proc duplicating data
- Views
- After SP4, proc w. Cursor doesn't release keylocks
- Using FormsOf(INFLECTIONAL, )
- Multiple Search Criteria using FREETEXTTABLE function
- clustered vs. non clustered
- copy database via tapefile no SQL 2005
- need help with LEFT JOIN statemen
- Almost there with bulk insert
- Create View in SQL Server with data types
- SQL Server trigger that fires only on update of certain field?
- transaction logs full
- MS SQLServer or Pervasive SQL 2000i
- Validating State abbreviations using a Check Constraint
- Selecting on multiple tables
- SQL Server 2000 / [USA edition] = UK ???
- dependent assembly microsoft.vc80.mfcloc could not be found
- dependent assembly microsoft.vc80.mfcloc could not be found
- Accessing form controls values through ms sql fuction
- SQL 2005-Config Manager contains no data
- SQL Server 200 Developer vs Enterprise versions
- Weird DTS Problem
- Trigger problem in SQL
- Get the latest result (new in sql)
- Trouble with Impersonate User, ODBO and Analysis Services
- Hey I've got a homework problem I'm working on and am stumped.
- ALTER TABLE from sqlcmd script
- How to switch off automatic blanking of table views in enterprise manager ?
- 'MSDASQL' headache
- Flattening Parent Child Hierarchy: Urgent please help
- Error in Creating table in Sql server 2000
- New to stored procedure
- format files for use with bulk insert
- How to creat a sp for insert datas...
- Get files in different folder using sql
- Skip rows where the first column with letter 'S' - BCP
- Get column names with the corresponding table name from a SELECT with JOINs
- SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?
- Tying together tables
- Database design question
- Change Logical Name in Script
- TRAN_ABORT gone?
- Global ODBC Settings
- Regional Setting in MS SQL
- SQL Challenge Urgent, Please help
- Cant install SQL Server '05 EE, VB 2005, or Visual Web Dev 2005
- Query Analyzer. What settings to see the data output again?
- Query Analyzer. What settings to see the data output again?
- Import multiple csv into multiple tables
- Is DEFAULT a constraint?
- Using Union and Join in a single view
- SQL Round
- How to get last date only once all have been filled in
- How to restrict evil create scripts?
- What is the correct sequence of Restoring databases in SQL Server 7.0
- SQL Server 2005 + SQL Server Express
- need some help
- Moving SQL installation to a new Partition
- On to Bulk Insert issues
- Need help adding 3rd table to a Join
- Error 22272: Cannot load the DLL xpstar.dll...
- understanding triggers
- Reporting No Records Found
- Script, Save, Export SQL 2005 Database Diagrams
- SQL-SERVER - APPEND from different databse's table
- Supress Column names in the output
- Table structure and data transfer from SQL2000 to Access (.mdb)
- Understanding constraints and binding
- How to implement a foreign key
- Move from SBS2003 MSDE to MS SQL 2005 Express
- How to recover deleted data from master database
- Update SQL from Excel - newbie question and a challange
- Tough query?
- MS-SQL Related
- Survey: Enterprise Architecture and Software Development
- SQL Server 2005 Express to SQL Server 2005 Standard
- trouble porting a trivially simple function - with declared variables
- 2005: cannot to connect from .NET
- Using SQL to append records to a table from a flat file using DTS
- Sql Server Hot backups (Clone/Fracture)
- Any help?
- Unable to Create a Maintenance Plan
- SQL Server 7.0 equiv of IDENTITY_CURRENT
- Help with Database Solution
- Help! Need to extract date/time from SQL database table
- OUTPUT and Recordset
- table owner
- Problem with cast error in adventureworks sample
- Count of records inside the records but based on distinct?
- loading data from text files
- SQL 6.5 upgrade to 2000
- Migrating data from DB2 to SQL Server
- What To Join?
- What To Join?
- Specify SQL2005 LogFiles Path on Install
- moved from ms sql 2000 to ms sql2005
- Insert Problem in MS SQL
- Starting
- Distributed Transaction Coordinator on SQL Server Cluster
- SQL Server 2005 and file systems, any recommendations
- passing tablename as parameter to function and to use it dynamically
- How to change owner for all tables in a database.
- ODBC readonly (viewonly) linked tables....
- More questions about porting from MySQL to MS SQL
- Reclaim disk space after DROP columns
- questions about keys - porting code from MySQL to MS-SQL
- SQL query
- Help! I'm using MS SQL Views
- Accessing SQL2005 as a Second Instance to SQL2000
- Compare Two Queries - Help
- Limitations in a query !!
- Problems when trying to build Connection to SQL Server Express from ASP.NET application
- Set time for UTC
- Previous day query
- Having Problem While Importing a Text File
- Select Statement Problem
- Why the memory usage of SqlServer doesn't go down
- Inserting a record using values from another Stored Procedure
- Recommendation os SQL Server Monitoring Tool
- Scrambled data in some fields
- Help with case when
- Allow NULL or Define DEFAULT Value
- i'm a newbe. please help
- Alter Table
- Reads and writes to a sql server database per table
- Very Small Numbers
- It proclaims of the Commandant in Boss Fidel Castro to the town of Cuba.
- Proclama del Comandante en Jefe Fidel Castro al pueblo de Cuba
- How to export xml in dts "Excute SQL Task" to a flat file
- Data Transfer
- Find which SPs have quoted_identifier set wrong
- Transposing rows to columns
- SQL Profiler hanging
- Problems when upgrading to sql server 2000 sp 4
- SQL 2005 Developer edition - install problems
- Satan and the evil
- Referencing colum names in recordset which is created by join - URGENT!
- FULLTEXT SEARCH any drawbacks??
- MS SQL & Visual Studio 2005
- Create Ranking Column
- Sorting with NULL
- Sorting with NULL
- Question about summing up different fields in different records
- 64-bit SQL 2000 Compatibility
- dts dynamic query & automap columns question
- AFTER INSERT trigger not firing in SQL 2005
- Index Computed Column?
- xp_cmdshell/DTEXEC in SSIS
- Delete Non System Table
- 2005: problem with Books Online
- optimising the following query
- Ordering results by order of the "IN' clause
- query optimisation
- Some issues regarding using MS SQL
- Yeartodate
- Working with NULLS
- Using xp_cmdshell to run application that uses domain credentials
- How to Access Query Anaylzer?
- [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
- select minimum between two values
- new to sql....can anybody help..
- Having problems calling a procedure which returns output variables from another proc.
- Calling all MSSQL 2005 Experts
- Use both DBs in cluster?
- BULK IMPORT Stress
- CPU spike with SQL Server 2005 Express Edition
- Query optimization via table properties?
- Searching a database
- Urgent -- Outer Join Problem
- Change monitor server settings for Transaction Log Shipping
- SqlServer View Tuning
- backup job hang
- Admin Version of WITH(UPDLOCK)?
- 2005: installing Business Intelligence
- create trigger or stored procedure in external DB?
- MS SQL 2005, .NET, logins/sec and page faults
- 2005: Service Broker?
- sp_who and Citrix
- delete particular rows in a table
- syntax error ALTER TABLE
- Deleting more duplicates
- Select query help+primary key
- DTS Import Update table.
- sp_change_secondary_role missing in SQL Server 2005?
- Linear Regression for column values
- 2005: BACKUP
- System event triggers
- Deleting a column DEFAULT....
- Problem with Insert Exec in nested SP
- Wanna create a table field name as 'Name'
- Help with an online game project
- Sql Inner Join..
- Encryption Password
- Text column data incomplete
- SQL 2005 - SQLDMO - Adding Logins/ Users
- Recreating/reloading system stored procedures
- SQL Statement - Join
- Replace Access with a .NET front end and SQL Backend solution.
- Question on QUOTED_IDENTIFIER
- The best way to display values from a CURSOR
- ms sql 2005
- Newcomer to the whole milieu
- ODBC Timeout - Where to start looking
- Cryptography API for MS SQL Server
- SQL7 Files and HardDrive issue. Please Help
- DTS export to Excel
- Urgent SQL7 ISSUE
- Reduce Table Size without deleting data
- SQL Generator
- Updating text containing æ,ø or å
- Scripting table with rows values
- MS SQL Caching
- Exporting data from SQL 2005 to Access
- Text Import Finding Table to Import to Problem
- Subquery Help
- Delete 2005 [user] schema?
- How to send an automated email when SQL Server 2000 is shutdown...
- select no. of rows from the current database
- Formatting text file using DTS Select/Export
- Conversion datetime to string
- 2005 Express Edition: installing full-text search
- Trigger Between Linked Server - DTC Issue
- query to populate child table
- not permitted in this context
- SQL Server 2005 Script Generation
- quicker way to create indexes
- Terminal Service Manager
- URGENT - Link server 2005 to 2000
- (2000) Unable to connect to debugger
- Second Transaction Log File
- LongestRunningQueries.vbs - Using a VB Script to show long-running queries, complete with query plans
- 2005: creating aggregate function from .NET assembly
- Book recommendations?
- What do you mean 'clustered' index?
- Server Components Can't Be Installed
- SQl Server 2005
- SQL Server
- sqldata dictionary
- Red-Gate SQL Log Explorer
- Table design request for comment. (Help please)
- need help regarding finding rows modifeid during certain time frame
- Column permission being ignored by Access Form Combo box
- Micro-pump is cool idea for future computer chips
- Remving duplicate rows and NULLS
- Fill Factor
- Automatic Import of Emails
- Size of Row
- Multiple files import
- Check if a Table is used in any sp or function
- Input string -> table -> output string?
- Query to find a missing number
- SQL 2000 Error: 1203, Severity: 20, State: 1 Error
- SQL Server 2005 Startup error - TDSSNIClient... error 0x5... code 0x51
- De-normalizing query
- problems with query
- Limits in SQL 2000
- Character find and replace
- SQL Server 2005 JDBC 1.1 integrated security question
- SQL Server 2005 SP1 install
- changing records in tables
- Cursor loop
- vba sql server connection
- 955585 - Limited Term Employee / Infrastructure...position at hewlett Packard
- Backup and Restore on different computer?
- Using Decimal as a Key
- Problem with INSERT Trigger
- How to get modified time of a table
- Reporting Services 2000 & 2005 on same machine
- Reporting Services 2000 & 2005 on same machine
- Transact-SQL SUM Help!
- Get all table names with a given column name
- Problem with stored procedure and retrieving inserted identity value
- Error OLE DB
- Problem with installing SQL Server
- 2005: using SMO
- 2005: Business Intelligence Development Studio?
- How to combine 2 records into 1 unique record
- Strange results from "not in" query
- SQL2005 SSIS - won't allow text delimiters
- Turn of logging on SQL maintenance plans
- 2005: calling .NET procedure
- Databse Link will not connect
- I HATE Management Studio, how about you?
- Search Char in SQL query
- BCP using ODBC - problem with unique identifier
- Need help with denormalizing query
- Smarter Table build - might split the table
- Newby DTS Question
- MS SQL database Transfer
- 2005 EE: using full-text indexing
- stored procedure question
- sending a parameter from an access database to a DTS package in sqlserver
- Hierarchy
- Query: union on self
- User Defined Data Types Problem
- key column information is insufficient or incorrect
- Northwind database extra SQL needs
- Make and save a blob on the fly in stored proc
- Need More SQL Query NewID Help
- OUTER JOIN not working?
- Delete statement for a list of items with multiple columns identifying primary key
- Insert Function Help
- ADS user and sql 2005
- 2005 Express: testing replication
- Hide SQL Server DB; 2005 version on Win 98
- pulling all dates within a date range
- Insert Subqueries
- Odd SQL IN usage?
- Design question related to Grouping
- exporting to CSV
- Access Sql server using Javascript
- 2005: forbidding INSERTs and DELETEs
- Please Help with SQL Query Problem
- Building an application on multiple data sources
- BEGINNER: simple Delete trigger
- sequence of columns and preformance
- MS-SQL one .NDF file missing How to Recover/Rebuild DB??
- Create trigger - do users need to be out?
- Bizarre Query
- Problem when changing Views
- Update unique records only help
- Consolidate information from multiple rows into one row
- SQL 2005: keeping track of database changes
- Empty recordsets and artificial records
- How application can detect node restoring?
- need programmer to build a dts...
- to find a particular record set is present or not?
- Querying Windows Active Directory from Sql Server 2000
- Querying Windows Active Directory from Sql Server 2000
- comma separated values to stored procedures
- Announcing Yellowfin Version 2.5 release for SQL server based users
- SQL server 2000 timeout
- How to move transaction logs on-line?
- attach db MS SQL 2000 .BAK with enterprise manager
- multiple rows and columns MAX
- Getting Count(*) From Left side of Join using WHERE on right side of join
- How can I do a exact wording search?
- OR in the WHERE Clause?
- why don't group by work????
- memory usage/allocation/paging question
- Returning the newest rows
- conversion from Access query to mssql query
- SPROC won't execute - insufficient permissions
- Does anyone know of a tool that allows a SQL Server database to be
- inserting into two tables and transaction problem
- Sending email (recipients)
- SQL Server 2005 Express
- Export Image Data Types to Local PC from SQL Database
- Update statement, then insert what wasn't available to be updated.
- left() and right() function in MS SQL vs MS ACCESS
- Calling a SP inside a cursor loop..
- Calling a SP inside a cursor loop..
- Problem with Composite PK
- Select multiple rows into one row, MS SQL
- Differences between SQL2000 Dev. Edition & SQL2005 Dev. Edition
- mysql database session management with cj tracking
- MS Excel to MS SQL
- Insert trigger
- Need help with this select statement
- How to get rank?
- SQLserver on SBS2003 returns old data
- constraint expression for unique keys
- how/what should be the query for this result
- Datareader concepts to access SQL Server data using datareader.
- Scheduling of snapshot agent
- right padding equivalent
- Help With Syntax
- MS SQL date range and average
- sorting twice?!
- Problem on SELECT statement
- Combining 2 tables with date ranges
- dbcc reindex issue - - I don't understand!!
- Have Insert statement, need equivalent Update.
- SELECT statement help
- Developer Edition having issues connecting to server via TCP/IP
- "Sql Server 2005 Developer"
- need tool for managing database object ownership
- pulling progress data
- Enumerate databases
- trigger question
- "Ghost" primary key column
- I have a question With Related to performence
- The single OS nature of MS SQL
- EXcel sheet into database with stored procedure
- Network error IOException: Could not create socket (SQLState: 08S01)
- Insertion and Updates on 20.000.000 tuples table.
- Deleted "old" transaction logs = (no items) in EM. How to recover?
- Help.... This doesn't make sense...
- Access Query against SQL Server works only without criteria
- RUN SQL Stored Procedure in Access
- The identifier that starts with...is too long. Maximum length is 128
- 2 foreign keys to the same table - multitable selection query problem
- SQL Server Error "Missing end comment mark"
- SuperSocket Info: Bind failed on TCP port 1433
- Help sending email
- Separate databases for high/low transaction volumes?
- Speed up UDF
- SQL to Oracle update trigger fails due to distributed transaction error 7391
- What is Your Strategy for Upgrade an Access db to SQL Server 2000?
- Very Poor Performance - Identical DBs but Different Performance
- Query with Joins problem
- Extremely Poor Query Performance - Identical DBs Different Performance
- Comparison operator in Select list
- isql changes null behaviour in mssql 2000
- SQL Server 2005 and Cursors
- setup multiple SQL server listeners on one machine
- SQL server replication from non-clustered database servers
- Help with SQL Statement to find first and last populated field in string of fields
- Sql Server 2005 questions regarding editing views
- Ambiguous Column Names in Multi-Table Join
- Problem joining child data (JOIN, subquery, or something else?)
- Unable to reinstall Enterprise Manager from original disk: service pack rejected
- Ms Access to SQL
- Database name with point in it (mail.archive.mdf) not recognised in query analyser of SQL 2000
- MSSQL/Related to XML Query
- For Xml Explicit//mssql
- Concat ??
- Ms Access upload to SQL Server 2005 BE & Sharepoint FE
- One Database vs. Multiple Databases
- Web FE & SQL BE
- T-SQL Problem - should I use the "ALL" clause?
- SQL 2005: creating "correct" and "incorrect" versions of a database
- encryption in sql server 2005
- Datatype-convertion in TSQL
- Error: 16954, Severity: 10, State: 1 and Timeout problem
- SQLDMO - Getting 'Local' Server name
- Creating Cursor from Stored Procedure
- SQL 2005 - Disappearing Relationships in DB Diagram
- help for shrinking database
- Sequence generator
- DTS copies from SQL Server to MySQL on Windows.
- group by
- SQL Server 2005 Hash Partitioning?
- Left Join variable not valid
- SQL Join
- ISP Driver Error?Line: 131 of /ips_kernel/class_db_mysql.php
- Cannot remove dbo rights from a user
- Rebuild index issue - - strange
- Connecting Sql Server 2005 from ASP?
- How to FAST and EASY ENCRYPTION ALL Stored Procedure in my MS-SQL Database ?
- Sybase driver and MSSQL 2k
- MS SQL 2000 SP4 Error: 1038
- How can I get all records for both tables with the latest begin date if exists?
- Stored Proc Question : Why If Exisits...Drop...Create Proc?
- Copy text columns to nvarchar
- Assistance building a query...
- SQL0440N error in Stored Procedure........
- Calling another record into this record
- how to conver number to string
- Debugging in Query Analyser
- Are we going right?
- out of order identity field - sql2000
- Results in Parallel columns
- output the latest date for each foreign key
- output the latest date for each foreign key
- getting the most latest date
- Authentication
- PArse syslog message into data fields
- Create Procedure in an IF block?
- Stored Procedure Issue - Problem with temporary tables
- Performance issue
- enterprise manager (or other software) to document tables and columns for Server2k?
- 2 different foreign keys in one table
- How to create SQL Server Express server (INSTANCENAME) programmatically?
- backup of transaction log
- Perfomance Question
- SQL server backup and truncate log file
- how to specify the column name
- A floating point exception occurred in the user process - Msg 3628
- 2005: Database cannot be opened
- Indexing strategy
- Real newbie on SQL ....Know list database and table in SQL Server
- use result set returned by sp as derived table
- MIN(Count(*))
- Create XML in ASP.NET 2.0 then use for joined table in SQL Server 2005 Stored Procedure
- SQLDataset.WriteXml and filtering bad characters
- output parameters
- A basic question: Removing duplicate results from Max function
- Project Management Interview Questions June 5th, 2006
- Maintaining variable values
- Most efficient way to run update query
- if-then in select stmnt
- collation SQL_EBCDIC037_CP1_CS_AS
- Importing data into MS SQL 2000 from XML file