Forum Replies Created

Viewing 15 posts - 8,611 through 8,625 (of 13,460 total)

  • RE: What is executing my Stored Procedure?

    barry.smallman (10/7/2010)

    Hi,

    Yes, I tried amending the SP to query the sys.dm_exec_connections DMV as suggested in the reply by Lowell!!

    When the stored procedure failed to run this morning, I started investigating...

    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!

    October 7, 2010 at 4:20 am

    #1233386

  • RE: Migrate Oracle database to SQL Server 2008

    parthi-1705 (10/6/2010)

    Hi Lowell

    why did you changed your pic of old(that dog) it was nice when i came long time...

    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!

    October 6, 2010 at 12:36 pm

    #1232950

  • RE: Migrate Oracle database to SQL Server 2008

    looks like version 4.2 is for "all" versions of SQL 2008; no special version just for SQL 2008 R2:

    there are two different downloads for 2005 vs 2008 though, both marked...

    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!

    October 6, 2010 at 12:13 pm

    #1232925

  • RE: Migrate Oracle database to SQL Server 2008

    I like to think of SSIS as the universal tool, which can connect to all kinds of datasources, and you can write code to do anything you want. lots 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!

    October 6, 2010 at 12:01 pm

    #1232911

  • RE: Migrate Oracle database to SQL Server 2008

    SQL has created some ready-to-use Oracle Migration Assistants to make this kind of transformation a lot easier.

    http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx

    you can do it with SSIS, but this handles a lot of the twists...

    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!

    October 6, 2010 at 11:22 am

    #1232852

  • RE: Looping through the recordset to assign different balance value to each transaction row

    yogesh_pandey (10/6/2010)

    Thank you. Can I send you a DDL and may be you can help. Please let me know.

    post the DDL and sample data here; there's lots of volunteers 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!

    October 6, 2010 at 10:53 am

    #1232818

  • RE: Looping through the recordset to assign different balance value to each transaction row

    yogesh_pandey (10/6/2010)

    Thank you for the reply. But the cur balance is in one table and the transaction is in another. I would have to use cur balance and remember 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!

    October 6, 2010 at 10:46 am

    #1232812

  • RE: Setting a SQL Server Trace to find the number of times user tables are acsessed in a DataBase in a particular period of time.

    not that easy, because the objectname themselves are not stored anywhere long term as far as SELECT/UPDATE/DELETE are involved; there are some DMV's that keep track of some recent events,...

    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!

    October 6, 2010 at 10:41 am

    #1232804

  • RE: Looping through the recordset to assign different balance value to each transaction row

    what you are after is a "Running Total" type of query;

    what you end up doing is join the table to itself with an alias , by offsetting one row 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!

    October 6, 2010 at 10:24 am

    #1232782

  • RE: Travel Planner SQL

    not sure if this is what you are after;

    Peso is one of the forum members with a strong grasp on this;

    there is a thread about Dijkstra's Shortest Path Algorithm, which...

    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!

    October 6, 2010 at 9:53 am

    #1232743

  • RE: What is executing my Stored Procedure?

    barry can you edit the procedure? I would add a simple but detailed auditstatement to dump the snippet below into a table in master or call sp_send_dbmail, so you could...

    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!

    October 6, 2010 at 5:42 am

    #1232403

  • RE: How to delete database on production server

    Derrick Smith (10/5/2010)

    Lowell (10/5/2010)

    bump, as I wanted to know if kras followed up on the reasoning behind wanting to drop the production database.

    Wait, we need "reasons" for this kind 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!

    October 5, 2010 at 9:45 am

    #1231843

  • RE: tables that were deleted still appear when query

    g33kspeak (10/5/2010)

    What are the table names that are showing up that you cannot find?

    select * from sys.objects where name like 'queue_messages%'

    select * from sys.tables where name like 'queue_messages%'

    they are tables,...

    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!

    October 5, 2010 at 8:34 am

    #1231751

  • RE: How to delete database on production server

    bump, as I wanted to know if kras followed up on the reasoning behind wanting to drop the production database.

    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!

    October 5, 2010 at 8:30 am

    #1231741

  • RE: Disk Defrag

    sysInternals Contig.exe allows you to defrag specific folders, file specs like *.mdf or even specific files form a command line...so it's a little faster operation to script out 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!

    October 5, 2010 at 8:02 am

    #1231714

Viewing 15 posts - 8,611 through 8,625 (of 13,460 total)