Hi,
Anyone kindly let me know more and clear details about the below 2 statements
1.Remove reference to undocumented system tables/stored procs
2. Remove statements modifying system objects
as are not supported in SQL Server 2005. while migrating from sql server 2000 to YUkon (sql server 2005) the above 2 points need to be taken care. but no much clarity on the above.
kindly help me
Regards
Crish
If anybody willing to share the features, softwares, experience of the YUKON Beta release, please post it here or email me to mak_999@yahoo.com
Just like/want to feel the essence of YUKON.
Some links I found
http://www.microsoft.com/sql/evaluation/yukon.asp
http://advisor.com/doc/09056
http://www.eweek.com/article2/0,3959,687391,00.asp
Are we supposed to post/answer Yukon-related questions/answers here or there will be a dedicated forum for it?
View 3 Replies View RelatedHi folks, i've installed sql 2005 express edition; after downloading the express manager and running it. i get the following error:
TO RUN THIS APPLICATION, YOU FIRST MUST INSTALL ONE OF THE FOLLOWING VERSIONS OF .NET FRAMEWORK: V2.0.40903
I've the lates version of .NET FRAMEWORK from microsoft download.
Please guide!
Howdy!
Hallo everyone,is there someone who is partecipating to the Microsoft Yukon Beta testand who can send me some picture of the new GUI of Enterprise Managerand Query Analyser?Send it at my own e-mail Join Bytes!ThanksLorenzo Braidi
View 5 Replies View RelatedHi all,This should be an easy question to answer...I'm trying to connect to my SQL Server 2005 (running on localhost) from the code-behind of a test webpage that I made. The connection string I'm using is:Data Source=localhost;Initial Catalog=dbname;User Id=username;Password=password;Timeout=160I think the reason I'm confused is that I can't create a user in Yukon like in 2000, assigning it a username and password. In Yukon, there's no option to create a password for a user... I saw that I can create a username and password if I create an application role, so is this what I'm supposed to use?Whenever I create a user or application role and try to connect to it w/this connection string, I get:No process is on the other end of the pipe.If I make the user or application role the owner of the db_owner schema then this error message goes away but I then get:Invalid login for user ____I already made sure that I have tcp/ip and named pipes enabled for local and remote conns.Lastly, when I create a user, I have to give it a login name, which is a windows user account, so I have no idea what to put for that.So I guess my question is, what is the proper way to set up a user or application role in sql server 2005 and then be able to connect to it w/ado.net 2.0?Thanks,Justin
View 3 Replies View RelatedHi Guys,
Would anyone know or have heard of any rumours if the the next version of SQL - YUKON will support 'ALTER COLUMN' without having to DROP THE SUBSCRIPTION & THEN MAKE THE CHANGES THEN RE-SYNC ???
It would be nice if i we would not have to do all that just to say .... change a column data type!!!!!
Hi,
I have come across this term (YUKON or something like that). Is this the 'code name' for the next version of SQL server which is yet to be launced??? Can someone help me provide links to some articles on it.
Many TIA.
Folks, i've just installed the express edition and have enabled all the protocols within the COMPUTER MANAGER. When i try connecting the INSTANCE through QA or EM, sql doesn't exist or access denied.
I've installed the default instance.
Please guide.
Hi,
I have come across this term (YUKON) or something like that and assume that this is the "code name" of thenext version of SQL server (i.e. 2005) thatis yet to belaunched. Isthis correct? If not, can someone please explain what YUKON means/stands for.
Thanks.
I am trying to query data in an XML variable and I am having troublegetting the data out in the format that I would like. Given thefollowing XML:declare @myDoc xmlset @myDoc = '<OwnershipTeamGuid="23EA393A-3926-4A55-8329-FE747593379D" TeamName=".NETFramework"><Roles><Role Guid="93BDB4E2-95A0-438D-96E4-43032EB2BA16" Name="API ReviewPM Contact" ContactAlias="John.Smith" Inherited="0" ArtifactName="" /><Role Guid="8A7145EF-B48B-4A93-BFA5-28B53995C022" Name="Architect"ContactAlias="John.Doe" Inherited="0" ArtifactName="" /><Role Guid="BF727283-B18C-415A-A38C-CEC15CD341D9" Name="Corp VP"ContactAlias="None" Inherited="0" ArtifactName="" /></Roles></Ownership>'What I would like to do is run an XQuery against the variable and getattribute data back in normal rows and columns like the following:Guid NameContactAlias------------------------------------ ---------------------------------93BDB4E2-95A0-438D-96E4-43032EB2BA16 API Review PM Contact John.Smith8A7145EF-B48B-4A93-BFA5-28B53995C022 Architect John.DoeBF727283-B18C-415A-A38C-CEC15CD341D9 Corp VP NoneI've checked the Query and Value methods and have not been able to getthem to do this for me. Is this even possible w/XQuery? Do I need touse OpenXML to do what I am trying to accomplish?Thanks for your help!
View 2 Replies View RelatedHi yukon gurus,
View 7 Replies View RelatedHello,I'm using BIDS to create a package, and I need to pass in a variable value; how does this new DTS process work, in deploying the package and passing in a custom value at runtime?Thanks.
View 2 Replies View RelatedDoes anyone hava the URL?
View 2 Replies View RelatedHi,
I have a need to check whether SQL Express 2005 or Yukon is installed on a machine or not.
Can anybody suggest what is right method to check the existence of these installations.
If possible suggest the registry keys which can be used for this installation check.
Thanks a lot
krishna.s
I did some search and didn't find anything about whether Yokon willsupport sequence object. Appreciate it if you can reply with someresources.Thanks, James
View 6 Replies View RelatedHello,
View 1 Replies View RelatedI have developed a database on my local machine using MSDE. I am using Visual Studio.net to add tables/stored procedures to the database. I have created asp.net pages. I need to get this database on a web server that runs Enterprise SQL Server. Can I just use the 'sp_detach_db' and 'sp_attach_db' to move the database between servers?
View 4 Replies View RelatedHi Everyone,
I am migrating my old sql server database to the new hardware, in the processes I migrated all the databases from old sql server 7.0 to new sql server 7.0, and also generated the scripts for all jobs and executed in the new server, all the jobs appear but when I go and see in the job steps, I don't see any steps in the jobs, I tried different ways but I am not able to get the steps.
Can any one help me out..............
I have about 160 jobs so I cannot make new steps for each and every job.
Thanks in advance.........
Regards,
Madhuker.
Hi Everyone,
I am migrating my old sql server database to the new hardware, in the processes I migrated all the databases from old sql server 7.0(All tables from MSDB Database, sysjobs, syshistory etc) to new sql server 7.0, and also generated the scripts for all jobs and executed in the new server, all the jobs appear but when I go and see in the job steps, I don't see any steps in the jobs, I tried different ways but I am not able to get the steps.
Can any one help me out..............
I have about 160 jobs so I cannot make new steps for each and every job.
Thanks in advance.........
Regards,
Madhuker.
I want to do a data transfer but i am not sure how ..from oracle to sql server.
i want to know if its required to install the oracle client to configure so as to transfer data or not.
I heard from someone that if we change the win.ini file entry for oracle.ini and place the tnsnames.ora file i spcified location it will work but it does not what is the way to deal with..
How do i perform this with the odbc configuration for oracle..and use the same in the dts.
Thanks in advance.
Hi Every one,
I am upgrading from one computer to another.
I have few questions.
1. Is it neccessary to run the SQL Services on Domain User Account on both machines or on 6.5 machine.
2. How to check the all User logins exists in Master database.(I read in BOL that all user logins must exists in Master Database)
3. How much time it will take to complete for 10 GB database.
Please give me anohter suggetion which will help in this regard.
Thanks,
Dindu.
Can any one tell me the steps to migrate sql server 7.0 from one server to another server(Production databases). Its a 24x7 shop. The down time should be minimal. Iam looking for a most efficient way of doing that.
View 1 Replies View RelatedIs it possible to migrate SQL Server 6.5 to 2000? We have an ACtive/Active Cluster Environment. It it's possible, please give me a brief guidance on how to go about it. Thanks for your help.
View 1 Replies View Relatedhas anyone migrated a ms sql 6.5 server to a mssql server 7.0
on 2 different machines? and if so how the heck didja do it?
the 7.0 server keeps telling me that it cant do it until the 6.5 server
is upgraded.....help...help....help....the 7.0 server has the 6.5 one registered it just wont connect to it....tells me that it has to be a 7.0 server.....help
thanks
tony
What are the differneces between using Backup/Restore vs Copy Database Wizard when Migrating a SQL Server 7.0 Database to SQL Server 2000 ?
View 2 Replies View RelatedI have to migrate INFORMIX database to SQL Server 7.0 and I was wondering if there is anyone out there with any experience? I want to know the procedures and how to go about it towards a successfully INFORMIX migration to SQL Server. I look forward to hearing from you.
Regards,
Hi,
Does any one aware of any tool for sybase to ms-sql migration, which will migrate store procedures/triggers from sybase to ms-sql server 2000.
Thanks
Vaishali
Dear Experts
Can any one please help me in MIGRATION of table from Foxpro 2.5 and MSVisualFoxpro 6 to MSSqlServer 2000
I had a large no of table in foxpro now i want all of them in SQL SERVER 2000
Thanks and Regards
Hi There,
Greetings! Many of my clients are on SQL 7.0 (Win NT) and want to upgrade to SQL2K (Win 2003). We have approximately 1200 Stored Procedures (SPs) per module.
Our porting exercise involves changing keywords of SQL 7 to SQL2K (eg. LTRIM, RTRIM, GROUP BY etc).
Is there a tool available online which can run thru the SPs and do the porting job? Otherwise I have to hand-code these changes
Also, has any one out there done this exercise before? What are the things to lookout for to avoid goofups?
Thanks in advance
Hi evrybody,
I have been trying to migrate MY SQL to MSSQL and somehow cant do it.
I tried making Dsn for both of them, but the DTS wizard doesnt recognize MYSQL .
DOes anybody knwo how to do this?
thanks
We have a SQL 7 server SP3 which we want to replace. The initial planis to create a new SQL 7 server and restore the database backups.My first question is there any need to restore the master databaseonce all the other db's are copied.We had planned to copy the databases and the msdb.Do all the DTS jobs, users, security etc come over in the msdb.Also is there any reason why we shouldn't upgrade to SQL 2000, arethere any compatiability issues with restoring the SQL 7 databasebackups to the SQL 2000 server?Ed
View 1 Replies View Related
Hi,
How to migrate scheduled jobs from 2000 to 2005. Is this possible by doing bcp out and bcp in system tables which stores sql agent jobs from msdb database ?
Regards
Nit