• Using the snapshot feature in SQL Server 2005 to replicate an operational database

    We are trying to keep a replicated copy of a customer’s operational database at our hosting facility. Our copy of their operational system will be used to run ETL against each night to refresh a data reporting database. Our hope is that, each night, we will receive a snapshot file and apply that...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Webpage and SQL interaction

    The problem I need to figure out is that I need to have client information stored on an SQL server database and I need something to be able to use this information to get quotes from several insurance companies. All these companies require different info in a different order. So my questions are as...

    Katy20 pointsBadges:
  • Securing a SQL Server 2008 database

    I am on SQL Server 2000, and to secure my database, I want the user to be prompted for a user ID and password before the database is expanded. How might I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Differences between values in a SQL Server 2005 database

    What is the difference between the Checksum and TornPageDetection values of the PageVerify option in a SQL Server 2005 database's properties?

    SQL Server Ask the Experts2,585 pointsBadges:
  • os on data base servers

    do you need an os on a data base server if you have sql loaded

    Carman5 pointsBadges:
  • Error message while querying a linked server SQL database

    We have two remote servers, both with SQL Server 2000 databases. An ODBC data source was setup on the first server to point to the SQL Server database on the second server. Also, a linked server was setup on the first server between the SQL Server databases on both server. It was based on the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Rolling back a SQL Server 2005 database while retaining data added

    I have a database that has been running for about six months in SQL Server 2005 on 64-bit Windows Server 2003. There are no backups, but recovery mode is set to full and I have never deleted the log file. I need to rollback to a recent point in time while also retaining data added since that point...

    SQL Server Ask the Experts2,585 pointsBadges:
  • how to delete dup records from a table to ?

    basically i want to remove dups in a table. i have a table called productincludes it has a few fields listed here: ParentProductID ChildProductID SummarizedRowID IncludeStatus LastUpdateDate DisplayOrderByID i ran a update for a business request that made many dup rows and want to clean this up....

    Supergirl20085 pointsBadges:
  • Sql Server Database doesn’t updated

    Hello, iam developing an ASP.NET2 Application using SQL Server2005 database, i have updated data from a web page ,the data updated successfuly and displays a meessage that itis updated successfuly , but when i refresh the page or when i display the data from the database ,i found that no changes...

    AbuSolyman20 pointsBadges:
  • Producing a nightly tab delineated file for a SQL Server database

    I wish to produce a nightly tab delineated file, based on a recordset, for our SQL Server database. How could I program this to be produced at a specific time each night?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Analyzing Existing Indexes

    Hello, I am trying to analyze existing indexes on few tables. I think I can do this by using system views like sys.db_dm_index_usagestats, physicalstats and operationalstats. I am here trying to figure out disk space used by each index, I/O stats ,fragmentation etc I am wondering if ,Apart these...

    Sqloholic25 pointsBadges:
  • Connect SQL Server 2005 Express db to Visual Basic 2005 Express

    I get an error "Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances. I run the store procedure on SQL Server and it looks like it worked, but "Test Connection" gives me the same error. What can I do to resolve this error?

    Dhanson20 pointsBadges:
  • Re-linking database user

    Hi Guys, What I am trying to do is relink a database user to a new domain user, and also keeping the same database user name. I am able to do this when I run the following command, and if the database user isn't the same as the login name. use temp alter user TestUser2 with name= TestUser2, login=...

    Db23290 pointsBadges:
  • Using SQL Profiler to identify the cause of data loss

    We have a SQL database where a table is having information vanish. We plan to use SQL Profiler to identify the cause of this sudden data loss. When using SQL Profiler, what counters should be captured? Also, what trace format should be used?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Re-applying column constraints

    I have a 100+ db that was hacked. The column level constraints/defaults were removed. I'd like to know how I can reapply the constraints/defaults while keeping the data intact. I do have an identical database with no data in it.

    Kcook5 pointsBadges:
  • Truncating the transaction log for a SQL Server 2000 database

    What is the best automated way to truncate the transaction log for a SQL Server 2000 database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connecting sql server 2000 to 2 databases simultaneously

    I have to create a report to move inventory from an old warehouse to a new one. Each has a separate instance of the database, so I have to get the part# and location from the old warehouse and match it with the new location for that part# in the new warehouse. Is there a way to join tables from...

    CO Bill120 pointsBadges:
  • Transferring a database from Microsoft Access to SQL Server 2000

    How would I transfer a database from Microsoft Access to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL DATABASE SERVER

    Hi, Please how can I access a client SQL database server remotely to update date therein. My client have this MS SQL Server Ver. 9.00.2047.00, Product Level: SP1, Edition: Standard Edition. and I will need to update the data. I have to update the database. I have downloaded SQLEXPR and installed in...

    Chukbillo20 pointsBadges:
  • Creating database access at runtime for ADO and SQL Server

    I’ve put together some code to create database access at runtime using an ADO database connection. How can I do the same for a SQL Server database?

    SQL Server Ask the Experts2,585 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