Hi i see in the sql logs very often this kind of massages poping up Just like below and not sure what they meant because server or Database not...
Hi SOme one can provide advantages and disadvantages in implementing Schemas in prod environment.
Folks i was hearing timeout errors issues suddebly since one week ,but i did not find any errors in sql log these time out are kind of irregular...
Hi folksi have changed the sql server name Drop and add server script and it returns correct name when i do sp_helpserver namebut if i do @@server...
we are having some issues with one of my server.which is hosting the Named instance Connecting from workstations.to the named instance is erroring...
Yes , i have also restarted the browser service.still its not working.
i see this error in the sql logs and i cannot log on to the server using qualified name but i can log on using servername and port number and also...
uninstall and reinstall of Native client did not work for some reason , But i did it in different way . i have some changes in the registry values...
if i remove it does it fix the problem or i need to reinstall it.
I Found the below error and all my maintenance jobs were failing with the same error. Do any one have any clue on it. help is much appriciated....
Hi guys i found very funny situation when ever i run a select or update statement contaioning three involved in joining when run sp_who2 i find in...
is it required maintanence plan like Backup optimizations and dbcc checks at all? Because it stores only temp data and session informatio.
I Cannot take the database into single user mode or readonly mode. because this databases are actively used But my problem is need to figureour which...
Thanks it works.
<P mce_keep="true">Hi guys </P><P mce_keep="true">i was off way successfull in moving the SYSTEM Databases from one drive to other drive on the same...
Hi got kind of situation, we have one sql user on the database now we need to figureout who is actually using it because we plan to delete it but...
Thanks man it works.
I Found that dropping the user from database , erroring out like cannot delete the user because the objects owned by the user. i could not...
Hi Guys I Was on the Move of changing the Database collation from Windows to SQL. In that process i have found many Columns Declared column level...
Hi Guys Can some one provide the best practices to implement Partitioning in the SQL 2005. Right now in our environment we are not using it . if we...
Separate names with a comma.
