Viewing 15 posts - 46 through 60 (of 227 total)
12 is the correct build number for 2014.
You chose a startup account for your SQL Server 2014 setup, before receiving that setup error. If you logon to the machine as...
August 8, 2016 at 10:35 pm
You can use INFORMATION_SCHEMA.COLUMNS or sys.columns to dynamically build a T-SQL statement, assign that statement to an @variable, and sp_executesql @variable
August 8, 2016 at 10:20 pm
It is not possible for a perfmon collection of a database server's counters to detect a connection issue that exists on a client that is running upon a different server....
August 8, 2016 at 7:28 am
The key to troubleshooting this problem is to understand the cause for the error message "Could not find installable ISAM", for which there is a large amount of available Support...
August 8, 2016 at 6:52 am
Afraid I do not know the criteria used to define safe or improved, but the code example looks like a basic start (as do all code examples:-)). Are there additional...
July 25, 2016 at 8:09 am
Did you restore report server's databases from another server and point your laptop's SSRS to them (via RSCM or rsconfig)? If so, you need to export the Encryption Key from...
July 25, 2016 at 7:42 am
Just below the title, to the right of "SQL Server 2016" there is an "Other Versions" link. Click that.
December 29, 2015 at 10:38 am
For your last question see 7 in https://msdn.microsoft.com/en-US/library/hh710046.aspx
Can you post your results for each step (including step 4) from that URL?
December 29, 2015 at 10:12 am
Perhaps you have a database name (the "?") that cannot be parsed.
Try
EXEC sp_MSforeachDB 'USE [?]; DBCC CHECKDB (0)
WITH NO_INFOMSGS, ALL_ERRORMSGS, EXTENDED_LOGICAL_CHECKS, DATA_PURITY'
However, it appears at least one version of...
December 29, 2015 at 9:58 am
https://msdn.microsoft.com/en-US/library/hh710046.aspx
5. Redirect the Original Publisher to the AG Listener Name
--------------------------------------------------------------------------------
At the distributor, in the distribution database, run the stored procedure sp_redirect_publisher to associate the original publisher and the published database...
December 29, 2015 at 8:57 am
The answer depends upon what resources you can offer, and what risks you are willing to take. I would prefer to create an ETL server on its own OS (with...
December 28, 2015 at 9:09 pm
That's the client. Check the server :).
December 28, 2015 at 8:29 pm
They should be different.
Removed the humor.
Do not name the cluster the same as the virtual server name. At very least, you will cause mass confusion if you did. At very...
December 28, 2015 at 2:28 pm
Hmm. All I can think of is to run Sysinternal's Process Monitor on the box while a SMO attempt is being made, to determine what file was not found
December 28, 2015 at 12:03 pm
You should use the ODBC API to request a cursor type - don't go down the "formerly-undocumented sp_cursor% call" rabbit hole:-P. But, if you are curious as to what the...
December 28, 2015 at 8:57 am
Viewing 15 posts - 46 through 60 (of 227 total)