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

microsoft.public.sqlserver.serverMessages for August 2007

microsoft.public.sqlserver.server
Messages for August 2007