Viewing 15 posts - 1,606 through 1,620 (of 2,463 total)
below is the sql code that can help you
EXEC msdb.dbo.sp_send_dbmail
@profile_name = @profile_name ,
@recipients = @recipients,
@copy_recipients = @copy_recipients,
@subject = @subject,
@body = @body,
@body_format = 'TEXT',
@query =...
June 14, 2010 at 6:47 am
Hi why cant you use sp_send_dbmail ? anyeways i dont have good hand on
sp_OASetProperty
See if this link can help you http://www.lazydba.com/sql/1__26049.html
June 14, 2010 at 5:39 am
If you still find some issue post exec plan along with table defintion and index definition
June 14, 2010 at 5:01 am
PradeepVallabh (6/11/2010)
Is it safe to include all of the selected columns into "Included columns" list???
Best answer would be "Test it" and as previous post told that "it depends" so...
June 14, 2010 at 5:00 am
Dont cross post
please put reply on it http://www.sqlservercentral.com/Forums/Topic936388-360-1.aspx
June 14, 2010 at 4:58 am
samiam914 (6/13/2010)
Is it necessary for me to change the sa password?What sort of problems are expected if I do not change or do change.
It is not necessary but...
June 14, 2010 at 4:43 am
For fragmentation you can use dm_db_index_physical_stats DMV ( google it for more description).
and for sending mail use sp_send_dbmail ( again same suggestion......google it ). and after that you are...
June 14, 2010 at 4:36 am
extremenovice (6/11/2010)
I can do that, but, what benefits will restarting the sql agent have on connections to that server? TIA
Sometimes trust your heart rather than Sql server 😀
June 13, 2010 at 9:43 pm
from below link, i learnt that first we need to update concerned (NULLABLE) columns ( with any dummy values) then we can change them to NOT NULL.
though i...
June 11, 2010 at 7:32 am
if possible restart sql server agent
June 11, 2010 at 7:22 am
Mike01 (6/11/2010)
you shouldn't have to select it. It's an output parameter
oh my bad i just overlooked into it.
June 11, 2010 at 7:21 am
After reading your post i have impression that you are not a DBA. then my suggestion would be hire a professional , dont play with security section directly on production...
June 11, 2010 at 6:28 am
reefshark (6/10/2010)
CREATE PROCEDURE [dbo].[usp_GetDecryptedVal]@EncryptedVal varbinary (256),
@DecryptedVal varbinary (256) OUTPUT
WITH EXECUTE AS OWNER
AS
OPEN SYMMETRIC KEY keyname
DECRYPTION BY CERTIFICATE certname
SET @DecryptedVal = DecryptByKey(@EncryptedVal);
CLOSE SYMMETRIC KEY keyname
you are only setting the...
June 11, 2010 at 6:12 am
Any actitvity like patch or SP applied recently on that server ?
June 11, 2010 at 6:09 am
your question is so wide there is no precise answer for this
Anyways refer these links
http://www.sqlservercentral.com/articles/Administration/sql_server_security/578/
http://www.sqlservercentral.com/articles/Administration/sqlserversecuritypart3/615/
http://www.sqlservercentral.com/articles/Administration/securitypart2/593/
June 11, 2010 at 4:54 am
Viewing 15 posts - 1,606 through 1,620 (of 2,463 total)