Archive of microsoft.public.sqlserver.server for November 2008
The following articles have been archived for November 2008 from microsoft.public.sqlserver.server:
- Alter Index On Database Rebuild (SQL Server 2005) posted on Sun, 30 Nov 2008
- Concentrate on SQL 2008 or their Cloud services? posted on Sun, 30 Nov 2008
- SQL Server 2005 Alter Index All On DB Rebuild posted on Sat, 29 Nov 2008
- SQL Server 2005 Cannot refer column Schema Across Database posted on Sat, 29 Nov 2008
- Documentation / Checklists posted on Sat, 29 Nov 2008
- alter nvarchar column size posted on Sat, 29 Nov 2008
- export scripts posted on Sat, 29 Nov 2008
- Update? posted on Fri, 28 Nov 2008
- [SAN] More spindles via multiple RAID/LUNs, or fewer & more focused LUNs? posted on Fri, 28 Nov 2008
- Bitwise in SQL Server posted on Thu, 27 Nov 2008
- How to shrink addtional tempdb files posted on Thu, 27 Nov 2008
- check sql mail log posted on Thu, 27 Nov 2008
- How to shrink tempdb posted on Thu, 27 Nov 2008
- SQL Server 2005 SSMS List Role Permission posted on Thu, 27 Nov 2008
- free text search in large starschemes posted on Thu, 27 Nov 2008
- Unwanted single user mode posted on Wed, 26 Nov 2008
- HTTP T-SQL queries (with XML support) don't work on sql server 200 posted on Wed, 26 Nov 2008
- Exporting to txt posted on Wed, 26 Nov 2008
- cmdshell how to run server side vbscript posted on Wed, 26 Nov 2008
- Retaining same Instance Name in side-by-side upgrade/migration posted on Wed, 26 Nov 2008
- Issue with subselect posted on Wed, 26 Nov 2008
- INSERT'ing from SQL Server into DB2 posted on Wed, 26 Nov 2008
- Connections between 2 SQL Servers posted on Wed, 26 Nov 2008
- Lumigent Log Explorer - where to get it? posted on Wed, 26 Nov 2008
- shrinkfile is bad news, but do I have a choice? posted on Tue, 25 Nov 2008
- issue with data format in joining tables posted on Tue, 25 Nov 2008
- Server Side Trace wierdness posted on Tue, 25 Nov 2008
- NCHAR -> CHAR COLLATION problems posted on Tue, 25 Nov 2008
- Sql Server Forwarding posted on Tue, 25 Nov 2008
- bad query results posted on Tue, 25 Nov 2008
- DBs posted on Tue, 25 Nov 2008
- Debugging SSIS package posted on Tue, 25 Nov 2008
- Database Mirroring not synching till I open Mirroring Monitor posted on Tue, 25 Nov 2008
- How to add a date stamp to the back up filename posted on Tue, 25 Nov 2008
- 12m ghost records posted on Tue, 25 Nov 2008
- Cannot Install SQL Server 2005 Dev on Vista Ultimate posted on Tue, 25 Nov 2008
- high table/index fragmentation posted on Tue, 25 Nov 2008
- Performance Tuning a DB posted on Tue, 25 Nov 2008
- Rushabh Mehta SSIS Management Framework posted on Mon, 24 Nov 2008
- sys.sp_dbmmonitor* procedures missing from msdb at mirror posted on Mon, 24 Nov 2008
- Should I enable AWE on 32-bit SQL 2005 EE running on 64-bit Window posted on Mon, 24 Nov 2008
- Query running slow in SQL 2005 after migrating from SQL 2000 posted on Mon, 24 Nov 2008
- Manager/ment Server Status Check posted on Mon, 24 Nov 2008
- List of Tables in a FileGroup posted on Mon, 24 Nov 2008
- Alerts and Disk Space posted on Mon, 24 Nov 2008
- Restore a 64 bit backup to a 32 bit server? posted on Mon, 24 Nov 2008
- Define a "user" in the license policy. posted on Mon, 24 Nov 2008
- Reporting Services 2008 -> deploy to sqlserver 2005 (downgrade) posted on Mon, 24 Nov 2008
- HELP - SQL QUERY posted on Sun, 23 Nov 2008
- SQL 2005 SP2 Standard upgrade to 2005 Enterprise posted on Sun, 23 Nov 2008
- Quest vs Idera posted on Sun, 23 Nov 2008
- SCHEMABINDING in Views posted on Sat, 22 Nov 2008
- Impact of using Varchar as Opposed to using NVarchar posted on Sat, 22 Nov 2008
- fk is not a constraint!!! posted on Sat, 22 Nov 2008
- Data and log file size is SQL server 2008 vs. 2005 posted on Sat, 22 Nov 2008
- attach db from landisk posted on Sat, 22 Nov 2008
- SQL 2008 and TCP 1433 posted on Sat, 22 Nov 2008
- New Row in Linked SQL Server Table Appears as a Duplicate posted on Fri, 21 Nov 2008
- help resolving deadlock on single table. posted on Fri, 21 Nov 2008
- Querying Active Directory posted on Fri, 21 Nov 2008
- deadlocks posted on Fri, 21 Nov 2008
- how to change users login name in sql 2000 SP4 after domain change... posted on Fri, 21 Nov 2008
- Insert Statement takes longer time posted on Fri, 21 Nov 2008
- Insert Statement takes longer time posted on Fri, 21 Nov 2008
- Linked Server Check posted on Thu, 20 Nov 2008
- 100 sleeping db connections posted on Thu, 20 Nov 2008
- Reason to upgrade..? posted on Thu, 20 Nov 2008
- Converting Non-clustered Index to Clustered posted on Thu, 20 Nov 2008
- Best practices for error handling in SQL Server procs posted on Thu, 20 Nov 2008
- Transforming Rows to Columns posted on Thu, 20 Nov 2008
- DELETE and WHERE Clause SQL Help posted on Thu, 20 Nov 2008
- Transaction (Process ID 411) was deadlocked on thread posted on Thu, 20 Nov 2008
- Transaction (Process ID 411) was deadlocked on thread | communication buffer res posted on Thu, 20 Nov 2008
- bcp command specifying output file in path with a space posted on Thu, 20 Nov 2008
- help on bcp delimiter posted on Thu, 20 Nov 2008
- Model Database posted on Wed, 19 Nov 2008
- 64bit to 32bit?? posted on Wed, 19 Nov 2008
- Reporting Services - Service Error posted on Wed, 19 Nov 2008
- I need to copy data from table to another posted on Wed, 19 Nov 2008
- MSIDXS - Row handle is invalid posted on Wed, 19 Nov 2008
- Copy database posted on Wed, 19 Nov 2008
- Discover who is tempdb posted on Wed, 19 Nov 2008
- I cannot change values in database tables posted on Wed, 19 Nov 2008
- Covering indexes question posted on Wed, 19 Nov 2008
- 2 connections posted on Wed, 19 Nov 2008
- SQL Server Management Studio 2008 not backward compatible ? posted on Wed, 19 Nov 2008
- Is it a good practice to create a database without relationships? posted on Wed, 19 Nov 2008
- Import jpgs? posted on Wed, 19 Nov 2008
- SQL Browser with 2 ip's posted on Wed, 19 Nov 2008
- Query help with month\year selection posted on Wed, 19 Nov 2008
- Database Diagrams for SQL Server 2005 posted on Wed, 19 Nov 2008
- SQL 2008 Export to CSV. Numeric Fields quoted. WHY? posted on Wed, 19 Nov 2008
- Indexes - Clusteredand Non-clustered posted on Wed, 19 Nov 2008
- Is it possible to empty and drop the orginal mdf file of the Primary filegroup? posted on Wed, 19 Nov 2008
- Transaction log grows when import posted on Wed, 19 Nov 2008
- Data from remote tables: filtering? posted on Tue, 18 Nov 2008
- Returning result set rows before query is completed? posted on Tue, 18 Nov 2008
- Alerts on Error Numbers posted on Tue, 18 Nov 2008
- Can't install AdventureWorks - Full Text Search "missing" posted on Tue, 18 Nov 2008
- Removing Identity from column posted on Wed, 19 Nov 2008
- How to determin the last time a SQL 2000 database was written to posted on Tue, 18 Nov 2008
- SQL Server 2005 Audit Tracking for accidental deletions? posted on Tue, 18 Nov 2008
- ARITHABORT setting or property posted on Tue, 18 Nov 2008
- What is the difference between TM Mem Usage and Total Server Memor posted on Tue, 18 Nov 2008
- What is the difference between Mem Usage and Total Server Memory posted on Tue, 18 Nov 2008
- MS Stop SQL Server 2000 posted on Tue, 18 Nov 2008
- does sql 2008 have service pack? posted on Tue, 18 Nov 2008
- snapshot and error trapping posted on Tue, 18 Nov 2008
- Database needs to be in single user mode to be backed up by DBMain posted on Tue, 18 Nov 2008
- help with stored procedure posted on Tue, 18 Nov 2008
- Partitions, Index and filegroups? posted on Tue, 18 Nov 2008
- log shows FAILED TO NOTIFY USER VIA EMAIL but SEND TEST EMAIL works posted on Tue, 18 Nov 2008
- Partitions posted on Tue, 18 Nov 2008
- Upgrade SQL Server 2000 to SQL Server 2005 posted on Tue, 18 Nov 2008
- kill long running transaction log, help!! posted on Mon, 17 Nov 2008
- SQL that generates a sequence posted on Mon, 17 Nov 2008
- SQL Express 2005 command line shutdown posted on Mon, 17 Nov 2008
- sql server monitoring software posted on Mon, 17 Nov 2008
- SQL Profiler posted on Mon, 17 Nov 2008
- Stored Procedure posted on Mon, 17 Nov 2008
- How to grant access to read-only database? posted on Mon, 17 Nov 2008
- Create Database from mdf and ldf files posted on Mon, 17 Nov 2008
- /3Gb and AWE posted on Mon, 17 Nov 2008
- io affinity and reserved os memory on mlt. proc. server posted on Mon, 17 Nov 2008
- Searches against column of composite primary key posted on Mon, 17 Nov 2008
- join to sql server team posted on Mon, 17 Nov 2008
- Which version/edition of sql server 2005 would be good for umpc? posted on Sun, 16 Nov 2008
- Enterprise wide SQL Server licensing posted on Sun, 16 Nov 2008
- Question on Clustered and NonClustered posted on Sun, 16 Nov 2008
- Putting NET Framework Assemblies in a Separate Database posted on Sun, 16 Nov 2008
- Table with TWO Primary keys posted on Sun, 16 Nov 2008
- Design and Foreign Keys posted on Sat, 15 Nov 2008
- TOP, ROWCOUNT, & ORDER BY posted on Sat, 15 Nov 2008
- Continue past PK violations on insert posted on Sat, 15 Nov 2008
- Help on manual reinstall Sql Service posted on Sat, 15 Nov 2008
- Schedule Jobs status if server machine was restarted... posted on Fri, 14 Nov 2008
- Sql 2005 Maintenance Plan - Backup posted on Fri, 14 Nov 2008
- import Excel 2007 (.xslx) into SQL 2000 posted on Fri, 14 Nov 2008
- Index Question posted on Fri, 14 Nov 2008
- Restoring database and logs from .bak and .trn files posted on Fri, 14 Nov 2008
- High memory pages\sec posted on Fri, 14 Nov 2008
- Downloading hotfix for KB http://support.microsoft.com/kb/949095/ posted on Fri, 14 Nov 2008
- How to Use the Unused Space of a Table After Delete posted on Fri, 14 Nov 2008
- The supplied user buffer is not valid posted on Fri, 14 Nov 2008
- Replication - snapshot agent doesn't work from the job but running fine from sna posted on Thu, 13 Nov 2008
- 3 days into reinstall hell .. SQL SP2 Your Account Information Could not be Veri posted on Thu, 13 Nov 2008
- SQL Server 2005 Import Backup File posted on Thu, 13 Nov 2008
- Upgrade 2008 Developer to Enterprise posted on Thu, 13 Nov 2008
- fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION posted on Thu, 13 Nov 2008
- how to trace a given t-sql-statement? posted on Thu, 13 Nov 2008
- Exporting a SQL Server Agent Job to a new server posted on Thu, 13 Nov 2008
- Cannot remove table user permissions posted on Thu, 13 Nov 2008
- Execution Warnings - Query Wait posted on Thu, 13 Nov 2008
- Uninstall reporting server in sql2005 posted on Thu, 13 Nov 2008
- How to truncate logs if the database is mirroring and full recovery posted on Thu, 13 Nov 2008
- Creating SQL Share posted on Wed, 12 Nov 2008
- Encryption options posted on Wed, 12 Nov 2008
- sql 2005 password problem posted on Wed, 12 Nov 2008
- SQL2000, IO Spike, High CPU Queue Length posted on Wed, 12 Nov 2008
- Backups fail in Database Maintenance Plan posted on Wed, 12 Nov 2008
- How to allow access from only local machine posted on Thu, 13 Nov 2008
- changing Admin password caused SQL to not start posted on Wed, 12 Nov 2008
- SSMS error - Property Owner is not available for Database posted on Wed, 12 Nov 2008
- Collation error message posted on Wed, 12 Nov 2008
- SQL 2K EE to 05 SE or 08 SE posted on Tue, 11 Nov 2008
- SQL 2005 to SQL 2008 posted on Tue, 11 Nov 2008
- Standard Blocking Procedures For SQL Server 2005 posted on Tue, 11 Nov 2008
- fn_trace_gettable posted on Tue, 11 Nov 2008
- SQL Server 2000 32bit posted on Tue, 11 Nov 2008
- Extent allocation object posted on Tue, 11 Nov 2008
- truncate log in simple recovery model posted on Tue, 11 Nov 2008
- SQL process to check the table posted on Tue, 11 Nov 2008
- sql 2008 and DPM2007 posted on Tue, 11 Nov 2008
- BCP - Function Sequence Error posted on Tue, 11 Nov 2008
- convert hierarchical data to columns posted on Tue, 11 Nov 2008
- SQL Server licencing for MSDN professional subscription posted on Mon, 10 Nov 2008
- Need to monitor log backups posted on Tue, 11 Nov 2008
- Mirroring with SQL 2005 posted on Mon, 10 Nov 2008
- T-sql script generator for sql server 2005 posted on Mon, 10 Nov 2008
- incrementing values in server side trace posted on Mon, 10 Nov 2008
- Selective Order By? posted on Mon, 10 Nov 2008
- Insert if not there, otherwise return identity posted on Mon, 10 Nov 2008
- sort_in_tempdb posted on Mon, 10 Nov 2008
- Passing variable to Alter Database script posted on Mon, 10 Nov 2008
- SQL Server Developer Edition posted on Mon, 10 Nov 2008
- sql2005- Each GROUP BY expression must contain at least one posted on Mon, 10 Nov 2008
- Identity Inserts Skip posted on Mon, 10 Nov 2008
- SSIS package question posted on Mon, 10 Nov 2008
- Service Broker and SQL Server 2005 Express posted on Mon, 10 Nov 2008
- Subquery ? posted on Mon, 10 Nov 2008
- did anybody take classes with Nicomp International in New York posted on Mon, 10 Nov 2008
- Full backup not possible, log_reuse_wait_desc=LOG_BACKUP posted on Mon, 10 Nov 2008
- RESTORE progress indicator posted on Mon, 10 Nov 2008
- How to Install Full Text Search posted on Sun, 9 Nov 2008
- Date missing milliseconds posted on Sun, 9 Nov 2008
- Setup fails on three nodes posted on Sat, 8 Nov 2008
- Problem with Sql Sattement posted on Sat, 8 Nov 2008
- Another SQL Error in Dayabase Diagram!!! posted on Fri, 7 Nov 2008
- sql 2005 std - clustering posted on Fri, 7 Nov 2008
- Backup and flush logs ? posted on Fri, 7 Nov 2008
- schedule to run osql backup posted on Fri, 7 Nov 2008
- Shrinkfile taking way to long... posted on Fri, 7 Nov 2008
- sqlperf vs DMV posted on Fri, 7 Nov 2008
- Internal SQL 2000 Server error posted on Fri, 7 Nov 2008
- Vista and SQL on w2003 posted on Fri, 7 Nov 2008
- I modify the first 160 byte of mdf file to 0, now can't attach posted on Thu, 6 Nov 2008
- RAM configuration in SQL Server 2000 Standard Edition posted on Thu, 6 Nov 2008
- Row Size exceeded? posted on Thu, 6 Nov 2008
- Linked Server or VB? posted on Thu, 6 Nov 2008
- Sample database posted on Thu, 06 Nov 2008
- SQl2005 DB Mail posted on Thu, 6 Nov 2008
- Change partition filegroup posted on Thu, 6 Nov 2008
- Query on system tables hangs posted on Thu, 6 Nov 2008
- Ultra Larga Databases - #1 Needed Feature in SQL Server posted on Thu, 6 Nov 2008
- Performance problems inserting and querying large tables posted on Thu, 6 Nov 2008
- os showing wrong free space reading posted on Thu, 06 Nov 2008
- Estimates for time to perform upgrade from 2000 to 2005? posted on Thu, 6 Nov 2008
- table locking posted on Thu, 6 Nov 2008
- Unexpected reset of auto number field posted on Thu, 6 Nov 2008
- Attaching a SQL Server 2005 Standard db to an Express 2005 edition posted on Thu, 6 Nov 2008
- SQL Report and Crystal reports posted on Thu, 6 Nov 2008
- Help with bulk copy using BCP posted on Thu, 6 Nov 2008
- Generic DML/DDL Triggers and performance implications posted on Wed, 5 Nov 2008
- view dependencies does not seem to work in SQL2005 posted on Wed, 5 Nov 2008
- Convert 2000 database to 2005 posted on Wed, 5 Nov 2008
- Permissions Problem posted on Wed, 5 Nov 2008
- How to set timeout in SQL Agent Job or in stored proc posted on Wed, 5 Nov 2008
- SQL Server 2000 and SQL 2005/2008 Enterprise coexisting posted on Wed, 5 Nov 2008
- Equivalent of Orace Fine-grained auditing (FGA) in SQL Server 2005 posted on Wed, 5 Nov 2008
- sql 2005 to sql 2008 upgrade posted on Tue, 4 Nov 2008
- userlookups posted on Tue, 4 Nov 2008
- What enabled SQL VSS Writer Service? posted on Tue, 4 Nov 2008
- reporting services are grayed out on 64 bit sql server posted on Tue, 4 Nov 2008
- How to determine sql server version of a backup file? posted on Tue, 4 Nov 2008
- Partitions posted on Tue, 4 Nov 2008
- ?? Changing a MUST_CHANGE Password ?? posted on Tue, 4 Nov 2008
- converting table data/table structure into xml file posted on Tue, 4 Nov 2008
- how to grant right to a snapshot database posted on Mon, 3 Nov 2008
- how to create audit upon insert, update,and delete posted on Mon, 3 Nov 2008
- Need to script-out all the Sql Agent Jobs and DTS packages from SS posted on Mon, 3 Nov 2008
- Puzzling data file behavior - it won't grow posted on Mon, 3 Nov 2008
- Licensing question posted on Mon, 3 Nov 2008
- Access DB imported to SQL 2005 Yes/No Boxes converted to Bit posted on Mon, 3 Nov 2008
- Are there Service Packs or patches for SS2008 Standard? posted on Mon, 3 Nov 2008
- sql 2005 where to check logshipping status posted on Mon, 3 Nov 2008
- Any issues migrating 32 bit SQL db to a 64 bit machine? posted on Mon, 3 Nov 2008
- Change of Server Name containing SQL Server 2000 ? posted on Mon, 3 Nov 2008
- SQL 2005 + workstations posted on Sun, 2 Nov 2008
- SQL Server Setup Problem (2000 / 2005) posted on Sun, 2 Nov 2008
- Error installing BOL 2008 posted on Sun, 2 Nov 2008
- GROUP BY Problem in my Script posted on Mon, 03 Nov 2008
- Any reason NOT to shrink a static database? posted on Sun, 2 Nov 2008
- Connection forcibly closed posted on Sun, 2 Nov 2008
- q: enabling transaction logs posted on Sat, 1 Nov 2008
- Compression did not produce increased performance posted on Sat, 1 Nov 2008
- Determine column value of the row when trigger is fired. posted on Sat, 1 Nov 2008
- memory: input pages/sec posted on Fri, 31 Oct 2008
- Cannot bulk load because the file "..." could not be opened. Operating system er posted on Fri, 31 Oct 2008
- SQL backup posted on Fri, 31 Oct 2008