Viewing 15 posts - 256 through 270 (of 812 total)
Can you update the stats for the table and then run the index_usage?
----------
Ashish
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...
----------
Ashish
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...
----------
Ashish
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...
----------
Ashish
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)
----------
Ashish
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...
----------
Ashish
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'
----------
Ashish
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...
----------
Ashish
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...
----------
Ashish
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...
----------
Ashish
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...
----------
Ashish
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.
----------
Ashish
March 28, 2011 at 3:06 am
And if you still confused, have a read of http://www.sqlservercentral.com/articles/Editorial/72825/
----------
Ashish
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...
----------
Ashish
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...
----------
Ashish
March 28, 2011 at 2:41 am
Viewing 15 posts - 256 through 270 (of 812 total)