• SQL Server Logins

    Hi Currently using SQL server 2000 Is there a way of making SQL server logins use case sensitive passwords. for example    user = SA password = PassWord123 as it stands "SA" can login with password = password123 how can can i change it so the user cannot login with different case password. I...

    KH155 pointsBadges:
  • Crystal Reports XI period in database name

    SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?

    Fortuna35 pointsBadges:
  • SQL SERVER 2005 Performance Monitoring

    Hello, is there a free software tool to monitor sql server 2005 similar to Quest FogLight? Quest FogLight is just too expensive for my budget. I am an independent consultant and I want to be able to monitor my client’s sql server.

    Rick Martinez585 pointsBadges:
  • upgrade SQL Server 2008 32-bit to 64-bit

    We have a new SQL STANDARD SERVER 2008 R2 x64, and an existing SQL STandard Server 2008 R2 x32. I want to migrate the database from the old x32 bit to the new x64 bit machine. Has anyone got any information regarding this, or resource to research read up on. Thank you

    Revsoft5 pointsBadges:
  • Open IT Forum: What cloud concern do you need addressed?

    Will all of the buzz surrounding the cloud - no doubt amplified by Vivek Kundra's push to the cloud - are you feeling left out at all? I recently spoke to an operations manager who feels that SMBs are excluded from the discussion because of fewer resources. What information would you like to know...

    MelanieYarbrough6,345 pointsBadges:
  • 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:
  • VB6 and SQL Server

    What version(s) of SQLServer is/are copatible with VB6?  I am currently using an MS Access DB but am considering changing.  Can someone please assist - thanks in advance

    GeorgeRT5 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:
  • 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:

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