Database

I need to generate Mac address because we Program a Mac address in different kind of PCB's (like network cards) We want to trace the Mac address that we program in the PCB's. We get difefrent ranges that we use for that.

* Go to the object explorer (from the menu "View", "Object Explorer") * Go to the "database" node of the treeview and select your database. * Right-click the node and select the item "Tasks" and from there the subitem "Export Data". * Click next, and select the database from SQL Server that you want to export from. * Click next, and select "Microsoft Access" as your destination. You'll probably need an existing database. * Follow the wizard until finished with exporting :) I are Troll :)

Is it Related to Database :confused::confused: Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

It looks, feels and smells like a string containing RTF codes; why wouldn't you just get it like any other string field and either assign it to a RichTextBox.Rtf, or write it to a file (preferably with extension .rtf)? :) Luc Pattyn Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you. Local announcement (Antwerp region): Lange Wapper? Neen!

You have already asked this question and had correct replies. A database does NOT guarantee the order records are returned in UNLESS you have an order by clause. If there is a clustered index or primary key then this is the default order, but even then it is NOT guaranteed (certanly by SQL Server) as when you have multiple worker processe, unless an order by is specified he results are returned as each worker process completes, which MAY not be the expected order. If you hav any further doubts try reading up on it, there are thousands of articles on google Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Can you tell me how to proceed(Using SQL job) with a CSV file please? Thanks & regards Payal

thx, i think link can help me alot Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan

Vishnu Nath wrote: But its fuctioning and understanding is important while building a database driven web application. So you need to do more research than you will get from asking in a forum. Buy a few books on your chosen database (SQL Server, Oracle etc) and investigate further. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

zeusToronto wrote: Values do come from linked server Is that tested from within the trgger or just as a piece of sql? Based on your reply, if you hard code it or get the values from a local table it works, the only time it doesn't is when you get the values from a linked server in the trigger. The only cnclusion you can draw from this is that the linked server fetch is not working in the trigger. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

... I meant this star: 'SELECT * FROM tstadvdbf.ASFSTAG0' maybe if you reduce the fields it will cut out the field causing trouble. Some other ideas: 1. Compare the query plan for the working and failing case and see if there is any difference (for the linked server part of it) 2. try select * into table from yourview (I know know its a star ;P ) and see what data types you get in the new table. Maybe this will shed some light on it.

Yes all of those databases allow you to 'password' protect yuor database in some manner, but the DBA on site always knows this password.

I don't think you can call them "Urgent!" However you could call them "Urgent1", "Urgent2", "Urgent3", etc. A database wouldn't be very useful if you couldn't name your tables, would it? :) Luc Pattyn Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you. Local announcement (Antwerp region): Lange Wapper? Neen!

The 4 different configurations can all be put in 1 XML file? Any ideas would be gladly received.

rupal2 wrote: trigger in mainserver rupal2 wrote: main server is off = No chance to fire the trigger. The local server isn't going to clone everything that the mainserver has. If the linked server is down, then everything within that server is down too. Your options are relative limited; you could try to move the trigger to your local database, or turn on the main-server. I are Troll :)

AFAIK SQL Server applies it before or after the join depending on what it thinks would give you the quickest result.

Jeff has moved my reply to the MySql forum. This message will autodestruct in a few days, provided no one replies to it here. :) Luc Pattyn Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you. Local announcement (Antwerp region): Lange Wapper? Neen! modified on Friday, September 18, 2009 1:45 PM

these might be helpful exec sp_who exec sp_who2 exec sp_lock exec sp_monitor Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

but they are free for students https://www.dreamspark.com/default.aspx[^] Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

You might instead have a dummy location for the from value, e.g. "thin air".