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