Viewing 15 posts - 1,096 through 1,110 (of 1,478 total)
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2009 at 1:13 pm
Grant Fritchey (3/3/2009)
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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....
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2009 at 1:00 pm
Sp_help TableName gives you lots of information about the table, and this information includes data about the indexes. If you only want to see information about the indexes then...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 4, 2009 at 10:34 pm
Viewing 15 posts - 1,096 through 1,110 (of 1,478 total)