Forum Replies Created

Viewing 15 posts - 7,996 through 8,010 (of 13,460 total)

  • RE: fn_trace_gettable Permissions Issue

    SQLRandall did this idea work for you? I'm using a derivation of this technique to create a trace on the startup/restart of the server; i add a DML trace, 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!

    March 4, 2011 at 9:25 am

    #1294743

  • RE: How to add email address in a t sql code

    if we are going to help with syntax, you have to paste the entire script you are trying to use.

    remember we are not standing in your cubicle looking over your...

    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!

    March 4, 2011 at 8:38 am

    #1294706

  • RE: Update a Column that Exists in Any Table

    what you would need is just a variation of the above example, but with the three foreign key columns involved; can you paste the definition of the primary key/unique constraint...

    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!

    March 4, 2011 at 8:05 am

    #1294687

  • RE: How to add email address in a t sql code

    SKYBVI (3/4/2011)

    Also, i want the results in body , not in as an attachment.

    Thanks.

    Regards,

    Sushant

    please try both code snippets i pasted; one does exactly what you are asking by putting 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!

    March 4, 2011 at 7:50 am

    #1294673

  • RE: How to add email address in a t sql code

    the code i posted above has both examples: pasting the results of a SQL inline the html body, or as an attachment.

    take a look at the lower example i pasted,...

    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!

    March 4, 2011 at 7:29 am

    #1294653

  • RE: Ignore an error in a trigger

    my recommendation is to simply fix the trigger so you don't have to work around your errors; we can certainly help and offer advice and testable scripted solutions.

    paste the trigger...

    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!

    March 4, 2011 at 7:14 am

    #1294644

  • RE: Update a Column that Exists in Any Table

    well it sounds like th trm_cde is a lookup value, correct?

    so that table which contains all the possible trm_cde would have foreign keys from those 80 other tables, right?

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

    March 4, 2011 at 7:11 am

    #1294641

  • RE: How to ping a SQL Server datbase?

    LutzM (3/3/2011)

    Duplicate post. No replies please.

    Original post can be found here

    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!

    March 3, 2011 at 2:50 pm

    #1294361

  • RE: How to ping a SQL Server datbase?

    theres an application out there called What's Up!, which does what you are asking for...tests servers and services on those servers, and notifies people if anything goes down.

    last i heard...

    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!

    March 3, 2011 at 2:45 pm

    #1294357

  • RE: fn_trace_gettable Permissions Issue

    ok, still not an issue; read the file from the database, and recreate the view as needed:

    --we want the current trace folder

    declare...

    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!

    March 3, 2011 at 2:43 pm

    #1294356

  • RE: fn_trace_gettable Permissions Issue

    what i would suggest do is on the server itself, create a VIEW that selects the data from the trace; the view would run under the context of the owner...

    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!

    March 3, 2011 at 1:08 pm

    #1294295

  • RE: how to change the default DB Name while transferring LOGINS

    why cant you just use find and replace in a text editor or SSMS before you run the command? there cannot be that many defaults you have to change; just...

    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!

    March 3, 2011 at 12:34 pm

    #1294252

  • RE: diffrence between nolock with braces and without braces

    opc.three (3/3/2011)

    Just FYI using NOLOCK in an UPDATE or DELETE statement has been marked as deprecated in SQL 11 (Denali).

    and this command still works with the missing WITH in 2005/2008;...

    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!

    March 3, 2011 at 12:32 pm

    #1294250

  • RE: sql

    the UPDATE command is really misleading...it only identifies if the column was specifically listed int eh column names of the update. It does not tell you if it changed or...

    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!

    March 3, 2011 at 12:27 pm

    #1294242

  • RE: diffrence between nolock with braces and without braces

    I agree with Coldcoffee; no significant difference.

    Also i think i read in the future versions directives like that in the future will require the "WITH (nolock)" format, instead...

    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!

    March 3, 2011 at 11:58 am

    #1294208

Viewing 15 posts - 7,996 through 8,010 (of 13,460 total)