Forum Replies Created

Viewing 15 posts - 13,006 through 13,020 (of 13,460 total)

  • RE: Windows Permissions

    our shop thinks of DBA's as two different categories....there's development DBA's, which only need access to the databases in order to create schemas, write procs,review other developers code, etc.. That role...

    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, 2006 at 7:30 am

    #649774

  • RE: Collation problem with "like"

    when you changed your database collation, did you change all the existing columns too?

    a temp solution would be like this:

    select * from gmact where actnbr like '120%' collate Sql_Latin1_General_CP1253_greek_CI_AS

     

    a permenant...

    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, 2006 at 7:03 am

    #649767

  • RE: Fil generation on different location using SP

    in order to do that, the account used to run SQL server would need to have network rights...so instead of the default of running as system, it would 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!

    July 18, 2006 at 6:50 am

    #649765

  • RE: Start a Notification Service

    i looked in google groups and everyone who responded witht eh same error had instaleld the free copy, and then the production copy, which was technically a different version:

    http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/cc9c2343aa5bdfee/bf12353373a242e4?lnk=st&q=The+Notification+Services+instance+encountered+an+error+in+one+of+its+components+and+must+stop.&rnum=1&hl=en#bf12353373a242e4

     

    sounds...

    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 17, 2006 at 3:09 pm

    #649685

  • RE: how to avoid use of index in query???

    post the query; most likely we can help tune it ; most likely the WHERE clause can be tuned to use SARG-able arguments, which will then use the proper indexes...

    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 17, 2006 at 2:14 pm

    #649673

  • RE: Insufficient space on disk to create database

    If you create an empty database, but make the space allocated 10 GIG, you'll need 10 GIG to restore that backup, even though the database might be empty, or much...

    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 12, 2006 at 3:14 pm

    #648834

  • RE: Decimal/float/etc.

    nice, concise example to show someone why float is not a good solution for moeny. Thanks!

    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 12, 2006 at 7:08 am

    #648698

  • RE: How create a file for index

    after you've created your new filegroup, this script might help: it writes the sql statements you could use to move some of your indexes; i've used it just for regular...

    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!

    June 30, 2006 at 8:02 am

    #646980

  • RE: Sloooooow stored procedure

    wouldn't the sp need to be recompiled after the table is truncated, as the previous executtion plan would probably be invalid? i would think the proc is slow because 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!

    June 29, 2006 at 6:06 am

    #646642

  • RE: Server and Database Collation Questions

    here's a script i've used to generate the SQLs needed to change collation of a database for the existing items alzdba mentioned above;

    I wouldn't try to modify this to fiddle...

    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!

    June 29, 2006 at 5:49 am

    #646634

  • RE: Capturing text of result messages

    you should change your design a bit;

    your update trigger should populate a table of emails to be sent, and a job that runs every minute or five minutes or whatever...

    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!

    June 14, 2006 at 1:10 pm

    #643780

  • RE: linked server - SQL7 -> Oracle10 ?

    i believe the issue is related to the way oracle 10 handles BLOB and CLOB columns;

    if we don't use the updated drivers that are part of the Ora10 client install,...

    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!

    June 9, 2006 at 11:06 am

    #642858

  • RE: buffer latch type 2 error for spid115

    this might be of some help; what SP is on your i searched the KB and found something that references the dccc shrink command on a win2K SP2; fixed...

    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!

    June 9, 2006 at 9:18 am

    #642832

  • RE: how to parse a T-SQL script to get the tables touched by the query?

    I like David McFarlands idea; just looping thru the text of the view/stored proc/whatever object, looking for specific strings is MUCH better than trying to write a dynamic string reader 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!

    June 9, 2006 at 9:04 am

    #642827

  • RE: how to parse a T-SQL script to get the tables touched by the query?

    and comma delimited list after the FROM in case the older style join structure is used: FROM TABLE1,TABLE2 , TABLE3

    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!

    June 9, 2006 at 6:06 am

    #642755

Viewing 15 posts - 13,006 through 13,020 (of 13,460 total)