Viewing 15 posts - 2,986 through 3,000 (of 7,168 total)
I guess you are not using SSIS Package Configurations to store Connection Manager info. If you are you can simply change the config files and the code will not need...
October 1, 2012 at 4:35 pm
stillconfused (9/28/2012)
well if any DTS packages are there in 2000 then what are the possibilities of moving them..I have never done that before so need some suggestions.
The simplest way in...
October 1, 2012 at 4:28 pm
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?
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...
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).
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
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...
October 1, 2012 at 2:24 pm
ananda.murugesan (10/1/2012)
opc.three (9/27/2012)
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...
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...
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...
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...
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...
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...
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...
September 28, 2012 at 10:26 am
Viewing 15 posts - 2,986 through 3,000 (of 7,168 total)