Viewing 15 posts - 781 through 795 (of 1,079 total)
yes I have.
What bothers me a bit is that you didn't provide any attempt data from your side.
This post sort of looks like you want us to do the thinking...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 8, 2010 at 11:51 pm
no need for a parameter......
just run:
EXEC sp_MSforeachdb 'USE [?] IF ''[?]'' NOT IN (''[master]'', ''[model]'', ''[msdb]'', ''[tempdb]'')
SELECT name as [?],
...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 8, 2010 at 11:36 pm
Look for anything where you will be a senior DBA's 2nd pair of hands, sort of like an internship; this way you will have a mentor, and learn more. The...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 8, 2010 at 11:32 pm
Try this:
select sys.dm_exec_sessions.session_id,sys.dm_exec_sessions.host_name,sys.dm_exec_sessions.program_name,
sys.dm_exec_sessions.client_interface_name,sys.dm_exec_sessions.login_name,
sys.dm_exec_sessions.nt_domain,sys.dm_exec_sessions.nt_user_name
,sys.dm_exec_connections.client_net_address,
sys.dm_exec_connections.local_net_address,sys.dm_exec_connections.connection_id,sys.dm_exec_connections.parent_connection_id,
sys.dm_exec_connections.most_recent_sql_handle,
(select text from master.sys.dm_exec_sql_text(sys.dm_exec_connections.most_recent_sql_handle )) as sqlscript,
(select db_name(dbid) from master.sys.dm_exec_sql_text(sys.dm_exec_connections.most_recent_sql_handle )) as databasename,
(select object_id(objectid) from master.sys.dm_exec_sql_text(sys.dm_exec_connections.most_recent_sql_handle )) as objectname
from sys.dm_exec_sessions inner join sys.dm_exec_connections
on sys.dm_exec_connections.session_id=sys.dm_exec_sessions.session_id
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 8, 2010 at 3:57 am
Linked servers are more used when you have queries running against them (instead of OPENROWSET function)
read up to get a better and more in depth answer:
http://sqlserverpedia.com/wiki/Central_Management_Server
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 7, 2010 at 11:09 pm
http://msdn.microsoft.com/en-us/library/ms143269%28SQL.90%29.aspx
This will steer you in the right direction....remember, Google and MSDN is your friend.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 30, 2010 at 11:13 pm
You are returning multiple rows for a single result value.
try with a top 1 in your select statement and see if it works.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 28, 2010 at 4:06 am
The question was:
"Which of these SQL statements is correct? Please guess error message for those stements which are wrong. (select all that apply)"
So 1st you have to select all...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 27, 2010 at 11:56 pm
SSIS could be the answer for you.
Setup a "Global" job, with connections to each instance, with a Backup step.
You can host this job on a central server.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 19, 2010 at 3:49 am
If space is an issue, you could look into shrinking, but keep Fragmentation in mind......
Leave it at 20gb, at least you know there is ample space to grow within the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 19, 2010 at 3:21 am
What are the initial sizes set of the mdf and ldf on this database?
It could be that the DB is allocated at 29gb as predefined sizes, but the actual space...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 19, 2010 at 1:43 am
2010-05-08 14:10:34.720 spid4s Server-level event notifications can not be delivered. Either Service Broker is disabled in msdb, or msdsb failed to start. Event notifications in other databases could be affected...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 19, 2010 at 12:28 am
Execution plan.......
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 18, 2010 at 2:02 am
Please provide existing code
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 14, 2010 at 4:59 am
Try XCOPY:
XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W] [/C] [/I] [/Q] [/F] [/L] [/H] [/R] [/T] [/U] [/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z] [/EXCLUDE:file1[+file2][+file3]...]...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 13, 2010 at 8:48 am
Viewing 15 posts - 781 through 795 (of 1,079 total)