Forum Replies Created

Viewing 15 posts - 6,481 through 6,495 (of 13,460 total)

  • RE: Log to find all the 'FAILED LOGIN ATTEMPTS' in SQL Server 2005

    chandraa.bollineni (11/4/2011)

    Hi,

    Thanks for your reply.

    I already checked in this way and it's already fixed those settings like both failed and successful logins.But i am not able to see what are...

    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!

    November 4, 2011 at 5:29 am

    #1403150

  • RE: How can we find a particular process id to belong which instance ?.

    would they be asking you to use a DMV like sys.dm_exec_sessionsto get the column host_process_id?

    I think that would require querying all four instances, right?

    for example, ran Windows Task Manager and...

    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!

    November 4, 2011 at 5:16 am

    #1403146

  • RE: sp_send_dbmail Message size exceeds fixed maximum message size

    Jack this was a double post;

    In another thread we tracked down the issue:

    http://www.sqlservercentral.com/Forums/FindPost1200033.aspx

    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!

    November 3, 2011 at 2:09 pm

    #1402927

  • RE: Characters in field names

    sure but you'll have to make sure you always wrap it in brackets when refering to it:

    WHERE [Fixed/Float/Step (Interest Rate Type)] = 42

    to avoid that, you want to go witht...

    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!

    November 3, 2011 at 1:38 pm

    #1402914

  • RE: Moving tables from one database to another database

    you'll want to script the table out from the source, including indexes, and create it on the destination database.

    then you can use the import/export wizard,and change the step that says...

    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!

    November 3, 2011 at 1:06 pm

    #1402892

  • RE: 10GB CSV import into SQL 2008

    sturner (11/3/2011)

    I'm not aware of any file size limitation for importing data into SQL server.

    Things you can do to make the import operation as efficient as possible:

    1) put the database...

    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!

    November 3, 2011 at 12:47 pm

    #1402877

  • RE: sp_send_dbmail Message size exceeds fixed maximum message size

    glad you got it fixed!

    sometimes the "obvious fix" for an issue is, well, not really that obvious.

    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!

    November 3, 2011 at 10:50 am

    #1402786

  • RE: sp_send_dbmail Message size exceeds fixed maximum message size

    the mail server in your databasemail profile you are using in = your Exchange Server?

    i've got several profiles set up , some with the company mails erver, some with...

    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!

    November 3, 2011 at 9:33 am

    #1402722

  • RE: sp_send_dbmail Message size exceeds fixed maximum message size

    i think the issue is related to the mails erver, and not your database configuration settings.

    Are you using your Exchange server that Outlook points to as the mail server 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!

    November 3, 2011 at 9:06 am

    #1402698

  • RE: Verify if column exists

    i usually use dynamic sql for the command, as if i'm adding a table that doesn't exist, the script will fail validation.

    IF EXISTS(SELECT 1

    ...

    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!

    November 3, 2011 at 8:42 am

    #1402674

  • RE: How do I get a MS SQL bulk insert to recognize qualified values?

    bulk insert allows you to use a format file, and the format file handles the quoted delimiters for you.

    without the format file, you end up having to handle the delimiters...

    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!

    November 3, 2011 at 7:49 am

    #1402645

  • RE: One database, copied to two identical servers. Performance bad on second server. Why?

    if there are different server versions, for example ServerA is SQL2005 but ServerB is SQL2008, you'll want to rebuild the indexes as well as rebuild the statistics for non-index columns;...

    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!

    November 3, 2011 at 6:57 am

    #1402609

  • RE: Violation of PRIMARY KEY constraint

    since you are migrating from another table, and at least one value already exists, shouldn't you be joiing on the local data to prevent the duplicates from being inserted?

    or 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!

    November 2, 2011 at 6:08 am

    #1402095

  • RE: Why bcp import a file out of order in SQL 2008?

    i may be misremembering the thread; i'm searching thru my posts now to find it; i was fiddling with trying to make an example, but the clustred index i'm creating...

    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!

    November 1, 2011 at 3:14 pm

    #1401896

  • RE: Why bcp import a file out of order in SQL 2008?

    I think Gail had posted that they are logically stored in the clustered index order, and not necessarily physically stored once you look inside a page.; there was a post...

    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!

    November 1, 2011 at 2:59 pm

    #1401886

Viewing 15 posts - 6,481 through 6,495 (of 13,460 total)