Viewing 15 posts - 451 through 465 (of 1,479 total)
I know that this is a long shot but if the database is case sensitive, then objects’ names (including your procedure’s name) are also case sensitive.
Adi
September 6, 2011 at 8:30 am
I think that this is because you are using the option KEY_SOURCE. If you use this option, then you get the same key. The certificates on each database...
August 31, 2011 at 8:48 am
Pleas fallow the URL at my signature to see how to post questions. See the code and the remarks in the code for an answer for your question.
--Creating the...
August 29, 2011 at 3:53 am
You can specify your own order. For example in the fallowing query you’ll see all the sales from the U.S first and after those records you’ll see all the...
August 29, 2011 at 3:40 am
First of all thank you very much for the detailed post. I appreciate the time and effort that you spent in helping me understand your solution. Your explanation...
August 25, 2011 at 7:30 am
This is very impressive, but there is one thing that I don’t understand. I would expect that the second nodes operator will get the path Product/Authors/Author because the...
August 25, 2011 at 4:41 am
August 25, 2011 at 4:03 am
Adi Cohn-120898 (8/23/2011)
You can use the substring function to do that. You can find more details about this function in BOL (Books On Line).Adi
Sorry, didn't notice that it...
August 24, 2011 at 12:51 am
You can use the substring function to do that. You can find more details about this function in BOL (Books On Line).
Adi
August 23, 2011 at 2:18 am
Backup log with truncate_only is not supported with SQL Server 2008. I have to say that I wouldn’t run this script on other versions that still support the truncate_only...
August 22, 2011 at 9:59 am
ChrisM@Work (8/22/2011)
Adi Cohn-120898 (8/22/2011)
The book is wrong...
Quote from BOL, SQL server 2k8:
nchar [ ( n ) ]
Fixed-length Unicode character data of n characters. n must be a value from...
August 22, 2011 at 4:43 am
The book is wrong. The number that is used when you declare a variable or define a column that is a Unicode, specifies the number of characters and not...
August 22, 2011 at 4:32 am
Jayanth_Kurup (8/22/2011)
Execute the rollback statement a few times until you get a messageThe ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
Actually this will produce 2 errors. When...
August 22, 2011 at 4:21 am
You didn’t specify what you are trying to do, so maybe there is a better way. In any case if you’ll run what ever you need to run...
July 28, 2011 at 9:19 am
It seems that you need to learn more about log management, recovery models and log backups. After you’ll understand those topics, you’ll be able to configure and manage...
July 25, 2011 at 4:01 am
Viewing 15 posts - 451 through 465 (of 1,479 total)