Forum Replies Created

Viewing 15 posts - 4,066 through 4,080 (of 13,460 total)

  • RE: SQL08R2 Database Mail

    what kind of errors did you see int eh log? exact error messages help us diangnose a lot better;

    if there were no messages at all,

    i think you'll need to...

    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!

    January 30, 2013 at 1:40 pm

    #1582704

  • RE: SQL08R2 Database Mail

    check to see fi there is a specific error coming back from the SMTP server:

    it sounds like the email goes out but is never received;

    it might be no relaying allowed,...

    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!

    January 30, 2013 at 1:13 pm

    #1582697

  • RE: Insert row into linked server view

    assuming the Oracle view is updatable because it has no aggregates or calculated columns, it's exactly the same as any other insert.

    if it's not, you have to insert into the...

    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!

    January 29, 2013 at 9:57 am

    #1582240

  • RE: regular expression format supported by that CLR

    this CLR code is really nice, and something i have on my dev server:

    http://www.simple-talk.com/sql/t-sql-programming/clr-assembly-regex-functions-for-sql-server-by-example/

    for the expression itself, it looks very close to the format for an ip address;

    take a look...

    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!

    January 29, 2013 at 9:31 am

    #1582217

  • RE: Why does this not perform an index seek?

    an index seek would only occur if it was looking for one value, or a range of values that were consecutive; otherwise it has to scan the index, right?

    so WHERE...

    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!

    January 29, 2013 at 9:17 am

    #1582208

  • RE: What is the syntax for querying an oracle linked table in access 2007

    Access has linked servers?

    i think i just read your question wrong.

    If you've correctly set up an Oracle Linked server, you can first use sp_tables_ex MyOracle and you should see 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!

    January 29, 2013 at 9:08 am

    #1582198

  • RE: Are the posted questions getting worse?

    someone else does the same crap for anything barcode related because he made some plug in he's selling; annoying, to say the least, I agree.

    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!

    January 29, 2013 at 8:27 am

    #1582167

  • RE: Can I purge data on the principal without the purging it on the mirror?

    not with a mirror; the mirror is a read only copy of whatever is in production, right?

    It's been a while since i did this, but i think you...

    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!

    January 29, 2013 at 7:27 am

    #1582132

  • RE: combining outfrom sp_who2 and sysprocesses

    ok here's one way to do it with SQL2000:

    declare @sql_handle-2 binary(20),@spid smallint;

    declare c1 cursor for select sql_handle,spid from master..sysprocesses where spid >50;

    open c1;

    fetch next from c1 into @sql_handle-2,@spid;

    while (@@FETCH_STATUS...

    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!

    January 29, 2013 at 6:47 am

    #1582107

  • RE: combining outfrom sp_who2 and sysprocesses

    wow SQL 2000;

    edit : whoops this is clearly for 2005 or above; let me look again in my snippets; i know i have something

    I have this proc saved 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!

    January 29, 2013 at 6:32 am

    #1582093

  • RE: export/import error

    the error "identifier too long" is probably because a column name is longer than 30 characters, which is the Oracle size limit on object names.

    review the table you are trying...

    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!

    January 28, 2013 at 2:03 pm

    #1581808

  • RE: T-SQL, SELECT 10TH AND 11TH HIGHEST SALARY EMPLOYEES FROM EMPLOYEE TABLE

    you can also do it SQL2000 style(before the wonderful row_number/ranking functions came out) , using nested TOP statements to get the top 11, and then the top 2 of...

    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!

    January 28, 2013 at 2:00 pm

    #1581805

  • RE: Script "Create Table" script from Linked Server

    you can get a pretty good copy of the table , which would not have the any foreign key constraints, by doing something with the INTO statement:

    SELECT *

    INTO MyNewTable

    FROM MyLinkedServer.DatabaseName.dbo.TargetTable

    WHERE...

    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!

    January 28, 2013 at 1:47 pm

    #1581798

  • RE: SQL Server 2012 Insane Licensing Price!

    I Am probably reading this wrong:, but since I never stay at a Holiday Inn Express, I don't have the required Expertise:

    http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx

    but i don't see a # of connections...

    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!

    January 28, 2013 at 12:14 pm

    #1581767

  • RE: SQL Connection memory usage is growing steadily

    that is by design, and the normal behaviour for SQL server:

    SQL tries to keep everything in memory to support subsequent queries. if you leave an installation at it's default settings(2...

    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!

    January 28, 2013 at 10:59 am

    #1581736

Viewing 15 posts - 4,066 through 4,080 (of 13,460 total)