Forum Replies Created

Viewing 15 posts - 7,036 through 7,050 (of 13,460 total)

  • RE: C2 Audit Trace Files Location SQL Server 2005

    the C2 trace and the default DDL trace are not editable...but...

    a trace is just a trace.

    you can script out the C2 trace, the default trace, or any other trace on...

    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!

    August 1, 2011 at 10:02 am

    #1361676

  • RE: Send Email using T-SQL procedure

    Ninja's_RGR'us (8/1/2011)

    Hey lowell, can we really use gmail for this??? Would be really awesome if it worked!

    Yes Ninja absolutely GMail works; the only wierdness is the alternate non-"25" port,...

    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!

    August 1, 2011 at 9:55 am

    #1361666

  • RE: Send Email using T-SQL procedure

    with SQL 2005 and above, tehre is a built in service you can use by calling msdb.dbo.sp_send_dbmail

    you have to create a profile in SSMS (there's a simple wizard for...

    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!

    August 1, 2011 at 8:45 am

    #1361601

  • RE: Calling an Oracle function from SQL Server

    i don't think you are supposed to include the packagename, are you?

    for example, i've got a package that has a suite of 10 date functions and 6 string functions inside...

    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!

    August 1, 2011 at 7:37 am

    #1361531

  • RE: xp_cmdshell help

    a quick fix would be to put the xcopy.exe in a folder that exists int he cmd lines PATH variable...then, since you do not need to specify the path fro...

    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!

    August 1, 2011 at 5:31 am

    #1361454

  • RE: Arithmetic overflow error converting expression to data type datetime!! - ERROR

    justin.fernandes007 (7/29/2011)

    Hi,

    I've been running a query to obtain sone data from a table "Tickets" which is as follows :

    "SELECT *

    FROM Tickets

    WHERE CAST([Reported_Dtm] AS DATETIME )<='03/14/2011' AND CAST([Reported_Dtm] AS DATETIME...

    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 29, 2011 at 12:55 pm

    #1361043

  • RE: Pass multiple values to a stored procedure, rbar avoidance request

    how much of a change can you do? can you add your own proc, that does whatever the vendor proc did, but as a set based manipulation?

    I know 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!

    July 29, 2011 at 12:52 pm

    #1361041

  • RE: how to find ASCII characters in a table?

    here's one way:

    select * from YOURTABLE where PATINDEX('%[ !"#$%&''()*+,-./:;<=>?]%',YOURCOLUMN) > 0

    --or

    select * from YOURTABLE where YOURCOLUMN LIKE '%[ !"#$%&''()*+,-./:;<=>?]%'

    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 29, 2011 at 11:29 am

    #1360976

  • RE: From MS-SQL Query (without using xp_CmdShell & LINKED Server) how can we insert / update records from Local Excel file to a Remote MS-SQL Server database Table

    there you go!

    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 29, 2011 at 11:17 am

    #1360964

  • RE: From MS-SQL Query (without using xp_CmdShell & LINKED Server) how can we insert / update records from Local Excel file to a Remote MS-SQL Server database Table

    i'd step completely outside of SQL server and write something in a programming language instead.

    trying to do everything from within SQL is the old "Everything is a nail"...

    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 29, 2011 at 11:09 am

    #1360956

  • RE: how to find ASCII characters in a table?

    ranuganti (7/29/2011)

    I have a table in which a couple of columns (varchar) is having ASCii characters so how do i find them using a sql query?

    Thanks.

    you are still not...

    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 29, 2011 at 9:46 am

    #1360891

  • RE: From MS-SQL Query (without using xp_CmdShell & LINKED Server) how can we insert / update records from Local Excel file to a Remote MS-SQL Server database Table

    OPENROWSET command could do it, but for me that's just another flavor of a linked server; only difference is whether you devclare the server(that excel spreadsdheet) on the fly, 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!

    July 29, 2011 at 9:40 am

    #1360886

  • RE: how to find ASCII characters in a table?

    failrly easy to generate your own table of ascii chars, but i don't understand what you meant by from mulitple columns;

    can you explain what you were after?

    here's one example:

    with Tally...

    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 29, 2011 at 9:24 am

    #1360872

  • RE: grant execute permission on all sprocs

    sqlnaive (7/29/2011)

    Lowell, Your queries were perfect. It's just another thing. Lets say I want this user U1 to have permissions to GRANT permissions to other users ???

    well first, I'd question...

    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 29, 2011 at 9:17 am

    #1360868

  • RE: grant execute permission on all sprocs

    sqlnaive (7/29/2011)

    what permission level should a role have to run gran permissions ?

    well that's up to you...if the end user is supposed to have access to some of the procs,...

    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 29, 2011 at 8:26 am

    #1360840

Viewing 15 posts - 7,036 through 7,050 (of 13,460 total)