Viewing 15 posts - 211 through 225 (of 1,166 total)
You can replicate views to table...
or you can use a query too to replicate to table...
Check the BOL topic "Publishing Data and Database Objects " and "Filtering Published Data"
March 1, 2007 at 10:27 pm
How come checkdb returns no errors when you said you can't access the data and has corruption...
Only best option would be either bcp or dts...
March 1, 2007 at 10:10 pm
Did you enable the remote connections in SAC? If not enable first...
I believe in Express it is disabled by default..
March 1, 2007 at 6:04 pm
Interesting... thanks for sharing your experience...
Drop an email to MS guys to look at it or to file a bug...
February 28, 2007 at 5:48 pm
You don't need to create one table for each server...
One of these three tables will have machine name in it...I believe you have to filter based on machine name when...
February 28, 2007 at 5:36 pm
Try to open C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC file... if you get the error,
Try rename "SQL Server Enterprise Manager.MSC to "SQL Server Enterprise Manager1.MSC" and then copy the same...
February 28, 2007 at 5:27 pm
No,
You can run the ALTER DATABASE TEMPDB script but it will not take effect until you restart sql server because tempdb recreated every time you restart sql.
Note: Don't use...
February 28, 2007 at 5:19 pm
Run the DBCC CHECKDB first before doing anything to see what kind of corruption you have and how deep it is...
February 28, 2007 at 3:48 pm
Any other error in SQL error log related to this bakcup failure?
Final option will be call PSS...
February 28, 2007 at 3:45 pm
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG check summary.txt file and "Files" folder too...
February 28, 2007 at 3:36 pm
start SQL Server in mimimal configuration mode by using the (-f) startup parameter in command window
and move the tempdb database to a valid location.
See BOL topic "minimal configuration" how start...
February 28, 2007 at 3:26 pm
I think there is no MSDN version...Are you talking about MSDE 2000 or EXPRESS edition 2005...
Upgrade from MSDE 2000 to Express 2005
http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx
Upgrade from Express 2005 to WorkGroup/Standard 2005
February 28, 2007 at 3:07 pm
I don't think there is any difference between 32 bit and 64 bit...
Read the following which may help you in this...
February 28, 2007 at 2:41 pm
It is confused error, it could be the file path is incorrect or osql.exe path is not set...
Are you passing the right path of the file to OSQL when it...
February 28, 2007 at 2:35 pm
Take a look..
What sql build you are on?
Apply latest sevice pack sp4
February 27, 2007 at 11:36 pm
Viewing 15 posts - 211 through 225 (of 1,166 total)