Viewing 15 posts - 46 through 60 (of 315 total)
eemmmhhh....
True.. We had this situation earlier. I am still argueing myself with the following options:
1. My optoin.
2. Shas3's option
I am somehow not feeling comfortable to transfer control back to...
October 31, 2003 at 5:30 am
No I cannot deny because this user needs READONLY access to the tables all the time.
October 23, 2003 at 1:26 pm
I am sorry for the delay in replying... But I have implemented Andy's suggestion of having an additoinal role and adding to this role based on time thru job.
Thanks Again...
October 23, 2003 at 8:04 am
Just checked this thread... I have sent an email to webmaster@sqlservercentral.com as well. I thought I am alone on this.
Anyone has any idea how long this will take to get...
October 16, 2003 at 12:40 pm
Try Refreshing that view by selecting refresh after right clicking.
Or you can try the following from QA: This will shirnk it to 10 MB.
BACKUP LOG DBNAME WITH TRUNCATE_ONLY
go
DBCC SHRINKFILE (DBNAME_Log,...
September 23, 2003 at 4:59 pm
I have one development box running the same. No issues. Infact I have installed this last week. I have installed 7.0 as default to D:\MSSQL7\, then SQL Server 2000 Names...
September 23, 2003 at 4:55 pm
Thanks Len. But in SQL Server 6.5, we don't have query option. I am trying from a client which has SQL 2000 BCP utility.
September 23, 2003 at 10:48 am
Can you check which time zone is your new server in compated to other servers?
Just a thought!!!
September 23, 2003 at 7:39 am
I got similar error earlier. But I screwed-up in my first trail.
So I logged into the box with service account and setup the mail profile. Then changed the Startup account....
September 17, 2003 at 5:45 pm
Yes. You should have Local Admin Access on the BOX.
September 17, 2003 at 5:39 pm
I would think you can achieve this efficiently by simplifying the process.
Log Shipping is more easier and less complicated than Replication.
Again sync-up of scripts can easily be done with some...
September 12, 2003 at 12:29 am
Yes. Its much easier with DTS Transfer login Task. The only bottleneck would be : both the servers had to be up and running while doing this.
September 12, 2003 at 12:19 am
andoi : Thats the same option I choose (as I mentioned earlier) to increase performance significantly.
Vladan: Thanks for your input. I'll keep your suggestion (RAID 1 0 & Memory)...
September 12, 2003 at 12:11 am
How are you starting your SQL Server Service? Is it a Domain Account? Or a local system account?
Just a thought... Might have been an issue with this. I tried this...
September 11, 2003 at 4:44 pm
Viewing 15 posts - 46 through 60 (of 315 total)