the problem is, how do I specify the Instances because "[Instance2].SourceDB.dbo.SourceTable" doesn't work. It has too many qualifiers. I think I add a linked server on my side. But how do I specify in one line which instance to use?
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
select * INTO [Instance1].targetDB.dbo.TargetTable from [Instance2].SourceDB.dbo.SourceTable What I would like to do is copy the table from one instance to another. How do I specify copying from one instance to another. I have already created the database. The target is Sql 2000 and I have full control. The source is Sql 2005 and I have only select permissions. How would I forulate a correct select into statement? Thanks, Nick
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
no. but try this link http://www.dotnet247.com/247reference/a.aspx?u=http://www.c-sharpcorner.com/Tools/MP3TagEditorB2PL.asp[^]
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
lol. Nah thier all elements. And actually it worked. I just had the wrong events. Thanks for helping tho
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
[ This has been answered ] My path is to ( my conditional ) /Events/CompanyABC/Transaction/ProductList/Product/Event/Code = 435 The actual node I want: /Events/CompanyABC/Transaction/ProductList/Product/LoanList/Loan/ReturnedType I tried this: //Events/CompanyABC/Transaction/ProductList/Product[./Event/Code = '435']/LoanList/Loan/ReturnedType But it doesn't return anything. How can I combine the conditional into the xpath statement. This has to be one string, I can't split it. Thanks, Nick -- modified at 13:04 Tuesday 24th October, 2006
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
Well I can ping msn from my router. I was just using it as a test. The real problem is that I cant receive packets from the outside through my bridge
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
I have a DSL connection, then it goes to a 2WIRE router that is set to a bridge. That connects to my LINKSYS wireless router and then my PC connects. DSL -- 2WIRE --- LINKSYS --- PC ( the PC is connected via cable tho ) I can use Internet Explorer to surf the web just fine but if I ping www.msn.com, I get a it times out every time. I disbaled norton and tyhe firewall on the linksys. I am running win2k. I cant access the 2wire since it acts as a bridge. Note: I can ping www.msn.com from the router, but not my pc Can someone please help? Thanks, Nick -- modified at 16:08 Saturday 14th October, 2006
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
I want something for my son to where I can make a program that shows a math problem like so 123 + 99 ===== on some sort of hand held. and allows him to draw on the screen so he can cross 3 and put 13. 3rd grade math. I am trying to keep this as cheap as possible. Anyone know of any brands under a $100? He doesn't need a keyboard, just the pen. And I don't need any phone capabilities either. Just the handheld with pen, thats all. Any suggestions would be great. I have an Axim, but theres no way hes uses it:laugh: Thanks, Nick
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
I have a public field in my class [XmlIgnore] public string MyVar; But at runtime I need to remove this decoration. Is there a way to remove it at runtime? I tried the attributes collection in the PropertyInfo. That doesn't work Or if I could add the XmlIgnore at runtime. That would work also. But, the attributes collection doesn't allow me to do such a thing
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
hello world I am trying to copy the entire web.config file and just change one value attribute to a particular entry. Here copy all, except if the key = web.Server Please help -------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog -- modified at 9:51 Friday 8th September, 2006
i have this I am trying to copy the xml document line for line. But it doesnt show the elements. Just the text within them. I want an exact copy of the file. Can someone please help Nick -------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
yes, and due to the architecture of the web. Knowing the actual computer ID is unreliable also. But you can still trace the IP to the origination IP. It all depends on how much effort you want to use.( there are tons of utilities that can trace this) But, using whois you can trace down the ISP and they usually use the same patterns for IP's. I was on a spam rampage and I can trace anyone back to thier orignal IP that the email was sent from. Even if its sent within IP hider types. And if this tells me thier ip location, so will the requesting machine. all you really need is the ISP server name and a few other bits which are inside the request header. Everything is traceable. There maybe hurdle, but tons of sites in the UK tell you how to get past anyone of them. IP or a mac address is your best bet. But, last time i looked at a header the mac address wasn't there. And due to security you wont be able to get it, unless you create an active x control to run on your page. Much like AJAX. Nick
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
lol. its a GetEnumerator(). Theres no definition like that. Type t = typeof(T); if( t.Equals(Category) ) I figured it out just a second ago Thanks tho
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
I have a class public class myclass : BindingList<T> {} I have created(shadowed) the GetEnumerator method to provide some custom sorting and what not. But the problem is the type can be Category, Topic, or Entry. And I need to test each one because each has its own sorting strategy. I tried if( typeof(T) is Category) but that doesn't work. What is the easiest way to determine the type T is?
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
Is there a function that will retrieve the pixel color on a daesktop location? Or a function that will alliow me to save the desktop as a bitmap?
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
nevermind. you create a filter style
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
check the ip address when signing in
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
just send it through as text or use SQLDMO
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
I have a TableRow TableRow tr = new TableRow(); I need to specify this row as a gradient from light gray to dark gray. Does any know the code to do that? server-side code only please.
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog
Is there a way I can extract the extact data type strings but sql via ADO.NET. I need to know the exact name of the data type from sql. I tried creating a data table and filling it, then examining the columns. But, only gives me a .net data type. For instance, smalldatetime is converted to DateTime. I need to know what it is before the conversion. thanks nick
-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog