in
All Tags » 2005 » SQL Server 2005 » Microsoft (RSS)

Browse by Tags

  • Server-to-Server replication over the Internet

    I have a scenario where I need to ensure that my clients get a daily update of a SQL Server 2005 database. Their server will be SQL Server 2005 as well. What is the best replication model to accomplish this, given that the replication will have to cross firewalls, internet, etc?
    Posted to SQL Server 2005 (Forum) by microsoft on 05-15-2010

  • HOW DO I CONNECT TO LDAP DB FROM SQL SERVER 2005

    HOW DO I CONNECT TO LDAP DB FROM SQL SERVER 2005. Does anyone know of a resource that would show me or walk me through the steps to connect to the LDAP directory in our company and the bring down data to my SQL 2005 Server Database? A class or a book that may be available that explains this would be...
    Posted to SQL Server 2005 (Forum) by microsoft on 04-05-2010

  • Is there a quick way to restore multiple databases?

    Hi, My MS SQL 2005 database server is currently running 94 different databases. The db's are backed up nightly as full db backups. Here's my issue... I have a new server - is there a quick way of restoring all 94 databases and logins on this new server? I cannot take my existing server offline...
    Posted to SQL Server 2005 (Forum) by microsoft on 01-11-2010

  • SQL Server 2005 Format Phone Numbers

    I have a multi table database that has a bunch of phone number fields in the various tables. I need a stored procedure that i can execute on the DB to scan all tables for the phone number fields and then format the phone numbers to one of two formats depending on the presence of an extension. The format...
    Posted to SQL Server 2005 (Forum) by microsoft on 11-27-2009

  • Trying to find the Galactic database to download.

    I just purchased the "Microsoft SQL Server 2005 Reporting Services" book by Brian Larson. The link to download the Galactic sample database referenced on Page 116 is no longer valid. www.osborne.com has been replaced by a McGraw Hill site. Does anyone know where the site is for downloading...
    Posted to MS SQL Server (Forum) by microsoft on 09-14-2009

  • MSSQLServer Failure Audit Event ID 18456, Category (4)

    We're running Windows Server 2003 x64, SQL 2005 x64, and MOSS SharePoint 2007 all on the same box. We receive this error message in the event log every minute. The strange thing is the user is NT Authority\Syste. I'll post the text here as well as a screen shot. Any ideas? I've tried solutions...
    Posted to SQL Server 2005 (Forum) by microsoft on 08-04-2009

  • Backup and Restore DB using DOS Batch command

    Hi Everyone: How could I stop the DB service, backup DB and restart the SQL Server 2005 in Batch command? My intention is to automate the process of backup of a DB to a remote location. Is there any better way to accomplish this task? Thank in advance. Regards, LS
    Posted to MS SQL Server (Forum) by microsoft on 07-27-2009

  • Installing SQL server 2005 Domain account or the Built in system account??

    I am installing SQL server 2005 standard edition. About 3 installation dialog boxes into the install I get prompted with a dialog box to make several choices. The choices are confusing and I don't know which one to pick. First of all there is a check box labeled "Customize for each service account"...
    Posted to SQL Server 2005 (Forum) by microsoft on 07-23-2009

  • SQL server 2005  table update through XML file

    i have a xml file i want to enter the details of the xml file into the sql server 2005 table i know the table name of the database just with the xml file i have to update to sql server 2005 table just help me out to give the exact solutioin for this problem
    Posted to MS SQL Server (Forum) by microsoft on 07-18-2009

  • Change date storage format inside MS SQL Server 2005?

    Hello all, I am writing a VB application, and am storing dates. VB has default to the date format DD/MM/YYYY, which I prefer and I suspect has something to do with my localisation settings (Im in Canada). I am inserting the dates into my SQL database, but SQL is storing the dates as MM/DD/YYYY. This...
    Posted to MS SQL Server (Forum) by microsoft on 07-16-2009
Page 1 of 5 (45 items) 1 2 3 4 5 Next >