Viewing 15 posts - 2,671 through 2,685 (of 6,104 total)
Do you mean at the OS level?
K. Brian Kelley
@kbriankelley
Excellent review, Jeremy. I would have to agree on attempting to use it on production databases with the other posters (albeit with caution). If source control works the way it...
K. Brian Kelley
@kbriankelley
You can certainly remove the shortcut from the Start menu. Also, you could remove the files from wherever BOL installed. The default is the C:\Program Files\Microsoft SQL Server\80\Tools\Books directory. Keep...
K. Brian Kelley
@kbriankelley
True, but a justification can be made that Books Online can be accessed, even in IE enhanced security mode on Windows Server 2003 by dropping msdn.microsoft.com in as an approved...
K. Brian Kelley
@kbriankelley
Ultimately this is a business decision your organization is going to have to make. It's not hard to modify the stored procedure and have it refer to a second stored...
K. Brian Kelley
@kbriankelley
When you're able to upgrade to SQL Server 2005, you'll find you can get granular with the permissions and create the mix that you want. Ability to create a login,...
K. Brian Kelley
@kbriankelley
Check the event logs in Windows. The application and system event logs may give you an idea of why SQL Server went down if it wasn't a person doing it....
K. Brian Kelley
@kbriankelley
It's not a documentation thing... it's the fact that Books Online uses Windows Help and is a known target... typically in a certain location (default of C:\Program Files\Microsoft SQL Server\80\Tools\Books...
K. Brian Kelley
@kbriankelley
We're also heavily using SQL Server on VM in non-production. We've gone with ESX Server. It's substantially more efficient than GSX Server on Windows based on how it's architected (as...
K. Brian Kelley
@kbriankelley
Take a look at:
SSC.com Article: Oracle Link by Adrian Small
He worked through the errors he was receiving making a linked server connection to Oracle and that error you cite...
K. Brian Kelley
@kbriankelley
Write a select statement pulling back the metadata to do most of the work for you and execute it in QA:
SELECT COLUMN_NAME + '1, ' FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = '<Your table...
K. Brian Kelley
@kbriankelley
Viewing 15 posts - 2,671 through 2,685 (of 6,104 total)