Newsgroups : Microsoft : microsoft.public.sqlserver.server : August 2007
microsoft.public.sqlserver.server
Messages for August 2007
Messages from microsoft.public.sqlserver.server archived for August 2007:
- dba_tlog_shrink? posted by DaveF on Fri, 31 Aug 2007
- How restore BAK file? posted by Bill on Fri, 31 Aug 2007
- Profiler - just view Writes posted by Tmuldoon on Fri, 31 Aug 2007
- Can not remove user from SQL database.... posted by Mrpush on Fri, 31 Aug 2007
- SQL view not sorted when import to Excel posted by Pat M - City of Reno on Fri, 31 Aug 2007
- Renaming Database Files posted by ExcelMan on Fri, 31 Aug 2007
- Database Diagrams - SQL Server 2005 on Vista posted by David Griffiths on Fri, 31 Aug 2007
- Stored Procedure vs Code posted by tolcis on Fri, 31 Aug 2007
- Question about SQL Agent Jobs posted by FS on Fri, 31 Aug 2007
- Waitresouce of UNK in sysprocesses ? posted by SteveH on Fri, 31 Aug 2007
- Cursor alternative posted by morphius on Fri, 31 Aug 2007
- SQL Server 2000 with Windows sever 2003 R2 posted by Jouhayna on Fri, 31 Aug 2007
- SQL server 205 did not use index posted by Olafur on Fri, 31 Aug 2007
- Search and replace in multiple stored procedures posted by mohamad.rid..@intel.com on Fri, 31 Aug 2007
- Backup Question -- Old Files still attached posted by ExcelMan on Thu, 30 Aug 2007
- Copy Database from SQL 2000 to SQL 2005 posted by Liz on Fri, 31 Aug 2007
- SQL Server data files fragmentation posted by manu on Thu, 30 Aug 2007
- Can SQL Server 2005 and Sql Server Express both reside on server? posted by winlin on Thu, 30 Aug 2007
- No EM/Query Builder to access SQL Server on SQL Server 2005? posted by winlin on Thu, 30 Aug 2007
- size of paging file ? posted by Hassan on Thu, 30 Aug 2007
- Check Constraint posted by Alan T on Fri, 31 Aug 2007
- INDEXDEFRAG posted by istekk on Thu, 30 Aug 2007
- User Account Failing posted by Rustom on Thu, 30 Aug 2007
- How full backup works posted by ktrock on Thu, 30 Aug 2007
- Partitioned Index or table Question posted by S on Thu, 30 Aug 2007
- locking concept for SQL 2005 EE posted by Lynn on Thu, 30 Aug 2007
- Errors and Warnings posted by cbrichards via SQLMonster.com on Thu, 30 Aug 2007
- How to chceck if sprocs has startup option on or off? posted by Bartolo on Thu, 30 Aug 2007
- which patch or SP to install? posted by Daryl on Thu, 30 Aug 2007
- Reorganize vs. REbuild Index Question posted by Richard K on Thu, 30 Aug 2007
- TDS and character encoding posted by raymond_b_jimen..@yahoo.com on Thu, 30 Aug 2007
- correlating objectid to spid posted by Neo on Thu, 30 Aug 2007
- correlating session to objects posted by Neo on Thu, 30 Aug 2007
- Difference between SQL 2000 st. and SQL 2000 Enterprise posted by Ib Schrader on Thu, 30 Aug 2007
- How to fix an orphaned alias? posted by Magnus Bergh on Thu, 30 Aug 2007
- Linked Tables posted by Mark Shields on Thu, 30 Aug 2007
- Moving tables in SQL Server 2005 from one server to another posted by NightOwl888 on Thu, 30 Aug 2007
- Moving tables in SQL Server 2005 from one server to another posted by NightOwl888 on Thu, 30 Aug 2007
- "Detach Database" in SQL Server 2005 apparently dropped the database instead posted by NightOwl888 on Wed, 29 Aug 2007
- Extra logging in SQL error log posted by snafu..@hotmail.co.uk on Wed, 29 Aug 2007
- remotely attached DB ends up readonly .. why oh why oh why .. posted by Sam Samson on Thu, 30 Aug 2007
- Security Audit posted by Peps on Thu, 30 Aug 2007
- SQLagent jobs schedule posted by Jay on Wed, 29 Aug 2007
- Backup device in SQL 2005 posted by msnews.microsoft.com on Wed, 29 Aug 2007
- DPV's posted by Jay on Wed, 29 Aug 2007
- Tracking down the query with poor execution plan posted by Eugene on Wed, 29 Aug 2007
- sql server on local machine posted by Stranger3 via SQLMonster.com on Wed, 29 Aug 2007
- Top Ten lists... posted by Joe on Wed, 29 Aug 2007
- Viewing Databases posted by Stuart on Wed, 29 Aug 2007
- Does this log backup overwrite? posted by Jay on Wed, 29 Aug 2007
- Can't Create Database Diagram Support Objects posted by Dan on Wed, 29 Aug 2007
- Checking if anything changed posted by Maury Markowitz on Wed, 29 Aug 2007
- SQL Server Express - Display suddenly has bugs posted by Legaia on Wed, 29 Aug 2007
- SQL 2000 across servers posted by Alex on Wed, 29 Aug 2007
- Deadlock on replication update and NOLOCK hint question posted by techgrl on Wed, 29 Aug 2007
- New server with SQL Server 2005 standard x64 crashing posted by masmith on Wed, 29 Aug 2007
- 180 Eval Coming to an End posted by Rob R. on Wed, 29 Aug 2007
- SET NO_BROWSETABLE ON ? posted by raymond_b_jimen..@yahoo.com on Wed, 29 Aug 2007
- What problems if COLLATIONS differ on user + system dbs ? posted by Scott on Wed, 29 Aug 2007
- SQL 2005 32 bit on Windows 2000 64 bit posted by PRH on Wed, 29 Aug 2007
- Transaction logging process increases SQL server performance posted by jeronimo..@gmail.com on Wed, 29 Aug 2007
- SQL 6.5 Server vs Vista posted by Ivan on Wed, 29 Aug 2007
- Log backups to the same file posted by Jay on Tue, 28 Aug 2007
- Please help me, Its urgent posted by pal on Wed, 29 Aug 2007
- Problem handling NULL values in SQL Server 2000 posted by Rex on Tue, 28 Aug 2007
- Check constraints posted by Alan T on Wed, 29 Aug 2007
- Using Windows 'Compress drive' for backups posted by Jay on Tue, 28 Aug 2007
- Upgrading to SQL Server 2005 posted by sharman on Tue, 28 Aug 2007
- upgrading to sql server 2005 posted by sharman on Tue, 28 Aug 2007
- Upgrade sql2005 workgroup til sql2005 standard how posted by CK on Tue, 28 Aug 2007
- Text searches in SQL Server 2000 posted by Jay on Tue, 28 Aug 2007
- Differences between SQLs 2005 (performance) posted by Ostry on Tue, 28 Aug 2007
- Converting Numbers to a SSN Format posted by JOHN HARRIS on Tue, 28 Aug 2007
- Help with SQL Statment posted by Charles A. Lackman on Tue, 28 Aug 2007
- linked access to SQL Server posted by Janis on Tue, 28 Aug 2007
- can't backup database posted by Rockitman on Tue, 28 Aug 2007
- Differences in these errors posted by Hassan on Tue, 28 Aug 2007
- xp_sendmail and MAPI client posted by Jay on Tue, 28 Aug 2007
- convert rtf to plain text posted by munnyAnu on Tue, 28 Aug 2007
- DTS 2000 not running in SQL Server 2005 posted by Ron on Tue, 28 Aug 2007
- data migration - new server uses different collation posted by Scott on Tue, 28 Aug 2007
- Increase User connections posted by Hassan on Tue, 28 Aug 2007
- Connection Pooling Logic posted by Hassan on Tue, 28 Aug 2007
- Install 32 bit SQL on 64 bit Windows ??? posted by Hassan on Tue, 28 Aug 2007
- Truncate log file without backup, using the Query Analyzer posted by mklags@gmail.com on Tue, 28 Aug 2007
- TempDB mdf file deleted posted by zomer on Tue, 28 Aug 2007
- msdb database size posted by SQLGuru_not on Tue, 28 Aug 2007
- Connection string security. posted by ChrisR on Tue, 28 Aug 2007
- GetDate not working posted by Shan on Tue, 28 Aug 2007
- Searching Schema For String in Stored Procedures posted by parchk on Tue, 28 Aug 2007
- How to turn off backup/restore messages? posted by Valmir on Tue, 28 Aug 2007
- Problem with SSMA for Oracle Extension - Cannot Install or Deinsta posted by IPZ on Tue, 28 Aug 2007
- Application insert\update\delete posted by Abhi on Tue, 28 Aug 2007
- Database on removable USB disk drive posted by Nikola Milic on Tue, 28 Aug 2007
- Rough estimate of Database Size posted by Peter on Tue, 28 Aug 2007
- Limit Login Attempts and Log failed login posted by xav on Tue, 28 Aug 2007
- Reporting like this posted by RP on Mon, 27 Aug 2007
- text data type posted by Alan T on Tue, 28 Aug 2007
- Float and Bigint posted by Alan T on Tue, 28 Aug 2007
- Query Help on parsing a string between two colons posted by bpdee on Mon, 27 Aug 2007
- Resotring a backup file to a DB on a differerent server posted by Ant on Mon, 27 Aug 2007
- passwords are case sensitive in 2005 posted by Hassan on Mon, 27 Aug 2007
- Script Syntax Errors posted by paul on Mon, 27 Aug 2007
- My available memory is down to very little, yet my PF Usage is 8 gigabytes (abou posted by Daniel on Mon, 27 Aug 2007
- in sql server is it possible to get the amount of memory used by a stored proced posted by Daniel on Mon, 27 Aug 2007
- Query help posted by DXC on Mon, 27 Aug 2007
- UPDATE STATISTICS posted by Jay on Mon, 27 Aug 2007
- Log Shipping Question posted by sharman on Mon, 27 Aug 2007
- SQL Server 2000 Consolidation posted by sharman on Mon, 27 Aug 2007
- Cons w/ UDTs? posted by parchk on Mon, 27 Aug 2007
- Increase Performance with two connections posted by Toni Pohl on Mon, 27 Aug 2007
- question about removing logins at server level posted by Jean on Mon, 27 Aug 2007
- Carriage return in column values posted by bpdee on Mon, 27 Aug 2007
- Index tuning under heavy load... posted by Michael Kansky on Mon, 27 Aug 2007
- Can't connect to through OLE DB to remote host - Database 'XXX' does not exist. posted by panko on Mon, 27 Aug 2007
- Can this been done? posted by Goofy on Mon, 27 Aug 2007
- Heavy performance issue with sp_executesql posted by Jochen Wezel on Mon, 27 Aug 2007
- Fast SQL, slow storedproc? posted by Maury Markowitz on Mon, 27 Aug 2007
- sqlcmd and Hebrew output posted by Shoval on Mon, 27 Aug 2007
- SP4 install issues with SQL 2000. posted by Shotman on Mon, 27 Aug 2007
- columns_updated compatibility between sql2000 and sql 2005 posted by Vadim on Sun, 26 Aug 2007
- Distributed query against loopback linked server is not supported posted by Felix_Jiang on Sun, 26 Aug 2007
- ORDER BY returns opposite sequence between SQL 2000 and 2005 posted by Adrian on Sun, 26 Aug 2007
- Moving large amounts of data to remote data center posted by Hassan on Sun, 26 Aug 2007
- troubleshoot remote connection to sql posted by Scott on Sun, 26 Aug 2007
- SQL 2005 Maint Plan - Cannot see user databases? posted by jaybregm..@gmail.com on Sun, 26 Aug 2007
- How to check all exist triggers in database, thnaks! posted by SOHO on Sun, 26 Aug 2007
- Removing 2000 for 2008 posted by newscorresponde..@charter.net on Sat, 25 Aug 2007
- Retrieving result from user created formula posted by RP on Sat, 25 Aug 2007
- DBCC SHOWCONTIG posted by Jay on Fri, 24 Aug 2007
- sql server locks more that one record when updating one record. posted by Nalaka on Fri, 24 Aug 2007
- Index reorganization posted by shwac on Fri, 24 Aug 2007
- Linked Server problem posted by sharman on Fri, 24 Aug 2007
- Parsing a string into records posted by Maury Markowitz on Fri, 24 Aug 2007
- ! doesn't work in LIKE wildcards? posted by Maury Markowitz on Fri, 24 Aug 2007
- need help on update statement posted by kulkarni.nin..@gmail.com on Fri, 24 Aug 2007
- SQL Server VSS Writer posted by tanggo on Fri, 24 Aug 2007
- Transact SQL and selecting SQL Server instances posted by Andy on Fri, 24 Aug 2007
- Convert RTF to plain text in sql posted by munnyAnu on Fri, 24 Aug 2007
- Upgrade to 2005 or 2008 from sql server 2000 posted by sharman on Fri, 24 Aug 2007
- LEFT function uses table scan? posted by Leila on Fri, 24 Aug 2007
- dcdiag error posted by JFB on Fri, 24 Aug 2007
- Redirect Requests to One Instance to Another on Same Machine? posted by K on Fri, 24 Aug 2007
- SQL Server 2005 Remote Connection posted by wong..@gmail.com on Fri, 24 Aug 2007
- Regular intermittent Kerberos failures posted by JimLad on Fri, 24 Aug 2007
- Recover data after using delete statement posted by Le Thuan on Fri, 24 Aug 2007
- SQL Server error log--current missing posted by Shama on Fri, 24 Aug 2007
- Maintenance Plan / BackupJob failed with error 17055 posted by P.Nebermann on Thu, 23 Aug 2007
- SQL Server 2005 backup posted by RP on Fri, 24 Aug 2007
- Service broker filling up tempdb posted by Steven Kong on Thu, 23 Aug 2007
- Page File Size MSSQL 2005 posted by sam on Fri, 24 Aug 2007
- Can a UDF be forced into being considered deterministic? posted by Walbert on Thu, 23 Aug 2007
- How to generate Trace Files automatically? posted by Zrich on Thu, 23 Aug 2007
- Trigger behaviour in SQL Server 2005 posted by Loren Z on Thu, 23 Aug 2007
- Changing Filegroup for Text/Image Data SQL 2005 posted by chabotwvu on Thu, 23 Aug 2007
- Query exec time of 2005 vs. 2000. posted by ChrisR on Thu, 23 Aug 2007
- SSPI error posted by Ellie on Thu, 23 Aug 2007
- KB 934458 - how bad it is? posted by Ellie on Thu, 23 Aug 2007
- DBCC CHECKDB posted by Jay on Thu, 23 Aug 2007
- Full-text catalog is in an unusable state???? posted by George Ter-Saakov on Thu, 23 Aug 2007
- SQL query to display like this posted by RP on Thu, 23 Aug 2007
- Remove duplicate records after importing via SSIS posted by sketchy on Thu, 23 Aug 2007
- SQL 2000 missing the .LDF file posted by stoney on Thu, 23 Aug 2007
- 2005 vs 2000 views performance q posted by Derrick on Thu, 23 Aug 2007
- SQL Server 2005 using too much RAM posted by spdude on Thu, 23 Aug 2007
- Reset SQL Server Performance Statistics posted by cori on Thu, 23 Aug 2007
- Re-Initializing Auto-Number fields posted by RP on Thu, 23 Aug 2007
- I need Help. posted by Murat Fidan on Thu, 23 Aug 2007
- SQL Server 2000 Personal Edition posted by Richar on Thu, 23 Aug 2007
- Server problems posted by Michael Gapp on Thu, 23 Aug 2007
- SQL 2000 vs SQL 2005 performance with ADO/C++ posted by tom.n..@gmail.com on Thu, 23 Aug 2007
- 2000 and 2005 on same server? posted by K on Thu, 23 Aug 2007
- How the SQL Server do syntax check? posted by DDD on Thu, 23 Aug 2007
- Alloocation Errors in Database posted by Bobby Henningsen on Thu, 23 Aug 2007
- xp_cmdshell permission denied SQL 2005 posted by jose.mendez..@gmail.com on Thu, 23 Aug 2007
- xp_cmdshell permission denied SQL 2005 posted by jose.mendez..@gmail.com on Thu, 23 Aug 2007
- Convert column values into row posted by RP on Thu, 23 Aug 2007
- Sharing data between databases posted by Frank O'Hara on Wed, 22 Aug 2007
- Server2003 x64 and SBS SQL Server Connection error posted by John C on Thu, 23 Aug 2007
- Nightly maintenance posted by Jay on Wed, 22 Aug 2007
- test-data generation tool for sqlserver 2000 posted by andrea on Thu, 23 Aug 2007
- Good Day SQL Guru's posted by Scott Cummins on Wed, 22 Aug 2007
- Cannot Attach Database in SQL Server 2005 (Vista) posted by Mike on Wed, 22 Aug 2007
- Insert days into a table posted by Paul on Wed, 22 Aug 2007
- Problem in SQLServer posted by sayeesarat..@gmail.com on Wed, 22 Aug 2007
- xp_cmdshell proxy account issue posted by harvinder on Wed, 22 Aug 2007
- SQL Logon Failed posted by David on Wed, 22 Aug 2007
- option db_chaining posted by Andrea Anastasescu on Wed, 22 Aug 2007
- Access Control and Security? posted by kilik30..@gmail.com on Wed, 22 Aug 2007
- Mirroring for SQL Server snapshot databases? posted by Sanchet Dighe on Wed, 22 Aug 2007
- Accessing one db by two sql server instances (eg. native vs vmware) posted by HP on Wed, 22 Aug 2007
- Viewing Transactions on a SQL Server posted by frant1..@googlemail.com on Wed, 22 Aug 2007
- Multiple Instance SQL 2005 posted by TBoon on Wed, 22 Aug 2007
- Restore problem... "The media family on device '%ls' is incorrectly formed" posted by Mike C on Tue, 21 Aug 2007
- SQL Server 2005 Standard 32 bits posted by FredDBA on Tue, 21 Aug 2007
- Clustering more than one SQL Server instance at a time posted by aferrand..@gmail.com on Tue, 21 Aug 2007
- invalid object name sys.endpoints posted by Code Wench on Tue, 21 Aug 2007
- Odd syntax issue - didn't happen in SQL 2000 - error in SQL 2005 posted by Steve Z on Tue, 21 Aug 2007
- Query using datetime datatype posted by FS on Tue, 21 Aug 2007
- query help posted by Johnfli on Tue, 21 Aug 2007
- proper case for name in sql server posted by mecn on Tue, 21 Aug 2007
- SQL Server 2005 SP CTP vs. final release posted by JoeyD on Tue, 21 Aug 2007
- Dynamic Parameter List posted by James on Tue, 21 Aug 2007
- Default Trace SQL 2005 posted by evan4434 on Tue, 21 Aug 2007
- disconnected import-export posted by andrea on Tue, 21 Aug 2007
- sqlserveragent won't stay started posted by Rockitman on Tue, 21 Aug 2007
- Developer Access posted by guest5 on Tue, 21 Aug 2007
- How to Export tables in 2005 posted by Waldy on Tue, 21 Aug 2007
- sync trigger posted by mecn on Tue, 21 Aug 2007
- SQL/Exhange VHD downloaded - whats the password? posted by Bob on Tue, 21 Aug 2007
- Prerformanceproblem posted by Ferdinand Zaubzer on Tue, 21 Aug 2007
- SQL 2005 RTM Backup failure posted by Ronald Green on Tue, 21 Aug 2007
- Backup log WITH NO_LOG - change recovery model to SIMPLE? posted by anxco..@gmail.com on Tue, 21 Aug 2007
- Timeout error when adding field to table posted by Jens on Tue, 21 Aug 2007
- how to export/import entire database posted by Prem Mehrotra on Mon, 20 Aug 2007
- Does a role exist? posted by Frank Rizzo on Mon, 20 Aug 2007
- 2005 Express Backup Error:Set Property Devices to accomplish this action. posted by Steve Ricketts on Mon, 20 Aug 2007
- insert query question posted by Paul on Mon, 20 Aug 2007
- Restoring master to a different location posted by Carlos on Mon, 20 Aug 2007
- Restoring data only posted by Tim Grant on Mon, 20 Aug 2007
- Cross database transactions. posted by Frank Rizzo on Mon, 20 Aug 2007
- Key/Index Questions posted by Brian Staff on Mon, 20 Aug 2007
- Bold() function posted by mecn on Mon, 20 Aug 2007
- new tables everyday posted by Schmeg on Mon, 20 Aug 2007
- AMD or Intel for SQL Servers.. posted by Hassan on Mon, 20 Aug 2007
- IDENTITY with inline sql works different in 2005 than 2000 posted by Douglas Marquardt on Mon, 20 Aug 2007
- Create database on NAS posted by andyoye on Mon, 20 Aug 2007
- Network connection problem when trying to use SSMS posted by Matt on Mon, 20 Aug 2007
- 10GB Tran log from Optimizations job?? posted by Rich on Mon, 20 Aug 2007
- sending email by calling sql server2k sp_OA sp posted by mecn on Mon, 20 Aug 2007
- Msg 5133, Level 16, State 1, Line 1 posted by SQLGuru_not on Mon, 20 Aug 2007
- Sql Performance posted by lecour..@gmail.com on Mon, 20 Aug 2007
- error log latest info shows as Attempting to cycle errorlog posted by Shama on Mon, 20 Aug 2007
- No Online Backup possible with Veritas Netbackup and SP2 installed posted by Celina on Mon, 20 Aug 2007
- Collation in SQL Server posted by Prabhat on Mon, 20 Aug 2007
- sql server express setup ? posted by Agnes on Mon, 20 Aug 2007
- SQL 2005 Server Embedded Edition posted by Florian L. on Sun, 19 Aug 2007
- Attach DB problem posted by vovan on Sun, 19 Aug 2007
- sql 2000 log posted by Cemal Tuncel on Sun, 19 Aug 2007
- Connection for windows authorization posted by Light on Sun, 19 Aug 2007
- SQL Membership Provider issue posted by GaryDean on Sun, 19 Aug 2007
- error running grant create database - cannot find user posted by Steve Richter on Sun, 19 Aug 2007
- Store only month/year posted by RP on Sun, 19 Aug 2007
- Query Performance posted by cbrichards via SQLMonster.com on Sat, 18 Aug 2007
- varchar(max) or text datatype posted by Hassan on Sat, 18 Aug 2007
- Virtual memory and Physical memory for SQL posted by Hassan on Sat, 18 Aug 2007
- Learning SQL SERVER 2000 posted by zigzagd..@yahoo.com on Sat, 18 Aug 2007
- Import from a file does not load data posted by zigzagd..@yahoo.com on Sat, 18 Aug 2007
- Pierrot Imports database? posted by dj on Sat, 18 Aug 2007
- ISOLATION LEVEL posted by Mohit K. Gupta on Fri, 17 Aug 2007
- SQL Error: 53123, Severity: 16, State: 1 posted by Zrich on Fri, 17 Aug 2007
- Restore sp_grantdbaccess posted by Frank on Fri, 17 Aug 2007
- Audit Database Mirroring Login Event Class missing in both SQL2K5 RTM & SP1 posted by Scuzzlebutt on Fri, 17 Aug 2007
- SharePoint Servers and SQL Server 2000 SP4 posted by Don B. on Fri, 17 Aug 2007
- Exact Table Copy posted by James on Fri, 17 Aug 2007
- Help with sp_lock output posted by Derek on Fri, 17 Aug 2007
- char datatype padding posted by John Scott on Fri, 17 Aug 2007
- Database in 'In recovery' mode posted by int64 on Fri, 17 Aug 2007
- Table Defragmentation posted by mecn on Fri, 17 Aug 2007
- several exports in a batch file using direct connect posted by snazzy on Fri, 17 Aug 2007
- Simple Log Shipping Code posted by frant1..@googlemail.com on Fri, 17 Aug 2007
- URGENT: count and group by means I can't select text or ntext?! posted by musosdev on Fri, 17 Aug 2007
- Merge replicaton: How to customize conflict detection, resolution? posted by yash..@gmail.com on Thu, 16 Aug 2007
- trying to use conditional sum? posted by Paul on Thu, 16 Aug 2007
- SQL statement available for identifying if a user is a schema owne posted by Jeroen van den Bosch on Thu, 16 Aug 2007
- Disaster - Recovery Order of events posted by Carlos on Thu, 16 Aug 2007
- Net address 000000000000 posted by Ellen on Thu, 16 Aug 2007
- Heterogeneous queries and use of OLEDB providers are not supported posted by Gene. on Thu, 16 Aug 2007
- Can't Kill Process posted by dotNetDave on Thu, 16 Aug 2007
- How to find nth lowest value in a row posted by willcas on Thu, 16 Aug 2007
- Full Text Compatible index posted by Jerry C on Thu, 16 Aug 2007
- Table Locking Problem posted by David C on Thu, 16 Aug 2007
- MySQL and SQL2000 posted by Chris Wood on Thu, 16 Aug 2007
- Maintenance Plan posted by super1 on Thu, 16 Aug 2007
- Backing up secondary DB in log shipping ... posted by peter.wism..@gmail.com on Thu, 16 Aug 2007
- Log shipping posted by Jon on Thu, 16 Aug 2007
- Can't attach database after server crash? posted by Sunfire on Thu, 16 Aug 2007
- Which disks are mirrored in raid 10? posted by miazga.marc..@gmail.com on Thu, 16 Aug 2007
- using Perfmon to test sql server posted by Roy Goldhammer on Thu, 16 Aug 2007
- Monitoring SQL Server Error Message - Severity Level Messages posted by danfoxley@anon.postalias on Thu, 16 Aug 2007
- Dumb index question posted by Jay on Wed, 15 Aug 2007
- moving DBs on sql2000 to sql2005 posted by tungminhnguy..@gmail.com on Wed, 15 Aug 2007
- SQL 2000 Dev Edition on Windows Vista?? posted by TheSQLGuru on Wed, 15 Aug 2007
- spt_Values posted by nmahoney03..@gmail.com on Wed, 15 Aug 2007
- Way to import file per timestamp into SQL posted by Hassan on Wed, 15 Aug 2007
- system created indexes posted by Ellen on Wed, 15 Aug 2007
- compare Data in 2 databases? posted by JOHN HARRIS on Wed, 15 Aug 2007
- syntax problem with select command posted by Mich on Wed, 15 Aug 2007
- Select query times out until indexes are rebuilt posted by Greg on Wed, 15 Aug 2007
- Any way to be notified if database grows? posted by RobinMC on Wed, 15 Aug 2007
- GRANT statement and Windows login posted by pshroa..@gmail.com on Wed, 15 Aug 2007
- Going from 5M to 450M transactions a month posted by Stephane on Wed, 15 Aug 2007
- Restore fails posted by Jay on Wed, 15 Aug 2007
- Questions on simple recovery model posted by ktrock on Wed, 15 Aug 2007
- problem running where table2.column1 in (table1.column2) posted by igorn..@gmail.com on Wed, 15 Aug 2007
- re-attach database to another server posted by david on Wed, 15 Aug 2007
- SQL Server Management Studio posted by bsc gmcc on Wed, 15 Aug 2007
- Find floats with exponential notation posted by Matt Williamson on Wed, 15 Aug 2007
- Filegroup Backups posted by Dave B on Wed, 15 Aug 2007
- Having problems service packing (sp2) on 4 node cluster posted by Mark Broadbent on Wed, 15 Aug 2007
- Replace NULL with "-" using Trigger posted by RP on Wed, 15 Aug 2007
- Help Please... dbo vs. db_owner role posted by Dave on Tue, 14 Aug 2007
- SQL server 2005 Express Edition - login posted by Alan T on Wed, 15 Aug 2007
- Delete all data from user tables with a DELETE statement? posted by Tmuldoon on Tue, 14 Aug 2007
- sp_sdidebug is missing for a SQL Server 2005 installation posted by eyal.suss..@gmail.com on Tue, 14 Aug 2007
- Automatically run query plan. posted by Frank Rizzo on Tue, 14 Aug 2007
- Business Intelligence Studio disappeared posted by Fresno Bob on Tue, 14 Aug 2007
- Database mirroring setup without downtime posted by sqlboy2000 on Tue, 14 Aug 2007
- 4 prrocessors versus 1 posted by thejamie on Tue, 14 Aug 2007
- Datetime function slowdowns posted by thejamie on Tue, 14 Aug 2007
- Best way to Learn T-SQL Performance Tuning posted by Dragon on Tue, 14 Aug 2007
- Error on creating new Integration Services project in VS2005 posted by Marcus on Tue, 14 Aug 2007
- complicated sql query posted by plevexi..@gmail.com on Tue, 14 Aug 2007
- sql server 2000 sp4 installed DATE on sql server posted by Kumar on Tue, 14 Aug 2007
- sorting results of sp commands posted by rschatz on Tue, 14 Aug 2007
- Log Shipping posted by sharman on Tue, 14 Aug 2007
- sp_spaceused showing huge unallocated space posted by siri on Tue, 14 Aug 2007
- error logs disappearing posted by Joe Mama on Tue, 14 Aug 2007
- sp_xp_cmdshell_proxy_account posted by guest5 on Tue, 14 Aug 2007
- How to get "user defined default value", thanks! posted by SOHO on Tue, 14 Aug 2007
- SQL DB Sizes posted by sam on Tue, 14 Aug 2007
- scom2007 and sql 2005 posted by Pete on Mon, 13 Aug 2007
- Storing date in table posted by Prashant C on Mon, 13 Aug 2007
- FillFactor on Clustered Index posted by cbrichards via SQLMonster.com on Mon, 13 Aug 2007
- Service Pack 2 posted by Matt on Mon, 13 Aug 2007
- Optimally setting a FillFactor value posted by cbrichards via SQLMonster.com on Mon, 13 Aug 2007
- sysservers posted by JayKon on Mon, 13 Aug 2007
- Is "User" some type of ms sql keyword? posted by eggie5 on Mon, 13 Aug 2007
- SQL 2005 SP2 Standard Reports posted by Tim Kelley on Mon, 13 Aug 2007
- Moving objects from Primary File Group using T-SQL posted by Todd C on Mon, 13 Aug 2007
- log files posted by Stup88 on Mon, 13 Aug 2007
- Copy Active DB to a TEST DB on same machine posted by Stup88 on Mon, 13 Aug 2007
- The OLE DB provider "MSDASQL" for linked server "MySQL" reported a posted by Antnee on Mon, 13 Aug 2007
- Question about Pages posted by jbergmanst..@gmail.com on Mon, 13 Aug 2007
- file size of restore posted by Jack Vamvas on Mon, 13 Aug 2007
- How to release Table unused space posted by Juan on Mon, 13 Aug 2007
- VMWare ESX and SQL 2000 posted by Neil W. on Mon, 13 Aug 2007
- SQL Server Agent - Max Jobs Per Server posted by Amos Soma on Mon, 13 Aug 2007
- Optimizations Job and Shrink DB creating HUGE transaction log file posted by Rich on Mon, 13 Aug 2007
- allround maintance plan for many small SQL2005 DB. posted by CK on Mon, 13 Aug 2007
- ntbackup & sqlserver posted by Freaky on Mon, 13 Aug 2007
- sql 2005 mirroring - using shared db on SAN - nit how to scale processing power posted by Scott on Mon, 13 Aug 2007
- Optimize this table design posted by RP on Mon, 13 Aug 2007
- osql breaks output posted by Joachim Hofmann on Mon, 13 Aug 2007
- SQLCMD Truncating results posted by ink on Mon, 13 Aug 2007
- Backup Only Tool posted by joe on Mon, 13 Aug 2007
- SQL file locations & Best Practice posted by Adrian on Mon, 13 Aug 2007
- create trigger on system table posted by Ivan on Mon, 13 Aug 2007
- restoring backup on new server posted by Abhi on Sun, 12 Aug 2007
- maintance plan posted by Abhi on Sun, 12 Aug 2007
- Sybase as Linked Server posted by fairozl..@gmail.com on Sun, 12 Aug 2007
- Index Physical Statistics posted by Curtis on Sun, 12 Aug 2007
- Master -> Target jobs in MSSQL2005 posted by Smint on Sun, 12 Aug 2007
- read trn log backup files posted by AHartman on Sat, 11 Aug 2007
- DTS Copy locks web posted by Dave on Sat, 11 Aug 2007
- Restore SQL2K on different machine posted by zz12 on Fri, 10 Aug 2007
- SQL table design posted by mecn on Fri, 10 Aug 2007
- Datafile From Non-Windows Server posted by Jerry on Fri, 10 Aug 2007
- Covered Index posted by jason7655 on Fri, 10 Aug 2007
- SQL 2005 Memory posted by msnews.microsoft.com on Fri, 10 Aug 2007
- DBCC CHECKDB error posted by jaylou on Fri, 10 Aug 2007
- Mgt Studio - Exclamation Point with a check mark? posted by Steve Z on Fri, 10 Aug 2007
- Database version/compare posted by JayKon on Fri, 10 Aug 2007
- Heap table unused space and performance posted by kghammond on Fri, 10 Aug 2007
- SQL 2005 Standard 64-bit on Windows 64-bit Performance Counters is posted by Alejandro on Fri, 10 Aug 2007
- Database mail setup posted by db on Fri, 10 Aug 2007
- Read Uncommitted posted by jason7655 on Fri, 10 Aug 2007
- Update Salary value with random number posted by Bishman on Fri, 10 Aug 2007
- Choose a named instance port(firewall). posted by Hate_orphaned_users on Fri, 10 Aug 2007
- Best SAN configuration for partitioned table posted by ianwr on Fri, 10 Aug 2007
- Enterprise Manager Stops Responding posted by Rajan on Thu, 9 Aug 2007
- Summary Tab posted by Ray Yan on Thu, 9 Aug 2007
- Alter Index...Rebuild posted by cbrichards via SQLMonster.com on Thu, 9 Aug 2007
- this should be a simple query posted by Coaster on Thu, 9 Aug 2007
- Export a table (datas and structure) posted by Stan SR on Thu, 9 Aug 2007
- Intra-query parallelism posted by Ron Hinds on Thu, 9 Aug 2007
- Executing procedure for empty result set return posted by cbrichards via SQLMonster.com on Thu, 9 Aug 2007
- problem with ##xp_cmdshell_proxy_account## posted by Chris Wood on Thu, 9 Aug 2007
- Sql 2005 Backup posted by Sandy Ryan on Thu, 9 Aug 2007
- SQL Statement posted by usabmast..@gmail.com on Thu, 9 Aug 2007
- does using WITH ENCRYPTION for sps affect performance? posted by bendlam on Thu, 9 Aug 2007
- Where is the PK flag in the systables posted by JayKon on Thu, 9 Aug 2007
- procs that reference a table posted by JayKon on Thu, 9 Aug 2007
- 2005 SP1 Installation Fails - MSP 1612 - 'Unableto install MSI fil posted by Craig on Thu, 9 Aug 2007
- Script which will shrink all databases posted by anxco..@gmail.com on Thu, 9 Aug 2007
- Update exchange rates posted by strychtur on Thu, 9 Aug 2007
- maintenance plan for all databases posted by Ramu on Thu, 9 Aug 2007
- equal sign posted by Rick on Thu, 9 Aug 2007
- SQl 2005 version numbers posted by jaylou on Thu, 9 Aug 2007
- DTS Work Flow issue posted by David Hay on Thu, 9 Aug 2007
- Ability to create and schedule jobs on shared system posted by Jason on Thu, 9 Aug 2007
- Error: 17805, Severity: 20, State: 3 posted by db on Thu, 9 Aug 2007
- SQL DMO to Update/delete data posted by morphius on Thu, 9 Aug 2007
- Different FillFactors for different partitions? posted by dba on Thu, 9 Aug 2007
- Hot opening for IT Manager(System Admin) in World Class Product Development posted by anjali6.borah@gmail.com on Thu, 9 Aug 2007
- cant append multiple Diff backups to same file?... posted by Methodology on Thu, 9 Aug 2007
- Unable to remove SQL Server 2000 completely ? posted by Peter on Thu, 9 Aug 2007
- Paging in sql 2005 using ROW_NUM() posted by Hari on Wed, 8 Aug 2007
- Len() posted by Rick on Wed, 8 Aug 2007
- Install help posted by AHartman on Wed, 8 Aug 2007
- Dynamic USE posted by morphius on Wed, 8 Aug 2007
- Merging 2 databases posted by Irene on Wed, 8 Aug 2007
- Move db posted by S on Wed, 8 Aug 2007
- Database synchronization options posted by SQL Dude on Wed, 8 Aug 2007
- cannot generate sspi context posted by Erasmo on Wed, 8 Aug 2007
- Programmatically determine Startup Account posted by Blue Sky on Wed, 8 Aug 2007
- Problem in stored procedure with fully qualified name posted by byteman on Wed, 8 Aug 2007
- Moving databases from SQL 2000 to SQL2005 - best practice? posted by Sandy Wood on Wed, 8 Aug 2007
- SQL 6.5 support retirement posted by Dave Patterson on Wed, 8 Aug 2007
- Rename named instance to default instance? posted by Eric Hall on Wed, 8 Aug 2007
- Do mirrored servers have to be in same domain? posted by Steve on Wed, 8 Aug 2007
- SQL Server 2005 Developer installation issue - svchost.exe posted by thesimpsonator on Wed, 8 Aug 2007
- Moving distribution database - how? posted by anxco..@gmail.com on Wed, 8 Aug 2007
- sql conneciton problem - ok for all users but 1 - even using SA pass - but query posted by Scott on Wed, 8 Aug 2007
- Tables Script posted by Prashant C on Wed, 8 Aug 2007
- Linking 2000 SQL server to SQL 2005 posted by Nobby on Wed, 8 Aug 2007
- how to remove reference of a table from all stored procs posted by ekta on Wed, 8 Aug 2007
- Recovery of database posted by Prashant C on Tue, 7 Aug 2007
- Properly connecting to multiple instancesof SQL servers posted by GeekBoy on Tue, 7 Aug 2007
- null varbinary(max) question posted by GaryDean on Tue, 7 Aug 2007
- Restore HeaderOnly posted by cbrichards via SQLMonster.com on Tue, 7 Aug 2007
- Sql server agent question posted by Jason on Tue, 7 Aug 2007
- 2000 vs. 2005 - assigning permissions posted by emde on Tue, 7 Aug 2007
- About to put 1.5 GB of images into a DB posted by Steve Z on Tue, 7 Aug 2007
- dbcc checkdb question posted by pinney.colt..@gmail.com on Tue, 7 Aug 2007
- USE statement posted by morphius on Tue, 7 Aug 2007
- SQL Query Get Data a Month Old posted by Gabe Matteson on Tue, 7 Aug 2007
- Empty Database Not Shrinking posted by Bachelor Boy on Tue, 7 Aug 2007
- SQLDMO "Redistributable" package? posted by Ron Hinds on Tue, 7 Aug 2007
- Logins and users posted by Lubomir on Tue, 7 Aug 2007
- ss7 encrypted views in ss2k ent mgr posted by SandpointGuy on Tue, 7 Aug 2007
- SSIS packages in Visual Studio posted by EricV on Tue, 7 Aug 2007
- SQL Server 7.0: Annotating comments against tables and fields posted by Water Cooler v2 on Tue, 7 Aug 2007
- SQL Server replication for multisite installation? posted by yash..@gmail.com on Tue, 7 Aug 2007
- New to Sql Server 2005 SSIS and need guidance posted by taxidermi..@cableone.net on Tue, 7 Aug 2007
- Backup policy for a newbies? posted by Patrick Sandron on Tue, 7 Aug 2007
- SQL 2005 - Rebuild vs Reorganize Index posted by ML on Tue, 7 Aug 2007
- Restore auto or manually posted by Abhi on Tue, 7 Aug 2007
- sql 2005 view decryption posted by Muson on Tue, 7 Aug 2007
- Truncate table on a log shipped database posted by James Kaiser on Mon, 6 Aug 2007
- Radically different Transactions/sec behavior in 2005 posted by Jerry on Mon, 6 Aug 2007
- Preventing MS SQL2005 patches from being applied thru Windows Upda posted by shaila on Mon, 6 Aug 2007
- SQL 2005 SP2 Standard Reports posted by Tim Kelley on Mon, 6 Aug 2007
- SQL Server 2005 Cluster posted by Jason on Mon, 6 Aug 2007
- Database Backups posted by Chris on Mon, 6 Aug 2007
- 2005 Maintenance Plan Best Practices? posted by ML on Mon, 6 Aug 2007
- Maximum Recommended Databases posted by Chris Reeder on Mon, 6 Aug 2007
- Management Studio Replacement posted by parchk on Mon, 6 Aug 2007
- reading a txt file posted by Johnfli on Mon, 6 Aug 2007
- SAN impact on performance posted by Mark on Mon, 6 Aug 2007
- SQL getdate() posted by mecn on Mon, 6 Aug 2007
- SQL 2000 DB, "Suspect", but is shown as being replicated posted by Rob on Mon, 6 Aug 2007
- Error while upgrading SQL2005 Standard To SQL 2005 Enterprise posted by Noah on Mon, 6 Aug 2007
- Trasaction log backup !! posted by Abhi on Mon, 6 Aug 2007
- SQL server - Access violation exception posted by vedran.juric..@gmail.com on Mon, 6 Aug 2007
- tempdb full posted by Abhi on Mon, 6 Aug 2007
- Premission on jobs posted by Abhi on Mon, 6 Aug 2007
- RAID5 for all files? posted by JXStern on Sun, 5 Aug 2007
- Cannot seem to connect to named instance posted by Hassan on Sun, 5 Aug 2007
- Transfer data from a.table to b.table posted by Godzilla on Sun, 5 Aug 2007
- Log shipping to DR env posted by pdx on Sun, 5 Aug 2007
- problem error no 9003 posted by love shishu on Sat, 4 Aug 2007
- Sql Server 2000 - Problems with long waits and slow responsiveness. posted by bourg..@gmail.com on Sat, 4 Aug 2007
- mssql remote gui posted by trpo..@gmail.com on Fri, 3 Aug 2007
- SQL Server 2000 MERGE JOIN Inconsistent Behaviour posted by Seth Stokes-Leifeste on Fri, 3 Aug 2007
- Create view "disconnected" posted by DWalker on Fri, 3 Aug 2007
- Choosing which index is best posted by Hurme on Fri, 3 Aug 2007
- SQL Server 2005 Stored Procedures posted by Rob Meade on Fri, 3 Aug 2007
- SQL 2005 Named Instance posted by msnews.microsoft.com on Fri, 3 Aug 2007
- change startup options in SQL 2005 posted by Hassan on Fri, 3 Aug 2007
- Copying data posted by Harish Mohanbabu on Fri, 3 Aug 2007
- Dual Core Processor posted by Carlos on Fri, 3 Aug 2007
- get properties of a relation with SQL - DMO posted by Imre Ament on Fri, 3 Aug 2007
- Unable to view job history posted by Alberto Brivio on Fri, 3 Aug 2007
- sql scalability - 1 db or 100 ? posted by Scott on Fri, 3 Aug 2007
- SQL2005 Performance Issue - Point in the right direction please ? posted by Bishman on Fri, 3 Aug 2007
- Scripting objects into indiviaual files with sql server 2005 posted by Paras Sharma on Fri, 3 Aug 2007
- mdf changed to 0 byte from 70 GB posted by amish on Fri, 3 Aug 2007
- Is there a MS-SQL equivalent of Sybase DBCC TUNE(ascinserts) comma posted by SteveH on Fri, 3 Aug 2007
- Tables used in Stored Procedure posted by TBoon on Fri, 3 Aug 2007
- merge replication licensing posted by mommi on Fri, 3 Aug 2007
- Year to date calculations posted by Pelican on Thu, 2 Aug 2007
- backup big db fail posted by 906507N on Thu, 2 Aug 2007
- Stored Procedure vs Prepared statements posted by Hassan on Thu, 2 Aug 2007
- Error 17883 in SQL error log posted by Sugarhigh on Thu, 2 Aug 2007
- query assistance posted by Johnfli on Thu, 2 Aug 2007
- Agent jobs that copy files to network shares posted by Steve Z on Thu, 2 Aug 2007
- Break mirror availability posted by sqlboy2000 on Thu, 2 Aug 2007
- SQL 2005 and XML posted by David Lozzi on Thu, 2 Aug 2007
- Cursor for MSAccess table posted by Gaspar on Thu, 2 Aug 2007
- Deleting large volume of data .. posted by Harish Mohanbabu on Thu, 2 Aug 2007
- SQL Server Licensing posted by Giles on Thu, 2 Aug 2007
- Management Studio - No Report Button in Object Explorer Details posted by Janne on Thu, 2 Aug 2007
- rowdelimiter not accepted in bulk insert statement , used in an sproc - please h posted by rshivaram..@gmail.com on Thu, 2 Aug 2007
- Using SQL 2005 Profiler posted by Hurme on Thu, 2 Aug 2007
- Question on @sql return value posted by mecn on Thu, 2 Aug 2007
- High CPU usage on 64bit (8 Way dual core) machine posted by Rabbers on Thu, 2 Aug 2007
- Maitenance plans and noskip posted by usen..@tynemarch.co.uk on Thu, 2 Aug 2007
- Dynamic date value required for function / view posted by thejamie on Thu, 2 Aug 2007
- Help with CASE in Stored Procedure posted by Dooza on Thu, 2 Aug 2007
- Dynamic cursor variable posted by pelegk1 on Thu, 2 Aug 2007
- Source Control for Database posted by Charles Law on Thu, 2 Aug 2007
- really quick question posted by Paul on Thu, 2 Aug 2007
- index & statistics posted by sali on Thu, 2 Aug 2007
- Cannot Install SQL2005 developer on Windows XP with Office 2007 pr posted by gavin on Wed, 1 Aug 2007
- Droping Partition Schema SQL 2005 posted by Praveen on Wed, 1 Aug 2007
- 12 month forecasting pivot table posted by Ant on Wed, 1 Aug 2007
- Sql Server 2000 archiving problem posted by dk.ka..@gmail.com on Thu, 2 Aug 2007
- Limiting Transaction Time? posted by karlag92 on Wed, 1 Aug 2007
- help with sql query syntax posted by Joanne M. on Wed, 1 Aug 2007
- Remote scan on linked server posted by Dale M. on Wed, 1 Aug 2007
- Email setup for Admins posted by Deasun on Wed, 1 Aug 2007
- Rowsize limit, ghost columns, and reclaiming row space. posted by Loel on Wed, 1 Aug 2007
- "model" system database transaction log posted by Peter L. on Wed, 1 Aug 2007
- SQL 2005: Getting beyond the 4000/8000 character limit when using varchar/nvarc posted by Conan Kelly on Wed, 1 Aug 2007
- SQL Agent keeps terminating, no SQLAGENT.1 file created posted by sqlboy2000 on Wed, 1 Aug 2007
- Grant permission to table for truncate table posted by mecn on Wed, 1 Aug 2007
- Backup takes longer toward the end of the month,yet load is consta posted by Methodology on Wed, 1 Aug 2007
- Strange permission mismatch problem on SQL2K? posted by zash..@gmail.com on Wed, 1 Aug 2007
- Database Mirroring Connection Question posted by acmcdba68 on Wed, 1 Aug 2007
- about copy a new stored procedure to all databases posted by kelvinwong..@gmail.com on Wed, 1 Aug 2007
- NOSKIP & SKIP make no difference to the amount of time backup take posted by Methodology on Wed, 1 Aug 2007
- Computed column, ARITHABORT, QUOTED_IDENTIFIER and Maintenance Plan posted by Ivan on Wed, 1 Aug 2007
- Question on READ_COMMITTED_SNAPSHOT posted by Peter on Wed, 1 Aug 2007
- Recreate Statistics posted by Bry on Wed, 1 Aug 2007
- Query Optimization posted by Henning Eiben on Wed, 1 Aug 2007
- Imposible restore msdb at SQL Server 2005 posted by JORULL on Wed, 1 Aug 2007
- Imposible res posted by JORULL on Wed, 1 Aug 2007
- using getdate() as alias posted by Ant on Wed, 1 Aug 2007
- non default port - client cannot connect posted by guest5 on Wed, 1 Aug 2007
- Trans log backup taking too long - can I see whats in it? posted by Methodology on Wed, 1 Aug 2007
- sql server 2000 with 2005 posted by Abhi on Tue, 31 Jul 2007
- How to connect instance on local server posted by YesGoGoGo on Tue, 31 Jul 2007
- Linked Servers posted by bpdee on Tue, 31 Jul 2007