Viewing 15 posts - 1,936 through 1,950 (of 2,840 total)
There are couple of ways to do this... But first I hope you ran the upgrade adviser on your SQL 2000 Databases that you are planning to migrate.
1. If...
May 28, 2009 at 11:47 am
I know that I am going to be kicked from several sides for this statement.... But here it is..
"There are two animals that I dislike, One is Snake and the...
May 28, 2009 at 11:39 am
Does this table have a clustered index? If not, you might see this behavior. I am not 100% sure but I have seen this happen in SQL 2000 but I...
May 28, 2009 at 9:52 am
Just a dumb question, did you by any chance update the statistics of the tables after you moved to SQL 2005? I read somewhere that you have to run the...
May 28, 2009 at 9:50 am
I have one small suggestion. I dont know if it will meet your criteria or not.
Set up a read only Transactional replication to your report server. In that transactional replication,...
May 28, 2009 at 9:03 am
Yes, you can use delete. And the delete will be propagated to the Subscriber.
PS: You can actually tell the replication agent not to propagate the delete command using some...
May 28, 2009 at 8:55 am
I see that the Operation "Kill the Parrot" is on the road... 😀
May 28, 2009 at 8:50 am
As per MSDN...
You cannot use TRUNCATE TABLE on tables that:
* Are referenced by a FOREIGN KEY constraint.
* Participate in an indexed view.
...
May 28, 2009 at 8:34 am
One thing that you could do is to write a stored proc that does the back up. Check for error, If there is error, store it in a table that...
May 28, 2009 at 8:18 am
I was thinking maybe we should ask someone who is politically correct to tell him not to be parrot.. 😀
The people who comes in mind for this job is our...
May 28, 2009 at 8:05 am
Congrats to Wayne for hitting the 5000 posts. You win the grand prize... And the grand prize is...(Drum roll)
You get to host the SSC party... 😀
BTW, the echo guy...
May 28, 2009 at 7:46 am
It is better to put -T 1204 in your start up parameters and restart SQL Engine if you can so that even if you are not there to monitor it,...
May 28, 2009 at 7:33 am
GetDate is the function to get the current date. let us say you want to find out what is was the date 10 days back, it will be getdate() -...
May 27, 2009 at 1:23 pm
You can always set up a Job in SQL Server agent that runs every day that will purge data more than 60 days old or two months old based on...
May 27, 2009 at 1:05 pm
Viewing 15 posts - 1,936 through 1,950 (of 2,840 total)