Viewing 15 posts - 781 through 795 (of 1,179 total)
you can get those information from the backup of msdb database. But restore msdb into test environment and get the required information.
February 23, 2010 at 4:05 am
Try second suggestions....
export it to xls and delete a few rows and improt it again with different table and see if it works.
February 22, 2010 at 5:39 am
With HTTP you can do entry to your database.
Once Data will be in Database you can use any type of replication as per your business needs.
HTH
February 22, 2010 at 5:06 am
I guess it would be good to get intouch with Microsoft Sales/Marketing people to have exact clarity with respect to your environment and what Microsoft is offering.
February 22, 2010 at 3:17 am
Yes, Inplace upgrade is not possible in your scenario.
But you can go with side by side upgrade or as mentioned by Steve do unistall/reinstall...
In side by side upgrade you will...
February 22, 2010 at 2:58 am
If you do have free sapce in the datafile than you can shrink file else you have to purge some of the data with concent with the client.
February 22, 2010 at 2:40 am
Can you check data type and data in the columns you are moving.
Also try with the other xls with very few data.
Also do one more experiment like export a small...
February 22, 2010 at 2:28 am
Me too... went wrong and lost the point 🙁
The term used in question is SSRS which is not used for the SQL Server 2000 and the reference is given for...
February 15, 2010 at 5:14 am
There is no price difference for 32 bit Vs 64 bit for SQL Server so better go with 64 bit.
February 11, 2010 at 3:49 am
I guess it's purely depend on the application you are hosting on the database, database structure, table structure etc....
I prefer you do more performance R&D by setting various fill factors...
February 11, 2010 at 3:46 am
February 11, 2010 at 3:26 am
Above DBCC displays the status of all trace flags that are currently enabled.
February 10, 2010 at 5:32 am
Hello Adi,
Your explanation is very much correct and I guess it's with respect to non clustered index. What about clustered index?
Have a nice day!
February 8, 2010 at 3:35 am
Yes, sometime poor maintenance of the database is also result into similar scenario.
February 8, 2010 at 3:31 am
Viewing 15 posts - 781 through 795 (of 1,179 total)