Viewing 15 posts - 76 through 90 (of 1,068 total)
How many indexes are there in the table?
Why do you want to delete all the indexes?
Why do you want to delete the primary key as well?
I believe second one would...
September 13, 2012 at 10:25 pm
This is a nonclustered index. You can drop the index first.
Hope you have good backup, in case required.
September 12, 2012 at 4:58 am
Yes. Log file of subscriber can be shrinked.
It should not have any impact on replication.
September 12, 2012 at 3:18 am
Shrink the log file to appropriate size using DBCC SHRINKFILE command.
September 12, 2012 at 12:24 am
You can change the database recovery model to "Simple".
I believe now the database is in "Full" recovery model.
September 11, 2012 at 4:57 am
No. Don't do detach/attach. It's not a good practice.
Are you taking the log backup regularly?
September 10, 2012 at 3:36 am
Sapen (9/4/2012)
...In my scenario what can you think will be a best column that I can have the primary key on.Thanks for your inputs in advance.
By default primary key creates...
September 4, 2012 at 5:59 am
Are the RAM, temp db and disk configurations same?
September 3, 2012 at 11:56 pm
zahid_7777 (8/10/2012)
Actually I don't know. How to know this and change the configuration.
Backup and restore are very serious activites. You need to lear it thorouly, practice and become comfortable in...
September 3, 2012 at 10:05 am
whizkidgps (8/30/2012)
Do you want me to truncate the LOG file after restoring DB into new environment?
Yes.
or Can we take the DB backup after truncating LOG file from Source DB...
August 30, 2012 at 11:51 pm
whizkidgps (8/30/2012)
... can we restore DB without restoring LOG file?
No. DB cannot be restored without LOG file.
Restored database would be just like the backedup DB. You can only move the...
August 30, 2012 at 11:34 pm
Backup-Restore.
Transaction replication has option called initialize from backup.
August 29, 2012 at 11:51 pm
SQLSACT (8/29/2012)
How do iIcreate the Logins with the same SID?Is there a process for this?
You can use SID option in CREATE LOGIN statement (see BOL for more details).
You can get...
August 29, 2012 at 2:51 am
Try this (untested):
select * into #t
from table1
delete a
from #t a
inner join table2 b
on b.number = a.NEW_NUMBER
update a
set a.Flag = 0
from table1 a
inner join #t t
on t.NEW_NUMBER = b.NEW_NUMBER
inner join table2...
August 29, 2012 at 1:51 am
You need to write two update statements.
August 29, 2012 at 1:34 am
Viewing 15 posts - 76 through 90 (of 1,068 total)