Viewing 15 posts - 1,606 through 1,620 (of 2,462 total)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 14, 2010 at 5:39 am
If you still find some issue post exec plan along with table defintion and index definition
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 14, 2010 at 5:00 am
Dont cross post
please put reply on it http://www.sqlservercentral.com/Forums/Topic936388-360-1.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 😀
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 11, 2010 at 7:32 am
if possible restart sql server agent
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 11, 2010 at 6:12 am
Any actitvity like patch or SP applied recently on that server ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 11, 2010 at 4:54 am
Match the column's datatype in both destination and source tables
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 11, 2010 at 4:45 am
Viewing 15 posts - 1,606 through 1,620 (of 2,462 total)