Rating Thread / Thread Starter	Last Post	Replies	Views
error message Ox80070570 ( 1 2 ) When I log in this error message comes straight after saying: Error parsing... liz	05-21-2008 06:59 AM Tibor Karaszi	10	37
Steps for jobs ( 1 2 ) Hi! I have a SQL Job with 24 independent steps. I would like to send out a notification if any of the steps failed but the job should... tolcis	05-21-2008 06:15 AM Laszlo Toth	13	47
Transfer of data doesn't complete ( 1 2 ) Hi! I am running SQL 2000 SP4. I have a table1 with about 6.5mil rows. I created another table (table2) and I needed to transfer all data from... tolcis	05-21-2008 05:02 AM John Bell	10	28
SQL Server 2000 shuts itself down. ( 1 2 3 4 5 ... Last Page) If my memory is correct, this server doesnt run on an evaluation copy of MSSQL. Here are some entries from the Event Viewer application log: 6006... samk17	05-21-2008 02:03 AM Uri Dimant	60	116
cancelling update statistics command ( 1 2 ) If I run an update statistics and then cancel it before finishing, does it have any kind of effect on statistics? Or is the end result the same as... Sam	05-21-2008 02:01 AM Uri Dimant	10	25
SQL2005 Trying to create re-useable error trapping SP to be calledfrom another SP ( 1 2 ) Hello, I’m trying to create a re-useable stored proc that will build an error message that will be returned to the calling proc, I’ll call this... GiJeet	05-21-2008 01:46 AM Tibor Karaszi	10	28
Starting SQL in single user mode ( 1 2 3 4 5 ... Last Page) This is an old issue, but I want to see whether there are new tricks. If I want to start the SQL instance in a single user mode and I don't want any... Linchi Shea	05-20-2008 10:41 PM Linchi Shea	80	115
SQL server on domain controller ( 1 2 3 ) Hi, I heard many comment about not putting SQL server on a domain controller. Can someone tell me what is the implication of it? Thanks OM	05-20-2008 10:27 PM Aaron Bertrand [SQL Server MVP]	20	44
SQLOperator\Join We are converting some queries that were used in SQL Server 2000 to SQL Server 2005. They have a where clause like below: where personid *=... gh	05-20-2008 05:27 PM gh	0	20
page issue ( 1 2 3 ) Hi! I am getting the follow error message when trying rebuild an index or run DBCC Checkdb. ODBC error: Attempt to fetch logical page (1:53888) in... tolcis	05-20-2008 02:46 PM Geoff N. Hiten	20	51
Upgrade to SQL Server 2005 Still Show Version 2000 ( 1 2 3 4 5 ... Last Page) Need help here: Upgrading from 2000 to 2005 and applying SP2 ran well. But the instance and databases are still showing version 8, not 9, even... JohnDo3	05-20-2008 02:27 PM Ekrem Önsoy	60	102
insoluble problem: cannot make remote connection ( 1 2 3 4 ) Greetings I know this is a bit of old chestnut as questions go but I have experienced serious problems making a remote connection. I have googled... Granty	05-20-2008 02:07 PM Ekrem Önsoy	30	60
Database performance ( 1 2 3 4 5 ) We are having problems with database performance at some of our bigger customers. Our biggest customer has a 1.1 TB database and they are... Richard Douglass	05-20-2008 09:52 AM TheSQLGuru	40	69
2 instances with 32 GB of RAM ( 1 2 3 4 5 ) We have 2 instances on a box with 32 GB of RAM. When we set max memory on each, do we want to give each say 30GB leaving 2GB for OS or do we give... RR	05-20-2008 09:49 AM TheSQLGuru	40	73
How to verify all records touched/accessed in a very large table ( 1 2 3 ) Hi all Using Sql server 2005. I would like to know if there is a utilty or if you have any ideas on finding out which records have been accessed in... Sbell	05-20-2008 09:24 AM Pete Kane	20	45
Isolation Level in NON-Transaction Selects ( 1 2 ) I need to set the Isolation Level (in ADO) for the Non-transaction queries to SNAPSHOT. Both the ADO.Connection.IsolationLevel Property and the SQL... Ariel	05-20-2008 08:47 AM Alex Kuznetsov	10	29
inner join on 3 tables produces duplicates ( 1 2 3 ) table 1 abc 241060 3332.29 table 2 abc def 241060 OH_Adm_InsPremOth Whiskey	05-20-2008 05:11 AM Whiskey	20	49
DELETE ( 1 2 3 4 5 ... Last Page) I need to delete ID '1' and '3' using SQL: ID Customer DateTime 1 1 3/06/2005 03:00:00 2 1 3/06/2005... morphius	05-19-2008 09:43 PM morphius	120	187
SQL 2005 automatically disconnect ( 1 2 3 ) Hi, our ERP software connects to SQL server 2005 Ent. 64 bit throw ADO 2.8. The application runs on a Windows 2003 Server with Terminal... Stefano	05-19-2008 05:39 PM Daniele	28	41
question regarding multiple instances of SQL2000 on BSB2003 Premium ( 1 2 3 4 5 ) Good morning! Okay, this question is regarding putting a second instance of SQL2000 on the SBS2003 box. Client has an application that makes use of... Cary Shultz	05-19-2008 05:00 PM Cary W. Shultz	40	66
SQL 2005 Disaster Recovery ( 1 2 ) I've got a Disaster Recovery plan for SQL 2000 that I'm trying to modify to work with SQL 2005. Currently, I've built a test server (same OS build,... John Trask	05-19-2008 02:53 PM Tibor Karaszi	10	30
Does SQL Server run well over the Internet? ( 1 2 3 4 5 ... Last Page) I have an Access 2003 application that works well in a LAN environment with a Jet based back end. However, I would like to move this back end to a... David Anderson	05-19-2008 11:59 AM John Bell	50	85
Problems creating replica for Database on SQL2005 SP2 ( 1 2 ) Error: Type: Replica creation Status: Failed Description: An unexpected error occurred during job execution. (ID 104 Details: The filename,... jb	05-19-2008 09:24 AM Hitesh Sharma [MSFT]	10	30
page allocation issue Hi all, I am running SQL 2000 Enterprise SP4 on Windows Server 2003 Standard SP2 I am getting the follow error message: Table error: Page (1:53888)... tolcis	05-19-2008 09:24 AM tolcis	0	25
inner join on 3 tables - the result returned is duplicated ( 1 2 3 ) table 1 abc 241060 3332.29 table 2 abc def 241060 OH_Adm_InsPremOth table 3 def Whiskey	05-19-2008 09:05 AM John Bell	20	50
MSSQL server timeout ( 1 2 3 ) HI I was deleteing old data (app 400 MB) from an MSSQL server, with max 4 GB. Now it is 4,83 GB, and I cannot loginm I get a timeout error. When I... jodleren	05-19-2008 08:23 AM John Bell	20	44
Delete ABC log file for ABC database, affects XYZ log file XYZ dat ( 1 2 3 4 ) I backup and detach a database ABC , then delete ABC log file for ABC database, then attach database ABC . This affects the XYZ log file and XYZ... Whiskey	05-19-2008 08:11 AM John Bell	30	69
backup and restore - NTBackup / SQL2000 SP4 on SBS2003 Premium ( 1 2 3 4 5 ... Last Page) Good morning! Quick question - in an SBS2003 SP2 Premium environment we have a need to back up the SQL Database and then restore it. The client has... Cary Shultz	05-19-2008 03:25 AM Cary Shultz	50	89
WinDBPro. Ver 2.0 WinDBPro. Ver 2.0 Works with any Windows Version Complete DB one exe file only One file : (88KB) 12 billion Record Capacity Search / Sort /Find Built... Scott	05-19-2008 01:31 AM Scott	0	19
Cannot install the default instance of SQL 2005 ( 1 2 3 4 ) I had SQL express installed and tried to upgrade to SQL 2005. It allows me to create a new named instance but won't upgrade the default... Bradley Davidson	05-18-2008 01:10 PM John Bell	30	62
query to find long running query ( 1 2 3 4 5 ... Last Page) I want to write a query that will tell me if there are queries that are still running and are past 20 mins since it came in ? How can I do so ? I am... Jack	05-18-2008 11:33 AM Jack	58	94
Bad behaved client application ( 1 2 3 4 5 ... Last Page) I'm suspecting that one of the .NET applications that connects to our SQL Server 2005 occasionnaly goes into an infinite loop while inside... AlanPorter	05-18-2008 07:43 AM Andrew J. Kelly	100	138
Moving a large database ( 1 2 3 4 5 ... Last Page) SQL Server 2005 What's the best way to move a half-terabyte database from one drive to another, while minimizing downtime? Simple backup/restore or... cruscio@gmail.com	05-18-2008 04:47 AM John Bell	50	108
Stats Update ( 1 2 3 4 ) Hi all, My question is about updating statistics. I have come to find out that letting SQL Server create and update statistics did not work for me... Bulent	05-17-2008 11:57 PM Uri Dimant	37	77
SAN Storage ( 1 2 3 ) Our SAN storage team states that we dont have to worry about RAID 10 or RAID 5 and they will give us the performance we need. They said its RAID 5... Jack	05-17-2008 10:17 PM Linchi Shea	20	50
Error 22029 on Transaction Log Backup ( 1 2 ) Hi, I just upgraded an old SQL7.0 db to SQL 2000, and put it on a new server. I can't get the backups to run from the maint plan. It gives the... Lance Wynn	05-17-2008 07:09 PM Lance Wynn	10	37
VMWare Fusion/Sql Server/Jython/Java I am trying to connect to SQL Server running on VMWare fusion on a Macintosh. The connectivity drivers work (1.2) but I can't connect. I get the... axwack	05-17-2008 07:00 PM axwack	0	21
mirror question ( 1 2 3 ) I have mirroring set up from server PRD to DR, working fine. Doing failover test right now, all is going well. Took PRD offline, changed IP, now DR... JOH	05-17-2008 10:08 AM JOH	20	54
Restoring 2005 DB ( 1 2 ) First be patient - I'm an Informix DBA who is tasked to manage a 2005 install. I have a db that's been restoring for 24 hrs and is only 12 MB. ... Scott	05-17-2008 08:05 AM Dan Guzman	10	39
SQL2005 engine service account - domain user? ( 1 2 ) Hi, The installation prompts for user to run the engine service account, the default (and recommended) user is a domain user, not a local user.... Gerry Hickman	05-17-2008 05:50 AM John Bell	10	34
Collation Order SQL2000->SQL2005 ( 1 2 ) Hi, I've moving some databases from SQL 2000 to SQL 2005 (new master and model). All our Windows servers are set to either English US or English UK.... Gerry Hickman	05-17-2008 05:30 AM John Bell	10	43
%Disk Time ( 1 2 3 4 5 ) Dear All, I am doing a performance analysis for one of my customer. After analysis of the perfmon logs I foundout average _Total %DiskTime is around... Balaji	05-16-2008 07:50 PM Andrew J. Kelly	40	112
Full recovery model for shrinking transaction logs? ( 1 2 3 4 ) Hello: A client is going to run these two scripts in SQL 2000, in order to shrink the transaction log of the database to a reasonable size: BACKUP... childofthe1980s	05-16-2008 05:01 PM Aaron Bertrand [SQL Server MVP]	38	63
No Results when using Encrypt and TrustServerCertificate - SQL2005 Hi All, can someone shed some light on my issue. I have an SQL Server 2005 instance setup and have not specified a Server Certificate. When i... SirCodesALot	05-16-2008 12:34 PM SirCodesALot	0	22
Instances Information ( 1 2 ) Is anybody having t-sql or vbscript that can display the SQL Server instances installed on the machine? Please share it if you have any such... manu	05-16-2008 12:08 PM Alan Brewer [MSFT]	10	35
SQL Server service does not start ( 1 2 3 4 ) Hi, I have a SQL Server that was earlier a part of the domain and had a domain account for the MSSQLSERVER service and SQLSERVERAGENT service. Now... ronnie	05-16-2008 10:46 AM ronnie	30	65
USERSTORE_TOKENPERM cache store problems in build 3239 Hi, I thought that this problem had been fixed in build 3186 but we still see it in build 3239. I followed Jasper's tracking method and fire off the... Chris Wood	05-16-2008 10:43 AM Chris Wood	0	27
Package error in DTS ( 1 2 ) Hi All, When I double click on the work from arrow which is connected between the server, it show me this error:- Error Source : Microsoft OLE DB... honeybee86 via SQLMonster.com	05-16-2008 09:37 AM manu	10	43
Has SQL Server 2008 been officially released? ( 1 2 3 4 5 ... Last Page) Hi Folks, We're a shop that is required to keep our clients at n-1. So I'm wondering, and I can't find conclusive evidence, if SQL Server 2008 has... Scott H.	05-16-2008 09:29 AM Aaron Bertrand [SQL Server MVP]	56	100
Many SATA vesrus fewer SAS ( 1 2 3 4 5 ... Last Page) Hi, What would peoples preference/opinions be on using the following drive RAID combinations for a SQL 2005 install: 6 x 73G SAS 15K drives (RAID5... John Davis	05-16-2008 09:12 AM TheSQLGuru	82	135

Page 145 of 1157

145

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off