• Unable to Restore Backup in SQL Server 2005

    I am unable to RESTORE Backup through code in SQL Server 2005 from VB.Net, even though that code is running fine in SQL Server 2000. The code is: "restore database [" + databasename + "] from disk ='" + Me.lblSource.Text + "' with move '" & dfile & "' to '" + Me.lbldatafile.Text + "'," & _...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrading from SQL Server 2000 to SQL Server 2005

    I have been offered a free upgrade to SQL Server 2005 Express Edition, but I am very pleased with my current version, SQL Server 2000. If I decide to upgrade, will I have any problems with our network? We use languages like C# and Visual Basic often.

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000/2005 Transaction Logs

    Quick Ques. Are transaction logs cummulative? If I have a database set to Full recovery mode; database being backed once a day and transaction logs being backed up hourly, if the database needs to be restored, can I just restore the last transaction log file? Will the last transaction log file...

    JCDBA20 pointsBadges:
  • Writing a query in SQL for use in SQL Server 2005

    I’d like to write a query that would allow me to view items with a characteristic of my choosing and filter out the others. Is it possible to write something like this in SQL and use it in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Linked server error message on a SQL Server 2005 machine

    We are installing a vendor-developed application that requires linked servers between the vendor database’s server and many of our other servers. It has been set up and tested effectively, but it should be noted that it is a double hop to the servers. Server A (which houses the application)...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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:
  • Manually migrating databases from SQL Server 2000 to SQL Server 2005

    I am manually migrating a large number of databases from SQL Server 2000 to SQL Server 2005. What kind of issues should I expect, and do you have any readily available solutions?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to move a DTS from sql 7 to a server running sql 2005?

    I have several dts packages that are running on a sql 7 server, I need to move them to a server running sql 2005. Any suggestions on how to do this? Thanks

    Bubbanm90 pointsBadges:
  • Impact on TSM backups after an upgrade to SQL Server 2005

    What would the impact be on TSM backups if I undertook a side by side upgrade of SQL Server 2000 SP4 to SQL Server 2005 SP2?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server Upgrade and Server Move

    I have an old Windows 2000 server running SQL 2000 and need to retire the server and move my SQL databases to a new server. The new server is a fresh install of Windows Server 2003 and SQL Server 2005. I am having a hard time finding a procedure for this complex conversion. Is this something that...

    RussGunther5 pointsBadges:
  • Read Only Table

    I create a table in sql server 2k5, the script is look like this: CREATE TABLE [dbo].[tb1PmtD]( [PmtDLU] [int] NOT NULL, [PmtDInvLU] [int] NOT NULL, [PmtDAmount] [money] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[tb1PmtD] WITH NOCHECK ADD CONSTRAINT [tb1Pmttb1PmtD] FOREIGN KEY([PmtDLU])...

    Ipong40 pointsBadges:
  • SQL Database Migration Process

    Hello, I would please like to know if someone could help me out with a database migration issue.I have a server and i need to migrate all of my data on my current database to a new database.It seems that the new database might be a little different in structure and the tables generally so i would...

    Absorbed5 pointsBadges:
  • Error message on versioning in SQL Server 2005

    I’ve received this error message on SQL Server 2005: "Version store is full. New version(s) could not be added. A transaction that needs to access the version store may be rolled back. Please refer to BOL on how to configure tempdb for versioning." What exactly is version store, and do I need to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Moving a DTS package to SQL Server 2005

    I would like to move a DTS package created in SQL Server 7.0 to SQL Server 2005, as we are in the process of migrating the server. Can anyone offer me advice?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Cold Fusion 8.0 + Memory Issues

    Hi, I am hosting a cold fusion application which was developed in version 6.1 in CF8 server. There is a application variable which is set to a value of 1000 in the Application.cfm and we invoke components and have a loop till the max value of this variable which runs a sp on SQL Server2005. The...

    Vidukarth25 pointsBadges:
  • query of query errors

    I have a runtime query of a query error as below. java.lang.String cannot be cast to java.util.Date But the output format is correct and is in date. This application was developed in coldfusion 6.1 and sqlserver2000. But now we get this error when it was migrated to coldfusion 8 and sql server...

    Vidukarth25 pointsBadges:
  • i want to send sap idoc to sql server 2005

    I have one application in sap which takes sap data into idoc and want to send in sql server 2005

    Vimalshah5 pointsBadges:
  • Saving Query results into Excel format

    How can I save query results into .xls format directly from Microsoft SQL server Management studio?

    Preetg5 pointsBadges:
  • Error message during database mirroring on SQL Server 2005

    I am trying to begin database mirroring in SQL Server 2005. I have Service Pack 2 installed, and I have three instances running. When I attempt to start mirroring, I receive the error message, “One or more of the server network addresses lacks a fully qualified domain name.” My network...

    SQL Server Ask the Experts2,585 pointsBadges:
  • BCP and SQL2005 collation issues

    I get this error: Error = [Microsoft][SQL Native Client]Unable to resolve column level collations SQLState = 01000, NativeError = 5701 I am using the standar collation that comes with SQL2005

    Jmead5 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