I am very new to performance and stuff, and we have been implementing changes (adding indices). If the SP is the same, would the proccache need clearing or would it automatically update to use the index? From http://www.developmentnow.com/g/118_2005_3_0_0_483358/DROPCLEANBUFFERSFREEPROCCACHE.htm ...more >>

We had the same issue and this is how we resoloved it : 1. Run "backup log dbname with truncate_only" 2. Do a full backup of the db 3. Start the regular transaction backup That fixed it. From http://www.developmentnow.com/g/118_2004_1_0_0_467587/transaction-log-back-up-fails-with-spid5...more >>

Thanks 4 the Nice Work! From http://www.developmentnow.com/g/118_2009_7_0_0_627483/Cant-Restore-Database-to-New-Server.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

Can you send me the file so I can take a look at it. Gr. Bjorn From http://www.developmentnow.com/g/118_2003_8_0_0_462025/Corrupted-mdf-file-.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

OK but i want to ask you -is there a place MSDTC like service on my PC?It is not a server , I m running WinXP SP3.I don't know what kind of error happened, but using of MSDN knowledge base don't help me at all.My question is :can I copy this log file from backup and replace it in C/windows/system...more >>

hi i excuted the DBCC SQLPERF(WAITSTATS) i got this msg plz do help me on cxpacket and latch_ex n how shud i remove waitstats plz gimme the discription to my mail. MISCELLANEOUS 0 0 0 LCK_M_SCH_S 1 15 0 LCK_M_SCH_M 2 0 0 LCK_M_S 38 5968 15 LCK_M_U 2 15 0 LCK_M_X 9 203 0 LCK_M_IS 1 0 ...more >>

Hiii You can edit the registry by setting this HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server If this doesn't work then uninstall application and also delete SQL entry from the registry. Then install the application. You can get this message if the installation of SQL server is not w...more >>

Hiii You can edit the registry by setting this HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server If this doesn't work then uninstall application and also delete SQL entry from the registry. Then install the application. You can get this message if the installation of SQL server is not w...more >>

Our users are getting this message when updating one particular table at the moment. Due to some hardware issues we have had to move our live database to another server. I am not sure how this was done. What would I need to look into, or query the tect support with. Thanks so much. From http://www....more >>

gfd From http://www.google.co.in/search?hl=en&q=minimum+query+plan+threshold&start=10&sa=N Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

Thanks Hari! you are my hero. I looked all over the net for getting this resolved but neither the rebuilding of my master db worked nor anything else. So i copied the old files to the actual location and the services restarted. Then I started getting the error - login failed for the user 'sa'. So I ...more >>

Hi Jim, yes, I'am familiar with this issue. Try the [url=http://www.recoverytoolbox.com/microsoft_sql_server_2005_repair_database.html] repair corrupt sql server sqlboot.dll[/url] program, it eliminates database errors automatically From http://www.google.ru/url?sa=t&source=web&ct=res&cd=5&ved=0CCI...more >>

Can you post the rest of that script Andy. What you posted appears to be incomplete. Thanks From http://www.developmentnow.com/g/118_2007_8_0_0_1011896/Convert-RTF-to-plain-text-in-sql.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

Can you post the rest of that script Andy. What you posted appears to be incomplete. Thanks From http://www.developmentnow.com/g/118_2007_8_0_0_1011896/Convert-RTF-to-plain-text-in-sql.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

Executed as user: NT AUTHORITY\SYSTEM. SQL Server blocked access to procedure 'dbo.sp_send_dbmail' of component 'Database Mail XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Database Mail XPs' by using sp...more >>

hi. m searching for mail sending from database and found that we need databasemail90.exe and few more .dll file. some search say that it will get from sql server 2005 sp2. i had download it but i cant get it. so pls tell me from where this exe file i will get. pls replay soon. thanks in advance....more >>

development From http://www.google.co.in/search?hl=en&q=100rsbusiness&meta=&aq=f&oq= Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

I got the same problem but it is BITS not starting because i was infected by a Trojan downloader http://www.viruslist.com/en/viruses/encyclopedia?virusid=21782844 Kind regards, James From http://www.developmentnow.com/g/118_2007_6_0_0_984150/Error-0X8007042B-while-restarting-SQLServer-Agent-2005...more >>

[SSIS.Pipeline] Error: component "SQL Server Destination" (118) failed the pre-execute phase and returned error code 0xC0202071. From http://www.google.cz/search?hl=cs&q=Error:+component+"SQL+Server+Destination"+(118)+failed+the+pre-execute+phase+and+returned+error+code+0xC0202071.&lr= Posted vi...more >>

How to attach a database from a network drive. From http://www.google.co.in/search?hl=en&q=sql+server+attach+database+from+network+drive&start=20&sa=N Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

I've got the same information in my logs. And I just want to now, what it means! It's in the error log, so i couldn't just ignor it. From http://www.developmentnow.com/g/118_2003_10_0_0_464808/This-instance-of-SQL-Server-has-been-using-a-process-id--.htm Posted via DevelopmentNow.com Groups ht...more >>

hi how are you? i read your message that you send me.. take care, god bless. From http://www.google.com.ph/search?hl=tl&source=hp&q=pablosteward&meta=&btnG=Hanapin+sa+Google Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

Executing the query "EXECUTE msdb.dbo.sp_notify_operator @name=N'Ron Kinney',@body=N'Backup done' " failed with the following error: "No global profile is configured. ... The package execution fa... The step failed. From http://www.google.com/search?hl=en&source=hp&q=Database+Mail+error:+"+faile...more >>

Hi Hari, Excellent work, keep it up. Great job, really great. Sweet, short, and successful example. Your solution solved my problem within no time. Thanks. Bye... From http://www.developmentnow.com/g/118_2005_10_0_0_627483/Cant-Restore-Database-to-New-Server.htm Posted via DevelopmentNow.co...more >>

Thanx very much! It's work excellent for me too! From http://www.developmentnow.com/g/118_2007_6_0_0_980365/SQL2005-no-sp-maintanance-plan-error.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

I updated the re-indentation tool. The new download can be found here: http://www.softfrontiers.com/Downloads/ReIndenter.shtml From http://www.developmentnow.com/g/118_2009_5_0_0_725837/Indentation-of-code-in-SQL-server-2005.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.co...more >>

We have sqlserver 2005. I need to find a method that I can automate to change a stored procedure and a function name, the issue is that I can not just re-create they are encrypted. Thanks in advance. From http://www.developmentnow.com/g/118_0_0_0_0_0/microsoft-public-sqlserver-server.htm Poste...more >>

The tool I spoke of is available here for free (donations accepted): http://www.softfrontiers.com/Downloads/ReIndenter.shtml Enjoy! From http://www.developmentnow.com/g/118_2009_5_0_0_725837/Indentation-of-code-in-SQL-server-2005.htm Posted via DevelopmentNow.com Groups http://www.developmentn...more >>

The server network address "TCP://KANTIME66.kantime:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418) From http://www.google.co.in/search?hl=en&client=firefox-a&channel=s&rls=org.mozilla:en-US:official&hs=Axq&q=Th...more >>

We has facing with exactly this same issue. Now this trouble is resolved : http://myitcommunity.com/cs2/blogs/cstauffer/archive/2007/10/03/sms-webreports-error-2147217392-solution.aspx Thanks a lot to Chris Stauffer From http://www.google.fr/search?hl=fr&q=sql+2147217392&btnG=Rechercher&meta=...more >>