• SQL 2005 Transaction Logs

    I am by no means very good at SQL. I know the basics. I am a network engineer but was recently asked to do a few tasks in a SQL 2005 environment. I currently have a database that is residing off-site and I was asked to import the database and transaction logs so that this server can be used for...

    Danyluk15 pointsBadges:
  • Need advice on CRM application integration for email newsletter system

    We are in the process of developing an electronic email newsletter system for one of our client. Could you tell me how we may be able to link to and from their Microsoft CRM database to our email newsletter SQL Server database. For example, we need to link the newsletter with the database of...

    CRM Ask the Expert250 pointsBadges:
  • Insert records between records in a file using RPG code.

    Is there a way to insert a record in between records in a file? For example, a file contains 10 records (1 to 10). I want to insert a record in between records 1 and 2, thus record 2 will move to position 3, 3 to 4, and so on and so forth. Can SQL/Insert function be used to do this?

    Francissamonte15 pointsBadges:
  • installing SQL server enterprise edition on XP

    how can I install SQL server enterprise edition on windows XP? I know there is a way but I dont know it if some body know it tell me plz

    Sazzemokhalef5 pointsBadges:
  • Should we use system tables or information schema views to retrieve metadata if both give the same results? Please explain why.

    Should we use System tables or Information schema views to retrieve Metadata, since both give the same results, and why?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to access a database on a remote SQL Server

    I want to access a database on a remote SQL Server in my organization. I need to access it with my Visual Basic (VB) application. I can do it on the local machine but not on my remote machine. How do I resolve the issue?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Configuring a SQL Server installation to accept only SQL Server authentication

    How do you configure a SQL Server installation to accept only SQL Server authentication and not both SQL and Windows authentication?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using DTS objects for scripts to alter SQL Server password

    Is it possible to use DTS objects to create scripts to alter the SQL Server password I assigned when I installed the server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Stored procedures in SSRS

    Can we call the stored procedure in SSRS when creating reports.I am new to sql server plaese help me in this question

    Sriradhi25 pointsBadges:
  • Need to upgrade sql server

    Hi right now my database server running on sql server 2000 & my application is also running from the same server for heavy load on server i m going to seperate my database server & application server i need a help bocz my database size is all most 3 GB. also i need to upgrade my database on new...

    Ravijoshi2020 pointsBadges:
  • Looking for best way to have SQL Server data security, replication as well as security maintenance

    I joined a production environment recently, and I’m the key person here. We have 2 servers: one production server and a replication server. Data from the application goes to the production server every second and that is replicated to the replication server. We fetch the data from replication...

    SQL Server Ask the Experts2,585 pointsBadges:
  • how to upgrade server to SQL 2005

    I have a system with MS SQL Server 2005 installed and am running the MS SQL Server Management Studio Express but when I query the database version it comes back as SQL 2000 - 8.00.194. How do it change to using SQL 2005?

    Cjdechris5 pointsBadges:
  • sql scripts

    Hi all, i'm updating a new 'commun management' software n i wanna update the database bcoz i added many extra tables. i did write scripts for all the tables this way: Create........... Drop........... Alter........ so our clients would be able to have access to it. but i have been asked to write...

    JARON5 pointsBadges:
  • Restoring SQL Server 2000 database

    I want to restore a database in SQL Server 2000, using a specific name. I tried restoring it using Enterprise Manager, but kept getting the error 'You must select a backup set to restore'. Why is this and how do I resolve it?

    Gini_25 pointsBadges:
  • how to update a row in grid view in vb.net

    how to update a row in grid view in vb.net using sql server as back end

    Anupamak1515 pointsBadges:
  • Problem converting Access SQL query to T-SQL 2005

    I have a SQL Server 2005 database. One of my co-workers has put a MS Access front-end on it, because of the ease of designing queries in Access. I need to convert an existing query from Access SQL to T-SQL to put it into production. So far, I have removed all the obvious differences between the 2,...

    Chunkydrew15 pointsBadges:
  • Linking Microsoft CRM to MSSQL Server

    We are currently setting up a email newsletter system for one of our client and are looking at linking to and fro their CRM, for example, we need to link our newsletters (stored in MSSQL) to their list of contact emails (Stored in CRM) and write information related to the newsletter usage back to...

    Estellemorris15 pointsBadges:
  • Veritas vs. SQL Server 2005

    Why will SQL Server not accept files restored from Veritas backups?

    Patticake5 pointsBadges:
  • Planning to move data on new databse server?

    Well i m working in MNC As a Network admin actually we have one server having data & application so both our application and database on same server & now we are facing some problem on it so we plan to seperate database server & application if any body has a plan or he/she know how move our...

    Ravijoshi2020 pointsBadges:
  • GPO — increasing logon banner size

    how to configure a logon banners that can exceed 512 characters in length in window server 2003?

    Rmcfarla0 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