Archive of microsoft.public.sqlserver.server for December 2006

The following articles have been archived for December 2006 from microsoft.public.sqlserver.server:

• IO Completion Listener Worker appears to be non-yielding on Node posted on 31 Dec 2006
• how is the cache broken up in SQL 2000? posted on Sun, 31 Dec 2006
• sessions vs connections posted on Sat, 30 Dec 2006
• Second Instance problem posted on Sat, 30 Dec 2006
• [Ugent] attach Database error in SQL 7.0 posted on Sun, 31 Dec 2006
• Database Maintenance Planner option disabled posted on 30 Dec 2006
• SQL Server 2005 Express vs MSDE posted on Sat, 30 Dec 2006
• Open default DB in Enterprise Manager upon connecting to server (SQL2000) posted on Sat, 30 Dec 2006
• SQL 2005 useful catalog views and DMVs posted on Fri, 29 Dec 2006
• Viewing column names of SQL table posted on 29 Dec 2006
• SQL 2000 64 bit on x64 Win 2003 Server posted on Fri, 29 Dec 2006
• server hosed? Very slow server posted on 29 Dec 2006
• Moving the Reprot Server log files in 2005 posted on Fri, 29 Dec 2006
• Why the term "Truncate Log" posted on Fri, 29 Dec 2006
• representative sub-data posted on 29 Dec 2006
• How often and when should the sp_recompile procedure be used posted on Fri, 29 Dec 2006
• Sql 2003 posted on 29 Dec 2006
• q; INSRET/UPDATE trigger posted on Fri, 29 Dec 2006
• Transaction log backups--file size posted on Fri, 29 Dec 2006
• Migrate jobs from production to backup posted on Fri, 29 Dec 2006
• stored procedure compilation - broken posted on 29 Dec 2006
• Dump SQLExpress Data posted on Fri, 29 Dec 2006
• caching a view? posted on 29 Dec 2006
• Production DB Modifications posted on Thu, 28 Dec 2006
• Is database mirroring the solution for this scenario? posted on Thu, 28 Dec 2006
• When will SP2 be released? posted on Fri, 29 Dec 2006
• Auditing table access posted on 28 Dec 2006
• Load Test posted on Thu, 28 Dec 2006
• Security Permissions Question posted on Thu, 28 Dec 2006
• Help With Query posted on Thu, 28 Dec 2006
• About change log file folder after database was created posted on Thu, 28 Dec 2006
• How to find rows marked for replication? posted on 28 Dec 2006
• Determine which edition of the engine is used by which instance? posted on Thu, 28 Dec 2006
• I want to activate trace flag 1807 an have it persist across reboots/restarts posted on 28 Dec 2006
• SQL Server Express Service Pack 2 maintenance plan wizard posted on Thu, 28 Dec 2006
• Retrieve database size information posted on Thu, 28 Dec 2006
• SQL 2000 on a em64T server. posted on Thu, 28 Dec 2006
• Silent installs posted on Thu, 28 Dec 2006
• SQL Server statistics posted on 28 Dec 2006
• Why Clustered Index 'SCAN'.....instead of 'SEEK' posted on 27 Dec 2006
• Load on SQL Server Database posted on 27 Dec 2006
• PF Usage posted on Wed, 27 Dec 2006
• AWE /3GB performance posted on Wed, 27 Dec 2006
• listing of sp_who posted on Wed, 27 Dec 2006
• Replacement for my LIKE Clause posted on 27 Dec 2006
• SQL Server 2005 64 bits on a system with Windows Server 2003 32 bi posted on Wed, 27 Dec 2006
• Update trigger posted on Wed, 27 Dec 2006
• DIFF Objects posted on Wed, 27 Dec 2006
• Installing Multiple Instances of SQL Server 2000 posted on Wed, 27 Dec 2006
• SQL 2005 Agent is not available in Studio posted on 27 Dec 2006
• Latin1_General_BIN vs Latin1_General_BIN2 in Script posted on Wed, 27 Dec 2006
• Insert a row in one table for every matching row in another table posted on 27 Dec 2006
• Has anyone here been both an Oracle and SQL Server DBA? posted on Wed, 27 Dec 2006
• NOP in COMMAND column of SYSPROCESSES - any ideas? posted on 27 Dec 2006
• Archiving Data posted on Wed, 27 Dec 2006
• q; How to write this function posted on Wed, 27 Dec 2006
• Anybody seen this error? - 37000 - Storage Allocation record not available posted on 27 Dec 2006
• ADODB.Recordset, save record at a time from different workstation posted on 27 Dec 2006
• read out transaction log posted on Wed, 27 Dec 2006
• High Availability Options posted on Wed, 27 Dec 2006
• Trigger posted on Tue, 26 Dec 2006
• Query Plans of 2005 same in 2000 QA ? posted on Tue, 26 Dec 2006
• Any idea when the next version of SQL is out ? posted on Tue, 26 Dec 2006
• SQL Server Backup Compression posted on Tue, 26 Dec 2006
• Logical Processing of SQL posted on Tue, 26 Dec 2006
• trying to use password and username in an OPENROWSET command posted on Tue, 26 Dec 2006
• sql where clause question posted on Tue, 26 Dec 2006
• COPY Package from SERVER TO SERVER posted on Tue, 26 Dec 2006
• q: convert to DeteTime posted on Tue, 26 Dec 2006
• Reason for multiple filegroups/ files? posted on Tue, 26 Dec 2006
• SQL database restore problem posted on Tue, 26 Dec 2006
• **linked server** posted on Tue, 26 Dec 2006
• SQL 2005 versions posted on Mon, 25 Dec 2006
• cannot connect to sql 2005 from isql posted on 25 Dec 2006
• Problems with executing ssis package by job posted on 25 Dec 2006
• Web Service max out at 20 SQL connections posted on Sun, 24 Dec 2006
• best way to learn SQL Server posted on 24 Dec 2006
• HDD problem posted on Sun, 24 Dec 2006
• User 'guest' does not have permission to run DBCC shrinkdatabase for database 't posted on Sun, 24 Dec 2006
• provider list empty posted on Sat, 23 Dec 2006
• Permission VS Owner posted on 23 Dec 2006
• weekday diff posted on 23 Dec 2006
• octo-processor with SQL2000 posted on Sat, 23 Dec 2006
• Learning SQL Server (no software at home) posted on 22 Dec 2006
• Specified SQL server not found posted on 22 Dec 2006
• replicating with Active directory posted on Fri, 22 Dec 2006
• SSIS package erroring through scheduled job posted on 22 Dec 2006
• Restoring a database posted on 22 Dec 2006
• VARCHAR trivia? posted on Fri, 22 Dec 2006
• save binary files to a SQLExpress database posted on Fri, 22 Dec 2006
• Unable to touch a folder to attach a database posted on Fri, 22 Dec 2006
• IO completion listener error posted on 22 Dec 2006
• sqlservr.exe -m not single user posted on Fri, 22 Dec 2006
• SQL server self healing posted on Fri, 22 Dec 2006
• locking hint versus isolation level posted on Fri, 22 Dec 2006
• Full Recovery model and transaction log posted on Fri, 22 Dec 2006
• Question on 'load/replace" in SQL Server posted on 22 Dec 2006
• Path of SystemDB during SQL Server 2005 Installation posted on Fri, 22 Dec 2006
• SQL-Server 2005 and Windows VISTA posted on Fri, 22 Dec 2006
• query for this purpose posted on 21 Dec 2006
• Server Renamed But Replication Still Looking for Old Name posted on Fri, 22 Dec 2006
• Mirroring posted on Thu, 21 Dec 2006
• Log backup does not truncate the log file posted on Thu, 21 Dec 2006
• Browse mssqlsystemresource.mdf (SQL Server's Resource Database) posted on Thu, 21 Dec 2006
• Need to create an "offline" database, using production SQL2000 dat posted on Thu, 21 Dec 2006
• About difference between log shipping standby and active/passive c posted on Thu, 21 Dec 2006
• Data Shaping Question (Syntax) posted on 21 Dec 2006
• sql server backup.. not able to finish posted on Thu, 21 Dec 2006
• Sorting the "insides" of a UNION posted on Thu, 21 Dec 2006
• Correlated Subquery posted on Thu, 21 Dec 2006
• Package execution failed but no error (SQL2005) posted on Thu, 21 Dec 2006
• Connection Leak posted on Thu, 21 Dec 2006
• Annoying omission in SQL Server Import and Export Wizard posted on Thu, 21 Dec 2006
• setting a column unique in design view posted on 21 Dec 2006
• Getting results from 2 tables, determined by a 3rd posted on Thu, 21 Dec 2006
• Colletions for Multi lenjuage posted on Thu, 21 Dec 2006
• What Port is Used? posted on Thu, 21 Dec 2006
• SQL 2005 Defrag Script posted on Thu, 21 Dec 2006
• Compatibility level bug? posted on Thu, 21 Dec 2006
• search phrase as google does posted on Thu, 21 Dec 2006
• Database Engine Tuning Advisor and Small Workload Files posted on Thu, 21 Dec 2006
• Pervasive SQL in same box as MSSQL 2000 ? posted on Wed, 20 Dec 2006
• bcp -- queryout posted on Wed, 20 Dec 2006
• Import fails on varchar field posted on 20 Dec 2006
• Where are all the Procedure/Statement cache stored ? posted on Wed, 20 Dec 2006
• If exists posted on Wed, 20 Dec 2006
• Expanding a database posted on Wed, 20 Dec 2006
• xp_cmdshell 'net use r: ' - Password Invalid posted on Wed, 20 Dec 2006
• How do i put column values into a single row posted on 20 Dec 2006
• QUERY: 1 SQL Server restricted access according to user account... posted on Wed, 20 Dec 2006
• Database mirroring and log growth posted on Wed, 20 Dec 2006
• Database Maintenance question... posted on Wed, 20 Dec 2006
• Database Engine Tuning Advisor Wont Suggest Any Changes :-) posted on Wed, 20 Dec 2006
• General Question about Cursor Programming posted on Wed, 20 Dec 2006
• SQL 2005 Defrag Script posted on Wed, 20 Dec 2006
• Import DB Watcom posted on Wed, 20 Dec 2006
• SQL Server 2005 DB Mirroring posted on Wed, 20 Dec 2006
• Very slow Blob inserts posted on 20 Dec 2006
• Can you link SQL 2005 DB to query Sharepoint? posted on Tue, 19 Dec 2006
• SQL Server 2000 & Oracle 9i posted on Tue, 19 Dec 2006
• sp_prepare vs sp_executesql posted on Tue, 19 Dec 2006
• Sql Server sometime starts sometime starts not when starting windows system posted on Wed, 20 Dec 2006
• SQL Server Backup Job - Map Drive posted on Tue, 19 Dec 2006
• Install system data files on the SAN for SQL2005 posted on Tue, 19 Dec 2006
• Select query blocks itself posted on Tue, 19 Dec 2006
• Security question posted on Tue, 19 Dec 2006
• Backup using the proxy account in SQL2005 posted on Tue, 19 Dec 2006
• Problems with Profiler on SQL 2k5 posted on Tue, 19 Dec 2006
• A differential backup that seems to darn big... posted on 19 Dec 2006
• Performance Monitor SQL Counters question posted on Tue, 19 Dec 2006
• For/Next loop to process INSERT INTO statement posted on Tue, 19 Dec 2006
• Select result into file posted on Tue, 19 Dec 2006
• evils of dynamic SQL posted on Tue, 19 Dec 2006
• Uninstalling 2005 posted on Tue, 19 Dec 2006
• what command to see all SQL Servers on the network ? posted on Tue, 19 Dec 2006
• Base64 posted on Tue, 19 Dec 2006
• Warning: unable to allocate 'min server memory' posted on 19 Dec 2006
• Setting permissions for a Asp.Net website using a Sql2005 database posted on 19 Dec 2006
• Error Message 8152 posted on Tue, 19 Dec 2006
• SQL Server performance over internet connection posted on 19 Dec 2006
• Cannot Defrag Index posted on 19 Dec 2006
• How to include more databases in DB Mainteance Plan for SQL Server 2005 posted on Tue, 19 Dec 2006
• BULK INSERT - error column too long posted on 19 Dec 2006
• SQL2K Restore 133GB database question posted on Mon, 18 Dec 2006
• How do I compact the LDB database? posted on Tue, 19 Dec 2006
• upgrade to SQL 2005 posted on Tue, 19 Dec 2006
• Linked server (Access file) posted on Mon, 18 Dec 2006
• Getting rid of unused indexes - sql server 2000 posted on Mon, 18 Dec 2006
• Does Tlog actually contain data ? posted on Mon, 18 Dec 2006
• Error in Backup posted on 18 Dec 2006
• object ownership question posted on Tue, 19 Dec 2006
• Disk permission to move SQL 2005 databases too... posted on Mon, 18 Dec 2006
• how to synchronize dataabase from SQLServer2000 to SQLServer 2005 posted on Tue, 19 Dec 2006
• How to backup database posted on 18 Dec 2006
• Regarding sp_spaceused sp posted on Mon, 18 Dec 2006
• Can't change Memory in SQL 2K posted on Mon, 18 Dec 2006
• Troubleshooting SQL server posted on Mon, 18 Dec 2006
• Regarding sp_spaceused sp posted on Mon, 18 Dec 2006
• Help with migrating jobs from SQL 2000 to SQL 2005 posted on Mon, 18 Dec 2006
• Linked server issues for named instances. posted on Mon, 18 Dec 2006
• Backup and Restore Guidelines posted on Mon, 18 Dec 2006
• Nightly Windows reboot posted on Mon, 18 Dec 2006
• SQL 2005 Partial db restore from full backup? posted on 18 Dec 2006
• Backing up Tables posted on 18 Dec 2006
• SQL Server 2005 Security posted on 18 Dec 2006
• Stored Procedure Query Problem posted on Mon, 18 Dec 2006
• relationship between set ansi_defaults and set implicit_transactio posted on Mon, 18 Dec 2006
• Help-Can I use 4 GB memory by SQL Server2000? posted on Mon, 18 Dec 2006
• Uninstalling the default instance posted on Mon, 18 Dec 2006
• SQL Server Agent not running posted on Mon, 18 Dec 2006
• xp_cmdshell posted on 18 Dec 2006
• Trigger Help... posted on 18 Dec 2006
• Question on a join posted on 18 Dec 2006
• Running a 3 step dts process serially in SQL Server 2000 posted on Mon, 18 Dec 2006
• probably a simple question. aggregating aggregates posted on Mon, 18 Dec 2006
• Adding users from cursor posted on 18 Dec 2006
• Backups Question? posted on Mon, 18 Dec 2006
• Split Data File into Multiple File Groups.. posted on 18 Dec 2006
• Can 32 bit SQL 2005 run on a 64 bit processor? posted on Mon, 18 Dec 2006
• how to improve memory utilization?? posted on 18 Dec 2006
• Application architecture posted on Mon, 18 Dec 2006
• Get executed sql command with parameters posted on Mon, 18 Dec 2006
• DBCC DBREINDEX posted on Mon, 18 Dec 2006
• SQL 2005 Express with Advanced Services: missing providers posted on Mon, 18 Dec 2006
• HELP: SQL Server Service can't start up!!! posted on Mon, 18 Dec 2006
• Re Order table posted on 18 Dec 2006
• How to include more databases in DB Maintenance Plan ? posted on Mon, 18 Dec 2006
• query: child of child of child of...: Which are the descendants? posted on Mon, 18 Dec 2006
• How to view log file posted on 17 Dec 2006
• DateTime variable problem posted on Mon, 18 Dec 2006
• Why is it using index scan instead of index seek??? posted on Sun, 17 Dec 2006
• "Multiple Cascade Paths Error in SQL Server" posted on 17 Dec 2006
• Database Corruption (Please help!!) posted on Sun, 17 Dec 2006
• [SQL 2005] SQLCLR UDT Comparison Methods posted on Sun, 17 Dec 2006
• Where to find SQL Server Integration Services posted on Sun, 17 Dec 2006
• Failed Upgrade to SQL Server 2005 SP1 - Error KB913090 posted on 16 Dec 2006
• Calculated Fields posted on Fri, 15 Dec 2006
• Default Databases and Windows Groups posted on Fri, 15 Dec 2006
• 'Database Mail' posted on Fri, 15 Dec 2006
• How to use CTRL+SHIFT+INSERT to insert template in Management Stud posted on Fri, 15 Dec 2006
• arrrgh why Java over PL/SQL posted on Fri, 15 Dec 2006
• SQL 2005 Error 80080e14 when installing MS CRM???? posted on Fri, 15 Dec 2006
• Linked Server Security Pass User ID posted on Fri, 15 Dec 2006
• Loss of table permissions, DB move domain to workgroup posted on 15 Dec 2006
• Daylight Savings Time Change in 2007 posted on Fri, 15 Dec 2006
• how to shrink Trx Log posted on Sat, 16 Dec 2006
• update triggers on underlying tables of a view posted on 15 Dec 2006
• Sql 2005 slow inserts/updates on large tables with indexes posted on Fri, 15 Dec 2006
• SQL Licensing in Web Environment posted on 15 Dec 2006
• SQL 2005 Question posted on 15 Dec 2006
• Anyone know how to stop a restore? "Database cannot be opened. It is in the midd posted on 15 Dec 2006
• Anyone know how to stop a restore? "Database cannot be opened. It is in the midd posted on 15 Dec 2006
• SQL Licensing in Web Environment posted on 15 Dec 2006
• change recovery mode posted on Fri, 15 Dec 2006
• Temp variable as AND operand posted on 15 Dec 2006
• Deployment/copy of Db from remote server posted on 15 Dec 2006
• cannot locally telnet to 1433 but Mgt Studio ok ? posted on Fri, 15 Dec 2006
• nvarchar vs varchar for .net application. posted on 15 Dec 2006
• Permissions for tables and Sprocs posted on 15 Dec 2006
• LCS 2005 posted on Fri, 15 Dec 2006
• SQL Agent job failure posted on Thu, 14 Dec 2006
• Backup/restore advice targeting a particular customer in database posted on Thu, 14 Dec 2006
• EXEC stored procedure posted on Fri, 15 Dec 2006
• q; Compare Two Dates posted on Thu, 14 Dec 2006
• Writing update to a logging table posted on Fri, 15 Dec 2006
• 8GB Ram, /PAE, /3GB, AWE etc. set Max & Min SQL memory to 6GB or 7Gb posted on 14 Dec 2006
• DBCC CHECKDB posted on Thu, 14 Dec 2006
• Heeeelp !!! Can't insert any DATE anymore in table ! posted on Thu, 14 Dec 2006
• Check Server Disk Space Daily posted on Thu, 14 Dec 2006
• Scripting a database template posted on Thu, 14 Dec 2006
• SQL Server running on the High Performance Cluster posted on Thu, 14 Dec 2006
• query a table on different server instance posted on Thu, 14 Dec 2006
• Question on sqlmaint scripts posted on 14 Dec 2006
• How to uninstall SQL Server2005 ? posted on Thu, 14 Dec 2006
• DBCC UpdateUsage posted on Thu, 14 Dec 2006
• who did it? posted on Thu, 14 Dec 2006
• sql server 7.0 - "update statistics" - no indexes on table posted on 14 Dec 2006
• how to get users out of sql server posted on Thu, 14 Dec 2006
• Need to use "USE" in a stored Proc posted on 14 Dec 2006
• automatic sequence number by id posted on Thu, 14 Dec 2006
• View SQLDmpr.mdmp File posted on Thu, 14 Dec 2006
• When should I use SQL Browser? posted on Thu, 14 Dec 2006
• linked server to access posted on Thu, 14 Dec 2006
• ObsoletedSprocException is being thrown posted on 14 Dec 2006
• Returning the error message in a stored proc posted on 14 Dec 2006
• Can I turn browser service off with multiple nics / Ips? posted on Thu, 14 Dec 2006
• Mgmt Studio posted on Thu, 14 Dec 2006
• 2K Tranaction Log Recovery with Corrupt Backup posted on Thu, 14 Dec 2006
• Transferring data between instances posted on Thu, 14 Dec 2006
• Foreign Keys posted on Thu, 14 Dec 2006
• who understands SQL Server? --- agghhhhhhh...... posted on 14 Dec 2006
• Callind Stored Proc from Stored Proc posted on Thu, 14 Dec 2006
• A question on when to use bulk logged recovery mode posted on Thu, 14 Dec 2006
• failed to restore db from SQL 2005 to SQL 2000 posted on Thu, 14 Dec 2006
• One table have many columns posted on Thu, 14 Dec 2006
• Log shipping trn file retention posted on Wed, 13 Dec 2006
• copy from sql to access posted on 13 Dec 2006
• urgent: SQL 2005 authentication posted on Thu, 14 Dec 2006
• Retrieve list of largest tables in a database posted on 13 Dec 2006
• to_date(null) posted on Wed, 13 Dec 2006
• Query works in 2000 but not 2005 posted on 13 Dec 2006
• Date loop posted on Wed, 13 Dec 2006
• Change SQL 2000 Server 64bit collation posted on Wed, 13 Dec 2006
• HyperTreading and SQL 2000 licenses. posted on Wed, 13 Dec 2006
• Server Mgmt Studio question posted on Wed, 13 Dec 2006
• Appending from one column to another for every row in a table posted on Wed, 13 Dec 2006
• SQLserver2005 and SQLserver2000 on the same computer: cannot access SQLserver200 posted on 13 Dec 2006
• Alternatives when trying to keep two databases in sync... posted on 13 Dec 2006
• SQL server 2000 (32 bit) and Windows OS (64 bit) posted on 13 Dec 2006
• Users complaining of slowness posted on Wed, 13 Dec 2006
• Tedious Backup and Restore with EM posted on Wed, 13 Dec 2006
• How do I create a script to populate a table? posted on 13 Dec 2006
• Indexing of binary and varbinary posted on Wed, 13 Dec 2006
• MDF vs BAK file sizes posted on Wed, 13 Dec 2006
• Performance comparaison posted on Wed, 13 Dec 2006
• Locating recently edited tables posted on Wed, 13 Dec 2006
• SP in a View posted on 13 Dec 2006
• Little SQL icon gone in SQL Server 2005?? posted on Wed, 13 Dec 2006
• Does SQL Server 2005 Clean Up Unclosed Connections? posted on Wed, 13 Dec 2006
• "pivotting" a table... posted on Wed, 13 Dec 2006
• Incorrect syntax posted on 13 Dec 2006
• setting the number of jobs executed in parallel posted on Wed, 13 Dec 2006
• Need help with an SQL query and creating Variables for my application?? posted on 12 Dec 2006
• Whether Service Pack Installed on SQL server 2005 posted on Tue, 12 Dec 2006
• xp_cmdshell ACCESS IS DENIED posted on Tue, 12 Dec 2006
• 2005 DB backwards-compatible to 2000? posted on Tue, 12 Dec 2006
• Change values in SSIS. posted on Tue, 12 Dec 2006
• Login failed for user '(null)'... posted on Tue, 12 Dec 2006
• Alternating INSERTs fail posted on Tue, 12 Dec 2006
• Restoring Multiple Databases Drains System Memory posted on Tue, 12 Dec 2006
• A Real Sql Server 2005 Bug! A Real Sql Server Bug! posted on Tue, 12 Dec 2006
• Server Registration in Sql Server 2005 posted on Tue, 12 Dec 2006
• RI Question: Declarative vs Trigger posted on Tue, 12 Dec 2006
• SQL Server Replication Issue posted on 12 Dec 2006
• convert posted on Tue, 12 Dec 2006
• System Commands used by SQL 2K Maintenance Plans? posted on Tue, 12 Dec 2006
• How do I find the db name from a stored procedure in the db posted on Tue, 12 Dec 2006
• Why do sp_helpdb return maxsize Unlimited for Express Edition posted on Tue, 12 Dec 2006
• most i/o logs or database posted on 12 Dec 2006
• Visual Studio on a MS-SQL 2005 Server posted on 12 Dec 2006
• Conversion posted on 12 Dec 2006
• Restore? posted on Tue, 12 Dec 2006
• Traces, tables and triggers posted on Tue, 12 Dec 2006
• Table update issue posted on 12 Dec 2006
• Certification Signature posted on Mon, 11 Dec 2006
• Visual Studio 2005 in the installation of SQL Server 2005 posted on Mon, 11 Dec 2006
• SQL Server 7 - "Unicode Comparison" won't let me restore posted on Mon, 11 Dec 2006
• How do i get rid of a SQL Server login-prompt. posted on 11 Dec 2006
• connection error posted on Mon, 11 Dec 2006
• How to dynamically choose whether to SUM() column or GROU BY this column? posted on 11 Dec 2006
• Restore only few tables of the database posted on Tue, 12 Dec 2006
• Disk Crash Recover - Won't Recover my SQL Database posted on Mon, 11 Dec 2006
• Database Mail posted on 11 Dec 2006
• differentials question - can i skip a full backup? posted on 11 Dec 2006
• OS requirements for SQL 2000 posted on Mon, 11 Dec 2006
• Alert posted on Mon, 11 Dec 2006
• SQL Server Express posted on 11 Dec 2006
• Event 697 on SQL2005 Servers posted on Mon, 11 Dec 2006
• Reducing physical transaction log file size. posted on Mon, 11 Dec 2006
• Licensing question... posted on 11 Dec 2006
• Problem connecting to SQL 2005 from MS Access posted on Mon, 11 Dec 2006
• Query help (NOT IN vs. derived table vs. FROM clause) posted on Mon, 11 Dec 2006
• How to get Procedure call text from within SQL Stored Procedure posted on 11 Dec 2006
• Table Size posted on Mon, 11 Dec 2006
• Database Maintenance Plan for SQL Server 2005 Problem posted on Mon, 11 Dec 2006
• trigger status posted on Mon, 11 Dec 2006
• How to take data from the corrupted table. posted on 10 Dec 2006
• Mirrored db - Witness server multiple networks posted on Sun, 10 Dec 2006
• Restoring Transaction log posted on 10 Dec 2006
• SQL Server/Vista and D: Disk Drive Visibility posted on Sun, 10 Dec 2006
• Safely updating stored procedures, functions and table structure with minimal do posted on 10 Dec 2006
• q; using SSIS posted on Sun, 10 Dec 2006
• FullText posted on 10 Dec 2006
• Remote Accessing posted on 10 Dec 2006
• Can I do this ? posted on Sat, 9 Dec 2006
• Who is starting SQLSERVR.EXE? posted on Sat, 9 Dec 2006
• Date field in exported excel file posted on Sat, 9 Dec 2006
• Trace to Table posted on Sat, 9 Dec 2006
• Checking a database for physical damage posted on 8 Dec 2006
• Copy Stored proc from one DB to other posted on 8 Dec 2006
• Why would bad login attempts not get logged with the source IP? posted on Fri, 08 Dec 2006
• 2005 features not working posted on Fri, 8 Dec 2006
• Importing Data into SQL 2005 posted on Fri, 8 Dec 2006
• @@version, add database to a named instance? posted on Fri, 8 Dec 2006
• "dbcc dbreindex" vs "dbcc reindex" posted on 8 Dec 2006
• Execute permission denied on 'sp_xml_preparedocument' posted on Sat, 09 Dec 2006
• Delete previous backup in append mode sql 2000 posted on 8 Dec 2006
• multi instances of sql server posted on Fri, 8 Dec 2006
• How to get rid of Ghost Pages posted on Fri, 8 Dec 2006
• SQL Server Version posted on 8 Dec 2006
• Why won't Service Browser bind to my LAN port posted on 8 Dec 2006
• Insert one row for each day posted on 8 Dec 2006
• in oracle we have a functionality "cursor" ... do we have some replacement of it posted on 8 Dec 2006
• How to add document type in full - text search (ifiter) posted on Thu, 7 Dec 2006
• Defrag local drive in SQL Server 2005 posted on Thu, 7 Dec 2006
• Poor Performance after upgrading from 2000 to 2005 posted on Thu, 7 Dec 2006
• Violation of PRIMARY KEY Constraint Error After Restore from a Backup File posted on 7 Dec 2006
• Delete TempDB Database on SQL Server 2000 EE posted on Thu, 7 Dec 2006
• Restoring deleted records with out of row blobs? posted on Thu, 7 Dec 2006
• Trigger to update field based on criteria posted on 7 Dec 2006
• standard or enterprise or developer edition? posted on Thu, 7 Dec 2006
• Asymmetric communication from ms-sql-m protocol from an SQL Cluster posted on 7 Dec 2006
• Quoted Identifier ON as default posted on Thu, 07 Dec 2006
• SQL2005 & Small business server2003 R2 posted on Thu, 07 Dec 2006
• Drive space for db and log backups posted on Thu, 7 Dec 2006
• Table updates from server posted on 7 Dec 2006
• retrieve Datetime posted on 7 Dec 2006
• xp_sendmail permission issued from a job posted on Thu, 7 Dec 2006
• Recover Transaction Log posted on Thu, 7 Dec 2006
• C:\SQL.LOG File, And growing very large posted on Thu, 7 Dec 2006
• SQL Time Specific Daily Query posted on 7 Dec 2006
• Max Degree of Parallelism - clearification posted on Thu, 07 Dec 2006
• What happens when when a row is inserted into a table with indexes? posted on Thu, 07 Dec 2006
• SQL 2005: Service Pack 2: Timing? posted on Thu, 7 Dec 2006
• 64 bit SQL 2005 memory problem posted on Thu, 7 Dec 2006
• ado-sql-oledb posted on Thu, 7 Dec 2006
• Info Isa 2006? posted on Thu, 7 Dec 2006
• SQL ODBC not listing database. posted on 7 Dec 2006
• Does SQL Server handles time zone difference? posted on Thu, 7 Dec 2006
• Starting up the database XXX (Error ID 17137) posted on Thu, 7 Dec 2006
• Compare Databases posted on Wed, 6 Dec 2006
• Incorrect LicenseType & NumLicenses returned by SERVERPROPERTY fnc posted on Wed, 6 Dec 2006
• MS DTC timeout posted on Thu, 7 Dec 2006
• SQL Server 2000 server time question posted on Thu, 7 Dec 2006
• grant select to public posted on Wed, 6 Dec 2006
• Recover data from corrupt DB posted on Wed, 6 Dec 2006
• SQL 2005: Querying a table or view posted on Wed, 06 Dec 2006
• Need to transform table data to excel 2003 files posted on Wed, 6 Dec 2006
• SQL errors on running stored procedure... posted on Wed, 6 Dec 2006
• Transaction log files get smaller posted on Wed, 6 Dec 2006
• data export to flat file posted on Wed, 06 Dec 2006
• Jobs and logins posted on Wed, 6 Dec 2006
• Update Statistics with fullscan blocks myself posted on Wed, 6 Dec 2006
• Need help w/ scripting tables posted on 6 Dec 2006
• What is good and what is bad in the Graphical Exec Plan? posted on Wed, 6 Dec 2006
• Third party tool backup not Supported by Microsoft?!!!! posted on Wed, 6 Dec 2006
• loading status after restore database posted on Wed, 6 Dec 2006
• SQL 2005 Encrypted columns posted on Wed, 6 Dec 2006
• attaching to msdb db posted on Wed, 6 Dec 2006
• SQL 2000 and awe memory posted on Wed, 6 Dec 2006
• Max Memory SQL2K EE on W2K3 EE posted on Wed, 6 Dec 2006
• Question on Backup/Restore posted on 6 Dec 2006
• What is the difference between dbo schema and db_owner? posted on Wed, 6 Dec 2006
• Exporting Datas to Excel File posted on 6 Dec 2006
• Script to peg all CPUs posted on Tue, 5 Dec 2006
• How to allow null by SQL posted on Wed, 6 Dec 2006
• OLE automation posted on Wed, 6 Dec 2006
• Transaction log backups way bigger than differential backups? posted on Tue, 5 Dec 2006
• Moving SQL Server posted on Tue, 5 Dec 2006
• SQL 2005 WORKGROUP Installation Problem Please help! posted on Tue, 5 Dec 2006
• Import multiple .DBF files w/SSIS - OLE DB posted on 5 Dec 2006
• NTBackup posted on Tue, 5 Dec 2006
• Database on SQL Ent Trial buying Standard Edt posted on Tue, 5 Dec 2006
• Telling if SQL2005 is running posted on Tue, 5 Dec 2006
• Does Sql 2005 allow ORDER BY @Variable ? posted on Tue, 5 Dec 2006
• error running a vb script on servr 2003 posted on 5 Dec 2006
• Windows 2003 SP1 posted on Tue, 5 Dec 2006
• Error Connecting to Database (SQL Server 2005)! posted on 5 Dec 2006
• Slow hard disk? posted on Tue, 5 Dec 2006
• Managing Large Views on Large Tables posted on Tue, 5 Dec 2006
• begin transactions posted on 5 Dec 2006
• perf question posted on Tue, 5 Dec 2006
• Can 32 bit webserver work with a 64 bit db server? posted on Tue, 5 Dec 2006
• Could not create tempdb - SQL Server 2005 with SP1 posted on Tue, 5 Dec 2006
• SQL Server Database Size/Free Space Query posted on 5 Dec 2006
• What type of replication should i use? posted on 5 Dec 2006
• Difference between SQL Server Express Utility and SQL Server Server Management S posted on Tue, 05 Dec 2006
• How can i access internal row id of sql server posted on 5 Dec 2006
• Using current time as parameter for a stored procedure posted on Tue, 5 Dec 2006
• backuping to tape posted on Tue, 5 Dec 2006
• Schema versioning posted on Tue, 5 Dec 2006
• AWE Enabled for 4gb but sqlsevr.exe only uses 74,172k posted on 4 Dec 2006
• FULL and Tran Backup posted on Mon, 4 Dec 2006
• Easy way to find size of data returned in SQL 2005 ? posted on Mon, 4 Dec 2006
• Data Encryption posted on Mon, 4 Dec 2006
• Transaction log posted on Mon, 4 Dec 2006
• Application Server to Point to Mirror Server posted on 4 Dec 2006
• How to alter the data type of a field posted on Tue, 5 Dec 2006
• Alter Index issue & Try/Catch question posted on 4 Dec 2006
• disable external connections to sql server 2000 posted on Mon, 4 Dec 2006
• include .mdf, .ndf, and .ldf files in exclusion list posted on Mon, 4 Dec 2006
• SQL2K5 XQuery data types posted on Mon, 4 Dec 2006
• mirror db blocking issue posted on 4 Dec 2006
• Scheduled job with @active_start_time AFTER @active_end_time posted on 4 Dec 2006
• How do I add an AS400 system as a Linked server?? posted on Mon, 4 Dec 2006
• Enabling service broker posted on Mon, 4 Dec 2006
• User access right: posted on Mon, 4 Dec 2006
• Determine When/Who Deleted Database posted on Mon, 4 Dec 2006
• Fastest way to delete to huge datarow? posted on 4 Dec 2006
• Encrypt sproc still returns NULL's to non DBO's. posted on Mon, 4 Dec 2006
• User security setting in SQL Server 2000 posted on Mon, 4 Dec 2006
• Reserved words etc. posted on Sun, 3 Dec 2006
• RAID 5 vs RAID 10 for reads posted on Sun, 3 Dec 2006
• Restoring Master DB to a clustered server posted on Sun, 3 Dec 2006
• Error Msg 701(on sql2000)---no insufficient system memory to run q posted on Sun, 3 Dec 2006
• Grid computing as it applies to SQL Server.. posted on Sun, 3 Dec 2006
• dbcc inputbuffer equivalent in SQL 2005 posted on Sun, 3 Dec 2006
• List DMVs posted on Sun, 3 Dec 2006
• ProSQL posted on Mon, 04 Dec 2006
• How to shrink db posted on Sun, 3 Dec 2006
• Restore execution sequence? posted on Sun, 3 Dec 2006
• Database corrupted posted on Sun, 3 Dec 2006
• SET ANSI_NULLS ON/OFF posted on Sun, 3 Dec 2006
• q; Running SP with a different user posted on Sat, 2 Dec 2006
• Force Encryption on client with Thawte certificate posted on 2 Dec 2006
• Restoring SQL 2005 Analysis service database backup on SQL 2000 posted on 2 Dec 2006
• q; Registration access denied posted on Sat, 2 Dec 2006
• Integrity Checks Fail posted on Sat, 2 Dec 2006
• Trans log backup frequency posted on Fri, 1 Dec 2006
• order of maintenance task posted on Fri, 1 Dec 2006
• Optimal Backup posted on Fri, 1 Dec 2006
• Changing display-name in Database Mail posted on 1 Dec 2006
• Horrizontal partition posted on 1 Dec 2006
• How to write sp_helptext to file ? posted on 1 Dec 2006
• Find "current database" posted on Fri, 1 Dec 2006
• Computed Column posted on Fri, 01 Dec 2006
• AWE and Perfmon Counters posted on Fri, 1 Dec 2006
• Problems moving MSDE database posted on 1 Dec 2006
• Database Growth Options posted on Fri, 1 Dec 2006
• Adding processors after the fact posted on Fri, 01 Dec 2006
• SQL Server 2000 Errorlog Errors - posted on Fri, 1 Dec 2006
• Ignore NULLs in index posted on Fri, 1 Dec 2006
• SQL Server Crash posted on Fri, 1 Dec 2006
• Memory Allocation posted on Fri, 1 Dec 2006
• Extract color formatted text from code editor? posted on Fri, 1 Dec 2006
• history of Process info posted on Fri, 1 Dec 2006
• Recover a standby db posted on Fri, 1 Dec 2006
• Help - Suggestions on 1 day window for Production Server posted on Fri, 1 Dec 2006
• Triggers with SQL Server 2005 and linked UniOleDb Servers posted on 1 Dec 2006
• Insert transaction batch size posted on Fri, 1 Dec 2006
• attaching a database in SQL 2005 Express posted on Fri, 1 Dec 2006
• q; user running trigger posted on Fri, 1 Dec 2006
• Should I apply Post SP1 hotfix ? posted on Fri, 1 Dec 2006
• SQL Server 2000 first time backup question posted on Fri, 1 Dec 2006
• QA database change take too much time posted on Fri, 1 Dec 2006
• Clear the resultset during batch processing posted on 30 Nov 2006
• SQL 2005 Memory Usage posted on 30 Nov 2006
• Full Text Search across multiple tables posted on Thu, 30 Nov 2006
• SQL join question posted on 30 Nov 2006