• Archiving a row of data into another database on SQL Server 2005

    I work on SQL Server 2005, and I need to archive a row and its relationship into another database. I know a script could be written to do this, but I would like to know if software exists that could be given the data row and then complete the archiving by itself. Is this possible?

    SQL Server Ask the Experts2,585 pointsBadges:
  • securing sql server database object

    I connect my access project to sql server. Is there as simple way to secure sql server object such as table, view, stored proc from editing or deletion since access let us to edit sql server object directly

    Ipong40 pointsBadges:
  • SQL Server Error while creating db from DUMP

    Hi, We get the following error while trying to create a new db from a dump which contains the MDF and LDF files. Appreciate if anyone could let me know on what could be the reason for this error. The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at...

    Vidukarth25 pointsBadges:
  • Error message when connecting SQL Server database to ASP.NET

    I’ve been getting the following message when connecting my SQL Server database to the ASP.NET application: "Login failed because, under default settings, SQL Server 2000 does not allow remote connections." What might this mean?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Setting aside code for 12 databases in separate database on SQL Server

    I have 12 databases on my SQL Server, one for each month of the year, and I have almost all the same stored procedures in each database. This architecture is hard to maintain, because you have duplication of the code, and a modification must be made on all the databases. Is there a way to put all...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Making a query for a SQL Server database

    I would like to make a query for my SQL Server database to specify that only unmatching records should be displayed from both tables. Can you help me in doing so?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Email notification in the event of a SQL Server database failover

    In case of a failover of a SQL Server database, I’d like to be notified by email. Can you tell me how to activate this option?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Union Query

    I 've a problem with porting my ms access database to sql server. In my inventory database, i have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, i do with this kind of queries : a....

    Ipong40 pointsBadges:
  • Creating a website with a SQL Server database

    What programming tools can I use to create a website that will be hosted on a Windows-based platform with a SQL Server database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copying a database to a newer version of SQL Server

    I have a database on my SQL Server that needs to be upgraded to SQL Server 2005 or SQL Server 2008, but when I try to copy it with the Copy Database Wizard, I do not have the option “Copy” listed under “Tasks”. I am using SQL Server Express, which I think may be my problem. Is this...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copying a database from SQL Server 2000 to SQL Server 2005

    I am using the Copy Database Wizard to copy a database from SQL Server 2000 to SQL Server 2005. I gave it the data file path on the source server (ex. \SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLData), but it returns an error when I attempt to execute the package ("Access to the path...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database hanged due to concurrence

    Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration...

    Ome0015 pointsBadges:
  • Error messages during the creation of a mirror database on SQL Server

    I am trying to restore a database from one SQL Server to another to create a mirror database. However, when I enter “RESTORE DBMirror FROM DISK=’C:Backup DBMirror_FULL.BAK’ WITH NORECOVERY,” next to the database name appears the error message “Restoring…” It never goes away. What...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Complications in snapshot replication from a SQL Server database

    I have done snapshot replication from my SQL Server database to another SQL Server database. After completing the replication, the replicated data is not present in the other SQL Server database. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copy SQL Server Table

    How do I copy a table into the same database without including the data? Thanks ken

    Ilfoprog50 pointsBadges:
  • Implementing access from a remote site to a SQL Server 2000 database

    I have been tasked to set up access from a remote site to a SQL Server 2000 database. The user interface was programmed in .NET. This database will sit outside our firewall and will be protected by its own firewall. The application currently uses an ODBC connection to the database. Do you have any...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Eliminating duplicate rows in SQL Server 2000

    I have a database I recently inherited in SQL 2000 that contains some duplicate rows. How can I identify the tables that have this problem (duplicate rows meaning ones that have the same “time_stamp” value, and “time_stamp” being used as a raw identifier)?

    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