Forum Replies Created

Viewing 15 posts - 13,231 through 13,245 (of 13,460 total)

  • RE: .mdf and .ldf file dates

    FYI i stopped and started my server to test this theory, and sure enough, any open databases had mdf/ldf's with a timestamp of when the server shutdown; some mdf's 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!

    October 5, 2005 at 7:51 am

    #595127

  • RE: .mdf and .ldf file dates

    I believe it is  because the files are open and being used, and are only closed when the server is stopped.

    when the server stops it closes the files and 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 4, 2005 at 3:32 pm

    #595015

  • RE: Can we send Job Notification to two seperate "Operators"

    you could also solve this at the mailserver level...where a group called DBANotifications is created, and dba's are added to that group...then have the scheduled job send to the group...

    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 4, 2005 at 3:14 pm

    #595010

  • RE: write result in excel file.

    from within query analyzer and not an appliction, i created an excel file with the three columns exactly as david suggested and ran this code:

    INSERT INTO

    OPENROWSET('Microsoft.Jet.OLEDB.4.0',

    'Excel 8.0;Database=C:\Book1.xls', [sheet1$])...

    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 3, 2005 at 10:44 am

    #594641

  • RE: Toad for SQL Freeware connection problem

     

    connect via instance name and run the script below. this will identify what port your instance is listening to.

    if it is anything other than 1433, you will 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!

    October 3, 2005 at 10:25 am

    #594632

  • RE: SQL Server multiple instance problem

    connect via instance name and run the script below. this will identify what port your instance is listening to.

    if it is anything other than 1433, you will need to include...

    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 3, 2005 at 10:25 am

    #594633

  • RE: help needed with xp_cmdshell

    Shelling out an html file does not return any text.

    if your objective is to use sql server to call and parse a web page, you will need to write an...

    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 3, 2005 at 5:08 am

    #594511

  • RE: Toad for SQL Freeware connection problem

    are you trying to connect to a named instance of SQl server, rather than a default instance?

    for example, my machine has a SQL7 instance and a SQL2000 instance.

    connecting to 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 30, 2005 at 6:16 am

    #594295

  • RE: SQL Server 2000 Statistics

    I believe statistics are gathered when a table is queried, so that subsequent queries can be tuned to follow the path of previous queries;

    could it be that the tables 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 29, 2005 at 6:32 am

    #593993

  • RE: ActiveX Script Resources?

    I hope this helps: if you take an html file and change it's extension to .xls, Excel translates the file beautifully, keeping all your table atrributes TR and TD and everything...

    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 28, 2005 at 7:38 am

    #593660

  • RE: HELP! SOX OUT OF CONTROL!@!

    there is a fascinating read here at SCC where the SOX auditors tried to say that the DBA must not have access to the production servers:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=161&messageid=116604

    which is patently ridiculous,...

    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 27, 2005 at 12:10 pm

    #593396

  • RE: Insert Child before Parent

    this is probably better for you than the long crap i posted:

    create table #tuser (type int, oname varchar(517), owner varchar(517), seq int)

    insert #tuser exec sp_msdependencies null, 3, null, null, 1

    select...

    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 27, 2005 at 9:35 am

    #593329

  • RE: Insert Child before Parent

    below is a procedure which returns all tables in the foreign key hiearachy order; it's copied and slightly adapted from scripts here at SSC;

    i would suggest the following:

    use this...

    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 27, 2005 at 9:19 am

    #593319

  • RE: Insert Child before Parent

    i think you missed the point that each insert statement is an atomic transaction;

    the begin tran is just a marker so that a group of atomic transactions can be rolled...

    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 27, 2005 at 7:19 am

    #593263

  • RE: Printing command lines

    I thought the issue might be because you are running it in Query Analyzer; by default, text is limited to 256 chanracters until you change it to allow up 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 27, 2005 at 7:10 am

    #593254

Viewing 15 posts - 13,231 through 13,245 (of 13,460 total)