freitasm
-
Posts
6 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by freitasm
-
-
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?
Text output
in PowerGadgets Discussion
Posted
Thank you guys... Output to a table would work as well. I will contact you later.
Cheers