Viewing 15 posts - 8,041 through 8,055 (of 9,720 total)
If you don't need to see the messages at the time the proc is run, Insert them into some sort of log table. If you do need to see the...
April 29, 2010 at 8:47 am
Tara-1044200 (4/29/2010)
Is there any other best way to test which helps me to decide whether or not to go with the plan ?
Run PerfMon and a server-side Profiler trace on...
April 29, 2010 at 8:40 am
Bhuvnesh (4/28/2010)
chanti2985 (4/28/2010)
tlogbackup-everyday except sundayfull backup-sunday
Not an ideal Backup strategy, Include differentail back up also and change the Tlog backup frequency to One hour. Additionally read the articles related...
April 29, 2010 at 6:28 am
Are there global policy restrictions on launching applications from entry through a VPN tunnel?
Could the VPN tunnel be such a memory hog that the system doesn't have the resources to...
April 29, 2010 at 6:25 am
If you've already got the users set up in the Target server, don't worry about deleting and creating. As suggested earlier, just use sp_change_users_login and that will fix the database.
However,...
April 29, 2010 at 6:22 am
Rectify it? Why? Is it actually causing you a problem?
If so, please describe the problems it's causing. If you're just concerned because you've seen it increase memory utilization and you...
April 29, 2010 at 6:17 am
NJ-DBA (4/29/2010)
The Cluster Service should...
April 29, 2010 at 6:17 am
I'm not quite sure I understand the question, but I'll try.
If you add SQL Services to the cluster administrator tool, you should absolutely make sure they are set to restart....
April 29, 2010 at 6:07 am
I agree with thoughts that this could be a misinterpretation of the situation. If an entire database needs encrypting, my thought is that NO ONE should have access to it....
April 29, 2010 at 5:52 am
My take on this post is (s)he wants us to build the actual database.
Read Books Online. It has all sorts of useful information on how to do this task.
April 29, 2010 at 5:48 am
I'll have to check into that myself. I never bothered to look and we do need that info.
Thanks, Lynn & Grant.
April 28, 2010 at 8:35 am
Your best bet is to run a day long session of Profiler and PerfMon to identify your issues.
Or have both run sample traces every X number of minutes. But that's...
April 28, 2010 at 5:21 am
2cams (4/28/2010)
MANU-J. your query gives me NULL in all the rows listed ...
If you're getting NULLS, there's not a whole lot happening. But just an FYI, MANU-J is using an...
April 28, 2010 at 4:19 am
The maintenance plans will always look in the system tables for backup file names when cleaning up old data. The only way to delete old backups without affecting the system...
April 28, 2010 at 4:14 am
I know a SAN admin who holds on to information like a Scottish miser holds on to money. Anytime he's asked a question about setup, his first response is "Why?...
April 27, 2010 at 8:27 am
Viewing 15 posts - 8,041 through 8,055 (of 9,720 total)