• Problem with Download-only Articles in New Subscription of Merge Replication

    Hi, I have a Publication in a SQL Server 2005 Merge Replication with Mobile Devices. To explain my problem follow this example: I have an Article in Download-Only with 100 rows. When I start new subscription I look, in the Replication Monitor, that Process start with "Insert 300 rows" for this...

    Eclipses5 pointsBadges:
  • Which version of SQL will work best?

    We have a small but critical application that is accessed by about 30 - 40 users on our network. We want to set up a SQL environment to run the database, but the application accessing the data is locally installed on each users machine. Users will access the db over our network using an ODBC...

    LeninKAF5 pointsBadges:
  • dynamic temporary table variable usage

    We have an sqr (running against a MS SQL Server DB), that references a dynamic temporary table variable in several begin-sql and begin-select statements. I am getting a syntax error in one begin-select statement where I can't resolve the problem. It occurs after the INNER JOIN on the...

    PaminBuckeyeLand15 pointsBadges:
  • Migrate User & Permissions SQL 2000 to SQL XXXX

    Hello, I need to a new windows server, but too install MS SQL Server 2005. Who know or have a code to do this job. Tank you so much.

    Njimenez5 pointsBadges:
  • Deleting Nightly Database Backups (dumps)

    How do you set up a maintenance plan to delete or overwrite daily database backups (*.bak) file. My maintenance plan in SQL 2005 does not work...it doesn't do the cleanup it continuously appends to folder and I have to manually delete the files everyday

    637815 pointsBadges:
  • Failover issues in a SQL Server 2005 mirrored database

    I have a SQL Server 2005 mirrored database with a witness. Everything seems to be working OK but I am having problems in the instance a failover occurs. Once the primary server goes down, my access to the database continues normally once both servers are back up and running and the old mirror is...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up SQL Server 2008 databases to a tape drive

    I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?

    Phrathepmali30 pointsBadges:
  • SQL Backup File

    I have two computers running sql server, sqlserver01 and sqlserver01. On sqlserver01 I backup the database locally to C:\SQLBackup\backupfile.bak (db size: 150GB) then I copy and paste the *.bak file to sqlserver02 via the network. It finishes copying but when I try to restore it on sqlserver02 it...

    0 pointsBadges:
  • grid view connection to a data in a table ?!

    Hello , I'm julien , beginner in visual studio 2008 using c# language I Have this task that I seem to be stuck in ! I've created a database using sql server express 2005 of 4 tables :"BOOKS , AUTHORS , CATEGORIES and PUBLISHERS ". I've connected this database to my gridview in visual studio , it...

    Julien5110 pointsBadges:
  • trying to restore a database in SQL Server 7

    I know I have seen a simular question before but I did not get the exact answer I was looking for. I have created a backup of my database in SQL server 7. To my knowledge I just backuped a single databse at a time. The databases might be connected in that data is used between them, but basically it...

    EdwardL20095 pointsBadges:
  • Insert Word document into SSRS

    How can I import/insert a word document into a report in SSRS?

    NTBC5 pointsBadges:
  • Transaction Log – SQL Server 2005

    How do i find out what transaction log file was last applied to a database?

    0 pointsBadges:
  • How well does SSAS run under virtualization? Any special considerations?

    How well does SSAS run under virtualization? Any special considerations?

    ITKE344,995 pointsBadges:
  • SQL script to disable views after a demo period.

    Hi, I have a sql view that I created for someone on a test basis. I want to create something (stored procedure, trigger, etc) that will delete or disable this view after a 30 day trial period. I prefer to make the view unvisible even to the "sa" administrator so that the view can not be recreated...

    Katiekat5 pointsBadges:
  • Prevent unauthorized users from accessing SQL Server 2000

    One of the SQL Server 2000 databases that I administer is configured for Windows authentication. I added an integrated logon for the domain user group. However, 20 of those in the domain user group who should not have access to the server are still able to access it. How can I prevent these...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Crystal Reports Duplicating Records

    Hi, I hope that someone can help me. We are currently replacing a system with a new version and as such we are building a new SQL DB. Although the two DBs store the same information they don't share a common layout. I have created a basic report to see if the record count for a certain select...

    Simonlevey5 pointsBadges:
  • when i print a work order in the application i need to update a field in a sql table to true

    when i print a work order in the application i need to update a field in a sql workorder table to true

    Tanjaatbrenlo40 pointsBadges:
  • SQL/400 Call Level Interface

    The option set thru the SQLSetConnectionAttr call persists until the next SQLSetConnectAttr call. If I need to set another option, how do I know that the effect of the previously set option is no longer required? Can I set connection attributes after I have connected to the database? Thank you for...

    LBurkett99830 pointsBadges:
  • What backend works best with Cognos frontend?

    Our company is looking to install Cognos as an upgrade from the Access reporting system we currently use. What is the best backend database to a Cognos frontend? We are considering SQL Server, but aren't sure if that is the best option. Any suggestions?

    Jayne46245 pointsBadges:
  • Retrieving System information

    I need to retrieve logins and users for all databases by server for SS2000 - 08. Querying the system tables sysservers, sysdatabases, sysloginns and sysusers provide the information. But how do I collect all that information with one query hopefully that I can run against all serves in the...

    Calcindor5 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