Viewing 15 posts - 2,521 through 2,535 (of 9,725 total)
Okay, I think I've figured out part of the problem. The SQL Server 2012 Setup Files are still partially installed. There were two versions in the Programs and Features and...
July 9, 2015 at 11:13 am
BTW, you do know how to use annotations to document an SSIS package, right?
July 9, 2015 at 11:00 am
So your own process prevents you from using the full suite of SSIS tools to accomplish your task?
That seems a little excessive to me. But yes, if you can't use...
July 9, 2015 at 10:59 am
Assuming you've ensured that your test DB restore to production will never overwrite an active production db...
You can script this out into a job. It's just a simple T-SQL...
July 9, 2015 at 8:57 am
GilaMonster (7/9/2015)
Welsh Corgi (7/8/2015)
What do you consider best practices?
Designing a backup strategy that meets the company's RPO, RTO and maintenance windows.
It's all well and good for you to say 'I...
July 9, 2015 at 8:50 am
So far as I know, cluster resources can be deleted and recreated without affecting the actual physical disks. As far as the drive letters go, they are based on OS...
July 9, 2015 at 8:46 am
Does the SQL service account have permissions on the drive / folder in question?
Are the files younger or older than 4 weeks old?
Is it pointing to the correct folder?
Is the...
July 9, 2015 at 6:49 am
philosophaie (7/9/2015)
July 9, 2015 at 6:46 am
philosophaie (7/9/2015)
Error code from RD Connection Broker - Configure High Availability: "write permission to sql database"How do you create "RD Connection Broker having write permission to sql database"?
I haven't worked...
July 9, 2015 at 6:31 am
Update your package to include IF NOT EXISTS before you create the objects. That should avoid your errors.
July 9, 2015 at 6:05 am
Okay, I have done my due diligence this a.m. to post both a "worse question" and lots of "worse answers." Feel free to mock and fling porkchops as necessary.
@=)
July 9, 2015 at 5:34 am
philosophaie (7/8/2015)
http://www.connectionstrings.com/sql-server-2012/
Having trouble with myserverAddress.
What belongs there with SQL Server 2012?
DRIVER=SQL Server...
July 9, 2015 at 5:33 am
tempdb will always grow and shrink depending on what operations are accessing your different databases. This database keeps all the variables, temp tables (including table variables), and "in memory" calculations...
July 9, 2015 at 5:31 am
Viewing 15 posts - 2,521 through 2,535 (of 9,725 total)