Forum Replies Created

Viewing 15 posts - 4,621 through 4,635 (of 13,460 total)

  • RE: Need to call a batch file from a remote server

    it's been a while since i sued it but PSEXEC from the PSTools suite is designed for executing things on a remote system...there might be some permissions issues...

    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 10, 2012 at 1:37 pm

    #1547790

  • RE: create full DDL all databases

    this thread has a really nice powershell script Gene Hunter posted for the community:

    it scripts everything.

    http://www.sqlservercentral.com/Forums/Topic1240480-1351-1.aspx

    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 10, 2012 at 1:33 pm

    #1547789

  • RE: Send email to different recipients

    i was modifying an example named "notes" to match your data, but without the actual tables, I could not test it for valid objects.

    if you can fix the syntax...

    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 10, 2012 at 1:22 pm

    #1547787

  • RE: Send email to different recipients

    this one is tough, because i don't have the tables to test agaisnt.

    this MIGHT return the email/string you want to send.

    if it does, then this query is what you would...

    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 10, 2012 at 12:20 pm

    #1547779

  • RE: Send email to different recipients

    your image is blocked at my work, some filesharing violation according to our IT guys......can you paste the code you are referencing instead of an image?

    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 10, 2012 at 11:44 am

    #1547770

  • RE: Create a database from XML file

    paruchuri4 (10/10/2012)

    How to create a sql database from a xml file

    you are definitely going to have to help us help you here.

    what xml?

    are you reading a value from the xml,...

    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 10, 2012 at 9:58 am

    #1547737

  • RE: The object 'DF.....' is dependent on column 'COL1' . But How?

    the part of your script here:

    DEFAULT 1

    Alter Table Demo ADD col1 Int NOT NULL DEFAULT 1

    creates a default constraint ont eh column...so you can't drop teh column until you drop...

    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 10, 2012 at 9:44 am

    #1547731

  • RE: Question Can you connect to a database directly without linking to its server?

    maybe, with openrowset, and assuming there is connectivity between the two SQL servers:

    here's a couple basic examples:

    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!

    October 10, 2012 at 8:17 am

    #1547675

  • RE: How to monitor a database in SQL Server 2005?

    depends completely on what you want to monitor.

    Monitoring usually refers to the whole server in general .

    For built in reports, go to the Object Explorer in SQL Server Management...

    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 10, 2012 at 7:48 am

    #1547656

  • RE: Alternative process except by doing using linked server?

    if you think about it at a little higher level, the question is :

    how can [something] make two connections and transfer data.

    just as you are seeing, the possibilities boil down...

    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 10, 2012 at 6:30 am

    #1547618

  • RE: can't attach adventurework database 2012

    access denied is usually because the account the SQL service is running from doesn't have access to teh specific folder the mdf exists in;

    for example, if the mdf is 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 9, 2012 at 11:07 am

    #1547301

  • RE: Full Text Column Weight/Rank

    if you change form inner join to left outer joins, won't you get the desired results, where the string is in one or more 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 9, 2012 at 9:36 am

    #1547265

  • RE: I need help

    thbe error is here: you are mixing the old comma delimited join style up with the newer explicit join;

    you should stick with the newer version, since it makes it clearer...

    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 9, 2012 at 6:48 am

    #1547197

  • RE: Open EDI file in SQL Server

    ramadesai108 (10/8/2012)

    siggemannen,

    Say for example I have a file named my127.edi. How to do bcp or bulk insert for this file?

    Thanks for your time.

    that's what we keep...

    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 9, 2012 at 5:12 am

    #1547156

  • RE: BCP to pipe delimited format

    for the pipe delimited row terminator, you need to add -t"|" to the command ; see bcp /? from a command prompt for all the options.

    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 8, 2012 at 1:37 pm

    #1546894

Viewing 15 posts - 4,621 through 4,635 (of 13,460 total)