Newsgroups : Microsoft : microsoft.public.sqlserver.server : December 2006
microsoft.public.sqlserver.server
Messages for December 2006
Messages from microsoft.public.sqlserver.server archived for December 2006:
- IO Completion Listener Worker appears to be non-yielding on Node posted by Vishal on 31 Dec 2006
- how is the cache broken up in SQL 2000? posted by Hassan on Sun, 31 Dec 2006
- sessions vs connections posted by Hassan on Sat, 30 Dec 2006
- Second Instance problem posted by Armando on Sat, 30 Dec 2006
- [Ugent] attach Database error in SQL 7.0 posted by Gary on Sun, 31 Dec 2006
- Database Maintenance Planner option disabled posted by unimatt..@gmail.com on 30 Dec 2006
- SQL Server 2005 Express vs MSDE posted by Peter Zolja on Sat, 30 Dec 2006
- Open default DB in Enterprise Manager upon connecting to server (SQL2000) posted by Vsevolod Ukrainsky on Sat, 30 Dec 2006
- SQL 2005 useful catalog views and DMVs posted by Hassan on Fri, 29 Dec 2006
- Viewing column names of SQL table posted by Yvette on 29 Dec 2006
- SQL 2000 64 bit on x64 Win 2003 Server posted by Hassan on Fri, 29 Dec 2006
- server hosed? Very slow server posted by David C on 29 Dec 2006
- Moving the Reprot Server log files in 2005 posted by MACason on Fri, 29 Dec 2006
- Why the term "Truncate Log" posted by JayKon on Fri, 29 Dec 2006
- representative sub-data posted by voldeng..@gmail.com on 29 Dec 2006
- How often and when should the sp_recompile procedure be used posted by thejamie on Fri, 29 Dec 2006
- Sql 2003 posted by n_t_schul..@hotmail.com on 29 Dec 2006
- q; INSRET/UPDATE trigger posted by JIM.H. on Fri, 29 Dec 2006
- Transaction log backups--file size posted by Harlan Messinger on Fri, 29 Dec 2006
- Migrate jobs from production to backup posted by thejamie on Fri, 29 Dec 2006
- stored procedure compilation - broken posted by jhbp on 29 Dec 2006
- Dump SQLExpress Data posted by Arne Garvander on Fri, 29 Dec 2006
- caching a view? posted by voldeng..@gmail.com on 29 Dec 2006
- Production DB Modifications posted by morphius on Thu, 28 Dec 2006
- Is database mirroring the solution for this scenario? posted by DotComDBA on Thu, 28 Dec 2006
- When will SP2 be released? posted by enrique on Fri, 29 Dec 2006
- Auditing table access posted by stavros on 28 Dec 2006
- Load Test posted by morphius on Thu, 28 Dec 2006
- Security Permissions Question posted by Thunder on Thu, 28 Dec 2006
- Help With Query posted by Charles A. Lackman on Thu, 28 Dec 2006
- About change log file folder after database was created posted by Iter on Thu, 28 Dec 2006
- How to find rows marked for replication? posted by tootsui..@gmail.com on 28 Dec 2006
- Determine which edition of the engine is used by which instance? posted by Michael on Thu, 28 Dec 2006
- I want to activate trace flag 1807 an have it persist across reboots/restarts posted by war_wheel..@yahoo.com on 28 Dec 2006
- SQL Server Express Service Pack 2 maintenance plan wizard posted by John on Thu, 28 Dec 2006
- Retrieve database size information posted by Tim Kelley on Thu, 28 Dec 2006
- SQL 2000 on a em64T server. posted by Roberto Souza on Thu, 28 Dec 2006
- Silent installs posted by Mark on Thu, 28 Dec 2006
- SQL Server statistics posted by steingo..@gmail.com on 28 Dec 2006
- Why Clustered Index 'SCAN'.....instead of 'SEEK' posted by Dutt on 27 Dec 2006
- Load on SQL Server Database posted by sk.rasheedfarh..@gmail.com on 27 Dec 2006
- PF Usage posted by morphius on Wed, 27 Dec 2006
- AWE /3GB performance posted by John Grant on Wed, 27 Dec 2006
- listing of sp_who posted by JayKon on Wed, 27 Dec 2006
- Replacement for my LIKE Clause posted by varkey.math..@wipro.com on 27 Dec 2006
- SQL Server 2005 64 bits on a system with Windows Server 2003 32 bi posted by Ivar on Wed, 27 Dec 2006
- Update trigger posted by morphius on Wed, 27 Dec 2006
- DIFF Objects posted by morphius on Wed, 27 Dec 2006
- Installing Multiple Instances of SQL Server 2000 posted by PeterR on Wed, 27 Dec 2006
- SQL 2005 Agent is not available in Studio posted by geeknumb21..@yahoo.com on 27 Dec 2006
- Latin1_General_BIN vs Latin1_General_BIN2 in Script posted by sqlextreme on Wed, 27 Dec 2006
- Insert a row in one table for every matching row in another table posted by Lauren Quantrell on 27 Dec 2006
- Has anyone here been both an Oracle and SQL Server DBA? posted by ChrisR on Wed, 27 Dec 2006
- NOP in COMMAND column of SYSPROCESSES - any ideas? posted by bourg..@gmail.com on 27 Dec 2006
- Archiving Data posted by Ben UK on Wed, 27 Dec 2006
- q; How to write this function posted by JIM.H. on Wed, 27 Dec 2006
- Anybody seen this error? - 37000 - Storage Allocation record not available posted by jonathan.beckett on 27 Dec 2006
- ADODB.Recordset, save record at a time from different workstation posted by manojkumarshin..@gmail.com on 27 Dec 2006
- read out transaction log posted by Marcus Pink on Wed, 27 Dec 2006
- High Availability Options posted by Andrew Hayes on Wed, 27 Dec 2006
- Trigger posted by morphius on Tue, 26 Dec 2006
- Query Plans of 2005 same in 2000 QA ? posted by Hassan on Tue, 26 Dec 2006
- Any idea when the next version of SQL is out ? posted by Hassan on Tue, 26 Dec 2006
- SQL Server Backup Compression posted by Hassan on Tue, 26 Dec 2006
- Logical Processing of SQL posted by Hassan on Tue, 26 Dec 2006
- trying to use password and username in an OPENROWSET command posted by Paul on Tue, 26 Dec 2006
- sql where clause question posted by MarkAurit on Tue, 26 Dec 2006
- COPY Package from SERVER TO SERVER posted by thejamie on Tue, 26 Dec 2006
- q: convert to DeteTime posted by JIM.H. on Tue, 26 Dec 2006
- Reason for multiple filegroups/ files? posted by ChrisR on Tue, 26 Dec 2006
- SQL database restore problem posted by Marcus Pink on Tue, 26 Dec 2006
- **linked server** posted by M on Tue, 26 Dec 2006
- SQL 2005 versions posted by Hassan on Mon, 25 Dec 2006
- cannot connect to sql 2005 from isql posted by AH on 25 Dec 2006
- Problems with executing ssis package by job posted by Qwert on 25 Dec 2006
- Web Service max out at 20 SQL connections posted by Erin Loy on Sun, 24 Dec 2006
- best way to learn SQL Server posted by tmags..@gmail.com on 24 Dec 2006
- HDD problem posted by xezo on Sun, 24 Dec 2006
- User 'guest' does not have permission to run DBCC shrinkdatabase for database 't posted by DaveF on Sun, 24 Dec 2006
- Problem Upgrading From SQL 2000 To SQL 2005 posted by Rick on Sat, 23 Dec 2006
- provider list empty posted by PBsoft on Sat, 23 Dec 2006
- Permission VS Owner posted by Benny on 23 Dec 2006
- weekday diff posted by jack.smith.s..@gmail.com on 23 Dec 2006
- octo-processor with SQL2000 posted by Pete Certo on Sat, 23 Dec 2006
- Learning SQL Server (no software at home) posted by Jerry on 22 Dec 2006
- Specified SQL server not found posted by joh..@udel.edu on 22 Dec 2006
- replicating with Active directory posted by GaryDean on Fri, 22 Dec 2006
- SSIS package erroring through scheduled job posted by jeff on 22 Dec 2006
- Restoring a database posted by pshea..@gmail.com on 22 Dec 2006
- VARCHAR trivia? posted by Elaine on Fri, 22 Dec 2006
- save binary files to a SQLExpress database posted by Paul on Fri, 22 Dec 2006
- Unable to touch a folder to attach a database posted by John on Fri, 22 Dec 2006
- IO completion listener error posted by sam.m.gardiner on 22 Dec 2006
- sqlservr.exe -m not single user posted by Marcos Paione on Fri, 22 Dec 2006
- SQL server self healing posted by Cameron on Fri, 22 Dec 2006
- locking hint versus isolation level posted by thejamie on Fri, 22 Dec 2006
- Full Recovery model and transaction log posted by fniles on Fri, 22 Dec 2006
- Question on 'load/replace" in SQL Server posted by DataPro on 22 Dec 2006
- Path of SystemDB during SQL Server 2005 Installation posted by MB on Fri, 22 Dec 2006
- SQL-Server 2005 and Windows VISTA posted by r06 on Fri, 22 Dec 2006
- query for this purpose posted by MadhavC on 21 Dec 2006
- Server Renamed But Replication Still Looking for Old Name posted by Andrew Hayes on Fri, 22 Dec 2006
- Mirroring posted by BigSam on Thu, 21 Dec 2006
- Log backup does not truncate the log file posted by Leila on Thu, 21 Dec 2006
- Browse mssqlsystemresource.mdf (SQL Server's Resource Database) posted by Chris on Thu, 21 Dec 2006
- Need to create an "offline" database, using production SQL2000 dat posted by pbrill1 on Thu, 21 Dec 2006
- About difference between log shipping standby and active/passive c posted by Iter on Thu, 21 Dec 2006
- Data Shaping Question (Syntax) posted by Radu on 21 Dec 2006
- sql server backup.. not able to finish posted by Leida on Thu, 21 Dec 2006
- Sorting the "insides" of a UNION posted by Maury Markowitz on Thu, 21 Dec 2006
- Correlated Subquery posted by Ben UK on Thu, 21 Dec 2006
- Package execution failed but no error (SQL2005) posted by Frans on Thu, 21 Dec 2006
- Connection Leak posted by malkeshsheth via SQLMonster.com on Thu, 21 Dec 2006
- Annoying omission in SQL Server Import and Export Wizard posted by thejamie on Thu, 21 Dec 2006
- setting a column unique in design view posted by arun@greettech.com on 21 Dec 2006
- Getting results from 2 tables, determined by a 3rd posted by Ib Schrader on Thu, 21 Dec 2006
- Colletions for Multi lenjuage posted by sqlextreme on Thu, 21 Dec 2006
- What Port is Used? posted by Amos Soma on Thu, 21 Dec 2006
- SQL 2005 Defrag Script posted by Ben UK on Thu, 21 Dec 2006
- Compatibility level bug? posted by BerndB on Thu, 21 Dec 2006
- search phrase as google does posted by tolgay on Thu, 21 Dec 2006
- Database Engine Tuning Advisor and Small Workload Files posted by Simon Harvey on Thu, 21 Dec 2006
- Pervasive SQL in same box as MSSQL 2000 ? posted by Dennis on Wed, 20 Dec 2006
- bcp -- queryout posted by Andy on Wed, 20 Dec 2006
- Import fails on varchar field posted by tootsui..@gmail.com on 20 Dec 2006
- Where are all the Procedure/Statement cache stored ? posted by Hassan on Wed, 20 Dec 2006
- If exists posted by thejamie on Wed, 20 Dec 2006
- Expanding a database posted by Tom Reis on Wed, 20 Dec 2006
- xp_cmdshell 'net use r: ' - Password Invalid posted by Joe K. on Wed, 20 Dec 2006
- How do i put column values into a single row posted by rsap..@gmail.com on 20 Dec 2006
- QUERY: 1 SQL Server restricted access according to user account... posted by Andrew Wan on Wed, 20 Dec 2006
- Database mirroring and log growth posted by Jim Norton on Wed, 20 Dec 2006
- Database Maintenance question... posted by Saral6978 on Wed, 20 Dec 2006
- Database Engine Tuning Advisor Wont Suggest Any Changes :-) posted by Simon Harvey on Wed, 20 Dec 2006
- General Question about Cursor Programming posted by Bishop on Wed, 20 Dec 2006
- SQL 2005 Defrag Script posted by Ben UK on Wed, 20 Dec 2006
- Import DB Watcom posted by Carlo on Wed, 20 Dec 2006
- SQL Server 2005 DB Mirroring posted by Ivan on Wed, 20 Dec 2006
- Very slow Blob inserts posted by JaffaB on 20 Dec 2006
- Can you link SQL 2005 DB to query Sharepoint? posted by Jason on Tue, 19 Dec 2006
- SQL Server 2000 & Oracle 9i posted by Asif Razzaq Attari on Tue, 19 Dec 2006
- sp_prepare vs sp_executesql posted by Hassan on Tue, 19 Dec 2006
- Sql Server sometime starts sometime starts not when starting windows system posted by Rolf Welskes on Wed, 20 Dec 2006
- SQL Server Backup Job - Map Drive posted by Joe K. on Tue, 19 Dec 2006
- Install system data files on the SAN for SQL2005 posted by Johnny on Tue, 19 Dec 2006
- Select query blocks itself posted by Eduardo Sicouret on Tue, 19 Dec 2006
- Security question posted by JJ on Tue, 19 Dec 2006
- Backup using the proxy account in SQL2005 posted by Chris Wood on Tue, 19 Dec 2006
- Problems with Profiler on SQL 2k5 posted by Catadmin on Tue, 19 Dec 2006
- Having trouble using timestamp as a way of determining what to pro posted by nickdu on Tue, 19 Dec 2006
- A differential backup that seems to darn big... posted by Not the Face on 19 Dec 2006
- Performance Monitor SQL Counters question posted by Catadmin on Tue, 19 Dec 2006
- For/Next loop to process INSERT INTO statement posted by Doctorjones_md on Tue, 19 Dec 2006
- Select result into file posted by Franck Fouache on Tue, 19 Dec 2006
- evils of dynamic SQL posted by Hassan on Tue, 19 Dec 2006
- Uninstalling 2005 posted by Emma on Tue, 19 Dec 2006
- what command to see all SQL Servers on the network ? posted by Hassan on Tue, 19 Dec 2006
- Base64 posted by Franck Fouache on Tue, 19 Dec 2006
- Warning: unable to allocate 'min server memory' posted by J1C on 19 Dec 2006
- Setting permissions for a Asp.Net website using a Sql2005 database posted by Nemisis on 19 Dec 2006
- Error Message 8152 posted by Al on Tue, 19 Dec 2006
- SQL Server performance over internet connection posted by jha..@datalyzer.com on 19 Dec 2006
- Cannot Defrag Index posted by David Wimbush on 19 Dec 2006
- How to include more databases in DB Mainteance Plan for SQL Server 2005 posted by Peter on Tue, 19 Dec 2006
- BULK INSERT - error column too long posted by Franc on 19 Dec 2006
- SQL2K Restore 133GB database question posted by Uday Shivamurthy on Mon, 18 Dec 2006
- How do I compact the LDB database? posted by BJ on Tue, 19 Dec 2006
- upgrade to SQL 2005 posted by 00MichaelJordan on Tue, 19 Dec 2006
- Linked server (Access file) posted by Curtis on Mon, 18 Dec 2006
- Getting rid of unused indexes - sql server 2000 posted by Pedja on Mon, 18 Dec 2006
- Does Tlog actually contain data ? posted by Hassan on Mon, 18 Dec 2006
- Error in Backup posted by raju on 18 Dec 2006
- object ownership question posted by Alex on Tue, 19 Dec 2006
- Disk permission to move SQL 2005 databases too... posted by Andres Perales on Mon, 18 Dec 2006
- how to synchronize dataabase from SQLServer2000 to SQLServer 2005 posted by acd on Tue, 19 Dec 2006
- How to backup database posted by mrajanikrish..@gmail.com on 18 Dec 2006
- Regarding sp_spaceused sp posted by Iter on Mon, 18 Dec 2006
- Can't change Memory in SQL 2K posted by John on Mon, 18 Dec 2006
- Troubleshooting SQL server posted by Marco Shaw on Mon, 18 Dec 2006
- Regarding sp_spaceused sp posted by Iter on Mon, 18 Dec 2006
- Help with migrating jobs from SQL 2000 to SQL 2005 posted by Jarek Gal on Mon, 18 Dec 2006
- Linked server issues for named instances. posted by ChrisR on Mon, 18 Dec 2006
- Backup and Restore Guidelines posted by Joe on Mon, 18 Dec 2006
- Nightly Windows reboot posted by JayKon on Mon, 18 Dec 2006
- SQL 2005 Partial db restore from full backup? posted by JoeyD on 18 Dec 2006
- Backing up Tables posted by laura.x.kenne..@jpmorgan.com on 18 Dec 2006
- SQL Server 2005 Security posted by DataGuy on 18 Dec 2006
- Stored Procedure Query Problem posted by Bishop on Mon, 18 Dec 2006
- relationship between set ansi_defaults and set implicit_transactio posted by Peter on Mon, 18 Dec 2006
- Help-Can I use 4 GB memory by SQL Server2000? posted by Damon on Mon, 18 Dec 2006
- Uninstalling the default instance posted by Carla on Mon, 18 Dec 2006
- SQL Server Agent not running posted by JayKon on Mon, 18 Dec 2006
- xp_cmdshell posted by tolcis on 18 Dec 2006
- Trigger Help... posted by Zamael on 18 Dec 2006
- Question on a join posted by Ryan S on 18 Dec 2006
- Running a 3 step dts process serially in SQL Server 2000 posted by Sally on Mon, 18 Dec 2006
- probably a simple question. aggregating aggregates posted by Iain on Mon, 18 Dec 2006
- Adding users from cursor posted by Jim Johnson on 18 Dec 2006
- Backups Question? posted by morphius on Mon, 18 Dec 2006
- Split Data File into Multiple File Groups.. posted by Query Builder on 18 Dec 2006
- Can 32 bit SQL 2005 run on a 64 bit processor? posted by ChrisR on Mon, 18 Dec 2006
- how to improve memory utilization?? posted by tlyczko on 18 Dec 2006
- Application architecture posted by Henrik on Mon, 18 Dec 2006
- Get executed sql command with parameters posted by xezo on Mon, 18 Dec 2006
- DBCC DBREINDEX posted by SkyDave on Mon, 18 Dec 2006
- SQL 2005 Express with Advanced Services: missing providers posted by PBsoft on Mon, 18 Dec 2006
- HELP: SQL Server Service can't start up!!! posted by Andrew Wan on Mon, 18 Dec 2006
- Re Order table posted by pinhead on 18 Dec 2006
- How to include more databases in DB Maintenance Plan ? posted by Peter on Mon, 18 Dec 2006
- query: child of child of child of...: Which are the descendants? posted by Pieter on Mon, 18 Dec 2006
- How to view log file posted by Bhaskara on 17 Dec 2006
- DateTime variable problem posted by Bob on Mon, 18 Dec 2006
- Why is it using index scan instead of index seek??? posted by Pedja on Sun, 17 Dec 2006
- "Multiple Cascade Paths Error in SQL Server" posted by kosanov..@gmail.com on 17 Dec 2006
- Database Corruption (Please help!!) posted by Leila on Sun, 17 Dec 2006
- [SQL 2005] SQLCLR UDT Comparison Methods posted by Mike C# on Sun, 17 Dec 2006
- Where to find SQL Server Integration Services posted by ad on Sun, 17 Dec 2006
- Failed Upgrade to SQL Server 2005 SP1 - Error KB913090 posted by mark.anders..@ohic.com on 16 Dec 2006
- Calculated Fields posted by Liz on Fri, 15 Dec 2006
- Default Databases and Windows Groups posted by Ola Hallengren on Fri, 15 Dec 2006
- 'Database Mail' posted by Arden Smith on Fri, 15 Dec 2006
- How to use CTRL+SHIFT+INSERT to insert template in Management Stud posted by Kodi on Fri, 15 Dec 2006
- arrrgh why Java over PL/SQL posted by klabu on Fri, 15 Dec 2006
- SQL 2005 Error 80080e14 when installing MS CRM???? posted by rhalljr on Fri, 15 Dec 2006
- Linked Server Security Pass User ID posted by smoss on Fri, 15 Dec 2006
- Loss of table permissions, DB move domain to workgroup posted by cynthia.l.dy..@us.army.mil on 15 Dec 2006
- Daylight Savings Time Change in 2007 posted by Sally on Fri, 15 Dec 2006
- how to shrink Trx Log posted by TBoon on Sat, 16 Dec 2006
- update triggers on underlying tables of a view posted by nadabadan on 15 Dec 2006
- Sql 2005 slow inserts/updates on large tables with indexes posted by Alex S on Fri, 15 Dec 2006
- SQL Licensing in Web Environment posted by Sean on 15 Dec 2006
- SQL 2005 Question posted by shub on 15 Dec 2006
- Anyone know how to stop a restore? "Database cannot be opened. It is in the midd posted by brian.honeycu..@retiregroup.com on 15 Dec 2006
- Anyone know how to stop a restore? "Database cannot be opened. It is in the midd posted by brian.honeycu..@retiregroup.com on 15 Dec 2006
- SQL Licensing in Web Environment posted by Sean on 15 Dec 2006
- change recovery mode posted by Iter on Fri, 15 Dec 2006
- Temp variable as AND operand posted by Dutt on 15 Dec 2006
- Deployment/copy of Db from remote server posted by hnteknik on 15 Dec 2006
- cannot locally telnet to 1433 but Mgt Studio ok ? posted by Scott on Fri, 15 Dec 2006
- nvarchar vs varchar for .net application. posted by stucki..@gmail.com on 15 Dec 2006
- Permissions for tables and Sprocs posted by Nemisis on 15 Dec 2006
- LCS 2005 posted by Kingjo on Fri, 15 Dec 2006
- SQL Agent job failure posted by Shri.DBA on Thu, 14 Dec 2006
- Backup/restore advice targeting a particular customer in database posted by buzlite@sympatico.ca on Thu, 14 Dec 2006
- EXEC stored procedure posted by DaveF on Fri, 15 Dec 2006
- q; Compare Two Dates posted by JIM.H. on Thu, 14 Dec 2006
- Writing update to a logging table posted by Jason Huang on Fri, 15 Dec 2006
- 8GB Ram, /PAE, /3GB, AWE etc. set Max & Min SQL memory to 6GB or 7Gb posted by J1C on 14 Dec 2006
- DBCC CHECKDB posted by Viktor on Thu, 14 Dec 2006
- Heeeelp !!! Can't insert any DATE anymore in table ! posted by bthouin on Thu, 14 Dec 2006
- Check Server Disk Space Daily posted by Joe K. on Thu, 14 Dec 2006
- Scripting a database template posted by Thomas Mick on Thu, 14 Dec 2006
- SQL Server running on the High Performance Cluster posted by WizyDig on Thu, 14 Dec 2006
- query a table on different server instance posted by bangwo on Thu, 14 Dec 2006
- Question on sqlmaint scripts posted by DataPro on 14 Dec 2006
- How to uninstall SQL Server2005 ? posted by Stan SR on Thu, 14 Dec 2006
- DBCC UpdateUsage posted by cbrichards via SQLMonster.com on Thu, 14 Dec 2006
- who did it? posted by sali on Thu, 14 Dec 2006
- sql server 7.0 - "update statistics" - no indexes on table posted by lesperanc..@natpro.com on 14 Dec 2006
- how to get users out of sql server posted by Dan D. on Thu, 14 Dec 2006
- Need to use "USE" in a stored Proc posted by shub on 14 Dec 2006
- automatic sequence number by id posted by Edgar on Thu, 14 Dec 2006
- View SQLDmpr.mdmp File posted by Joe K. on Thu, 14 Dec 2006
- When should I use SQL Browser? posted by Simon Harvey on Thu, 14 Dec 2006
- linked server to access posted by Mike Read on Thu, 14 Dec 2006
- ObsoletedSprocException is being thrown posted by Tom on 14 Dec 2006
- Returning the error message in a stored proc posted by grosd..@hotmail.com on 14 Dec 2006
- Can I turn browser service off with multiple nics / Ips? posted by sqlboy2000 on Thu, 14 Dec 2006
- Mgmt Studio posted by GaryDean on Thu, 14 Dec 2006
- 2K Tranaction Log Recovery with Corrupt Backup posted by C RAMSEY on Thu, 14 Dec 2006
- Transferring data between instances posted by Alec MacLean on Thu, 14 Dec 2006
- Foreign Keys posted by Shiry on Thu, 14 Dec 2006
- who understands SQL Server? --- agghhhhhhh...... posted by de..@2bytes.co.uk on 14 Dec 2006
- Callind Stored Proc from Stored Proc posted by Billy on Thu, 14 Dec 2006
- A question on when to use bulk logged recovery mode posted by Simon Harvey on Thu, 14 Dec 2006
- failed to restore db from SQL 2005 to SQL 2000 posted by xiaomei on Thu, 14 Dec 2006
- One table have many columns posted by Jason Huang on Thu, 14 Dec 2006
- Log shipping trn file retention posted by PhilN on Wed, 13 Dec 2006
- copy from sql to access posted by hmge..@gmail.com on 13 Dec 2006
- urgent: SQL 2005 authentication posted by 00MichaelJordan on Thu, 14 Dec 2006
- Retrieve list of largest tables in a database posted by ozonefilt..@gmail.com on 13 Dec 2006
- to_date(null) posted by klabu on Wed, 13 Dec 2006
- Query works in 2000 but not 2005 posted by adau..@gmail.com on 13 Dec 2006
- Date loop posted by BR on Wed, 13 Dec 2006
- Change SQL 2000 Server 64bit collation posted by T Morris on Wed, 13 Dec 2006
- HyperTreading and SQL 2000 licenses. posted by Thinkpad21 on Wed, 13 Dec 2006
- Server Mgmt Studio question posted by user on Wed, 13 Dec 2006
- Appending from one column to another for every row in a table posted by Simon Harvey on Wed, 13 Dec 2006
- SQLserver2005 and SQLserver2000 on the same computer: cannot access SQLserver200 posted by acadam on 13 Dec 2006
- Alternatives when trying to keep two databases in sync... posted by jmaurer@harleysvillegroup.com on 13 Dec 2006
- SQL server 2000 (32 bit) and Windows OS (64 bit) posted by Praveen on 13 Dec 2006
- Users complaining of slowness posted by fnadal via SQLMonster.com on Wed, 13 Dec 2006
- Tedious Backup and Restore with EM posted by Don Miller on Wed, 13 Dec 2006
- How do I create a script to populate a table? posted by groovyjman..@gmail.com on 13 Dec 2006
- Indexing of binary and varbinary posted by Kjell Arne Johansen on Wed, 13 Dec 2006
- MDF vs BAK file sizes posted by fixitchris on Wed, 13 Dec 2006
- Performance comparaison posted by Thinkpad21 on Wed, 13 Dec 2006
- Locating recently edited tables posted by Ib Schrader on Wed, 13 Dec 2006
- SP in a View posted by Dutt on 13 Dec 2006
- Little SQL icon gone in SQL Server 2005?? posted by Spin on Wed, 13 Dec 2006
- Does SQL Server 2005 Clean Up Unclosed Connections? posted by Simon Harvey on Wed, 13 Dec 2006
- "pivotting" a table... posted by Dan Bass on Wed, 13 Dec 2006
- Incorrect syntax posted by Daz01 on 13 Dec 2006
- setting the number of jobs executed in parallel posted by Rea on Wed, 13 Dec 2006
- Need help with an SQL query and creating Variables for my application?? posted by mike11d11 on 12 Dec 2006
- Whether Service Pack Installed on SQL server 2005 posted by sesciber on Tue, 12 Dec 2006
- xp_cmdshell ACCESS IS DENIED posted by Joe K. on Tue, 12 Dec 2006
- 2005 DB backwards-compatible to 2000? posted by Earl on Tue, 12 Dec 2006
- Change values in SSIS. posted by ChrisR on Tue, 12 Dec 2006
- Login failed for user '(null)'... posted by Vladimir Svrkota on Tue, 12 Dec 2006
- Alternating INSERTs fail posted by greg.holmes on Tue, 12 Dec 2006
- Restoring Multiple Databases Drains System Memory posted by Aaron Sanders on Tue, 12 Dec 2006
- A Real Sql Server 2005 Bug! A Real Sql Server Bug! posted by Mike on Tue, 12 Dec 2006
- Server Registration in Sql Server 2005 posted by Simona on Tue, 12 Dec 2006
- RI Question: Declarative vs Trigger posted by Isaac Alexander on Tue, 12 Dec 2006
- SQL Server Replication Issue posted by maxvale..@gmail.com on 12 Dec 2006
- convert posted by stoney on Tue, 12 Dec 2006
- System Commands used by SQL 2K Maintenance Plans? posted by Mike on Tue, 12 Dec 2006
- How do I find the db name from a stored procedure in the db posted by Kjell Arne Johansen on Tue, 12 Dec 2006
- Why do sp_helpdb return maxsize Unlimited for Express Edition posted by Kjell Arne Johansen on Tue, 12 Dec 2006
- most i/o logs or database posted by James on 12 Dec 2006
- Visual Studio on a MS-SQL 2005 Server posted by dgruen on 12 Dec 2006
- Conversion posted by Dutt on 12 Dec 2006
- Restore? posted by morphius on Tue, 12 Dec 2006
- Traces, tables and triggers posted by Adrian on Tue, 12 Dec 2006
- Table update issue posted by cyrstalclear on 12 Dec 2006
- Certification Signature posted by labsRcool@community.nospan on Mon, 11 Dec 2006
- Visual Studio 2005 in the installation of SQL Server 2005 posted by Johnny on Mon, 11 Dec 2006
- SQL Server 7 - "Unicode Comparison" won't let me restore posted by Rosman Computing on Mon, 11 Dec 2006
- How do i get rid of a SQL Server login-prompt. posted by p on 11 Dec 2006
- connection error posted by Newbie on Mon, 11 Dec 2006
- How to dynamically choose whether to SUM() column or GROU BY this column? posted by HP on 11 Dec 2006
- Restore only few tables of the database posted by Chedva on Tue, 12 Dec 2006
- Disk Crash Recover - Won't Recover my SQL Database posted by Rosman Computing on Mon, 11 Dec 2006
- Database Mail posted by cploess..@gmail.com on 11 Dec 2006
- differentials question - can i skip a full backup? posted by ddelapas..@gmail.com on 11 Dec 2006
- OS requirements for SQL 2000 posted by donsql22222 on Mon, 11 Dec 2006
- Alert posted by Razvan Dragomir on Mon, 11 Dec 2006
- SQL Server Express posted by Brett_A on 11 Dec 2006
- Event 697 on SQL2005 Servers posted by Chris Wood on Mon, 11 Dec 2006
- Reducing physical transaction log file size. posted by Elbryyan on Mon, 11 Dec 2006
- Licensing question... posted by skinnydipcle..@gmail.com on 11 Dec 2006
- Problem connecting to SQL 2005 from MS Access posted by ME on Mon, 11 Dec 2006
- Query help (NOT IN vs. derived table vs. FROM clause) posted by sck10 on Mon, 11 Dec 2006
- How to get Procedure call text from within SQL Stored Procedure posted by PFI on 11 Dec 2006
- Table Size posted by klabu on Mon, 11 Dec 2006
- Database Maintenance Plan for SQL Server 2005 Problem posted by Peter on Mon, 11 Dec 2006
- trigger status posted by 00MichaelJordan on Mon, 11 Dec 2006
- How to take data from the corrupted table. posted by None on 10 Dec 2006
- Mirrored db - Witness server multiple networks posted by sqlboy2000 on Sun, 10 Dec 2006
- Restoring Transaction log posted by highflier on 10 Dec 2006
- SQL Server/Vista and D: Disk Drive Visibility posted by EagleRed@HighFlyingBirds.com on Sun, 10 Dec 2006
- Safely updating stored procedures, functions and table structure with minimal do posted by Strider80 on 10 Dec 2006
- q; using SSIS posted by JIM.H. on Sun, 10 Dec 2006
- FullText posted by shapper on 10 Dec 2006
- Remote Accessing posted by shapper on 10 Dec 2006
- Can I do this ? posted by Hassan on Sat, 9 Dec 2006
- Who is starting SQLSERVR.EXE? posted by Chris Shearer Cooper on Sat, 9 Dec 2006
- Date field in exported excel file posted by JIM.H. on Sat, 9 Dec 2006
- Trace to Table posted by Haki on Sat, 9 Dec 2006
- Checking a database for physical damage posted by craigkenisst..@hotmail.com on 8 Dec 2006
- Copy Stored proc from one DB to other posted by Sheryl on 8 Dec 2006
- Why would bad login attempts not get logged with the source IP? posted by Henrik on Fri, 8 Dec 2006
- 2005 features not working posted by Paul on Fri, 8 Dec 2006
- Importing Data into SQL 2005 posted by ME on Fri, 8 Dec 2006
- @@version, add database to a named instance? posted by bangwo on Fri, 8 Dec 2006
- "dbcc dbreindex" vs "dbcc reindex" posted by xamman on 8 Dec 2006
- Execute permission denied on 'sp_xml_preparedocument' posted by Sharath Shetty on Sat, 9 Dec 2006
- Delete previous backup in append mode sql 2000 posted by Arejan on 8 Dec 2006
- multi instances of sql server posted by bangwo on Fri, 8 Dec 2006
- How to get rid of Ghost Pages posted by Adam on Fri, 8 Dec 2006
- SQL Server Version posted by J1C on 8 Dec 2006
- Why won't Service Browser bind to my LAN port posted by mark.howel..@gmail.com on 8 Dec 2006
- Insert one row for each day posted by Lauren Quantrell on 8 Dec 2006
- in oracle we have a functionality "cursor" ... do we have some replacement of it posted by manish1.agarwal@gmail.com on 8 Dec 2006
- How to add document type in full - text search (ifiter) posted by jp on Thu, 7 Dec 2006
- Defrag local drive in SQL Server 2005 posted by morphius on Thu, 7 Dec 2006
- Poor Performance after upgrading from 2000 to 2005 posted by Ryan on Thu, 7 Dec 2006
- Violation of PRIMARY KEY Constraint Error After Restore from a Backup File posted by Gary Lou on 7 Dec 2006
- Delete TempDB Database on SQL Server 2000 EE posted by Joe K. on Thu, 7 Dec 2006
- Restoring deleted records with out of row blobs? posted by Andrew Meinert on Thu, 7 Dec 2006
- Trigger to update field based on criteria posted by Keeper of the Bits on 7 Dec 2006
- standard or enterprise or developer edition? posted by bangwo on Thu, 7 Dec 2006
- Asymmetric communication from ms-sql-m protocol from an SQL Cluster posted by ddna..@gmail.com on 7 Dec 2006
- Quoted Identifier ON as default posted by cbrichards via SQLMonster.com on Thu, 7 Dec 2006
- SQL2005 & Small business server2003 R2 posted by Fred Nygaard on Thu, 7 Dec 2006
- Drive space for db and log backups posted by Gerald Hopkins on Thu, 7 Dec 2006
- Table updates from server posted by omaris on 7 Dec 2006
- retrieve Datetime posted by db-x on 7 Dec 2006
- xp_sendmail permission issued from a job posted by thejamie on Thu, 7 Dec 2006
- Recover Transaction Log posted by labsRcool@community.nospan on Thu, 7 Dec 2006
- C:\SQL.LOG File, And growing very large posted by Ryan McAtee on Thu, 7 Dec 2006
- SQL Time Specific Daily Query posted by CRS_UK on 7 Dec 2006
- Max Degree of Parallelism - clearification posted by Jaski on Thu, 7 Dec 2006
- What happens when when a row is inserted into a table with indexes? posted by Simon Harvey on Thu, 7 Dec 2006
- SQL 2005: Service Pack 2: Timing? posted by Dr. Network on Thu, 7 Dec 2006
- 64 bit SQL 2005 memory problem posted by thejamie on Thu, 7 Dec 2006
- ado-sql-oledb posted by Meelis Lilbok on Thu, 7 Dec 2006
- Info Isa 2006? posted by Cyber-Guy on Thu, 7 Dec 2006
- SQL ODBC not listing database. posted by hugostyl..@yahoo.com on 7 Dec 2006
- Does SQL Server handles time zone difference? posted by Lalit on Thu, 7 Dec 2006
- Starting up the database XXX (Error ID 17137) posted by ghostwolf on Thu, 7 Dec 2006
- Compare Databases posted by morphius on Wed, 6 Dec 2006
- Incorrect LicenseType & NumLicenses returned by SERVERPROPERTY fnc posted by DBADave on Wed, 6 Dec 2006
- MS DTC timeout posted by 00MichaelJordan on Thu, 7 Dec 2006
- SQL Server 2000 server time question posted by Jason Huang on Thu, 7 Dec 2006
- grant select to public posted by klabu on Wed, 6 Dec 2006
- Recover data from corrupt DB posted by John on Wed, 6 Dec 2006
- SQL 2005: Querying a table or view posted by Conan Kelly on Wed, 6 Dec 2006
- Need to transform table data to excel 2003 files posted by Maxwell2006 on Wed, 6 Dec 2006
- SQL errors on running stored procedure... posted by Mrpush on Wed, 6 Dec 2006
- Transaction log files get smaller posted by JayKon on Wed, 6 Dec 2006
- data export to flat file posted by jchampion728 on Wed, 6 Dec 2006
- Jobs and logins posted by rgn on Wed, 6 Dec 2006
- Update Statistics with fullscan blocks myself posted by Ian Boyd on Wed, 6 Dec 2006
- Unable to deallocate a kept page posted by morphius on Wed, 6 Dec 2006
- Need help w/ scripting tables posted by tootsui..@gmail.com on 6 Dec 2006
- What is good and what is bad in the Graphical Exec Plan? posted by ChrisR on Wed, 6 Dec 2006
- Third party tool backup not Supported by Microsoft?!!!! posted by Hate_orphaned_users on Wed, 6 Dec 2006
- loading status after restore database posted by Iter on Wed, 6 Dec 2006
- SQL 2005 Encrypted columns posted by DXC on Wed, 6 Dec 2006
- attaching to msdb db posted by Roy Goldhammer on Wed, 6 Dec 2006
- SQL 2000 and awe memory posted by paul on Wed, 6 Dec 2006
- Max Memory SQL2K EE on W2K3 EE posted by Paul Ward on Wed, 6 Dec 2006
- Question on Backup/Restore posted by DataPro on 6 Dec 2006
- What is the difference between dbo schema and db_owner? posted by Peter on Wed, 6 Dec 2006
- Exporting Datas to Excel File posted by retheeshnewa..@gmail.com on 6 Dec 2006
- Script to peg all CPUs posted by Hassan on Tue, 5 Dec 2006
- How to allow null by SQL posted by ad on Wed, 6 Dec 2006
- OLE automation posted by 00MichaelJordan on Wed, 6 Dec 2006
- Transaction log backups way bigger than differential backups? posted by Nasser on Tue, 5 Dec 2006
- Moving SQL Server posted by Tedmond on Tue, 5 Dec 2006
- SQL 2005 WORKGROUP Installation Problem Please help! posted by Newbie on Tue, 5 Dec 2006
- Import multiple .DBF files w/SSIS - OLE DB posted by SQLNewbie on 5 Dec 2006
- NTBackup posted by Diane Walker on Tue, 5 Dec 2006
- Database on SQL Ent Trial buying Standard Edt posted by Paul on Tue, 5 Dec 2006
- Telling if SQL2005 is running posted by Chris Wood on Tue, 5 Dec 2006
- Does Sql 2005 allow ORDER BY @Variable ? posted by Dan E on Tue, 5 Dec 2006
- error running a vb script on servr 2003 posted by pr0f1t on 5 Dec 2006
- Windows 2003 SP1 posted by Paul Charleston on Tue, 5 Dec 2006
- Error Connecting to Database (SQL Server 2005)! posted by Mohd Al Junaibi on 5 Dec 2006
- Slow hard disk? posted by nkw on Tue, 5 Dec 2006
- Managing Large Views on Large Tables posted by thejamie on Tue, 5 Dec 2006
- begin transactions posted by KristinaDBA@gmail.com on 5 Dec 2006
- perf question posted by SalamElias on Tue, 5 Dec 2006
- Can 32 bit webserver work with a 64 bit db server? posted by Hurme on Tue, 5 Dec 2006
- Could not create tempdb - SQL Server 2005 with SP1 posted by Keith Kratochvil on Tue, 5 Dec 2006
- SQL Server Database Size/Free Space Query posted by ChrisP on 5 Dec 2006
- What type of replication should i use? posted by stucki..@gmail.com on 5 Dec 2006
- Difference between SQL Server Express Utility and SQL Server Server Management S posted by J.S. on Tue, 5 Dec 2006
- How can i access internal row id of sql server posted by khaleek_ahm..@yahoo.com on 5 Dec 2006
- Using current time as parameter for a stored procedure posted by Ib Schrader on Tue, 5 Dec 2006
- backuping to tape posted by Roy Goldhammer on Tue, 5 Dec 2006
- Schema versioning posted by RobRoma on Tue, 5 Dec 2006
- AWE Enabled for 4gb but sqlsevr.exe only uses 74,172k posted by ste..@mallsoft.com on 4 Dec 2006
- FULL and Tran Backup posted by morphius on Mon, 4 Dec 2006
- Easy way to find size of data returned in SQL 2005 ? posted by Hassan on Mon, 4 Dec 2006
- Data Encryption posted by TBoon on Mon, 4 Dec 2006
- Transaction log posted by morphius on Mon, 4 Dec 2006
- Application Server to Point to Mirror Server posted by Gary Lou on 4 Dec 2006
- How to alter the data type of a field posted by ad on Tue, 5 Dec 2006
- Alter Index issue & Try/Catch question posted by theredmia..@hotmail.com on 4 Dec 2006
- disable external connections to sql server 2000 posted by Vadim on Mon, 4 Dec 2006
- include .mdf, .ndf, and .ldf files in exclusion list posted by Joe on Mon, 4 Dec 2006
- SQL2K5 XQuery data types posted by Mike C# on Mon, 4 Dec 2006
- mirror db blocking issue posted by pdm on 4 Dec 2006
- Scheduled job with @active_start_time AFTER @active_end_time posted by jayneandkum..@gmail.com on 4 Dec 2006
- How do I add an AS400 system as a Linked server?? posted by WANNABE on Mon, 4 Dec 2006
- Enabling service broker posted by Tim Greenwood on Mon, 4 Dec 2006
- User access right: posted by JIM.H. on Mon, 4 Dec 2006
- Determine When/Who Deleted Database posted by Matt on Mon, 4 Dec 2006
- Fastest way to delete to huge datarow? posted by Gerrit Horeis on 4 Dec 2006
- Encrypt sproc still returns NULL's to non DBO's. posted by ChrisR on Mon, 4 Dec 2006
- User security setting in SQL Server 2000 posted by Peter on Mon, 4 Dec 2006
- Reserved words etc. posted by s on Sun, 3 Dec 2006
- RAID 5 vs RAID 10 for reads posted by Hassan on Sun, 3 Dec 2006
- Restoring Master DB to a clustered server posted by Tedmond on Sun, 3 Dec 2006
- Error Msg 701(on sql2000)---no insufficient system memory to run q posted by faithdiffla on Sun, 3 Dec 2006
- Grid computing as it applies to SQL Server.. posted by Hassan on Sun, 3 Dec 2006
- dbcc inputbuffer equivalent in SQL 2005 posted by Hassan on Sun, 3 Dec 2006
- List DMVs posted by Hassan on Sun, 3 Dec 2006
- ProSQL posted by Naba via SQLMonster.com on Mon, 4 Dec 2006
- How to shrink db posted by news.microsoft.com on Sun, 3 Dec 2006
- Restore execution sequence? posted by morphius on Sun, 3 Dec 2006
- Database corrupted posted by Roy Goldhammer on Sun, 3 Dec 2006
- SET ANSI_NULLS ON/OFF posted by Atenza on Sun, 3 Dec 2006
- q; Running SP with a different user posted by JIM.H. on Sat, 2 Dec 2006
- Force Encryption on client with Thawte certificate posted by norrad on 2 Dec 2006
- Restoring SQL 2005 Analysis service database backup on SQL 2000 posted by ahuja.madh..@gmail.com on 2 Dec 2006
- q; Registration access denied posted by JIM.H. on Sat, 2 Dec 2006
- Integrity Checks Fail posted by thejamie on Sat, 2 Dec 2006
- Trans log backup frequency posted by mmc on Fri, 1 Dec 2006
- order of maintenance task posted by mmc on Fri, 1 Dec 2006
- Optimal Backup posted by mmc on Fri, 1 Dec 2006
- Changing display-name in Database Mail posted by petecu..@gmail.com on 1 Dec 2006
- Horrizontal partition posted by SP on 1 Dec 2006
- How to write sp_helptext to file ? posted by tootsui..@gmail.com on 1 Dec 2006
- Find "current database" posted by klabu on Fri, 1 Dec 2006
- Computed Column posted by cbrichards via SQLMonster.com on Fri, 1 Dec 2006
- AWE and Perfmon Counters posted by BATMAN on Fri, 1 Dec 2006
- Problems moving MSDE database posted by cbend..@mriresearch.org on 1 Dec 2006
- Database Growth Options posted by KenO on Fri, 1 Dec 2006
- Adding processors after the fact posted by Conan Kelly on Fri, 1 Dec 2006
- SQL Server 2000 Errorlog Errors - posted by Joe K. on Fri, 1 Dec 2006
- Ignore NULLs in index posted by BK on Fri, 1 Dec 2006
- SQL Server Crash posted by mmc on Fri, 1 Dec 2006
- Memory Allocation posted by Kamal Hassan on Fri, 1 Dec 2006
- Extract color formatted text from code editor? posted by Tadwick on Fri, 1 Dec 2006
- history of Process info posted by ld-runner on Fri, 1 Dec 2006
- Recover a standby db posted by mecn on Fri, 1 Dec 2006
- Help - Suggestions on 1 day window for Production Server posted by thejamie on Fri, 1 Dec 2006
- Triggers with SQL Server 2005 and linked UniOleDb Servers posted by csadli..@vodavi.com on 1 Dec 2006
- Insert transaction batch size posted by DXC on Fri, 1 Dec 2006
- attaching a database in SQL 2005 Express posted by Candace on Fri, 1 Dec 2006
- q; user running trigger posted by JIM.H. on Fri, 1 Dec 2006
- Should I apply Post SP1 hotfix ? posted by Peter on Fri, 1 Dec 2006
- SQL Server 2000 first time backup question posted by Jason Huang on Fri, 1 Dec 2006
- QA database change take too much time posted by Falik Sher on Fri, 1 Dec 2006
- Clear the resultset during batch processing posted by chandresh.x.so..@sonyericsson.com on 30 Nov 2006
- SQL 2005 Memory Usage posted by Galtygreen on 30 Nov 2006
- Full Text Search across multiple tables posted by IronYuppie on Thu, 30 Nov 2006
- SQL join question posted by drsystems@gmail.com on 30 Nov 2006