Archive of comp.databases.ms-sqlserver for May 2005

The following articles have been archived for May 2005 from comp.databases.ms-sqlserver:

• Tx Log Truncate and Deadlock posted on 31 May 2005
• Giving Active Queries Priority posted on 31 May 2005
• Query to compare table data between Test and Production? posted on Tue, 31 May 2005
• Query Question posted on 31 May 2005
• datatime error posted on Tue, 31 May 2005
• Filter Expression posted on 31 May 2005
• sqldmo ListAvailableSQLServers crashes posted on 31 May 2005
• Need help returning a null value, please posted on 31 May 2005
• text or varchar ? posted on 31 May 2005
• Set READ UNCOMMITTED (dirty read) at login. posted on 31 May 2005
• Problem to Run DTS from Stored Procedure posted on 31 May 2005
• Logic problem in cursor/SPROC posted on 31 May 2005
• Question: ODBC Connection Error .. multiple thread (urgent, pls) posted on 31 May 2005
• Blocking posted on 30 May 2005
• Need an allround DBA (development&Admin) in MSSQL and Oracle posted on 30 May 2005
• ADO Error Code:0x80040e4d posted on Mon, 30 May 2005
• Can't install MSDE posted on 30 May 2005
• Column name in functions posted on 30 May 2005
• IF SELECT UNION posted on 30 May 2005
• One-to-many with a twist posted on 30 May 2005
• log-file for interface-use posted on Mon, 30 May 2005
• Problem with DateTime and strings in stored procedures posted on 30 May 2005
• sa Vs sysadmin login posted on 30 May 2005
• Stored procedure fails execution sometime posted on 29 May 2005
• How to delete a big amount of data posted on Sun, 29 May 2005
• tips on securting sql server posted on 29 May 2005
• What is the right value for BCP's ROWS_PER_BATCH posted on Sun, 29 May 2005
• system time on sql server is wrong? posted on 29 May 2005
• Change SQL Server Authentication Programmatically posted on Sat, 28 May 2005
• deadlocks posted on Sat, 28 May 2005
• More Newbie Questions posted on Sat, 28 May 2005
• Can MSSQL load a tab delimited text file? posted on 27 May 2005
• SQL Server Express posted on 27 May 2005
• Query Help, thanks! posted on 27 May 2005
• Encryption and "WHERE encrypted_column LIKE" posted on 27 May 2005
• Getting Plan of previously executed Queries posted on 27 May 2005
• SQL Memory Issues - Need Advice posted on 27 May 2005
• Help Needed With Job Scheduling posted on 27 May 2005
• displaying a table posted on 27 May 2005
• SQL Automatic Growth posted on 27 May 2005
• Displaying database name within select within UNION posted on 27 May 2005
• Doubt to be Clarified posted on 26 May 2005
• What's the difference? Unque Constraint and unique index, etc.? posted on 26 May 2005
• ACCESS 2003 query size high problem help posted on Thu, 26 May 2005
• Need some help with design of tables/views posted on 26 May 2005
• Increase number of process(thread) posted on Thu, 26 May 2005
• Db Owner posted on 26 May 2005
• Concurrent queries error posted on Thu, 26 May 2005
• Setting password for each database posted on 26 May 2005
• getting a stored procedure's code posted on Thu, 26 May 2005
• Upgrade from SQL Standard edition to Enterprise edition posted on 26 May 2005
• Restore master database from 64bit sql server to 32 bit server posted on 26 May 2005
• Permissions with views and tables posted on Thu, 26 May 2005
• Converting Text to Proper Text in SQL posted on 26 May 2005
• Writing multiple queries to a file with BCP posted on 26 May 2005
• Help with SELECT please posted on 26 May 2005
• some sort of cross tab query in sql posted on 26 May 2005
• EM posted on 25 May 2005
• Creating a DB by restore - problems posted on Wed, 25 May 2005
• Multiple SQL statements in a stored procedure posted on 25 May 2005
• Sql Server incorrectly functioning posted on 25 May 2005
• Help with SQL Query posted on 25 May 2005
• retrieving backup posted on 25 May 2005
• BCP fmt and Create Table posted on 25 May 2005
• VALUE IN FIELD NULL OR VOID STRING!? posted on 25 May 2005
• Passwords in Sql Server 2000 posted on Wed, 25 May 2005
• Create table from Text posted on Wed, 25 May 2005
• URGENT - DTS - Need to run the object to perform the operation - Exception Access Violation posted on 25 May 2005
• Proportional fill posted on Wed, 25 May 2005
• Trigger Error posted on 25 May 2005
• what is the true definition of catalog table? posted on Tue, 24 May 2005
• sql server transaction syntax help posted on 24 May 2005
• Locking an MSSQL record with ADO.NET posted on 24 May 2005
• setting remote path for "text file (source)" - DTS posted on 24 May 2005
• sql 2000 with windows 2003 posted on 24 May 2005
• DTS posted on 24 May 2005
• Display Image Datatype from a table in Reporting Services report..! posted on 24 May 2005
• Backup Help posted on 24 May 2005
• SQL Union / Intersection posted on 24 May 2005
• DBs not appearing in query analyer dropdown posted on 24 May 2005
• Question on generating SQL scripts using Enterprise Manager posted on 24 May 2005
• Heterogeneous queries posted on 24 May 2005
• Selecting Min/Max over multiple rows posted on 24 May 2005
• Easy way to remove international alphabet from all rows? posted on 24 May 2005
• how to continue on error posted on 24 May 2005
• Suggestions?: Querying tables from multiple databases posted on 24 May 2005
• Returning a count of items including zero posted on 24 May 2005
• update sql errors using linked server posted on 24 May 2005
• Insert performance different between two servers posted on 24 May 2005
• SQL Injection Attack posted on 23 May 2005
• Forbidden access to ReportServer (error 403) posted on 23 May 2005
• Subquery in case statement posted on 23 May 2005
• Joins on UPDATE posted on 23 May 2005
• Copying Database from 2000Server Machine To 2003 Server Machine posted on 23 May 2005
• SQL Job failing error 8198 posted on 23 May 2005
• How to reclaim space in columns changed from nvarchar to varchar posted on 23 May 2005
• personal edition then move to enterprise posted on 23 May 2005
• bad page ID posted on Sun, 22 May 2005
• Foreign key constraints? posted on Sun, 22 May 2005
• Newbie: how to make a datatypeconversion in a view posted on Sat, 21 May 2005
• Compare SQL objects posted on Sat, 21 May 2005
• CS vs CI database posted on Sat, 21 May 2005
• Network Restoration Of Database posted on 21 May 2005
• MSCS SQL2000 Cluster 64 and 32 bit servers posted on Fri, 20 May 2005
• help with for xmp explicit posted on 20 May 2005
• Update question posted on Fri, 20 May 2005
• Cant use ODBC data source on SQL SERver 2000 sp3a named Instance posted on 20 May 2005
• Order Schedule. posted on 20 May 2005
• Problem linking tables posted on 20 May 2005
• Informix Date Function Equivalent posted on 20 May 2005
• Delete Duplicates posted on 20 May 2005
• Using IN(xxx, yyy) with table row posted on 20 May 2005
• Conversion Error...nvarchar to Datetime posted on 20 May 2005
• Data Comparison posted on 20 May 2005
• Query Analyzer on 2003 WE posted on 20 May 2005
• Procedure Encryption - Any side effects? posted on Thu, 19 May 2005
• How long is a SQL statement allowed to be? posted on Thu, 19 May 2005
• BULK INSERT Question posted on Thu, 19 May 2005
• Updating SQL Server Database from Access posted on Thu, 19 May 2005
• Newbie: Transfering databases from different servers posted on Thu, 19 May 2005
• Sql query help posted on 19 May 2005
• SQL Query Analyzer Greyed Out posted on 19 May 2005
• SQL server 7 physical storage posted on 19 May 2005
• newbie: Can results from "Contains" be ranked? posted on 19 May 2005
• Updating indexed views - who pays? posted on 19 May 2005
• Adding Active Directory login (ca vs. samaccount) posted on 19 May 2005
• Checking The User's Server Role posted on 19 May 2005
• Very Urgent: Required document for R/3 installation on SQL server in disrtibuted environment posted on 18 May 2005
• Collation problem posted on 18 May 2005
• A floating point exception occurred in the user process. Current transaction is canceled. posted on 18 May 2005
• Extended stored procedure performance tuning posted on 18 May 2005
• Remote ODBC Connection problem \ posted on Wed, 18 May 2005
• creating data for a histogram. posted on 18 May 2005
• IF...ELSE error posted on 18 May 2005
• Newbie question on SQL Query writing posted on 18 May 2005
• Error 7201: Permissions problem? posted on Wed, 18 May 2005
• Company-calendars posted on Wed, 18 May 2005
• Front Page 2002 and SQL Query posted on 18 May 2005
• Newbie Questions posted on Wed, 18 May 2005
• Service Pack 3 to Service Pack 4 posted on 18 May 2005
• Building / Modifying an SQL Database remotely posted on Tue, 17 May 2005
• [Fwd: Reverse pattern matching] posted on Tue, 17 May 2005
• Using EXISTS posted on 17 May 2005
• Negative values for RowModCtr col in sysobjects tbl posted on 17 May 2005
• Delete recordsets with same Date and Line posted on Tue, 17 May 2005
• Working with date ranges posted on 17 May 2005
• complexity of nested self left joins? posted on 17 May 2005
• Changing collation when installing SQL2000 posted on 17 May 2005
• ODBC connection to SQL server failing posted on 17 May 2005
• SQL Files Query posted on 17 May 2005
• Problem finding values with aggregate functions posted on 17 May 2005
• Moving all DTS packages from server to server posted on 17 May 2005
• Deadlocks & BEGIN/END TRANSACTION posted on 16 May 2005
• Bad executed Plan and wrong Result by SQL posted on Mon, 16 May 2005
• Excessive stored procedure [COMPILE] lock posted on 16 May 2005
• NOT FOR REPLICATION, Enterprise manager posted on Mon, 16 May 2005
• How to deploy a report in Reporting Services without using VS 2005? posted on Mon, 16 May 2005
• Date poition comparison of a datetime field posted on 16 May 2005
• hash table (#) order by problem with more records posted on 16 May 2005
• Avoid index scan with LIKE and a variable posted on 15 May 2005
• help with exists posted on 15 May 2005
• Compare two databases and update objects? posted on Sun, 15 May 2005
• Query Produces Jumbled output / output not in sequence posted on 15 May 2005
• Will it auto convert datatype??? posted on 15 May 2005
• db_owner to all tables posted on 15 May 2005
• Which is more efficient, join or straight select posted on 14 May 2005
• importing from .txt posted on 14 May 2005
• How to send data from a remote Client to my FTP site posted on 14 May 2005
• How to Copy and Rename a Database: same server posted on 14 May 2005
• SQL query - highest rated or least voted items posted on 13 May 2005
• FK on a column to a table where the column is not the PK but a Unique Index posted on 13 May 2005
• Script for comma seperated values posted on 13 May 2005
• Output Select results to a text file. posted on 13 May 2005
• Storing pdfs in an image field posted on Fri, 13 May 2005
• compare data posted on 13 May 2005
• ntext and update/insert triggers posted on 13 May 2005
• A query runs fast in Query analuser but slow in APplication posted on 13 May 2005
• Cannot start MSSQL Server 7 posted on 13 May 2005
• Insert datetime problem posted on 13 May 2005
• Why....'PRIMARY' filegroup is full???? posted on 12 May 2005
• insert current date/time posted on 12 May 2005
• Can't create table posted on Thu, 12 May 2005
• storing text data in a binary field posted on Thu, 12 May 2005
• How to insert new rows to master table posted on 12 May 2005
• dynamic SQL variable with Output ?? posted on 12 May 2005
• Need hardware suggestions for SQL 2000 server posted on 12 May 2005
• Basic Syntax explanation posted on 12 May 2005
• lookup table relationships best practice posted on 12 May 2005
• Troubleshooting failed job posted on Thu, 12 May 2005
• Serverwide Rollback posted on 12 May 2005
• Insert Trigger to Update table posted on 12 May 2005
• Split a field posted on 12 May 2005
• Date Format Conversion posted on 12 May 2005
• Creating SQLServer Jobs in Enterprise Manager posted on 12 May 2005
• SQL Syntax - group by and having count posted on 12 May 2005
• Can I recover from the database files? posted on 11 May 2005
• Theta join or equijoins?? posted on Wed, 11 May 2005
• BCP and SQL Server 2K posted on 11 May 2005
• Importing from PL/SQL to MSSQL posted on Wed, 11 May 2005
• Sending data to a Stored Procedure with ASP error posted on 11 May 2005
• Syntax question posted on 11 May 2005
• How to convert binary or hexa to decimal? posted on Wed, 11 May 2005
• Xquery Support in SQL-Server 2005 posted on Wed, 11 May 2005
• WHERE clause delima posted on 11 May 2005
• XML Problem in SQL Server 2000 posted on 11 May 2005
• Syntax Question posted on 11 May 2005
• removing data posted on 11 May 2005
• equivalent Oracle rownum in SQLServer posted on 11 May 2005
• C# SQL-DMO ExecuteImmediate posted on Tue, 10 May 2005
• Need help relocating transaction log file. posted on Tue, 10 May 2005
• Memory leak in SQL Server posted on 10 May 2005
• SQL Databases compare tool posted on Tue, 10 May 2005
• Create Second 'sa' Account ('sa2') on SQL 6.5? posted on 10 May 2005
• delete last added row -how to posted on Tue, 10 May 2005
• Slow MDB Linked View posted on Tue, 10 May 2005
• Propagation of event notification when tables are updated. posted on 10 May 2005
• Which is better for making a copy of a database, restore or DTS? posted on 10 May 2005
• testing a connection string posted on 10 May 2005
• Process Info (SQL Server Enterprise - Management - Current Activity) posted on 10 May 2005
• Memory Running Out posted on 9 May 2005
• How to restore database to point in time (no full backup) posted on Mon, 9 May 2005
• Help With Some SQL posted on Mon, 9 May 2005
• How to synchronize 2 tables on different sql servers posted on Mon, 09 May 2005
• Global temp table permissions posted on 9 May 2005
• SQL Replication posted on Mon, 09 May 2005
• time from datetime posted on 9 May 2005
• xp_sendmail problem posted on 9 May 2005
• SQL Server 2000 2GB memory limit? posted on 9 May 2005
• Formating Numbers with Commas posted on 9 May 2005
• Formating Numbers with Commas posted on 9 May 2005
• Constructing Email message posted on 9 May 2005
• Does DB-Restore on a different machine omit user/login information ? posted on 9 May 2005
• SQL DTS package to process a remote OLAP database posted on Sun, 8 May 2005
• Using DTS to move data to a new table with some datatype changes posted on 7 May 2005
• how to add 1 to the field posted on 7 May 2005
• Help with SELECT Query posted on 7 May 2005
• Is this correct use of INSTEAD OF Triggers? posted on 7 May 2005
• Tunneling enterprise manager over https ASP.NET? posted on 6 May 2005
• Conecting over the Internet for getting data from clients. posted on 6 May 2005
• SQL Profiler posted on Fri, 06 May 2005
• Number Data Types... posted on 6 May 2005
• wil s2k developer edition really work on XP Pro box? posted on 6 May 2005
• Help ! Database Still says loading after restore posted on 6 May 2005
• Select JOIN problem posted on 6 May 2005
• Wrong syntax in where smth in case ? posted on 6 May 2005
• Query Analyzer Template files, object browser bug posted on 6 May 2005
• DTS of data between two tables, same field names but differnt datatypes posted on 6 May 2005
• Crosstab queries posted on Thu, 5 May 2005
• Connecting for entire session, or just when performing an operation? posted on Thu, 5 May 2005
• How do you lock an entire table? posted on Thu, 5 May 2005
• User interaction with SQL posted on Thu, 05 May 2005
• What is purpose of N in SQL examples? posted on 5 May 2005
• cursor insert with like '%' posted on 5 May 2005
• BULK INSERT row terminator posted on 5 May 2005
• Help Please - Backup FileGroup and Restore posted on 5 May 2005
• Stored Proc not updating multiple rows posted on 5 May 2005
• DBA on mulitiple databases posted on 5 May 2005
• Problem returning a datarow posted on Wed, 4 May 2005
• simple SQL update posted on Wed, 04 May 2005
• SQL update statement in VB posted on Wed, 04 May 2005
• 7.00.1078_enu.exe on msde posted on 4 May 2005
• Storing binary files in MS SQL 2000 posted on 4 May 2005
• Primary key posted on Wed, 4 May 2005
• update from ...? posted on Wed, 04 May 2005
• How can I INSERT w/Constraints in other tables? posted on 4 May 2005
• Loop through a recordset to populate columns in a temp table posted on 4 May 2005
• SQL 2000 - 450+ Databases posted on 4 May 2005
• SQL problem posted on Wed, 4 May 2005
• Book and class posted on Wed, 4 May 2005
• HexToInt and HexToSmallInt posted on Wed, 4 May 2005
• How to delete rows in a table when no primary key is defined posted on 4 May 2005
• Field not being updated within Stored Procedure posted on 4 May 2005
• Complicated SELECT Problem posted on 4 May 2005
• Mails are stuck in the Queue Folder posted on 4 May 2005
• odbc errors on terminal server posted on 4 May 2005
• XML to View posted on 4 May 2005
• DTS package doesn't execute posted on 3 May 2005
• any SQL guru's out there? posted on Tue, 3 May 2005
• How can i get the details of the error posted on Tue, 03 May 2005
• Sql server authentication not set posted on 3 May 2005
• Error while running xp_cmdshell posted on 3 May 2005
• timeout expired w/SQL2K SP3 posted on 3 May 2005
• DEFRAG disk drive posted on 3 May 2005
• Need good idea posted on 3 May 2005
• Problem using CAST with Zeroed out Field Values posted on 3 May 2005
• Will MSSQL DB Server perform better with 2k3? posted on 3 May 2005
• Changing the default port number and still connecting posted on Tue, 03 May 2005
• Database design, inherit posted on 3 May 2005
• How to get the status? posted on 3 May 2005
• Need advice for process of swapping DBs posted on 2 May 2005
• How to convert recursive function into recursive stored procedure posted on 2 May 2005
• Crosstab query posted on 2 May 2005
• Database Backup Security posted on 2 May 2005
• Separate an And/Or parameter posted on 2 May 2005
• Best way for a Set-based query posted on 2 May 2005
• Recovery and Backup posted on 1 May 2005
• SQL Server -> MS- Access VBA posted on Sun, 1 May 2005
• ODBC and MSDE posted on 1 May 2005
• Customer IDs without identity posted on 1 May 2005
• persisting data for a pluggable tree posted on 1 May 2005