Forum Replies Created

Viewing 15 posts - 91 through 105 (of 1,884 total)

  • RE: SQL SERVER 9.0.3073 Reporting Services Issues

    you may want to review the logs. The logs will be located on the drive where SSRS are installed, in case of my computer, on drive C:

    C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting...

    Regards,Yelena Varsha

  • RE: How to resend email in Database Mail?

    You can re-run the query or a job that sent you this db mail.

    But before you do that try to find your original email:

    - Look in the Junk mail folder....

    Regards,Yelena Varsha

  • RE: SQL 2005 Server Management Studio Import Export Wizard

    Carel,

    it will help if you describe in more details what kind of the connections you make to both servers:

    Do you have SQL 2000 Server on your computer and have...

    Regards,Yelena Varsha

  • RE: fastest method to copy data from one table to another

    To make it faster you can also make use of the non-logged or minimally logged operations to avoid writing into the transaction log if your business task allows that. Read...

    Regards,Yelena Varsha

  • RE: How do i identify last SQL Services start date time?

    SQL Server Error logs and Windows Event Logs provide both start and stop time

    Regards,Yelena Varsha

  • RE: The Challenges of Being Safe

    My advice is to use legal Nondisclosure Agreements

    Regards,Yelena Varsha

  • RE: Automating Excel from SQL Server

    Wayne,

    Please read about data driven subscriptions for Reporting Services. It may help you.

    Here is a link to the 3 -page 30 min tutorial:

    http://technet.microsoft.com/en-us/library/ms169673.aspx

    Tutorial: Creating a Data-Driven Subscription

    In the tutorial it...

    Regards,Yelena Varsha

  • RE: Automating Excel from SQL Server

    You can call Excel remotely from ASP and ASP.NET pages

    Also we have good experience with MS ACCESS / VBA and linked tables to SQL Server. This is really good for...

    Regards,Yelena Varsha

  • RE: Scripting INSERTs

    I mostly use CSV / BCP or MS ACCESS for that.

    Regards,Yelena Varsha

  • RE: Scripting INSERTs

    Why Insert... Select would not do?

    Regards,Yelena Varsha

  • RE: Indexes

    My guess is that a Senior technical writer got this assignment, created a TO-DO list of all types with the intention of naming them properly and adding a description later,...

    Regards,Yelena Varsha

  • RE: Indexes

    I totally agree with Ed V. and Hugo K.

    I did not select Indexed Views as a type. As for the naming things: there is a Russian expression: "you can...

    Regards,Yelena Varsha

  • RE: Security

    Steve, I added "SA" to my answer and I think I am correct.

    "SA" is represented externally as a service startup account and as such has full rights on the database...

    Regards,Yelena Varsha

  • RE: Database Security

    It is funny that 'EXTERNAL ACCESS" or "UNSAFE" is also needed with"TRUSTWORTHY". Unusual combination.

    Regards,Yelena Varsha

  • RE: Automating Excel from SQL Server

    We do have a couple of applications using similar approach. They are coded by a consultant. I prefer to demonstrate what reports you can produce in the Reporting Services...

    Regards,Yelena Varsha

Viewing 15 posts - 91 through 105 (of 1,884 total)