Viewing 15 posts - 136 through 150 (of 1,165 total)
Are you using CTP version of SQL server?
March 19, 2007 at 1:27 pm
Try running rebuilding the indexes using DBCC DBREINDEX or ALTER INDEX commands and see what will you get?
You may need to apply the sp2 hotfix (3152) if you are using MPs...
March 19, 2007 at 1:25 pm
To understand sql memory architecture...
March 19, 2007 at 1:15 pm
Did you install DTS addins (SQLServer2005_DTS.msi) for sql server 2005?
March 19, 2007 at 1:07 pm
Try the following...
SELECT l.LocationID, l.Title FROM tblLocations l
join tblContact c on l.LocationId = c.LocationId
join tblSpecialities s on s.SpecialityId = c.SpecialityId
where s.SpecialityID = @SpecialityID
March 18, 2007 at 7:46 pm
Is backup location is local?
Under what account sql agent service is running?
I think You should be sysadmin on both servers to configure log shipping...
You have to have read/write permission...
March 18, 2007 at 7:41 pm
In sql 2005 EE you can configure oracle as publisher...
See BOL topic "Configuring an Oracle Publisher "
March 17, 2007 at 9:49 pm
Looks like you are reading encrypted data.
Can you query the data through Query Window?
March 17, 2007 at 9:43 pm
Are you looking for sp_addextendedproperty procedure?
March 17, 2007 at 6:47 pm
select
name, collation_name from master.sys.databases
select
object_name(id
March 17, 2007 at 6:44 pm
Read BOL topic "Using the REPLACE Option" for complete details...
March 17, 2007 at 6:35 pm
Check for Peer to peer replication...
Peer-to-Peer Transactional Replication in SQL Server 2005
http://www.sql-server-performance.com/da_peer-to-peer_replication.asp
http://www.microsoft.com/technet/technetmag/issues/2006/07/InsideMSFT/
March 17, 2007 at 6:25 pm
Partitioned Tables and Indexes in SQL Server 2005
http://msdn2.microsoft.com/en-us/library/ms345146.aspx
Exploring Table and Index Partitioning in SQL Server 2005
http://www.sqljunkies.com/article/f4920050-6c63-4109-93ff-c2b7eb0a5835.scuk
March 17, 2007 at 6:22 pm
What level of access to do you have on this ser ver?
March 17, 2007 at 6:19 pm
You can use DBCC CHECKTABLE also in place of CHECKDB....
You can also restore the backup of current msdb on to deve server and repair it then take the backup and...
March 16, 2007 at 6:20 pm
Viewing 15 posts - 136 through 150 (of 1,165 total)