Neither windows Authentication nor sysadmin is the solution. As far as I think login is failing because of SID mismatch. (To cross-verify, after the...
Moving data to another filegroup requires data movement. One method is to MERGE the partition you want to move, set the next used to the new...
I am sure this is just a test environment [;)]. Patch SQL Server with latest service pack. If, you are able to ping the machine, Try giving the ip...
The script looks fine. I don't see any reason of table not showing up. Just try to restore the full backuponly i.e. without the t-log backups nad see...
Welcome to the stressfree life of DBAs [;)]
Oops! Sorry. Missed the part that SQL Server is 32-bit. The above answer was for 64-bit OS and 64-bit SQL Server only. In WOW64, you can enable AWE...
Hello, - AWE is not needed for 64bit OS, it's only a window for 32bit OS to address more memory. - Instead, you can enable 'lock pages in memory' on...
Hello Fais, It is always good to have a backup strategy in place. I think you should have a backup strategy for this database. Secondly, is the file...
Hello Satya, I believe taking a look at the below links might help you.....
Hello Koteswar, Details of the job responsibilities should be provided to you during the initial interaction for the specified role (in case of an...
Hi All,I have seen in our environment, that whenever a patch is applied to SQL Server, the jobs having non-sa user (domain account) as owner fails....
Hey,You should be connect to SQL SERVER 2008 via SSMS 2005 if your SQL Server is at version 9.0.3228 or higher. Check the level of service pack you...
Hey,Kindly refer to the below...
Hello,One-to-One relationship can be implemented as a single table or two tables with primary and foreign key relationships.One-to-Many relationships...
Atul, I think you are concerned about the performance of updates and the role of indexes for this operation. So, as Adriaan said, this shouldn't be a...
Hello, Welcome to the Forums! [From MSDN] TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the...
Hello, Welcome to the Forums! If you are trying to create the file on the server running SQL Server then the path is OK. If you are trying to create...
:) Ya! will keep that in mind... [:)]
Oops! forgot to drop #Temp1 [:D] select * from #temp1 drop table #temp1
Separate names with a comma.
