Viewing 15 posts - 7,141 through 7,155 (of 13,460 total)
relaying is prohibited.
in order to avoid spam, a mail server, by default, will not deliver to an email address outside it's own domain unless
1. the sending IP address...
July 18, 2011 at 8:00 am
the servername for the mailserver is typically mail.mycompanyname.com, but can be something different.
you can go to http://www.mxtoolbox.com to input the real domain name and find the real mail server...
July 18, 2011 at 6:52 am
I believe connecting via the DAC(
dedicated Admin Connection ) automatically decrypts encrypted procs triggers and functions to allow diagnosis of problems.
July 18, 2011 at 6:03 am
that's easy...they are ALL server versions.
if it is installed as a service, it is the server version. always, no exceptions.
the client tools don't show up as a service
If you go...
July 18, 2011 at 5:57 am
well, whether you use a datatable like that on the fly, or a strongly typed dataset, the constraints should be the same, creating a duplicate structure of what exists in...
July 15, 2011 at 9:44 am
it's not an all-in-the-db or all-in-the-application kind of thing.
it's a mixture of both doing their parts to make sure the data is good.
generally you make sure your data has constraints...
July 15, 2011 at 9:22 am
great read, thanks for bring that to our attention!
July 15, 2011 at 8:38 am
from TSQL, it's very difficult; there's no native way to get the scripts in TSQL; most people end up calling something else that calls SMO via xp_cmdshell, and brings it...
July 15, 2011 at 6:55 am
C.K.Shaiju (7/15/2011)
Here I have 15 systems which have been already installed with SQL Server. But now I have to find out which all systems are installed as CLIENT and which...
July 15, 2011 at 6:12 am
stewartc-708166 (7/15/2011)
Features Supported by the Editions of SQL Server 2008 R2
The google force is strong in this one....
July 15, 2011 at 6:00 am
not sure what you mean.... the machine with the MSSQLSERVER service is the server...but "client" software can be installed on the server or on other machines...
what , for you, do...
July 15, 2011 at 5:52 am
you have a pretty wide array of encryption choices, but as Perry Whittle mentioned, they require a schema change...you'll need to change a varchar column to varbinary, for example using...
July 15, 2011 at 5:44 am
--no transactions at all for a givien client:
SELECT * FROM clients
LEFT OUTER JOIN clienthistory
ON clients.clientID = clienthistory.clientID
WHERE clienthistory.clienthistoryID IS NULL
--the balance of all transactions is zero.
SELECT * FROM...
July 14, 2011 at 2:13 pm
you'll have to show the code that is being called to send the mail...it sounds like you might be building a string, instead of using parameters.
if you are building a...
July 14, 2011 at 12:56 pm
Viewing 15 posts - 7,141 through 7,155 (of 13,460 total)