Forum Replies Created

Viewing 15 posts - 1,186 through 1,200 (of 13,460 total)

  • RE: Error sending email in ssrs 2012 subscription on local machine

    <SMTPServer>192.168.0.8</SMTPServer> is incorrect. YOUR local machine is not the SMTP server, you are not running an SMTP service.

    you want smtp.googlemail.com in that value, which is the address for gmail.

    setting up...

    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!

    March 19, 2016 at 6:23 am

    #1866257

  • RE: SSIS package works but fails when run as a SQL Server job.

    your job is probably running under the context of a specific user (operator) in SQL Agent.

    If you edit the job step calling the package, what is the name of 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!

    March 18, 2016 at 1:33 pm

    #1866200

  • RE: How to find out what databases have not being used for a year

    you can infer the last accessed time of every database since the server was last rebooted base din the index stats; if you've got something regularly rebooting your server, you'll...

    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!

    March 18, 2016 at 9:17 am

    #1866166

  • RE: Decrypt Stored Procedure

    if you connect locally via a Dedicated Admin Connection, you will be able to see the unencrypted definitions. you might have to enable the DAC just to conenct that way,...

    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!

    March 18, 2016 at 7:03 am

    #1866127

  • RE: cannot create new database - profile name is not valid

    i think there is a server wide trigger that is sending an email if a database is created....and the end user creating the database does not have access 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!

    March 17, 2016 at 1:37 pm

    #1865981

  • RE: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

    SET @QRY = requires passing a single column value or string value to the variable.

    SELECT @DaTE = MAX(CreatedDate) is a decent example

    your query says SET = (SELECT PL.Permit_number,

    ...

    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!

    March 17, 2016 at 12:51 pm

    #1865971

  • RE: Error Assitiance

    i think your issue is you are storing integer representations of dates; not sure if you have control, but i would change the datatypes to be [date] or [datetime] 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!

    March 17, 2016 at 12:10 pm

    #1865961

  • RE: Export all reports in RDL format from SSRS Server Automatically

    yes you can; google for "powershell extract SSRS"

    or just "extract SSRS" and you'll find quite a few solutions that query the ReportServer database and extract all the objects 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!

    March 17, 2016 at 9:58 am

    #1865915

  • RE: same old question - login and user , default database and privileges

    q1) I would say the reason is atomicity of the data plus permissions, and yes, portability. the permissions related to the database are contained in the database itself.

    backups 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!

    March 17, 2016 at 7:05 am

    #1865845

  • RE: Enumerate Windows Group Members

    Pieter-423357 (3/17/2016)

    Need trick and scanning the AD-group is certainly useful, but wouldn't you want to know the real permissions in SQL Server itself to the Database level? Or at least...

    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!

    March 17, 2016 at 6:53 am

    #1865842

  • RE: SQL Server connection issues / visibility of database.

    I've seem this before;

    What I've seen is that while 99% of the calls to the [production] database are perfectly normal, sometimes the database context gets lost, and the the default...

    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!

    March 17, 2016 at 5:45 am

    #1865824

  • RE: Dropping primary key improves performance

    i'd like to see the actual query and an execution plan;

    you might have a non-Sargable query, functions in the Where clause, a catch all query containing a lot of OR...

    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!

    March 16, 2016 at 1:54 pm

    #1865727

  • RE: Need to add and grant permissions to all the tables,procs from a database to a database role

    typically, you grant on a per-table or per-procedure basis when you want to restrict access to SOME of the tables.

    what happens if new tables are added, or a table/proc is...

    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!

    March 16, 2016 at 1:08 pm

    #1865715

  • RE: Export a table to Excel(2010)

    exporting to csv is no problem, even if there is 2.5 million rows.

    opening it IN EXCEL is an issue, since it will not support that many rows.

    open it 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!

    March 16, 2016 at 12:51 pm

    #1865710

  • RE: Monitoring Solution

    monitoring is a big subject, and enterprise level monitoring certainly depends on your budget;

    i think a lot of typical apps out there gun for $1K per monitored server, with discounts...

    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!

    March 16, 2016 at 12:06 pm

    #1865692

Viewing 15 posts - 1,186 through 1,200 (of 13,460 total)