View Full Version : MS SQL
- Write conflict on SQL 2000 ODBC linked table
- Executing a job using TSQL or Stored procedure on SQL 2005 Express
- Specifying Columns in a Bulk Insert
- u just click u get some dollars
- Re: Queries Occasionally Slowing Down
- database size vs. its performance
- Re: Clustered Indexes, what actually happens when you rebuild one, does the optimiser love them?
- Database backup using Scheduled Tasks
- SqlDataReader on Sql 2005
- Bulk Insert with LINQ to SQL
- LINQ to SQL with bulk insert
- SP timing out, can't find the cause
- slow DNS caused extreme SQLS memory pressure+CPU?
- sql server 2005 express problem wtih {7twud62389sdksdk} the like
- How to determin if current computer has functioning sql sever(s)installed?
- How add rows to table in Microsoft SQL 2008 Server
- Finding a way to avoid joins/inner selects
- How do I detect a local temp table
- ssis - Where is the sql?
- Re: Select with many to one relationship
- Precision in a REAL data type
- new blog
- Re: A dynamic table to be made into excel file
- Seeking Simple Tutorial for Connecting to SQL via C++ (VS2005)
- how to generate the following output in sql ?
- copy data from one server to another
- Re: CREDIT CARD SERVISES
- Exporting data
- IBM X336 server with RAID1 configuration formats all HDDs on newhardware installation
- A dynamic table to be made into excel file
- SQL STATE 22003: Numeric value out of range with TIME data type
- odd SqlInfoMessageEventHandler problem (source code provided)
- variables in SSIS
- Security for server tables on SQL 2000.
- test-sanderson@eliteinvestment.net
- Aborting a stored procedure?
- Datetime comparison problem
- point-in-time vs. shadow tables for audit history
- Linked Servers
- Performance: Conditions in WHERE clause vs. conditions in INNER JOIN?
- Displaying time from Datetime datatype
- Build a search query based on multiple userinput from textboxes
- SQL query question #2
- SQL query question #2
- Can't get "<>" (not equals) to work in view
- default schema resolution for user-defined functions?
- Maximize sql window in SSMS?
- SQL query question
- AntiVirus recommendation for SQL 2008
- How to compare two different columns in two different rows.
- Where clause
- Remove Seconds from Datetime: How To?
- To unicode or not?
- How to store big Arrays
- Create UDDT - good idea?
- Verify backup after the backup is completed
- Succinct way to return logical condition as column?
- DataServices World (November 20): SOA, WOA, cloud computing andfuture of database
- REALLY REALLY FUNDAMENTAL QUESTION....Response would be greatly appreciated
- spam
- Intellisense not working
- Selectively Executing Interactive SQL in Management Studio
- Yellowfin Enhances Business Intelligence Reporting forTelecommunications
- Parameterize FROM clause in Stored Procedure: How To?
- Does (code) size matter?!?
- Concatenate float data type
- osql import inserting carriage returns?
- Managing data between CRM and Informix
- Trans log backup based on size rather than time?
- number of Connection for Linked Server
- Change SQL Server 2005 Express's default port programatically
- SRS Reports
- SQL 2005 Optimizer not optimizing
- How to find out what type of the data procedure in MSSQL 2005returns?
- dataGridview
- sql 2005 express command line instalation
- Custom and UserControls
- spam
- sql server cluster node rebuild failure :(
- BCP out image files not working
- Problem Entering Item Into A Table
- Stored procedure Question
- Datetime in sqlserver 2005
- Copy 2000 database to 2005 - cannot detach/attach
- Error 262 create database
- How to control number of users in a database?
- [Newbie Question] SSMS indexes
- T-SQL
- Stored procedure
- SSMS - setting root of Object Explorer
- Accessing the call stack via TSQL
- Application Roles and SQL Server 2005 - DDL?
- SQL Server Management Studio question
- easily repeatable index corruption in SQL Server 2000 (8.00.2050,post-sp4)
- Import/Export Wizard
- Performance/stability issues
- SQL 2005 management studio vs SQL 2008 express
- set default value
- How To Look At Chronological Series To Find the First Values GreaterThan Zero?
- Inconsistent results for SELECT SUM(<<real field>>) ...
- DateDiff Calculation - odd results
- Interview type Question
- SQL Express on dual processor server?
- How do i write Set based queries and avoid a cursor?
- Connection issue when trying to connect MS SQL SERVER from Linux
- copying from a table to a file
- Services not listed on Configuration Manager screen?
- SQLSVR 2005 SP2 / Shrink data file will not work
- Call for speakers for DataServices World in Silicon Valley closes September 26, 2008
- DTS package and new folder
- Trigger to Update Fields of Inserted Record
- SQL Server 2005 Profiler etc.
- Maintenance/Auditing Scripts for SQL Server
- SQL Server Agent Alert System - Operators?
- Standards for using Stored Procedures as an interface
- management tool express 2005
- data/schema comparison
- Error in Proc
- dividing return set into smaller sets
- spam
- selecting rows from a table
- datatable select
- I need a little cursor help
- Single server but multiple timezone database..
- Select Insert Deadlock
- using sp_helpdb and getting error
- FORMSOF Predicate: Need Plural, not Inflectional
- UDF using EXISTS help requested
- Customizing SQL Server 2005 Enterprise Manager colors depending ondatabase
- sp_executesql increases number of reads?
- How to read the xml and display using xslt from a DB in sql server2005
- Incorrect syntax near ','
- Incorrect syntax near ','
- Cannot find data type xml
- How to synch renamed NT account with SQL Server 2005
- Re: Datadevices
- Select Max() not working
- MS/SQL Developer--DTS--Contract--Detroit Area
- SQL Server 2000 Failover Cluster upgrade to SQL Server 2005
- ODBC mystery
- SPROC help for insert into from related records
- SQL Server 2005 copy objects
- Why Restore with Norecovery is incomplete?
- Re: Cannot Connect
- Sorting
- Passive Laddered Bonds: Table Structure?
- Location Intelligence where to from here?
- SQL 2000/2005 Transaction Log Reader Library
- Modified Proc
- logs
- ONLINE RESOURCE FOR HELP DESK SOFTWARE
- export relationships in SQL 2000
- TSQL Query
- SQL 2005 Management Studio/Express - Any differences
- Calculated fields...
- ODBC DSN connection fails from MS Access 2000 after SQL2005 mirrorfailover
- Microsoft's SQL Server and related products.
- SQL Server data dictionary
- How to use stored procedure parameter in sql-statement?
- Indexing Low Cardinality columns in a data warehouse scenario
- UPDATE query gives Incorrect Syntax error
- large data : how do you store multidimensional data ?
- DELETE only deleted 10000 records
- database problem
- Tweaking SQL to optimize the query execution plan
- Help Needed For writting a query (SQl Server 2005)
- How can I produce multiple output flat files from a single SQL filewith multiple SQL statements?
- SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?
- Different empty_string/NULL handling under ODBC and OLE DB?
- Project Management Knowledge Base !
- sql squeries
- Query with different WHERE clauses
- sql queries
- Truncate text in table? (ie 101928494 will become 928494)
- SQL Server 2008 Final release date
- relationship
- sql queries
- not showing proper datetime in tables
- sql server queries
- plz suggest me the query
- IT auditing tool SC Magazine Review
- Creative query assistance needed
- How to find out difference between two rows....
- SQL Server Engine Downgrade
- SQL 2000: Transport-level error on SELECT statement
- dropped tables
- Trying to insert a zero, its telling me i cannot insert a null
- A Question on query efficiency
- How to deploy a database on SQL Server Express 2005
- Can Analysis Server and Report Server run on SQL Server 2000 Cluster
- Jobs, Interview Questions, Certification, Knowledge
- Re: SQL Server 2008 caching
- Re: SQL Server 2008 caching
- select blocking sessions t-sql
- Write "Messages" window to a log file?
- Deduping
- Yellowfin seeks resellers for BI product
- load_file and blobs
- Using a Trigger to determine when a column was changed
- Data returned by SQL Server ODBC driver is not correct
- Certification in Mind???
- Only 90MB for SQL Server 2005 on a Windows 2003 64bit 12GB System
- Finding duplicate records
- SQL 2000 DTS tool - 256 char limit?
- Linking Windows SQL Login to user database
- Calling Commonly Used SQL (reusable code)
- Export to Excel, exclude header
- Can a dropped table be recovered?
- How to show field that not being group
- Softclarity Builder
- Accepting wildcards like % in input parameters of stored procedures
- Distinct Row based on description count
- Re: problem with column alias
- Re: problem with column alias
- just u click make a money online
- Having problems using BCP for CSV output
- Re: ALTER proc vs IF EXISTS DROP/CREATE
- ALTER proc vs IF EXISTS DROP/CREATE
- Delete Trigger
- Intrusion Detection Strategies
- SQL Server Scripting Question
- sql server query problem
- Insert Into Select trouble
- SNL Sql
- ms sql 2000 - create update script
- SQL Query for Dummies
- CONVERT() problem
- Latest updates in database management and SQL server tools andtechniques
- Da MySQL a SQL express
- T-Sql & Active Directory Roles, Identification of original login ofimpersonated ID's and Suspended processing
- unable to install SQL Server 2005
- Re: Best practice on nullability and default value
- Formatting datetime when including in a PRINT command etc...
- Pb to open an attached mdf file
- Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
- Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
- Patch for KB948110 causing random "Could not find database table ID"errors
- Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
- How to compile TPC-H ver2.7 on Windows XP?
- complicated query (where statement inside select statement, don'tknow how to explain it)
- Insurance data models...any tips on good starting point?
- Are Deadlocks inevitable ?
- Help With Full Text Search. Performing AND across columns
- rupdating duplicate entries with random numbers
- Changing the name in the ServerName column
- Schedule a Query
- Multiple attribute design that need to be searchable
- Multiple attribute design that need to be searchable
- Sql Server 2005 Replication
- does this backup sequence commit all data to the database
- SQL problem - a variation on outer join
- BACKUP LOG questions
- Could not execute a package by a scheduled job
- dbcc shrinkdatabase
- Testing
- DB Structure Advice - lots of measurements in DB or file refs?
- programmatically stopping and starting transactional replication
- login failed
- Data loss importing from Excel
- transaction log
- How do I number an output field consecutively?
- Database management and latest updates on SQL server
- Re: [ANNOUNCE] Release 1.3 of Mogwai ERDesignerNG available
- Cursor among several databases
- design issues with large amounts of data
- SELECTing from a DML statement
- Using UPDATE to sequentially abbreviate address information
- Odd character appended to data
- Datetime import/export issue
- Yellowfin Business Intelligence Release 4.0 Announced to Industry
- slow queries for a particular database
- sql agent JOB to Backup Database and Maintain Backup Files
- Need a script to recreate scheduled jobs
- Help needed for Data formatting.
- How can I do that using a trigger
- OLEDB configuration when deploying multiple SSIS packages
- Decimal point and comma
- Re: Stop hotlinking to a specific file & keeping a counter
- Please Help - Can't check for duplicates
- Deploying an app with SQL Server (installation on client machine)
- How to secure a database ...?
- Can I search for a string in a set of stored procedures?
- GROUP BY a computed column
- Creating a database from set of TSQLl files
- Concatenate in MSSQL
- Storing BLOBs outside database
- Re: Duplicate Tests - Help Please
- Re: Grouping by Day for a Date Range
- Question about recompiling a dll
- table naming convention about this case..
- Latest updates on SQL server 2008 tools and techniques
- Computing a column that is a percentage of the sum of another column
- Database security (non-existent?)
- Tool to chase down the consequences of adding field to DB tables?
- Applying tranaction log to old data file
- Re: Database naming conventions?
- Latin1_General_BIN comparing two char strings
- alter table query not working after working at least once. MS SQL2000
- Re: Database naming conventions?
- Re: Database naming conventions?
- Transact-SQL for Restore Filelistonly using a variable
- Toad for MSSQL problem: closing script file doesn't "release" thefile?
- bcp out in UTF-8 format
- Kuljetusalan ongelmista
- Basic SQL Statement Question
- Differences between relational DB and warehouse ?
- tbl_A CROSS JOIN top 1000 rows of tbl_B?
- bcp out empty string into csv files
- C++ API for SQL Server?
- SQL 2008 EULA and pricing
- SqlBulkCopy.WriteToServer() blowing up on tables with Identitycolumns
- Performing multiple bulkcopies for different tabels
- stored proc with datetime
- Forget about Referential checks??
- Re: Not finding GUID value after migration sql 2005 to 2000
- bulk insert in clustered index table
- Re: Vaalirahoitus (oli: Re: Irlanti pelastaa Suomen)
- database design
- Re: Not finding GUID value after migration sql 2005 to 2000
- DB migration
- Newbie basic questions
- HCL, Aricent, Infosys and many more companies hiring fresh &experienced engineers ,
- Anyway to declare and use variables in a View
- MSDE upgraded to SP4 but showing SP2
- Select from a access table
- Migration of an Access Database. How is the best way?
- Problem connecting to SQL Server from Access Database
- simple SQL engine
- Fuzzy logic for duplicate identification?
- Full text search in albanian
- database owner?
- Convert Int to Date
- IF within SELECT
- live online training
- Re: "Maksanhierontalaite" ; )
- Problem With View and Changing Field Length
- stored procs
- Looping Through the Records returned from a DTS Lookup
- Snap-in failed to initalize.
- Compound vs Simple Indexes
- Re: Ruuska
- Not an ad hoc query?
- Stored Procedures and Commiting Data
- Connect problem
- Dell c610
- Re: search pyrkii nettiin
- Using Case within Select
- SQL 2005 report deploy issue
- Is this a correct table structure for my database?
- How to find if instance is cluster or non-cluster
- SQL Server 2008 - Filestream
- Error running DTS script in VB
- SQL->RDF? Best question about semantics technology wins admission to LinkedData Planet
- How do do a query against hardcoded row values
- Need SQL Server Dasbase Admin
- simple ALTER Table query question...SQL 2000.
- Disabling Triggers
- Installing sql server 2000 on windows server 2008
- Update Query Runs Forever
- Re: Outer joins in MS SQL 2005: why is it this way? better yet, any resources on these nuances?
- How to sell sql skills? (Need your knowledge and thoughts)
- (Newbie) Join problem.
- Problem with joins in SQL.
- where do I download sql odbc drivers from?
- Re: Connection pooling issue with pass through queries
- Join zero padded char to varchar
- Re: Connection pooling issue with pass through queries
- Re: Strange select
- Re: Strange select
- Re: Need Help With an Update Script
- strange Problem
- your thoughts on this please
- SQL Server 2000 UDF Intermittent Slow Execution
- Sysmergesubscriptions question
- examples with SS2008 -xEvents?
- Need Help With an Update Script
- delete a named instance - how?
- SQL Server Browser service?
- select from two tables
- Strange connection problem
- Help with an Update Statment
- Install new instance...
- Simple Query Question
- Where's my instance???
- DBMS advantage and disadvantage
- Rename Default Instance Name SQL Server 2005
- Cannot Read Varchar(max)
- relocating Outlook Business Contact manager
- confusion over indexs via primary key and clustered index
- Link to external file
- SQL Excel - freeware add-in for excel
- Modeling/Constraint question
- Email Generation from within SQL/Server 2005
- Re: SELECT Optimalization
- Best pratices to manage the "same logical" database on multipledatabase engine types (postgreSQL, SLQServer, etc..)
- Help with SQL Backup Problem
- DTS Transfer Data Task - output to text file with field names infirst line
- I want to update the column in a table based on the updation of theother column in the same table
- syscharsets unicode
- nested stored procedures and returning lots of rows
- Checking for duplicates in a database table
- firewall rules for SQL Server
- Modifying registry information to change type of login logging
- Suggested DB Reverse Engineering tool...
- Local Security Policy - Restricting Access
- Cursor and Procedure
- select from row1 to row n
- Reattaching database - identity_insert set to off
- Most Helpful Professional Award
- Cross Database Select
- Merge process could not update the list of subscriptions
- a and (b or c) better than (a and b) or (a and c) ?
- caching table Problem
- How to return a Pk value from one stored procedure to another storedprocedure
- create dynamic variable in procedure
- Advanced SQL Cubing
- SQL 2005 on Windows Server 2008 - Slow Connection Time
- Re: Display duplicate rows
- Help!
- Re: comp.databases.ms-sqlserver
- Altova v2008r2
- Urgent: Deciphering binary code executed against the database
- copying row from same table and adding value from form.request
- Doing a SELECT INTO using a Stored Proc as the data source
- SQL Statement Problem : Separate long varchar into word seqments 35chars long
- Setting SQL Server Agent Account without being part of a domain
- Limiting table access using stored procedure.
- SQL Select All Items where one meets the criteria
- optimal selection of all records for a certain month (illegal datesOK?)
- updating multiple columns with subselect
- Selecting several types
- Prevent Excel and Access access to SQL 2000
- Read HTML File though Network for Email.
- Disable and Rebuild or Drop and recreate Index
- Force protocol encryption on hosted database
- How to implement Audit/Alert for Row level access?
- Orphaned tupels, should I clean or is it ok to leave?
- Full text indexing scheduler SQL Options
- SQL and Database Design newsgroup
- ASP.NET 2.0 not connecting to SQL Server (not web.config)
- Help with bbrowser cell focus ?
- Client applications
- Re: SELECT * vs SELECT col1, col2
- COLUMNS_UPDATED() with triggers
- Re: How to show Median in a GROUP BY clause? (AVE works, Mediandoesn'
- beginners question...
- Conditional data copy SQL Server to Oracle
- Can you tell who last edited a SProc, and when?
- Select CASE returning NULL value
- Why freetext query become very slow all of a sudden
- Select date in british format
- back up jobs, re-index question
- MSSQL - MySQL
- file crawler
- How to recover deleted records?
- capture and save running sql query to database table (for logging)
- Use of having with additional select
- design question - type heirarchy with supertype queries
- Performance question concerning varchar(max)
- Yet another basic SQL question
- using LEN to find a first word greater than 17
- Job ends successfully even when it's not true
- exporting a table with long field names to Access
- Basic SQL Question
- FAQ & Solution: How to generate a number automatically for thePrimary Key when inserting a record?
- Another new DBMS
- copying data from one server to another
- How to find records with length greater than 17
- CHECKSUM to determine record changes
- first minimum date in the column for each distinct column a value
- Re: Get rows whose sum matches a value
- The Sql ranking OVERture
- sp_prepexec syscomments?
- select parent records that do not have a particular child
- how to create my own primary key which auto-increment
- Re: Get rows whose sum matches a value
- Re: tempdb size question
- Re: HELP WITH SELECT STATEMENT PLEASE
- SQL Server 2005: functions become slow after a while
- How to get the sql statement of a view? (by running a query or from ado.net)
- Granting permissions for a user from another database
- Login Seems OK but doesn't behave correctly
- table trigger just hangs
- SQL Server Management Studio
- Dump table as INSERTs
- Query Japanese Text in an NVarChar?
- SQL 2005 XML Searching
- import ADO DLL
- Performing Bulk Load of XML Data
- case-when error
- Secure Auditor, 30 security tools at the price of one.
- Secure Auditor, 30 security tools at the price of one.
- Finding "missing" rows
- Login failed for user 'sa'. Reason: Server is in single user mode.
- Re: T-SQL Duplicate Record Help
- Connection String on shared server- Almost there but need a littlehelp
- Please recommend SQL book with excercises
- Re: default value wich is not in DDL.
- Handle Triggers in MS Access 2003 with SQL Server as Back-End
- where do I download sql odbc drivers from?
- (Newbie) Join problem.
- Problem with joins in SQL.
- Join zero padded char to varchar
- Constipated publisher (SQL 2005)
- PHP/MS SQL - automatic formatting: varchar, datetime
- xSQL Profiler - monitor multiple SQL Servers from one centrallocation
- How do I make a backup device file smaller ?
- SQL 2005: Renamed 'sa' account
- Client side insert update
- help,a regular text file how to sql 2000 table code ?
- Problem Connecting .NET app to SQL Server
- An optimum query..?
- boot camp
- getting tables that link to a table
- [IAT ELEZIONI] Presentazione candidati
- Simple Concatenation Question
- List Columns in a Table in SQL 2005
- SQL Assistance required
- Error History?
- Deleting multiple columns from multiple objects
- from 'image' to 'varbinary(max)'
- What does it mean to SET a value?
- Complex Calculation
- difference between explicit inner join and implicit
- delete output into <xml column of audit table>
- testing if value is null
- Internal query processor error
- Violation of primary key
- CASE WHEN Equivalent in WHERE Clause?
- Uninstall SQL 2000 Workstation Components
- Scalar Subquery in MS-SQL Server 2000
- Scalar Query in SQL Server 2000 like in oracle
- SQL 2005 Express - problem with no "SQL Serevr Agent"
- SSIS security
- converting SQLTable to Excel Sheet
- dbrpcparam datalen problem
- ADO vs ADO.net
- SQLServer - VC++
- DLL -> Database
- SQL Server
- help with DDL trigger. Moved from other newsgroup.
- UTF-8 Coding of MSSQL 2005 DB
- how to calculate rank in selected records in sql server 2000
- SQL Server - synchronizing database changes across servers
- Rounding not working
- Getting record position in sql server 2000
- Deleting Tables
- call script from another script
- nub question :(
- Triggers and Flag bit