Forum Replies Created

Viewing 15 posts - 5,521 through 5,535 (of 13,460 total)

  • RE: Can I connect another SQL Server DB without add Linked Server?

    a couple of basic examples:

    --connect via trusted connection using your domain credentials

    SELECT *

    FROM OPENROWSET('SQLOLEDB','Server=yourservernamehere;Trusted_Connection=Yes;Database=Master',

    ...

    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!

    May 7, 2012 at 7:59 am

    #1484069

  • RE: Output to CSV or txt file from Query Window

    if adding a CLR is an option, take a look at this project i slapped together over at codeplex, and this thread that discusses other options, as well as tightening...

    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!

    May 6, 2012 at 10:25 pm

    #1483951

  • RE: How to completely UNINSTALL SQL Server 2005 from Windows 2003 server, including SQL Config Manager

    it happens a lot:

    there is a MicroSoft knowledge base article on the specific registry entries and files that will help tremendously:

    How to manually uninstall an instance of SQL Server 2005

    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!

    May 6, 2012 at 7:44 am

    #1483880

  • RE: Trigger with db_send_mail and try catch

    sp_senddb_mail Is a service broker; it's already asyncronous

    more likely is the person calling the procedure doesn't have permissions to send dbmail, which requires being a user in the DatabasemailUserRole in...

    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!

    May 5, 2012 at 7:27 am

    #1483826

  • RE: Write all the records of a table to a text file on the local disk with in T-SQL (SP)

    An excellent point on security Jeff, I'm still mulling it over.

    I was thinking that a CLR added a layer of flexibility in there. You don't have to give the end...

    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!

    May 4, 2012 at 3:20 pm

    #1483772

  • RE: Trigger fires from query window but not from application

    bopritchard (5/4/2012)

    but that's just it...there are no errors...

    and i'm using sa impersonation for the linked server

    i think Craig is right...errors are being supressed in the .net app, and stesting...

    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!

    May 4, 2012 at 2:28 pm

    #1483761

  • RE: Write all the records of a table to a text file on the local disk with in T-SQL (SP)

    well i took opc.three's advice and slapped together a project on CodePlex.

    There is no doubt in my mind this will help the SQL Community.

    If any of you guys have...

    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!

    May 4, 2012 at 1:21 pm

    #1483748

  • RE: Write all the records of a table to a text file on the local disk with in T-SQL (SP)

    is adding CLR assemblies an option?

    I made a suite of CLR export functions as a proof of concept, and i can export to any text data type or HTMl 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!

    May 3, 2012 at 10:58 am

    #1483211

  • RE: Using COALESCE Statement And Char(13)

    how are you looking at the results?

    you know that SSMS, in gridview mode, converts CrLf to spaces so that it can present all the data, right? even thought 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!

    May 3, 2012 at 8:58 am

    #1483090

  • RE: DataAdapter.Update(Datatable) is not working

    hmsanghavi (5/3/2012)

    SqlCommand cmd = new SqlCommand();

    cmd.CommandText = "UPDATE DimRequestMasterTestHS SET [RunningBoard] = ?,[DutyBoard] =? ,[DriverId] =? ,[PublicServiceCode] = ?,[ServiceCode] = ?,[DepotCode] = ?,[Direction] = ?,[EOJMethod] = ?, JourneyNo=? WHERE [RequestID]=?...

    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!

    May 3, 2012 at 8:26 am

    #1483064

  • RE: Store Proc runs in 3 secs in SSMS takes 3 minutes when ran from Agent

    doesn't the slow plan say it is copying 3.8 million rows @ 115 gig via a table spooll from the linked server?

    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!

    May 2, 2012 at 12:52 pm

    #1482645

  • RE: Store Proc runs in 3 secs in SSMS takes 3 minutes when ran from Agent

    as mentioned, without specifics, wer can only guess;

    a different process smay have different ANSI settings, like ANSI NULLS, etc, which can affect the query(whatever it does).

    it could be 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!

    May 2, 2012 at 12:49 pm

    #1482641

  • RE: BCP

    er.rajesh89 (5/2/2012)

    hi if u can send code for import using " bcp in "

    By Rajesh

    Booksonline and google are great resources, but if you need an example, here's both an out...

    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!

    May 2, 2012 at 9:46 am

    #1482513

  • RE: Database mail: Emailing one message per session

    Eliyahu (5/2/2012)

    In my case godaddy just happened to be the destination. There will be hundreds of other destinations, we can neither control nor make any assumptions about them.

    you mean godaddy...

    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!

    May 2, 2012 at 7:58 am

    #1482390

  • RE: Database mail: Emailing one message per session

    when i googled "godaddy SMTP host "Too many messages for this session". ", i found a couple of posts that might help;

    one of them says godaddy has a limit...

    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!

    May 2, 2012 at 5:43 am

    #1482298

Viewing 15 posts - 5,521 through 5,535 (of 13,460 total)