Viewing 15 posts - 841 through 855 (of 1,179 total)
If database is not production. You can also use backup and restore with move option.
September 25, 2009 at 2:06 am
If I am not worng the txt file which you are talking about is the log files of the jobs. Now you can set the retention period for this history...
September 21, 2009 at 4:56 am
yes Ratheesh,
When every you set up a replication it will create the jobs automatically which is called depend on the type of replication you are setting up. e.g. for Logreader...
September 17, 2009 at 5:52 am
what is the database size?
What is the database recovery model?
Howmuch freespace is there in database as well as on disk?
what is the size of tempdb?
Looks like this is a space...
September 17, 2009 at 1:14 am
If I am not wrong in India at present you can ask around 20% more on the currnet salary.
But still Depend on Company, requirement, roles & responsibilities etc....
September 17, 2009 at 12:58 am
If your environment is very huge and company can afford you can use MOM, redgate etc. third party tool to monitor your daily activity as well as much more other...
September 17, 2009 at 12:03 am
You can also think about SSIS.
September 16, 2009 at 1:18 am
First of all if it's not production you can run reindexing on the database.
Than run checktable command if you still have errors you can use repair option to fix the...
September 16, 2009 at 1:08 am
You have not mention which sql server enterprise edition are you installing.... 2000,2005, or 2008?
You are getting correct error "Hardware compatability".
sql 2005 EE do not support winxp refer link below:
http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx
HTH
September 15, 2009 at 3:04 am
Try to start sql server into minimal mode and then fix the issue.
Moveing Model database is very simple.
First of all stop sql server agent
Second, Detach and attach (after copying mdf...
September 15, 2009 at 1:32 am
I have parse the query in the query analyzer and got the following error:
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'SETS'.
September 15, 2009 at 1:13 am
September 14, 2009 at 5:56 am
Viewing 15 posts - 841 through 855 (of 1,179 total)