Hi Everyone,<br /><br />I use syslogins table in master database that has user default database access .That table has user info and their default...
Hi Satya,<br /><br />Thanks for your idea, I got it to work. Here what I want to share to everyone that may be interest in.<br /><br />-- 1. On...
Hi everyone,<br /><br />I have reviewed the forum about File group restore but did not see one that address this question.<br /><br />We have test...
Hi Everyone,<br /><br />Does anyone has experience or idea on how to build query on master system table(s) to produce login access report?<br /><br...
Hi Hemant, Thanks for your reply, I appreciate it. I was thinking about log shipping before posting this question, but since all tables need to be...
Hi Everyone,<br /><br />We have database on the remote location connection on slow lines that need to be refreshed fully from local location. The...
Hi,<br /><br />Does anyone has experience on how to set SQL Profiler to run from command line, reading certain predefined template?<br /><br />I have...
Hi everyone, The DTS load that we have in our environment were running fine for more than 1.5 years, until a few months ago it starts to fail with...
Dineshasanka Thanks for your response, I appreciate it. At least I know other have use it without problem. After looking at my profile template,...
Hi SQL Gurus,<br /><br />On the SQL Profiler - Event Tab - Security Audit Object, I have already choose "Audit Login Change Password Event", run the...
Satya,<br /><br />Thanks for your response, I appreciate it very much. I turned off the log and got this data:<br />Package Steps execution...
Hi everyone! I created simple DTS package to transfer jobs from one server to another server using "Transfer Jobs Task" on DTS Designer, but when I...
Simon, Luis, I appreciate very much for the feedback. Yes, that SQL server is using local account & not the domain account for the MSSQL service....
Hi Everyone! I have one SQLserver that cannot be registered using trusted connection (Windows AD) on SQL Enterprise Manager - server registration....
Brad, Argyle, Thank you very much for the input. I appreciate it. That's make sense. Last year, when we replaced server hardware on one node , we...
Hi everyone ! Does anyone ever experience this and know how to solve it? We added new SAN drive and designated the drive letter L: The windows...
Hi everyone, On the Windows 2000 Event Viewer for Application log, it show this error message numerious times; Here Event Type:Error Event...
Thanks Satya. I appreciate for the idea. SP_UPDATE_JOBSCHEDULE works for this purpose. I can modify the query to use this sp and read a table that...
Hi Everyone!<br /><br />I have job that run on different date each month. I have "Reset_Schedule_Start_Date" stored procedure on msdb database for...
It's possible. Since it's active/active, Brad's advice is easier to follow to replace the whole cluster. Paulus
Separate names with a comma.
