Viewing 15 posts - 1,096 through 1,110 (of 1,479 total)
The error message is very descriptive – you are trying to convert a string to date but the value in the string can not be converted to date. One...
March 13, 2009 at 1:36 am
The best place to do formatting is the at the presentation layer. The fact that it can be done using SQL Server doesn’t mean that it should be...
March 12, 2009 at 6:53 am
Sorry, I misunderstood the first message (although the message was very clear). You can’t do it with DML trigger, but you can create a DDL trigger and rollback the...
March 11, 2009 at 11:50 pm
Where did you get the idea that a table that has a trigger can not be dropped? Such table can be dropped with no problems. If you can’t...
March 11, 2009 at 11:18 pm
Bob Hovious (3/11/2009)
Please share with us what error you are getting, the table schema(s), and perhaps a sample of data.
The function doesn’t work with table. It works only with the...
March 11, 2009 at 3:51 pm
I have not explanation why the function causes the error message when creating this function. In my opinion it is some kind of bug. You can get around...
March 11, 2009 at 2:48 pm
If the files are called logXX.trc where XX is a number (doesn’t have to be 2 digits, but has to be an integer number), then yes. If the name...
March 11, 2009 at 1:37 pm
Do you mean how to get in one select statement the content of all the trace files? If this is what you mean then just use the default value...
March 11, 2009 at 1:18 pm
Are you using the exact same query at both times? Does the query’s result have any connection to the person that is running the query (for example - like...
March 10, 2009 at 7:47 am
Look in books on line for information about creating jobs. You can define a job and schedule it to run whenever you want.
Adi
March 10, 2009 at 2:05 am
That sounds strange. scope_identity function does exist in SQL Server 2000. Could it be that the database's compatibility level is set to an earlier version that didn't have...
March 6, 2009 at 1:00 am
Actually that is what my other option is, loading the data into a staging table. But I just don't know how to do bulk load with different number of columns...
March 5, 2009 at 11:34 pm
sajilsidharth (3/4/2009)
datatype of that field is nvarachar(2000).
when I insert the arabic text it is coming like this ??????????
can you help me
How are you trying to insert it? Are you...
March 5, 2009 at 1:13 pm
Grant Fritchey (3/3/2009)
March 5, 2009 at 1:10 pm
No this is not what I’m saying. You need to write the logic that will know what to do with each line. You can use SSIS for that....
March 5, 2009 at 1:00 pm
Viewing 15 posts - 1,096 through 1,110 (of 1,479 total)