Viewing 15 posts - 2,011 through 2,025 (of 6,105 total)
I wish I could, but unfortunately, since my primary duty is Directory Services administration, I can't justify it to my management. Maybe they'll do a virtual PASS like with TechEd...
June 23, 2006 at 2:53 pm
How about a solid corporate policy with enforcement? When technology doesn't provide a solution, there are always procedural controls.
June 23, 2006 at 12:50 pm
No, I believe it's been around since at least the SQL Server 7.0 days.
June 23, 2006 at 12:45 pm
Try to locate the process using sysprocesses (through Query Analyzer). See if the cpu, physical_io, and/or memusage is changing. That'll let you know if it's still working or not. It...
June 23, 2006 at 11:01 am
There are some changes to optimization plans, yes, but they are pretty specific. The list of changes:
June 23, 2006 at 10:59 am
How is overall performance on the machine locally? Is this a server operating system? If so, remember that it'll give higher priority to background operations than foreground ones (like refreshing...
June 23, 2006 at 10:54 am
Take a look at the following whitepaper for help trying to troubleshoot why this is happening:
How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888
June 23, 2006 at 10:46 am
How do you handle when the primary comes back on-line? Are changes merged back in?
You can always issue an ALTER DATABASE statement putting the database into RESTRICTED_USER mode. In this...
June 23, 2006 at 10:43 am
Speaking from a security best practice side, you always try to avoid giving permissions directly to individuals. The same is true on the maintenance side. You make the assumption, from...
June 23, 2006 at 10:38 am
Common thing that bites us all though. I can't count how many times I've been in a user database and queried a table that's only in master to get the...
June 23, 2006 at 10:34 am
With the firewalls off you should have been able to connect. Try this... create a connection in EM to <server name>,1433. That tells EM to make a connection to that...
June 23, 2006 at 8:52 am
Three part naming convention.
master.dbo.syslogins
June 23, 2006 at 8:50 am
I'll experiment over the weekend and post what I find by Monday. Even if I don't hit upon something, hopefully it'll give you some areas of where not to try....
June 23, 2006 at 8:31 am
Agreed, Mike. Jack, if you spot a problem with lack of knowledge in a forum, try and contribute. It's an excellent opportunity for you to grow in your knowledge as...
June 23, 2006 at 8:29 am
When you say port 1434, you mean udp port 1434? If so, have you opened that on your laptop? This is the catch all article for enabling SQL Server connectivity...
June 23, 2006 at 8:24 am
Viewing 15 posts - 2,011 through 2,025 (of 6,105 total)