Viewing 15 posts - 1,351 through 1,365 (of 2,008 total)
smohammadnia.3840 (11/23/2011)
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot...
November 23, 2011 at 3:39 am
I've had this problem couple days ago and switching the DB from Full to Simple recovery mode and back helped for some time, but the problem reappeared.
First, you shouldn't mess-up...
November 23, 2011 at 3:16 am
_UB (11/21/2011)
This may sound like a repeated question, but I could not find a single solution that answers it all.
How to find out the amount of memory used by Sql...
November 23, 2011 at 3:11 am
I don't find any limit set by SS2K8 so it should be as many your server can handle efficiently. 😉
Maximum Capacity Specifications for SQL Server
November 23, 2011 at 2:57 am
I am sorry but there is no straight answer to this. Please go through following articles. They might help you in determining what you need.
Using Files and Filegroups to Manage...
November 23, 2011 at 2:55 am
@SqlNewJack: Are you here? Are you reading all these suggestions?
Nope. He/she is not. Last Login Friday, May 06, 2011 9:35 PM.
November 23, 2011 at 2:45 am
The second thing is – why do you have 14 different processes that are reading the log?
In addition to this question, do you have any 3rd party Monitoring tool?...
November 23, 2011 at 2:24 am
WYL (11/22/2011)
Found a couple notes on the web, most of them recommend different ip addresses for Window cluster and SQL Cluster.
e.g.
http://www.scribd.com/doc/28250844/SQL-Server-Clustering-Guide
http://www.sqlmag.com/content1/topic/set-up-a-sql-server-2008-cluster/catpath/configuration/page/2
Any pros and cons between using 2...
November 23, 2011 at 2:20 am
smohammadnia.3840 (11/23/2011)
no I can ont select the data form the openquery.
Please post your query & error message here.
November 23, 2011 at 2:09 am
It looks like permissions issue. Can you select data from linked table with query? Please post here the error message of the same.
November 23, 2011 at 1:17 am
forsqlserver (11/23/2011)
I want to do the load testing for this 10 gb MEMORY.How can I do this..
Have u some code..
There are 3rd party tools available for load testing. BTW... Load...
November 23, 2011 at 12:39 am
forsqlserver (11/23/2011)
Should I enable awe also??It is a 64 bit server.
Nope.
November 23, 2011 at 12:32 am
Chris Metzger (11/23/2011)
November 23, 2011 at 12:29 am
Klarence A. (11/23/2011)
thank you thank you... now i am able to determine which is the better approach.
Please don't jump on conclusion so fast. Bill has a valid point of 'referential...
November 23, 2011 at 12:24 am
Yes if someone is adding DB objects into it.
FYI
When a CREATE DATABASE statement is issued, the first part of the database is created by copying in the contents of the...
November 23, 2011 at 12:09 am
Viewing 15 posts - 1,351 through 1,365 (of 2,008 total)