Silly Question - What Is 'YUKON'?

Nov 25, 2004

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.

View 2 Replies


ADVERTISEMENT

Silly Question - What Is This 'YUKON ??

Nov 25, 2004

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.

View 3 Replies View Related

Yukon

Apr 10, 2003

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

View 3 Replies View Related

Yukon

Sep 2, 2004

Are we supposed to post/answer Yukon-related questions/answers here or there will be a dedicated forum for it?

View 3 Replies View Related

Yukon

Jan 12, 2005

Hi 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!

View 3 Replies View Related

Yukon

Jul 20, 2005

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 Related

Connecting To Yukon Db

Dec 22, 2005

Hi 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 Related

Sp_replALTERcolumn ??? YUKON ????

Nov 17, 2003

Hi 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!!!!!

View 8 Replies View Related

Migration To Yukon

Jul 18, 2006

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

View 3 Replies View Related

Connecting Sql Server Yukon

Aug 19, 2004

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.

View 4 Replies View Related

Yukon XQuery Question

Jul 27, 2005

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 Related

Yukon's Transactional Replication

Dec 2, 2005

Hi yukon gurus,

View 7 Replies View Related

Yukon BIDS Package Variables

May 25, 2005

Hello,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 Related

I Want To Download A Sql Server 2005 Yukon

May 21, 2004

Does anyone hava the URL?

View 2 Replies View Related

How To Detect The SQL Express & Yukon Installation

Nov 10, 2005

Hi,

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

View 1 Replies View Related

Yukon - Will It Support Sequence Object?

Jul 20, 2005

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 Related

Embedded Text Qualifiers No Longer Supported In Yukon ?

Oct 19, 2005

Hello,

View 1 Replies View Related

This Is So Silly

Jul 1, 2004

I Imported a table over to sql 2000 server(through the DTS), then I exported the table to access 2000. After creating my forms my users were trying ot add data but couldnt, they kept getting an error message saying these records are not updateable. After some research I found that I never appointed a primary key, so after doing so the records became updateable. constant learning process adn I love it :)

View 7 Replies View Related

Silly BAcKUp Log Is Too Big

Jun 11, 2001

Is there a way to restore just the data.mdf file and accept an existing log?

Current state: A client has a backup where the data file is 400mb and the log is 4.99gb. The avaiable hhd space is 6gb.

Restoring the backup to a test database fails.

Objective: Check the calendar file for missing data, and if found, update the live calendar with the missing items.

We don't need the database to be fully operational, we only need a particular table. I'll write a cursor if needed to update the live cal from the restored backup.

I suspect that the available diskspace is causing the retore to fail.

TIA

View 3 Replies View Related

I've Done A Very Silly Thing And Need Help

Mar 25, 2003

After being put in a position where I had to deal with a SQL problem without very little SQL knowledge I have screwed a clients main database up.

I backed up the transaction log and then deleted the log. The database is shown as suspect and won't let me restore.

Am I F&%ked?


Any help in sorting this out will be rewarded with much kudos and thanks

View 12 Replies View Related

This Is Probably A Silly Question

Jul 8, 2004

I wanted to create a table with an exsisting table, then create a relationship between the two. The table being created needs a DocID autonumbered primary key, is that possible to create through sql. An autonumber like access has, through a query or something. should I just have a insert into query or something?? how would I go about doing that.


Goodmorning Guys :)

View 3 Replies View Related

Silly Question

Jul 22, 2004

I can execute a stored procedure I created in the Enterprise manager cant I??

View 8 Replies View Related

Silly Question Here

Jan 23, 2006

Yes this is a silly question, but I don't know the answer!

I have developed a database using SQL Server 2K. I am now upgrading to SQL Server 2005. Can I still use my current database files in SQL Server 2005? If I can, do u have any idea how I can make SQL Server 2005 load up the old files and start working?

Also my hosting provider has NOT upgraded to SQL Server 2005. He will only accept the old SQL Server 2K files. Can SQL Server 2005 save files that will work on a SQL Server 2K server?

Thank you!!!

View 7 Replies View Related

Silly Question

Mar 16, 2007

Hi all. I think its a silly question to ask. What is better to use? I mean in terms of performance.
c.* or c.field1, c.field2, c.field3, c.lastfield..... ?

thanks
-Ron-

View 2 Replies View Related

Silly Question

Jul 20, 2005

HiI've not used SQL Server for a while, and I've forgotten how you hide allthose system procedures (beginning with dt_) in Enterprise Manager.Could some kind person please refresh my memory?ThanksCaptain Nemo

View 2 Replies View Related

May Be A Silly Question,but.....

Mar 3, 2008

In a situation when you have a power cut, and then sometime later 'most' of your sql servers come back on line, is it better to leave them all down unless they all come back online, or is it better to let some of them come back up knowing that the ones that do come up will have job failure issues with the ones that are down. I pose this question purely from the perspective of scheduled job problem as we do not have people on site when we have intermittent power cuts at weekends. What would scheduled jobs which are due to run , but miss their run time as we leave the servers down after a power cut till we get back in on Mondays do when we do actually re-power them up, would they just resume from their next scheduled point, or would they try to run as often as they should have run?

Dave

View 3 Replies View Related

Silly Question...

Apr 24, 2007

Hi everyone,

Inside a Script Task I€™ve got this line:

Dts.Variables("Var1").Value = Dts.Variables("Var2").ToString

After that, I get this value for Var1:
"Microsoft.SqlServer.Dts.Runtime.Variable" {String}
String: "Microsoft.SqlServer.Dts.Runtime.Variable"

Does anyone have any idea about the hell is happening here?

Both of them has been defined at the same scope and own String as data type

Thanks in advance and regards,

View 3 Replies View Related

Silly Sql Problem

Oct 11, 2007

I will give you the simplest version of this I know if.

I have 3 tables.

Person Table
PersonID, Forename, Surname

Event Table
EventID, EventName


Involvment Table
PersonID, EventID

In this, the Person table's primary key is PersonID, the Event table's primary key is EventID and the Involvment table's primary key is PersonID, EventID.
There is also a foreign key constrant between Person.PersonID and Involvment.PersonID and a foreign key constraint between Event.EventID and Involvment.EventID.

The sql to create this would be


CREATE TABLE [dbo].[Person](

[PersonID] [int] NOT NULL,

[Forename] [nchar](30) NOT NULL,

[Surname] [nchar](30) NOT NULL,

CONSTRAINT [PK_Person] PRIMARY KEY CLUSTERED

(

[PersonID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]



CREATE TABLE [dbo].[Event](

[EventID] [int] NOT NULL,

[EventName] [nvarchar](50) NOT NULL,

CONSTRAINT [PK_Event] PRIMARY KEY CLUSTERED

(

[EventID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]



CREATE TABLE [dbo].[Involvment](

[PersonID] [int] NOT NULL,

[EventID] [int] NOT NULL,

CONSTRAINT [PK_Involvment] PRIMARY KEY CLUSTERED

(

[PersonID] ASC,

[EventID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Involvment] WITH CHECK ADD CONSTRAINT [FK_Involvment_Event] FOREIGN KEY([EventID])

REFERENCES [dbo].[Event] ([EventID])

GO

ALTER TABLE [dbo].[Involvment] CHECK CONSTRAINT [FK_Involvment_Event]

GO

ALTER TABLE [dbo].[Involvment] WITH CHECK ADD CONSTRAINT [FK_Involvment_Person] FOREIGN KEY([PersonID])

REFERENCES [dbo].[Person] ([PersonID])

GO

ALTER TABLE [dbo].[Involvment] CHECK CONSTRAINT [FK_Involvment_Person]


As so obviously stolen from SSMS.

Now what I am having problems with is if someone is involved with more than one event, then I only want them to get listed once.

If we have the following in the Person table.





0
John
Doe

1
Jane
Doe

the following in the events table





0
This

1
That

and this in the Involvment table





0
0

0
1

1
1

then when doing any select using the Involvment to get name and event information from their respective tables, there will be two entries for John Doe. I don't want this if it is possible. Although the same event multiple times is ok in this case.

So, if someone could help with this then it will be greatly appreciated. I'm still not that great with SQL so this is a problem which has been annoying me.

View 4 Replies View Related

Is This A Silly Way To Use SSIS?

Mar 1, 2006

I have typically done any ETL style manipulations I needed to do to data stored in SQL Server in VB.NET. I would use the IMPORT?EXPORT DTS wizard to import flat files, or mabe something from ACCESS every now and then.

I am looking at a situation in my current contract where I will be pulling flat files from a mainframe and quasi relational stuff from a DB2 instance via an ODBC connection. I will be using this stuff to build a datawarehouse for a manufacturing client.

My question is this. Is there really enough good stuff in SSIS for what I will be doing to justify my learning it or if I'm comfortable doing the manipulations in VB.NET will that work just as well for my client? After all, I can schedule VB.NET apps to write results to log files and to run at specified times, etc. It just sort of always seemed to me that DTS was for people that needed to manipulate data without necessarily having to know a lot about programming per se.

I'm looking for opinions from people that know SSIS well. Is there enough meat to make cooking the SSIS meal worth the trouble?

Thanks in advance for any info.



View 4 Replies View Related

Silly Question Please Help

May 7, 2007

As i am inserting data from textfile to sql server database i happened to have space Like a square appears in front of data for certain columns.How do i remove that????I use Trim(column) for all incoming columns but it does not work.

View 3 Replies View Related

A Silly Question!

Oct 19, 2007

What is the function of SQL Server Manager Studio Express?
Create Database and tables?
It seems that Visual Studio is already including the functions.
We can create database and table in Visual Studio 2005.

I am a new to SQL, sorry for the silly question.

View 10 Replies View Related

Help Needed On A Silly Query :P

Aug 26, 2004

hi ...
i m a new member
i want a help on this query(new user of sql :D )
yaa and the query is

create a rule and attach it to the service_code(column) of airline_service(Table) alow only the values 'cc','n' and 'wc' to be entered into the column

plz tell mee... :confused: ..i wlll be gr8 fulllllllllllllllllllllllllllllllll ;)

View 6 Replies View Related

Simple And Silly SQL Puzzle

Mar 31, 2004

Hello SQL Gurus,

I want to dynamically add a column to a select statement who must contain the line number.

Example :

Some table has 3 columns (id,field1,field2)


SELECT top 3 *,[lineNumber] as lineOrder FROM someTable

must produce

id | field1 | field 2 | lineOrder
-----------------------------------
1 abc def 1
23 def ghi 2
7 ghi jkl 3

and so on... Possible ?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved