I agree..Does the DTA create any temporary kind of indexes and drops during the analysis process.
We have observerd that the view which is used to take few sec was running longer, So I've used the option of Analyze this query using the database...
Hope it will clear all your doubts.. http://msdn.microsoft.com/en-us/library/ms143706(SQL.90).aspx#runtime_installing
look for login mode key in the registry and change the value to 2 that will change the authentication mode to mixed. then restart the sql services...
Hi Better option is script out the users,roles and permissions of dev database and refresh the database using the production backup then reapply the...
It shoud have the tables in standby, Is your DR database sync with Production Database. Please check the restorehistory on msdb not only restore job...
I have not been able to find the functionality to script user's role membership for databases in SQL 2005. In SQL 2000, I could right click on a...
I'm using my account to install sql 2008,I'm having admin rights on the system, But still the installation fails
To be exact this is the info i get when i click help on the error details Details Product:SQL Server ID:15007 Source:MSSQLServer Version:8.0...
Do you mean Windows XP SP3? But, Requiremnts says Windows XP SP2 itself enough for installing SQL 2008
I've am trying to install SQL 2008 Dev Edition on my Windows XP SP2 PC, But intallation always failing with the below error, '' is not a valid login...
Satya, Thanks, I think i have not expressed my problem correctly, I am doing the Daily restore of full db backup to test box with Different db...
Guys, I have db called 'Blue' in Prod system and doing the restore of the backup taken at Prod System to test box as 'BlueLoad',Is there any way i...
It should work, Have you tried correctly, Here is the example setuser 'dbw' -----Where dbw is the username Select user_name() --- This will display...
No, you can't...You shd add the user after each restore
Check the system table restorehistory on msdb database
Hi, Why you can't try the View definition permission.
SELECT 'DROP DATABASE'+SPACE(1)+name from sysdatabases where dbid>4 , Run this and it will produce the script to drop all the user db's. Then u need...
Do you have Scheuled restore of the database from any other environment..
Hi , I will usually follow this , check the access by impersonating the user using 'SETUSER <<username>>' then try to do the operations and see it...
Separate names with a comma.
