Viewing 15 posts - 556 through 570 (of 1,069 total)
Suriya.pn (5/17/2011)
May 17, 2011 at 10:14 pm
Additional server hardware is not necessary. You can use Publisher as the Distributor (if it can bear the load).
No logins are replicated. You have to create them yourself.
Few observations:
1) Primary...
May 17, 2011 at 10:04 pm
I would recommend replicating the (read-write) primary database.
May 16, 2011 at 4:18 am
prasad.perini (12/9/2010)
Problem:SSMS on many Windows 7 (64) computers are quite slow compared with slower XP computers with less memory. Simple query takes anywhere from 3 to 30 sec.....
Thanks Prasad...
May 10, 2011 at 10:15 pm
Single Log Reader Agent for a database irrespective of number of publications.
May 10, 2011 at 2:18 am
1) Grant CREATE DATABASE permision.
2) Recreate the login on the other server with same SID.
May 9, 2011 at 3:43 am
Open SSMS. Connect to your SSAS instance. Right clik on the SSAS instance, select Properties.
Click on Security tab, then click on Add... button to add Windows users.
You need to...
May 9, 2011 at 3:34 am
Transactional replication has option to filter the rows/columns. See whether it is sutable for your scenario.
.sch, .bcp, .pre files are created.
May 9, 2011 at 3:12 am
It looks like you are not taking log back regularly. Create a maintenance plan to take log backUP regularly.
45GB log file is NOT ideal for 7.5 data file.
I have slightly...
May 6, 2011 at 4:40 am
ninu (5/5/2011)
How do I connect to the Active directory from the report so that i can know which group the user belongs to?Any help in this regard is much appreciated.
My...
May 5, 2011 at 10:31 pm
I don't see any issue with your script. It looks fine. However, I have two suggestions:
1) Change USE myDB to USE Master.
2) You can use Maintenance Plan to take Log...
May 5, 2011 at 9:52 pm
Make sure that the SSAS service account has write permision on the path where you are trying to back up the database.
May 5, 2011 at 9:39 pm
Raghavender (5/4/2011)
TCP/IP, Named Pipes, VIA were disabled. Only Shared Memory was enabled. did you find anything difference ?
When only Shared Memory is enabled, you can connect only from local machine....
May 4, 2011 at 10:41 pm
jroberts-758537 (4/26/2011)
Are there any...
April 26, 2011 at 9:31 pm
jroberts-758537 (4/26/2011)
Is it possible to restore a .bak file from sql 2005 to a new database if the original db is no longer available?
Yes, it is possible.
It not necessary for...
April 26, 2011 at 5:03 am
Viewing 15 posts - 556 through 570 (of 1,069 total)