Viewing 15 posts - 946 through 960 (of 1,079 total)
Can you access remote folders on that server via windows Server? \\servername\foldername?
Is you app (sam) looking for an IP or hostname? Is the named pipes configured on the hosting sql...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 18, 2010 at 3:57 am
any errors in SQL Logs?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 17, 2010 at 10:36 pm
muthukkumaran (2/16/2010)
sanketahir1985 (2/16/2010)
try sp_who4 active SPWhat is sp_who4 ?:-)
I also want to know?
upgrade on sp_who3? which is an upgrade on sp_who2?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 16, 2010 at 6:07 am
Sy-1148362 (2/16/2010)
Thanks for your response.Could you please elaborate on creating reports.
Create a SQL rdl report, where you can specify a more clean version of these sp's to return data in...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 16, 2010 at 2:09 am
These should get you started and on the right track.
Ever thought about building a report?
Use master
Select @@VERSION
exec sp_helpDB
exec sp_helpuser
exec xp_fixeddrives
Use msdb
exec sp_help_jobhistory
exec sp_monitor
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 16, 2010 at 1:04 am
64 bit SQL will automatically see and possibly use all memory on the host.
The AWE can be enabled on 64bit SQL when you need pages to be locked in memory.
32...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 11, 2010 at 5:04 am
How much memory do you need SQL to allocate?
How much memory is installed on your server?
Which version of SQL are you running? 2005, 2008? Express, Standard, Enterprise?
Need more info...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 11, 2010 at 1:19 am
I used the MS Press book for 70-432, and must say it was very helpfull, thats why I'd prefer another MSP book for future exams.
Will have a look at...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 9, 2010 at 12:32 am
Gail, Steve, taken from the MS site on 70-450...
Microsoft E-Learning
There is no Microsoft E-Learning training currently available.
Microsoft Press Books
There are no Microsoft Press books currently available...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 8, 2010 at 11:21 pm
http://msdn.microsoft.com/en-us/library/ms186358.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 1, 2010 at 12:06 am
Depends on the field of interest...
see: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 31, 2010 at 11:42 pm
Try a Copy Column task, or T-SQL Select into statement.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 31, 2010 at 10:16 pm
Personally I think 2gb RAM for SQL and an OS is a bit too little.
Did you specify the amount of RAM available to SQL?
You'll have to do a series of...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 31, 2010 at 10:14 pm
not quite sure, but tried it on 3 different servers, each with a different version, and all returned 1 and 1.
not getting the 0 and 1 as indicated as 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
January 28, 2010 at 9:27 pm
I am sorry, but that question simply cannot be answered straight forward here, as I have no idea what setup you are running, what connectivity type is used, how many...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 24, 2010 at 11:19 pm
Viewing 15 posts - 946 through 960 (of 1,079 total)