Viewing 15 posts - 5,131 through 5,145 (of 7,429 total)
For B I am not sure that would be a yes. It depends on the columns affected. If there is no free space and the column from a clustered index...
July 24, 2002 at 6:58 am
Not sure but what message do you get when you try to install or does it just not give you the option? I have never had any issues with the...
July 22, 2002 at 6:39 am
Then for my previous message where I suggested having a newsletter to product mapping table add a country field should allow you to get that as well.
"Don't roll your eyes...
July 22, 2002 at 6:36 am
If you want to overwirte the previous backup then use.
backup database <databasename>
to disk = 'filename'
WITH FORMAT
"Don't roll your eyes at me. I will tape them in place." (Teacher...
July 22, 2002 at 6:26 am
You can write output to another table when trigger is fired as a means to know when or you can look for in Profiler in SQL items where you can...
July 22, 2002 at 5:57 am
Not sure, but try. If not then you can reference the name of the user in the object creation to put under them.
Ex.
CREATE TABLE username.tblname
"Don't roll your eyes at me....
July 22, 2002 at 5:52 am
Don't think so. Can you give an example in detail of what you need so I am sure I didn't miss something here.
"Don't roll your eyes at me. I will...
July 21, 2002 at 1:51 pm
Try just GETDATE() and see if it works. If so then your problem may be the fact you are trying to change the dateformat and it is not being recongnized....
July 21, 2002 at 10:18 am
Best in my opinion is to create a Role ofor the msdb database and set it with SELECT rights on those 2 tables. Then you can add and remove users...
July 19, 2002 at 5:47 pm
This is handled by the default language. Set the server and the users to British as that is the dateformat for British.
From BOL how to set server default
July 19, 2002 at 5:43 pm
Try reinstalling MDAC. If that does not work then reinstall the AS Manager.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 19, 2002 at 5:35 pm
Print does not work in triggers as it does not return to the user interface. To handle this look at using RAISERROR.
Ex.
Replace
PRINT 'PRINT THIS'
with
RAISERROR ('Error Message', 11, -1)
"Don't roll your...
July 19, 2002 at 5:32 pm
OK try this.
--Change--
Dim s As Integer
Try
s = objCommand.ExecuteNonQuery()
Catch ex As SqlException
OutError.InnerHtml = "Errore " & ex.Message & " " & ex.Source
End Try
--to--
Dim s As Integer
Try
s = objCommand.ExecuteNonQuery()
Catch ex As SqlException
Dim...
July 19, 2002 at 5:28 pm
Does sequence have more than one match between tabe1 and table 2. If so then you will only get one record unless another field has a match of some kind.
"Don't...
July 19, 2002 at 5:11 pm
quote:
IF @@transcount>0 COMMIT TRANS
Is unneeded since we have reached the end of processing and thus...
July 19, 2002 at 4:54 pm
Viewing 15 posts - 5,131 through 5,145 (of 7,429 total)