Viewing 15 posts - 781 through 795 (of 972 total)
Can you perform the task within SQL Server and not with the 3rd party tool (Lite Speed)?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
March 9, 2010 at 9:46 am
Saravanan_tvr (2/27/2010)
Here i tried some configurtions nothing is happening..like db optimize, index,shrink etc...
Navision has it's on "internal" indexes that it uses as well so you might need to do some...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
March 3, 2010 at 8:18 am
There some good information on Christian Bolt's blog post about memory issues.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
March 1, 2010 at 10:51 am
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 26, 2010 at 10:59 am
You have to CREATE LOGIN first, then CREATE USER. If a LOGIN does not exist for the user in the database it will never be able to login to...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 26, 2010 at 10:56 am
MarvinTheAndriod (2/26/2010)
This is not an option at my company (politics)
Is what you wanting want to do with the SQL Policy in there as a company policy or standard?
If it is,...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 26, 2010 at 10:20 am
SQLDraggon's suggestion sounds good, and more controllable.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 26, 2010 at 9:36 am
It is probably not allowed mode with the facet, according to TechNet
Allowed Evaluation Modes
The policy evaluation modes are determined by the characteristics of the Policy-Based Management facet that is...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 26, 2010 at 9:31 am
MarvinTheAndriod (2/26/2010)
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 26, 2010 at 8:28 am
david.holley (2/24/2010)
Q: Which is preferred Windows Authentication or Windows/SQLServer (mixed)?(Even temporarily 6mos - 1 year)
Windows Authentication is Microsofts answer...and mine.
david.holley (2/24/2010)
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 25, 2010 at 10:26 am
If it is due to database being restored you can check the restore history of the databases by querying the msdb system tables.
Thomas LaRock put an article on mssqltips.com that...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 25, 2010 at 6:48 am
steve.neumann (2/17/2010)
..."because they deal with physical inventory, there don't subtely "....do you ever proofread or spellcheck what you write?
I would agree with Steve...every post you have made on this forum...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 17, 2010 at 7:03 am
http://msdn.microsoft.com/en-us/library/ms186858(SQL.90).aspx
Section that is titled "Permissions" has your information
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 11, 2010 at 9:35 am
I would agree with AndrewSQLDBA. SQL Server 2008 installation has many places to change the "default" file locations of everything. If you are installing more than the just...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 9, 2010 at 7:50 pm
For those interested I came across this program from PrepMasters:
http://www.prepmasters.com/mct.php
Which also states they have an online program that you can go through that they state: "The Online Train-the-Trainer class is...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 9, 2010 at 1:17 pm
Viewing 15 posts - 781 through 795 (of 972 total)