Viewing 15 posts - 8,026 through 8,040 (of 9,253 total)
as the link details the workaround is to un install the mismatched features
April 27, 2010 at 3:26 pm
i too, use the RSS tool. Easiest way to migrate
April 27, 2010 at 3:15 pm
April 25, 2010 at 3:17 am
sqlguy-549681 (4/24/2010)
you mean i will re-write 500 DTS again !!!!!!!!!!!!!!!!!!!!!!!!!!!!
if they wont convert then yes!! Look at this way, your job should be safe for sometime 😉
April 24, 2010 at 3:58 pm
Guys, you get the message 'Current SKU is invalid' because of the licence key.
When you get to the part of node 2 install where you see the licence key, delete...
April 24, 2010 at 3:51 pm
Table\index partitioning is exactly what it says. Within this there are 2 methods of partitioning
Horizontal partitioning - rows are separated into partitions
Vertical partitioning - columns are separated out into partitions
April 24, 2010 at 3:48 pm
if the database is in Simple recovery the log will truncate on checkpoint, also the alter index is minimally logged so this should not need log file modifications
April 24, 2010 at 1:02 pm
Bhuvnesh (4/24/2010)
ORShrink the transaction log file
to effectively shrink the log file you will need to back it up first
April 24, 2010 at 10:55 am
halifaxdal (4/23/2010)
It seems the bracket is causing the problem, I took away the [], now this issue went away.Thanks for replying.
then the error wasnt network related or instance specific was...
April 24, 2010 at 9:46 am
varshachyk (4/24/2010)
on one of our server Re-build index job is failing with the below error. Please suggest.
Failed: (-1073548784) Executing the query "ALTER INDEX [PPS_USER_SESSION_COOKIE] ON [dbo].[abc] REBUILD WITH (...
April 24, 2010 at 9:29 am
striker-baba (4/23/2010)
I can back up the log. But, it is not necessary.and the database is in full recovery mode.
if the database is in full recovery model then log backups are...
April 24, 2010 at 9:20 am
Sourav-657741 (4/23/2010)
1. Can you please suggest me a suitable query to find out whether any database is in "offline" status in the SQL Server?
the following will work for sql2005 on
select...
April 24, 2010 at 7:42 am
Can you supply a little more info on the error. Check the SQL server and Windows event logs
April 24, 2010 at 7:26 am
Viewing 15 posts - 8,026 through 8,040 (of 9,253 total)