Viewing 15 posts - 31 through 45 (of 108 total)
GRANT SELECT ON <TABLENAME> TO <USERNAME> would work.
If you are creating multiple people that will have the same permissions you can setup a database role with those permissions. That...
October 8, 2009 at 7:45 am
There is another post that has asked the same question with some good answers. That is a broad question to explain in a forum. Are you talking about...
October 8, 2009 at 7:43 am
You need to check out a few different things.
1. Make sure your SQL Servers can connect to each other through the firewall. You should be able to telnet...
September 3, 2009 at 7:45 am
Checking with network guys might be a good idea. That IP address could be used as a NAT address and if so, I don't think those show up with...
August 5, 2009 at 10:06 am
Have you tried doing an nslookup on the ipaddress for your new instance? If you are getting an error saying IP is in use, that should tell you what...
August 5, 2009 at 7:52 am
port number is 1433 by default for a default instance of SQL Server. If you install a named instance, it will grab a different port number by default. ...
July 30, 2009 at 8:25 am
Are you asking for help with an attitude like that?
July 10, 2009 at 7:56 am
I would either download a trial version of litespeed, or restore it as a separate database on your server with Litespeed and then take a native backup and copy down...
June 15, 2009 at 8:58 am
Is it possible to clear your cache before running each test?
dbcc freeproccache, and dbcc dropcleanbuffers
September 19, 2008 at 7:50 am
Gail is right, you shouldn't need client tools on server. If it is a must have, you should be able to install only MGMT Studio by running the install...
September 19, 2008 at 7:45 am
If you are using SQL Server 2005 or 2008 you can take advantage of the Row_number function. If you are in 2000, you can use an identity column
August 18, 2008 at 8:06 am
It sounds like this might be a configuration issue and not an issue with Oracle.
When you run SQL Server, it is usually a good idea to set a cap for...
July 2, 2008 at 12:31 pm
Sounds like you might not have memory allocated correctly.
What kind of hardware do you have? 32 bit, 64bit, are you using AWE, what is the min/max server memory setting.
July 1, 2008 at 9:54 am
Sorry for the delay in response.
The reason I asked about the SP4 update is that when I have connected to 10g with SQL Server before it was 2000 SP4.
Are...
July 1, 2008 at 8:20 am
Viewing 15 posts - 31 through 45 (of 108 total)