• SQL server 2000 sp3 database remote access

    hi i want to access a sql server 2000 sp3 database in remote system where no sql server 2000 is installed. can anyone help me for this?

    Itdonsavi30 pointsBadges:
  • SQL Server user name issue

    We have a server in which Windows 2003 is installed and we have created users in the domain (e.g. - aaa). The server is installed with SQL Server 2000 and data is stored in the database. The user name for the server is “administrator.” When we login from the user computer with the same name and...

    SQL Server Ask the Experts2,585 pointsBadges:
  • MS DNS query logging to sql server?

    Does anybody know if it is possible using 2003 server r2 dns to log querys to a sql server database instead of a file?

    Ryan99795 pointsBadges:
  • Merging MDF files on SQL databases after restoring from a backup

    I recently restored our SQL Server database from a backup, but unfortunately I used a Wednesday backup instead of Thursday, and it is now Friday. Is there a way to merge MDF files, to join all the data together because, as of now, we are missing Thursday’s data.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Removing and adding new space to databases.

    The scenario: SQL_SVR_A (2000)has x amount 'too much' SAN disk space that they want to reclaim/use to allocate to SQL_SVR_B (2000)- which doesn't have enough space. What is the best method to, first, remove the disk space and keep all DBs in-tact and secondly, how to add new space to ServerB,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Monitoring log files in a SQL Server 2000 database

    I have an intermittent problem with a SQL Server 2000 database. The job, to truncate the log files, doesn't start on time, and the transaction fills up preventing users from logging in. I would like to monitor the log such that I can send an alert when the log reaches e.g. 80% full.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Email Notification

    Hey i am creating an application front end = vb.net and back end = sql server db!! the application helps assign staff to jobs and when an assignment occurs i would like the staff to recieve an email informing them that they have been assigned to a job... can anyone help me out with how i would go...

    Keirameister5 pointsBadges:
  • Find a particular text from all tables in DB.

    Hi There are 100 tables in my DB. I want to find if a text say "ABCD" is availbale in any these 100 tables. If it is availbale can we list those tables. Can someone help me out with the Query.   Regards Mayur

    Mayurkhe295 pointsBadges:
  • Hiding the system views table from Microsoft Access

    How can you hide the system views table from applications like Microsoft Access? For example, whenever I link to tables in our SQL Server database, INFORMATION_SCHEMA and sys system views are included in the list of tables. This prevents us from finding our tables immediately. How can this be done?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Implementing Encrypted SQL Server Database Columns

    This is the problem I'm facing: The database (SQL Server 2005) holds more than 5 million customer records. These records contain sensitive credit-card information that must be encrypted. Implementing an application-side encryption solution involves VB6 and .Net technologies. How to achieve a...

    Kansai5 pointsBadges:
  • Replication sync_method set to concurrent in SQL Server 2000

    Hi, Just wondering what happens to data that are inserted during the time of a snapshot replication generation when the sync_method is set to concurrent, as there are no table locks, are the data insert into the publisher then held in the distribution database and when the snapshot has been...

    Db23290 pointsBadges:
  • Data model for Custom fields and Custom forms.

    Hi, I plan to build a web application which would have dynamic forms with custom fields. he can create one module, web form having some custom fields.So these fields can be created by customer itself through web application. To make this enable i believe I should have some tables to store meta data...

    SQLServer200810 pointsBadges:
  • SQL Server Database Restore

    When i restore a database from server1 to server2 as stand by/read-only mode the database restores with a database owner "domainrmartinez". How can i restore a database from server1 to server2 and the database owner as "sa"?

    Rick Martinez585 pointsBadges:
  • Adding data in SQL 2005 server

    i am trying to add data on an sql database from backend problem is it does not acceptnull values kindly help. My email address is edmuia@yahoo.com

    Zippyyepee15 pointsBadges:
  • SQL Server Database Date Time Values

    I am developing a software using Date Time values. i am using SQL server 2000 as the database. can i create a coloumn with only time value or data value. Only datetime is available. how can i eliminate a part of it in the database. when inserting the time values the date part is 01 jan 1900. i want...

    RAYNISH35 pointsBadges:
  • SQL Server error: Cannot find log file

    I am receiving the error, "cannot find log file." I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql in C#

    How can I attach And detach a database file to sqlserver in C# code ? please give me an example of this

    Sajjadzare5 pointsBadges:
  • Shrinking a SQL Server database

    What is the best way to shrink a database? What are the alternative methods?

    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:
  • Linked SQLServer

    Hi, In oracle database you are able to link the oracle database to a SQLServer 2005 database, I want to be able to link a SQLServer 2005 another SQLServer 2005 database (not another SQLServer 2005), does SQLServer 2005 allow us to do this? Does it only allow server to server linking? Thanks.

    Db23290 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