Hello, Is it possible to set SQL 2005 to listen to two ports on the same IP address, or do I need to add an IP address to connect on the alternate...
So, has anyone seen any information where someone has tried to install SQl 2000 on Vista? I am also wondering if it could possibly work.
No problems. I just thought this is something I may want to do from time to time with different databases and I was surprised with so may good SQL...
I used this batch file for now: http://whatis.techtarget.com/tip/1,289483,sid8_gci808623,00.html?bucket=ETA But, if anyone knows of any good 3rd...
Is there any software out there that can calculate the size of each table and tell me which tables are using the most disk space?
quote:Originally posted by Adriaan You will always have a server administrator, who will have full access to all databases - that goes with the job....
quote:Originally posted by Adriaan Check Books Online for "application roles". It doesn't look like application roles can restrict access from a...
I was told that applications will not be able to access a particular database, even if the "sa" login is used. Is this possible?
I was told that a database that I sometimes work with is going to be "locked down" so that special permission is needed to access it (only supported...
Yes, but there are multiple bit values in the result set. All may be false for one of the columns, but I still need the results for the rest of the...
I don't know if there are rows with BitColumn = 1. If the result comes back 0, then all of them were 0. If the result comes back as 1, then at least...
I am not sure what you are getting at, but the query is working perfectly for me. I have tested every possible combination, and it is giving me the...
It's a table that holds flags indicating whether to perform a certain action. That is exactly what I want. I want to know if any row has a 1 on the...
That may work in some scenarios, but not in this one. Anyway, converting inside of the aggregate function works. MAX(CAST(tbl.Bitfield As tinyint))...
Actually, I think I found the answer here: http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=2290 I assumed converting inside of the min...
I never said bit was not a valid data type. I am not grouping by any of the bit fields, but I need to include them in the result set. Of course, I...
I have a table where I need to group by a field, and some of the columns are defined as a bit. What is the best way to handle this situation, or am I...
That's how I started doing it, but I was hoping it would only be temporary... I guess there's no other way.
I was playing with some code found here: http://www.sommarskog.se/arrays-in-sql.html Particularly this function: CREATE FUNCTION...
It seems like I may have found my answer: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_7zas.asp
Separate names with a comma.
