Newsgroups : Microsoft : microsoft.public.sqlserver.server : November 2007

microsoft.public.sqlserver.server
Messages for November 2007

Messages from microsoft.public.sqlserver.server archived for November 2007:

Backup script posted by David C on Fri, 30 Nov 2007
Removing Log File posted by rmcompute on Fri, 30 Nov 2007
What permission is needed to exec sp_droprolemember? posted by Dan on Fri, 30 Nov 2007
Foreign Keys Without Index posted by TheSQLGuru on Fri, 30 Nov 2007
NT AUTHORITY/NETWORK SERVICE posted by GaryDean on Fri, 30 Nov 2007
shrinking log via gui posted by Jason on Fri, 30 Nov 2007
how to remove trace flag in startup option posted by Brian Brian on Fri, 30 Nov 2007
Service Accounts and Permissions posted by CJM on Fri, 30 Nov 2007
IMPORTANT: Search tables with data field is decimal(5,2) posted by Jesus Suarez on Fri, 30 Nov 2007
Linke server 64bit 2005SP2 to 32bit 2000 SP3 posted by steve on Fri, 30 Nov 2007
Server Name Change posted by Steven on Thu, 29 Nov 2007
sql server 2005 express vs sql server 2000 posted by John on Fri, 30 Nov 2007
Moving Database to a different LUN posted by warsai on Thu, 29 Nov 2007
Easiest way to move database from 1 machine to another ? posted by fniles on Fri, 30 Nov 2007
Enabling AWE SQL Server 2005 64-bit posted by philt on Thu, 29 Nov 2007
differences between versions of SQL serve2005 posted by Larry Killen on Thu, 29 Nov 2007
1:many with independent many posted by Tina on Thu, 29 Nov 2007
Active/Active Vs. Active/Passive posted by manu on Thu, 29 Nov 2007
Backups to another server from SQL Server posted by Pat M - City of Reno on Thu, 29 Nov 2007
Join between 2 tables, that exist on different sql server instances posted by Andy on Thu, 29 Nov 2007
-- encrypt database -- posted by Edmundo J. Davila on Thu, 29 Nov 2007
DB Mirroring in a mixed 64bit/32bit Environment posted by NickN on Thu, 29 Nov 2007
SQL 2005: Shrinking DB files posted by Conan Kelly on Thu, 29 Nov 2007
rebuilding index not doing anything posted by Chris on Thu, 29 Nov 2007
SQL log purge... posted by Daniel on Thu, 29 Nov 2007
VB Script posted by Charles A. Lackman on Thu, 29 Nov 2007
Copy Database Wizard on Vista x64 machine posted by CJM on Thu, 29 Nov 2007
Can I use SQL 2005 script to create SQL 2000 database? posted by John Steen on Thu, 29 Nov 2007
transaction log backups are failing posted by Sas on Thu, 29 Nov 2007
transfer large amt of records posted by mecn on Thu, 29 Nov 2007
SQL 2000 How do I setup SQL Mail for Failure Notification posted by Baris Ratanjee on Thu, 29 Nov 2007
Disconnected app with sql server compact posted by John on Thu, 29 Nov 2007
SQL Error posted by Adam Sankey on Thu, 29 Nov 2007
Lock escalation not working posted by James on Thu, 29 Nov 2007
long time process - what's the progress? posted by Piotr Lipski on Thu, 29 Nov 2007
SQL Svr Express Access ADP and Reports posted by John Kraus on Thu, 29 Nov 2007
Severity 20 error messages in Error log posted by vijay on Thu, 29 Nov 2007
designing inheriting entities posted by Emre DİNÇER on Thu, 29 Nov 2007
Error 12291 in Event Log posted by Tom Juergens on Wed, 28 Nov 2007
Upgrade to SQL Server 2005 posted by Lukasz Glaz on Wed, 28 Nov 2007
SUSER_SID always NULL ?!? posted by aaron.na..@gmail.com on Wed, 28 Nov 2007
Creating a VIEW based on other VIEW. posted by stevong on Wed, 28 Nov 2007
exec stored procedure without qualifying dbo posted by Hassan on Wed, 28 Nov 2007
Kerberos in Cross-Forest trust - Fails back to NTLM or Cannot generate SSPI Cont posted by Neufusion on Wed, 28 Nov 2007
Cannot connect to SQL Server from localhost (no problem from any xp client) posted by Markus on Wed, 28 Nov 2007
SQL Server 200 Login failed for user SQLSTATE 28000 SQL Server Err posted by Baris Ratanjee on Wed, 28 Nov 2007
sp_adduser problem posted by Adam Sankey on Wed, 28 Nov 2007
Moving SQL Server 2000 to SQL Server 2005 - Need suggestions on syncronization posted by Learner on Wed, 28 Nov 2007
SQL Server 2005 Maintenance Plan Error posted by NigelA on Wed, 28 Nov 2007
How to add sp to SQL 2005 cluster? posted by Clayton Sutton on Wed, 28 Nov 2007
Impact of transaction log backups in synchronous DB Mirroring syst posted by HeatherK on Wed, 28 Nov 2007
Equal disk space needed to delete .bak file? posted by rockemha..@gmail.com on Wed, 28 Nov 2007
String manipulation syntax posted by db on Wed, 28 Nov 2007
Sql better than Oracle? posted by Paulo on Wed, 28 Nov 2007
Delete & create a partition posted by r.no on Wed, 28 Nov 2007
Installing Sp2 on clustered Instances posted by Stefano Colombo on Wed, 28 Nov 2007
SQL Server 2000 download? posted by Anil Gupte on Wed, 28 Nov 2007
Do I need to Reindex after truncate table? posted by dengcharl..@hotmail.com on Tue, 27 Nov 2007
Pivot Query.... posted by tremmorke..@gmail.com on Tue, 27 Nov 2007
Local Admin posted by AHartman on Tue, 27 Nov 2007
samples not installed posted by sharman on Tue, 27 Nov 2007
Login failed for user '(Null)' posted by Jay on Tue, 27 Nov 2007
hotfix/service pack directory posted by horseradish on Tue, 27 Nov 2007
Obtain the sql server properties by code... posted by Chevy on Tue, 27 Nov 2007
question on proxy with sql 2005 posted by Paul on Tue, 27 Nov 2007
What is (+) ? posted by Paulo on Tue, 27 Nov 2007
create table posted by db on Tue, 27 Nov 2007
moveing data posted by db on Tue, 27 Nov 2007
Moveing data posted by db on Tue, 27 Nov 2007
Migration SQL server 2000 to 2005, with heavy use of DTS posted by baruffa..@gmail.com on Tue, 27 Nov 2007
Test connections with NT User groups posted by SM on Tue, 27 Nov 2007
non-admin user and SSIS (integration services) posted by horseradish on Tue, 27 Nov 2007
Added SP2 now have linked server error posted by TLuebke on Tue, 27 Nov 2007
full and diff backup - sql2005 posted by oto.pakoz..@gmail.com on Tue, 27 Nov 2007
sql 2005 copying dbmail configuration between servers posted by Piotr Lipski on Tue, 27 Nov 2007
Computed Column Formulas posted by John Kraus on Tue, 27 Nov 2007
SQL SERVER 2000 INDEX USAGE posted by generodud..@gmail.com on Tue, 27 Nov 2007
Missing index query help posted by Hassan on Mon, 26 Nov 2007
Problems with my Scheduled Backup Jobs on Windows Server 2003 SP2 posted by Mohd Al Junaibi on Mon, 26 Nov 2007
Fulldatabase backup query posted by Balaji on Mon, 26 Nov 2007
transaction log growing very quickly posted by Chris on Mon, 26 Nov 2007
Performance monitoring specific database posted by olig on Mon, 26 Nov 2007
Export Wizard Error posted by Roger Denison on Mon, 26 Nov 2007
Backup error posted by Ed White on Mon, 26 Nov 2007
identity insert issue posted by sharman on Mon, 26 Nov 2007
SQL Server 2000 production problem: can't drop/index table posted by wombatdea..@gmail.com on Mon, 26 Nov 2007
Capture Error In DTS Package posted by Creative on Mon, 26 Nov 2007
Updates posted by BigSam on Mon, 26 Nov 2007
Altering column in a large table posted by manu on Mon, 26 Nov 2007
SSIS vs. Replication posted by Jay on Mon, 26 Nov 2007
High Pagelatch and threadpool posted by Hassan on Mon, 26 Nov 2007
Trigger instead of declarative referential integrity posted by Ferdinand Zaubzer on Mon, 26 Nov 2007
SQL 2005 Express to SQL Server 2000 posted by musosdev on Mon, 26 Nov 2007
sql 2005 std increase server memory limit >2GB? posted by Piotr Lipski on Mon, 26 Nov 2007
SQL 2008 Express posted by Mahmoud Amin on Mon, 26 Nov 2007
Index size. posted by Shiju Samuel on Sun, 25 Nov 2007
Restoring a column in a table posted by tnt on Sun, 25 Nov 2007
Where to learn how to read the query execution plan? posted by pedestrian via SQLMonster.com on Mon, 26 Nov 2007
Receive "Acquiring a connection requires a valid Task name" when execute a DTS posted by Dobby Cai on Sun, 25 Nov 2007
Newbie-shrink transaction log files posted by Coop on Sun, 25 Nov 2007
Showing data from a procedure posted by MattIrwin via SQLMonster.com on Sat, 24 Nov 2007
SQL SERVER 2000 posted by Ramanpreet on Sat, 24 Nov 2007
Odd query result in SQL server 2000 posted by Eiriken on Sat, 24 Nov 2007
Database compromise - need help posted by tnt on Fri, 23 Nov 2007
Error when limiting memory usage with OSQL.EXE posted by Tom Del Rosso on Fri, 23 Nov 2007
IIS Question posted by manu on Fri, 23 Nov 2007
Collate problems posted by Juan Manuel Alegría B. on Fri, 23 Nov 2007
Live server running out of space - Can't reduce Transaction Log! posted by Mike Owen on Fri, 23 Nov 2007
Overwriting Backup Set posted by Shelley on Fri, 23 Nov 2007
database and tlog backups - MSSQL 2000 & MSSQL 2005 posted by morebeer on Fri, 23 Nov 2007
SQL 2005 and Pervasive Linked Server posted by Steve Z on Fri, 23 Nov 2007
Error Connecting SQL Server 2005 posted by carmen413 via SQLMonster.com on Fri, 23 Nov 2007
SQL 2000 Std on Win 2003 Std R2 x64 bit? posted by Leythos on Fri, 23 Nov 2007
accessing from T-SQL a database on another DBMS posted by wvandenbroeck on Fri, 23 Nov 2007
SQL Express - Identity specification posted by Mike on Fri, 23 Nov 2007
Column in profiler that shows no. of rows returned posted by Hassan on Thu, 22 Nov 2007
Setting up SQL Relationships? posted by Mark Moss on Thu, 22 Nov 2007
Why does MS SQL 2005 Management Studio runs/loads @ a snail pace? posted by stevong on Thu, 22 Nov 2007
login failure posted by Hassan on Thu, 22 Nov 2007
Copy views from one database server to another posted by db on Thu, 22 Nov 2007
Event 18454 connection non-trusted posted by pcnetnet on Thu, 22 Nov 2007
SQL server - cant see new backuped base posted by piwo on Thu, 22 Nov 2007
SQL 2005 Embedded posted by S Sainsbury on Thu, 22 Nov 2007
Entire 2005 Database deleted posted by CF on Thu, 22 Nov 2007
HT sp_help_jobschedule results? posted by Zekske on Thu, 22 Nov 2007
security connection is or not posted by ddoc on Thu, 22 Nov 2007
Regarding Transaction Log posted by Balaji on Thu, 22 Nov 2007
Trigger to fire only after a commit. posted by Avi on Thu, 22 Nov 2007
job fails for sql 2005 run SSIS package posted by Paul on Wed, 21 Nov 2007
Optimizing and shrinking large highly-transactional database posted by Curtis on Wed, 21 Nov 2007
Logging from SP posted by Mohit K. Gupta on Wed, 21 Nov 2007
Is the same? posted by Paulo on Wed, 21 Nov 2007
cannot drop mdf file posted by Roger on Wed, 21 Nov 2007
Update Timeout and indexes posted by Jim on Wed, 21 Nov 2007
sql2005 data backup posted by mecn on Wed, 21 Nov 2007
sql server 2005 upgrade posted by Ellie on Wed, 21 Nov 2007
Linked Server Properties - Security - SQL Server 2000 posted by Steve Wilkinson on Wed, 21 Nov 2007
sp_addlinkedsrvlogin syntax for "not be made" posted by Steve Wilkinson on Wed, 21 Nov 2007
can't start SQL Server Analysis Services posted by Paul on Wed, 21 Nov 2007
rollback in trigger posted by nima_kashian on Wed, 21 Nov 2007
Is there any way we can handle cross database transaction on mirrored database?? posted by DNB on Wed, 21 Nov 2007
copy many ssis packages between servers posted by Piotr Lipski on Wed, 21 Nov 2007
CPU dedicated to one Stored Procedure posted by Abel on Wed, 21 Nov 2007
Backing up to a server on another domain ? posted by pcmangl..@googlemail.com on Wed, 21 Nov 2007
Stranger than Fiction: differences in Edit vs Design a view posted by aaqqqa on Wed, 21 Nov 2007
Telling a user of an error in a function posted by Avi on Wed, 21 Nov 2007
SSIS Execute button greyed posted by Jay on Wed, 21 Nov 2007
I want to recover deleted database from SQL Server 2000 posted by skbhadu..@gmail.com on Wed, 21 Nov 2007
I want to recover deleted database from SQL Server 2000 posted by skbhadu..@gmail.com on Wed, 21 Nov 2007
SQL Server 2000 database owner question posted by Jason Huang on Wed, 21 Nov 2007
BOL - Katmai posted by Alan T on Wed, 21 Nov 2007
how to append 2 fields together posted by Paul on Tue, 20 Nov 2007
distributed transaction issue posted by jeff_y on Tue, 20 Nov 2007
Records Versioning/Auditing posted by David Lozzi on Tue, 20 Nov 2007
How to solve Deadlock posted by guest5 on Tue, 20 Nov 2007
how to determine what indexes are being used. posted by Tom on Tue, 20 Nov 2007
The affinity mask specified does not match the CPU mask on this system posted by jmcl4vid..@juno.com on Tue, 20 Nov 2007
Creating indexes posted by NC3 on Tue, 20 Nov 2007
How do I view trace flag output posted by Chris on Tue, 20 Nov 2007
ms sql cluster: should i and how to place tempdb on local drive posted by Gene. on Tue, 20 Nov 2007
BCP import large text file to sql tables posted by mecn on Tue, 20 Nov 2007
Invalid object name 'information_schema.constraint_table_usage' posted by scuba79 on Tue, 20 Nov 2007
For Xml Auto Problem posted by Looch on Tue, 20 Nov 2007
Backup fail on msllockdb & pwe files posted by Saucer Man on Tue, 20 Nov 2007
SQL Server Transaction Log growing posted by dylan on Tue, 20 Nov 2007
index on computed column ignored posted by da..@hotmail.com on Tue, 20 Nov 2007
System table with max and min values for all SQL data types posted by Avi on Tue, 20 Nov 2007
Why sql server always choose index scan instead of index seek for my query? posted by da..@hotmail.com on Tue, 20 Nov 2007
SQL Server 2005: log shipping posted by adhodgs..@gmail.com on Tue, 20 Nov 2007
SQL 2000 : space available is zero posted by Nitz on Tue, 20 Nov 2007
need urgent help posted by Bhishm on Mon, 19 Nov 2007
log shipping status posted by Hassan on Mon, 19 Nov 2007
Profiler complaining about "Sort Warnings" posted by Hassan on Mon, 19 Nov 2007
Snapshot size posted by Alan T on Tue, 20 Nov 2007
I dont see any hostname in sysprocesses posted by Hassan on Mon, 19 Nov 2007
Set recovery model posted by Alan T on Tue, 20 Nov 2007
A column nullability inconsistency was detected in the metadata E posted by Aaron on Mon, 19 Nov 2007
sql 2005 - which role allows to read ddl but not to modify it? posted by newToSql on Mon, 19 Nov 2007
SQL Server better than DB2 posted by Ian Boyd on Mon, 19 Nov 2007
Log parser posted by Hassan on Mon, 19 Nov 2007
Update copied DB posted by Stup88 on Mon, 19 Nov 2007
Sql Server 2005 posted by Salahu on Mon, 19 Nov 2007
Lost SEK posted by sql-guy on Mon, 19 Nov 2007
Tempdb - Device not ready posted by DnBDBA on Mon, 19 Nov 2007
Date Sql 2000 posted by Paulo on Mon, 19 Nov 2007
How to catch io's for tsql execution. posted by Gene. on Mon, 19 Nov 2007
SQL 2008 system requirments posted by Stup88 on Mon, 19 Nov 2007
Is SQL Express 2005 by default a single connection db? posted by RGF on Mon, 19 Nov 2007
Converting posted by Paulo on Mon, 19 Nov 2007
Database Maintenance Plans posted by cc.shine on Mon, 19 Nov 2007
Multiple mirrored databases posted by Jazmin Gutierrez on Mon, 19 Nov 2007
Transaction Log Backups Failure posted by Ron on Mon, 19 Nov 2007
Cleaning up goldmine Data posted by Blair on Mon, 19 Nov 2007
SQL Server service will not start. posted by JC1979 on Mon, 19 Nov 2007
Change minimum database size from 3mb to 2mb posted by Piotrekk on Mon, 19 Nov 2007
Distribution licensing posted by John on Mon, 19 Nov 2007
SA user lost SYSADMIN RIGHTS posted by atdmpp on Mon, 19 Nov 2007
Transaction Log posted by Balaji on Mon, 19 Nov 2007
No. Of Records inserted into a table/database posted by Balaji on Mon, 19 Nov 2007
SQL 2000 big .ldf file posted by Jason Huang on Mon, 19 Nov 2007
Transaction Log Writes posted by Balaji on Sun, 18 Nov 2007
restoring msdb with SQL 2000 posted by Howard on Sun, 18 Nov 2007
SQL 2005 has a restore problem posted by childofthe1980s on Sun, 18 Nov 2007
Report server SQL 2005 posted by support at Marin on Sun, 18 Nov 2007
Urgent: query analyzer posted by tnt on Sun, 18 Nov 2007
Unable to delete old backups posted by Peter Afonin on Sun, 18 Nov 2007
ssis and excel posted by avit..@business-solutions.co.il on Sun, 18 Nov 2007
Database Backup Problem posted by imran019 on Sun, 18 Nov 2007
statement_Start_offset again posted by Hassan on Sat, 17 Nov 2007
SQL2005 sp2x64 won't start Error: 26024, Severity: 16, State: 1 TD posted by SJ on Sat, 17 Nov 2007
Simple question on SQL 2005 posted by Adam Raff on Sat, 17 Nov 2007
SQL Server Express 2005 ad Classic ASP posted by Anil Gupte on Sun, 18 Nov 2007
Witness servers posted by manu on Sat, 17 Nov 2007
Concurrency violation adding records Why? posted by Rob Dob on Fri, 16 Nov 2007
@@CPU_BUSY posted by Jay on Fri, 16 Nov 2007
Does SSIS understand perflog binary file posted by Hassan on Fri, 16 Nov 2007
How to list (Export to txt) the Built-In and User Store Procedures posted by gatox on Fri, 16 Nov 2007
Database maintenance plan backup posted by PT on Fri, 16 Nov 2007
altering unique index to primary key posted by James on Fri, 16 Nov 2007
sms shows new job dialog when view properties posted by John on Fri, 16 Nov 2007
regarding troubleshooting blocking in sql server 2000 posted by Iter on Fri, 16 Nov 2007
Role to create views only posted by Juan Manuel Porras GÃ¡lvez on Fri, 16 Nov 2007
Two related tables transpose table 2. posted by zb on Thu, 15 Nov 2007
installing sql server 2005 express with advanced services sp2 posted by Daniel Brower on Fri, 16 Nov 2007
sys.dm_db_index_usage_stats posted by Hassan on Thu, 15 Nov 2007
SQL Server Read/Write Request Size from the Disk IO Subsystem posted by Cqlboy on Thu, 15 Nov 2007
sql server 2005 with sql server 2000 desktop consecutively posted by Daniel Brower on Thu, 15 Nov 2007
unused indexes in SQL 2005 posted by Hassan on Thu, 15 Nov 2007
Install Visual Studio or SQL 2005 first ? posted by Hassan on Thu, 15 Nov 2007
fix DBCC CHECKCATALOG errors posted by Waldemar Grzywiñski on Fri, 16 Nov 2007
Stored procedure sp_sqlagent_get_perf_counters uses too much cpu t posted by Erick Korsten on Thu, 15 Nov 2007
Temp table solve the performance issue? posted by Ed on Thu, 15 Nov 2007
Take a database out of Exclusive mode posted by Shelley on Thu, 15 Nov 2007
Cannot register server (LOCAL) posted by rkbnair on Thu, 15 Nov 2007
Query wizard posted by Aleks Kleyn on Thu, 15 Nov 2007
service pack on windows server prior install sql server 2005 standard posted by Daniel Brower on Thu, 15 Nov 2007
EXISTS Performance Problem posted by Clark Kent on Thu, 15 Nov 2007
join SmallDateTime column very slow posted by da..@hotmail.com on Thu, 15 Nov 2007
2005 Analysis Services problem! posted by Paul on Thu, 15 Nov 2007
SQL2005 and scheduled backup posted by Tom Reis on Thu, 15 Nov 2007
Database Refreshes posted by guest5 on Thu, 15 Nov 2007
c2 auditing posted by guest5 on Thu, 15 Nov 2007
DB Disk Hot Split question posted by Blue Fish on Thu, 15 Nov 2007
Cannot edit maintenance plans post SP2 posted by CharlesB1 on Thu, 15 Nov 2007
master location in sysdatabases incorrect after move posted by DaveS on Thu, 15 Nov 2007
tool to import eventlog and perfmon data into SQL database. posted by Hassan on Wed, 14 Nov 2007
index usage posted by Hassan on Wed, 14 Nov 2007
about set an alert that is about blocking posted by Iter on Wed, 14 Nov 2007
SQL Analyse Software posted by Pcnetnet on Thu, 15 Nov 2007
DDL Triggers posted by news.microsoft.com on Wed, 14 Nov 2007
Are there any good performance tuning tools that I can use to moni posted by Iter on Wed, 14 Nov 2007
-- rebuild master -- posted by Edmundo J. Davila on Wed, 14 Nov 2007
Changing backup model before running reindex posted by Kevin on Wed, 14 Nov 2007
the master, model database posted by nobody on Wed, 14 Nov 2007
Cannot get proxy account to work. posted by Chris Lumnah on Wed, 14 Nov 2007
How Does Log Shipping / Database Mirroring Work with a SAN? posted by Charles Law on Wed, 14 Nov 2007
SQL2000 end life posted by Paul on Wed, 14 Nov 2007
SQL Question posted by bpdee on Wed, 14 Nov 2007
SQL Server Access posted by Brett_A on Wed, 14 Nov 2007
Poor SQL Server Performance on High End System posted by Jimmy on Wed, 14 Nov 2007
[AdventureWorks] database backup failed with error: 3013 posted by Jay on Wed, 14 Nov 2007
can SP4 be uninstalled? posted by Brad Ashforth on Wed, 14 Nov 2007
dts package failure when setup as job posted by Paul on Wed, 14 Nov 2007
Local Testing Using SQL Server posted by Brett_A on Wed, 14 Nov 2007
AppDomain unloads due to memory pressure. posted by vlad on Wed, 14 Nov 2007
What is an 'SQL process' posted by Roger on Wed, 14 Nov 2007
List remote server and directory posted by guest5 on Wed, 14 Nov 2007
SQL Server on Virtualized environment posted by Majid on Wed, 14 Nov 2007
How to open DTS posted by Ratan on Wed, 14 Nov 2007
Importing Comma Delimited Data. posted by ben brugman on Wed, 14 Nov 2007
License posted by pragyafeelin..@gmail.com on Wed, 14 Nov 2007
online indexing on standard edition posted by Hassan on Tue, 13 Nov 2007
SQL2005 - How to remove database file and filegroup posted by ThorR on Tue, 13 Nov 2007
need to backup databases and reinstall posted by nobody on Tue, 13 Nov 2007
AWE got 0, said DBCC MEMORYSTATUS... posted by light_wt on Tue, 13 Nov 2007
copy/replace column data? posted by Russ Hromyko on Wed, 14 Nov 2007
Simple recovery - transaction log posted by Alan T on Wed, 14 Nov 2007
BCP truncation error on few tables? posted by Jeje on Tue, 13 Nov 2007
sql server 2000 sp4 hot fix (8.00.2148) posted by Ron A on Tue, 13 Nov 2007
SQL 2000 msdb, master, model, tempdb backup question posted by Jason Huang on Wed, 14 Nov 2007
apply unique constraint in MS posted by Tina on Tue, 13 Nov 2007
Attempted to move System table posted by Scott on Tue, 13 Nov 2007
SQL database really slow when I added index to a table please help!!!!! posted by mazdotnet on Tue, 13 Nov 2007
Please help Index slowed down our production system posted by mazdotnet on Tue, 13 Nov 2007
The text data field posted by rojel..@gmail.com on Tue, 13 Nov 2007
Dual Core CPUs and Parallelism posted by Leila on Wed, 14 Nov 2007
Database path contains an Extra Backslash. posted by Jon Osborn on Tue, 13 Nov 2007
troubleshooting slowness posted by J on Tue, 13 Nov 2007
Mercury LoadRunner posted by Isaac Alexander on Tue, 13 Nov 2007
looping result printed posted by mecn on Tue, 13 Nov 2007
Index Question posted by bpdee on Tue, 13 Nov 2007
Percentage? posted by Paulo on Tue, 13 Nov 2007
Cross apply requires 9.0 compatibility posted by thejamie on Tue, 13 Nov 2007
SQL Server 2005 Developer Edition posted by JDS on Tue, 13 Nov 2007
Builtin\Administrators posted by NC3 on Tue, 13 Nov 2007
SSMS Query Editory change default directory for saved sql scripts posted by Mike Mullane on Tue, 13 Nov 2007
Copy timestamp data between columns posted by Justindawg on Tue, 13 Nov 2007
msdb corrupted in sql 2005 sp2, how to start with a new one? posted by Federico Caselli on Tue, 13 Nov 2007
import text file to sql tables? posted by mecn on Tue, 13 Nov 2007
select blocking itself posted by Wade Ding on Tue, 13 Nov 2007
mssql server started and then stopped posted by nobody on Tue, 13 Nov 2007
insufficient memory availbele posted by pcnetnet on Tue, 13 Nov 2007
Best indexing option? posted by Andy on Tue, 13 Nov 2007
Grant rights to Truncate table to specific user 2000/2005 posted by terrysham..@gmail.com on Tue, 13 Nov 2007
What happens when clustered server failing over posted by Wade Ding on Tue, 13 Nov 2007
Severe Error when running a view posted by Johnny Falcon on Tue, 13 Nov 2007
User role membership posted by manu on Tue, 13 Nov 2007
Convert DB Collation Sort Type in SQL 2005 for MS Dynamics GP posted by HAfandi on Tue, 13 Nov 2007
Query Privileges posted by Praetorian Guard on Tue, 13 Nov 2007
Error connecting to SQL 2000 remotely posted by Simon on Tue, 13 Nov 2007
SQL 2005 generates 1000's of logs posted by Marcus on Tue, 13 Nov 2007
How to make a StandBy server to be a Primary server? posted by Jason Huang on Tue, 13 Nov 2007
execution plan operators posted by Hassan on Mon, 12 Nov 2007
SQL Express Server Authentication posted by mets19@gmail.com on Tue, 13 Nov 2007
domain administrator password and sql services startup posted by bntgoog..@yahoo.com on 12 Nov 2007
1:1 cardinality ? posted by Tina on Mon, 12 Nov 2007
sql server running uder unix? posted by mecn on Mon, 12 Nov 2007
text edit to open 4.5 gb text file posted by mecn on Mon, 12 Nov 2007
Moving DB's to a new server posted by Jay on Mon, 12 Nov 2007
Types of columns posted by Paulo on Mon, 12 Nov 2007
SQL Server does not exist or access denied problem.... posted by Joe on Mon, 12 Nov 2007
Database Tuning Advisor doubt. posted by generodud..@gmail.com on Mon, 12 Nov 2007
Help explain statement start offset and end offset posted by Hassan on Mon, 12 Nov 2007
Massive Performance Hit Running Two Queries on Different Databases posted by Charles Law on Mon, 12 Nov 2007
Is this the correct syntax? posted by bobh on Mon, 12 Nov 2007
Getting all indexes (both clustered and nonclustered) posted by mazdotnet on Mon, 12 Nov 2007
How do I find the source of mystery backups? posted by Bev Kaufman on Mon, 12 Nov 2007
How MERGE few databases to big one posted by anxco..@gmail.com on Mon, 12 Nov 2007
Database Tuning Advisor problems posted by Catadmin on Mon, 12 Nov 2007
PL/SQL code to load data from a flat file into a MS-SQL Server table posted by Ratan on Mon, 12 Nov 2007
XP_smtp_sendmail and SQL 2000 SP4 posted by jouj on Mon, 12 Nov 2007
~How to write posted by pal on Mon, 12 Nov 2007
Timeouts after periods of inactivity in server posted by Squig on Mon, 12 Nov 2007
Linked Server Error posted by davids@thorntonsinc.com on Sun, 11 Nov 2007
Profiler and Perfmon data side by side posted by Hassan on Sun, 11 Nov 2007
How to write? posted by pal on Mon, 12 Nov 2007
will timed out queries show in profiler? posted by Hassan on Sun, 11 Nov 2007
statements running with sp_who2 active posted by Hassan on Sun, 11 Nov 2007
log shipping question posted by Jason Huang on Mon, 12 Nov 2007
error:8646,severity:21,state:1 posted by MICS on Sun, 11 Nov 2007
sql server running under local system account posted by Hassan on Sun, 11 Nov 2007
capture showplan in profiler posted by Hassan on Sun, 11 Nov 2007
Warning: Fatal error 3624 occurred posted by schli..@012.net.il on Sun, 11 Nov 2007
what made us lost our clustered index posted by Wade Ding on Sun, 11 Nov 2007
General configuration question - maximum performance. posted by Dave A on Sun, 11 Nov 2007
Perfmon data trending for free :) posted by Hassan on Sun, 11 Nov 2007
Memory paging out noted in errorlog posted by Hassan on Sat, 10 Nov 2007
How busy is my tempdb ? posted by Hassan on Sat, 10 Nov 2007
High Disk queue length.. how slow posted by Hassan on Sat, 10 Nov 2007
how to determine cause here ? posted by Hassan on Sat, 10 Nov 2007
SQL Server 2008 Release Date posted by Leila on Sat, 10 Nov 2007
WRITETEXT and UPDATETEXT on table variables posted by Albert on Sat, 10 Nov 2007
Need magic trick to set index as PK posted by JRStern on Fri, 9 Nov 2007
Cannot delete a record in a table posted by SftwDude on Fri, 9 Nov 2007
indexes on foreign key columns? posted by Joel Lyons on Fri, 9 Nov 2007
Performance affecting users only posted by pfrank61 on Fri, 9 Nov 2007
Log shipping TLog dump naming covention posted by Hassan on Fri, 9 Nov 2007
help installing service pack posted by pete0085 on Fri, 9 Nov 2007
uninstall SQL 2005 Studio Express so that I can install SQL 2005 t posted by childofthe1980s on Fri, 9 Nov 2007
viewing connection status posted by tnt on Fri, 9 Nov 2007
Formatting query/view in SQL Server Management Studio (2005) posted by Paul on Fri, 9 Nov 2007
SQL 2000 Script User Logins With Passwords posted by LaEsmeralda on Fri, 9 Nov 2007
Drop table causes system to hang posted by mlwallin on Fri, 9 Nov 2007
union different queries from temp table posted by skyloon on Fri, 9 Nov 2007
domain administrator password and sql services startup posted by bntgoog..@yahoo.com on Fri, 9 Nov 2007
I locked myself out of the server posted by AlanPorter on Fri, 9 Nov 2007
sa password posted by DXC on Fri, 9 Nov 2007
Increasing disk space on cluster for data drive posted by gb on Fri, 9 Nov 2007
Any standalone version of SQL2005 Express? posted by aNewbie on Fri, 9 Nov 2007
SQL Server 2000 log shippping question posted by Jason Huang on Fri, 9 Nov 2007
Why does the log file grow so large? posted by Michael Bray on Thu, 8 Nov 2007
Two versions of SQL Server one the same machine? posted by Peter Olcott on Thu, 8 Nov 2007
dbo's Login Name is blank and can't be edited from Enterprise Manager posted by Eli on Thu, 8 Nov 2007
SQL 2000 and 2005 posted by greg on Thu, 8 Nov 2007
SQL Server Express 2005 command line params... posted by gr..@ram-software.com on Thu, 8 Nov 2007
Odbc access posted by AHartman on Thu, 8 Nov 2007
Errors when rebuilding indexes posted by MKBOBBA on Thu, 8 Nov 2007
BACKUP LOG WITH TRUNCATE_ONLY is deprecated in 2005 posted by Jay on Thu, 8 Nov 2007
How do you figure out what's hammering the server? posted by JimLad on 8 Nov 2007
DTS Package- Check its useability posted by shub on 8 Nov 2007
1:M Relationship and Records Deletion posted by VUNETdotUS on 8 Nov 2007
2005 msdb database size posted by Jay on Thu, 8 Nov 2007
Weird behaviour with user-defined type and NOT NULL posted by Thomas Steinmaurer on Thu, 8 Nov 2007
Urgent! How recover master db from master.mdf and mastlog.ldf posted by Zrich on Thu, 8 Nov 2007
Can tempdb be presized? posted by Jay on Thu, 8 Nov 2007
History of all SQL Executed posted by Sumit Pal on Thu, 8 Nov 2007
CTE behind the scenes posted by Arthur Dent on Thu, 8 Nov 2007
Compatibility Level posted by John Holt on Thu, 8 Nov 2007
Exporting SQL db from Visual Studio? posted by musosdev on Thu, 8 Nov 2007
Which SQL version for Vista? posted by Matutolas on Thu, 8 Nov 2007
Editing Stored Procedures posted by Rockn on Thu, 8 Nov 2007
Security Question posted by DXC on Thu, 8 Nov 2007
Performance question : One single MDF file ? Or multiple MDF file ? posted by cpchan on Thu, 8 Nov 2007
temp table posted by Jack Vamvas on Thu, 8 Nov 2007
Service Pack 2 - how to know has installed posted by Alan T on Thu, 8 Nov 2007
Moving RootDirectory from disk C to D (Database Engine, Analysis Services) posted by anxco..@gmail.com on Thu, 8 Nov 2007
Display results like this using SQL posted by RP on Thu, 8 Nov 2007
Log file not freeing space (FULL recovery model) - even after transaction log ba posted by David Conte on Wed, 7 Nov 2007
Restrict decimals posted by RP on Thu, 8 Nov 2007
New request is not allowed to start posted by r..@aic.net.au on Wed, 7 Nov 2007
Redirecting an EXEC to null posted by Michael Bray on Wed, 7 Nov 2007
How to determine ROWCOUNT without executing the select statement posted by Michael Bray on Wed, 7 Nov 2007
sp_configure lightweight pooling posted by Jason on Wed, 7 Nov 2007
2nd Login failed for user '(null)' ... posted by Jay on Wed, 7 Nov 2007
sql table structure doc posted by mecn on Wed, 7 Nov 2007
SQL 6.5, 7.0, and 2000 Upgrade posted by Mohit K. Gupta on Wed, 7 Nov 2007
Memory Configuration Question - SQL 2000 sp4 posted by BH337 on Wed, 7 Nov 2007
Different procedures for SQL 2000 and 2005 posted by Mark Lemoine on Wed, 7 Nov 2007
Using share for a backup device posted by Tom Reis on Wed, 7 Nov 2007
Sybase Linked Server Error posted by Doug on Wed, 7 Nov 2007
creating a new database from .bak posted by andy on Wed, 7 Nov 2007
Best Practices: Should other (unrelated) applications be installed on a SQL ser posted by jimguytruck..@yahoo.com on Wed, 7 Nov 2007
Best Practice posted by Bad Beagle on Wed, 7 Nov 2007
only 1 out of 8 CPU maxed out posted by Cranfield on Wed, 7 Nov 2007
SQL Server 2005 64 Bit posted by Cy on Wed, 7 Nov 2007
Need some help posted by RBS via SQLMonster.com on Wed, 7 Nov 2007
Moving logshipping target database (sql2000) without recovery posted by Paul Cahill on Wed, 7 Nov 2007
sql server grinding to a halt on uploads posted by jimschlemm..@gmail.com on Wed, 7 Nov 2007
Retrieving XML Data posted by Michael Bray on Wed, 7 Nov 2007
Cannot delete a maintenance plan posted by Larry on Wed, 7 Nov 2007
Where is the default collation stored? posted by Brian Cryer on Wed, 7 Nov 2007
SQL Server 2000 log shipping BAK and TRN files question posted by Jason Huang on Wed, 7 Nov 2007
Must Remove SQL Server Components when Installing Accountant posted by WJB on Tue, 6 Nov 2007
Login failed for user '(null)' - new laptop can't connect, using mixed mode posted by Mark on Tue, 6 Nov 2007
Stored Procedures getting created as system stored procedures. posted by Jason Shadonix on Tue, 6 Nov 2007
Upsert Insert/Update using Except and Intercept posted by Ron on Tue, 6 Nov 2007
SELECT really slow for me posted by mazdotnet on Tue, 6 Nov 2007
Restore of Model databse posted by msnews.microsoft.com on Tue, 6 Nov 2007
MaintenancePlan - task order posted by anxco..@gmail.com on Tue, 6 Nov 2007
Backup Standards and Suggestions posted by Mohit K. Gupta on Tue, 6 Nov 2007
Performace Monitor and SQL Profiler posted by Mohit K. Gupta on Tue, 6 Nov 2007
Strange Problem Works with SQL Server 2000 but give error in SQL 2 posted by Netaji on Tue, 6 Nov 2007
Connecting to a DB in a non-trusted domain posted by Jay on Tue, 6 Nov 2007
SQL server table reindex posted by mecn on Tue, 6 Nov 2007
PAE & AWE Question posted by Walid on Tue, 6 Nov 2007
Stored procedure posted by omasis on Tue, 6 Nov 2007
moving database files from hard disk to storage posted by DarthSidious on Tue, 6 Nov 2007
After installing active directory I failed to connect SQL server 2000 posted by asif on Tue, 6 Nov 2007
64 bit 2003 server, 32 bit sql standard posted by thejamie on Tue, 6 Nov 2007
SQL Backup posted by Kevin A on Tue, 6 Nov 2007
OK to install Outlook 2003 client on an SQL Server 2005? posted by Alan on Tue, 6 Nov 2007
Named Pipe question posted by Jason Huang on Tue, 6 Nov 2007
script in 2005 cannot be run on sql server 2000 posted by kei on Mon, 5 Nov 2007
get text after a delimiter posted by RP on Tue, 6 Nov 2007
Rows in sys.partitions posted by Balaji on Mon, 5 Nov 2007
DELETE certain rows posted by Russ Hromyko on Tue, 6 Nov 2007
sql 2005 trial edition posted by tulip on Mon, 5 Nov 2007
Two step NT Remote Backup posted by David C on Mon, 5 Nov 2007
FC or ATA for LOG FILES? posted by SBG on Mon, 5 Nov 2007
SQL 2005 - Adding a description to DB? posted by Mark on Mon, 5 Nov 2007
master, model & msdb in database list posted by Jay on Mon, 5 Nov 2007
insufficient system posted by BigSam on Mon, 5 Nov 2007
Collation problem migrating 2000 > 2005 posted by Tchavdar Todorov on Mon, 5 Nov 2007
Strange problem Sql 2005 returning different size result sets from different mac posted by Rob Dob on Mon, 5 Nov 2007
Openrowset error posted by Alvin Clark on Mon, 5 Nov 2007
sql server 2k error message posted by Gerry M on Mon, 5 Nov 2007
Windows Server 2003...64 bit or 32 bit? posted by jason7655 on Mon, 5 Nov 2007
64-bit Windows/64-bit SQL - External Drives posted by craig_amtdatatechnologies@discussions.mi on Mon, 5 Nov 2007
Duplicate SQL Server entry posted by Makenshi on Mon, 5 Nov 2007
Error 17 SQL SERVER posted by thejamie on Mon, 5 Nov 2007
Failing job step while running an Batch File in SQL Server Agent posted by L.J.J. Priemis on Mon, 5 Nov 2007
what is cost based optimiser? posted by Hassan on Sun, 4 Nov 2007
Any good link on tracking memory issues posted by Hassan on Sun, 4 Nov 2007
Pagefile for SQL Server posted by Hassan on Sun, 4 Nov 2007
correlated subqueries posted by Hassan on Sun, 4 Nov 2007
need help posted by Miley Cyrus on Mon, 5 Nov 2007
SQL Server 2005 Express Edition Problems posted by Malhyp on Sun, 4 Nov 2007
Automate to get version number for a list of SQL Instances posted by shub on Sun, 4 Nov 2007
Can I still recover this database : Only have the MDF file, no LDF file ? posted by cpchan on Sun, 4 Nov 2007
databse restore posted by Ron A on Sat, 3 Nov 2007
How does ANSI_PADDING work? posted by Bev Kaufman on Sat, 3 Nov 2007
ANSI_NULL setting and null comparisons posted by Bev Kaufman on Sat, 3 Nov 2007
SQL "built in" to the server posted by childofthe1980s on Sat, 3 Nov 2007
Getting the identity of some newly created row posted by pinkfloydhomer@gmail.com on Sat, 3 Nov 2007
What's the right data type for an id posted by Gotch on Sat, 3 Nov 2007
Running ACT! 2008 Database on two Laptops posted by Charles Turner on Sat, 3 Nov 2007
about Microsoft SQL Server 2005 Express Edition Service Pack 2 posted by apung on Fri, 2 Nov 2007
64 bit and max server memory posted by Hassan on Fri, 2 Nov 2007
Multi column subquery help requested posted by SandpointGuy on Fri, 2 Nov 2007
sql 2005 copy database wizard fails x64 to x64 posted by paul moore on Fri, 2 Nov 2007
Vachar( 100) vs Varchar(2000) vs Varchar(max) posted by Nalaka on Fri, 2 Nov 2007
forcing remote evaluation of like filters with linked servers posted by paul moore on Fri, 2 Nov 2007
Generic report and dataset posted by greg on Fri, 2 Nov 2007
VMWare ESX posted by Ken on Fri, 2 Nov 2007
SQL move (by restore) to new hardware posted by RW on Fri, 2 Nov 2007
Transfer Rate Versus Access Time posted by Scott Eguires on Fri, 2 Nov 2007
The server principal 'Domain\name' already exists. posted by Erin on Fri, 2 Nov 2007
DBname (loading) posted by Jay on Fri, 2 Nov 2007
could not find table error posted by Dan D. on Fri, 2 Nov 2007
Memory issue posted by Stuck on Fri, 2 Nov 2007
Restoring a database to a database with a different name. posted by Mufasa on Fri, 2 Nov 2007
backup question posted by Dan D. on Fri, 2 Nov 2007
one-to-one relationships in a database diagram posted by Andy Fish on Fri, 2 Nov 2007
CORRUPTED BAK files posted by mrique on Fri, 2 Nov 2007
Use query plan to a stored procedure posted by Hassan on Thu, 1 Nov 2007
Figure out no. of index tree levels posted by Hassan on Thu, 1 Nov 2007
backup posted by Ron A on Thu, 1 Nov 2007
SQL Server 2000 log shipping Destination Database question posted by Jason Huang on Fri, 2 Nov 2007
Help connecting to SQLEXPRESS using asp.net posted by lytu..@gmail.com on Fri, 2 Nov 2007
Restore Deleted Instance of SQL 2000 posted by ..@clowwater.com on Thu, 1 Nov 2007
How to log errors within a transaction and survive a ROLLBACK posted by willi..@accupointe.com on Fri, 2 Nov 2007
LoginName # posted by Ann on Thu, 1 Nov 2007
Could this be run using OSQL script posted by AHartman on Thu, 1 Nov 2007
Time needed to do a shrinkfile posted by Henrik Davidsen on Thu, 1 Nov 2007
SQL server 2005 64 bit Replication posted by JDS on Thu, 1 Nov 2007
Identifying SQL Server version and edition posted by ryblah9 on Thu, 1 Nov 2007
Need Advice on Backups posted by TDanley on Thu, 1 Nov 2007
Locking... posted by Joe on Thu, 1 Nov 2007
Login failed for user 'NT AUTHORITY\SYSTEM' posted by mgeorge8882000@yahoo.com on Thu, 1 Nov 2007
Identify long running tranactions posted by Shawn on Thu, 1 Nov 2007
Open transactions posted by Jay on Thu, 1 Nov 2007
S2005 maintenance plan issues posted by Pete Berry on Thu, 1 Nov 2007
Can I Query A Temporary Table? posted by zinck74 on Thu, 1 Nov 2007
Utilize better with memory switch posted by Jane on Thu, 1 Nov 2007
Differences between SQL Server and MySQL posted by Hassan on Thu, 1 Nov 2007
BCP invalid date posted by Thiru.net on 1 Nov 2007
SQL Server 2005 Missing Reports Icon/Context menu - HELP Please posted by Kinch on Thu, 1 Nov 2007
DB Shrink - Could not adjust the space allocation for file Error posted by JKL on Thu, 1 Nov 2007
Query latest attached database posted by Heiko Schuler on Thu, 1 Nov 2007
Error: Remotely connecting to Surface Area Configuration posted by shub on Thu, 1 Nov 2007
BULK INSERT performance posted by Scott Nichol on Thu, 1 Nov 2007
SQL Authenticated logins with unknown passwords posted by thejamie on Thu, 1 Nov 2007
SQL Server 2005 waste of time and money posted by John Rivers on Thu, 1 Nov 2007
bcp invalid date format posted by Thiru.net on Thu, 1 Nov 2007
Data and Log files posted by Rick on Thu, 1 Nov 2007
SQL 6.5 Undelete records posted by Jeffery on Wed, 31 Oct 2007
Cannot drop triggers using dynamic SQL posted by Ant on Wed, 31 Oct 2007
Generating a script for triggers only (not tables) posted by Ant on Wed, 31 Oct 2007
Fastest way to move XML document into and back out of CLR function posted by DR on Wed, 31 Oct 2007

microsoft.public.sqlserver.serverMessages for November 2007

microsoft.public.sqlserver.server
Messages for November 2007