Viewing 15 posts - 256 through 270 (of 816 total)
Can you update the stats for the table and then run the index_usage?
April 6, 2011 at 3:46 am
Shrinking will not help here as your log will grow again. I will suggest two option:-
1) Read Gail article which she referred in earlier reply.
2) Reduce the frequency of your...
April 6, 2011 at 3:40 am
1) what does this command reflect for your database:-
select name,state_desc form sys.databases
2) How frequently you doing the log backup? If the interval between the log backup is high then consider...
April 6, 2011 at 1:59 am
good SQL server monitoring tool and in affordable price?
as you have raised this query in sql 2008 forum, I beleive you using sql server 2008.
So I will suggest start...
April 5, 2011 at 2:41 am
so the invalid object which I referred, does exist? Give more detail as what you doing within your package.....like from which table to which flat file(txt file or something else)
April 1, 2011 at 5:58 am
check policy and check expiration, both are different thing.
Check Policy :- When you will configure the password, it will check the policy that password mentioned is matching the policy or...
April 1, 2011 at 4:58 am
its quite hard to predict the reason without knowling your dts/ssis, but from the error, it seems like the object not exists.
Description: "Invalid object name 'teoco.IDDMOUBYV_ROUNDEDDLYTRMCAR2011-04-01-2011-04-30'
April 1, 2011 at 4:51 am
clustering is at server level and for server high availability not the database. So even if your perticualr user database failed to bring online, it doesnt mean that perticular database...
April 1, 2011 at 3:05 am
Can any one tell me how to read log file (like what transaction happened etc) in SQL SERVER.
if you have litespeed tool and you have upgraded it to 5.0...
March 29, 2011 at 4:26 am
I need to reset a sequence number every 0000hrs daily...
can you explain where exactly you have to reset the sequence?
Is this a table column or something else. Please provide...
March 28, 2011 at 4:44 am
latency is a kind of counter which give you information on how much time it take subscriber to get updated.
In your case as its transaction replication with updating subscriber...
March 28, 2011 at 3:36 am
you can have trigger which will be fired as per requirement and will do the activity as scripted.
March 28, 2011 at 3:06 am
And if you still confused, have a read of http://www.sqlservercentral.com/articles/Editorial/72825/
March 28, 2011 at 3:03 am
But it fails when I switch to SQL Authentication.
not sure if you referring this switch within DTS/SSIS.
If that is the case then for SQL server windows authentication and...
March 28, 2011 at 2:52 am
if the secondary server database is purely reporting purpose then you can consider log shipping where you will be restoring the backup(full or log) with standby option which will leave...
March 28, 2011 at 2:41 am
Viewing 15 posts - 256 through 270 (of 816 total)