freitasm

Thank you guys... Output to a table would work as well. I will contact you later. Cheers

Hello guys Is there anyway to get text output from a SQL DB? For example the top 5 most recent messages posted in a table? I want to monitor as messages flow... This is strictly string stuff. Cheers

Thanks, done!

Hmmm. I have the unlock code for a full version, but I did not download from that e-mail - I only took note of the code and deleted it. Now I see the trial installer only accepts trial codes - unlike other software that actually have a single installer. So, could someone please point me out to the correct download, since the product page only lists the trial version? Thanks

Thanks for your reply... I have two SQL DB servers. On my test server I connect using SA and issue a simple command such as "select top 10 post_count from users order by post_count desc". It correctly retrieves the information and shows in the chart. In my production server I try to connect with a username/password (which contains "+"). If I connect with SA it shows the database, if I connect with [username] it doesn't show anything. Note that this [username] is the owner of my main database. If I try to simply enter the database name it won't allow me to click "NEXT". If I use SA on my production server I can see the list of databases, which I can use to select the one I need. And now that I think of it, I can issue the query ""select top 10 post_count from users order by post_count desc" but I have to add the owner to the table name as in [username].[table]... So this is sorted, but... I don't want to use SA! I will probablt have to check permissions on my database... Interesting that [username] is the owner, but the database is not listed when logged in with that user.

Hello folks... I am trying to connect to a SQL DB using SQL Authentication. I can connect if I use "sa", but I can't then issue commands such as "use [dbname]; [store procedure]" or any SQL statement for that matter (the DB ownership is not sa). However when I try using a username and password the list of DB comes back empty, as if I wasn't logged in. The password contains non-alpha characters. Could this be the problem?