Forum Replies Created

Viewing 15 posts - 7,141 through 7,155 (of 13,459 total)

  • RE: Failure sending mail

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 18, 2011 at 6:52 am

    #1354202

  • RE: Display an Encripted trigger definition

    I believe connecting via the DAC(

    dedicated Admin Connection ) automatically decrypts encrypted procs triggers and functions to allow diagnosis of problems.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 18, 2011 at 6:03 am

    #1354176

  • RE: Installed SQL is Client or Server?

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 18, 2011 at 5:57 am

    #1354174

  • RE: Does SQL SERVER just be used to storage and let the application do all the work

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 15, 2011 at 9:44 am

    #1353511

  • RE: Does SQL SERVER just be used to storage and let the application do all the work

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 15, 2011 at 9:22 am

    #1353492

  • RE: Read about Stuxnet on Wired

    great read, thanks for bring that to our attention!

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 15, 2011 at 8:38 am

    #1353463

  • RE: how to export database from oracle10g to sql server2008

    http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#oracle

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 15, 2011 at 7:01 am

    #1353409

  • RE: How to generate SQL database scripts into XML file format

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 15, 2011 at 6:55 am

    #1353401

  • RE: Installed SQL is Client or Server?

    C.K.Shaiju (7/15/2011)

    Lowell,

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 15, 2011 at 6:12 am

    #1353365

  • RE: SQL Features List

    stewartc-708166 (7/15/2011)

    Features Supported by the Editions of SQL Server 2008 R2

    The google force is strong in this one....

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 15, 2011 at 6:00 am

    #1353351

  • RE: Installed SQL is Client or Server?

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 15, 2011 at 5:52 am

    #1353343

  • RE: Encrypt & decrypt coloumn

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 15, 2011 at 5:44 am

    #1353335

  • RE: find only clients with zero transactions

    --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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 14, 2011 at 2:13 pm

    #1353096

  • RE: Database Mail issue

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 14, 2011 at 12:56 pm

    #1353050

  • RE: DDL Trigger to prevent dropping of a specific table?

    upstart (7/14/2011)

    ... either covered their tracks really, really well or our default 'black box' trace for some reason did not capture anything regarding it....

    In my career I've seen mostly careless...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 14, 2011 at 12:50 pm

    #1353047

Viewing 15 posts - 7,141 through 7,155 (of 13,459 total)