Viewing 15 posts - 1,126 through 1,140 (of 1,479 total)
I also enjoyed the fact that there was another answer that was the same as mine and came almost at the same time that my answer came. It feels...
February 22, 2009 at 7:34 am
You can do it char(1) with check constraint that will limit the values to M or F. BOL has some examples on how to define check constraint (look for...
February 22, 2009 at 6:38 am
Sorry, I don’t realy know how to get the second recordset using SQL Script. If no one will be able to offer you a way to do it, you...
February 22, 2009 at 5:36 am
The data type that fn_get_sql returns is text. This data type has some restrictions. One of the restrictions is that it can not be used in correlated sub query....
February 22, 2009 at 3:53 am
If you want to check a login, you can run sp_helplogins stored procedure. It will show you (among other things) the mapping users that the login has in all...
February 22, 2009 at 3:30 am
I don’t think that you can pass a column from a query as a parameter to fn_get_sql function. I think that you have to get the sql_handle to a...
February 22, 2009 at 3:25 am
Yes you can. You can setup trust relations between both domains. Take a look at this KB article for more details - http://support.microsoft.com/kb/321247
Adi
February 22, 2009 at 2:35 am
I have to admit that I didn’t understand the part about your application, but there are few remarks about your log file. First of all stop shrinking it. ...
February 18, 2009 at 10:49 pm
It sounds like after you are writing the script with CREATE TRIGGER statement, you are using the menu or the tool bar to do save operation. This operation just...
February 18, 2009 at 10:34 pm
If I remember correctly, SQL Server did support left and right join using the old syntax (*= or =*), but it didn’t support full outer join using the old syntax.
Adi
February 18, 2009 at 1:32 pm
htilburgs (2/18/2009)
Ok..... I didn't understood the first reply from Adi.I've tested and now I've got a good result, but.....
All you had to do as ask for clarifications:-)
Can it be, that...
February 18, 2009 at 1:25 pm
If you'll show us the code that you are using and explain what you are getting, you'll have a much better chance to get help.
Adi
February 18, 2009 at 12:43 pm
Michael Valentine Jones (2/18/2009)
jgrubb (2/18/2009)
I just ran the following code on SQL Server 6.5 and it worked fine:
I have to admit that I’m amazed that you have SQL Server 6.5...
February 18, 2009 at 12:32 pm
With windows authentication you don’t pass your credentials at all. SQL Server gets you credentials from the OS. In order to solve your problem you can try to...
February 17, 2009 at 10:42 pm
Viewing 15 posts - 1,126 through 1,140 (of 1,479 total)