• Automate SSRS report

    I have a monthly task where I have to run an SSRS report for each contractid we service and export each one to excel.  The problem is that there are over 800 contracts and the tool only allows me to enter 1 at a time.  I would like to somehow enter maybe 50 contractid's and have the tool run each...

    Dlowder5 pointsBadges:
  • sql server 2005 do not show Add new administrator in Surface area Configuration

    Hi  all I haved a problem with the installation of SQL Server 2005 SP3 in a WIn xp OS.   I proceed to install the free application but when i try to check the permisions to create a DB i went to Configuration tools > SQL Server Surface area Configuration, but the screen did not present the...

    Mcom5 pointsBadges:
  • VB2008 and Connection to SQL

    Is there any way to connect to a SQL server using Vb2008? I'm trying to add a datasource but this allows me to conenct locally only.

    alessandro.panzetta9,725 pointsBadges:
  • Basic Exchange Questions

    I am in the process of configuring an Exchange 2007 server and all the books and material I have seem to skip over the basics outside of Exchange itself. I have Exchange installed and integrated into AD, etc. I currently have a domain domain.local for internal use. I need to accept email from...

    Skepticals0 pointsBadges:
  • Manual / Conditional email report from reporting services

    I've got a bit of a problem. Our company has consolidating reports, and intranet servers. One of the reports that is used quite a bit is a report delivered to warehouse management, and executives detailing orders that have been printed on a given day. I'd origionally written this report in ASP...

    MODMOD0 pointsBadges:
  • Free IT Book: Governing Shared Services On-Premise and in the Cloud

    This week's free IT book is from Prentice Hall: SOA Governance: Governing Shared Services On-Premise and in the Cloud. From the publishers: "[This book] is the result of a multi-year project to collect proven industry practices for establishing IT governance controls specific to the adoption of SOA...

    MelanieYarbrough6,345 pointsBadges:
  • Dual DATE / DATETIME (data-type) formats possible

    DB2 apps retrieve DATE cols in US format, DATEIME in ISO; can SQLServer replicate this w/o using CONVERT? If possible, would prevent massive code chgs.

    Sambocaesar5 pointsBadges:
  • No of user for database

    How many users can be connected to SQL and ORACLE from application end?

    Akansha150 pointsBadges:
  • Running Crystal Reports with a SQL Server Login instead of a Network Login

    I'm trying to run a Crystal Report using Crystal Runtime but I'm getting a "Logon Failed. Details: [Database Vendor Code: 18456]" After running a SQL Trace, I think I have found why. It appears as though it depends on how the user is logged on to the network as to whether or not they are able to...

    DB20095 pointsBadges:
  • Archiving and Purging Data

    We deal with a very large database that grows at an avrage of 50GB a month. The current database size is 700 GB. All the transaction tables are horizontally partitioned to seperate filegroups assigned to a individual data files holding each months data. What would be the best strategy to retain...

    Roops15 pointsBadges:
  • Sponsor Post: Live Expert Chat 6/1: Drive Your Business Forward with SharePoint 2010

    Join us for the next Microsoft Live Chat on Tuesday, June 1 at 11 am ET. SharePoint 2010 allows your company to quickly respond to changing business needs. Your people can share ideas and expertise, create custom solutions for specific needs and find the right business information to drive your...

    EmNichs3,250 pointsBadges:
  • How to recover the deleted database using transaction log file?

    Hello all u witty people! I am working for a pvt. corporate company. We are using Windows 2003Server as our OS and SQL Server. Earlier this morning, i was taking the back up and as my hard disk ran out of space, so it showed me an error message stating that there was not much space. but by then, my...

    Kalyan20088745 pointsBadges:
  • SSRS 2008 R2 Trendlines

    I cannot find out how to add trendlines to my SSRS 2008 R2 report. TechNet http://technet.microsoft.com/en-us/library/dd207034.aspx refers to a 'Values' area and an option to 'Add Calculated Series'. The 'Values' area I see does nothing on a "Right-click" and the option to "Add Calculated Series" I...

    NHSNick30 pointsBadges:
  • SQL Server backup to remote internet location

    We have one server with 2 SQL databases with size 1.5GB and 6GB, Daily new transactions are added to the system. Now we want a solution that this SQL gets backed up / replicated at some remote internet location on daily basis. Since we cannot transpot full 1.5GB file or 6GB file on daily basis, how...

    Amitguptaais5 pointsBadges:
  • MVC Architecure and ASP.net programming

    Are Action Filters, model binding & validation new features in MVC?

    WeberK5 pointsBadges:
  • Multiple SQL For (AS/400)

    For (AS/400) I need to create a source member with multiple sentences of sql: i.e. update aa.... update bb.... update cc.... , and then run these source member with runsqlstm. Is it possible? which is the character to separate between sentences? Thanks in advance

    WSCST5 pointsBadges:
  • MS Project Server errors

    I have Ms Project server 2007(S1), project pro(2007), SharePoint Server 2007(language pack [Turkish]installed on Server 2003 with MS SQL server 2005. I have only one farm. I can see when I create a project on server and client side. however whenever I want to see preview of a task, it gives an...

    Mahirkarabacak15 pointsBadges:
  • conversion of oracle trigger to MS SQL

    how can i convert an oracle trigger into MS-SQL?

    Jannat895 pointsBadges:
  • cluster install node failure when adding

    I installed a sql server 2008 cluster, first node went fine, however the 2nd node install fails with the following installing failover node sql server 2008 This resource does not have all the nodes of the cluster listed as 'Possible Owners'. The group that this resource is a member of will not be...

    tcstl95 pointsBadges:
  • oracle 9i in windows 7

    i installed oracle 9i in windows 7 os,and i open sql plus and login as scott and tiger it gives authentication fail message,pls help me,same i installed in win xp it works fine,one of my frnd says oracle 9i doesnot works on win7,he formatted win 7 and installed win XP

    Rsg30 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following