Viewing 15 posts - 76 through 90 (of 92 total)
ghanshyam.kundu (9/9/2011)
1) go to configuration manager and enable...
September 9, 2011 at 8:44 am
Karl-Marten Paulsen (9/8/2011)
Hi,Have a look in the "Server Properties" - "Connections", if Remote Server Connections are allowed.
Regards
Karl
Yes - "Allow remote connections to this server" is enabled. But that's good...
September 9, 2011 at 8:23 am
Perry Whittle (9/8/2011)
Does the remote server have a firewall running?Go into SQL server configuration manager on the remote server and check the protocols enabled.
In each configuration node of the configuration...
September 9, 2011 at 8:19 am
Perry Whittle (9/9/2011)
sqlguy-736318 (9/8/2011)
September 9, 2011 at 8:14 am
I guess I should ask the following general question to those with more dba experience than myself. If I set up a database with SQL Server authentication then should any...
September 8, 2011 at 8:31 pm
It seems like I may need to add the network user ID's of the other users somewhere on the remote machine so they can access the remote database through their...
September 8, 2011 at 6:42 pm
Perry Whittle (9/8/2011)
Does the remote server have a firewall running?Go into SQL server configuration manager on the remote server and check the protocols enabled.
I can connect to the remote server...
September 8, 2011 at 6:36 pm
Karl-Marten Paulsen (9/8/2011)
Hi,Have a look in the "Server Properties" - "Connections", if Remote Server Connections are allowed.
Regards
Karl
Well - I can connect from my local machine to the remote server so...
September 8, 2011 at 6:31 pm
Thanks for the responses everybody. I was able to locate the MSSQLSERVER service through services.msc.
However, the "Log On As" network user ID for the service belongs to a manager...
September 8, 2011 at 2:42 pm
dva2007 (12/6/2008)
I agree with indexing on table field which is used in the join. May be check execution plan and see table scan or index scan.
It seems like columns...
December 7, 2008 at 3:20 am
GilaMonster (12/6/2008)
sqlguy (12/6/2008)
Grant Fritchey (12/6/2008)
You mentioned that there are some types of joins that could prevent index usage. Can you give me an example of this?
CAST(Table1.Col1 AS INT) =...
December 6, 2008 at 1:23 pm
Grant Fritchey (12/6/2008)
And yes, '%y%' won't use an index. If you think about it logically, it makes sense. An index stores...
December 6, 2008 at 9:29 am
Grant Fritchey (12/6/2008)
Nah. I'll stick with getting indexing...
December 6, 2008 at 9:10 am
Grant Fritchey (12/5/2008)
sqlguy (12/5/2008)
December 5, 2008 at 5:59 pm
Grant Fritchey (12/5/2008)
The one point I'm not sure about... From your description, does this report even use a WHERE clause when accessing the information for...
December 5, 2008 at 11:24 am
Viewing 15 posts - 76 through 90 (of 92 total)