I am Brazilian and would like to know as this the market for the analyst whom he manipulates and desenolve in Sql Server/oracle... In Brazil we have as base the 2000,00 5000,00 Reals.... as this the work market ai is....em relation to the wage?
Valter Lacerda
(55)+ 11 83009925
I need Power Guys!
I need help!!!
When I try from Enterprise Manager to returns all rows from a table I received a popup with message "Unknow Error 8007007F"
I have sqlserver2000 with S.O Windows Advenced Server 2003 and when I run MDAC checker I obtain version 2.8.
odbcbcp.dll Expected version 2000.85.1022.0
oledb32.dll " " 2.80.1022.0
sqlsrv32.dll " " 2000.85.1022.0
Does anybody know what is happening??
Thanks
Hi,I need to create a partition table but the column on which I need tocreate a partition may not have any logical ranges. So while creatingor defining partition function I can not use any range.likeCREATE PARTITION FUNCTION my_part_func (NUMERIC(7)) AS RANGE LEFT FORVALUES (1,100,1000);Is there any way to define partition function in SQL Server somethinglike Oracle HASH partitions where logical range is unkown?ThanksSameer
View 5 Replies View Related
We replicate a SQL2000 database (DataBaseA) to a SQL2000 database (DataBaseB) by using the Restore function and hasn't change its logical name but only the physical data path and file name. It is running fine for a year. We use the same way to migrate the DataBaseB to a new SQL2005 server with the Restore function and the daily operation is running perfect. However, when we do the Backup of DatabaseB in the SQL2005, it just prompt the error message
System.Data.SqlClient.SqlError: The backup of full-text catalog 'DataBaseA' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)
Please note we left the DataBaseA in the old SQL2000 server.
Please help on how we can delete the Full-text catalog from DatabaseB so we can do a backup
Many Thanks