View Full Version : answers
- union query taken more time
- Need to shrink the size of log file
- System.data.sqlclient.sqlerror: cannot open backup device 'DLT VS80(\\.\Tape0)'.
- Help with Subquery
- Data base encodings
- Sum result of a Select
- Help with SQL IF
- Using the same column in bother SUM and ORDER BY? How?
- textcopy binary transfer fails on certain files
- Viewing backup in a different location
- Using CTE Common Common Table Expressions
- Insert into a table that has identity column
- SQL CASE Statements with IF EXISTS
- Migrating SQL 2000 to SQL 2005
- MS SQL Linked Servers(Linking MySQL to MS SQL) Collation problem.
- SQL Joins
- Reduce field data Length
- SQL Joins
- executing a query
- Foreign Key
- Need some help with query
- Welcome to the -Net User Group
- Welcome to the -Net User Group
- Welcome to the -Net User Group
- Win2003 / Sql2000 Memory usage
- Can SQL Lose Records?
- Help with a simple query
- Read Backup File Directly?
- SQL Duplicate Error
- User ip tracking
- Building Table for Duplicate Records
- How to use two pivot columns in a single querry
- Microsoft OLE DB Provider for SQL Server error '80004005'
- How to manipulate records using SQL
- SQL - how to - minimum number of steps
- automatic restoration
- Update a column
- can someone help me pls
- how to ignore time and get only date in a query?
- Help
- passing arguments to a trigger
- I need to find the rows that exist in one table but not in the other with condition
- Solution needed
- Creating table in linked server
- How to export/import database
- Problem mapping SQL Server mobile and Visual Studio 2005 Dataset
- SQL 2005 Function to Convert Dotted IPs to Long IP Format?
- Why won't MS SQL allow nullable primary key components?
- How to get the error message rather than the code error
- looking for DBA/ Database Developer with experience in Microsoft SQL Server Montreal, QC
- sql string
- how to make an Update trigger capture the foreign key text value
- Max value in SQL runtime
- Separating Address Field into Multiple Fields
- Req DOTNET Developer
- Alter existing table to add a IDENTITY column
- how to delete rows using linked server
- DateTime
- how do i know who accessed/ran a procedure or query
- Date Range
- NEED TO GO FASTER
- Search: CONTAINSTABLE
- Web Server Can't Connect to Sql Server
- how to compare 5-10 chars from 2 tables.
- Improving SELECT statement
- Hiding the Database list from a certain user\group
- Delete an excel worksheet only if it exists, in a dts package
- tlog size
- How To Connect Sql Server 2000 From Java
- mdac 2.8 and sql 2005 cursor performace issue
- tlog backup
- UDF for a complex calculation
- JSQLConnect MS SQL SERVER CONNECTION ISSUE
- converting char date value in date value
- Multi access in SQL Server
- T-SQL Pivot type of problem plus AVG
- Simple SQL Query need Help
- sql server 2000 connection fail
- Parameter for Stored Procedure
- How to conver 24 Hrs. time into 12 Hrs. time
- Simple SQL Query Need Help
- Help with database design.
- Help
- DB2 Viper 2 beta - Compatibility features, Need your help
- deadlock help please
- Go Through Each Row in Trigger
- Help with Setting up a SQL Insert Statment, from a web form
- timing out error
- Characters not allowed in SQL varchar?
- need an sql query for the following situation
- Turkish character problem in stored procedure
- T-sql
- Windows/Linux
- Windows/Linux
- Sleeping Status
- sp_columns
- work day fields?
- Dynamic database selection?
- how to implement fuzzy search using soundex in SQL SERVER 2005!
- Error handling with CREATE INDEX
- SQL 2005 error: Replication-Replication Distribution Subsystem: agent (null) failed.
- Syntax for storing query results from one server to another server
- update one colum with other column value in same table using update table statement
- Loose connection in vpn enviroment
- how to retrieve the value of a primary key
- Using SSIS to backup/restore databases
- Debugging SQL 2005 SP
- Select all tables in a database
- Problem in creating foreign key when .....in sql server 2005...pls help.thanxs
- Full text indexing on Encrypted columns
- Calculations in Database
- SSIS sp_send_dbmail
- maximum number of fields that can be created in a table
- Would like a stored proc to convert rtf field to text
- Move Images (BLOBs) from MSSQL to a folder
- many-to-many help
- Linking sql table in MS excess over dialup.
- Req:DOT NET Developer
- how to learn
- new
- how much bytes needed in sql server
- bcp_init and SQL Native Client
- Transaction (Process ID 474 ) Deadlock
- transfer a value from one table to another
- Question about simple query..
- Error converting data type varchar to numeric.
- Modification Logs
- how to update foreign key while primary is auto generate int
- Creating query that allows user to choose criteria to be used in one or another field
- how to convert dvd-binary data-url
- Remove the last carriage return and line feed from sql text field
- Dynamic RDLC generation question
- Visual Studio
- Deadlock within stored procedure - need help
- User configurable table designs
- Creating DTS Package to archive database from one sql server to another
- timeout expired
- How calculate space that occupied?
- MSSQL - DTS Package - Find distinct rows - Output to TXT file - ActiveX?
- MSSQL - DTS Package - Find distinct rows - Output to TXT file - ActiveX
- Dynamic SQL and NewID function - pulling random records
- UPDATETEXT, WRITETEXT
- Stored Procedure Local Variables
- Trigger problem
- Duplicate table
- Can't Edit Maintenance Plan
- Can't connect to SSIS
- How do I execute a .sql file from command promt
- Establishing Precedence In ORDERBY Condition Causing Problems.
- MSSQL Insert Permissions
- sqlserver.exe-Applicatyion Error
- database security
- Local Admin Rights Needed to Use DSNs on W2K3 Server?
- Query help?
- can we use stored procedure inside trigger?
- hi all
- TSQL coding style - an example
- parentheses in a check constraint
- Lock Error
- Download Subform Alternate Colored Rows
- SQL Server 2005 with VB.net 2005
- How to Gnerate a Random ID Number
- Searching Binary data from sql server 2005
- Error: Must declare the scalar variable
- How to list tables with Primary keys
- Bulk Additions & Updates in SQL 2000/2005
- SQL 2005 Upgrade on a 64 bit machine
- WHAT HAPPENED?
- difference between MSDE and SQL SERVER 2000
- ALTER how long should it take?
- SQL Changing the Result from blank to something
- finding mismatched rows between identical tables based on 2 or more cols
- Database Design Question
- A binary field problem
- Syntax error in string in query expression
- Connection string to SQL Server database
- Build a Data Cube?
- Sql server security problem
- Login failed for user 'DomainName\shhi'. [SQLSTATE 28000] (Error 18456).
- In implicit conversions between char & varchar, are indexes used?
- execute a query command string
- Changing Datatypes
- SQL 2005 trigger Help
- SQL 2005 : AFTER INSERT - Trigger
- Error: Not associated with a trusted SQL Server connection
- Computed Column specification formula
- hierarchical selection within a select statment
- SQL Server and Net Apps
- Domain Change on SQL 2000
- float storage and usage
- how to quit an sproc
- Change name of exported csv file
- HELP NEEDED
- Unable to schedule DTS
- how to access a sql server 2005 which as by default windows authentication
- Order by Issue in SQL Code while using temporary tables.. ?
- MYSQL to MSSQL or vice versa
- Linux Servers
- Linux Server(Verified)
- Turn off "Documentation Feedback" section of BO for printing?
- Update query not working
- Strange character in column
- xml as sql script ?
- How To Script
- SQL 2K Combining similiar rows without creating temp table?
- Using SQL in VB
- Clustering SQL
- Problem looping through excel workbooks(sheets) in a excel file in ssis
- Full Text Indexing (job)
- Merge two exact tables
- find server name using query
- Linux Servers(Usage)
- Deadlock
- Extract text from fixed-length text rows to SQL table
- best way to add column not null
- How to pass table temp to DLL COM
- Openquery & Local Table
- Data import definition
- Help connecting pages which has Database connection.
- Returning different table results based upon variable
- SQLServer Table Partitioning
- Linking 2 Databases
- CASE statement advice needed
- Maintenance Plan Database Selection
- Linked Server, ODBC, OPENQUERY, Collation and Network Traffic
- How to?
- Problem with foreign key
- Bulk insert data conversion error (truncation) for row 1
- procedure using cursors
- Sub Query Help
- jdbc createConnection(String url) throws exception
- Restore Database Fails
- Nulls in columns additions when 1 or more column values is blank
- Copy Row Of Data From Table to Table In Same DB
- DTS import with dashes in source data
- Database Infrastructure Failover Capability
- ADODB Command (Stored Procedure)
- INVALID LENGTH PARAMETER PASSED....
- Reset Primary ID back to 1
- Failure Audit - MSSQLSERVER EventID 18456
- How to install SQL Server Schema (.sql) from remote machine
- Not Equal To
- Set Numeric_roundabort { On | Off }
- Dowt in create View
- Problem with inserted tuple in triggers
- How to Format date without "Convert " function in T-SQL
- Image Datatype in Sql Server
- Database connecytivity from ASP using IP address
- Db Design for Matrix Lookup
- escaping data for update query
- Converting Integers to DateTime
- My ms sqlserver database is in suspected state how to recover or restore it
- HCL hiring IT professionals -Chennai/Noida/Gurgaon/Bangalore
- How to format numbers in SQL Query
- SQLserver Image filter
- Updating Table syntax
- use array for storing multiple data
- dbinit(), dblogin(), how often?
- ANNOUNCE: Release 3 of Altova v2007 XML software available
- Problems backing up SQL DB.
- Copy rows across to another db
- Hi Here Nasir
- Update & Merge MultiDB into Single DB - Do this as a Routine - Weekly
- SQL Server error '80040e31': please help me!
- problem connecting to sql database
- ntext problem
- dbinit(), dblogin(), how often?
- Help on Partitioning column was not found.
- PACKAGESTART / PACKAGEEND In SSIS
- Is there a maximum perameter set for sql server?
- SQL connection logs
- merge rows of data within a table
- DTS w/ Oracle Issue
- insert into using a sub select apostrophe issue
- RebuildLog
- How to distinguish operation type in trigger?
- Locking Select queries on rows
- Count of is null of datetime field
- Programming a Dashboard using SQL
- Dynamic Granting of Insert Permissions?
- How to send email through stored procedure
- Nearest time from 3rd record
- SQLSTATE=42601 error
- Slow Query Processing
- connection to sql server
- Forcing a join
- Conversion from MSSQL 2000 to MSSQL 2005
- SQL Enterprise Manager - Not very usefull tool for building views
- OLE DB Error
- Book recall
- URGENT: Cascading Parameters in SQL Server Reporting Services 2005
- Select Most Recent Record for all Customer IDs
- sorting table while inserting
- Cross-database ownership chaining in SQL 2005
- MS Sql 2003 problems - HELP!
- Mssql New Shell
- Escaping international (unicode) characters in string
- What do you think about the checksum function ?
- Merging Dataset into exisitng SQL DB
- Sql query help
- sql query
- Transpose column into rows
- needed: 1 + null = 1
- Calling Function From Stored Procdure ???
- hi,need help.....
- sql server2000 a problem
- How to import/export dump file from command prompt in SQLServer
- Is SQL Server 2005 backward compatible with SQL Server 2000
- Trigger Problem
- Urgent - Strange Problem With Stored Procedure
- How To Take Copy of SQLSERVER 2005 DataBase
- Char or varchar for a primary key?
- Slow Query Processing
- Automatic Email Sending to multiple Email addresses
- Information about sql server
- problem with Stored procedure ,Please help
- Tracking when a Trigger runs... MS SQL
- Custom Software Development
- Moving database back to its original position
- uploading image files
- Database design
- Trigger problem
- Need Help with a SQL Statement - Trying not to use a Cursor
- Storing 2 instants of contact in a seperate table
- transfer users' telephone numbers from sql database to active directory users
- SQLExpress
- MS SQL Linked server - error on connection
- Use CVS server with SQL Server
- WHERE statement - need to check if Cell is blank
- Cluster IP address change and delay
- T-SQL automatic resizing of columns in table
- How to find Double Majors in a statement
- Any Input: Converting from Sybase to SQL
- Remove neighbouring duplicates
- Password Changed. udl refused to work
- Query result sent via e-mail
- summing up values in each record
- Synchronous Bulk-Copy into two table
- Converting Assertion to a code in sql server 2005
- Earliest Date from Common IDs
- DTS - send mail task fails
- SUM a range of records from a fixed DATE in the DB
- Selecting data from two databases within MSSQL
- SUBSTRING in User Defined Function - Invalid column
- Decimal Format
- How to copy data of Sqlserver 2000 to MySql
- Become MCSD Certified
- Question about Transaction isolation level="readCommitted"
- Select top (7 - (datepart(weekday, Fordate))) from table1
- hourly average help
- Installing Sql server 8
- Error in upgrade process
- Whats the use of creating the index
- Finding values containing milli seconds!
- Duplicate key insertion error when concurrent users insert same data into table
- query on procedure
- Invalid object name 'Product'.
- Sql server 6.5 Enterprise Edtn Installation
- Collection of All SQL Commands
- Accessing SQL Server 2005 via Scheduled Task
- [Microsoft][ODBC SQL Server Driver]Restricted data type attribute violation
- Stored Procdures
- Stored Procdures MS SQL
- SQL 2005 and Scheduled Tasks
- Sql server 6.5 Enterprise Edtn Installation
- Transaction log and tempdb
- Transaction log and tempdb
- Transaction log and tempdb
- Transaction log and tempdb
- Transaction log and tempdb
- constructing strings from table
- SQl server 6.5 Enterprise Edtn. Installation steps
- Sql server 6.5 Enterprise Edtn Installation
- Transaction log and tempdb
- view of max values from many tables
- Transaction log and tempdb
- export data from Sql table to xml file example please
- how can i access SQL 2005 OLAP Service
- To get the Child query for TreeView in .NET
- how can i access SQL 2005 OLAP Service
- SQL 2005 OLAP Service
- Using local VAR as FILENAME in CREATE DB Statement
- Getting Result of query inside another query
- Write a Script as Varchar Parameter in Stored Procedure
- Return data from multiple tables
- Uniccode Data trasformation from text file to a table
- how to setup a server?
- Inserting multiple rows with a single INSERT query
- How to choose SQL Collation for multi language
- Need help with converting Access Query to MSDE
- Bulk insert, skip rows with duplicate key error?
- SQL Query to insert data to a table
- self referential database table
- Help for Ordering the rows
- Transaction log file size - does it do any harm?
- help query sql server 2005
- Migration from MSSQL Server Reporting Services to OracleReports 10g.
- Excel based query for SQL-data extraction to excel
- Backing up a DB @ a Hosting Company
- JOB POSTING: Looking for a senior database manager /department head/ architecture
- Is it possible to change login of 'dbo'
- Trigger
- Moving SQL Server 2005 databases
- Syscomments system table limitation
- Trigger problem while updating
- SQL Log.ldf files reading
- is there a way using sqlexpress to review the most recent set of sql commands submitted to a database?
- Multiple values into single cell
- Run DTS within a DTS
- Microsoft SQL Server DBA's required immediately
- How to attach a MS SQL 2005 database (.mdf) file to MS SQL 2000
- SQL server 2005 express import and export
- SQL Query Error Help
- SQL Server Case
- Server Hardware
- SQL Server 2005 - > = 0 is not the same as > 0?
- Insert into problem
- Optimalization - SELECT tatement
- DTS package executing a stored proc
- Automatic Database Backup
- SQL Server 2000 - Recover Database using only File System Backup
- Hi Friends, JOB ID: SB 0501 >>> Urgent req for SQL/.NET
- SQL server 2000 - database problem
- join reducing selected data in undesired way
- SQL Server 2005 SSIS Progress Question
- SQL Code for todays date -90 days
- SqlServer 2005: How *best* to copy one database to another
- SqlServer 2005: Importing Data: Idenitity fields getting made into non-identities
- Query LDAP camUserClasses via SQL Server
- SQL Server Case Syntax
- Case Syntax
- create constraint error
- Search for a table/string within job steps, dts, database, stored procedures etc
- how to if needed recover from mistake
- Is there any array or collections in sql server.
- Can one create a view in MS SQL across databases
- Why is the trigger locking the table?
- INSERT INTO sporadically fails - suggestions for possible reasons?
- Count Rows Help
- How to fix error 207 in ms sql server 2000
- Query Help
- SQL Triggers and stored procedures
- Composite Foreign Key
- select 'message'; not appearing
- Issue with Multiple Foreign Keys in MSSQL 2005
- updatig sys.indexes
- Accessing Remote Stored Procedures using SQLExpress
- Extracting data in SQL server using crystal report
- Problem with NOT EXISTS
- approach to creating a procedure that contains dll , dml to upgrade a system
- sorting table
- sorting table
- 2 IDs profiles from one table
- MSSQL
- SQL server? MySQL server?
- unique filed
- /usr/sbin/mysqld: unknown variable 'expire_logs_days=10'
- i am not able to connect sql server 2000
- Database Owner cannot connect
- How to execute all rows in a dynamic query
- Get last 5 digits of a 16 digit number - How?
- So you think your database is secure? Think again.
- TRIGGER after UPDATE
- Runtime Error 800a100c!!!!!!!!
- Want to make ''Get Latest Status'' function more efficient
- UNION SELECT from Multiple Subselects
- Subquery returned more than 1 value. This is not permitted when the subquery follows
- Subquery returned more than 1 value. This is not permitted when the subquery follows
- Passing Parameter Using 'IN'
- selecting from 3 different tables
- Match exact phrase
- Run same query for each day across a date range?
- Select trigger?
- Moving,Updating and Mergeing in to Single SQL database
- Need Some SqlServer Help
- Match field and return to "1"
- Invalid use of Is operator in query expression 'product is is_clearence=1 and is_visi
- Help parsing field
- Delta between current and previous row of select
- Incorrect Syntax near WHERE
- Scoring of returned results with OR
- SQL SERVER _ FirePrograms
- So you think your database is secure!?
- 5-table SELECT giving me problems
- Reading SHOW_PLAN output
- Date Issue
- Stored procedure with if condition on column names
- Datetime in Where clause.
- How does UPDATE statement work?
- delete redundant data
- Check Box Value has changed
- PROBLEM using CharIndex(), IF, OR etc- PLEASE HELP
- Memo field not found
- Passing a Parameter through an OpenRowSet
- Error 21776 when I change the sa password in sql server 2000
- Date function
- SQL Server 2000 only using 2GB of 16GB of memory
- connecting to Sql Server
- Last Day Of Previous Month...with a twist
- Combine values
- Stored Procedure Times Out from Web Application
- Xcopy
- Need help in printing the Crystal report in PDF format
- Format expression
- DBCC INPUTBUFFER results into table
- How Import XML file in a table with trigger.
- Bulk import a complex XML to SQL2005
- calculate commision amount
- DB restore question
- Narrowed Down Search
- Changing license mode
- MS SQL Trigger Handling Multiple Inserts Question
- Authentication issue
- SQL 2005 Job Type subsystem is missing
- Number of columns in Database
- Output result of query to existing file
- How to resolve SQL Server Deadlock
- MS Sql 2000 unable to use query analyser
- Need help with concatenate Text data field
- SQL Query Help
- SQL Server 2005 / securityadmin role / SSMS
- Extremely Unusual Connection Problem
- Web Front End for DTS
- how to identify special characters with a single case statement
- Inserting ntext into another ntext
- Loading data from xml http stream
- sql2005/BIDS: getting error 102 with CTE in dynamic query expression
- SQL Server 2000 Backup and Restore, Need help!
- JPEGs into image column
- List of all available sql servers...
- new line
- Urgent Help
- modifying column 'ID'
- Sql Server query
- Find out last day of the month
- Fix Failure result due to no records found
- Problem with: Greak characters, superscripts and subscripts
- SQL Display Null Values
- intersect problem!!
- Update a Column
- stock control, procedures
- Memory Leak in Application running in SQL Server 2005
- Update text for a subset of Records
- Sorting money with SQL and ASP.NET
- Single user mode for Checkdb doesn't work
- SQL 2K5 beta 2 setup problem...
- Stored Procedure Help For Join Query
- MSSQL to Access (SQL Query)
- unique constraint on two tables?
- How to cancatenate the rows returned by a table-valued function in a sql statement