Forum Replies Created

Viewing 15 posts - 4,771 through 4,785 (of 13,460 total)

  • RE: bulk export table to csv files

    bcp is a command line utility...not a TSQL command.

    if you get the error in a command window, it's because bcp is not in the path...so you need to use 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!

    September 7, 2012 at 12:51 pm

    #1535240

  • RE: Server Side Traces.......How often do you use them?

    I'm a lot less worried about performance impacts of server side traces than most people i guess;

    I have three traces that are created by procedures that have been marked as...

    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!

    September 7, 2012 at 8:42 am

    #1535095

  • RE: Help Needed

    Div Goud (9/7/2012)

    Thanks Lowel,

    how to insert the currentdate into AA table with new policy number

    just expand the number of columns being updated;

    ...

    SET AA.Polcinumber = BB.Policynumber,

    Column2 = GetDate(), --a function fromt...

    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!

    September 7, 2012 at 6:41 am

    #1535030

  • RE: Help Needed

    assuming the ID is the join criteria between the two tables, this will do it:

    UPDATE AA

    SET AA.Polcinumber = BB.Policynumber

    FROM BB

    WHERE AA.ID = BB.ID

    AND AA.Polcinumber <> BB.Policynumber

    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!

    September 7, 2012 at 5:44 am

    #1535010

  • RE: Permissions

    Try this stack of queries; they all give you some various information about what permissions your current login belongs to:

    select * from fn_my_permissions(null,'SERVER')

    select * from fn_my_permissions(null,'DATABASE')

    --some inferred roles I may...

    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!

    September 6, 2012 at 1:37 pm

    #1534734

  • RE: Can I install additional sql instances without affecting the existing Production instance while it's being accessed online

    I'm with Braindonor:

    I'd lean towards no instance at all.

    just add a database to the server, create the user for the application with the appropriate permissions.

    one instance with multiple databases...

    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!

    September 6, 2012 at 8:51 am

    #1534531

  • RE: Release Total Server Memory in SQL 2008

    sqldba4u (9/6/2012)

    Things are even much slower. So just wanted to know how we can release memory without restarting SQL.

    That's what we've been trying to tell you.

    SQL Server is designed 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!

    September 6, 2012 at 7:57 am

    #1534478

  • RE: Can SQL Profiler catch the trace

    glad I could help Ali;

    pay attention to the code at the bottom, which is creating a VIEW named sp_MyTrace so you can query the trace any time, 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!

    September 6, 2012 at 7:23 am

    #1534448

  • RE: Query runs forever following database migration (2005 - 2008)

    after an upgrade to a higher version, it's pretty much manditory to rebuild all your statistics;

    the statistics in place are used differently by teh updated query engine, so if 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!

    September 6, 2012 at 6:59 am

    #1534439

  • RE: Can SQL Profiler catch the trace

    Ali Tailor (9/6/2012)

    Hi

    I am wondering for; Will SQL Profiler will capture trace for the hard coded

    query in application.

    Answers will be thankfull.

    a profiler session or a server side trace can catch...

    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!

    September 6, 2012 at 6:07 am

    #1534418

  • RE: Some linked server connections stop working

    i believe that can happen if a transaction between the server and a linked server gets rolled back, but never completes the rollback.

    if you check sp_who2 for spid = -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!

    September 5, 2012 at 1:58 pm

    #1534116

  • RE: cursor error in a stored procedure.

    also take a look at this detailed 5 page thread on trying to delete all temp tables from tempdb.

    http://www.sqlservercentral.com/Forums/Topic627590-146-1.aspx

    a quick recap: you cannot drop tables from other connections that 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!

    September 5, 2012 at 1:49 pm

    #1534113

  • RE: cursor error in a stored procedure.

    yeah, i had mentioned "get you closer", because i saw you'll need to modify it some, and wanted you to understand that part.

    looking at your cursor, do you notice...

    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!

    September 5, 2012 at 11:29 am

    #1534030

  • RE: 2:00 + Minutes to Run a No Op Function??

    well what you posted is a scalar function; ideally you want it to be an inline table valued function isntead.

    after correcting some syntax, and putting it in my default dbo...

    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!

    September 5, 2012 at 11:14 am

    #1534022

  • RE: cursor error in a stored procedure.

    qur7 (9/5/2012)

    Thanks Barry,

    it makes sense. can you please let me know where to make changes in the code, sorry I am kind a new at this and for the past...

    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!

    September 5, 2012 at 11:08 am

    #1534020

Viewing 15 posts - 4,771 through 4,785 (of 13,460 total)