MsSQL Software

is there any free web apps out there that can interface with an SQL Server in real time, like add, edit, delete, update and search the DB?Ummm yeah, any ideas?|||There's always Query Analyzer, the free query tool that ships with MS-SQL Server. Free to use as long as the server you connect to is licensed.

If you're looking for a non-MS tool, just google 'SQL Query tool' and you'll find lots of stuff or check tucows.|||Originally posted by loach
There's always Query Analyzer, the free query tool that ships with MS-SQL Server. Free to use as long as the server you connect to is licensed.

If you're looking for a non-MS tool, just google 'SQL Query tool' and you'll find lots of stuff or check tucows.

Thats not what I am talkin about, I dont want to find an SQL Query tool, I want a full GUI interface to control the DB. All the programs I found in google to view and export data. I dont want a program that just lets you control the DB via SQL statements alone...|||I guess I don't really understand what you're looking for. What is it that you're looking for that Enterprise Manager does not do?|||Originally posted by sabastious
Thats not what I am talkin about, I dont want to find an SQL Query tool, I want a full GUI interface to control the DB. All the programs I found in google to view and export data. I dont want a program that just lets you control the DB via SQL statements alone...

Hello.

See if this help... I have not tried it myself yet.

http://www.msde.biz/msdequery/download.htm|||Originally posted by sabastious
is there any free web apps out there that can interface with an SQL Server in real time, like add, edit, delete, update and search the DB?

myLittleAdmin : http://www.myLittleTools.net/mla_sql

This is a web-based GUI for MS Sql.

best regards|||You can link to your SQL Server database via a Microsoft Access database Access Data Project (.adp file extension) and control many things such as table, view, and procedure creation as well as data manipulation. It acts like a stripped down Enterprise Manager.

But again, why not just use Enterprise Manager?

blindman

MSSQL questions

1) I haven't seen any use of "SAVE TRANSACTION" in small to mid size apps. Is it used mainly in big and complex apps?

2) Given this linkhttp://www.databasejournal.com/features/mssql/article.php/3584751 about SQL2005. How can what the article presents be done in SQL2000?

Thanks.

SAVE TRANSACTION isn't normally used in small apps because you would only want to use it in a situation in which you have a subroutine that might fail, but you still want the transaction to commit. Small apps usually either have very small transactions (or none), and you either want them to commit or rollback as a single unit. I've used it in mid size apps where I was looping, doing some processing of for a batch transaction, and any loop may fail, but I needed it to skip the bad loop and continue processing. This isn't very common.

For example a batch load of (something), as you are looping through, Save trans, insert, save trans, insert (Insert fails) rollback, save trans, insert, commit.

Record #1, and #3 are commited to the database, while record #2 failed and was rolled back. Many times this type of logic can also be subdivided into separate transactions (BEGIN TRANS, insert, commit, begin trans, insert (fail), rollback, begin trans, insert, commit), but in some cases it can't. It's those rare cases in which save transaction is nice.

|||Please take a look at my second question and advise? Thanks.|||Can't really help you out there very much. In the past I've written my own .NET apps that monitored directories for file drops and sucked them into the database. Never used the bulk load stuff for that as I don't think it's a great idea to give access to the SQL Server itself for file drops.