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 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...
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...
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...
Hi Everyone! I have one SQLserver that cannot be registered using trusted connection (Windows AD) on SQL Enterprise Manager - server registration....
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...
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...
Hi everyone,<br /><br />Does anyone notice on enterprise manager, when starting the schedule job by right click the job - start job, sometimes the...
Hi Everyone,<br /><br />Does anyone know TSQL syntax on how to move database files from primary filegroup to secondary filegroups? The book online...
Dear SQL Gurus,<br /><br />Does anyone know article(s) on the web, or have experience before in replacing server hardware in primary node of SQL...
Dear SQL experts,<br /><br />One of the SQL servers that I monitor on the same environment, periodically given this message on the server log, while...
Dear SQL gurus, Does any one have idea or comment on how to suspend the scheduled task for a specific days. In our environment, we would like to...
Dear SQL guru, Does anyone have an idea or ever write a script that can feed the result of sp_spaceused of all databases from all servers to a...
Dear SQL gurus,<br /><br />Most people I know, that use this stored procedure feel uncomfortable with the<br />result. They said the result of...
Dear SQL Guru,<br />><br />> I ran DBCC DBReindex on all objects (indexes and tables) several times in<br />> one particular database, and...
Separate names with a comma.
