Viewing 15 posts - 256 through 270 (of 2,387 total)
sp_helpsort
Or
check database property using EM.
August 19, 2004 at 8:16 am
Any hardware issues in your destination server? How do you do the backup, ie with maintenance wizard or T-SQL statement?
August 19, 2004 at 7:30 am
Script the SQL Server database, Recreate it by upgrading Access database using Access upsizing wizard to move the Access database including data to SQL Server and reapply the changes from...
August 19, 2004 at 7:19 am
Did it happen only to Windows 2003? Do you use local system account or domain account to run SQL Server services? Is login BUILTIN\Aministrators in those SQL Servers?
August 18, 2004 at 7:30 am
Trt select * from dbo.syscolumn
Is your SQL Server be setup as case sensitive?
August 18, 2004 at 7:08 am
Sounds like you doesn't need 820GB spaces. I would go to separtate the transaction log with two disk mirrored and create RAID 10 array for database files with the...
August 17, 2004 at 7:18 pm
RAID 5 seems the only option.
August 17, 2004 at 7:12 pm
A connection pool is a set of SQL Server connections maintained by ADO/ ADO.NET and is used to communicate with SQL Server. In SQL Server side, TCP/IP has to be...
August 17, 2004 at 2:37 pm
Contact Microsoft to get the fix. It should be free of charge.
http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&Product=sql2k
August 17, 2004 at 2:11 pm
What is your SQL Server build number? can you post the result of select @@version?
Your SQL Server has to be at least in build 780.
August 17, 2004 at 1:51 pm
How much physical memory each server has?
August 17, 2004 at 1:49 pm
select object_name(parent_obj) as tablename, name, xtype, crdate
from sysobjects
where xtype in ('C ','PK','UQ','F ', 'D ')
order by tablename
August 17, 2004 at 10:05 am
Upgrade may not be a big deal but you need to pay more attention to the database/application perrformance after the upgrade.
August 17, 2004 at 9:58 am
Viewing 15 posts - 256 through 270 (of 2,387 total)