Viewing 15 posts - 2,041 through 2,055 (of 2,387 total)
Here is an example.
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINNT
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINNT="Microsoft Windows 2000 Advanced Server (3GB)" /3GB /fastdetect
April 10, 2003 at 7:18 am
Is MSDE in this developer's machine. If not, you can't use SQL2KDeskSP3.exe to update the client tools. Instead, you have to use SQL2KSP3.exe to do it.
April 10, 2003 at 7:05 am
Jeff is right. You have to add the logical disks name of physical RAID5 and RAID1 to SQL Server cluster group before you can use them.
April 10, 2003 at 7:02 am
It shouldn't take that long. Run sp_who2 active to see are there any blocking and whether this backup process is runnable status. And you may try "backup log pubs to...
April 9, 2003 at 1:27 pm
You may try to run DBCC CHECKDB with 'REPAIR_ALLOW_DATA_LOSS' option to see whether you can fix it. But as system objects seems damaged, you better have full database backup ready...
April 9, 2003 at 1:22 pm
As you already know, SQL Server standard edition can't use more than 2GB memory. But I am thinking your problem may not be just the shortage of memory that you...
April 9, 2003 at 11:55 am
As racosta already explained, the fress spaces can be used by any objects. If your database does not have sufficient spaces when you insert data or create new tables, the...
April 9, 2003 at 9:58 am
Run sp_spaceused @updateusage = true before and after the deletion and you will see the difference (unused pages) in your database.
April 9, 2003 at 9:46 am
I have seen same issue but no ideas why it works in this way. You don't have to give everyone 'sa' to run query against it. Instead, create a generic...
April 9, 2003 at 7:47 am
Each job created by maintenance plan has planid attached and you can't simply script it, transfer and run it in another server.
Maybe you could try Profiler to trace the exact...
April 9, 2003 at 7:34 am
How much avaiable memory did you have at time your job failed? Which version SQL Server you are ruuning?
In order to allocate memory than 2GB to SQL Server, you have...
April 9, 2003 at 7:21 am
Are you able to start SQL Server and Agent services after master database restoration completion? Try to login SQL Server with EM or ISQL to verfiy following.
1. Your SQL Server...
April 7, 2003 at 3:10 pm
After linked server setup and table PPC_2lists created, you can use
insert into dplads01.earthlink.dbo.PPC_2lists
select * from dplads03.peoplepc.dbo.PPCMP200302
where list in ('0099', '0157')
April 7, 2003 at 1:41 pm
Run Client network utility in Server 1 to create server alias to Server 2 first and create linked server in server 1 with the alias to link to server 2....
April 7, 2003 at 12:52 pm
Viewing 15 posts - 2,041 through 2,055 (of 2,387 total)