Viewing 15 posts - 1,246 through 1,260 (of 1,479 total)
AV is Anti Virus. I’ve noticed that you wrote your message in the SQL Server 2000 forum. SQL Server 2000 doesn’t have DBMail. Instead it has SQL...
January 4, 2009 at 1:40 am
I assume that your application is running on a different server/work station then the one that your SQL Server is installed on. Do you have BCP utility on that...
January 2, 2009 at 1:24 pm
That depends. If it is really in the middle of restore operation, then you will just have to wait until the restore operation is over. If on the...
January 2, 2009 at 1:16 pm
Pleas read about create function statement in Books On Line. You have to decide if you want to create an in-line table valued function or multi-statement table valued function....
January 2, 2009 at 4:17 am
venki.ffcl (1/2/2009)
dear friends,Can i use if condition in function ?
Please give me a example
thank you
Why not check books on line for such a question? The first example of create...
January 2, 2009 at 3:49 am
If you’ll find a solution, pleas post it, so all of us will learn it.
Adi
January 2, 2009 at 3:43 am
Unfortunately I wasn’t able to import the file and got the same error that you got. I played with it a bit, but no matter what I tried, it...
January 2, 2009 at 3:14 am
Timestamp is a data type that has noting to do with neither time nor date (and of course nothing to do with stamps?). Time stamp is a binary value...
January 2, 2009 at 2:14 am
The bulk provider was intreduced in SQL Server 2005. You can't work with it if you use SQL Server 2000.
Adi
January 2, 2009 at 1:49 am
When you use function in the where clause on the column, the server can’t use any index that was created on that column. Although the queries that were...
January 2, 2009 at 1:45 am
It can't be done. You can restore a database that was backed up with SQL Server 2000 on SQL Server 2005, but you can't do it the other way...
January 1, 2009 at 9:17 am
You can use dbcc shrinkfile instead of dbcc shrinkdb. This enables you to select the file that you want to shrink and set the new size. The question...
January 1, 2009 at 1:29 am
I don’t think that you can filter dbcc log command (unless there is a third parameter that can be used and I’m not aware about). If you do want...
December 31, 2008 at 11:45 pm
Another one is managing transaction the wrong way. Specifying begin tran and commit tran only thinking that if there will be an error, it will automatically roll back the...
December 31, 2008 at 2:39 pm
Aspet Golestanian Namagerdi (12/31/2008)
December 31, 2008 at 1:57 pm
Viewing 15 posts - 1,246 through 1,260 (of 1,479 total)