• How can I bring a .dat database file into SQL Server 2005?

    I need to bring a .dat database into SQL Server 2005. When I right click on database and Task, I don’t get the "Copy Database" option. What do I need to have this? What is an alternative method to bring the SQL Server 2000 database into SQL Server 2005 Express?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql 2005 db security for public

    I have databases that were converted (by restore) from sql 2000 to sql 2005. I found a script to move the logins (all using nt/sql auth) to the 2005 box. All the users on the sql 2000 box belonged to public on the old box. If i loook at the users inside the db's on the 2005 box (no public) they are...

    tcstl95 pointsBadges:
  • Connecting from VB6 to a remote Oracle Database

    We are a SQL 2000 Database shop using Visual Basic 6.0 & Windows 2003. I need to develop an application that can access an Orcale database on a remote system (sight to sight VPN in place) using SQL. I retreived some information yesterday that enabled me to construct the connect statement in our...

    Gcasner5 pointsBadges:
  • Installing Terminal server to existing domain

    I have a client who has Server 2003 R2 installed running 2 line of business applications on SQL Express databases, plus Exchange. They have installed a Second server as a Terminal Server to provide access for remote workers. Do I have to reinstall the applications on the Terminal Server, or is...

    Itworx5 pointsBadges:
  • Using Veritas for SQL clustering

    I would like to know if anyone is using VCS for SQL clustering and, if so, what their real-world experiences and thoughts are on VCS versus Microsoft SQL Clustering.

    JohnGalt35 pointsBadges:
  • SQL Right Trim Nulls

    How can I trim any trailng nulls from a selected record set. I have a table with up to 17 cols that I need to extract data from which included all embedded nulls but no trailing nulls

    Tim442025 pointsBadges:
  • Equivolent SQL Server function for Access DoCmd.TransferText

    I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?

    Paul4815 pointsBadges:
  • Apache config question

    I'm trying to get a rewriteCond & rewriteRule to work. I want the command to check for a file(image) and if it doesn't find it to use a default image. Not having any luck getting the command right. example: RewriteCond /doc/route/%{REQUEST_FILENAME} !-f RewriteRule ^(.+)...

    Chrissdc5 pointsBadges:
  • Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?

    Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Limiting users to one concurrent login in Active Directory

    We wish our users to login once only to one PC. Microsoft say we can only do this by limiting them to one designated machine, this is not possible for us. We need to know that if a particular user did something we can rely on the audit trail. We understand this may get tricky with Citrix use....

    Stanslad0 pointsBadges:
  • Stored Procedure for dropping indexes

    I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another strored procedure that takes a table name as...

    Dangagne30 pointsBadges:
  • Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005

    Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005

    LindaLawson10 pointsBadges:
  • Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded

    Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded

    LindaLawson10 pointsBadges:
  • SQL MERGE

    I have a view like below generated from my time and attendance software. staffNo EmployeeName title TransactionType Cdate time 556 JOHN WEB DEVELOPER IN ENTRY 24/01/2008 13:47:30 556 JOHN WEB DEVELOPER OUT ENTRY 24/01/2008 16:38:33 556 JOHN WEB DEVELOPER OUT ENTRY 24/01/2008 16:40:03 556 JOHN WEB...

    Binu.emiliya10 pointsBadges:
  • Settng Memory Sql Server 2005 SP2 64Bit

    Hi I've a SQL Server 2005 sp2 64bit , i have to set memory and my server has 12gb fisical memory and 20gb paging file, what is the best pratices to set sql server memory for best performance? Thank You Best Regards Vincenzo

    Nuanda777720 pointsBadges:
  • Securing dynamic file uploads to a SQL 2005 Server database

    I need to determine what is the best (practices) method for scanning of files/documents (.DOC, .XLS, .JPG, .TIF, .PDF) before they are dynamically uploaded into an SQL 2005 db as BLOBs..Thanks

    RJpoorvin0 pointsBadges:
  • 29 Feb incorrect in DateAdd and GetDate command

    Hi, Does anyone know Why the day of date different ? when i used : select GetDate() --> It's Return 2008-02-29 11:01:45.310 and then when used : select DateAdd(yyyy,543,GetDate() ) ---> It's return 2551-02-28 11:01:45.310 My SQL Server is MS SQL Standard Edittion VERSION 6.5 Anyone have any...

    283036050 pointsBadges:
  • Using SELECT statements

    Can we get the number of saturdays in any month using a SELECT statement(i.e without creating a table or function)? If so, can you give me the logic?

    OracleATE190 pointsBadges:
  • Performance Tracking of Stored Procedures

    we have a current system where a COBOL stored procedure is called by a .NET application. This COBOL SP then calls multiple COBOL subprograms which perform calculations and update files and then eventually return a value to the .NET app. We have a limitation in tracking the performance of each...

    Pcrum735 pointsBadges:
  • Fixing a corrupted file

    I have a 2801 router, but the Nvram file is corrupted. When we try to copy the Running config is not working. The command I use is the following: copy running-config startup-config The error says it cannot save it. I don't know what's wrong. What should I do? Do I need to download the new IOS in...

    NetworkingATE1,545 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