Viewing 15 posts - 526 through 540 (of 1,155 total)
Perry Whittle (9/14/2011)
sqlbuddy123 (9/13/2011)
Right, Mirrored DB is not accessible at all times.Thank You,
Best Regards,
SQLBuddy
Unless you're using...
September 14, 2011 at 6:12 pm
Something might be blocking the mail relay from this server. Check if the ports are being blocked by any antivirus software , file filters etc...
...
September 14, 2011 at 6:08 pm
How different are the servers ?
Do you have SQL Server 2000 instance ?
Thank You,
Best Regards,
SQLBuddy
September 14, 2011 at 6:05 pm
How much memory do you have on each node?
How many SQL instances running on the cluster all together ?
...
September 13, 2011 at 6:20 pm
Right, Mirrored DB is not accessible at all times.
Thank You,
Best Regards,
SQLBuddy
September 13, 2011 at 6:06 pm
Yep .. That's the new change ..
Thank You,
Best Regards,
SQLBuddy
September 13, 2011 at 6:01 pm
I don't think there is a way to prevent the logging of those events..
Thank...
September 13, 2011 at 5:58 pm
Just check with your system administrators to see if they have recently made any changes to the SMTP server or any Antivirus software is blocking the mails or ports etc..
...
September 13, 2011 at 5:56 pm
Use IPALL TCPPort.
Thank You,
Best Regards,
SQLBuddy
September 13, 2011 at 5:52 pm
I don't think there is any company out there who has courses only on Replication.
Almost all of them give a basic introduction and one or 2 simple demonstarations. To get...
September 13, 2011 at 5:50 pm
Follow Wildcats advice. You need to use ForEachLoop with variables.
Thank You,
Best Regards,
SQLBuddy
September 13, 2011 at 5:45 pm
I don't think there is a direct way to do this. Wild Cat gave good recommendation.
Sometimes SQL 2000 passwords cause lot of issues due to the Case Insensitive collations.
...
September 13, 2011 at 5:37 pm
If you want Reporting Dbs to be in R\W mode, you can't use LS or DB mirroring. You need to use Replication but the setup would be a huge task....
September 13, 2011 at 5:35 pm
Did you use the following method..
EXEC sp_dropserver '<old_name>'
GO
EXEC sp_addserver '<new_name>', 'local'
GO
To find those details run a brief profiler trace to find the machine from which it...
September 13, 2011 at 5:26 pm
This is an excellent one from Michael Campbell
WITH indexstats ([Table],[Index],[Reads],[Writes],[Rows])
AS
(
SELECT
usr.[name] + '.' + obj.[name] [Table],
ixs.[name] [Index] ,
usage.user_seeks + usage.user_scans + usage.user_lookups [Reads],
usage.[user_updates] [Writes],
(SELECT SUM(sp.[rows]) FROM sys.partitions sp WHERE usage.OBJECT_ID...
September 13, 2011 at 5:20 pm
Viewing 15 posts - 526 through 540 (of 1,155 total)