Viewing 15 posts - 706 through 720 (of 1,069 total)
Nikki-395727 (4/11/2010)
Also, which component do I need to rinstall service pack?
See this log file on the server:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
April 12, 2010 at 3:20 am
venkatreddy.bashi (4/11/2010)
We are making all changes to publisher database by loading files, Some time 2,00,000 to 3,00,000 rows going to updated/deleted/inserted on publisher database.
How many rows are there in the...
April 12, 2010 at 2:34 am
lijusmail (4/7/2010)
i wanted to know is there some SQL Setting which is limiting the number of rows being generated when a stored procedure runs.
SET ROWCOUNT can limit the number of...
April 8, 2010 at 11:28 pm
http://support.microsoft.com/kb/918992
Use EXEC sp_help_revlogin provided by Microsoft in the above link
April 8, 2010 at 4:27 am
RV-813525 (4/6/2010)
At the end of day I have to ship the logs from each of the client's database and sync to the centralized database.
Log shipping does not work like this....
April 8, 2010 at 3:28 am
arjung (4/7/2010)
Can somebody please help me about what is SSIS?Thanks,
Arjun
SSIS stands for SQL Server Integration Services.
It is an ETL (Extract-Transform-Load) tool.
You can create SSIP packages using BIDS (Business Intelligent Development...
April 8, 2010 at 3:05 am
Ratheesh.K.Nair (3/30/2010)
Thanks Suresh,Hope u meant that differential backup and full backup can be appended to the same file.
Yes.
Any (full or diff) backup can be appended to an existing backup file.
For...
March 30, 2010 at 5:48 am
Ratheesh.K.Nair (3/29/2010)
Hi Experts,Is it possible to restore latest differential backup after restoring an old full backup?
No, unless the OLD backup is base for the differential backup.
You will get following error:
This...
March 30, 2010 at 3:40 am
Ratheesh.K.Nair (3/30/2010)
Adding to aboveIs it possible to append differential backup to a full backup?
Yes. It is possible to take a backup to existing backup file.
However it is recommended to...
March 30, 2010 at 3:22 am
Sometimes backup files are moved to some other place.
For example backups are taken to local disk to reduce time and avoid network issue.
Later the backup files are move...
March 29, 2010 at 6:02 am
Congrats!
You took only one month to prepare for the exam 🙂
Regards
March 19, 2010 at 4:27 am
Reo (3/5/2010)
I have this on production server.
windows account policies are good if I'm going to create new login.
My problem is that I want to find out thoses login who...
March 9, 2010 at 2:31 am
Please post the errors you are getting.
Without seeing the error message, it is difficult to help.
Replication can be down for different reasons.
March 8, 2010 at 2:35 am
Eugoogley (2/25/2010)
We have one database which publishes to another (SQL 2005 - transactional replication). The subscriber is used by a number of applications where the publisher is only ever used...
March 2, 2010 at 2:36 am
I am not familiar with Oracle Streams.
SQL Server has features likes
1) DML/DDL triggers
2) Service Broker for asynchronous processing
3) Change Data Capture
Replication has granular control. For example, you can replicate...
March 2, 2010 at 2:29 am
Viewing 15 posts - 706 through 720 (of 1,069 total)