Viewing 15 posts - 106 through 120 (of 232 total)
FYI
I did run the select * from sys.databases and I got :
master
tempdb
model
msdb
reportserver$mssql2k8
reportserer$mssql2k8tempdb
and of course the other databases
..
May 16, 2009 at 2:54 pm
Since you have posted this article under sql 2005 then I am assuming we are talking about this version.
Question: what is the service version installed on this server?
May 15, 2009 at 8:21 pm
Interesting; a system database that is not listed under the system databases in 2008. But, I dig it..
😎
May 15, 2009 at 11:02 am
same thing here.. was not expecting that.. this is the type of the question that normally show up in exams..:-D
you got me..:w00t:
May 15, 2009 at 9:19 am
Ouch, yes, I will have to do some testings..
I have feeling there will be a unforeseen pitfall along the path that is going to hurt.. a little I hope.
🙂
May 14, 2009 at 11:10 pm
I will definitely try that. In fact, after I used the spid I did try with several connections and seemed fine.
Shortly, I realized that this may not work as...
May 14, 2009 at 10:50 pm
Nice posting by you, very nice...
You must also consider the fact that there are "volunteers" out there that are trying to assist others and yet can not understand the clear...
May 12, 2009 at 10:47 am
I do not see any relevance here but to satisfy your curiosity;-); let say ad-hoc!!
May 12, 2009 at 10:23 am
The caller needs to get a table value PERIOD. Functions are the one that do that with the criteria and param.. that's all. but since we can not have...
May 12, 2009 at 10:10 am
Are you messing with me?.. I think we should drop this at this point.
I do not have to explain any more, but just being nice, it does not matter if...
May 12, 2009 at 9:27 am
What the business is doing with this function call is trivial; however, the concept behind calling a function with the current conditions is almost impossible and I think we might...
May 12, 2009 at 8:54 am
I thought I was very clear during the serveral reviewing and rewriting the scenario.
The reason for using the function is that the caller has to have a "select a, b,...
May 12, 2009 at 1:23 am
have fun..
and
thank you for your patience..
May 11, 2009 at 4:53 pm
Of course, this is how all my problems begun;
everything that I wanted to do was fine except when bringing all that into a function and function in sql has limitations...
May 11, 2009 at 4:51 pm
I am getting
Msg 2010, Level 16, State 1, Procedure ADV_UDF_GetEmp_ID, Line 16
Cannot perform alter on 'ADV_UDF_GetEmp_ID' because it is an incompatible object type.
Does not let me modify the function::
alter FUNCTION...
May 11, 2009 at 4:44 pm
Viewing 15 posts - 106 through 120 (of 232 total)