Viewing 15 posts - 796 through 810 (of 1,079 total)
Which/what account are you using to run the SQL Service?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 4:30 am
1st of all, I would deny all access to a developer like this.
Even with only one connection, he can cripple the 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 12, 2010 at 8:21 am
Connect to the SSIS instance of the server, and see if the packages are stored.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 11, 2010 at 11:21 pm
Did you
Check the SQL Server error log and the Windows event logs for information about possible related problems"
???
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 11, 2010 at 11:17 pm
The DB engine and SSRS are different versions.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 11, 2010 at 11:17 pm
balaji.ganga (5/7/2010)
hi..while shrinking a database that time if kill that process.. if database is going to be crash or not..
reply pls
With Regards
BalajiG
read Gail's first answer, you asked the same 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
May 7, 2010 at 7:26 am
can you use openrowset to that 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 7, 2010 at 12:00 am
GilaMonster (5/6/2010)
Henrico Bekker (5/6/2010)
Next on your agenda I would say is to go for MVP status.
Um.....
MVP status is not something that you should be 'going for' as a career goal....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 6, 2010 at 9:23 am
Awesome, thanx ColdCoffee
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 6, 2010 at 6:36 am
It acts the same when I provide a non-existing servername, which tell's me the @servername is not actually passing its defined value?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 6, 2010 at 6:20 am
1)Is it possible to delete report server database and report server temporary databases? -
Yes, anything is possible 🙂
2)If yes, will it cause problem for me generating a report?
Yes -...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 6, 2010 at 6:01 am
Yes I have, doesn't like the '+' s
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 6, 2010 at 5:57 am
http://www.sqlservercentral.com/articles/Monitoring/monitoringdriveanddatabasefreespace/1415/
http://www.mssqltips.com/tip.asp?tip=1349
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 6, 2010 at 3:57 am
Autogrow is realtime, but specify it to grow by MB and not %, and use realistic values - which only you will know after determining the growth over a week...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 6, 2010 at 3:54 am
Set up notifications and alert?
never shrink it to a size that's less than the current size.
Read up on shrinking here for more info:
http://msdn.microsoft.com/en-us/library/aa174524%28SQL.80%29.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
May 6, 2010 at 3:51 am
Viewing 15 posts - 796 through 810 (of 1,079 total)