• Clustering in SQL Server 2005/Windows Server 2003

    Does clustering become Active/Active when using SQL Server 2005 and Windows Server 2003?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Scheduling errors after moving a SQL Server to a different domain

    We run SQL Server 2005 on Windows Server 2003, and we have put our server onto a recently changed domain. Since we’ve done this, we’ve had numerous problems running reports. The latest issue has been that as soon as we start the Internet Information Server (IIS) website to access the reporting...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases?

    In SQL Server 2000, you can use a backdoor to create your own view in INFORMATION_SCHEMA... In SQL Server 2005, I get a permissions error though. Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases like the INFORMATION_SCHEMA views? Thanks...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Storing text documents in tables in SQL Server 2005

    I have a table in SQL Server 2005 which is used to store text/word documents, and I have enabled full-text search on the column and included a corresponding document type for the document. The problem is when I upload a real NotePad Text/MS Word document saved from the NotePad/MS Word application....

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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:
  • Moving SQL 2005 databases with no downtime between servers

    We have 2 SQL 2005 servers and would like to move the database and the logins and passwords from server to server. I ran backup and restored the full database with no recovery mode which allow me to copy the transaction logs then I transfered the logons and ran sp_change_users_login to associate a...

    Theitman25 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:
  • slow outer join after delete rows

    Hi, I've tried this on two installations of SQL Server 2005 service pack 2. If I delete rows of a table, an outer join on the empty table is extremely slow...if I truncate it's ok, if I delete with the tablock hint it's ok. Any ideas why? The code to reproduce this follows, the outer join takes...

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

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