• Systems Management Server 2003 with SP3 and SQL 2000 sp3a advertisements at logon question.

    I've deployed SMS 2k3 with SP3 and SQL 2000 sp3a. My issue is with Advertisements that I want to run at logon. I have some Advertisements working fine at logon. When I create a new one, I need to have two entries in the mandatory field. one for logon and the other at an interval..(Strange) if I log...

    WinIT ATE110 pointsBadges:
  • sql 2005 log shipping versus DoubleTake for MS SQL 2005

    We were going to use log shipping from a cluster back to a dr site in a different city. Our network Operations folks want us to use a product called DoubleTake for MS SQL 2005. Anyone had any experience or insight with this. Log shipping has worked for us for 8 years, and if I am going to change I...

    tcstl95 pointsBadges:
  • How do I move all stored procedures to a new SQL server?

    I recently moved a database from SQL Server 2000 to a new server running SQL Server 2005. Is it possible to move all of the stored procedures to the new server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Learning SQL 2005/2008

    I would like to start from the grounds up in learning SQL 2005 and 2008. Any recomendations? I have been working with databases for sometime now including SQL 2000, but I have not jumped to anything newer. Thanks.

    NKaram5 pointsBadges:
  • Create Information_Schema view

    Back in 2k, there was a backdoor that allowed you to create an INFORMATION_SCHEMA view. Backdoor yeilds a permissions error in 2k5. Is there any way to create a view in Master that would be accessabile from all databases like the Information_Schema views? Thanks for the help... --Jeff Moden

    Jeff Moden30 pointsBadges:
  • How to transfer encrypted data between SQL Server 2005 and SQL Server 2000

    We are a retail/web/phone order store. We process credit cards for all three stores at our retail location. We have our web data stored offsite on the web server, using SQL Server 2005. We have our retail/phone order data stored onsite in SQL Server 2000. I'd like to add a function to our MS Access...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Unable to execute the saved SSIS package.

    I have two servers server1 and Server2 both has SQL Server 2005 installed.Server1 has Enterprise Evaluation Edition SP1 and server2 has Workgroup Edition SP2.Since server2 has workgroup edition I cannot open the saved SSIS package in server2. So I connected from server1 created a DTS package and...

    MNA20 pointsBadges:
  • Decreasing CPU usage on SQL Server 2005

    My SQL Server 2005 is installed in Windows Server 2003. CPU usage is always 90-100%. If more users connect to this SQL server using their local Management Studio, then the server will become very slow. Can you please tell me how to decrease CPU usage on this SQL Server – is there a step-by-step...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How SSIS works with cluster SQL and non cluster SSIS service?

    According to microsoft, we can cluster SSIS service but it is NOT RECOMMENDED. http://msdn2.microsoft.com/en-us/library/ms345193.aspx Now this is the situation that I have where I need to understand how SSIS works? Enviornment: Active Active cluster enviornment for SQL server with SSIS server...

    Munnu5 pointsBadges:
  • sql server errors………..

    hi I have 2 questtion: 1-After I installed the sql server 2005 enterprise on my server there isn't the sql management program in the program list of sql serevr 2005!!!!!!???? so I should installed the developer version of sql server 2005 on my winxp cleint and connect to server and work with sql...

    Aliyani265 pointsBadges:
  • Merge Replication Identity Ranges

    What should the publication range and subscription range be set to for each table with identity ranges, bearing in mind thousands of changes can go into some tables each day. I have 1 Publisher and 9 Subscriptions (Merge) and have started getting "The Publisher failed to allocate a new set of...

    Ramapa25 pointsBadges:
  • Restoring a SQL Server 2005 IBM Rational RequisitePro database from SQL Server 2008, back to SQL Server 2005

    I have installed a SQL Server 2005 IBM Rational RequisitePro DB into my local SQL Server 2008. Can I restore this database back to the SQL Server 2005 box? I know this was a problem when going from SQL Server 2005 to 2000.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is it possible for named instances to share components in SQL Server 2005?

    Is it possible for two named instances to share components in SQL Server 2005? I’m aware multiple instances have their own components, but is there any way these can be shared to reduce overhead in SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I bring a .dat database file into SQL Server 2005?

    I need to bring a .dat database into SQL Server 2005. When I right click on database and Task, I don’t get the "Copy Database" option. What do I need to have this? What is an alternative method to bring the SQL Server 2000 database into SQL Server 2005 Express?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql 2005 db security for public

    I have databases that were converted (by restore) from sql 2000 to sql 2005. I found a script to move the logins (all using nt/sql auth) to the 2005 box. All the users on the sql 2000 box belonged to public on the old box. If i loook at the users inside the db's on the 2005 box (no public) they are...

    tcstl95 pointsBadges:
  • Connecting from VB6 to a remote Oracle Database

    We are a SQL 2000 Database shop using Visual Basic 6.0 & Windows 2003. I need to develop an application that can access an Orcale database on a remote system (sight to sight VPN in place) using SQL. I retreived some information yesterday that enabled me to construct the connect statement in our...

    Gcasner5 pointsBadges:
  • Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?

    Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005

    Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005

    LindaLawson10 pointsBadges:
  • Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded

    Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded

    LindaLawson10 pointsBadges:
  • Settng Memory Sql Server 2005 SP2 64Bit

    Hi I've a SQL Server 2005 sp2 64bit , i have to set memory and my server has 12gb fisical memory and 20gb paging file, what is the best pratices to set sql server memory for best performance? Thank You Best Regards Vincenzo

    Nuanda777720 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