Forum Replies Created

Viewing 15 posts - 11,056 through 11,070 (of 13,460 total)

  • RE: Linked Server - Fails From Desktop, but Works Remotely

    I believe it has to do with how the linked server was set up...the default is "no security context", which is not what you want.

    go to your linked server properties;...

    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!

    May 27, 2009 at 8:51 am

    #1000693

  • RE: Very serious problem with SQL

    in this specific case, this error:

    Exception message: Column 'TFTAgentName' does not belong to table .

    seems to be pretty straight forward;

    I would guess that a SQL statement that is loading specific...

    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!

    May 27, 2009 at 6:40 am

    #1000526

  • RE: How to calculate Time field sum

    nice solution ashokdasari

    , i didn't realize the OP might still want the data in Hours and Minutes.

    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!

    May 26, 2009 at 8:57 am

    #999932

  • RE: How to calculate Time field sum

    the trick is you've got to take the minutes, i.e. "25", turn them into a decimal and divide by 60 so you get the part of an hour

    create table #Example(TimeTaken...

    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!

    May 26, 2009 at 8:51 am

    #999930

  • RE: Reading an Execution Plan for Index Suggestions

    Thanks Gail; This query is a rollup of a bunch of financial data based on it's attributes, so there's no WHERE statement in it....just a bunch of GROUP BY stuff...

    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!

    May 26, 2009 at 7:19 am

    #999875

  • RE: Database compatibility change 80 to 90

    for me, the biggest advantage for switching to compatibility 90 is the row_number() function; I've solved a couple of important SQL's with that function easier than if I had 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!

    May 25, 2009 at 8:37 am

    #999673

  • RE: Ho to retrieve column aliases for a view ?

    it took a while for this one to soak in. I read the requirement a couple of times, and kept thinking it's gotta be possible by using the stored...

    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!

    May 25, 2009 at 6:19 am

    #999636

  • RE: Connecting to SQL DB 2005

    HanShi (5/25/2009)

    SQL 2000 is not compatible with SQL 2005. Connect to the SQL 2005 instance using the SQL 2005 tools.

    the above advice is not correct. you can connect to 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!

    May 25, 2009 at 5:47 am

    #999626

  • RE: Deny the 'drop database' right to a user with dbcreator server role

    doh i'm sorry; i jumped to conclusions and thought the question was "how to assign/deny permissions to a role" ; Lemme test a couple of thoeries and i'll post 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!

    May 22, 2009 at 7:48 am

    #998861

  • RE: Deny the 'drop database' right to a user with dbcreator server role

    something like this example might help.

    I'm creating 3 roles...one that is almost-but-not-quite-admin, one for regular users, and a third to explicity deny deletion rights.

    i then assign various users to those...

    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!

    May 22, 2009 at 7:00 am

    #998832

  • RE: Index space discrepancy

    no, my point was indid=1;

    in my case the difference between the totals was 3x the number of rows, but 6 times the mb size:

    SELECT SUM([# of Pages]) as NumPages,

    Sum([# 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!

    May 21, 2009 at 2:34 pm

    #998572

  • RE: Variable columns to be returned

    dynamic results means dynamic SQL. there's no other way to do it.

    if you only have read access, you could not create a stored procedure to run dynamic sql anyway, right?

    basically,...

    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!

    May 21, 2009 at 11:56 am

    #998442

  • RE: Find All SQL Servers on a Network

    SQLRecon is a good tool that finds installs and instances, and tests them for a lot of security holes like blank passwords, etc.

    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!

    May 21, 2009 at 10:56 am

    #998406

  • RE: Index space discrepancy

    i think it's this WHERE statement:

    WHERE indid >= 2 and indid = 1 would include the clustered index of each table, and certainly makes a huge difference when i ran...

    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!

    May 21, 2009 at 10:35 am

    #998392

  • RE: Saving Text datatypes

    to add to what Greg said, SQL server keeps a pointer for each TEXT field;

    SQL server will try to store each fields data stuffed into a TEXT datatype in 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!

    May 21, 2009 at 9:58 am

    #998370

Viewing 15 posts - 11,056 through 11,070 (of 13,460 total)