Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Knowledge Base > SQL Server > Security & Login


Search:
What's New - What's Hot
How To Implement Proactive Caching in SQL Server Analysis Services (SSAS) 2005     
Total Hits: 409  |  Today: 0Author: Ray Barley      Rating:  
Read Reviews | Write Review |  Your Rating: 

We have chosen MOLAP storage in order to maximize the query performance of our cubes. Since we have a number of cubes we are now focused on coming up with a strategy for keeping the cubes up to date as the data in our warehouse changes frequently. Can you give us the details on how we go about implementing the Proactive Caching feature in SQL Server Analysis Services 2005?...

Authentication Methods for Connections to SQL Server in Active Server Pages     
Total Hits: 1127  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Both SQL Server authentication (standard security) and Windows NT authentication (integrated security) are SQL Server authentication methods that are used to access a SQL Server database from Active Server Pages (ASP).
...

How To Use the Analysis Services Execute DDL Task in SSIS 2005     
Total Hits: 423  |  Today: 0Author: Ray Barley      Rating:  
Read Reviews | Write Review |  Your Rating: 

We are looking to automate some tasks to be performed on our SQL Server Analysis Services Servers. Can you give us the details on how the Analysis Services Execute DDL Task can be used in a SQL Server Integration Services (SSIS) package? The Analysis Services Execute DDL Task is a very useful one, allowing you to do just about anything with a SQL Server Analysis Services instance. For example you could backup a database, process a cube, create a partition, merge partitions, etc. You specify c...

How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server     
Total Hits: 326  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to change the location of the data and log files for any SQL Server 7.0, SQL Server 2000 or SQL Server 2005 database. The steps that you must follow to change the location for some SQL Server system databases differ from the steps you must follow to change the location for user databases. These special cases are described separately....

HOWTO: SQL Server with Integrated Security, IIS on Same Machine     
Total Hits: 1241  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to set up Microsoft SQL Server using Integrated Security on the same physical machine as Microsoft Internet Information Server....

SQL Server 2005 Login Properties to Enforce Password Policies and Password Expiration     
Total Hits: 342  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

For some reason your web site is up, but none of the data is loading on your web site? Is your SQL Server up and running? Are you able to access the data with either your Windows account or sa? What does your SQL Server error log report? What is the culprit? Then the password for the login used in your web application has expired. SQL Server 2005 introduced 'Enforce password policy' and/or the 'Enforce password expiration' configurations which use the local policies for password length, com...

How to store longer SQL Agent Job Step output messages     
Total Hits: 242  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

When working with SQL Agent jobs sometimes it is difficult to determine why a job failed or even exactly what occurred. For each job step SQL Server provides a message, but it is not always that easy to determine exactly what was occurring during that step. The default message that is saved in the job history is 1024 characters. In most cases this may be enough, but if you have a long running process you may need to store more than 1024 characters. Is there any way to get additional informati...



Disclaimer - Privacy
© 2002-2017 DevASP.net