Forum Replies Created

Viewing 15 posts - 9,001 through 9,015 (of 13,460 total)

  • RE: SQL Licensing - Instances

    on any one physical server, you may install as many instances as you want under that license.

    the license is really per machine, not per instance.

    http://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20Overview%20final.docx

    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!

    July 23, 2010 at 6:45 am

    #1197469

  • RE: send_dbmail error. Attachment file is invalid

    i had not seen anyone try that before...getting a file from an url.

    I'm awful sure the retrieving of an attachment is a file operation only, and the file must exist...

    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!

    July 23, 2010 at 4:58 am

    #1197427

  • RE: Doubt in a SQL Server function

    i don't think you can have variable names with the dash in them...it's interpreted as trying to minus something from the value @sd

    change your variable to @sd adn @sdaux and...

    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!

    July 23, 2010 at 4:53 am

    #1197423

  • RE: Readin email using SSIS Script Task

    for whatever reason, reading email and/or attachments was possible in SQL 2000, but deprecated for 2005 and above, i believe.

    the code to read a POP3 mailbox in .NET is pretty...

    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!

    July 22, 2010 at 12:09 pm

    #1197070

  • RE: Aliasing servername

    sushantkumar1984 (7/22/2010)

    @ lowell

    So the synonyms A,B and C which i created will be local to database level or server level..?

    and how to deallocate those synonyms once the use is over?

    thanks

    Sushant

    Virgin...

    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!

    July 22, 2010 at 9:32 am

    #1196937

  • RE: Aliasing servername

    sushantkumar1984 (7/21/2010)

    is there a method to avoid writing the server name in a query..

    like xyz.dbname.dbo.tablename1 A

    xyz.dbname.dbo.tablename2 B

    ...

    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!

    July 22, 2010 at 6:36 am

    #1196803

  • RE: SQL Server Agent Issue

    i think you'll want to use a monitoring software package that tests the server and the services that exist on it; you can't relaly expect the server to monitor itself...

    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!

    July 22, 2010 at 6:22 am

    #1196789

  • RE: Firewall config for access to remote databases at another network/domain from SSMS client

    well I know about the listening port for SQL Server...the other services, I'll await other more knowledgable users to chime in.

    the default instance uses port 1433 until you change it.

    additional...

    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!

    July 22, 2010 at 5:55 am

    #1196766

  • RE: how to deny user permission to select from a table

    well, i'm confident you didn't misspell the user, so here is my best guess:

    the user Fateme_Hei is probably already a sysadmin. that LOGIN does not also have to be a...

    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!

    July 22, 2010 at 5:39 am

    #1196759

  • RE: The mail could not be sent to the recipients because of the mail server failure.

    okiftequar (7/22/2010)

    Exception Message: Could not connect to mail server. (No such host is known).

    )

    that error is usually because the url to the mail server is incorrect, or there's no...

    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!

    July 22, 2010 at 5:28 am

    #1196754

  • RE: What Events does the Default Trace Capture?

    here's the default trace scripted out so you can see and add more events, etc and create a replacement that might last longer than the default:

    default_trace_script.txt

    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!

    July 22, 2010 at 4:27 am

    #1196731

  • RE: logon logout auditing

    also this part:

    'The service queue "LoggingQueue" is currently disabled.'

    you have to kick everyone off of the database to run the script to set up the queue; exclusive access is required....

    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!

    July 21, 2010 at 5:01 pm

    #1196555

  • RE: logon logout auditing

    I'd think sa has access to everything if it exists...

    if you don't filter by application name, your hours using the ERP will be inflated for developers who connect with SSMS...

    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!

    July 21, 2010 at 4:57 pm

    #1196553

  • RE: Terrible code, trying to tweak

    rule of thumb for me is if the @TableVariable has anywhere near 1000 rows or more, it should be changed to a #temp table instead...

    after that, it would take some...

    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!

    July 21, 2010 at 4:52 pm

    #1196550

  • RE: Linked Server from SQLExpress to Excel - fails in job but works on PC

    the security part that is tripping you up is this part:

    @useself=N'True'

    that means when you select from the linked server, your sql login is being used as the credentials for 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!

    July 21, 2010 at 4:47 pm

    #1196549

Viewing 15 posts - 9,001 through 9,015 (of 13,460 total)