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