Viewing 15 posts - 931 through 945 (of 6,105 total)
Grantor is simply who granted the permissions to the grantee. You can change this by revoking the permissions and regranting it.
Do the SIDs match up for intake on the...
August 14, 2008 at 9:36 am
If all else fails, interact with your admins to modify the hosts file on each system. It's located at:
%systemroot%\system32\drivers\etc
You can put in entries for each server participating, for instance, all...
August 14, 2008 at 9:19 am
SQL Server Management Studio will do the scripting but it's geared towards objects. There's also Scriptio, but it too is more geared towards objects:
Then there are the...
August 14, 2008 at 9:15 am
This is not a question that can easily be answered on the forums. But in general:
- You are most likely going to have to increase size. That's probably not avoidable....
August 14, 2008 at 9:08 am
We permit traces in development, but not in QA. Our developers have no more rights in QA than they do in production. This prevents QA from becoming a second development...
August 14, 2008 at 9:02 am
This is why I shouldn't reply to posts on 2 hours sleep. Gail's right. Not bytes and GB but MB and TB.
August 14, 2008 at 4:46 am
bodhilove (8/14/2008)
why is the max set so high as a default (2147483647 MB)? If I am getting paging problem would that be because this is too high?
It's actually the server...
August 14, 2008 at 4:27 am
Wilfred van Dijk (8/14/2008)
OK, enough. NT 4 was a product of the 90's. Stop searching for an answer, upgrade your...
August 14, 2008 at 4:19 am
Is the disk full? Also, is the error occuring on the application server or the SQL Server?
August 14, 2008 at 4:14 am
Your DHCP should be providing a domain suffix if it's setup right. This is standard and was standard back in the 90s. I know you indicated you're still on an...
August 14, 2008 at 4:13 am
Shame-less self promotion since trigger behavior has changed only slightly between 2000 and 2005:
Triggers in SQL Server 7.0 and 2000 - The Common Ground[/url]
August 14, 2008 at 1:41 am
That is correct. If the web server is on the same server as SQL Server then the only protocol that needs to be enabled is Shared Memory. If you have...
August 14, 2008 at 1:36 am
Re-instituting the logins portion (getting access to the SQL Server itself) is fairly straight-forward:
How to transfer the logins and the passwords between instances of SQL Server 2005[/url]
However, permissions within the...
August 14, 2008 at 1:23 am
SK (8/13/2008)
August 13, 2008 at 1:51 pm
Larry Johnson (8/13/2008)
I can think of a lot better ways to spend $5000 than on a week of partying and networking in Seattle -- oh, and drinking great...
August 13, 2008 at 1:00 pm
Viewing 15 posts - 931 through 945 (of 6,105 total)