Forum Replies Created

Viewing 15 posts - 13,171 through 13,185 (of 13,460 total)

  • RE: How do you create a XML (string) from temporary table in T_SQL

    it pretty much cannot be done.

    the FOR XML returns a stream to a dataset or recordset, adn not an standard object in SQL server, so you cannot capture the data,...

    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!

    December 23, 2005 at 10:53 am

    #611344

  • RE: Create a CHM file out of SQL Server database?

    someone created a script here on SSC which creates HTML documentation of a database and it's schema;

    it produces results in HTMl, and a google search showed me a lot 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!

    December 23, 2005 at 6:51 am

    #611283

  • RE: How to read the value of "set rowcount int_value" after setting it ?

     

    you can get that value by running DBCC USEROPTIONS

    set rowcount 50

    DBCC USEROPTIONS

    textsize64512

    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!

    December 22, 2005 at 1:33 pm

    #611221

  • RE: Etended Procedures

    vb6 cannot build any dll that can be used as an extended stored proc; you have to do it in C/C++/Delphi or any .NET language.

    VB6 can't do it because 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!

    December 21, 2005 at 6:14 am

    #610808

  • RE: Lost Data

    when you did the manual backup on Saturday 4pm, could it be that the backup was set to the default of "append to existing media"?

    in that case, the backup file...

    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!

    December 21, 2005 at 6:10 am

    #610806

  • RE: need script to kill user SPIDS

    i stick this in master and use the command sp_kill dbname to kick my users out:

    what is nice is that when called in a job or script, it is 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!

    December 20, 2005 at 6:35 am

    #610552

  • RE: MSDE - Temporary Tables - Closed Recordset

    i would bet it's the SET NOCOUNT ON thing; the adodb recordset can get the  12 records(s) affected as the recordset to return, unless you explicily say set nocount:

    ALTER...

    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!

    December 17, 2005 at 10:16 pm

    #610220

  • RE: Displaying RTF or HTML in a report?

    you should be able to use regualr expressions to strip out either rtf or html;

    you can do it within an app or client side in vb or .net, but 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!

    December 9, 2005 at 8:20 am

    #608680

  • RE: double spaced when typing? how to correct?

    if you switch to HTML view in the textbox where you type your comments, you'll see that when typing directly into textarea, the ENTER key ends up creating a <P>...

    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!

    December 8, 2005 at 11:14 am

    #608495

  • RE: Best way to audit table updates

    i would suggest some of the utilities from Redgate or idera that can present all changes in script format by reading the transaction logs.

    it's full featured and would probably cost...

    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!

    December 5, 2005 at 1:49 pm

    #607796

  • RE: Reverse engineering a 2005 database with Visio

    can't you still use the standard driver for SQl server to connect to a SQL 2005 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!

    December 1, 2005 at 8:11 am

    #607072

  • RE: No index hint

    indexes are used by the server to find data faster.

    I doubt you might want the server to get the data slower or less efficiently.

    in a complex query, you might add...

    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!

    December 1, 2005 at 6:59 am

    #607027

  • RE: corrupt mdf and ldf file

    dunno if this is it, but i've seen a simialr situation:

    Device activation error. The physical file name 'E:\WSUS\SUSDB_log.LDF' may be incorrect.

    you would get this error if:

    the folder path to create 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!

    December 1, 2005 at 6:49 am

    #607023

  • RE: Convert RTF data

    If you could send me the proc, i could convert it to TSQL no problem.

    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!

    November 30, 2005 at 6:24 am

    #606691

  • RE: very complicated stored proc

    just guessing, but the whole SQL is full of inner joins... so that means if one of those tables in all the joins do not have a row to match...

    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!

    November 29, 2005 at 11:44 am

    #606508

Viewing 15 posts - 13,171 through 13,185 (of 13,460 total)