Viewing 15 posts - 76 through 90 (of 109 total)
Thanks for your suggestion, we will test the plan before go migration.
But as i know, the user account is old in reporting if we doesn't change them to new...
May 23, 2011 at 3:31 am
We have a old domain A and would like to create a new domain B. Then all servers and users will be migrate to domain B.
In this way, we need...
May 23, 2011 at 3:11 am
Thanks Ramdas Baghel. But how about the old domain users? When move to new domain, the user should be changed to new domain user, how to do this?
May 23, 2011 at 3:04 am
Yes, i was able to see the database id, the spid involved, the exact resources at the source of the deadlock, but i only found SQL statement "FETCH API_CURSOR0000000000001AEC". ...
May 5, 2011 at 7:09 pm
Use grants command to grant permissions on a securable to a principal.
Also you could use view to query the column you need and grant the user permission to query...
May 3, 2011 at 1:36 am
No, SQL Server need LDF file. The .ldf file stores the transaction log information used to recover data in disaster recovery scenarios.
May 3, 2011 at 1:31 am
As i know, MS suggest the SQL Server agent service should run as a member of sysadmin fixed server roles. But i made some testing, even without sysadmin right, the...
May 3, 2011 at 1:17 am
The Database Engine chooses the size of the virtual log file dynamically when log files are created or extended, so you should not able to manully modify virtual log file...
May 3, 2011 at 1:10 am
I know SQL Server provide TRY...CATCH which implements error handling for Transact-SQL. Does it help?
May 3, 2011 at 1:04 am
It is 64 bit version and not confiure max server memory. I suspect it is a internal memory pressure issue, not sure whether configure max server memory could fix this.
March 20, 2011 at 8:29 pm
I know it is not recommened to add SQL Server servcie account as local administratror. This is only to validate whether you got permission issue. If you could restart the...
February 25, 2011 at 6:08 pm
I suspect the dll file has problem. You can try to backup this 'xpstar90.dll' and copy a new one from other server then register it. After that reboot the server...
February 25, 2011 at 2:20 am
I suspect the eventID is created by someone. You check whether the Event ID is there by running following code:
SELECT * FROM sis.message WHERE message_id ='1073742657'
The new Message...
February 25, 2011 at 2:12 am
Could you try to add the SQL Server servcie account to local administrator group and try again. I susepct it is permission issue.
February 25, 2011 at 2:03 am
Viewing 15 posts - 76 through 90 (of 109 total)