• 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:
  • Row versioning in SQL Server 2005

    What is row versioning in SQL Server 2005, and how does it work?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SSIS – Bulk Inserts dynamically into various tables depending on the input file name.

    I have a scenario where a folder consists of various files with the format 'ABC_DbName_Date_TableName.txt' and there are many Databases with DBNames For e.g. - DB1, DB2 DB3 etc consisting of tables created every day with a 'Date_TableName' format. I need to provide a prompt to accept a folder name...

    NewLearnerSSIS5 pointsBadges:
  • database ownership won’t accept login

    I'm trying to assign an owner to AdventureworksDW so I may turn on database diagrams. Neither the GUI interface nor the 'Alter Authorization ...' method work. The sript approach reports success but whe reopened, the dialog still shows the property blank. Any ideas?

    Jsmaccready15 pointsBadges:
  • Errors: Violation of UNIQUE KEY constraint ‘UN_FILENAME’. Cannot insert duplicate key in object

    when i am migrating data from oracle9i to SQL2005 i am getting the error Errors: Violation of UNIQUE KEY constraint 'UN_FILENAME'. Cannot insert duplicate key in object how should i solve the problem

    Lava5 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:
  • Strange behavior in Access 2003 user interface

    I create a form in access 2k3 data project connected to sql server 2k5. I put two check boxes on my form. On runtime, when i click on one of check box, it also fires on the other check box...set check box value from false to true. But it works normally when i use keyboard shortcut to fire that...

    Ipong40 pointsBadges:
  • SQL SERVER 2005 MAINTENANCE PLAN PROBLEM

    HI, SQL2K5 Maintenance plan does not delete old backups even when 'backups older than 1 days' is selected.so my backups are piling up and have to remove them manulally everyday. any solution? Marshall

    Marshall01275 pointsBadges:
  • Data protection features in SQL Server 2005

    Can you explain data protection features in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Federated Fabric cluster

    Can any one help me out on how to setup a federated fabric cluster using SQL 2005 + windows 2003

    Henrywat4885 pointsBadges:
  • How to generate a column name in a table dynamically

    hi, I have to generate dynamic columns for a temp table. I have a temp table with column a, the column b should be generated based on a condition. B conditions are if value> 10 i have to genrate the column as 10 and if the value >20 the column name should be 20 etc....n values.... If i select...

    GIG240 pointsBadges:
  • Tuning a simple SQL statement in SQL Server 2005

    How would I tune a simple SQL statement, like "SELECT @eno = eno FROM emp WHERE dno = @dno," in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is there a way to make ODBC see SQL Server 2005 Synonyms

    I have created synonyms on tables in SQL Server 2005. Does anyone know of a way to make those synonyms available through ODBC for use in MS Access? I have installed the latest SQL Server Native Client development pack; but the synonyms do not show up in the list of tables when linking via ODBC.

    Randym1,740 pointsBadges:
  • Is it possible to copy system DBs to another server?

    Hi, I am at total lost at trying to copy system db(master, model, distribution, etc) from a 2005 server on one machine to another 2005 server on a different machine, so all the logins, job, etc are also copied to the new server. I have tried to google this problem and am at a lost to how to do...

    Db23290 pointsBadges:
  • Creating XML file using SQL Server 2005

    How to create a xml file using sql server 2005? what are all the steps to do for this?

    Sunithashree5 pointsBadges:
  • Improving the performance of full-text searches in SQL Server 2005

    Why does a full-text search perform so slowly in SQL Server 2005? How can i improve the performance, in general, of query results ?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Tracking Table Changes SQL Server 2005

    Is there a SQL Server 2005 script that would give all the table_names in a database, the last time they were updated and by whom? I've gotten as far as: select name, modify_date from sys.tables order by name but I can't figure out the "user" part.

    VelameLaCosa110 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:
  • Upgrading clustered SQL 2005 64 bit standard to enterprise

    Does anyone have any steps on how to upgrade a clustered SQL 2005 64 bit standard edition to a clustered 64 bit enterprise edition ??

    Gazzer5 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:

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