Viewing 15 posts - 1,246 through 1,260 (of 1,478 total)
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...
--------------------------------------------------------------
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/
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...
--------------------------------------------------------------
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/
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....
--------------------------------------------------------------
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/
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...
--------------------------------------------------------------
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/
January 2, 2009 at 3:49 am
If you’ll find a solution, pleas post it, so all of us will learn it.
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/
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...
--------------------------------------------------------------
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/
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...
--------------------------------------------------------------
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/
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
--------------------------------------------------------------
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/
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...
--------------------------------------------------------------
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/
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...
--------------------------------------------------------------
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/
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...
--------------------------------------------------------------
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/
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...
--------------------------------------------------------------
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/
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...
--------------------------------------------------------------
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/
December 31, 2008 at 2:39 pm
Aspet Golestanian Namagerdi (12/31/2008)
--------------------------------------------------------------
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/
December 31, 2008 at 1:57 pm
Perry Whittle (12/31/2008)
as Adi pointed out you cannot query the database in the norecovery state. Bear in mind with the standy option when log file restores occur users will 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/
December 31, 2008 at 10:11 am
Viewing 15 posts - 1,246 through 1,260 (of 1,478 total)