Viewing 15 posts - 2,986 through 3,000 (of 7,164 total)
I would venture a guess that a difference in SMO for 2012 is the source of the trouble. Have you changed any of the standard scripting options in SSMS 2012?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 1, 2012 at 4:12 pm
It's probably because you have a lot of data in the table. If you haven't been cleaning the backup history and you have done a lot of backups since msdb...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 1, 2012 at 3:55 pm
And make sure UDP port 1434 is open from your workstations to your server (check Windows firewall settings and other network firewalls).
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 1, 2012 at 2:33 pm
BOL is the primary resource but here is a series worth having a look at as well:
http://www.mssqltips.com/sqlservertip/2575/getting-started-with-sql-server-2012-data-quality-services--part-1/%5B/url%5D
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 1, 2012 at 2:28 pm
vijayarani87.s (10/1/2012)
I would like to know about, for what purpose we are using powershell.
Three properties of a given task that compel me to use PowerShell or another managed programming language...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 1, 2012 at 2:24 pm
ananda.murugesan (10/1/2012)
opc.three (9/27/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 1, 2012 at 9:13 am
Konuri Dinesh (9/28/2012)
not for log shipping and replication. i need to use that database
Is the requirement is to be taken literally? Say you have 40 instances named as Instance1 through...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 29, 2012 at 6:46 am
Steve Hendricks (9/28/2012)
...by the fact that you need to be local to the SQL Server when accessing the file system, which a CREATE DATABASE would require implicitly.
Not exactly. Yes, creating...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 28, 2012 at 8:48 pm
Jeff Moden (9/27/2012)
opc.three (9/27/2012)
Jeff Moden (9/27/2012)
opc.three (9/27/2012)
Jeff Moden (9/27/2012)
opc.three (9/26/2012)
Jeff Moden (9/26/2012)
opc.three (9/25/2012)
sanjuv999 (9/25/2012)
please guide me
Do not enable xp_cmdshell! You do not need it for this scenario and it introduces...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 28, 2012 at 11:57 am
Ola's solution does not do that. Honestly you do not want anything automatically creating missing indexes. If you're referring to what's in the DMV or what the Database Tuning Advisor...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 28, 2012 at 11:08 am
Konuri Dinesh (9/28/2012)
actual requirement is automatic but it is helpful to me ,if you can tell both ways
Well I already gave you two ways you could achieve the creation of...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 28, 2012 at 10:58 am
The more work you can lift off those outermost views the better. That's what I mean by materializing the inner views. Views referencing views that reference base tables are bad...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 28, 2012 at 10:49 am
What is the upper bound of your data set size? Sounds like you're in .NET too. Client-side paging with sorting really is best done in memory in the presentation-tier (or...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 28, 2012 at 10:26 am
SD1999 (9/28/2012)
We’ll have 10-20 people per group with same read only permission for all dbs.
In some cases, permissions for some members of the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 28, 2012 at 9:29 am
EdVassie (9/28/2012)
There is also the risk of people being added to an AD group and inadvertently being granted access to data they should not have access to.
Security best practice is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 28, 2012 at 9:08 am
Viewing 15 posts - 2,986 through 3,000 (of 7,164 total)