Viewing 15 posts - 46 through 60 (of 130 total)
msimone (11/9/2011)
Hello.I don't know exactly the difference.
In a OLTP, if avg fragmentation>1, ¿rebuild or reorganize?
Suppose, that the table has 100000 pages.
Thanks for all.
In general
...
November 9, 2011 at 3:41 am
Cadavre (11/9/2011)
Hakuna Matata (11/9/2011)
I need to retrieve all the tables, stored procedure's, views, functions etc which are related to a particular field in a database.
For example if the...
November 9, 2011 at 3:25 am
Thanks a loooooot!!!!!!! John & Sridhar. I was soooo stupid to not to implement your simple idea!!:-)
November 4, 2011 at 7:33 am
I too had the same issue & I had also posted the same on SQL Central. After a weeks troubleshooting I finally had to restart the server to resolve the...
October 3, 2011 at 2:38 am
Gianluca Sartori (9/21/2011)
(: Hakuna Matata 🙂 (9/21/2011)
Can we rollback if we use truncate command??? I dont think we can rollback since truncate command does not generate any logs.
If SQL Server...
September 21, 2011 at 9:12 am
I was able to rollback a table with around 181000 records.
September 21, 2011 at 8:28 am
Can we rollback if we use truncate command??? I dont think we can rollback since truncate command does not generate any logs.
September 21, 2011 at 8:05 am
The issue has been resolved finally. I had to restart the SQL Server. Once restarted The server started sending all the mails that were in queue. Still have no clue...
September 15, 2011 at 1:37 am
The same Gmail settings worked fine on my other production server.
(: Hakuna Matata 🙂 (9/14/2011)
September 14, 2011 at 7:22 am
The IT Team confirms that we don't use Exchange Server. I tried using my Gmail Id with the following settings:
Server Name: smtp.gmail.com
port no: 587
Check : This server requires a secure...
September 14, 2011 at 7:06 am
Can restarting the SQL Server resolve my issue, Since this is a Production Server used 24/7, I am reluctant to restart the SQL Server. My other concern is what...
September 13, 2011 at 12:38 am
I restarted the Database Mail service, deleted the existing profiles & accounts and created a new profile & account. Yet I am unable to send Test Mails. In...
September 12, 2011 at 4:43 am
The mail profile has already been enabled. I
mandeep.joon (9/12/2011)
Try these thingsRight click on Sql server Agent > Properties > Now click on Enable mail profile
Click on ok.
September 12, 2011 at 2:53 am
Even after 3.5 hours , I was unable to stop the mail service. What could be the issue. Can restarting the SQL server solve this issue.
(: Hakuna Matata :)...
September 12, 2011 at 12:49 am
Tried stopping the mail service using EXECUTE msdb.dbo.sysmail_stop_sp;, Even after 1 hr the Query is executing. Unable to stop the service.
(: Hakuna Matata 🙂 (9/8/2011)
September 9, 2011 at 11:58 pm
Viewing 15 posts - 46 through 60 (of 130 total)